comparison: setup/postgres/psql_patch_1.5.0.sql
setup/postgres/psql_patch_1.5.0.sql
- changeset 348
- 1dc9c405e9e2
- parent 347
- d1edd8d9c8a1
equal
deleted
inserted
replaced
| 347:d1edd8d9c8a1 | 348:1dc9c405e9e2 |
|---|---|
| 14 description text, | 14 description text, |
| 15 active boolean not null default true | 15 active boolean not null default true |
| 16 ); | 16 ); |
| 17 | 17 |
| 18 create unique index lpit_variant_node_unique on lpit_variant (project, node); | 18 create unique index lpit_variant_node_unique on lpit_variant (project, node); |
| 19 | |
| 20 create table lpit_issue_variant_status | |
| 21 ( | |
| 22 issueid integer not null references lpit_issue (issueid), | |
| 23 variant integer not null references lpit_variant (id), | |
| 24 status issue_status not null default 'InSpecification', | |
| 25 primary key (issueid, variant) | |
| 26 ); |
