WorldGuard MySQL RegionDB update script

SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL';

ALTER SCHEMA `worldguard`  DEFAULT CHARACTER SET utf8  DEFAULT COLLATE utf8_bin ;

USE `worldguard`;

ALTER TABLE `worldguard`.`region` DROP FOREIGN KEY `parent` ;

ALTER TABLE `worldguard`.`region_cuboid` DROP FOREIGN KEY `fk_region_cuboid_region` ;

ALTER TABLE `worldguard`.`region_flag` DROP FOREIGN KEY `fk_flags_region1` ;

ALTER TABLE `worldguard`.`region_groups` DROP FOREIGN KEY `fk_region_groups_region` ;

ALTER TABLE `worldguard`.`region_players` DROP FOREIGN KEY `fk_region_players_user` , DROP FOREIGN KEY `fk_region_players_region` ;

ALTER TABLE `worldguard`.`region_poly2d` DROP FOREIGN KEY `fk_region_poly2d_region` ;

ALTER TABLE `worldguard`.`region_poly2d_point` DROP FOREIGN KEY `fk_region_poly2d_point_region_poly2d` ;

ALTER TABLE `worldguard`.`group` CHARACTER SET = utf8 , COLLATE = utf8_bin
, ADD UNIQUE INDEX `name` (`name` ASC)
, DROP INDEX  ;

ALTER TABLE `worldguard`.`region` CHARACTER SET = utf8 , COLLATE = utf8_bin , DROP COLUMN `parent` , ADD COLUMN `parent_region_id` VARCHAR(128) CHARACTER SET 'utf8' COLLATE 'utf8_bin' NULL DEFAULT NULL  AFTER `priority` , ADD COLUMN `parent_world_id` INT(10) UNSIGNED NULL DEFAULT NULL  AFTER `parent_region_id` , DROP FOREIGN KEY `fk_region_world1` ;

ALTER TABLE `worldguard`.`region`
  ADD CONSTRAINT `fk_region_world1`
  FOREIGN KEY (`world_id` )
  REFERENCES `worldguard`.`world` (`id` )
  ON DELETE CASCADE
  ON UPDATE CASCADE,
  ADD CONSTRAINT `parent`
  FOREIGN KEY (`parent_region_id` , `parent_world_id` )
  REFERENCES `worldguard`.`region` (`id` , `world_id` )
  ON DELETE SET NULL
  ON UPDATE CASCADE
, DROP INDEX `parent`
, ADD INDEX `parent` (`parent_region_id` ASC, `parent_world_id` ASC) ;

ALTER TABLE `worldguard`.`region_cuboid` CHARACTER SET = utf8 , COLLATE = utf8_bin , ADD COLUMN `world_id` INT(10) UNSIGNED NOT NULL  AFTER `region_id` ,
  ADD CONSTRAINT `fk_region_cuboid_region`
  FOREIGN KEY (`region_id` , `world_id` )
  REFERENCES `worldguard`.`region` (`id` , `world_id` )
  ON DELETE CASCADE
  ON UPDATE CASCADE
, DROP PRIMARY KEY
, ADD PRIMARY KEY (`region_id`, `world_id`) ;

ALTER TABLE `worldguard`.`region_flag` CHARACTER SET = utf8 , COLLATE = utf8_bin , ADD COLUMN `world_id` INT(10) UNSIGNED NOT NULL  AFTER `region_id` , CHANGE COLUMN `flag` `flag` VARCHAR(45) CHARACTER SET 'utf8' COLLATE 'utf8_bin' NOT NULL  ,
  ADD CONSTRAINT `fk_flags_region`
  FOREIGN KEY (`region_id` , `world_id` )
  REFERENCES `worldguard`.`region` (`id` , `world_id` )
  ON DELETE CASCADE
  ON UPDATE CASCADE
, DROP INDEX `fk_flags_region`
, ADD INDEX `fk_flags_region` (`region_id` ASC, `world_id` ASC) ;

