setup/postgres/psql_patch_1.5.0.sql

-- apply this script to patch a version < 1.5.0 database to version 1.5.0

alter table lpit_issue_history_event
    add userid integer null references lpit_user (userid) on delete set null;

create table lpit_variant
(
    id          serial primary key,
    project     integer not null references lpit_project (projectid),
    name        text    not null,
    node        text    not null,
    color       char(6) not null default '000000',
    ordinal     integer not null default 0,
    description text,
    active      boolean not null default true
);

create unique index lpit_variant_node_unique on lpit_variant (project, node);