Line | |
---|
1 | CREATE 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 |
|
---|
13 | INSERT 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.