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 630 ahitrov level integer default 0,
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 630 ahitrov create index tags_pid on tags (pid) WHERE level > 0;