
diff -r ea6181255423 -r 671c1c8fbf1c setup/postgres/psql_create_tables.sql
--- a/setup/postgres/psql_create_tables.sql	Sat Jul 22 15:07:23 2023 +0200
+++ b/setup/postgres/psql_create_tables.sql	Sat Jul 22 22:32:04 2023 +0200
@@ -1,6 +1,3 @@
--- This script creates the module management tables
---
-
 create table lpit_user
 (
     userid    serial primary key,
@@ -10,6 +7,8 @@
     givenname text
 );
 
+create type vcstype as enum ('None', 'Mercurial', 'Git');
+
 create table lpit_project
 (
     projectid   serial primary key,
@@ -18,6 +17,7 @@
     ordinal     integer not null default 0,
     description text,
     repoUrl     text,
+    vcs         vcstype not null default 'None'::vcstype,
     owner       integer references lpit_user (userid)
 );
 
@@ -168,3 +168,12 @@
 );
 
 create unique index lpit_issue_relation_unique on lpit_issue_relation (from_issue, to_issue, type);
+
+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);




