From 791466234b5e800b5710ddfaf7b4b18e190b7883 Mon Sep 17 00:00:00 2001 From: VladimirMangos Date: Wed, 30 Sep 2009 02:38:13 +0400 Subject: [PATCH] [8567] Include DB changes from [8548-8549] into mangos.sql --- sql/mangos.sql | 123 +++++++++++++++++++++ sql/updates/8549_03_mangos_battleground_events.sql | 2 +- src/shared/revision_nr.h | 2 +- 3 files changed, 125 insertions(+), 2 deletions(-) diff --git a/sql/mangos.sql b/sql/mangos.sql index 9071133cc..6c460fc96 100644 --- a/sql/mangos.sql +++ b/sql/mangos.sql @@ -179,6 +179,87 @@ LOCK TABLES `areatrigger_teleport` WRITE; UNLOCK TABLES; -- +-- Table structure for table `battleground_events` +-- + +DROP TABLE IF EXISTS `battleground_events`; +CREATE TABLE `battleground_events` ( + `map` smallint(5) NOT NULL, + `event1` tinyint(3) unsigned NOT NULL, + `event2` tinyint(3) unsigned NOT NULL, + `description` varchar(255) NOT NULL, + PRIMARY KEY (`map`,`event1`,`event2`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; + +-- +-- Dumping data for table `battleground_events` +-- + +LOCK TABLES `battleground_events` WRITE; +/*!40000 ALTER TABLE `battleground_events` DISABLE KEYS */; +INSERT INTO battleground_events (map, event1, event2, description) VALUES +-- WS +(489, 0, 0, 'Alliance Flag'), +(489, 1, 0, 'Horde Flag'), +(489, 2, 0, 'Spirit Guides'), +(489, 254, 0, 'Doors'), +-- AB +(529, 0, 0, 'Stables - neutral'), +(529, 0, 1, 'Stables - alliance contested'), +(529, 0, 2, 'Stables - horde contested'), +(529, 0, 3, 'Stables - alliance owned'), +(529, 0, 4, 'Stables - horde owned'), +(529, 1, 0, 'Blacksmith - neutral'), +(529, 1, 1, 'Blacksmith - alliance contested'), +(529, 1, 2, 'Blacksmith - horde contested'), +(529, 1, 3, 'Blacksmith - alliance owned'), +(529, 1, 4, 'Blacksmith - horde owned'), +(529, 2, 0, 'Farm - neutral'), +(529, 2, 1, 'Farm - alliance contested'), +(529, 2, 2, 'Farm - horde contested'), +(529, 2, 3, 'Farm - alliance owned'), +(529, 2, 4, 'Farm - horde owned'), +(529, 3, 0, 'Lumber Mill - neutral'), +(529, 3, 1, 'Lumber Mill - alliance contested'), +(529, 3, 2, 'Lumber Mill - horde contested'), +(529, 3, 3, 'Lumber Mill - alliance owned'), +(529, 3, 4, 'Lumber Mill - horde owned'), +(529, 4, 0, 'Gold Mine - neutral'), +(529, 4, 1, 'Gold Mine - alliance contested'), +(529, 4, 2, 'Gold Mine - horde contested'), +(529, 4, 3, 'Gold Mine - alliance owned'), +(529, 4, 4, 'Gold Mine - horde owned'), +(529, 254, 0, 'doors'), +-- EY +(566, 0, 0, 'Fel Reaver - alliance'), +(566, 0, 1, 'Fel Reaver - horde'), +(566, 0, 2, 'Fel Reaver - neutral'), +(566, 1, 0, 'Blood Elf - alliance'), +(566, 1, 1, 'Blood Elf - horde'), +(566, 1, 2, 'Blood Elf - neutral'), +(566, 2, 0, 'Draenei Ruins - alliance'), +(566, 2, 1, 'Draenei Ruins - horde'), +(566, 2, 2, 'Draenei Ruins - neutral'), +(566, 3, 0, 'Mage Tower - alliance'), +(566, 3, 1, 'Mage Tower - horde'), +(566, 3, 2, 'Mage Tower - neutral'), +(566, 4, 0, 'capture flag - Fel Reaver'), +(566, 4, 1, 'capture flag - Blood Elf'), +(566, 4, 2, 'capture flag - Draenei Ruins'), +(566, 4, 3, 'capture flag - Mage Tower'), +(566, 4, 4, 'capture flag - center'), +(566, 254, 0, 'doors'), +-- arenas +(559, 253, 0, 'buffs'), +(559, 254, 0, 'doors'), +(572, 253, 0, 'buffs'), +(572, 254, 0, 'doors'), +(562, 253, 0, 'buffs'), +(562, 254, 0, 'doors'); +/*!40000 ALTER TABLE `battleground_events` ENABLE KEYS */; +UNLOCK TABLES; + +-- -- Table structure for table `battleground_template` -- @@ -584,6 +665,27 @@ LOCK TABLES `creature_addon` WRITE; UNLOCK TABLES; -- +-- Table structure for table `creature_battleground` +-- + +DROP TABLE IF EXISTS `creature_battleground`; +CREATE TABLE `creature_battleground` ( + `guid` int(10) unsigned NOT NULL COMMENT 'Creature\'s GUID', + `event1` tinyint(3) unsigned NOT NULL COMMENT 'main event', + `event2` tinyint(3) unsigned NOT NULL COMMENT 'sub event', + PRIMARY KEY (`guid`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Creature battleground indexing system'; + +-- +-- Dumping data for table `creature_battleground` +-- + +LOCK TABLES `creature_battleground` WRITE; +/*!40000 ALTER TABLE `creature_battleground` DISABLE KEYS */; +/*!40000 ALTER TABLE `creature_battleground` ENABLE KEYS */; +UNLOCK TABLES; + +-- -- Table structure for table `creature_equip_template` -- @@ -1423,6 +1525,27 @@ LOCK TABLES `gameobject` WRITE; UNLOCK TABLES; -- +-- Table structure for table `gameobject_battleground` +-- + +DROP TABLE IF EXISTS `gameobject_battleground`; +CREATE TABLE `gameobject_battleground` ( + `guid` int(10) unsigned NOT NULL COMMENT 'GameObject\'s GUID', + `event1` tinyint(3) unsigned NOT NULL COMMENT 'main event', + `event2` tinyint(3) unsigned NOT NULL COMMENT 'sub event', + PRIMARY KEY (`guid`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='GameObject battleground indexing system'; + +-- +-- Dumping data for table `gameobject_battleground` +-- + +LOCK TABLES `gameobject_battleground` WRITE; +/*!40000 ALTER TABLE `gameobject_battleground` DISABLE KEYS */; +/*!40000 ALTER TABLE `gameobject_battleground` ENABLE KEYS */; +UNLOCK TABLES; + +-- -- Table structure for table `gameobject_involvedrelation` -- diff --git a/sql/updates/8549_03_mangos_battleground_events.sql b/sql/updates/8549_03_mangos_battleground_events.sql index 63bedd54d..f310af3ad 100644 --- a/sql/updates/8549_03_mangos_battleground_events.sql +++ b/sql/updates/8549_03_mangos_battleground_events.sql @@ -89,4 +89,4 @@ INSERT INTO battleground_events (map, event1, event2, description) VALUES (@RL_MAP, 254, 0, 'doors'), (@BE_MAP, 253, 0, 'buffs'), - (@BE_MAP, 254, 0, 'doors') + (@BE_MAP, 254, 0, 'doors'); diff --git a/src/shared/revision_nr.h b/src/shared/revision_nr.h index 027fd85f7..17c2cc5b6 100644 --- a/src/shared/revision_nr.h +++ b/src/shared/revision_nr.h @@ -1,4 +1,4 @@ #ifndef __REVISION_NR_H__ #define __REVISION_NR_H__ - #define REVISION_NR "8566" + #define REVISION_NR "8567" #endif // __REVISION_NR_H__ -- 2.11.4.GIT