Mercurial > hg > LightPIT / file diff

     1.1 --- /dev/null	Thu Jan 01 00:00:00 1970 +0000
     1.2 +++ b/setup/postgres/psql_patch_1.1.0.sql	Sun Jul 23 18:17:03 2023 +0200
     1.3 @@ -0,0 +1,11 @@
     1.4 +-- apply this script to patch a version 1.0.x database to 1.1.0
     1.5 +
     1.6 +create table lpit_commit_ref
     1.7 +(
     1.8 +    issueid      integer not null references lpit_issue (issueid) on delete cascade,
     1.9 +    commit_hash  text    not null,
    1.10 +    commit_brief text    not null
    1.11 +);
    1.12 +create unique index lpit_commit_ref_unique on lpit_commit_ref (issueid, commit_hash);
    1.13 +create type vcstype as enum ('None', 'Mercurial', 'Git');
    1.14 +alter table lpit_project add column vcs vcstype not null default 'None'::vcstype;