comparison: setup/postgres/psql_create_tables.sql
setup/postgres/psql_create_tables.sql
- changeset 347
- d1edd8d9c8a1
- parent 345
- 7a515768c481
- child 348
- 1dc9c405e9e2
equal
deleted
inserted
replaced
| 346:860bbccf33e7 | 347:d1edd8d9c8a1 |
|---|---|
| 55 lead integer references lpit_user (userid), | 55 lead integer references lpit_user (userid), |
| 56 active boolean not null default true | 56 active boolean not null default true |
| 57 ); | 57 ); |
| 58 | 58 |
| 59 create unique index lpit_component_node_unique on lpit_component (project, node); | 59 create unique index lpit_component_node_unique on lpit_component (project, node); |
| 60 | |
| 61 create table lpit_variant | |
| 62 ( | |
| 63 id serial primary key, | |
| 64 project integer not null references lpit_project (projectid), | |
| 65 name text not null, | |
| 66 node text not null, | |
| 67 color char(6) not null default '000000', | |
| 68 ordinal integer not null default 0, | |
| 69 description text, | |
| 70 active boolean not null default true | |
| 71 ); | |
| 72 | |
| 73 create unique index lpit_variant_node_unique on lpit_variant (project, node); | |
| 60 | 74 |
| 61 create type issue_status as enum ( | 75 create type issue_status as enum ( |
| 62 'InSpecification', | 76 'InSpecification', |
| 63 'ToDo', | 77 'ToDo', |
| 64 'Scheduled', | 78 'Scheduled', |
