[pal-cvs 2782] [527] added generated identity

svnno****@sourc***** svnno****@sourc*****
2007年 9月 3日 (月) 16:48:38 JST


Revision: 527
          http://svn.sourceforge.jp/cgi-bin/viewcvs.cgi?root=pal&view=rev&rev=527
Author:   shinsuke
Date:     2007-09-03 16:48:37 +0900 (Mon, 03 Sep 2007)

Log Message:
-----------
added generated identity

Modified Paths:
--------------
    pompei/portlets/pompei-core/trunk/src/main/config/pompei.clay
    pompei/portlets/pompei-core/trunk/src/main/webapp/WEB-INF/db/create_table.sql


-------------- next part --------------
Modified: pompei/portlets/pompei-core/trunk/src/main/config/pompei.clay
===================================================================
--- pompei/portlets/pompei-core/trunk/src/main/config/pompei.clay	2007-09-03 06:43:34 UTC (rev 526)
+++ pompei/portlets/pompei-core/trunk/src/main/config/pompei.clay	2007-09-03 07:48:37 UTC (rev 527)
@@ -158,7 +158,7 @@
 <table-description></table-description>
 <table-figure-bounds height="-1" width="-1" x="29" y="1842"/>
 <column-list>
-<column alias="" auto-increment="false" column-size="10" decimal-digits="0" default-value="" mandatory="true" name="ADDRESS_FORMAT_ID" remarks="">
+<column alias="" auto-increment="false" column-size="0" decimal-digits="0" default-value="AUTOINCREMENT: start 1 increment 1" mandatory="true" name="ADDRESS_FORMAT_ID" remarks="">
 <column-description></column-description>
 <data-type jdbc-type="4" name="INTEGER" selected-variant-pattern="INTEGER">
 <variant type-name-pattern="INTEGER"/>
@@ -194,7 +194,7 @@
 <table-description></table-description>
 <table-figure-bounds height="-1" width="-1" x="42" y="3829"/>
 <column-list>
-<column alias="" auto-increment="false" column-size="10" decimal-digits="0" default-value="" mandatory="true" name="BANNERS_ID" remarks="">
+<column alias="" auto-increment="false" column-size="0" decimal-digits="0" default-value="AUTOINCREMENT: start 1 increment 1" mandatory="true" name="BANNERS_ID" remarks="">
 <column-description></column-description>
 <data-type jdbc-type="4" name="INTEGER" selected-variant-pattern="INTEGER">
 <variant type-name-pattern="INTEGER"/>
@@ -296,7 +296,7 @@
 <table-description></table-description>
 <table-figure-bounds height="-1" width="-1" x="594" y="3894"/>
 <column-list>
-<column alias="" auto-increment="false" column-size="10" decimal-digits="0" default-value="" mandatory="true" name="BANNERS_HISTORY_ID" remarks="">
+<column alias="" auto-increment="false" column-size="0" decimal-digits="0" default-value="AUTOINCREMENT: start 1 increment 1" mandatory="true" name="BANNERS_HISTORY_ID" remarks="">
 <column-description></column-description>
 <data-type jdbc-type="4" name="INTEGER" selected-variant-pattern="INTEGER">
 <variant type-name-pattern="INTEGER"/>
@@ -472,7 +472,7 @@
 <table-description></table-description>
 <table-figure-bounds height="-1" width="-1" x="36" y="4430"/>
 <column-list>
-<column alias="" auto-increment="false" column-size="10" decimal-digits="0" default-value="" mandatory="true" name="CONFIGURATION_ID" remarks="">
+<column alias="" auto-increment="false" column-size="0" decimal-digits="0" default-value="AUTOINCREMENT: start 1 increment 1" mandatory="true" name="CONFIGURATION_ID" remarks="">
 <column-description></column-description>
 <data-type jdbc-type="4" name="INTEGER" selected-variant-pattern="INTEGER">
 <variant type-name-pattern="INTEGER"/>
@@ -570,7 +570,7 @@
 <table-description></table-description>
 <table-figure-bounds height="-1" width="-1" x="18" y="4290"/>
 <column-list>
-<column alias="" auto-increment="false" column-size="10" decimal-digits="0" default-value="" mandatory="true" name="CONFIGURATION_GROUP_ID" remarks="">
+<column alias="" auto-increment="false" column-size="0" decimal-digits="0" default-value="AUTOINCREMENT: start 1 increment 1" mandatory="true" name="CONFIGURATION_GROUP_ID" remarks="">
 <column-description></column-description>
 <data-type jdbc-type="4" name="INTEGER" selected-variant-pattern="INTEGER">
 <variant type-name-pattern="INTEGER"/>
