comparison: setup/postgres/psql_create_tables.sql
setup/postgres/psql_create_tables.sql
- changeset 128
- 947d0f6a6a83
- parent 127
- 6105ee2cceaf
- child 138
- e2aa673dd473
equal
deleted
inserted
replaced
| 127:6105ee2cceaf | 128:947d0f6a6a83 |
|---|---|
| 38 id serial primary key, | 38 id serial primary key, |
| 39 project integer not null references lpit_project(projectid), | 39 project integer not null references lpit_project(projectid), |
| 40 name varchar(20) not null, | 40 name varchar(20) not null, |
| 41 color char(6) not null default '000000', | 41 color char(6) not null default '000000', |
| 42 ordinal integer not null default 0, | 42 ordinal integer not null default 0, |
| 43 description text | 43 description text, |
| 44 lead integer references lpit_user(userid) | |
| 44 ); | 45 ); |
| 45 | 46 |
| 46 create type issue_status as enum ( | 47 create type issue_status as enum ( |
| 47 'InSpecification', | 48 'InSpecification', |
| 48 'ToDo', | 49 'ToDo', |
