Changeset 12123

Timestamp:

2007/04/09 13:42:13 (17 years ago)

Author:

kakinaka

Message:

dtb_site_control を NULL許可に変更

Location:

branches/dev/html/install/sql/add

Files:

• dtb_site_control_mysql.sql (modified) (1 diff)
• dtb_site_control_pgsql.sql (modified) (1 diff)

branches/dev/html/install/sql/add/dtb_site_control_mysql.sql

@@ -1 +1 @@
 CREATE TABLE dtb_site_control (
     control_id int auto_increment NOT NULL,
-    control_title varchar(255) NOT NULL DEFAULT '',
-    control_text text NOT NULL DEFAULT '',
+    control_title varchar(255) ,
+    control_text text ,
     control_flg int NOT NULL DEFAULT 2,
     del_flg int NOT NULL DEFAULT 0,
-    memo text NOT NULL DEFAULT '',
+    memo text ,
     create_date datetime NOT NULL,
     update_date datetime NOT NULL,

branches/dev/html/install/sql/add/dtb_site_control_pgsql.sql

@@ -1 +1 @@
 CREATE TABLE dtb_site_control (
     control_id serial primary key NOT NULL,
-    control_title text NOT NULL DEFAULT '',
-    control_text text NOT NULL DEFAULT '',
+    control_title text ,
+    control_text text ,
     control_flg int2 NOT NULL DEFAULT 2,
     del_flg int2 NOT NULL DEFAULT 0,
-    memo text NOT NULL DEFAULT '',
+    memo text ,
     create_date timestamp NOT NULL DEFAULT now(),
     update_date timestamp NOT NULL DEFAULT now()