Changeset 17522 for branches/comu-ver2/html

Timestamp:

2008/08/11 23:28:34 (16 years ago)

Author:

Seasoft

Message:

stock_unlimited に NULL が代入され、stock_unlimited_min 及び stock_unlimited_max が不当な値になるのを回避。また、予防処置としてテーブル定義に NOT NULL 制約を追加。

Location:

branches/comu-ver2/html/install/sql

Files:

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

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

@@ -337 +337 @@
     product_code text,
     stock numeric,
-    stock_unlimited smallint DEFAULT 0,
+    stock_unlimited smallint NOT NULL DEFAULT 0,
     sale_limit numeric,
     price01 numeric,

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

@@ -347 +347 @@
     product_code text,
     stock numeric,
-    stock_unlimited int2 DEFAULT 0,
+    stock_unlimited int2 NOT NULL DEFAULT 0,
     sale_limit numeric,
     price01 numeric,