salix/db/versions/.archive/10704-wheatMastic/00-firstScript.sql

3 lines
208 B
MySQL
Raw Permalink Normal View History

ALTER TABLE vn.delivery DROP FOREIGN KEY delivery_ticketFk_FK;
ALTER TABLE vn.delivery ADD CONSTRAINT delivery_ticketFk_FK FOREIGN KEY (ticketFk) REFERENCES vn.ticket(id) ON DELETE CASCADE ON UPDATE CASCADE;