comparison: setup/postgres/psql_create_tables.sql
setup/postgres/psql_create_tables.sql
- changeset 227
- f0ede8046b59
- parent 225
- 87328572e36f
- child 231
- dcb1d5a7ea3a
equal
deleted
inserted
replaced
| 226:c8e1b5282f69 | 227:f0ede8046b59 |
|---|---|
| 50 name text not null, | 50 name text not null, |
| 51 node text not null, | 51 node text not null, |
| 52 color char(6) not null default '000000', | 52 color char(6) not null default '000000', |
| 53 ordinal integer not null default 0, | 53 ordinal integer not null default 0, |
| 54 description text, | 54 description text, |
| 55 lead integer references lpit_user (userid) | 55 lead integer references lpit_user (userid), |
| 56 active boolean not null default true | |
| 56 ); | 57 ); |
| 57 | 58 |
| 58 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); |
| 59 | 60 |
| 60 create type issue_status as enum ( | 61 create type issue_status as enum ( |
