setup/postgres/psql_patch_1.5.0.sql

changeset 348
1dc9c405e9e2
parent 347
d1edd8d9c8a1
--- a/setup/postgres/psql_patch_1.5.0.sql	Thu Jan 30 21:20:27 2025 +0100
+++ b/setup/postgres/psql_patch_1.5.0.sql	Sat Feb 01 18:52:08 2025 +0100
@@ -16,3 +16,11 @@
 );
 
 create unique index lpit_variant_node_unique on lpit_variant (project, node);
+
+create table lpit_issue_variant_status
+(
+    issueid   integer        not null references lpit_issue (issueid),
+    variant   integer        not null references lpit_variant (id),
+    status    issue_status   not null default 'InSpecification',
+    primary key (issueid, variant)
+);

mercurial