Line # Revision Author
1 296 ahitrov create table companies
2 (
3 id integer not null primary key default nextval('public.documents_id_seq'::text),
4 class text not null,
5 ctime timestamp not null default now(),
6 mtime timestamp not null default now(),
7 dtime timestamp not null default now(),
8 status smallint not null default 0,
9 sections integer[],
10 country text,
11 city text,
12 name text,
13 service integer,
14 rate integer,
15 data text
16 );
17 create index companies_sections on companies using gist ( "sections" "gist__int_ops" );
18 create index companies_city on companies ("city");