[pal-cvs 2770] [537] changed to "start with 100"

svnno****@sourc***** svnno****@sourc*****
2007年 9月 4日 (火) 21:41:49 JST


Revision: 537
          http://svn.sourceforge.jp/cgi-bin/viewcvs.cgi?root=pal&view=rev&rev=537
Author:   shinsuke
Date:     2007-09-04 21:41:49 +0900 (Tue, 04 Sep 2007)

Log Message:
-----------
changed to "start with 100"

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


-------------- next part --------------
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-04 08:53:47 UTC (rev 536)
+++ pompei/portlets/pompei-core/trunk/src/main/webapp/WEB-INF/db/create_table.sql	2007-09-04 12:41:49 UTC (rev 537)
@@ -1,5 +1,5 @@
 CREATE TABLE BANNERS (
-       BANNERS_ID INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1)
+       BANNERS_ID INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 100, 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 CONFIGURATION_GROUP (
-       CONFIGURATION_GROUP_ID INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1)
+       CONFIGURATION_GROUP_ID INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 100, INCREMENT BY 1)
      , CONFIGURATION_GROUP_TITLE VARCHAR(64) NOT NULL
      , CONFIGURATION_GROUP_DESCRIPTION VARCHAR(255) NOT NULL
      , SORT_ORDER INTEGER
@@ -34,7 +34,7 @@
 );
 
 CREATE TABLE COUNTRIES (
-       COUNTRIES_ID INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1)
+       COUNTRIES_ID INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 100, 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
@@ -43,7 +43,7 @@
 );
 
 CREATE TABLE CURRENCIES (
-       CURRENCIES_ID INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1)
+       CURRENCIES_ID INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 100, INCREMENT BY 1)
      , TITLE VARCHAR(32) NOT NULL
      , CODE CHAR(3) NOT NULL
      , SYMBOL_LEFT VARCHAR(12)
@@ -57,7 +57,7 @@
 );
 
 CREATE TABLE CUSTOMERS (
-       CUSTOMERS_ID INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1)
+       CUSTOMERS_ID INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 100, INCREMENT BY 1)
      , CUSTOMERS_PORTAL_ID VARCHAR(255) NOT NULL
      , CUSTOMERS_GENDER CHAR(1) NOT NULL
      , CUSTOMERS_FIRSTNAME VARCHAR(32) NOT NULL
@@ -73,7 +73,7 @@
 );
 
 CREATE TABLE DELIVERY_METHOD (
-       DELIVERY_METHOD_ID INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1)
+       DELIVERY_METHOD_ID INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 100, INCREMENT BY 1)
      , DELIVERY_CLASS VARCHAR(128) NOT NULL
      , DELIVERY_STATUS VARCHAR(1) NOT NULL
      , SORT_ORDER INTEGER
@@ -83,7 +83,7 @@
 );
 
 CREATE TABLE GEO_ZONES (
-       GEO_ZONE_ID INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1)
+       GEO_ZONE_ID INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 100, INCREMENT BY 1)
      , GEO_ZONE_NAME VARCHAR(32) NOT NULL
      , GEO_ZONE_DESCRIPTION VARCHAR(255) NOT NULL
      , LAST_MODIFIED TIMESTAMP
@@ -92,7 +92,7 @@
 );
 
 CREATE TABLE LANGUAGES (
-       LANGUAGES_ID INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1)
+       LANGUAGES_ID INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 100, INCREMENT BY 1)
      , NAME VARCHAR(32) NOT NULL
      , CODE CHAR(2) NOT NULL
      , IMAGE VARCHAR(64)
@@ -102,7 +102,7 @@
 );
 
 CREATE TABLE MANUFACTURERS (
-       MANUFACTURERS_ID INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1)
+       MANUFACTURERS_ID INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 100, INCREMENT BY 1)
      , MANUFACTURERS_NAME VARCHAR(32) NOT NULL
      , MANUFACTURERS_IMAGE VARCHAR(64)
      , DATE_ADDED TIMESTAMP
@@ -111,7 +111,7 @@
 );
 
 CREATE TABLE NEWSLETTERS (
-       NEWSLETTERS_ID INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1)
+       NEWSLETTERS_ID INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 100, INCREMENT BY 1)
      , TITLE VARCHAR(255) NOT NULL
      , CONTENT LONG VARCHAR NOT NULL
      , MODULE VARCHAR(255) NOT NULL
@@ -128,12 +128,12 @@
 );
 
 CREATE TABLE PRODUCTS_OPTIONS (
-       PRODUCTS_OPTIONS_ID INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1)
+       PRODUCTS_OPTIONS_ID INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 100, INCREMENT BY 1)
      , PRIMARY KEY (PRODUCTS_OPTIONS_ID)
 );
 
 CREATE TABLE PRODUCTS_OPTIONS_VALUES (
-       PRODUCTS_OPTIONS_VALUES_ID INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1)
+       PRODUCTS_OPTIONS_VALUES_ID INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 100, INCREMENT BY 1)
      , PRIMARY KEY (PRODUCTS_OPTIONS_VALUES_ID)
 );
 
