comparison: setup/postgres/psql_patch_1.1.0.sql
setup/postgres/psql_patch_1.1.0.sql
- changeset 285
- 8da71efbaa35
equal
deleted
inserted
replaced
| 284:671c1c8fbf1c | 285:8da71efbaa35 |
|---|---|
| 1 -- apply this script to patch a version 1.0.x database to 1.1.0 | |
| 2 | |
| 3 create table lpit_commit_ref | |
| 4 ( | |
| 5 issueid integer not null references lpit_issue (issueid) on delete cascade, | |
| 6 commit_hash text not null, | |
| 7 commit_brief text not null | |
| 8 ); | |
| 9 create unique index lpit_commit_ref_unique on lpit_commit_ref (issueid, commit_hash); | |
| 10 create type vcstype as enum ('None', 'Mercurial', 'Git'); | |
| 11 alter table lpit_project add column vcs vcstype not null default 'None'::vcstype; |