@@ -668,7 +668,7 @@
 <table-description></table-description>
 <table-figure-bounds height="-1" width="-1" x="1281" y="5"/>
 <column-list>
-<column alias="" auto-increment="false" column-size="10" decimal-digits="0" default-value="" mandatory="true" name="COUNTRIES_ID" remarks="">
+<column alias="" auto-increment="false" column-size="0" decimal-digits="0" default-value="AUTOINCREMENT: start 1 increment 1" mandatory="true" name="COUNTRIES_ID" remarks="">
 <column-description></column-description>
 <data-type jdbc-type="4" name="INTEGER" selected-variant-pattern="INTEGER">
 <variant type-name-pattern="INTEGER"/>
@@ -718,7 +718,7 @@
 <table-description></table-description>
 <table-figure-bounds height="-1" width="-1" x="1079" y="4015"/>
 <column-list>
-<column alias="" auto-increment="false" column-size="10" decimal-digits="0" default-value="" mandatory="true" name="CURRENCIES_ID" remarks="">
+<column alias="" auto-increment="false" column-size="0" decimal-digits="0" default-value="AUTOINCREMENT: start 1 increment 1" mandatory="true" name="CURRENCIES_ID" remarks="">
 <column-description></column-description>
 <data-type jdbc-type="4" name="INTEGER" selected-variant-pattern="INTEGER">
 <variant type-name-pattern="INTEGER"/>
@@ -902,7 +902,7 @@
 <table-description></table-description>
 <table-figure-bounds height="-1" width="-1" x="261" y="2328"/>
 <column-list>
-<column alias="" auto-increment="false" column-size="10" decimal-digits="0" default-value="" mandatory="true" name="CUSTOMERS_BASKET_ID" remarks="">
+<column alias="" auto-increment="false" column-size="0" decimal-digits="0" default-value="AUTOINCREMENT: start 1 increment 1" mandatory="true" name="CUSTOMERS_BASKET_ID" remarks="">
 <column-description></column-description>
 <data-type jdbc-type="4" name="INTEGER" selected-variant-pattern="INTEGER">
 <variant type-name-pattern="INTEGER"/>
@@ -974,7 +974,7 @@
 <table-description></table-description>
 <table-figure-bounds height="-1" width="-1" x="1" y="2159"/>
 <column-list>
-<column alias="" auto-increment="false" column-size="10" decimal-digits="0" default-value="" mandatory="true" name="CUSTOMERS_BASKET_ATTRIBUTES_ID" remarks="">
+<column alias="" auto-increment="false" column-size="0" decimal-digits="0" default-value="AUTOINCREMENT: start 1 increment 1" mandatory="true" name="CUSTOMERS_BASKET_ATTRIBUTES_ID" remarks="">
 <column-description></column-description>
 <data-type jdbc-type="4" name="INTEGER" selected-variant-pattern="INTEGER">
 <variant type-name-pattern="INTEGER"/>
@@ -1051,7 +1051,7 @@
 <table-description></table-description>
 <table-figure-bounds height="-1" width="-1" x="471" y="204"/>
 <column-list>
-<column alias="" auto-increment="false" column-size="10" decimal-digits="0" default-value="" mandatory="true" name="CUSTOMERS_INFO_ID" remarks="">
+<column alias="" auto-increment="false" column-size="0" decimal-digits="0" default-value="AUTOINCREMENT: start 1 increment 1" mandatory="true" name="CUSTOMERS_INFO_ID" remarks="">
 <column-description></column-description>
 <data-type jdbc-type="4" name="INTEGER" selected-variant-pattern="INTEGER">
 <variant type-name-pattern="INTEGER"/>
@@ -1245,7 +1245,7 @@
 <table-description></table-description>
 <table-figure-bounds height="-1" width="-1" x="320" y="539"/>
 <column-list>
-<column alias="" auto-increment="false" column-size="10" decimal-digits="0" default-value="" mandatory="true" name="GEO_ZONE_ID" remarks="">
+<column alias="" auto-increment="false" column-size="0" decimal-digits="0" default-value="AUTOINCREMENT: start 1 increment 1" mandatory="true" name="GEO_ZONE_ID" remarks="">
 <column-description></column-description>
 <data-type jdbc-type="4" name="INTEGER" selected-variant-pattern="INTEGER">
 <variant type-name-pattern="INTEGER"/>
@@ -1299,7 +1299,7 @@
 <table-description></table-description>
 <table-figure-bounds height="-1" width="-1" x="1341" y="2161"/>
 <column-list>