@@ -145,7 +145,7 @@
 );
 
 CREATE TABLE TAX_CLASS (
-       TAX_CLASS_ID INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1)
+       TAX_CLASS_ID INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 100, INCREMENT BY 1)
      , TAX_CLASS_TITLE VARCHAR(32) NOT NULL
      , TAX_CLASS_DESCRIPTION VARCHAR(255) NOT NULL
      , LAST_MODIFIED TIMESTAMP
@@ -154,14 +154,14 @@
 );
 
 CREATE TABLE ADDRESS_FORMAT (
-       ADDRESS_FORMAT_ID INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1)
+       ADDRESS_FORMAT_ID INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 100, INCREMENT BY 1)
      , ADDRESS_FORMAT VARCHAR(128) NOT NULL
      , ADDRESS_SUMMARY VARCHAR(48) NOT NULL
      , PRIMARY KEY (ADDRESS_FORMAT_ID)
 );
 
 CREATE TABLE ORDERS (
-       ORDERS_ID INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1)
+       ORDERS_ID INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 100, INCREMENT BY 1)
      , CUSTOMERS_ID INTEGER NOT NULL
      , CUSTOMERS_NAME VARCHAR(64) NOT NULL
      , CUSTOMERS_COMPANY VARCHAR(32)
@@ -213,7 +213,7 @@
 );
 
 CREATE TABLE PRODUCTS (
-       PRODUCTS_ID INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1)
+       PRODUCTS_ID INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 100, INCREMENT BY 1)
      , PRODUCTS_QUANTITY INTEGER NOT NULL
      , PRODUCTS_MODEL VARCHAR(12)
      , PRODUCTS_IMAGE VARCHAR(64)
@@ -230,7 +230,7 @@
 );
 
 CREATE TABLE CATEGORIES (
-       CATEGORIES_ID INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1)
+       CATEGORIES_ID INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 100, INCREMENT BY 1)
      , CATEGORIES_IMAGE VARCHAR(64)
      , PARENT_ID INTEGER DEFAULT 0
      , SORT_ORDER INTEGER
@@ -240,7 +240,7 @@
 );
 
 CREATE TABLE REVIEWS (
-       REVIEWS_ID INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1)
+       REVIEWS_ID INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 100, INCREMENT BY 1)
      , PRODUCTS_ID INTEGER NOT NULL
      , CUSTOMERS_ID INTEGER
      , CUSTOMERS_NAME VARCHAR(64) NOT NULL
@@ -252,7 +252,7 @@
 );
 
 CREATE TABLE ZONES (
-       ZONE_ID INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1)
+       ZONE_ID INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 100, INCREMENT BY 1)
      , ZONE_COUNTRY_ID INTEGER NOT NULL
      , ZONE_CODE VARCHAR(32) NOT NULL
      , ZONE_NAME VARCHAR(32) NOT NULL
@@ -260,7 +260,7 @@
 );
 
 CREATE TABLE PRODUCTS_ATTRIBUTES (
-       PRODUCTS_ATTRIBUTES_ID INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1)
+       PRODUCTS_ATTRIBUTES_ID INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 100, INCREMENT BY 1)
      , PRODUCTS_ID INTEGER NOT NULL
      , OPTIONS_ID INTEGER NOT NULL
      , OPTIONS_VALUES_ID INTEGER NOT NULL
@@ -270,7 +270,7 @@
 );
 
 CREATE TABLE BANNERS_HISTORY (
-       BANNERS_HISTORY_ID INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1)
+       BANNERS_HISTORY_ID INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 100, INCREMENT BY 1)
      , BANNERS_ID INTEGER NOT NULL
      , BANNERS_SHOWN INTEGER DEFAULT 0 NOT NULL
      , BANNERS_CLICKED INTEGER DEFAULT 0 NOT NULL
@@ -286,7 +286,7 @@
 );
 
 CREATE TABLE CONFIGURATION (
-       CONFIGURATION_ID INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1)
+       CONFIGURATION_ID INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 100, INCREMENT BY 1)
      , CONFIGURATION_TITLE VARCHAR(64) NOT NULL
      , CONFIGURATION_KEY VARCHAR(64) NOT NULL
      , CONFIGURATION_VALUE VARCHAR(255) NOT NULL
@@ -301,7 +301,7 @@
 );
 
 CREATE TABLE CUSTOMERS_BASKET (
-       CUSTOMERS_BASKET_ID INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1)
+       CUSTOMERS_BASKET_ID INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 100, INCREMENT BY 1)
      , CUSTOMERS_ID INTEGER NOT NULL
      , PRODUCTS_ID INTEGER NOT NULL
      , CUSTOMERS_BASKET_QUANTITY INTEGER NOT NULL
@@ -311,7 +311,7 @@
 );
 
 CREATE TABLE CUSTOMERS_BASKET_ATTRIBUTES (
-       CUSTOMERS_BASKET_ATTRIBUTES_ID INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1)
+       CUSTOMERS_BASKET_ATTRIBUTES_ID INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 100, INCREMENT BY 1)
      , CUSTOMERS_ID INTEGER NOT NULL
      , PRODUCTS_ID INTEGER NOT NULL
      , PRODUCTS_OPTIONS_ID INTEGER NOT NULL
