svnno****@sourc*****
svnno****@sourc*****
2007年 8月 26日 (日) 03:23:29 JST
Revision: 493
http://svn.sourceforge.jp/cgi-bin/viewcvs.cgi?root=pal&view=rev&rev=493
Author: takeharu
Date: 2007-08-26 03:23:29 +0900 (Sun, 26 Aug 2007)
Log Message:
-----------
changed comment of delete sql
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-08-25 18:21:14 UTC (rev 492)
+++ pompei/portlets/pompei-core/trunk/src/main/webapp/WEB-INF/db/create_table.sql 2007-08-25 18:23:29 UTC (rev 493)
@@ -1,4 +1,4 @@
-//DROP TABLE address_book;
+--DROP TABLE address_book;
CREATE TABLE address_book (
address_book_id int NOT NULL GENERATED ALWAYS AS IDENTITY
(START WITH 1, INCREMENT BY 1),
@@ -21,7 +21,7 @@
PRIMARY KEY (address_book_id)
);
-//DROP TABLE address_format;
+--DROP TABLE address_format;
CREATE TABLE address_format (
address_format_id int NOT NULL,
address_format varchar(128) NOT NULL,
@@ -29,7 +29,7 @@
PRIMARY KEY (address_format_id)
);
-//DROP TABLE banners;
+--DROP TABLE banners;
CREATE TABLE banners (
banners_id int NOT NULL,
banners_title varchar(64) NOT NULL,
@@ -46,7 +46,7 @@
PRIMARY KEY (banners_id)
);
-//DROP TABLE banners_history;
+--DROP TABLE banners_history;
CREATE TABLE banners_history (
banners_history_id int NOT NULL,
banners_id int NOT NULL,
@@ -56,7 +56,7 @@
PRIMARY KEY (banners_history_id)
);
-//DROP TABLE categories;
+--DROP TABLE categories;
CREATE TABLE categories (
categories_id int NOT NULL GENERATED ALWAYS AS IDENTITY
(START WITH 1, INCREMENT BY 1),
@@ -68,7 +68,7 @@
PRIMARY KEY (categories_id)
);
-//DROP TABLE categories_description;
+--DROP TABLE categories_description;
CREATE TABLE categories_description (
categories_id int DEFAULT 0 NOT NULL,
language_id int DEFAULT 1 NOT NULL,
@@ -76,7 +76,7 @@
PRIMARY KEY (categories_id, language_id)
);
-//DROP TABLE configuration;
+--DROP TABLE configuration;
CREATE TABLE configuration (
configuration_id int NOT NULL,
configuration_title varchar(64) NOT NULL,
@@ -92,7 +92,7 @@
PRIMARY KEY (configuration_id)
);
-//DROP TABLE configuration_group;
+--DROP TABLE configuration_group;
CREATE TABLE configuration_group (
configuration_group_id int NOT NULL,
configuration_group_title varchar(64) NOT NULL,
@@ -102,19 +102,19 @@
PRIMARY KEY (configuration_group_id)
);
-//DROP TABLE counter;
+--DROP TABLE counter;
CREATE TABLE counter (
startdate char(8),
counter int
);
-//DROP TABLE counter_history;
+--DROP TABLE counter_history;
CREATE TABLE counter_history (
month char(8),
counter int
);
-//DROP TABLE countries;
+--DROP TABLE countries;
CREATE TABLE countries (
countries_id int NOT NULL,
countries_name varchar(64) NOT NULL,
@@ -124,7 +124,7 @@
PRIMARY KEY (countries_id)
);
-//DROP TABLE currencies;
+--DROP TABLE currencies;
CREATE TABLE currencies (
currencies_id int NOT NULL,
title varchar(32) NOT NULL,
@@ -139,7 +139,7 @@
PRIMARY KEY (currencies_id)
);
-//DROP TABLE customers;
+--DROP TABLE customers;
CREATE TABLE customers (
customers_id int NOT NULL GENERATED ALWAYS AS IDENTITY
(START WITH 1, INCREMENT BY 1),
@@ -158,7 +158,7 @@
);
-//DROP TABLE customers_basket;
+--DROP TABLE customers_basket;
CREATE TABLE customers_basket (
customers_basket_id int NOT NULL,
customers_id int NOT NULL,
@@ -169,7 +169,7 @@
PRIMARY KEY (customers_basket_id)
);
-//DROP TABLE customers_basket_attributes;
+--DROP TABLE customers_basket_attributes;
CREATE TABLE customers_basket_attributes (
customers_basket_attributes_id int NOT NULL,
customers_id int NOT NULL,
@@ -179,7 +179,7 @@
PRIMARY KEY (customers_basket_attributes_id)
);
-//DROP TABLE customers_info;
+--DROP TABLE customers_info;
CREATE TABLE customers_info (
customers_info_id int NOT NULL,
customers_info_date_of_last_logon TIMESTAMP,
@@ -190,7 +190,7 @@
PRIMARY KEY (customers_info_id)
);
-//DROP TABLE languages;
+--DROP TABLE languages;
CREATE TABLE languages (
languages_id int NOT NULL,
name varchar(32) NOT NULL,
@@ -202,7 +202,7 @@
);
-//DROP TABLE manufacturers;
+--DROP TABLE manufacturers;
CREATE TABLE manufacturers (
manufacturers_id int NOT NULL GENERATED ALWAYS AS IDENTITY
(START WITH 1, INCREMENT BY 1),
@@ -213,7 +213,7 @@
PRIMARY KEY (manufacturers_id)
);
-//DROP TABLE manufacturers_info;
+--DROP TABLE manufacturers_info;
CREATE TABLE manufacturers_info (
manufacturers_id int NOT NULL,
languages_id int NOT NULL,
@@ -225,7 +225,7 @@
PRIMARY KEY (manufacturers_id, languages_id)
);
-//DROP TABLE newsletters;
+--DROP TABLE newsletters;
CREATE TABLE newsletters (
newsletters_id int NOT NULL,
title varchar(255) NOT NULL,
@@ -238,7 +238,7 @@
PRIMARY KEY (newsletters_id)
);
-//DROP TABLE products;
+--DROP TABLE products;
CREATE TABLE products (
products_id int NOT NULL GENERATED ALWAYS AS IDENTITY
(START WITH 1, INCREMENT BY 1),
@@ -258,7 +258,7 @@
FOREIGN KEY (manufacturers_id) REFERENCES manufacturers (manufacturers_id)
);
-//DROP TABLE products_attributes;
+--DROP TABLE products_attributes;
CREATE TABLE products_attributes (
products_attributes_id int NOT NULL GENERATED ALWAYS AS IDENTITY
(START WITH 1, INCREMENT BY 1),
@@ -270,7 +270,7 @@
PRIMARY KEY (products_attributes_id)
);
-//DROP TABLE products_attributes_download;
+--DROP TABLE products_attributes_download;
CREATE TABLE products_attributes_download (
products_attributes_id int NOT NULL,
products_attributes_filename varchar(255) NOT NULL default '',
@@ -279,7 +279,7 @@
PRIMARY KEY (products_attributes_id)
);
-//DROP TABLE products_description;
+--DROP TABLE products_description;
CREATE TABLE products_description (
products_id int NOT NULL,
language_id int NOT NULL default 1,
@@ -292,7 +292,7 @@
);
-//DROP TABLE products_notifications;
+--DROP TABLE products_notifications;
CREATE TABLE products_notifications (
products_id int NOT NULL,
customers_id int NOT NULL,
@@ -300,7 +300,7 @@
PRIMARY KEY (products_id, customers_id)
);
-//DROP TABLE products_options;
+--DROP TABLE products_options;
CREATE TABLE products_options (
products_options_id int NOT NULL default 0,
language_id int NOT NULL default 1,
@@ -308,7 +308,7 @@
PRIMARY KEY (products_options_id,language_id)
);
-//DROP TABLE products_options_values;
+--DROP TABLE products_options_values;
CREATE TABLE products_options_values (
products_options_values_id int NOT NULL default 0,
language_id int NOT NULL default 1,
@@ -316,7 +316,7 @@
PRIMARY KEY (products_options_values_id,language_id)
);
-//DROP TABLE products_options_values_to_products_options;
+--DROP TABLE products_options_values_to_products_options;
CREATE TABLE products_options_values_to_products_options (
products_options_values_to_products_options_id int NOT NULL,
products_options_id int NOT NULL,
@@ -324,7 +324,7 @@
PRIMARY KEY (products_options_values_to_products_options_id)
);
-//DROP TABLE products_to_categories;
+--DROP TABLE products_to_categories;
CREATE TABLE products_to_categories (
products_id int NOT NULL,
categories_id int NOT NULL,
@@ -333,7 +333,7 @@
FOREIGN KEY (products_id) REFERENCES products (products_id)
);
-//DROP TABLE orders;
+--DROP TABLE orders;
CREATE TABLE orders (
orders_id int NOT NULL GENERATED ALWAYS AS IDENTITY
(START WITH 1, INCREMENT BY 1),
@@ -387,7 +387,7 @@
PRIMARY KEY (orders_id)
);
-//DROP TABLE orders_products;
+--DROP TABLE orders_products;
CREATE TABLE orders_products (
orders_products_id int NOT NULL GENERATED ALWAYS AS IDENTITY
(START WITH 1, INCREMENT BY 1),
@@ -404,7 +404,7 @@
FOREIGN KEY (products_id) REFERENCES products (products_id)
);
-//DROP TABLE orders_status;
+--DROP TABLE orders_status;
CREATE TABLE orders_status (
orders_status_id int DEFAULT 0 NOT NULL,
language_id int DEFAULT 1 NOT NULL,
@@ -412,7 +412,7 @@
PRIMARY KEY (orders_status_id, language_id)
);
-//DROP TABLE orders_status_history;
+--DROP TABLE orders_status_history;
CREATE TABLE orders_status_history (
orders_status_history_id int NOT NULL,
orders_id int NOT NULL,
@@ -423,7 +423,7 @@
PRIMARY KEY (orders_status_history_id)
);
-//DROP TABLE orders_products_attributes;
+--DROP TABLE orders_products_attributes;
CREATE TABLE orders_products_attributes (
orders_products_attributes_id int NOT NULL,
orders_id int NOT NULL,
@@ -435,7 +435,7 @@
PRIMARY KEY (orders_products_attributes_id)
);
-//DROP TABLE orders_products_download;
+--DROP TABLE orders_products_download;
CREATE TABLE orders_products_download (
orders_products_download_id int NOT NULL,
orders_id int NOT NULL default 0,
@@ -446,7 +446,7 @@
PRIMARY KEY (orders_products_download_id)
);
-//DROP TABLE orders_total;
+--DROP TABLE orders_total;
CREATE TABLE orders_total (
orders_total_id int NOT NULL,
orders_id int NOT NULL,
@@ -458,7 +458,7 @@
PRIMARY KEY (orders_total_id)
);
-//DROP TABLE delivery_method;
+--DROP TABLE delivery_method;
CREATE TABLE delivery_method (
delivery_method_id int NOT NULL GENERATED ALWAYS AS IDENTITY
(START WITH 1, INCREMENT BY 1),
@@ -468,7 +468,7 @@
PRIMARY KEY (categories_id)
);
-//DROP TABLE delivery_method_description;
+--DROP TABLE delivery_method_description;
CREATE TABLE delivery_method_description (
delivery_method_id int DEFAULT 0 NOT NULL,
language_id int DEFAULT 1 NOT NULL,
@@ -477,7 +477,7 @@
);
-//DROP TABLE reviews;
+--DROP TABLE reviews;
CREATE TABLE reviews (
reviews_id int NOT NULL,
products_id int NOT NULL,
@@ -490,7 +490,7 @@
PRIMARY KEY (reviews_id)
);
-//DROP TABLE reviews_description;
+--DROP TABLE reviews_description;
CREATE TABLE reviews_description (
reviews_id int NOT NULL,
languages_id int NOT NULL,
@@ -498,7 +498,7 @@
PRIMARY KEY (reviews_id, languages_id)
);
-//DROP TABLE sessions;
+--DROP TABLE sessions;
CREATE TABLE sessions (
sesskey varchar(32) NOT NULL,
expiry int NOT NULL,
@@ -506,7 +506,7 @@
PRIMARY KEY (sesskey)
);
-//DROP TABLE specials;
+--DROP TABLE specials;
CREATE TABLE specials (
specials_id int NOT NULL,
products_id int NOT NULL,
@@ -519,7 +519,7 @@
PRIMARY KEY (specials_id)
);
-//DROP TABLE tax_class;
+--DROP TABLE tax_class;
CREATE TABLE tax_class (
tax_class_id int NOT NULL,
tax_class_title varchar(32) NOT NULL,
@@ -529,7 +529,7 @@
PRIMARY KEY (tax_class_id)
);
-//DROP TABLE tax_rates;
+--DROP TABLE tax_rates;
CREATE TABLE tax_rates (
tax_rates_id int NOT NULL,
tax_zone_id int NOT NULL,
@@ -542,7 +542,7 @@
PRIMARY KEY (tax_rates_id)
);
-//DROP TABLE geo_zones;
+--DROP TABLE geo_zones;
CREATE TABLE geo_zones (
geo_zone_id int NOT NULL,
geo_zone_name varchar(32) NOT NULL,
@@ -552,7 +552,7 @@
PRIMARY KEY (geo_zone_id)
);
-//DROP TABLE whos_online;
+--DROP TABLE whos_online;
CREATE TABLE whos_online (
customer_id int,
full_name varchar(64) NOT NULL,
@@ -563,7 +563,7 @@
last_page_url varchar(255) NOT NULL
);
-//DROP TABLE zones;
+--DROP TABLE zones;
CREATE TABLE zones (
zone_id int NOT NULL,
zone_country_id int NOT NULL,
@@ -572,7 +572,7 @@
PRIMARY KEY (zone_id)
);
-//DROP TABLE zones_to_geo_zones;
+--DROP TABLE zones_to_geo_zones;
CREATE TABLE zones_to_geo_zones (
association_id int NOT NULL,
zone_country_id int NOT NULL,