# HG changeset patch
# User Mike Becker <universe@uap-core.de>
# Date 1690129023 -7200
# Node ID 8da71efbaa352274c22c99d8a1736c56f5bcb11e
# Parent  671c1c8fbf1c98c346f8938da0db428e396786c2
add SQL patch script

relates to #276

diff -r 671c1c8fbf1c -r 8da71efbaa35 setup/postgres/psql_patch_1.1.0.sql
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/setup/postgres/psql_patch_1.1.0.sql	Sun Jul 23 18:17:03 2023 +0200
@@ -0,0 +1,11 @@
+-- apply this script to patch a version 1.0.x database to 1.1.0
+
+create table lpit_commit_ref
+(
+    issueid      integer not null references lpit_issue (issueid) on delete cascade,
+    commit_hash  text    not null,
+    commit_brief text    not null
+);
+create unique index lpit_commit_ref_unique on lpit_commit_ref (issueid, commit_hash);
+create type vcstype as enum ('None', 'Mercurial', 'Git');
+alter table lpit_project add column vcs vcstype not null default 'None'::vcstype;