Changeset 12123


Ignore:
Timestamp:
2007/04/09 13:42:13 (15 years ago)
Author:
kakinaka
Message:

dtb_site_control を NULL許可に変更

Location:
branches/dev/html/install/sql/add
Files:
2 edited

Legend:

Unmodified
Added
Removed
  • branches/dev/html/install/sql/add/dtb_site_control_mysql.sql

    r12017 r12123  
    11CREATE TABLE dtb_site_control ( 
    22    control_id int auto_increment NOT NULL, 
    3     control_title varchar(255) NOT NULL DEFAULT '', 
    4     control_text text NOT NULL DEFAULT '', 
     3    control_title varchar(255) , 
     4    control_text text , 
    55    control_flg int NOT NULL DEFAULT 2, 
    66    del_flg int NOT NULL DEFAULT 0, 
    7     memo text NOT NULL DEFAULT '', 
     7    memo text , 
    88    create_date datetime NOT NULL, 
    99    update_date datetime NOT NULL, 
  • branches/dev/html/install/sql/add/dtb_site_control_pgsql.sql

    r12017 r12123  
    11CREATE TABLE dtb_site_control ( 
    22    control_id serial primary key NOT NULL, 
    3     control_title text NOT NULL DEFAULT '', 
    4     control_text text NOT NULL DEFAULT '', 
     3    control_title text , 
     4    control_text text , 
    55    control_flg int2 NOT NULL DEFAULT 2, 
    66    del_flg int2 NOT NULL DEFAULT 0, 
    7     memo text NOT NULL DEFAULT '', 
     7    memo text , 
    88    create_date timestamp NOT NULL DEFAULT now(), 
    99    update_date timestamp NOT NULL DEFAULT now() 
Note: See TracChangeset for help on using the changeset viewer.