23 lines
913 B
PL/PgSQL
23 lines
913 B
PL/PgSQL
-- upgrade script to migrate the Koji database schema
|
|
-- from version 1.31 to 1.32
|
|
|
|
BEGIN;
|
|
|
|
-- fix duplicate extension in archivetypes
|
|
UPDATE archivetypes SET extensions = 'vhdx.gz vhdx.xz' WHERE name = 'vhdx-compressed';
|
|
|
|
-- for tag if session is closed or not
|
|
ALTER TABLE sessions ADD COLUMN closed BOOLEAN NOT NULL DEFAULT FALSE;
|
|
ALTER TABLE sessions ADD CONSTRAINT no_closed_exclusive CHECK (closed IS FALSE OR "exclusive" IS NULL);
|
|
ALTER TABLE sessions DROP CONSTRAINT exclusive_expired_sane;
|
|
|
|
-- track checksum of rpms
|
|
CREATE TABLE rpm_checksum (
|
|
rpm_id INTEGER NOT NULL REFERENCES rpminfo(id),
|
|
sigkey TEXT NOT NULL,
|
|
checksum TEXT NOT NULL UNIQUE,
|
|
checksum_type SMALLINT NOT NULL,
|
|
PRIMARY KEY (rpm_id, sigkey, checksum_type)
|
|
) WITHOUT OIDS;
|
|
CREATE INDEX rpm_checksum_rpm_id ON rpm_checksum(rpm_id);
|
|
COMMIT;
|