comparison: setup/postgres/psql_create_tables.sql
setup/postgres/psql_create_tables.sql
- changeset 124
- ed2e7aef2a3e
- parent 88
- 1438e5a22c55
- child 127
- 6105ee2cceaf
equal
deleted
inserted
replaced
| 123:c27eee1259bd | 124:ed2e7aef2a3e |
|---|---|
| 81 issueid integer references lpit_issue(issueid), | 81 issueid integer references lpit_issue(issueid), |
| 82 versionid integer references lpit_version(versionid), | 82 versionid integer references lpit_version(versionid), |
| 83 primary key (issueid, versionid) | 83 primary key (issueid, versionid) |
| 84 ); | 84 ); |
| 85 | 85 |
| 86 | 86 create table lpit_issue_comment ( |
| 87 commentid serial primary key, | |
| 88 issueid integer not null references lpit_issue(issueid), | |
| 89 userid integer references lpit_user(userid), | |
| 90 created timestamp with time zone not null default now(), | |
| 91 updated timestamp with time zone not null default now(), | |
| 92 updatecount integer not null default 0, | |
| 93 comment text not null | |
| 94 ); |
