--- 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) +);