source: branches/dev/html/install/sql/add/dtb_trackback_pgsql.sql @ 11972

Revision 11972, 397 bytes checked in by inoue, 15 years ago (diff)

トラックバックテーブル(PostgreSQL)

Line 
1CREATE TABLE dtb_trackback (
2    trackback_id serial primary key NOT NULL,
3    product_id int NOT NULL,
4    blog_name varchar(255) NOT NULL DEFAULT '',
5    title varchar(255) NOT NULL DEFAULT '',
6    excerpt text NOT NULL DEFAULT '',
7    url text NOT NULL DEFAULT '',
8    status int2 NOT NULL DEFAULT 2,
9    del_flg int2 NOT NULL DEFAULT 0,
10    create_date timestamp NOT NULL,
11    update_date timestamp NOT NULL
12);
Note: See TracBrowser for help on using the repository browser.