5 lines
302 B
MySQL
5 lines
302 B
MySQL
|
USE `vn`;
|
||
|
|
|
||
|
|
ALTER TABLE `vn`.`awb` ADD invoiceInPaletizedFk INT NULL;
|
||
|
|
ALTER TABLE `vn`.`awb` MODIFY COLUMN invoiceInPaletizedFk mediumint(8) unsigned NULL;
|
||
|
|
ALTER TABLE `vn`.`awb` ADD CONSTRAINT awb_FK_3 FOREIGN KEY (invoiceInPaletizedFk) REFERENCES vn.invoiceIn(id) ON DELETE RESTRICT ON UPDATE CASCADE;
|