| Revision 12123,
537 bytes
checked in by kakinaka, 20 years ago
(diff) |
|
dtb_site_control を NULL許可に変更
|
| Line | |
|---|
| 1 | CREATE TABLE dtb_site_control (
|
|---|
| 2 | control_id int auto_increment NOT NULL,
|
|---|
| 3 | control_title varchar(255) ,
|
|---|
| 4 | control_text text ,
|
|---|
| 5 | control_flg int NOT NULL DEFAULT 2,
|
|---|
| 6 | del_flg int NOT NULL DEFAULT 0,
|
|---|
| 7 | memo text ,
|
|---|
| 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.
