Line # Revision Author
1 234 ahitrov create table blogs
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 sections integer[],
12 235 ahitrov alias varchar(64),
13 234 ahitrov name text,
14 records integer default 0,
15 readers integer[],
16 members integer[],
17 moderators integer[],
18 data text
19 );
20 create index blogs_sections on blogs using gist ( "sections" "gist__int_ops" );
21 create index blogs_members on blogs using gist ( "members" "gist__int_ops" );
22 create index blogs_moderators on blogs using gist ( "moderators" "gist__int_ops" );
23 create index blogs_dtime on blogs (dtime);
24 create index blogs_uid on blogs (uid);