Changeset 21502 for branches/version-2_12-dev/html/install/sql/create_table_pgsql.sql

Timestamp:

2012/02/14 15:10:54 (12 years ago)

Author:

Seasoft

Message:

#1641 (商品規格における木構造の廃止)

File:

• branches/version-2_12-dev/html/install/sql/create_table_pgsql.sql (modified) (2 diffs)

branches/version-2_12-dev/html/install/sql/create_table_pgsql.sql

@@ -305 +305 @@
     product_class_id int NOT NULL,
     product_id int NOT NULL,
-    class_combination_id int,
+    classcategory_id1 int NOT NULL DEFAULT 0,
+    classcategory_id2 int NOT NULL DEFAULT 0,
     product_type_id int NOT NULL DEFAULT 0,
     product_code text,
@@ -345 +346 @@
     del_flg smallint NOT NULL DEFAULT 0,
     PRIMARY KEY (classcategory_id)
-);
-
-CREATE TABLE dtb_class_combination (
-    class_combination_id int NOT NULL,
-    parent_class_combination_id int,
-    classcategory_id int NOT NULL,
-    level int,
-    PRIMARY KEY (class_combination_id)
 );