From c77e76fa61a620affdfe60ae2dae639f95091e1b Mon Sep 17 00:00:00 2001 From: funjoker Date: Sun, 5 Nov 2017 20:24:45 +0100 Subject: Core/Gameobject: Add WorldEffectID to Gameobject (#20785) --- .../hotfixes/master/9999_99_99_99_hotfixes.sql | 28 ++++++++++++++++++++++ sql/updates/world/master/2017_11_05_11_world.sql | 5 ++++ 2 files changed, 33 insertions(+) create mode 100644 sql/updates/hotfixes/master/9999_99_99_99_hotfixes.sql create mode 100644 sql/updates/world/master/2017_11_05_11_world.sql (limited to 'sql') diff --git a/sql/updates/hotfixes/master/9999_99_99_99_hotfixes.sql b/sql/updates/hotfixes/master/9999_99_99_99_hotfixes.sql new file mode 100644 index 00000000000..6654e5d42dd --- /dev/null +++ b/sql/updates/hotfixes/master/9999_99_99_99_hotfixes.sql @@ -0,0 +1,28 @@ +-- +-- Table structure for table `world_effect` +-- + +DROP TABLE IF EXISTS `world_effect`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `world_effect` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `TargetAsset` int(10) unsigned NOT NULL DEFAULT '0', + `CombatConditionID` smallint(5) unsigned NOT NULL DEFAULT '0', + `TargetType` tinyint(3) unsigned NOT NULL DEFAULT '0', + `WhenToDisplay` tinyint(3) unsigned NOT NULL DEFAULT '0', + `QuestFeedbackEffectID` int(10) unsigned NOT NULL DEFAULT '0', + `PlayerConditionID` int(10) unsigned NOT NULL DEFAULT '0', + `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0', + PRIMARY KEY (`ID`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Dumping data for table `world_effect` +-- + +LOCK TABLES `world_effect` WRITE; +/*!40000 ALTER TABLE `world_effect` DISABLE KEYS */; +/*!40000 ALTER TABLE `world_effect` ENABLE KEYS */; +UNLOCK TABLES; diff --git a/sql/updates/world/master/2017_11_05_11_world.sql b/sql/updates/world/master/2017_11_05_11_world.sql new file mode 100644 index 00000000000..76252fbb0d6 --- /dev/null +++ b/sql/updates/world/master/2017_11_05_11_world.sql @@ -0,0 +1,5 @@ +ALTER TABLE `gameobject_template_addon` + ADD COLUMN `WorldEffectID` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0' AFTER `maxgold`; + +ALTER TABLE `gameobject_addon` + ADD COLUMN `WorldEffectID` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0' AFTER `invisibilityValue`; -- cgit v1.2.3