8 lines
446 B
MySQL
8 lines
446 B
MySQL
|
ALTER TABLE vn.roadmapStop DROP FOREIGN KEY expeditionTruck_FK_1;
|
||
|
|
ALTER TABLE vn.roadmapStop DROP COLUMN warehouseFk;
|
||
|
|
ALTER TABLE vn.roadmapStop ADD addressFk int(11) NULL;
|
||
|
|
ALTER TABLE vn.roadmapStop CHANGE addressFk addressFk int(11) DEFAULT NULL NULL AFTER roadmapFk;
|
||
|
|
|
||
|
|
ALTER TABLE vn.roadmapStop
|
||
|
|
ADD CONSTRAINT roadmapStop_roadmapAddress_FK FOREIGN KEY (addressFk) REFERENCES vn.roadmapAddress(addressFk) ON DELETE RESTRICT ON UPDATE CASCADE;
|