diff -r 860bbccf33e7 -r d1edd8d9c8a1 setup/postgres/psql_patch_1.5.0.sql --- a/setup/postgres/psql_patch_1.5.0.sql Thu Jan 30 19:47:21 2025 +0100 +++ b/setup/postgres/psql_patch_1.5.0.sql Thu Jan 30 21:20:27 2025 +0100 @@ -2,3 +2,17 @@ alter table lpit_issue_history_event add userid integer null references lpit_user (userid) on delete set null; + +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);