
diff -r 3e287f361c7a -r 833e0385572a setup/postgres/psql_create_tables.sql
--- a/setup/postgres/psql_create_tables.sql	Sun May 17 16:38:04 2020 +0200
+++ b/setup/postgres/psql_create_tables.sql	Mon May 18 21:05:57 2020 +0200
@@ -32,3 +32,36 @@
     ordinal         integer         not null default 0,
     status          version_status  not null default 'Future'
 );
+
+create type issue_status as enum (
+    'InSpecification',
+    'ToDo',
+    'Scheduled',
+    'InProgress',
+    'InReview',
+    'Done',
+    'Rejected',
+    'Withdrawn'
+);
+
+create type issue_category as enum (
+    'Feature',
+    'Improvement',
+    'Bug',
+    'Task',
+    'Test'
+);
+
+create table lpit_issue (
+    id              serial          primary key,
+    project         integer         not null references lpit_project(id),
+    status          issue_status    not null default 'InSpecification',
+    category        issue_category  not null default 'Feature',
+    subject         varchar(20)     not null,
+    description     text,
+    version_plan    integer         references lpit_version(id),
+    version_done    integer         references lpit_version(id),
+    created         timestamp       with time zone not null default now(),
+    updated         timestamp       with time zone not null default now(),
+    eta             date
+);




