From f4b4425862dab8ea743d9fa52097f7d742984a59 Mon Sep 17 00:00:00 2001 From: TDB Release Date: Fri, 14 Aug 2020 21:46:30 +0000 Subject: TDB 837.20081 - 2020/08/14 --- sql/base/dev/hotfixes_database.sql | 9 ++++--- sql/base/dev/world_database.sql | 52 ++++++++++++++------------------------ 2 files changed, 24 insertions(+), 37 deletions(-) (limited to 'sql/base/dev') diff --git a/sql/base/dev/hotfixes_database.sql b/sql/base/dev/hotfixes_database.sql index 3b4f0c3cd87..9715d3b8f55 100644 --- a/sql/base/dev/hotfixes_database.sql +++ b/sql/base/dev/hotfixes_database.sql @@ -1,8 +1,8 @@ --- MySQL dump 10.13 Distrib 5.7.29, for Linux (x86_64) +-- MySQL dump 10.13 Distrib 5.7.30, for Linux (x86_64) -- -- Host: localhost Database: hotfixes -- ------------------------------------------------------ --- Server version 5.7.29-0ubuntu0.18.04.1 +-- Server version 5.7.30-0ubuntu0.18.04.1 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; @@ -3317,9 +3317,10 @@ DROP TABLE IF EXISTS `hotfix_blob`; CREATE TABLE `hotfix_blob` ( `TableHash` int(10) unsigned NOT NULL, `RecordId` int(11) NOT NULL, + `locale` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `Blob` blob, `VerifiedBuild` int(11) NOT NULL DEFAULT '0', - PRIMARY KEY (`TableHash`,`RecordId`) + PRIMARY KEY (`TableHash`,`RecordId`,`locale`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; @@ -7975,4 +7976,4 @@ CREATE TABLE `world_state_expression` ( /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2020-06-17 17:05:00 +-- Dump completed on 2020-08-14 21:41:28 diff --git a/sql/base/dev/world_database.sql b/sql/base/dev/world_database.sql index 2baf0163bd7..bbc606d9c61 100644 --- a/sql/base/dev/world_database.sql +++ b/sql/base/dev/world_database.sql @@ -1,8 +1,8 @@ --- MySQL dump 10.13 Distrib 5.7.29, for Linux (x86_64) +-- MySQL dump 10.13 Distrib 5.7.30, for Linux (x86_64) -- -- Host: localhost Database: world -- ------------------------------------------------------ --- Server version 5.7.29-0ubuntu0.18.04.1 +-- Server version 5.7.30-0ubuntu0.18.04.1 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; @@ -532,20 +532,6 @@ CREATE TABLE `creature_classlevelstats` ( ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; --- --- Table structure for table `creature_default_trainer` --- - -DROP TABLE IF EXISTS `creature_default_trainer`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `creature_default_trainer` ( - `CreatureId` int(11) unsigned NOT NULL, - `TrainerId` int(11) unsigned NOT NULL DEFAULT '0', - PRIMARY KEY (`CreatureId`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8; -/*!40101 SET character_set_client = @saved_cs_client */; - -- -- Table structure for table `creature_equip_template` -- @@ -928,6 +914,22 @@ CREATE TABLE `creature_text_locale` ( ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; +-- +-- Table structure for table `creature_trainer` +-- + +DROP TABLE IF EXISTS `creature_trainer`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `creature_trainer` ( + `CreatureId` int(11) unsigned NOT NULL, + `TrainerId` int(11) unsigned NOT NULL DEFAULT '0', + `MenuId` int(10) unsigned NOT NULL DEFAULT '0', + `OptionIndex` int(10) unsigned NOT NULL DEFAULT '0', + PRIMARY KEY (`CreatureId`,`MenuId`,`OptionIndex`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + -- -- Table structure for table `criteria_data` -- @@ -1667,21 +1669,6 @@ CREATE TABLE `gossip_menu_option_locale` ( ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; --- --- Table structure for table `gossip_menu_option_trainer` --- - -DROP TABLE IF EXISTS `gossip_menu_option_trainer`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `gossip_menu_option_trainer` ( - `MenuId` int(10) unsigned NOT NULL DEFAULT '0', - `OptionIndex` int(10) unsigned NOT NULL DEFAULT '0', - `TrainerId` int(11) unsigned NOT NULL DEFAULT '0', - PRIMARY KEY (`MenuId`,`OptionIndex`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8; -/*!40101 SET character_set_client = @saved_cs_client */; - -- -- Table structure for table `graveyard_zone` -- @@ -4110,7 +4097,6 @@ CREATE TABLE `version` ( `core_revision` varchar(120) DEFAULT NULL, `db_version` varchar(120) DEFAULT NULL COMMENT 'Version of world DB.', `cache_id` int(11) DEFAULT '0', - `hotfix_cache_id` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`core_version`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Version Notes'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -4227,4 +4213,4 @@ CREATE TABLE `world_safe_locs` ( /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2020-06-17 17:04:59 +-- Dump completed on 2020-08-14 21:41:27 -- cgit v1.2.3