Changeset 17864 for branches/comu-ver2/html

Timestamp:

2009/03/04 20:48:14 (15 years ago)

Author:

Seasoft

Message:

プログラム上の必須列を NOT NULL に変更。

Location:

branches/comu-ver2/html/install/sql

Files:

• create_table_mysql.sql (modified) (2 diffs)
• create_table_pgsql.sql (modified) (2 diffs)

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

@@ -124 +124 @@
     law_term09 text,
     law_term10 text,
-    tax numeric DEFAULT 5,
-    tax_rule smallint DEFAULT 1,
+    tax numeric NOT NULL DEFAULT 5,
+    tax_rule smallint NOT NULL DEFAULT 1,
     email01 text,
     email02 text,
@@ -134 +134 @@
     shop_name text,
     shop_kana text,
-    point_rate numeric,
-    welcome_point numeric,
+    point_rate numeric NOT NULL DEFAULT 0,
+    welcome_point numeric NOT NULL DEFAULT 0,
     update_date datetime,
     top_tpl text,

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

@@ -127 +127 @@
     law_term09 text,
     law_term10 text,
-    tax numeric DEFAULT 5,
-    tax_rule int2 DEFAULT 1,
+    tax numeric NOT NULL DEFAULT 5,
+    tax_rule int2 NOT NULL DEFAULT 1,
     email01 text,
     email02 text,
@@ -137 +137 @@
     shop_name text,
     shop_kana text,
-    point_rate numeric,
-    welcome_point numeric,
+    point_rate numeric NOT NULL DEFAULT 0,
+    welcome_point numeric NOT NULL DEFAULT 0,
     update_date timestamp,
     top_tpl text,