15 lines
413 B
MySQL
15 lines
413 B
MySQL
|
-- Place your SQL code here
|
||
|
|
ALTER TABLE `hedera`.`orderRecalc`
|
||
|
|
DROP FOREIGN KEY `orderRecalc_ibfk_1`;
|
||
|
|
|
||
|
|
ALTER TABLE `hedera`.`orderRecalc`
|
||
|
|
ADD COLUMN `id` INT(11) NOT NULL AUTO_INCREMENT FIRST,
|
||
|
|
DROP PRIMARY KEY,
|
||
|
|
ADD PRIMARY KEY (`id`);
|
||
|
|
|
||
|
|
ALTER TABLE `hedera`.`orderRecalc`
|
||
|
|
ADD CONSTRAINT `orderRecalc_ibfk_1`
|
||
|
|
FOREIGN KEY (`orderFk`)
|
||
|
|
REFERENCES `hedera`.`order` (`id`)
|
||
|
|
ON DELETE CASCADE
|
||
|
|
ON UPDATE CASCADE;
|