Line # Revision Author
1 234 ahitrov create table blog_records
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 uid integer not null,
10 blog_id integer not null,
11 sections integer[],
12 235 ahitrov alias varchar(64),
13 234 ahitrov name text,
14 comments integer default 0,
15 tags text,
16 data text
17 );
18 create index blog_records_sections on blog_records using gist ( "sections" "gist__int_ops" );
19 create index blog_records_dtime on blog_records (dtime);
20 create index blog_records_uid on blog_records (uid);
21 235 ahitrov create index blog_records_alias on blog_records (alias) where alias is not null and alias != '';
22 234 ahitrov create index blog_records_blog_id on blog_records (blog_id);