comparison: setup/postgres/psql_create_tables.sql
setup/postgres/psql_create_tables.sql
- changeset 85
- 3d16ad54b3dc
- parent 81
- 1a2e7b5d48f7
- child 88
- 1438e5a22c55
equal
deleted
inserted
replaced
| 84:5407d4ea0611 | 85:3d16ad54b3dc |
|---|---|
| 61 create table lpit_issue ( | 61 create table lpit_issue ( |
| 62 issueid serial primary key, | 62 issueid serial primary key, |
| 63 project integer not null references lpit_project(projectid), | 63 project integer not null references lpit_project(projectid), |
| 64 status issue_status not null default 'InSpecification', | 64 status issue_status not null default 'InSpecification', |
| 65 category issue_category not null default 'Feature', | 65 category issue_category not null default 'Feature', |
| 66 subject varchar(20) not null, | 66 subject varchar(200) not null, |
| 67 description text, | 67 description text, |
| 68 assignee integer references lpit_user(userid), | 68 assignee integer references lpit_user(userid), |
| 69 created timestamp with time zone not null default now(), | 69 created timestamp with time zone not null default now(), |
| 70 updated timestamp with time zone not null default now(), | 70 updated timestamp with time zone not null default now(), |
| 71 eta date | 71 eta date |