-<column alias="" auto-increment="false" column-size="10" decimal-digits="0" default-value="" mandatory="true" name="LANGUAGES_ID" remarks="">
+<column alias="" auto-increment="false" column-size="0" decimal-digits="0" default-value="AUTOINCREMENT: start 1 increment 1" mandatory="true" name="LANGUAGES_ID" remarks="">
 <column-description></column-description>
 <data-type jdbc-type="4" name="INTEGER" selected-variant-pattern="INTEGER">
 <variant type-name-pattern="INTEGER"/>
@@ -1492,7 +1492,7 @@
 <table-description></table-description>
 <table-figure-bounds height="-1" width="-1" x="40" y="4104"/>
 <column-list>
-<column alias="" auto-increment="false" column-size="10" decimal-digits="0" default-value="" mandatory="true" name="NEWSLETTERS_ID" remarks="">
+<column alias="" auto-increment="false" column-size="0" decimal-digits="0" default-value="AUTOINCREMENT: start 1 increment 1" mandatory="true" name="NEWSLETTERS_ID" remarks="">
 <column-description></column-description>
 <data-type jdbc-type="4" name="INTEGER" selected-variant-pattern="INTEGER">
 <variant type-name-pattern="INTEGER"/>
@@ -2027,7 +2027,7 @@
 <table-description></table-description>
 <table-figure-bounds height="-1" width="-1" x="687" y="1603"/>
 <column-list>
-<column alias="" auto-increment="false" column-size="10" decimal-digits="0" default-value="" mandatory="true" name="ORDERS_PRODUCTS_ATTRIBUTES_ID" remarks="">
+<column alias="" auto-increment="false" column-size="0" decimal-digits="0" default-value="AUTOINCREMENT: start 1 increment 1" mandatory="true" name="ORDERS_PRODUCTS_ATTRIBUTES_ID" remarks="">
 <column-description></column-description>
 <data-type jdbc-type="4" name="INTEGER" selected-variant-pattern="INTEGER">
 <variant type-name-pattern="INTEGER"/>
@@ -2105,7 +2105,7 @@
 <table-description></table-description>
 <table-figure-bounds height="-1" width="-1" x="543" y="1456"/>
 <column-list>
-<column alias="" auto-increment="false" column-size="10" decimal-digits="0" default-value="" mandatory="true" name="ORDERS_PRODUCTS_DOWNLOAD_ID" remarks="">
+<column alias="" auto-increment="false" column-size="0" decimal-digits="0" default-value="AUTOINCREMENT: start 1 increment 1" mandatory="true" name="ORDERS_PRODUCTS_DOWNLOAD_ID" remarks="">
 <column-description></column-description>
 <data-type jdbc-type="4" name="INTEGER" selected-variant-pattern="INTEGER">
 <variant type-name-pattern="INTEGER"/>
@@ -2174,7 +2174,7 @@
 <table-description></table-description>
 <table-figure-bounds height="-1" width="-1" x="737" y="1048"/>
 <column-list>
-<column alias="" auto-increment="false" column-size="10" decimal-digits="0" default-value="1" mandatory="true" name="ORDERS_STATUS_ID" remarks="">
+<column alias="" auto-increment="false" column-size="0" decimal-digits="0" default-value="AUTOINCREMENT: start 1 increment 1" mandatory="true" name="ORDERS_STATUS_ID" remarks="">
 <column-description></column-description>
 <data-type jdbc-type="4" name="INTEGER" selected-variant-pattern="INTEGER">
 <variant type-name-pattern="INTEGER"/>
@@ -2287,7 +2287,7 @@
 <table-description></table-description>
 <table-figure-bounds height="-1" width="-1" x="421" y="665"/>
 <column-list>
-<column alias="" auto-increment="false" column-size="10" decimal-digits="0" default-value="" mandatory="true" name="ORDERS_TOTAL_ID" remarks="">
+<column alias="" auto-increment="false" column-size="0" decimal-digits="0" default-value="AUTOINCREMENT: start 1 increment 1" mandatory="true" name="ORDERS_TOTAL_ID" remarks="">
 <column-description></column-description>
 <data-type jdbc-type="4" name="INTEGER" selected-variant-pattern="INTEGER">
 <variant type-name-pattern="INTEGER"/>
@@ -2735,7 +2735,7 @@
 <table-description></table-description>
 <table-figure-bounds height="-1" width="-1" x="1108" y="1951"/>
 <column-list>
-<column alias="" auto-increment="false" column-size="10" decimal-digits="0" default-value="0" mandatory="true" name="PRODUCTS_OPTIONS_ID" remarks="">
+<column alias="" auto-increment="false" column-size="0" decimal-digits="0" default-value="AUTOINCREMENT: start 1 increment 1" mandatory="true" name="PRODUCTS_OPTIONS_ID" remarks="">
 <column-description></column-description>
 <data-type jdbc-type="4" name="INTEGER" selected-variant-pattern="INTEGER">
 <variant type-name-pattern="INTEGER"/>
