5 lines
302 B
SQL
5 lines
302 B
SQL
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; |