#1643 fix schema.sql introduced by moving owner from tag_packages to another table
Merged 2 years ago by tkopecek. Opened 2 years ago by julian8628.
julian8628/koji fix-schema  into  master

@@ -51,7 +51,8 @@ 

  $BODY$

  LANGUAGE plpgsql;

  

- INSERT INTO tag_package_owners (SELECT package_id, tag_id, owner create_event revoke_event creator_id revoker_id active FROM convert_owners());

+ INSERT INTO tag_package_owners (SELECT package_id, tag_id, owner, create_event, revoke_event, creator_id, revoker_id, active FROM convert_owners());

+ DROP INDEX IF EXISTS tag_packages_owner;

  ALTER TABLE tag_packages DROP COLUMN owner;

  DROP FUNCTION convert_owners();

  

file modified
-2
@@ -584,7 +584,6 @@ 

  CREATE TABLE tag_packages (

  	package_id INTEGER NOT NULL REFERENCES package (id),

  	tag_id INTEGER NOT NULL REFERENCES tag (id),

- 	owner INTEGER NOT NULL REFERENCES users(id),

  	blocked BOOLEAN NOT NULL DEFAULT FALSE,

  	extra_arches TEXT,

  -- versioned - see earlier description of versioning
@@ -602,7 +601,6 @@ 

  CREATE INDEX tag_packages_active_tag_id ON tag_packages(active, tag_id);

  CREATE INDEX tag_packages_create_event ON tag_packages(create_event);

  CREATE INDEX tag_packages_revoke_event ON tag_packages(revoke_event);

- CREATE INDEX tag_packages_owner ON tag_packages(owner);

  

  CREATE TABLE tag_package_owners (

  	package_id INTEGER NOT NULL REFERENCES package(id),

rebased onto 1a707add83cdaaa7b8682e8ff848439206babe42

2 years ago

Metadata Update from @julian8628:
- Pull-request tagged with: easyfix, testing-ready

2 years ago

rebased onto e89ab91222036ead484051bd349aa49e65ee164b

2 years ago

rebased onto 18cb1eb

2 years ago

Metadata Update from @julian8628:
- Pull-request tagged with: testing-done

2 years ago

Commit 3dcc193 fixes this pull-request

Pull-Request has been merged by tkopecek

2 years ago