Commits

sk89q authored 79862389363
Add migrations for region MySQL support.
No tags

contrib/region_manual_update_20110325.sql

Renamed
1 +--
2 +-- This file only needs to be run if you are using a very old version
3 +-- of the region database (before 2011/03/25).
4 +--
5 +-- Otherwise, WG knows how to update your tables automatically, as well
6 +-- as set them up initially.
7 +--
8 +
1 9 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
2 10 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
3 11 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL';
4 12
5 13 ALTER TABLE `region_cuboid` DROP FOREIGN KEY `fk_region_cuboid_region` ;
6 14
7 15 ALTER TABLE `region_flag` DROP FOREIGN KEY `fk_flags_region1` ;
8 16
9 17 ALTER TABLE `region_groups` DROP FOREIGN KEY `fk_region_groups_region` ;
10 18

Everything looks good. We'll let you know here if there's anything you should know about.

Add shortcut