@@ -2780,7 +2780,7 @@
 <table-description></table-description>
 <table-figure-bounds height="-1" width="-1" x="743" y="1920"/>
 <column-list>
-<column alias="" auto-increment="false" column-size="10" decimal-digits="0" default-value="0" mandatory="true" name="PRODUCTS_OPTIONS_VALUES_ID" remarks="">
+<column alias="" auto-increment="false" column-size="0" decimal-digits="0" default-value="AUTOINCREMENT: start 1 increment 1" mandatory="true" name="PRODUCTS_OPTIONS_VALUES_ID" remarks="">
 <column-description></column-description>
 <data-type jdbc-type="4" name="INTEGER" selected-variant-pattern="INTEGER">
 <variant type-name-pattern="INTEGER"/>
@@ -2825,7 +2825,7 @@
 <table-description></table-description>
 <table-figure-bounds height="-1" width="-1" x="827" y="1793"/>
 <column-list>
-<column alias="" auto-increment="false" column-size="10" decimal-digits="0" default-value="" mandatory="true" name="PRODUCTS_OPTIONS_VALUES_TO_PRODUCTS_OPTIONS_ID" remarks="">
+<column alias="" auto-increment="false" column-size="0" decimal-digits="0" default-value="AUTOINCREMENT: start 1 increment 1" mandatory="true" name="PRODUCTS_OPTIONS_VALUES_TO_PRODUCTS_OPTIONS_ID" remarks="">
 <column-description></column-description>
 <data-type jdbc-type="4" name="INTEGER" selected-variant-pattern="INTEGER">
 <variant type-name-pattern="INTEGER"/>
@@ -2933,7 +2933,7 @@
 <table-description></table-description>
 <table-figure-bounds height="-1" width="-1" x="13" y="3455"/>
 <column-list>
-<column alias="" auto-increment="false" column-size="10" decimal-digits="0" default-value="" mandatory="true" name="REVIEWS_ID" remarks="">
+<column alias="" auto-increment="false" column-size="0" decimal-digits="0" default-value="AUTOINCREMENT: start 1 increment 1" mandatory="true" name="REVIEWS_ID" remarks="">
 <column-description></column-description>
 <data-type jdbc-type="4" name="INTEGER" selected-variant-pattern="INTEGER">
 <variant type-name-pattern="INTEGER"/>
@@ -3013,7 +3013,7 @@
 <table-description></table-description>
 <table-figure-bounds height="-1" width="-1" x="1312" y="3491"/>
 <column-list>
-<column alias="" auto-increment="false" column-size="10" decimal-digits="0" default-value="" mandatory="true" name="REVIEWS_ID" remarks="">
+<column alias="" auto-increment="false" column-size="0" decimal-digits="0" default-value="AUTOINCREMENT: start 1 increment 1" mandatory="true" name="REVIEWS_ID" remarks="">
 <column-description></column-description>
 <data-type jdbc-type="4" name="INTEGER" selected-variant-pattern="INTEGER">
 <variant type-name-pattern="INTEGER"/>
@@ -3102,7 +3102,7 @@
 <table-description></table-description>
 <table-figure-bounds height="-1" width="-1" x="280" y="3307"/>
 <column-list>
-<column alias="" auto-increment="false" column-size="10" decimal-digits="0" default-value="" mandatory="true" name="SPECIALS_ID" remarks="">
+<column alias="" auto-increment="false" column-size="0" decimal-digits="0" default-value="AUTOINCREMENT: start 1 increment 1" mandatory="true" name="SPECIALS_ID" remarks="">
 <column-description></column-description>
 <data-type jdbc-type="4" name="INTEGER" selected-variant-pattern="INTEGER">
 <variant type-name-pattern="INTEGER"/>
@@ -3190,7 +3190,7 @@
 <table-description></table-description>
 <table-figure-bounds height="-1" width="-1" x="262" y="378"/>
 <column-list>
-<column alias="" auto-increment="false" column-size="10" decimal-digits="0" default-value="" mandatory="true" name="TAX_CLASS_ID" remarks="">
+<column alias="" auto-increment="false" column-size="0" decimal-digits="0" default-value="AUTOINCREMENT: start 1 increment 1" mandatory="true" name="TAX_CLASS_ID" remarks="">
 <column-description></column-description>
 <data-type jdbc-type="4" name="INTEGER" selected-variant-pattern="INTEGER">
 <variant type-name-pattern="INTEGER"/>
@@ -3244,7 +3244,7 @@
 <table-description></table-description>
 <table-figure-bounds height="-1" width="-1" x="845" y="335"/>
 <column-list>
