11 lines
298 B
MySQL
11 lines
298 B
MySQL
|
-- Place your SQL code here
|
||
|
|
ALTER TABLE `vn`.`routeCommission`
|
||
|
|
DROP FOREIGN KEY `routeCommission_routeFk`;
|
||
|
|
|
||
|
|
ALTER TABLE `vn`.`routeCommission`
|
||
|
|
ADD CONSTRAINT `routeCommission_routeFk`
|
||
|
|
FOREIGN KEY (`routeFk`)
|
||
|
|
REFERENCES `vn`.`route` (`id`)
|
||
|
|
ON DELETE CASCADE
|
||
|
|
ON UPDATE CASCADE;
|