comparison: setup/postgres/psql_create_tables.sql
setup/postgres/psql_create_tables.sql
- changeset 239
- 9365c7fb0240
- parent 232
- 296e12ff8d1c
- child 241
- 1ca4f27cefe8
equal
deleted
inserted
replaced
| 238:1d48b38ca349 | 239:9365c7fb0240 |
|---|---|
| 116 type issue_history_event not null | 116 type issue_history_event not null |
| 117 ); | 117 ); |
| 118 | 118 |
| 119 create table lpit_issue_history_data | 119 create table lpit_issue_history_data |
| 120 ( | 120 ( |
| 121 eventid integer not null references lpit_issue_history_event (eventid) on delete cascade, | 121 eventid integer not null references lpit_issue_history_event (eventid) on delete cascade, |
| 122 component text, | 122 component text, |
| 123 status issue_status not null, | 123 status issue_status not null, |
| 124 category issue_category not null, | 124 category issue_category not null, |
| 125 subject text not null, | 125 subject text not null, |
| 126 description text, | 126 description text, |
| 127 assignee text, | 127 assignee_username text, |
| 128 eta date, | 128 assignee text, |
| 129 affected text, | 129 eta date, |
| 130 resolved text | 130 affected text, |
| 131 resolved text | |
| 131 ); | 132 ); |
| 132 | 133 |
| 133 create table lpit_issue_comment | 134 create table lpit_issue_comment |
| 134 ( | 135 ( |
| 135 commentid serial primary key, | 136 commentid serial primary key, |
