comparison: setup/postgres/psql_create_tables.sql
setup/postgres/psql_create_tables.sql
- changeset 88
- 1438e5a22c55
- parent 85
- 3d16ad54b3dc
- child 124
- ed2e7aef2a3e
equal
deleted
inserted
replaced
| 87:501addad452b | 88:1438e5a22c55 |
|---|---|
| 75 issueid integer references lpit_issue(issueid), | 75 issueid integer references lpit_issue(issueid), |
| 76 versionid integer references lpit_version(versionid), | 76 versionid integer references lpit_version(versionid), |
| 77 primary key (issueid, versionid) | 77 primary key (issueid, versionid) |
| 78 ); | 78 ); |
| 79 | 79 |
| 80 create table lpit_issue_scheduled_version ( | |
| 81 issueid integer references lpit_issue(issueid), | |
| 82 versionid integer references lpit_version(versionid), | |
| 83 primary key (issueid, versionid) | |
| 84 ); | |
| 85 | |
| 86 create table lpit_issue_resolved_version ( | 80 create table lpit_issue_resolved_version ( |
| 87 issueid integer references lpit_issue(issueid), | 81 issueid integer references lpit_issue(issueid), |
| 88 versionid integer references lpit_version(versionid), | 82 versionid integer references lpit_version(versionid), |
| 89 primary key (issueid, versionid) | 83 primary key (issueid, versionid) |
| 90 ); | 84 ); |
