salix/db/versions/.archive/10525-yellowRuscus/00-firstScript.sql

2 lines
197 B
MySQL
Raw Permalink Normal View History

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