1.1 --- a/setup/postgres/psql_create_tables.sql Sun May 24 15:30:43 2020 +0200
1.2 +++ b/setup/postgres/psql_create_tables.sql Sat May 30 15:26:15 2020 +0200
1.3 @@ -41,7 +41,8 @@
1.4 'InReview',
1.5 'Done',
1.6 'Rejected',
1.7 - 'Withdrawn'
1.8 + 'Withdrawn',
1.9 + 'Duplicate'
1.10 );
1.11
1.12 create type issue_category as enum (
1.13 @@ -52,6 +53,11 @@
1.14 'Test'
1.15 );
1.16
1.17 +create table lpit_issue_phases (
1.18 + status issue_status primary key,
1.19 + phase integer not null
1.20 +);
1.21 +
1.22 create table lpit_issue (
1.23 issueid serial primary key,
1.24 project integer not null references lpit_project(projectid),
