comparison: setup/postgres/psql_create_tables.sql
setup/postgres/psql_create_tables.sql
- changeset 242
- b7f3e972b13c
- parent 241
- 1ca4f27cefe8
- child 252
- 90f5e12c7623
equal
deleted
inserted
replaced
| 241:1ca4f27cefe8 | 242:b7f3e972b13c |
|---|---|
| 110 | 110 |
| 111 create table lpit_issue_history_event | 111 create table lpit_issue_history_event |
| 112 ( | 112 ( |
| 113 eventid serial primary key, | 113 eventid serial primary key, |
| 114 issueid integer not null references lpit_issue (issueid) on delete cascade, | 114 issueid integer not null references lpit_issue (issueid) on delete cascade, |
| 115 subject text not null, | |
| 115 time timestamp with time zone not null default now(), | 116 time timestamp with time zone not null default now(), |
| 116 type issue_history_event not null | 117 type issue_history_event not null |
| 117 ); | 118 ); |
| 118 | 119 |
| 119 create table lpit_issue_history_data | 120 create table lpit_issue_history_data |
| 120 ( | 121 ( |
| 121 eventid integer not null references lpit_issue_history_event (eventid) on delete cascade, | 122 eventid integer not null references lpit_issue_history_event (eventid) on delete cascade, |
| 122 component text, | 123 component text, |
| 123 status issue_status not null, | 124 status issue_status not null, |
| 124 category issue_category not null, | 125 category issue_category not null, |
| 125 subject text not null, | |
| 126 description text, | 126 description text, |
| 127 assignee text, | 127 assignee text, |
| 128 eta date, | 128 eta date, |
| 129 affected text, | 129 affected text, |
| 130 resolved text | 130 resolved text |