ALTER TABLE `worldguard`.`region_groups` CHARACTER SET = utf8 , COLLATE = utf8_bin , ADD COLUMN `world_id` INT(10) UNSIGNED NOT NULL  AFTER `region_id` , DROP FOREIGN KEY `fk_region_groups_group` ;

ALTER TABLE `worldguard`.`region_groups`
  ADD CONSTRAINT `fk_region_groups_group`
  FOREIGN KEY (`group_id` )
  REFERENCES `worldguard`.`group` (`id` )
  ON DELETE CASCADE
  ON UPDATE CASCADE,
  ADD CONSTRAINT `fk_region_groups_region`
  FOREIGN KEY (`region_id` , `world_id` )
  REFERENCES `worldguard`.`region` (`id` , `world_id` )
  ON DELETE CASCADE
  ON UPDATE CASCADE
, DROP PRIMARY KEY
, ADD PRIMARY KEY (`region_id`, `world_id`, `group_id`) ;

ALTER TABLE `worldguard`.`region_players` CHARACTER SET = utf8 , COLLATE = utf8_bin , ADD COLUMN `world_id` INT(10) UNSIGNED NOT NULL  AFTER `region_id` ,
  ADD CONSTRAINT `fk_region_users_region`
  FOREIGN KEY (`region_id` , `world_id` )
  REFERENCES `worldguard`.`region` (`id` , `world_id` )
  ON DELETE CASCADE
  ON UPDATE CASCADE,
  ADD CONSTRAINT `fk_region_users_user`
  FOREIGN KEY (`user_id` )
  REFERENCES `worldguard`.`user` (`id` )
  ON DELETE CASCADE
  ON UPDATE CASCADE
, DROP PRIMARY KEY
, ADD PRIMARY KEY (`region_id`, `world_id`, `user_id`)
, ADD INDEX `fk_region_users_user` (`user_id` ASC)
, DROP INDEX `fk_region_players_user` ;

ALTER TABLE `worldguard`.`region_poly2d` CHARACTER SET = utf8 , COLLATE = utf8_bin , ADD COLUMN `world_id` INT(10) UNSIGNED NOT NULL  AFTER `region_id` ,
  ADD CONSTRAINT `fk_region_poly2d_region`
  FOREIGN KEY (`region_id` , `world_id` )
  REFERENCES `worldguard`.`region` (`id` , `world_id` )
  ON DELETE CASCADE
  ON UPDATE CASCADE
, DROP PRIMARY KEY
, ADD PRIMARY KEY (`region_id`, `world_id`) ;

ALTER TABLE `worldguard`.`region_poly2d_point` CHARACTER SET = utf8 , COLLATE = utf8_bin , ADD COLUMN `world_id` INT(10) UNSIGNED NOT NULL  AFTER `region_id` , CHANGE COLUMN `id` `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT  ,
  ADD CONSTRAINT `fk_region_poly2d_point_region_poly2d`
  FOREIGN KEY (`region_id` , `world_id` )
  REFERENCES `worldguard`.`region_poly2d` (`region_id` , `world_id` )
  ON DELETE CASCADE
  ON UPDATE CASCADE
, DROP INDEX `fk_region_poly2d_point_region_poly2d`
, ADD INDEX `fk_region_poly2d_point_region_poly2d` (`region_id` ASC, `world_id` ASC) ;

ALTER TABLE `worldguard`.`user` CHARACTER SET = utf8 , COLLATE = utf8_bin
, ADD UNIQUE INDEX `name` (`name` ASC)
, DROP INDEX  ;

ALTER TABLE `worldguard`.`world` CHARACTER SET = utf8 , COLLATE = utf8_bin
, ADD UNIQUE INDEX `name` (`name` ASC)
, DROP INDEX  ;


SET SQL_MODE=@OLD_SQL_MODE;
SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;