salix/db/versions/11040-grayMonstera/00-firstScript.sql

UPDATE vn.route
    SET vehicleFk = NULL
    WHERE vehicleFk NOT IN (SELECT id FROM vn.vehicle);

ALTER TABLE vn.route
ADD CONSTRAINT route_vehicleFk FOREIGN KEY (vehicleFk) REFERENCES vn.vehicle(id);

ALTER TABLE vn.route
MODIFY COLUMN firstEditorFk int(10) unsigned NULL;

UPDATE vn.route
    SET firstEditorFk = NULL
    WHERE firstEditorFk NOT IN (SELECT id FROM account.user);

ALTER TABLE vn.route
ADD CONSTRAINT route_firstEditorFk FOREIGN KEY (firstEditorFk) REFERENCES account.user(id);