salix/db/versions/11152-goldenRaphis/00-firstScript.sql

4 lines
230 B
MySQL
Raw Permalink Normal View History

2024-07-15 10:02:00 +00:00
-- Place your SQL code here
ALTER TABLE vn.ticketSms__ DROP FOREIGN KEY IF EXISTS ticketSms_FK;
ALTER TABLE vn.ticketSms__ ADD CONSTRAINT ticketSms_FK FOREIGN KEY (smsFk) REFERENCES vn.sms(id) ON DELETE CASCADE ON UPDATE CASCADE;