1.1 --- a/setup/postgres/psql_create_tables.sql Fri May 22 17:26:27 2020 +0200
1.2 +++ b/setup/postgres/psql_create_tables.sql Fri May 22 21:23:57 2020 +0200
1.3 @@ -10,7 +10,7 @@
1.4 );
1.5
1.6 create table lpit_project (
1.7 - id serial primary key,
1.8 + projectid serial primary key,
1.9 name varchar(20) not null unique,
1.10 description varchar(200),
1.11 repoUrl varchar(50),
1.12 @@ -26,8 +26,8 @@
1.13 );
1.14
1.15 create table lpit_version (
1.16 - id serial primary key,
1.17 - project integer not null references lpit_project(id),
1.18 + versionid serial primary key,
1.19 + project integer not null references lpit_project(projectid),
1.20 name varchar(20) not null,
1.21 ordinal integer not null default 0,
1.22 status version_status not null default 'Future'
1.23 @@ -53,15 +53,34 @@
1.24 );
1.25
1.26 create table lpit_issue (
1.27 - id serial primary key,
1.28 - project integer not null references lpit_project(id),
1.29 + issueid serial primary key,
1.30 + project integer not null references lpit_project(projectid),
1.31 status issue_status not null default 'InSpecification',
1.32 category issue_category not null default 'Feature',
1.33 subject varchar(20) not null,
1.34 description text,
1.35 - version_plan integer references lpit_version(id),
1.36 - version_done integer references lpit_version(id),
1.37 + assignee integer references lpit_user(userid),
1.38 created timestamp with time zone not null default now(),
1.39 updated timestamp with time zone not null default now(),
1.40 eta date
1.41 );
1.42 +
1.43 +create table lpit_issue_affected_version (
1.44 + issueid integer references lpit_issue(issueid),
1.45 + versionid integer references lpit_version(versionid),
1.46 + primary key (issueid, versionid)
1.47 +);
1.48 +
1.49 +create table lpit_issue_scheduled_version (
1.50 + issueid integer references lpit_issue(issueid),
1.51 + versionid integer references lpit_version(versionid),
1.52 + primary key (issueid, versionid)
1.53 +);
1.54 +
1.55 +create table lpit_issue_resolved_version (
1.56 + issueid integer references lpit_issue(issueid),
1.57 + versionid integer references lpit_version(versionid),
1.58 + primary key (issueid, versionid)
1.59 +);
1.60 +
1.61 +
