Mercurial > hg > LightPIT / file diff

--- 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',