-<column alias="" auto-increment="false" column-size="10" decimal-digits="0" default-value="" mandatory="true" name="TAX_RATES_ID" remarks="">
+<column alias="" auto-increment="false" column-size="0" decimal-digits="0" default-value="AUTOINCREMENT: start 1 increment 1" mandatory="true" name="TAX_RATES_ID" remarks="">
 <column-description></column-description>
 <data-type jdbc-type="4" name="INTEGER" selected-variant-pattern="INTEGER">
 <variant type-name-pattern="INTEGER"/>
@@ -3395,7 +3395,7 @@
 <table-description></table-description>
 <table-figure-bounds height="-1" width="-1" x="1301" y="424"/>
 <column-list>
-<column alias="" auto-increment="false" column-size="10" decimal-digits="0" default-value="" mandatory="true" name="ZONE_ID" remarks="">
+<column alias="" auto-increment="false" column-size="0" decimal-digits="0" default-value="AUTOINCREMENT: start 1 increment 1" mandatory="true" name="ZONE_ID" remarks="">
 <column-description></column-description>
 <data-type jdbc-type="4" name="INTEGER" selected-variant-pattern="INTEGER">
 <variant type-name-pattern="INTEGER"/>
@@ -3445,7 +3445,7 @@
 <table-description></table-description>
 <table-figure-bounds height="-1" width="-1" x="867" y="501"/>
 <column-list>
-<column alias="" auto-increment="false" column-size="10" decimal-digits="0" default-value="" mandatory="true" name="ASSOCIATION_ID" remarks="">
+<column alias="" auto-increment="false" column-size="0" decimal-digits="0" default-value="AUTOINCREMENT: start 1 increment 1" mandatory="true" name="ASSOCIATION_ID" remarks="">
 <column-description></column-description>
 <data-type jdbc-type="4" name="INTEGER" selected-variant-pattern="INTEGER">
 <variant type-name-pattern="INTEGER"/>

Modified: pompei/portlets/pompei-core/trunk/src/main/webapp/WEB-INF/db/create_table.sql
===================================================================
--- pompei/portlets/pompei-core/trunk/src/main/webapp/WEB-INF/db/create_table.sql	2007-09-03 06:43:34 UTC (rev 526)
+++ pompei/portlets/pompei-core/trunk/src/main/webapp/WEB-INF/db/create_table.sql	2007-09-03 07:48:37 UTC (rev 527)
@@ -1,5 +1,5 @@
 CREATE TABLE BANNERS (
-       BANNERS_ID INTEGER NOT NULL
+       BANNERS_ID INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1)
      , BANNERS_TITLE VARCHAR(64) NOT NULL
      , BANNERS_URL VARCHAR(255) NOT NULL
      , BANNERS_IMAGE VARCHAR(64) NOT NULL
@@ -15,7 +15,7 @@
 );
 
 CREATE TABLE CATEGORIES (
-       CATEGORIES_ID INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1)
+       CATEGORIES_ID INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1)
      , CATEGORIES_IMAGE VARCHAR(64)
      , PARENT_ID INTEGER DEFAULT 0 NOT NULL
      , SORT_ORDER INTEGER
@@ -25,7 +25,7 @@
 );
 
 CREATE TABLE CONFIGURATION_GROUP (
-       CONFIGURATION_GROUP_ID INTEGER NOT NULL
+       CONFIGURATION_GROUP_ID INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1)
      , CONFIGURATION_GROUP_TITLE VARCHAR(64) NOT NULL
      , CONFIGURATION_GROUP_DESCRIPTION VARCHAR(255) NOT NULL
      , SORT_ORDER INTEGER
@@ -44,7 +44,7 @@
 );
 
 CREATE TABLE COUNTRIES (
-       COUNTRIES_ID INTEGER NOT NULL
+       COUNTRIES_ID INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1)
      , COUNTRIES_NAME VARCHAR(64) NOT NULL
      , COUNTRIES_ISO_CODE_2 CHAR(2) NOT NULL
      , COUNTRIES_ISO_CODE_3 CHAR(3) NOT NULL
@@ -53,7 +53,7 @@
 );
 
 CREATE TABLE CURRENCIES (
-       CURRENCIES_ID INTEGER NOT NULL
+       CURRENCIES_ID INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1)
      , TITLE VARCHAR(32) NOT NULL
      , CODE CHAR(3) NOT NULL
      , SYMBOL_LEFT VARCHAR(12)
@@ -67,7 +67,7 @@
 );
 
 CREATE TABLE CUSTOMERS (
-       CUSTOMERS_ID INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1)
+       CUSTOMERS_ID INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1)
      , CUSTOMERS_PORTAL_ID VARCHAR(255) NOT NULL
      , CUSTOMERS_GENDER CHAR(1) NOT NULL
      , CUSTOMERS_FIRSTNAME VARCHAR(32) NOT NULL
