Revision 11970,
678 bytes
checked in by inoue, 17 years ago
(diff) |
サイト管理テーブル(PostgreSQL)
|
Line | |
---|
1 | CREATE TABLE dtb_site_control (
|
---|
2 | control_id serial primary key NOT NULL,
|
---|
3 | control_title text NOT NULL DEFAULT '',
|
---|
4 | control_text text NOT NULL DEFAULT '',
|
---|
5 | control_flg int2 NOT NULL DEFAULT 2,
|
---|
6 | del_flg int2 NOT NULL DEFAULT 0,
|
---|
7 | memo text NOT NULL DEFAULT '',
|
---|
8 | create_date timestamp NOT NULL DEFAULT now(),
|
---|
9 | update_date timestamp NOT NULL DEFAULT now()
|
---|
10 | );
|
---|
11 |
|
---|
12 | INSERT INTO dtb_site_control (control_title, control_text) VALUES('¥È¥é¥Ã¥¯¥Ð¥Ã¥¯µ¡Ç½', '¥È¥é¥Ã¥¯¥Ð¥Ã¥¯µ¡Ç½¤ò»ÈÍѤ¹¤ë¤«¤É¤¦¤«¤ò·èÄꤷ¤Þ¤¹¡£');
|
---|
13 | INSERT INTO dtb_site_control (control_title, control_text) VALUES('¥¢¥Õ¥£¥ê¥¨¥¤¥Èµ¡Ç½', '¥¢¥Õ¥£¥ê¥¨¥¤¥Èµ¡Ç½¤ò»ÈÍѤ¹¤ë¤«¤É¤¦¤«¤ò·èÄꤷ¤Þ¤¹¡£');
|
---|
Note: See
TracBrowser
for help on using the repository browser.