Line # Revision Author
1 474 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 name text,
10 alias text,
11 data text
12 );
13 create index tags_name on tags (name);
14 create index tags_alias on tags (alias) WHERE alias IS NOT NULL AND alias != '';