Mercurial > hg > LightPIT / file diff

--- a/setup/postgres/psql_create_tables.sql	Thu Oct 15 11:42:43 2020 +0200
+++ b/setup/postgres/psql_create_tables.sql	Thu Oct 15 12:27:05 2020 +0200
@@ -33,6 +33,16 @@
     status          version_status  not null default 'Future'
 );
 
+
+create table lpit_component (
+    id              serial          primary key,
+    project         integer         not null references lpit_project(projectid),
+    name            varchar(20)     not null,
+    color           char(6)         not null default '000000',
+    ordinal         integer         not null default 0,
+    description     text
+);
+
 create type issue_status as enum (
     'InSpecification',
     'ToDo',
@@ -61,6 +71,7 @@
 create table lpit_issue (
     issueid         serial          primary key,
     project         integer         not null references lpit_project(projectid),
+    component       integer         references lpit_component(id),
     status          issue_status    not null default 'InSpecification',
     category        issue_category  not null default 'Feature',
     subject         varchar(200)    not null,