Sun, 23 Jul 2023 18:17:03 +0200
add SQL patch script
relates to #276
universe@285 | 1 | -- apply this script to patch a version 1.0.x database to 1.1.0 |
universe@285 | 2 | |
universe@285 | 3 | create table lpit_commit_ref |
universe@285 | 4 | ( |
universe@285 | 5 | issueid integer not null references lpit_issue (issueid) on delete cascade, |
universe@285 | 6 | commit_hash text not null, |
universe@285 | 7 | commit_brief text not null |
universe@285 | 8 | ); |
universe@285 | 9 | create unique index lpit_commit_ref_unique on lpit_commit_ref (issueid, commit_hash); |
universe@285 | 10 | create type vcstype as enum ('None', 'Mercurial', 'Git'); |
universe@285 | 11 | alter table lpit_project add column vcs vcstype not null default 'None'::vcstype; |