-- Tags to Assets
ALTER TABLE tags DROP CONSTRAINT tags_asset_id_fkey;
ALTER TABLE tags ADD CONSTRAINT tags_asset_id_fkey FOREIGN KEY (asset_id) REFERENCES assets(id) ON DELETE CASCADE;

-- Tags to TagTypes
ALTER TABLE tags DROP CONSTRAINT tags_tag_type_id_fkey;
ALTER TABLE tags ADD CONSTRAINT tags_tag_type_id_fkey FOREIGN KEY (tag_type_id) REFERENCES tag_types(id) ON DELETE CASCADE;