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)