@@ -83,7 +83,7 @@
 );
 
 CREATE TABLE DELIVERY_METHOD (
-       DELIVERY_METHOD_ID INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1)
+       DELIVERY_METHOD_ID INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1)
      , DELIVERY_CLASS VARCHAR(128) NOT NULL
      , DELIVERY_STATUS VARCHAR(1) NOT NULL
      , SORT_ORDER INTEGER
@@ -93,7 +93,7 @@
 );
 
 CREATE TABLE GEO_ZONES (
-       GEO_ZONE_ID INTEGER NOT NULL
+       GEO_ZONE_ID INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1)
      , GEO_ZONE_NAME VARCHAR(32) NOT NULL
      , GEO_ZONE_DESCRIPTION VARCHAR(255) NOT NULL
      , LAST_MODIFIED TIMESTAMP
@@ -102,7 +102,7 @@
 );
 
 CREATE TABLE LANGUAGES (
-       LANGUAGES_ID INTEGER NOT NULL
+       LANGUAGES_ID INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1)
      , NAME VARCHAR(32) NOT NULL
      , CODE CHAR(2) NOT NULL
      , IMAGE VARCHAR(64)
@@ -112,7 +112,7 @@
 );
 
 CREATE TABLE MANUFACTURERS (
-       MANUFACTURERS_ID INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1)
+       MANUFACTURERS_ID INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1)
      , MANUFACTURERS_NAME VARCHAR(32) NOT NULL
      , MANUFACTURERS_IMAGE VARCHAR(64)
      , DATE_ADDED TIMESTAMP
@@ -121,7 +121,7 @@
 );
 
 CREATE TABLE NEWSLETTERS (
-       NEWSLETTERS_ID INTEGER NOT NULL
+       NEWSLETTERS_ID INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1)
      , TITLE VARCHAR(255) NOT NULL
      , CONTENT LONG VARCHAR NOT NULL
      , MODULE VARCHAR(255) NOT NULL
@@ -140,7 +140,7 @@
 );
 
 CREATE TABLE TAX_CLASS (
-       TAX_CLASS_ID INTEGER NOT NULL
+       TAX_CLASS_ID INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1)
      , TAX_CLASS_TITLE VARCHAR(32) NOT NULL
      , TAX_CLASS_DESCRIPTION VARCHAR(255) NOT NULL
      , LAST_MODIFIED TIMESTAMP
@@ -149,21 +149,21 @@
 );
 
 CREATE TABLE ADDRESS_FORMAT (
-       ADDRESS_FORMAT_ID INTEGER NOT NULL
+       ADDRESS_FORMAT_ID INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1)
      , ADDRESS_FORMAT VARCHAR(128) NOT NULL
      , ADDRESS_SUMMARY VARCHAR(48) NOT NULL
      , PRIMARY KEY (ADDRESS_FORMAT_ID)
 );
 
 CREATE TABLE ORDERS_STATUS (
-       ORDERS_STATUS_ID INTEGER DEFAULT 1 NOT NULL
+       ORDERS_STATUS_ID INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1)
      , LANGUAGE_ID INTEGER DEFAULT 1 NOT NULL
      , ORDERS_STATUS_NAME VARCHAR(32) NOT NULL
      , PRIMARY KEY (ORDERS_STATUS_ID)
 );
 
 CREATE TABLE ORDERS (
-       ORDERS_ID INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1)
+       ORDERS_ID INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1)
      , CUSTOMERS_ID INTEGER NOT NULL
      , CUSTOMERS_NAME VARCHAR(64) NOT NULL
      , CUSTOMERS_COMPANY VARCHAR(32)
@@ -215,7 +215,7 @@
 );
 
 CREATE TABLE PRODUCTS (
-       PRODUCTS_ID INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1)
+       PRODUCTS_ID INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1)
      , PRODUCTS_QUANTITY INTEGER NOT NULL
      , PRODUCTS_MODEL VARCHAR(12)
      , PRODUCTS_IMAGE VARCHAR(64)
