salix/db/versions/11278-crimsonEucalyptus/00-firstScript.sql

7 lines
270 B
MySQL
Raw Permalink Normal View History

-- Place your SQL code here
ALTER TABLE vn.priceDelta ADD IF NOT EXISTS zoneGeoFk int(11) NULL;
2024-10-02 05:34:57 +00:00
ALTER TABLE vn.priceDelta ADD CONSTRAINT priceDelta_zoneGeo_FK FOREIGN KEY IF NOT EXISTS (zoneGeoFk)
REFERENCES vn.zoneGeo (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;