8 lines
353 B
MySQL
8 lines
353 B
MySQL
|
ALTER TABLE vn.travel DROP KEY shipment_1;
|
||
|
|
|
||
|
|
ALTER TABLE `vn`.`travel` ADD CONSTRAINT shipment_1 UNIQUE KEY (shipped,landed,warehouseInFk,warehouseOutFk,agencyModeFk,`ref`);
|
||
|
|
|
||
|
|
ALTER TABLE vn.travel DROP FOREIGN KEY travel_ibfk_3;
|
||
|
|
|
||
|
|
ALTER TABLE vn.travel CHANGE agencyFk agencyFk__ smallint(5) unsigned NOT NULL COMMENT '@deprecated 2024-10-01 refs #6604';
|