Sun, 23 Jul 2023 18:17:03 +0200
add SQL patch script
relates to #276
1 -- apply this script to patch a version 1.0.x database to 1.1.0
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;