START TRANSACTION;

  DROP TABLE IF EXISTS `modify_prices_locations`;
  CREATE TABLE `modify_prices_locations` (
    `id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
    `modify_price_id` INT UNSIGNED NOT NULL,
    `location_id` INT UNSIGNED NULL,
    PRIMARY KEY (`id`)
  ) ENGINE = InnoDB;

  INSERT INTO `modify_prices_locations` (`modify_price_id`, `location_id`)
  SELECT `id`, `location_id` FROM `modify_prices`;

  ALTER TABLE `modify_prices` DROP `location_id`;

COMMIT;