salix/db/versions/.archive/10394-brownHydrangea/00-firstScript.sql

3 lines
230 B
MySQL
Raw Permalink Normal View History

ALTER TABLE vn.workerJourney DROP FOREIGN KEY workerJourney_businessFk;
ALTER TABLE vn.workerJourney ADD CONSTRAINT workerJourney_businessFk FOREIGN KEY (businessFk) REFERENCES vn.business(id) ON DELETE CASCADE ON UPDATE CASCADE;