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