@@ -320,7 +320,7 @@
 );
 
 CREATE TABLE CUSTOMERS_INFO (
-       CUSTOMERS_INFO_ID INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1)
+       CUSTOMERS_INFO_ID INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 100, INCREMENT BY 1)
      , CUSTOMERS_INFO_DATE_OF_LAST_LOGON TIMESTAMP
      , CUSTOMERS_INFO_NUMBER_OF_LOGONS INTEGER
      , CUSTOMERS_INFO_DATE_ACCOUNT_CREATED TIMESTAMP
@@ -348,7 +348,7 @@
 );
 
 CREATE TABLE ORDERS_PRODUCTS (
-       ORDERS_PRODUCTS_ID INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1)
+       ORDERS_PRODUCTS_ID INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 100, INCREMENT BY 1)
      , ORDERS_ID INTEGER NOT NULL
      , PRODUCTS_ID INTEGER NOT NULL
      , PRODUCTS_MODEL VARCHAR(12)
@@ -361,7 +361,7 @@
 );
 
 CREATE TABLE ORDERS_PRODUCTS_ATTRIBUTES (
-       ORDERS_PRODUCTS_ATTRIBUTES_ID INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1)
+       ORDERS_PRODUCTS_ATTRIBUTES_ID INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 100, INCREMENT BY 1)
      , ORDERS_ID INTEGER NOT NULL
      , ORDERS_PRODUCTS_ID INTEGER NOT NULL
      , PRODUCTS_OPTIONS VARCHAR(32) NOT NULL
@@ -372,7 +372,7 @@
 );
 
 CREATE TABLE ORDERS_PRODUCTS_DOWNLOAD (
-       ORDERS_PRODUCTS_DOWNLOAD_ID INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1)
+       ORDERS_PRODUCTS_DOWNLOAD_ID INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 100, 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
@@ -382,7 +382,7 @@
 );
 
 CREATE TABLE ORDERS_STATUS_HISTORY (
-       ORDERS_STATUS_HISTORY_ID INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1)
+       ORDERS_STATUS_HISTORY_ID INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 100, INCREMENT BY 1)
      , ORDERS_ID INTEGER NOT NULL
      , ORDERS_STATUS_ID INTEGER NOT NULL
      , DATE_ADDED TIMESTAMP NOT NULL
@@ -392,7 +392,7 @@
 );
 
 CREATE TABLE ORDERS_TOTAL (
-       ORDERS_TOTAL_ID INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1)
+       ORDERS_TOTAL_ID INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 100, INCREMENT BY 1)
      , ORDERS_ID INTEGER NOT NULL
      , TITLE VARCHAR(255) NOT NULL
      , TEXT VARCHAR(255) NOT NULL
@@ -428,7 +428,7 @@
 );
 
 CREATE TABLE PRODUCTS_OPTIONS_VALUES_TO_PRODUCTS_OPTIONS (
-       PRODUCTS_OPTIONS_VALUES_TO_PRODUCTS_OPTIONS_ID INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1)
+       PRODUCTS_OPTIONS_VALUES_TO_PRODUCTS_OPTIONS_ID INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 100, 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)
@@ -442,14 +442,14 @@
 );
 
 CREATE TABLE REVIEWS_DESCRIPTION (
-       REVIEWS_ID INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1)
+       REVIEWS_ID INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 100, 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 GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1)
+       SPECIALS_ID INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 100, INCREMENT BY 1)
      , PRODUCTS_ID INTEGER NOT NULL
      , SPECIALS_NEW_PRODUCTS_PRICE DECIMAL(15,4) NOT NULL
      , SPECIALS_DATE_ADDED TIMESTAMP
@@ -461,7 +461,7 @@
 );
 
 CREATE TABLE TAX_RATES (
-       TAX_RATES_ID INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1)
+       TAX_RATES_ID INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 100, INCREMENT BY 1)
      , TAX_ZONE_ID INTEGER NOT NULL
      , TAX_CLASS_ID INTEGER NOT NULL
      , TAX_PRIORITY INTEGER DEFAULT 1
@@ -483,7 +483,7 @@
 );
 
 CREATE TABLE ZONES_TO_GEO_ZONES (
-       ASSOCIATION_ID INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1)
+       ASSOCIATION_ID INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 100, INCREMENT BY 1)
      , ZONE_COUNTRY_ID INTEGER NOT NULL
      , ZONE_ID INTEGER
      , GEO_ZONE_ID INTEGER
@@ -514,7 +514,7 @@
 );
 
 CREATE TABLE ADDRESS_BOOK (
-       ADDRESS_BOOK_ID INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1)
+       ADDRESS_BOOK_ID INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 100, INCREMENT BY 1)
      , CUSTOMERS_ID INTEGER NOT NULL
      , ENTRY_GENDER CHAR(1) NOT NULL
      , ENTRY_COMPANY VARCHAR(32)


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