• R/O
  • SSH
  • HTTPS

pal: Commit


Commit MetaInfo

Revision493 (tree)
Zeit2007-08-26 03:23:29
Autortakeharu

Log Message

changed comment of delete sql

Ändern Zusammenfassung

Diff

--- pompei/portlets/pompei-core/trunk/src/main/webapp/WEB-INF/db/create_table.sql (revision 492)
+++ pompei/portlets/pompei-core/trunk/src/main/webapp/WEB-INF/db/create_table.sql (revision 493)
@@ -1,4 +1,4 @@
1-//DROP TABLE address_book;
1+--DROP TABLE address_book;
22 CREATE TABLE address_book (
33 address_book_id int NOT NULL GENERATED ALWAYS AS IDENTITY
44 (START WITH 1, INCREMENT BY 1),
@@ -21,7 +21,7 @@
2121 PRIMARY KEY (address_book_id)
2222 );
2323
24-//DROP TABLE address_format;
24+--DROP TABLE address_format;
2525 CREATE TABLE address_format (
2626 address_format_id int NOT NULL,
2727 address_format varchar(128) NOT NULL,
@@ -29,7 +29,7 @@
2929 PRIMARY KEY (address_format_id)
3030 );
3131
32-//DROP TABLE banners;
32+--DROP TABLE banners;
3333 CREATE TABLE banners (
3434 banners_id int NOT NULL,
3535 banners_title varchar(64) NOT NULL,
@@ -46,7 +46,7 @@
4646 PRIMARY KEY (banners_id)
4747 );
4848
49-//DROP TABLE banners_history;
49+--DROP TABLE banners_history;
5050 CREATE TABLE banners_history (
5151 banners_history_id int NOT NULL,
5252 banners_id int NOT NULL,
@@ -56,7 +56,7 @@
5656 PRIMARY KEY (banners_history_id)
5757 );
5858
59-//DROP TABLE categories;
59+--DROP TABLE categories;
6060 CREATE TABLE categories (
6161 categories_id int NOT NULL GENERATED ALWAYS AS IDENTITY
6262 (START WITH 1, INCREMENT BY 1),
@@ -68,7 +68,7 @@
6868 PRIMARY KEY (categories_id)
6969 );
7070
71-//DROP TABLE categories_description;
71+--DROP TABLE categories_description;
7272 CREATE TABLE categories_description (
7373 categories_id int DEFAULT 0 NOT NULL,
7474 language_id int DEFAULT 1 NOT NULL,
@@ -76,7 +76,7 @@
7676 PRIMARY KEY (categories_id, language_id)
7777 );
7878
79-//DROP TABLE configuration;
79+--DROP TABLE configuration;
8080 CREATE TABLE configuration (
8181 configuration_id int NOT NULL,
8282 configuration_title varchar(64) NOT NULL,
@@ -92,7 +92,7 @@
9292 PRIMARY KEY (configuration_id)
9393 );
9494
95-//DROP TABLE configuration_group;
95+--DROP TABLE configuration_group;
9696 CREATE TABLE configuration_group (
9797 configuration_group_id int NOT NULL,
9898 configuration_group_title varchar(64) NOT NULL,
@@ -102,19 +102,19 @@
102102 PRIMARY KEY (configuration_group_id)
103103 );
104104
105-//DROP TABLE counter;
105+--DROP TABLE counter;
106106 CREATE TABLE counter (
107107 startdate char(8),
108108 counter int
109109 );
110110
111-//DROP TABLE counter_history;
111+--DROP TABLE counter_history;
112112 CREATE TABLE counter_history (
113113 month char(8),
114114 counter int
115115 );
116116
117-//DROP TABLE countries;
117+--DROP TABLE countries;
118118 CREATE TABLE countries (
119119 countries_id int NOT NULL,
120120 countries_name varchar(64) NOT NULL,
@@ -124,7 +124,7 @@
124124 PRIMARY KEY (countries_id)
125125 );
126126
127-//DROP TABLE currencies;
127+--DROP TABLE currencies;
128128 CREATE TABLE currencies (
129129 currencies_id int NOT NULL,
130130 title varchar(32) NOT NULL,
@@ -139,7 +139,7 @@
139139 PRIMARY KEY (currencies_id)
140140 );
141141
142-//DROP TABLE customers;
142+--DROP TABLE customers;
143143 CREATE TABLE customers (
144144 customers_id int NOT NULL GENERATED ALWAYS AS IDENTITY
145145 (START WITH 1, INCREMENT BY 1),
@@ -158,7 +158,7 @@
158158 );
159159
160160
161-//DROP TABLE customers_basket;
161+--DROP TABLE customers_basket;
162162 CREATE TABLE customers_basket (
163163 customers_basket_id int NOT NULL,
164164 customers_id int NOT NULL,
@@ -169,7 +169,7 @@
169169 PRIMARY KEY (customers_basket_id)
170170 );
171171
172-//DROP TABLE customers_basket_attributes;
172+--DROP TABLE customers_basket_attributes;
173173 CREATE TABLE customers_basket_attributes (
174174 customers_basket_attributes_id int NOT NULL,
175175 customers_id int NOT NULL,
@@ -179,7 +179,7 @@
179179 PRIMARY KEY (customers_basket_attributes_id)
180180 );
181181
182-//DROP TABLE customers_info;
182+--DROP TABLE customers_info;
183183 CREATE TABLE customers_info (
184184 customers_info_id int NOT NULL,
185185 customers_info_date_of_last_logon TIMESTAMP,
@@ -190,7 +190,7 @@
190190 PRIMARY KEY (customers_info_id)
191191 );
192192
193-//DROP TABLE languages;
193+--DROP TABLE languages;
194194 CREATE TABLE languages (
195195 languages_id int NOT NULL,
196196 name varchar(32) NOT NULL,
@@ -202,7 +202,7 @@
202202 );
203203
204204
205-//DROP TABLE manufacturers;
205+--DROP TABLE manufacturers;
206206 CREATE TABLE manufacturers (
207207 manufacturers_id int NOT NULL GENERATED ALWAYS AS IDENTITY
208208 (START WITH 1, INCREMENT BY 1),
@@ -213,7 +213,7 @@
213213 PRIMARY KEY (manufacturers_id)
214214 );
215215
216-//DROP TABLE manufacturers_info;
216+--DROP TABLE manufacturers_info;
217217 CREATE TABLE manufacturers_info (
218218 manufacturers_id int NOT NULL,
219219 languages_id int NOT NULL,
@@ -225,7 +225,7 @@
225225 PRIMARY KEY (manufacturers_id, languages_id)
226226 );
227227
228-//DROP TABLE newsletters;
228+--DROP TABLE newsletters;
229229 CREATE TABLE newsletters (
230230 newsletters_id int NOT NULL,
231231 title varchar(255) NOT NULL,
@@ -238,7 +238,7 @@
238238 PRIMARY KEY (newsletters_id)
239239 );
240240
241-//DROP TABLE products;
241+--DROP TABLE products;
242242 CREATE TABLE products (
243243 products_id int NOT NULL GENERATED ALWAYS AS IDENTITY
244244 (START WITH 1, INCREMENT BY 1),
@@ -258,7 +258,7 @@
258258 FOREIGN KEY (manufacturers_id) REFERENCES manufacturers (manufacturers_id)
259259 );
260260
261-//DROP TABLE products_attributes;
261+--DROP TABLE products_attributes;
262262 CREATE TABLE products_attributes (
263263 products_attributes_id int NOT NULL GENERATED ALWAYS AS IDENTITY
264264 (START WITH 1, INCREMENT BY 1),
@@ -270,7 +270,7 @@
270270 PRIMARY KEY (products_attributes_id)
271271 );
272272
273-//DROP TABLE products_attributes_download;
273+--DROP TABLE products_attributes_download;
274274 CREATE TABLE products_attributes_download (
275275 products_attributes_id int NOT NULL,
276276 products_attributes_filename varchar(255) NOT NULL default '',
@@ -279,7 +279,7 @@
279279 PRIMARY KEY (products_attributes_id)
280280 );
281281
282-//DROP TABLE products_description;
282+--DROP TABLE products_description;
283283 CREATE TABLE products_description (
284284 products_id int NOT NULL,
285285 language_id int NOT NULL default 1,
@@ -292,7 +292,7 @@
292292 );
293293
294294
295-//DROP TABLE products_notifications;
295+--DROP TABLE products_notifications;
296296 CREATE TABLE products_notifications (
297297 products_id int NOT NULL,
298298 customers_id int NOT NULL,
@@ -300,7 +300,7 @@
300300 PRIMARY KEY (products_id, customers_id)
301301 );
302302
303-//DROP TABLE products_options;
303+--DROP TABLE products_options;
304304 CREATE TABLE products_options (
305305 products_options_id int NOT NULL default 0,
306306 language_id int NOT NULL default 1,
@@ -308,7 +308,7 @@
308308 PRIMARY KEY (products_options_id,language_id)
309309 );
310310
311-//DROP TABLE products_options_values;
311+--DROP TABLE products_options_values;
312312 CREATE TABLE products_options_values (
313313 products_options_values_id int NOT NULL default 0,
314314 language_id int NOT NULL default 1,
@@ -316,7 +316,7 @@
316316 PRIMARY KEY (products_options_values_id,language_id)
317317 );
318318
319-//DROP TABLE products_options_values_to_products_options;
319+--DROP TABLE products_options_values_to_products_options;
320320 CREATE TABLE products_options_values_to_products_options (
321321 products_options_values_to_products_options_id int NOT NULL,
322322 products_options_id int NOT NULL,
@@ -324,7 +324,7 @@
324324 PRIMARY KEY (products_options_values_to_products_options_id)
325325 );
326326
327-//DROP TABLE products_to_categories;
327+--DROP TABLE products_to_categories;
328328 CREATE TABLE products_to_categories (
329329 products_id int NOT NULL,
330330 categories_id int NOT NULL,
@@ -333,7 +333,7 @@
333333 FOREIGN KEY (products_id) REFERENCES products (products_id)
334334 );
335335
336-//DROP TABLE orders;
336+--DROP TABLE orders;
337337 CREATE TABLE orders (
338338 orders_id int NOT NULL GENERATED ALWAYS AS IDENTITY
339339 (START WITH 1, INCREMENT BY 1),
@@ -387,7 +387,7 @@
387387 PRIMARY KEY (orders_id)
388388 );
389389
390-//DROP TABLE orders_products;
390+--DROP TABLE orders_products;
391391 CREATE TABLE orders_products (
392392 orders_products_id int NOT NULL GENERATED ALWAYS AS IDENTITY
393393 (START WITH 1, INCREMENT BY 1),
@@ -404,7 +404,7 @@
404404 FOREIGN KEY (products_id) REFERENCES products (products_id)
405405 );
406406
407-//DROP TABLE orders_status;
407+--DROP TABLE orders_status;
408408 CREATE TABLE orders_status (
409409 orders_status_id int DEFAULT 0 NOT NULL,
410410 language_id int DEFAULT 1 NOT NULL,
@@ -412,7 +412,7 @@
412412 PRIMARY KEY (orders_status_id, language_id)
413413 );
414414
415-//DROP TABLE orders_status_history;
415+--DROP TABLE orders_status_history;
416416 CREATE TABLE orders_status_history (
417417 orders_status_history_id int NOT NULL,
418418 orders_id int NOT NULL,
@@ -423,7 +423,7 @@
423423 PRIMARY KEY (orders_status_history_id)
424424 );
425425
426-//DROP TABLE orders_products_attributes;
426+--DROP TABLE orders_products_attributes;
427427 CREATE TABLE orders_products_attributes (
428428 orders_products_attributes_id int NOT NULL,
429429 orders_id int NOT NULL,
@@ -435,7 +435,7 @@
435435 PRIMARY KEY (orders_products_attributes_id)
436436 );
437437
438-//DROP TABLE orders_products_download;
438+--DROP TABLE orders_products_download;
439439 CREATE TABLE orders_products_download (
440440 orders_products_download_id int NOT NULL,
441441 orders_id int NOT NULL default 0,
@@ -446,7 +446,7 @@
446446 PRIMARY KEY (orders_products_download_id)
447447 );
448448
449-//DROP TABLE orders_total;
449+--DROP TABLE orders_total;
450450 CREATE TABLE orders_total (
451451 orders_total_id int NOT NULL,
452452 orders_id int NOT NULL,
@@ -458,7 +458,7 @@
458458 PRIMARY KEY (orders_total_id)
459459 );
460460
461-//DROP TABLE delivery_method;
461+--DROP TABLE delivery_method;
462462 CREATE TABLE delivery_method (
463463 delivery_method_id int NOT NULL GENERATED ALWAYS AS IDENTITY
464464 (START WITH 1, INCREMENT BY 1),
@@ -468,7 +468,7 @@
468468 PRIMARY KEY (categories_id)
469469 );
470470
471-//DROP TABLE delivery_method_description;
471+--DROP TABLE delivery_method_description;
472472 CREATE TABLE delivery_method_description (
473473 delivery_method_id int DEFAULT 0 NOT NULL,
474474 language_id int DEFAULT 1 NOT NULL,
@@ -477,7 +477,7 @@
477477 );
478478
479479
480-//DROP TABLE reviews;
480+--DROP TABLE reviews;
481481 CREATE TABLE reviews (
482482 reviews_id int NOT NULL,
483483 products_id int NOT NULL,
@@ -490,7 +490,7 @@
490490 PRIMARY KEY (reviews_id)
491491 );
492492
493-//DROP TABLE reviews_description;
493+--DROP TABLE reviews_description;
494494 CREATE TABLE reviews_description (
495495 reviews_id int NOT NULL,
496496 languages_id int NOT NULL,
@@ -498,7 +498,7 @@
498498 PRIMARY KEY (reviews_id, languages_id)
499499 );
500500
501-//DROP TABLE sessions;
501+--DROP TABLE sessions;
502502 CREATE TABLE sessions (
503503 sesskey varchar(32) NOT NULL,
504504 expiry int NOT NULL,
@@ -506,7 +506,7 @@
506506 PRIMARY KEY (sesskey)
507507 );
508508
509-//DROP TABLE specials;
509+--DROP TABLE specials;
510510 CREATE TABLE specials (
511511 specials_id int NOT NULL,
512512 products_id int NOT NULL,
@@ -519,7 +519,7 @@
519519 PRIMARY KEY (specials_id)
520520 );
521521
522-//DROP TABLE tax_class;
522+--DROP TABLE tax_class;
523523 CREATE TABLE tax_class (
524524 tax_class_id int NOT NULL,
525525 tax_class_title varchar(32) NOT NULL,
@@ -529,7 +529,7 @@
529529 PRIMARY KEY (tax_class_id)
530530 );
531531
532-//DROP TABLE tax_rates;
532+--DROP TABLE tax_rates;
533533 CREATE TABLE tax_rates (
534534 tax_rates_id int NOT NULL,
535535 tax_zone_id int NOT NULL,
@@ -542,7 +542,7 @@
542542 PRIMARY KEY (tax_rates_id)
543543 );
544544
545-//DROP TABLE geo_zones;
545+--DROP TABLE geo_zones;
546546 CREATE TABLE geo_zones (
547547 geo_zone_id int NOT NULL,
548548 geo_zone_name varchar(32) NOT NULL,
@@ -552,7 +552,7 @@
552552 PRIMARY KEY (geo_zone_id)
553553 );
554554
555-//DROP TABLE whos_online;
555+--DROP TABLE whos_online;
556556 CREATE TABLE whos_online (
557557 customer_id int,
558558 full_name varchar(64) NOT NULL,
@@ -563,7 +563,7 @@
563563 last_page_url varchar(255) NOT NULL
564564 );
565565
566-//DROP TABLE zones;
566+--DROP TABLE zones;
567567 CREATE TABLE zones (
568568 zone_id int NOT NULL,
569569 zone_country_id int NOT NULL,
@@ -572,7 +572,7 @@
572572 PRIMARY KEY (zone_id)
573573 );
574574
575-//DROP TABLE zones_to_geo_zones;
575+--DROP TABLE zones_to_geo_zones;
576576 CREATE TABLE zones_to_geo_zones (
577577 association_id int NOT NULL,
578578 zone_country_id int NOT NULL,
Show on old repository browser