Mercurial > hg > LightPIT / file revision

• file
• latest
• revisions
• annotate
• diff
• comparison
• raw

setup/postgres/psql_patch_1.1.0.sql@d1edd8d9c8a1

setup/postgres/psql_patch_1.1.0.sql

Thu, 30 Jan 2025 21:20:27 +0100

author

Mike Becker <universe@uap-core.de>

date

Thu, 30 Jan 2025 21:20:27 +0100

changeset 347

d1edd8d9c8a1

parent 285

8da71efbaa35

permissions

-rw-r--r--

prepare implementation of "variants"

introduces the class, implements basic DAO stuff, and
adds the new path parameter

relates to #491

-- apply this script to patch a version 1.0.x database to 1.1.0

create table lpit_commit_ref
(
    issueid      integer not null references lpit_issue (issueid) on delete cascade,
    commit_hash  text    not null,
    commit_brief text    not null
);
create unique index lpit_commit_ref_unique on lpit_commit_ref (issueid, commit_hash);
create type vcstype as enum ('None', 'Mercurial', 'Git');
alter table lpit_project add column vcs vcstype not null default 'None'::vcstype;