#3697 Unify migration script Koji 1.31 -> 1.32
Merged a year ago by tkopecek. Opened a year ago by jcupova.
jcupova/koji issue-3696  into  master

@@ -1,13 +0,0 @@ 

- -- 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;

- COMMIT;

@@ -6,6 +6,11 @@ 

      -- 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),

Commit 7960d72 fixes this pull-request

Pull-Request has been merged by tkopecek

a year ago

Metadata Update from @jcupova:
- Pull-request tagged with: no_qe

a year ago