Mercurial > hg > LightPIT / file diff

--- a/setup/postgres/psql_create_tables.sql	Sun May 24 15:30:43 2020 +0200
+++ b/setup/postgres/psql_create_tables.sql	Sat May 30 15:26:15 2020 +0200
@@ -41,7 +41,8 @@
     'InReview',
     'Done',
     'Rejected',
-    'Withdrawn'
+    'Withdrawn',
+    'Duplicate'
 );
 
 create type issue_category as enum (
@@ -52,6 +53,11 @@
     'Test'
 );
 
+create table lpit_issue_phases (
+    status          issue_status    primary key,
+    phase           integer         not null
+);
+
 create table lpit_issue (
     issueid         serial          primary key,
     project         integer         not null references lpit_project(projectid),