salix/db/versions/11160-blueRoebelini/00-firstScript.sql

3 lines
193 B
MySQL
Raw Permalink Normal View History

ALTER TABLE vn.state DROP FOREIGN KEY state_ibfk_1;
ALTER TABLE vn.state ADD CONSTRAINT state_ibfk_1 FOREIGN KEY (alertLevel) REFERENCES vn.alertLevel(id) ON DELETE RESTRICT ON UPDATE CASCADE;