comparison: setup/postgres/psql_create_tables.sql
setup/postgres/psql_create_tables.sql
- changeset 360
- f60ecdc0431f
- parent 350
- c676c200534d
equal
deleted
inserted
replaced
| 359:842bb8976b0f | 360:f60ecdc0431f |
|---|---|
| 184 | 184 |
| 185 create unique index lpit_issue_relation_unique on lpit_issue_relation (from_issue, to_issue, type); | 185 create unique index lpit_issue_relation_unique on lpit_issue_relation (from_issue, to_issue, type); |
| 186 | 186 |
| 187 create table lpit_commit_ref | 187 create table lpit_commit_ref |
| 188 ( | 188 ( |
| 189 issueid integer not null references lpit_issue (issueid) on delete cascade, | 189 issueid integer not null references lpit_issue (issueid) on delete cascade, |
| 190 commit_hash text not null, | 190 commit_hash text not null, |
| 191 commit_brief text not null | 191 commit_brief text not null, |
| 192 commit_time timestamp with time zone null -- optional feature added with Lightpit 1.5.0 | |
| 192 ); | 193 ); |
| 193 | 194 |
| 194 create unique index lpit_commit_ref_unique on lpit_commit_ref (issueid, commit_hash); | 195 create unique index lpit_commit_ref_unique on lpit_commit_ref (issueid, commit_hash); |
| 195 | 196 |
| 196 create table lpit_issue_variant_status | 197 create table lpit_issue_variant_status |
