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