comparison: setup/postgres/psql_create_tables.sql
setup/postgres/psql_create_tables.sql
- changeset 348
- 1dc9c405e9e2
- parent 347
- d1edd8d9c8a1
equal
deleted
inserted
replaced
| 347:d1edd8d9c8a1 | 348:1dc9c405e9e2 |
|---|---|
| 190 commit_hash text not null, | 190 commit_hash text not null, |
| 191 commit_brief text not null | 191 commit_brief text not null |
| 192 ); | 192 ); |
| 193 | 193 |
| 194 create unique index lpit_commit_ref_unique on lpit_commit_ref (issueid, commit_hash); | 194 create unique index lpit_commit_ref_unique on lpit_commit_ref (issueid, commit_hash); |
| 195 | |
| 196 create table lpit_issue_variant_status | |
| 197 ( | |
| 198 issueid integer not null references lpit_issue (issueid), | |
| 199 variant integer not null references lpit_variant (id), | |
| 200 status issue_status not null default 'InSpecification', | |
| 201 primary key (issueid, variant) | |
| 202 ); |