@@ -232,21 +232,21 @@
 );
 
 CREATE TABLE PRODUCTS_OPTIONS (
-       PRODUCTS_OPTIONS_ID INTEGER DEFAULT 0 NOT NULL
+       PRODUCTS_OPTIONS_ID INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1)
      , LANGUAGE_ID INTEGER DEFAULT 1 NOT NULL
      , PRODUCTS_OPTIONS_NAME VARCHAR(32) DEFAULT '' NOT NULL
      , PRIMARY KEY (PRODUCTS_OPTIONS_ID)
 );
 
 CREATE TABLE PRODUCTS_OPTIONS_VALUES (
-       PRODUCTS_OPTIONS_VALUES_ID INTEGER DEFAULT 0 NOT NULL
+       PRODUCTS_OPTIONS_VALUES_ID INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1)
      , LANGUAGE_ID INTEGER DEFAULT 1 NOT NULL
      , PRODUCTS_OPTIONS_VALUES_NAME VARCHAR(64) DEFAULT '' NOT NULL
      , PRIMARY KEY (PRODUCTS_OPTIONS_VALUES_ID)
 );
 
 CREATE TABLE REVIEWS (
-       REVIEWS_ID INTEGER NOT NULL
+       REVIEWS_ID INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1)
      , PRODUCTS_ID INTEGER NOT NULL
      , CUSTOMERS_ID INTEGER
      , CUSTOMERS_NAME VARCHAR(64) NOT NULL
@@ -258,7 +258,7 @@
 );
 
 CREATE TABLE ZONES (
-       ZONE_ID INTEGER NOT NULL
+       ZONE_ID INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1)
      , ZONE_COUNTRY_ID INTEGER NOT NULL
      , ZONE_CODE VARCHAR(32) NOT NULL
      , ZONE_NAME VARCHAR(32) NOT NULL
@@ -266,7 +266,7 @@
 );
 
 CREATE TABLE PRODUCTS_ATTRIBUTES (
-       PRODUCTS_ATTRIBUTES_ID INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1)
+       PRODUCTS_ATTRIBUTES_ID INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1)
      , PRODUCTS_ID INTEGER NOT NULL
      , OPTIONS_ID INTEGER NOT NULL
      , OPTIONS_VALUES_ID INTEGER NOT NULL
@@ -276,7 +276,7 @@
 );
 
 CREATE TABLE BANNERS_HISTORY (
-       BANNERS_HISTORY_ID INTEGER NOT NULL
+       BANNERS_HISTORY_ID INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1)
      , BANNERS_ID INTEGER NOT NULL
      , BANNERS_SHOWN INTEGER DEFAULT 0 NOT NULL
      , BANNERS_CLICKED INTEGER DEFAULT 0 NOT NULL
@@ -292,7 +292,7 @@
 );
 
 CREATE TABLE CONFIGURATION (
-       CONFIGURATION_ID INTEGER NOT NULL
+       CONFIGURATION_ID INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1)
      , CONFIGURATION_TITLE VARCHAR(64) NOT NULL
      , CONFIGURATION_KEY VARCHAR(64) NOT NULL
      , CONFIGURATION_VALUE VARCHAR(255) NOT NULL
@@ -307,7 +307,7 @@
 );
 
 CREATE TABLE CUSTOMERS_BASKET (
-       CUSTOMERS_BASKET_ID INTEGER NOT NULL
+       CUSTOMERS_BASKET_ID INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1)
      , CUSTOMERS_ID INTEGER NOT NULL
      , PRODUCTS_ID INTEGER NOT NULL
      , CUSTOMERS_BASKET_QUANTITY INTEGER NOT NULL
@@ -317,7 +317,7 @@
 );
 
 CREATE TABLE CUSTOMERS_BASKET_ATTRIBUTES (
-       CUSTOMERS_BASKET_ATTRIBUTES_ID INTEGER NOT NULL
+       CUSTOMERS_BASKET_ATTRIBUTES_ID INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1)
      , CUSTOMERS_ID INTEGER NOT NULL
      , PRODUCTS_ID INTEGER NOT NULL
      , PRODUCTS_OPTIONS_ID INTEGER NOT NULL
@@ -326,7 +326,7 @@
 );
 
 CREATE TABLE CUSTOMERS_INFO (
-       CUSTOMERS_INFO_ID INTEGER NOT NULL
+       CUSTOMERS_INFO_ID INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1)
      , CUSTOMERS_INFO_DATE_OF_LAST_LOGON TIMESTAMP
      , CUSTOMERS_INFO_NUMBER_OF_LOGONS INTEGER
      , CUSTOMERS_INFO_DATE_ACCOUNT_CREATED TIMESTAMP
@@ -355,7 +355,7 @@
 );
 
 CREATE TABLE ORDERS_PRODUCTS (
-       ORDERS_PRODUCTS_ID INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1)
+       ORDERS_PRODUCTS_ID INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1)
      , ORDERS_ID INTEGER NOT NULL
      , PRODUCTS_ID INTEGER NOT NULL
      , PRODUCTS_MODEL VARCHAR(12)
