Mercurial > hg > LightPIT / file diff

--- 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