start TRANSACTION;
alter table `Order`
 add column `billingAddressId` INT(10) unsigned after `frozenShippingAddress`,
 add column `shipmentAddressId` INT(10) unsigned AFTER `billingAddressId`,
 ADD CONSTRAINT `fk_billingAddressId` FOREIGN KEY (`billingAddressId`) REFERENCES `UserAddress` (`id`) ON UPDATE NO ACTION ON DELETE NO ACTION,
 ADD CONSTRAINT `fk_shipmentAddressId` FOREIGN KEY (`shipmentAddressId`) REFERENCES `UserAddress` (`id`) ON UPDATE NO ACTION ON DELETE NO ACTION;
ROLLBACK;