salix/db/versions/11140-azurePhormium/00-firstScript.sql

4 lines
207 B
SQL

ALTER TABLE vn.vehicle DROP FOREIGN KEY provinceFk;
ALTER TABLE vn.vehicle
ADD CONSTRAINT vehicle_warehouse_FK FOREIGN KEY (warehouseFk) REFERENCES vn.warehouse(id) ON DELETE RESTRICT ON UPDATE CASCADE;