setup/postgres/psql_create_tables.sql

changeset 227
f0ede8046b59
parent 225
87328572e36f
child 231
dcb1d5a7ea3a
--- a/setup/postgres/psql_create_tables.sql	Wed Aug 18 15:04:59 2021 +0200
+++ b/setup/postgres/psql_create_tables.sql	Wed Aug 18 15:30:49 2021 +0200
@@ -52,7 +52,8 @@
     color       char(6) not null default '000000',
     ordinal     integer not null default 0,
     description text,
-    lead        integer references lpit_user (userid)
+    lead        integer references lpit_user (userid),
+    active      boolean not null default true
 );
 
 create unique index lpit_component_node_unique on lpit_component (project, node);

mercurial