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); |