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 | 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 != ''; |