1 |
296 |
ahitrov |
create table events |
2 |
|
|
( |
3 |
|
|
id integer not null primary key default nextval('public.documents_id_seq'::text), |
4 |
|
|
class text not null, |
5 |
|
|
start timestamp not null default now(), |
6 |
|
|
finish timestamp not null default now(), |
7 |
|
|
status smallint not null default 0, |
8 |
|
|
sections integer[], |
9 |
|
|
name text, |
10 |
|
|
data text |
11 |
|
|
); |
12 |
|
|
create index events_sections on events using gist ( "sections" "gist__int_ops" ); |
13 |
|
|
create index events_start on events (start); |
14 |
|
|
create index events_finish on events (finish); |