@@ -368,7 +368,7 @@
 );
 
 CREATE TABLE ORDERS_PRODUCTS_ATTRIBUTES (
-       ORDERS_PRODUCTS_ATTRIBUTES_ID INTEGER NOT NULL
+       ORDERS_PRODUCTS_ATTRIBUTES_ID INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1)
      , ORDERS_ID INTEGER NOT NULL
      , ORDERS_PRODUCTS_ID INTEGER NOT NULL
      , PRODUCTS_OPTIONS VARCHAR(32) NOT NULL
@@ -379,7 +379,7 @@
 );
 
 CREATE TABLE ORDERS_PRODUCTS_DOWNLOAD (
-       ORDERS_PRODUCTS_DOWNLOAD_ID INTEGER NOT NULL
+       ORDERS_PRODUCTS_DOWNLOAD_ID INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1)
      , ORDERS_ID INTEGER DEFAULT 0 NOT NULL
      , ORDERS_PRODUCTS_ID INTEGER DEFAULT 0 NOT NULL
      , ORDERS_PRODUCTS_FILENAME VARCHAR(255) DEFAULT '' NOT NULL
@@ -389,7 +389,7 @@
 );
 
 CREATE TABLE ORDERS_STATUS_HISTORY (
-       ORDERS_STATUS_HISTORY_ID INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1)
+       ORDERS_STATUS_HISTORY_ID INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1)
      , ORDERS_ID INTEGER NOT NULL
      , ORDERS_STATUS_ID INTEGER NOT NULL
      , DATE_ADDED TIMESTAMP NOT NULL
@@ -399,7 +399,7 @@
 );
 
 CREATE TABLE ORDERS_TOTAL (
-       ORDERS_TOTAL_ID INTEGER NOT NULL
+       ORDERS_TOTAL_ID INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1)
      , ORDERS_ID INTEGER NOT NULL
      , TITLE VARCHAR(255) NOT NULL
      , TEXT VARCHAR(255) NOT NULL
@@ -435,7 +435,7 @@
 );
 
 CREATE TABLE PRODUCTS_OPTIONS_VALUES_TO_PRODUCTS_OPTIONS (
-       PRODUCTS_OPTIONS_VALUES_TO_PRODUCTS_OPTIONS_ID INTEGER NOT NULL
+       PRODUCTS_OPTIONS_VALUES_TO_PRODUCTS_OPTIONS_ID INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1)
      , PRODUCTS_OPTIONS_ID INTEGER NOT NULL
      , PRODUCTS_OPTIONS_VALUES_ID INTEGER NOT NULL
      , PRIMARY KEY (PRODUCTS_OPTIONS_VALUES_TO_PRODUCTS_OPTIONS_ID)
@@ -449,14 +449,14 @@
 );
 
 CREATE TABLE REVIEWS_DESCRIPTION (
-       REVIEWS_ID INTEGER NOT NULL
+       REVIEWS_ID INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1)
      , LANGUAGES_ID INTEGER NOT NULL
      , REVIEWS_TEXT LONG VARCHAR NOT NULL
      , PRIMARY KEY (LANGUAGES_ID, REVIEWS_ID)
 );
 
 CREATE TABLE SPECIALS (
-       SPECIALS_ID INTEGER NOT NULL
+       SPECIALS_ID INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1)
      , PRODUCTS_ID INTEGER NOT NULL
      , SPECIALS_NEW_PRODUCTS_PRICE DECIMAL(15,4) NOT NULL
      , SPECIALS_DATE_ADDED TIMESTAMP
@@ -468,7 +468,7 @@
 );
 
 CREATE TABLE TAX_RATES (
-       TAX_RATES_ID INTEGER NOT NULL
+       TAX_RATES_ID INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1)
      , TAX_ZONE_ID INTEGER NOT NULL
      , TAX_CLASS_ID INTEGER NOT NULL
      , TAX_PRIORITY INTEGER DEFAULT 1
@@ -490,7 +490,7 @@
 );
 
 CREATE TABLE ZONES_TO_GEO_ZONES (
-       ASSOCIATION_ID INTEGER NOT NULL
+       ASSOCIATION_ID INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1)
      , ZONE_COUNTRY_ID INTEGER NOT NULL
      , ZONE_ID INTEGER
      , GEO_ZONE_ID INTEGER
@@ -500,7 +500,7 @@
 );
 
 CREATE TABLE ADDRESS_BOOK (
-       ADDRESS_BOOK_ID INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1)
+       ADDRESS_BOOK_ID INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1)
      , CUSTOMERS_ID INTEGER NOT NULL
      , ENTRY_GENDER CHAR(1) NOT NULL
      , ENTRY_COMPANY VARCHAR(32)


pal-cvs メーリングリストの案内