comparison: setup/postgres/psql_create_tables.sql
setup/postgres/psql_create_tables.sql
- changeset 62
- 833e0385572a
- parent 37
- fecda0f466e6
- child 75
- 33b6843fdf8a
equal
deleted
inserted
replaced
| 61:3e287f361c7a | 62:833e0385572a |
|---|---|
| 30 project integer not null references lpit_project(id), | 30 project integer not null references lpit_project(id), |
| 31 name varchar(20) not null, | 31 name varchar(20) not null, |
| 32 ordinal integer not null default 0, | 32 ordinal integer not null default 0, |
| 33 status version_status not null default 'Future' | 33 status version_status not null default 'Future' |
| 34 ); | 34 ); |
| 35 | |
| 36 create type issue_status as enum ( | |
| 37 'InSpecification', | |
| 38 'ToDo', | |
| 39 'Scheduled', | |
| 40 'InProgress', | |
| 41 'InReview', | |
| 42 'Done', | |
| 43 'Rejected', | |
| 44 'Withdrawn' | |
| 45 ); | |
| 46 | |
| 47 create type issue_category as enum ( | |
| 48 'Feature', | |
| 49 'Improvement', | |
| 50 'Bug', | |
| 51 'Task', | |
| 52 'Test' | |
| 53 ); | |
| 54 | |
| 55 create table lpit_issue ( | |
| 56 id serial primary key, | |
| 57 project integer not null references lpit_project(id), | |
| 58 status issue_status not null default 'InSpecification', | |
| 59 category issue_category not null default 'Feature', | |
| 60 subject varchar(20) not null, | |
| 61 description text, | |
| 62 version_plan integer references lpit_version(id), | |
| 63 version_done integer references lpit_version(id), | |
| 64 created timestamp with time zone not null default now(), | |
| 65 updated timestamp with time zone not null default now(), | |
| 66 eta date | |
| 67 ); |
