Line # Revision Author
1 480 ahitrov create table tags
2 (
3 id integer not null primary key default nextval('public.documents_id_seq'::text),
4 ctime timestamp not null default now(),
5 mtime timestamp not null default now(),
6 class text not null,
7 status smallint not null default 0,
8 sections integer,
9 547 ahitrov pid integer default 0,
10 level integer default 1,
11 480 ahitrov name text,
12 alias text,
13 data text
14 );
15 create index tags_name on tags (name);
16 create index tags_alias on tags (alias) WHERE alias IS NOT NULL AND alias != '';
17 547 ahitrov create index tags_pid on tags (pid);