comparison: setup/postgres/psql_patch_1.5.0.sql
setup/postgres/psql_patch_1.5.0.sql
- changeset 347
- d1edd8d9c8a1
- parent 345
- 7a515768c481
- child 348
- 1dc9c405e9e2
equal
deleted
inserted
replaced
| 346:860bbccf33e7 | 347:d1edd8d9c8a1 |
|---|---|
| 1 -- apply this script to patch a version < 1.5.0 database to version 1.5.0 | 1 -- apply this script to patch a version < 1.5.0 database to version 1.5.0 |
| 2 | 2 |
| 3 alter table lpit_issue_history_event | 3 alter table lpit_issue_history_event |
| 4 add userid integer null references lpit_user (userid) on delete set null; | 4 add userid integer null references lpit_user (userid) on delete set null; |
| 5 | |
| 6 create table lpit_variant | |
| 7 ( | |
| 8 id serial primary key, | |
| 9 project integer not null references lpit_project (projectid), | |
| 10 name text not null, | |
| 11 node text not null, | |
| 12 color char(6) not null default '000000', | |
| 13 ordinal integer not null default 0, | |
| 14 description text, | |
| 15 active boolean not null default true | |
| 16 ); | |
| 17 | |
| 18 create unique index lpit_variant_node_unique on lpit_variant (project, node); |
