source: branches/dev/html/install/sql/add/dtb_site_control_pgsql.sql @ 11970

Revision 11970, 678 bytes checked in by inoue, 17 years ago (diff)

サイト管理テーブル(PostgreSQL)

Line 
1CREATE 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
12INSERT INTO dtb_site_control (control_title, control_text) VALUES('¥È¥é¥Ã¥¯¥Ð¥Ã¥¯µ¡Ç½', '¥È¥é¥Ã¥¯¥Ð¥Ã¥¯µ¡Ç½¤ò»ÈÍѤ¹¤ë¤«¤É¤¦¤«¤ò·èÄꤷ¤Þ¤¹¡£');
13INSERT INTO dtb_site_control (control_title, control_text) VALUES('¥¢¥Õ¥£¥ê¥¨¥¤¥Èµ¡Ç½', '¥¢¥Õ¥£¥ê¥¨¥¤¥Èµ¡Ç½¤ò»ÈÍѤ¹¤ë¤«¤É¤¦¤«¤ò·èÄꤷ¤Þ¤¹¡£');
Note: See TracBrowser for help on using the repository browser.