Repository List / Contenido / utf8 / samples / promosuite / sql / TOAST / companies.sql @ HEAD

create table companies
(
	id integer not null primary key default nextval('public.documents_id_seq'::text),
	class text not null,
	ctime timestamp not null default now(),
	mtime timestamp not null default now(),
	dtime timestamp not null default now(),
	status smallint not null default 0,
	sections integer[],
	country text,
	city text,
	name text,
	service integer,
	rate integer,
	data text
);
create index companies_sections on companies using gist ( "sections" "gist__int_ops" );
create index companies_city on companies ("city");