comparison: setup/postgres/psql_create_tables.sql
setup/postgres/psql_create_tables.sql
- changeset 345
- 7a515768c481
- parent 284
- 671c1c8fbf1c
equal
deleted
inserted
replaced
| 344:7280393d1fa7 | 345:7a515768c481 |
|---|---|
| 111 | 111 |
| 112 create table lpit_issue_history_event | 112 create table lpit_issue_history_event |
| 113 ( | 113 ( |
| 114 eventid serial primary key, | 114 eventid serial primary key, |
| 115 issueid integer not null references lpit_issue (issueid) on delete cascade, | 115 issueid integer not null references lpit_issue (issueid) on delete cascade, |
| 116 userid integer null references lpit_user (userid) on delete set null, | |
| 116 subject text not null, | 117 subject text not null, |
| 117 time timestamp with time zone not null default now(), | 118 time timestamp with time zone not null default now(), |
| 118 type issue_history_event not null | 119 type issue_history_event not null |
| 119 ); | 120 ); |
| 120 | 121 |
