Created
April 10, 2015 20:41
-
-
Save Goatform/7af7c0823f3861bec815 to your computer and use it in GitHub Desktop.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| ALTER TABLE `creature` | |
| ADD `PhaseId` INT(10) DEFAULT '0' AFTER `phaseMask`, | |
| ADD `PhaseGroup` INT(10) DEFAULT '0' AFTER `PhaseId`; | |
| ALTER TABLE `gameobject` | |
| ADD `PhaseId` INT(10) DEFAULT '0' AFTER `phaseMask`, | |
| ADD `PhaseGroup` INT(10) DEFAULT '0' AFTER `PhaseId`; | |
| DROP TABLE IF EXISTS `spell_phase`; | |
| /*Table structure for table `phase_definitions` */ | |
| ALTER TABLE `transports` | |
| ADD COLUMN `phaseid` INT(10) NOT NULL DEFAULT 0 AFTER `name`, | |
| ADD COLUMN `phasegroup` INT(10) NOT NULL DEFAULT 0 AFTER `phaseid`; | |
| UPDATE `creature` SET `phaseMask`=1 WHERE `id`=21347; | |
| DELETE FROM `gameobject` WHERE `guid` IN (66459, 66460, 66461, 66462, 66463, 66464, 66465, 66466, 66467, 66468, 66469, 66470, 66478, 66479, 66516, 66518, 66520, 66600, 66601, 66602, 66603, 66604, 66605, 66606, 66607, 66608, 66609, 66610, 74688, 74690, 74696, 74698, 74702, 74704, 74706, 74712, 74714, 74720, 74722, 74724, 74726, 74728, 74730, 74732, 74734, 74736, 74738, 74740, 74742, 74744, 74746, 74748, 74750, 74752, 74754, 74756, 74758, 74760, 74762, 74764, 74766, 74768, 74770, 74772); | |
| DROP TABLE IF EXISTS `phase_definitions`; | |
| DROP TABLE IF EXISTS `phase_info`; | |
| DROP TABLE IF EXISTS `terrain_phase_info`; | |
| DROP TABLE IF EXISTS `terrain_map_info`; | |
| CREATE TABLE `terrain_phase_info`( | |
| `Id` INT(10) unsigned NOT NULL, | |
| `TerrainSwapMap` INT(10) unsigned NOT NULL, | |
| `Comment` VARCHAR(255), | |
| PRIMARY KEY (`Id`, `TerrainSwapMap`) | |
| ); | |
| CREATE TABLE `terrain_map_info`( | |
| `MapId` INT(10) unsigned NOT NULL, | |
| `TerrainSwapMap` INT(10) unsigned NOT NULL, | |
| `Comment` VARCHAR(255), | |
| PRIMARY KEY (`MapId`, `TerrainSwapMap`) | |
| ); | |
| DELETE FROM `terrain_map_info` WHERE `MapId` IN (656, 655); | |
| INSERT INTO `terrain_map_info` (MapId, TerrainSwapMap, Comment) VALUES | |
| (655, 677, 'Gilneas_terrain1'), | |
| (656, 679, 'Gilneas_terrain2'); | |
| DELETE FROM `terrain_phase_info` WHERE `Id` IN (182, 186); | |
| INSERT INTO `terrain_phase_info` (Id, TerrainSwapMap, Comment) VALUES | |
| (182, 655, 'Quest Zone-Specific 07'), | |
| (186, 656, 'Quest Zone-Specific 11'); | |
| DELETE FROM `terrain_phase_info` WHERE `Id` = 0; | |
| INSERT INTO `terrain_phase_info` (Id, TerrainSwapMap, Comment) VALUES | |
| (0, 638, 'Gilneas default terrain swap'); |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment