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