setup/postgres/psql_patch_1.1.0.sql@1c21d7a9135d (annotated)
setup/postgres/psql_patch_1.1.0.sql
Sat, 13 Dec 2025 15:08:06 +0100
- author
- Mike Becker <universe@uap-core.de>
- date
- Sat, 13 Dec 2025 15:08:06 +0100
- changeset 403
- 1c21d7a9135d
- parent 285
- 8da71efbaa35
- permissions
- -rw-r--r--
fix that clearing a filter manually did not work anymore - fixes #783
| 285 | 1 | -- apply this script to patch a version 1.0.x database to 1.1.0 |
| 2 | ||
| 3 | create table lpit_commit_ref | |
| 4 | ( | |
| 5 | issueid integer not null references lpit_issue (issueid) on delete cascade, | |
| 6 | commit_hash text not null, | |
| 7 | commit_brief text not null | |
| 8 | ); | |
| 9 | create unique index lpit_commit_ref_unique on lpit_commit_ref (issueid, commit_hash); | |
| 10 | create type vcstype as enum ('None', 'Mercurial', 'Git'); | |
| 11 | alter table lpit_project add column vcs vcstype not null default 'None'::vcstype; |
