setup/postgres/psql_patch_1.1.0.sql

Sun, 28 Jul 2024 12:19:42 +0200

author
Mike Becker <universe@uap-core.de>
date
Sun, 28 Jul 2024 12:19:42 +0200
changeset 303
4c5342255263
parent 285
8da71efbaa35
permissions
-rw-r--r--

add changelog entry for issue #401

285
8da71efbaa35 add SQL patch script
Mike Becker <universe@uap-core.de>
parents:
diff changeset
1 -- apply this script to patch a version 1.0.x database to 1.1.0
8da71efbaa35 add SQL patch script
Mike Becker <universe@uap-core.de>
parents:
diff changeset
2
8da71efbaa35 add SQL patch script
Mike Becker <universe@uap-core.de>
parents:
diff changeset
3 create table lpit_commit_ref
8da71efbaa35 add SQL patch script
Mike Becker <universe@uap-core.de>
parents:
diff changeset
4 (
8da71efbaa35 add SQL patch script
Mike Becker <universe@uap-core.de>
parents:
diff changeset
5 issueid integer not null references lpit_issue (issueid) on delete cascade,
8da71efbaa35 add SQL patch script
Mike Becker <universe@uap-core.de>
parents:
diff changeset
6 commit_hash text not null,
8da71efbaa35 add SQL patch script
Mike Becker <universe@uap-core.de>
parents:
diff changeset
7 commit_brief text not null
8da71efbaa35 add SQL patch script
Mike Becker <universe@uap-core.de>
parents:
diff changeset
8 );
8da71efbaa35 add SQL patch script
Mike Becker <universe@uap-core.de>
parents:
diff changeset
9 create unique index lpit_commit_ref_unique on lpit_commit_ref (issueid, commit_hash);
8da71efbaa35 add SQL patch script
Mike Becker <universe@uap-core.de>
parents:
diff changeset
10 create type vcstype as enum ('None', 'Mercurial', 'Git');
8da71efbaa35 add SQL patch script
Mike Becker <universe@uap-core.de>
parents:
diff changeset
11 alter table lpit_project add column vcs vcstype not null default 'None'::vcstype;

mercurial