Line # Revision Author
1 234 ahitrov create table blog_comments
2 (
3 id integer not null primary key default nextval('public.documents_id_seq'::text),
4 class text not null,
5 ctime timestamp not null default now(),
6 mtime timestamp not null default now(),
7 dtime timestamp not null default now(),
8 status smallint not null default 0,
9 type smallint default 0,
10 uid integer not null,
11 blog_id integer not null,
12 record_id integer not null,
13 pid integer default 0,
14 sections integer[],
15 name text,
16 data text
17 );
18 create index blog_comments_sections on blog_comments using gist ( "sections" "gist__int_ops" );
19 create index blog_comments_dtime on blog_comments (dtime);
20 create index blog_comments_uid on blog_comments (uid);
21 237 ahitrov create index blog_comments_record_id on blog_comments (blog_id, record_id);