1.1 --- a/setup/postgres/psql_create_tables.sql Wed Aug 18 16:02:40 2021 +0200
1.2 +++ b/setup/postgres/psql_create_tables.sql Thu Aug 19 14:51:04 2021 +0200
1.3 @@ -96,21 +96,9 @@
1.4 assignee integer references lpit_user (userid),
1.5 created timestamp with time zone not null default now(),
1.6 updated timestamp with time zone not null default now(),
1.7 - eta date
1.8 -);
1.9 -
1.10 -create table lpit_issue_affected_version
1.11 -(
1.12 - issueid integer references lpit_issue (issueid),
1.13 - versionid integer references lpit_version (versionid),
1.14 - primary key (issueid, versionid)
1.15 -);
1.16 -
1.17 -create table lpit_issue_resolved_version
1.18 -(
1.19 - issueid integer references lpit_issue (issueid),
1.20 - versionid integer references lpit_version (versionid),
1.21 - primary key (issueid, versionid)
1.22 + eta date,
1.23 + affected integer references lpit_version (versionid),
1.24 + resolved integer references lpit_version (versionid)
1.25 );
1.26
1.27 create table lpit_issue_comment
