setup/postgres/psql_patch_1.5.0.sql

changeset 347
d1edd8d9c8a1
parent 345
7a515768c481
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);

mercurial