diff options
Diffstat (limited to 'sql/updates')
| -rw-r--r-- | sql/updates/hotfixes/2015_03_04_00_hotfixes.sql | 223 |
1 files changed, 223 insertions, 0 deletions
diff --git a/sql/updates/hotfixes/2015_03_04_00_hotfixes.sql b/sql/updates/hotfixes/2015_03_04_00_hotfixes.sql new file mode 100644 index 00000000000..cda2e375976 --- /dev/null +++ b/sql/updates/hotfixes/2015_03_04_00_hotfixes.sql @@ -0,0 +1,223 @@ +-- +-- Table structure for table `area_group` +-- + +DROP TABLE IF EXISTS `area_group`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `area_group` ( + `ID` 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 `area_group` +-- + +LOCK TABLES `area_group` WRITE; +/*!40000 ALTER TABLE `area_group` DISABLE KEYS */; +/*!40000 ALTER TABLE `area_group` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `area_group_member` +-- + +DROP TABLE IF EXISTS `area_group_member`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `area_group_member` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `AreaGroupID` int(10) unsigned NOT NULL DEFAULT '0', + `AreaID` 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 `area_group_member` +-- + +LOCK TABLES `area_group_member` WRITE; +/*!40000 ALTER TABLE `area_group_member` DISABLE KEYS */; +/*!40000 ALTER TABLE `area_group_member` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `currency_types` +-- + +DROP TABLE IF EXISTS `currency_types`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `currency_types` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `CategoryID` int(10) unsigned NOT NULL DEFAULT '0', + `Name` text, + `InventoryIcon1` text, + `InventoryIcon2` text, + `SpellWeight` int(10) unsigned NOT NULL DEFAULT '0', + `SpellCategory` int(10) unsigned NOT NULL DEFAULT '0', + `MaxQty` int(10) unsigned NOT NULL DEFAULT '0', + `MaxEarnablePerWeek` int(10) unsigned NOT NULL DEFAULT '0', + `Flags` int(10) unsigned NOT NULL DEFAULT '0', + `Quality` int(10) unsigned NOT NULL DEFAULT '0', + `Description` text, + `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 `currency_types` +-- + +LOCK TABLES `currency_types` WRITE; +/*!40000 ALTER TABLE `currency_types` DISABLE KEYS */; +/*!40000 ALTER TABLE `currency_types` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `currency_types_locale` +-- + +DROP TABLE IF EXISTS `currency_types_locale`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `currency_types_locale` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `locale` varchar(4) NOT NULL, + `Name_lang` text, + `InventoryIcon1_lang` text, + `InventoryIcon2_lang` text, + `Description_lang` text, + `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0', + PRIMARY KEY (`ID`,`locale`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Dumping data for table `currency_types_locale` +-- + +LOCK TABLES `currency_types_locale` WRITE; +/*!40000 ALTER TABLE `currency_types_locale` DISABLE KEYS */; +/*!40000 ALTER TABLE `currency_types_locale` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `curve_point` +-- + +-- +-- Table structure for table `sound_entries` +-- + +DROP TABLE IF EXISTS `sound_entries`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `sound_entries` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `SoundType` int(10) unsigned NOT NULL DEFAULT '0', + `Name` text, + `FileDataID1` int(10) unsigned NOT NULL DEFAULT '0', + `FileDataID2` int(10) unsigned NOT NULL DEFAULT '0', + `FileDataID3` int(10) unsigned NOT NULL DEFAULT '0', + `FileDataID4` int(10) unsigned NOT NULL DEFAULT '0', + `FileDataID5` int(10) unsigned NOT NULL DEFAULT '0', + `FileDataID6` int(10) unsigned NOT NULL DEFAULT '0', + `FileDataID7` int(10) unsigned NOT NULL DEFAULT '0', + `FileDataID8` int(10) unsigned NOT NULL DEFAULT '0', + `FileDataID9` int(10) unsigned NOT NULL DEFAULT '0', + `FileDataID10` int(10) unsigned NOT NULL DEFAULT '0', + `FileDataID11` int(10) unsigned NOT NULL DEFAULT '0', + `FileDataID12` int(10) unsigned NOT NULL DEFAULT '0', + `FileDataID13` int(10) unsigned NOT NULL DEFAULT '0', + `FileDataID14` int(10) unsigned NOT NULL DEFAULT '0', + `FileDataID15` int(10) unsigned NOT NULL DEFAULT '0', + `FileDataID16` int(10) unsigned NOT NULL DEFAULT '0', + `FileDataID17` int(10) unsigned NOT NULL DEFAULT '0', + `FileDataID18` int(10) unsigned NOT NULL DEFAULT '0', + `FileDataID19` int(10) unsigned NOT NULL DEFAULT '0', + `FileDataID20` int(10) unsigned NOT NULL DEFAULT '0', + `Freq1` int(10) unsigned NOT NULL DEFAULT '0', + `Freq2` int(10) unsigned NOT NULL DEFAULT '0', + `Freq3` int(10) unsigned NOT NULL DEFAULT '0', + `Freq4` int(10) unsigned NOT NULL DEFAULT '0', + `Freq5` int(10) unsigned NOT NULL DEFAULT '0', + `Freq6` int(10) unsigned NOT NULL DEFAULT '0', + `Freq7` int(10) unsigned NOT NULL DEFAULT '0', + `Freq8` int(10) unsigned NOT NULL DEFAULT '0', + `Freq9` int(10) unsigned NOT NULL DEFAULT '0', + `Freq10` int(10) unsigned NOT NULL DEFAULT '0', + `Freq11` int(10) unsigned NOT NULL DEFAULT '0', + `Freq12` int(10) unsigned NOT NULL DEFAULT '0', + `Freq13` int(10) unsigned NOT NULL DEFAULT '0', + `Freq14` int(10) unsigned NOT NULL DEFAULT '0', + `Freq15` int(10) unsigned NOT NULL DEFAULT '0', + `Freq16` int(10) unsigned NOT NULL DEFAULT '0', + `Freq17` int(10) unsigned NOT NULL DEFAULT '0', + `Freq18` int(10) unsigned NOT NULL DEFAULT '0', + `Freq19` int(10) unsigned NOT NULL DEFAULT '0', + `Freq20` int(10) unsigned NOT NULL DEFAULT '0', + `VolumeFloat` float NOT NULL DEFAULT '0', + `Flags` int(10) unsigned NOT NULL DEFAULT '0', + `MinDistance` float NOT NULL DEFAULT '0', + `DistanceCutoff` float NOT NULL DEFAULT '0', + `EAXDef` int(10) unsigned NOT NULL DEFAULT '0', + `SoundEntriesAdvancedID` int(10) unsigned NOT NULL DEFAULT '0', + `VolumeVariationPlus` float NOT NULL DEFAULT '0', + `VolumeVariationMinus` float NOT NULL DEFAULT '0', + `PitchVariationPlus` float NOT NULL DEFAULT '0', + `PitchVariationMinus` float NOT NULL DEFAULT '0', + `PitchAdjust` float NOT NULL DEFAULT '0', + `DialogType` int(10) unsigned NOT NULL DEFAULT '0', + `BusOverwriteID` 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 `sound_entries` +-- + +LOCK TABLES `sound_entries` WRITE; +/*!40000 ALTER TABLE `sound_entries` DISABLE KEYS */; +/*!40000 ALTER TABLE `sound_entries` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `sound_entries_locale` +-- + +DROP TABLE IF EXISTS `sound_entries_locale`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `sound_entries_locale` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `locale` varchar(4) NOT NULL, + `Name_lang` text, + `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0', + PRIMARY KEY (`ID`,`locale`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Dumping data for table `sound_entries_locale` +-- + +LOCK TABLES `sound_entries_locale` WRITE; +/*!40000 ALTER TABLE `sound_entries_locale` DISABLE KEYS */; +/*!40000 ALTER TABLE `sound_entries_locale` ENABLE KEYS */; +UNLOCK TABLES; + +ALTER TABLE `item_extended_cost` + DROP `RequiredHonorPoints`, + DROP `RequiredArenaPoints`, + ADD `RequiredMoney` int(10) unsigned NOT NULL DEFAULT '0' AFTER `RequiredAchievement`; + +ALTER TABLE `taxi_nodes` ADD `LearnableIndex` int(10) unsigned NOT NULL DEFAULT '0' AFTER `ConditionID`; |