Merge branch '4.3.4_phases' of https://github.com/TrinityCore/TrinityCore into 4.3.4

1 files changed, 31 insertions, 0 deletions

diff --git a/sql/updates/world/2014_06_02_00_world_phases_434.sql b/sql/updates/world/2014_06_02_00_world_phases_434.sql
new file mode 100644
index 00000000000..1c1b0a19f23
--- /dev/null
+++ b/sql/updates/world/2014_06_02_00_world_phases_434.sql
@@ -0,0 +1,31 @@
+DROP TABLE IF EXISTS `spell_phase`;
+DROP TABLE IF EXISTS `phase_definitions`;
+
+/*Table structure for table `phase_definitions` */
+
+DROP TABLE IF EXISTS `phase_definitions`;
+
+CREATE TABLE `phase_definitions` (
+  `zoneId` int(10) unsigned NOT NULL DEFAULT '0',
+  `entry` int(10) unsigned NOT NULL AUTO_INCREMENT,
+  `phaseId` int(10) unsigned NOT NULL DEFAULT '0',
+  `phaseGroup` int(10) NOT NULL DEFAULT '0',
+  `comment` text,
+  PRIMARY KEY (`zoneId`,`entry`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+/*Table structure for table `phase_info` */
+
+DROP TABLE IF EXISTS `phase_info`;
+
+CREATE TABLE `phase_info` (
+  `id` int(10) unsigned NOT NULL DEFAULT '0',
+  `worldmapareaswap` int(10) unsigned NOT NULL DEFAULT '0',
+  `terrainswapmap` int(10) unsigned NOT NULL DEFAULT '0',
+  `comment` varchar(255) DEFAULT NULL,
+  PRIMARY KEY (`id`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+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`;
\ No newline at end of file