--- a/setup/postgres/psql_create_tables.sql Thu Jan 30 21:20:27 2025 +0100 +++ b/setup/postgres/psql_create_tables.sql Sat Feb 01 18:52:08 2025 +0100 @@ -192,3 +192,11 @@ ); create unique index lpit_commit_ref_unique on lpit_commit_ref (issueid, commit_hash); + +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) +);