comparison: setup/postgres/psql_create_tables.sql
setup/postgres/psql_create_tables.sql
- changeset 81
- 1a2e7b5d48f7
- parent 75
- 33b6843fdf8a
- child 85
- 3d16ad54b3dc
equal
deleted
inserted
replaced
| 80:27a25f32048e | 81:1a2e7b5d48f7 |
|---|---|
| 39 'Scheduled', | 39 'Scheduled', |
| 40 'InProgress', | 40 'InProgress', |
| 41 'InReview', | 41 'InReview', |
| 42 'Done', | 42 'Done', |
| 43 'Rejected', | 43 'Rejected', |
| 44 'Withdrawn' | 44 'Withdrawn', |
| 45 'Duplicate' | |
| 45 ); | 46 ); |
| 46 | 47 |
| 47 create type issue_category as enum ( | 48 create type issue_category as enum ( |
| 48 'Feature', | 49 'Feature', |
| 49 'Improvement', | 50 'Improvement', |
| 50 'Bug', | 51 'Bug', |
| 51 'Task', | 52 'Task', |
| 52 'Test' | 53 'Test' |
| 54 ); | |
| 55 | |
| 56 create table lpit_issue_phases ( | |
| 57 status issue_status primary key, | |
| 58 phase integer not null | |
| 53 ); | 59 ); |
| 54 | 60 |
| 55 create table lpit_issue ( | 61 create table lpit_issue ( |
| 56 issueid serial primary key, | 62 issueid serial primary key, |
| 57 project integer not null references lpit_project(projectid), | 63 project integer not null references lpit_project(projectid), |
