Changeset 17873 for branches/comu-ver2/html

Timestamp:

2009/03/05 20:45:30 (15 years ago)

Author:

Seasoft

Message:

dtb_category のDDL修正。PostgreSQL ではプライマリキーが存在せず、MySQL ではインデックスが二重に作成される不具合を修正。

Location:

branches/comu-ver2/html/install/sql

Files:

• create_table_pgsql.sql (modified) (1 diff)
• insert_data.sql (modified) (1 diff)

branches/comu-ver2/html/install/sql/create_table_pgsql.sql

@@ -394 +394 @@
     create_date timestamp NOT NULL DEFAULT now(),
     update_date timestamp,
-    del_flg int2 NOT NULL DEFAULT 0
+    del_flg int2 NOT NULL DEFAULT 0,
+    PRIMARY KEY (category_id)
 );
 

branches/comu-ver2/html/install/sql/insert_data.sql

@@ -1 +1 @@
 CREATE INDEX dtb_products_class_product_id_key ON dtb_products_class(product_id);
 CREATE INDEX dtb_order_detail_product_id_key ON dtb_order_detail(product_id);
-CREATE INDEX dtb_category_category_id_key ON dtb_category(category_id);
 
 INSERT INTO dtb_member (name, login_id, password, creator_id, authority, work, del_flg, create_date, update_date)