Line # Revision Author
1 234 ahitrov create table blog_members
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 btime timestamp not null default now(),
8 etime timestamp not null default now(),
9 status smallint not null default 1,
10 source_id integer not null,
11 moderator smallint default 0,
12 temporary smallint default 0,
13 dest_id integer not null,
14 dest_class text not null default 'blogs::Blog',
15 data text
16 );
17 create index blog_members_source on blog_members (source_id);
18 create index blog_members_dest on blog_members (dest_id);