$BODY$

  LANGUAGE plpgsql;

  ALTER TABLE tag_packages DROP COLUMN owner;

  DROP FUNCTION convert_owners();

  CREATE TABLE tag_packages (

  	package_id INTEGER NOT NULL REFERENCES package (id),

  	tag_id INTEGER NOT NULL REFERENCES tag (id),

  	blocked BOOLEAN NOT NULL DEFAULT FALSE,

  	extra_arches TEXT,

  -- versioned - see earlier description of versioning

  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 TABLE tag_package_owners (

  	package_id INTEGER NOT NULL REFERENCES package(id),