diff -r 95b419e054fa -r dcb1d5a7ea3a setup/postgres/psql_create_tables.sql --- a/setup/postgres/psql_create_tables.sql Wed Aug 18 16:02:40 2021 +0200 +++ b/setup/postgres/psql_create_tables.sql Thu Aug 19 14:51:04 2021 +0200 @@ -96,21 +96,9 @@ assignee integer references lpit_user (userid), created timestamp with time zone not null default now(), updated timestamp with time zone not null default now(), - eta date -); - -create table lpit_issue_affected_version -( - issueid integer references lpit_issue (issueid), - versionid integer references lpit_version (versionid), - primary key (issueid, versionid) -); - -create table lpit_issue_resolved_version -( - issueid integer references lpit_issue (issueid), - versionid integer references lpit_version (versionid), - primary key (issueid, versionid) + eta date, + affected integer references lpit_version (versionid), + resolved integer references lpit_version (versionid) ); create table lpit_issue_comment