1.1 --- a/setup/postgres/psql_create_tables.sql Sun May 17 16:38:04 2020 +0200
1.2 +++ b/setup/postgres/psql_create_tables.sql Mon May 18 21:05:57 2020 +0200
1.3 @@ -32,3 +32,36 @@
1.4 ordinal integer not null default 0,
1.5 status version_status not null default 'Future'
1.6 );
1.7 +
1.8 +create type issue_status as enum (
1.9 + 'InSpecification',
1.10 + 'ToDo',
1.11 + 'Scheduled',
1.12 + 'InProgress',
1.13 + 'InReview',
1.14 + 'Done',
1.15 + 'Rejected',
1.16 + 'Withdrawn'
1.17 +);
1.18 +
1.19 +create type issue_category as enum (
1.20 + 'Feature',
1.21 + 'Improvement',
1.22 + 'Bug',
1.23 + 'Task',
1.24 + 'Test'
1.25 +);
1.26 +
1.27 +create table lpit_issue (
1.28 + id serial primary key,
1.29 + project integer not null references lpit_project(id),
1.30 + status issue_status not null default 'InSpecification',
1.31 + category issue_category not null default 'Feature',
1.32 + subject varchar(20) not null,
1.33 + description text,
1.34 + version_plan integer references lpit_version(id),
1.35 + version_done integer references lpit_version(id),
1.36 + created timestamp with time zone not null default now(),
1.37 + updated timestamp with time zone not null default now(),
1.38 + eta date
1.39 +);
