compareware/Application/Migration/1712852503.sql

3 lines
163 B
SQL

CREATE INDEX tags_item_id_index ON tags (item_id);
ALTER TABLE tags ADD CONSTRAINT tags_ref_item_id FOREIGN KEY (item_id) REFERENCES items (id) ON DELETE CASCADE;