comparison: setup/postgres/psql_create_tables.sql
setup/postgres/psql_create_tables.sql
- changeset 231
- dcb1d5a7ea3a
- parent 227
- f0ede8046b59
- child 232
- 296e12ff8d1c
equal
deleted
inserted
replaced
| 230:95b419e054fa | 231:dcb1d5a7ea3a |
|---|---|
| 94 subject text not null, | 94 subject text not null, |
| 95 description text, | 95 description text, |
| 96 assignee integer references lpit_user (userid), | 96 assignee integer references lpit_user (userid), |
| 97 created timestamp with time zone not null default now(), | 97 created timestamp with time zone not null default now(), |
| 98 updated timestamp with time zone not null default now(), | 98 updated timestamp with time zone not null default now(), |
| 99 eta date | 99 eta date, |
| 100 ); | 100 affected integer references lpit_version (versionid), |
| 101 | 101 resolved integer references lpit_version (versionid) |
| 102 create table lpit_issue_affected_version | |
| 103 ( | |
| 104 issueid integer references lpit_issue (issueid), | |
| 105 versionid integer references lpit_version (versionid), | |
| 106 primary key (issueid, versionid) | |
| 107 ); | |
| 108 | |
| 109 create table lpit_issue_resolved_version | |
| 110 ( | |
| 111 issueid integer references lpit_issue (issueid), | |
| 112 versionid integer references lpit_version (versionid), | |
| 113 primary key (issueid, versionid) | |
| 114 ); | 102 ); |
| 115 | 103 |
| 116 create table lpit_issue_comment | 104 create table lpit_issue_comment |
| 117 ( | 105 ( |
| 118 commentid serial primary key, | 106 commentid serial primary key, |
