Line # Revision Author
1 3 ahitrov@rambler.ru create table pid (
2 id integer default nextval('documents_id_seq'::regclass) not null,
3 mutex bigint not null,
4 host text,
5 state integer not null default 0,
6 script text,
7 pid integer,
8 started timestamp without time zone,
9 finished timestamp without time zone,
10 ctime timestamp without time zone default ('now'::text)::timestamp(0) without time zone
11 );
12 alter table only pid add constraint pid_pkey primary key (id);
13 create index pid_idx1 on pid using btree (mutex, state);