ALTER TABLE `location` ADD COLUMN `warehouseUnitId` int(10) NOT NULL DEFAULT 1 AFTER `id`;
ALTER TABLE `location` DROP INDEX `storeId`;
ALTER TABLE `location` DROP COLUMN `storeId`;

DROP INDEX `name` ON `location`;
CREATE UNIQUE INDEX warehouseunit_name ON location (warehouseUnitId, name);
CREATE INDEX `name` ON `location`(`name`) USING BTREE ;
