--- /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;