Changeset 18916

Timestamp:

2010/11/06 16:04:41 (13 years ago)

Author:

AMUAMU

Message:

商品種別のフィールドのデフォルト値が無い事で他に影響があるため、とりあえずDEFAULTを設定product_type_id

Location:

branches/version-2_5-dev/html/install/sql

Files:

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

branches/version-2_5-dev/html/install/sql/create_table_mysql.sql

@@ -308 +308 @@
     product_id int NOT NULL,
     class_combination_id int,
-    product_type_id smallint NOT NULL,
+    product_type_id smallint NOT NULL DEFAULT 0,
     product_code text,
     stock numeric,

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

@@ -308 +308 @@
     product_id int NOT NULL,
     class_combination_id int,
-    product_type_id int NOT NULL,
+    product_type_id int NOT NULL DEFAULT 0,
     product_code text,
     stock numeric,