diff -r 860bbccf33e7 -r d1edd8d9c8a1 setup/postgres/psql_create_tables.sql --- a/setup/postgres/psql_create_tables.sql Thu Jan 30 19:47:21 2025 +0100 +++ b/setup/postgres/psql_create_tables.sql Thu Jan 30 21:20:27 2025 +0100 @@ -58,6 +58,20 @@ create unique index lpit_component_node_unique on lpit_component (project, node); +create table lpit_variant +( + id serial primary key, + project integer not null references lpit_project (projectid), + name text not null, + node text not null, + color char(6) not null default '000000', + ordinal integer not null default 0, + description text, + active boolean not null default true +); + +create unique index lpit_variant_node_unique on lpit_variant (project, node); + create type issue_status as enum ( 'InSpecification', 'ToDo',