source: branches/comu/html/install/sql/add/dtb_site_control_mysql.sql @ 11983

Revision 11983, 778 bytes checked in by uehara, 17 years ago (diff)
Line 
1CREATE TABLE dtb_site_control (
2    control_id int auto_increment NOT NULL,
3    control_title varchar(255) NOT NULL DEFAULT '',
4    control_text text NOT NULL DEFAULT '',
5    control_flg int NOT NULL DEFAULT 2,
6    del_flg int NOT NULL DEFAULT 0,
7    memo text NOT NULL DEFAULT '',
8    create_date datetime NOT NULL,
9    update_date datetime NOT NULL,
10    PRIMARY KEY  (control_id)
11) TYPE=InnoDB;
12
13INSERT INTO dtb_site_control (control_title, control_text, create_date, update_date) VALUES('¥È¥é¥Ã¥¯¥Ð¥Ã¥¯µ¡Ç½', '¥È¥é¥Ã¥¯¥Ð¥Ã¥¯µ¡Ç½¤ò»ÈÍѤ¹¤ë¤«¤É¤¦¤«¤ò·èÄꤷ¤Þ¤¹¡£', NOW(), NOW());
14INSERT INTO dtb_site_control (control_title, control_text, create_date, update_date) VALUES('¥¢¥Õ¥£¥ê¥¨¥¤¥Èµ¡Ç½', '¥¢¥Õ¥£¥ê¥¨¥¤¥Èµ¡Ç½¤ò»ÈÍѤ¹¤ë¤«¤É¤¦¤«¤ò·èÄꤷ¤Þ¤¹¡£', NOW(), NOW());
Note: See TracBrowser for help on using the repository browser.