Sun, 23 Jul 2023 18:17:03 +0200
add SQL patch script
relates to #276
setup/postgres/psql_patch_1.1.0.sql | file | annotate | diff | comparison | revisions |
1.1 --- /dev/null Thu Jan 01 00:00:00 1970 +0000 1.2 +++ b/setup/postgres/psql_patch_1.1.0.sql Sun Jul 23 18:17:03 2023 +0200 1.3 @@ -0,0 +1,11 @@ 1.4 +-- apply this script to patch a version 1.0.x database to 1.1.0 1.5 + 1.6 +create table lpit_commit_ref 1.7 +( 1.8 + issueid integer not null references lpit_issue (issueid) on delete cascade, 1.9 + commit_hash text not null, 1.10 + commit_brief text not null 1.11 +); 1.12 +create unique index lpit_commit_ref_unique on lpit_commit_ref (issueid, commit_hash); 1.13 +create type vcstype as enum ('None', 'Mercurial', 'Git'); 1.14 +alter table lpit_project add column vcs vcstype not null default 'None'::vcstype;