universe@285: -- apply this script to patch a version 1.0.x database to 1.1.0
universe@285: 
universe@285: create table lpit_commit_ref
universe@285: (
universe@285:     issueid      integer not null references lpit_issue (issueid) on delete cascade,
universe@285:     commit_hash  text    not null,
universe@285:     commit_brief text    not null
universe@285: );
universe@285: create unique index lpit_commit_ref_unique on lpit_commit_ref (issueid, commit_hash);
universe@285: create type vcstype as enum ('None', 'Mercurial', 'Git');
universe@285: alter table lpit_project add column vcs vcstype not null default 'None'::vcstype;