From a054ce864d29127cef2cb68e1c19328e28e5e90b Mon Sep 17 00:00:00 2001 From: TDB Release Date: Fri, 16 Aug 2019 06:27:38 +0000 Subject: TDB 335.19081 - 2019/08/16 --- sql/base/auth_database.sql | 51 +++++++++--------- sql/base/characters_database.sql | 72 ++++++++++++------------- sql/base/dev/world_database.sql | 114 +++++++++++++++++++-------------------- 3 files changed, 118 insertions(+), 119 deletions(-) (limited to 'sql/base') diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql index ffcd11d5257..61c08d40e26 100644 --- a/sql/base/auth_database.sql +++ b/sql/base/auth_database.sql @@ -15,29 +15,6 @@ /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; --- --- Table structure for table `secret_digest` --- - -DROP TABLE IF EXISTS `secret_digest`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `secret_digest` ( - `id` int(10) unsigned not null, - `digest` varchar(100) not null, - PRIMARY KEY (`id`) -) ENGINE=InnoDB; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `secret_digest` --- - -LOCK TABLES `secret_digest` WRITE; -/*!40000 ALTER TABLE `secret_digest` DISABLE KEYS */; -/*!40000 ALTER TABLE `secret_digest` ENABLE KEYS */; -UNLOCK TABLES; - -- -- Table structure for table `account` -- @@ -1755,6 +1732,29 @@ INSERT INTO `realmlist` VALUES /*!40000 ALTER TABLE `realmlist` ENABLE KEYS */; UNLOCK TABLES; +-- +-- Table structure for table `secret_digest` +-- + +DROP TABLE IF EXISTS `secret_digest`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `secret_digest` ( + `id` int(10) unsigned NOT NULL, + `digest` varchar(100) NOT NULL, + PRIMARY KEY (`id`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Dumping data for table `secret_digest` +-- + +LOCK TABLES `secret_digest` WRITE; +/*!40000 ALTER TABLE `secret_digest` DISABLE KEYS */; +/*!40000 ALTER TABLE `secret_digest` ENABLE KEYS */; +UNLOCK TABLES; + -- -- Table structure for table `updates` -- @@ -1832,7 +1832,8 @@ INSERT INTO `updates` VALUES ('2019_07_16_00_auth.sql','36CB53A9EBD64BFDCF7030083E36E534F1753773','ARCHIVED','2019-07-16 00:00:00',0), ('2019_07_17_00_auth.sql','4F983F039904894ACC483BE885676C5F0A18F06B','ARCHIVED','2019-07-17 00:00:00',0), ('2019_08_10_00_auth.sql','E936802893474BB9B459D01BB5F181F54EDF0653','ARCHIVED','2019-08-10 00:00:00',0), -('2019_08_10_01_auth.sql','C58357260F0C70DA226A71F7E05DE2C49AAEFD74','ARCHIVED','2019-08-10 00:00:00',0); +('2019_08_10_01_auth.sql','C58357260F0C70DA226A71F7E05DE2C49AAEFD74','ARCHIVED','2019-08-10 00:00:00',0), +('2019_08_16_00_auth.sql','99CF9C250EFBBD703DF0A2D1BDEB1E46D1063EE9','ARCHIVED','2019-08-16 06:25:07',0); /*!40000 ALTER TABLE `updates` ENABLE KEYS */; UNLOCK TABLES; @@ -1934,4 +1935,4 @@ SET character_set_client = @saved_cs_client; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2019-07-15 5:57:44 +-- Dump completed on 2019-08-16 6:25:10 diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql index 668c8adb45f..b786a9e588f 100644 --- a/sql/base/characters_database.sql +++ b/sql/base/characters_database.sql @@ -115,29 +115,29 @@ CREATE TABLE `addons` ( LOCK TABLES `addons` WRITE; /*!40000 ALTER TABLE `addons` DISABLE KEYS */; INSERT INTO `addons` VALUES -('Blizzard_AchievementUI', 1276933997), -('Blizzard_ArenaUI', 1276933997), -('Blizzard_AuctionUI', 1276933997), -('Blizzard_BarbershopUI', 1276933997), -('Blizzard_BattlefieldMinimap', 1276933997), -('Blizzard_BindingUI', 1276933997), -('Blizzard_Calendar', 1276933997), -('Blizzard_CombatLog', 1276933997), -('Blizzard_CombatText', 1276933997), -('Blizzard_DebugTools', 1276933997), -('Blizzard_GlyphUI', 1276933997), -('Blizzard_GMChatUI', 1276933997), -('Blizzard_GMSurveyUI', 1276933997), -('Blizzard_GuildBankUI', 1276933997), -('Blizzard_InspectUI', 1276933997), -('Blizzard_ItemSocketingUI', 1276933997), -('Blizzard_MacroUI', 1276933997), -('Blizzard_RaidUI', 1276933997), -('Blizzard_TalentUI', 1276933997), -('Blizzard_TimeManager', 1276933997), -('Blizzard_TokenUI', 1276933997), -('Blizzard_TradeSkillUI', 1276933997), -('Blizzard_TrainerUI', 1276933997); +('Blizzard_AchievementUI',1276933997), +('Blizzard_ArenaUI',1276933997), +('Blizzard_AuctionUI',1276933997), +('Blizzard_BarbershopUI',1276933997), +('Blizzard_BattlefieldMinimap',1276933997), +('Blizzard_BindingUI',1276933997), +('Blizzard_Calendar',1276933997), +('Blizzard_CombatLog',1276933997), +('Blizzard_CombatText',1276933997), +('Blizzard_DebugTools',1276933997), +('Blizzard_GlyphUI',1276933997), +('Blizzard_GMChatUI',1276933997), +('Blizzard_GMSurveyUI',1276933997), +('Blizzard_GuildBankUI',1276933997), +('Blizzard_InspectUI',1276933997), +('Blizzard_ItemSocketingUI',1276933997), +('Blizzard_MacroUI',1276933997), +('Blizzard_RaidUI',1276933997), +('Blizzard_TalentUI',1276933997), +('Blizzard_TimeManager',1276933997), +('Blizzard_TokenUI',1276933997), +('Blizzard_TradeSkillUI',1276933997), +('Blizzard_TrainerUI',1276933997); /*!40000 ALTER TABLE `addons` ENABLE KEYS */; UNLOCK TABLES; @@ -2610,7 +2610,7 @@ INSERT INTO `updates` VALUES ('2015_10_28_00_characters.sql','622A9CA8FCE690429EBE23BA071A37C7A007BF8B','ARCHIVED','2015-10-19 14:32:22',0), ('2015_10_29_00_characters_335.sql','4555A7F35C107E54C13D74D20F141039ED42943E','ARCHIVED','2015-10-29 17:05:43',0), ('2015_11_03_00_characters.sql','CC045717B8FDD9733351E52A5302560CD08AAD57','ARCHIVED','2015-10-12 15:23:33',0), -('2015_11_07_00_characters.sql','0ACDD35EC9745231BCFA701B78056DEF94D0CC53','ARCHIVED','2016-04-11 00:42:36',94), +('2015_11_07_00_characters.sql','0ACDD35EC9745231BCFA701B78056DEF94D0CC53','ARCHIVED','2016-04-11 00:42:36',0), ('2016_02_10_00_characters.sql','F1B4DA202819CABC7319A4470A2D224A34609E97','ARCHIVED','2016-02-10 00:00:00',0), ('2016_03_13_2016_01_05_00_characters.sql','0EAD24977F40DE2476B4567DA2B477867CC0DA1A','ARCHIVED','2016-03-13 20:03:56',0), ('2016_04_11_00_characters.sql','0ACDD35EC9745231BCFA701B78056DEF94D0CC53','ARCHIVED','2016-04-11 03:18:17',0), @@ -2635,8 +2635,8 @@ INSERT INTO `updates` VALUES ('2019_07_14_00_characters.sql','A141F4F15BDF0320483921429871D4C572BD7E2D','ARCHIVED','2019-07-04 00:00:00',0), ('2019_07_15_00_characters.sql','5BCF35896BB36A306CE79CF1E3F1945FAF9019D9','ARCHIVED','2019-07-15 00:00:00',0), ('2019_07_15_01_characters.sql','5D383B026AB9EDE7114F249D206DE7E432E19468','ARCHIVED','2019-07-15 00:00:00',0), -('2019_07_16_00_characters.sql','76AE193EFA3129FA1702BF7B6FA7C4127B543BDF','ARCHIVED','2019-07-16 00:00:00',0); - +('2019_07_16_00_characters.sql','76AE193EFA3129FA1702BF7B6FA7C4127B543BDF','ARCHIVED','2019-07-16 00:00:00',0), +('2019_08_16_00_characters.sql','7E21060060513C9504107C4A06B106166CC0768E','ARCHIVED','2019-08-16 06:25:07',0); /*!40000 ALTER TABLE `updates` ENABLE KEYS */; UNLOCK TABLES; @@ -2725,11 +2725,11 @@ INSERT INTO `worldstates` VALUES (11,0,NULL), (12,0,NULL), (13,0,NULL), -(14,1476626581,NULL), -(15,1476626581,NULL), +(14,0,NULL), +(15,0,NULL), (16,0,NULL), (17,0,NULL), -(18,1476626581,NULL), +(18,0,NULL), (19,0,NULL), (20,0,NULL), (21,0,NULL), @@ -2738,14 +2738,14 @@ INSERT INTO `worldstates` VALUES (24,0,NULL), (25,0,NULL), (26,0,NULL), -(27,1476626581,NULL), +(27,0,NULL), (28,0,NULL), (29,0,NULL), (30,0,NULL), (31,0,NULL), (32,0,NULL), (33,0,NULL), -(34,1476626581,NULL), +(34,0,NULL), (35,0,NULL), (36,0,NULL), (37,0,NULL), @@ -2771,9 +2771,9 @@ INSERT INTO `worldstates` VALUES (57,0,NULL), (58,0,NULL), (59,0,NULL), -(60,1476626581,NULL), +(60,0,NULL), (61,0,NULL), -(62,1476626581,NULL), +(62,0,NULL), (63,0,NULL), (64,0,NULL), (65,0,NULL), @@ -2781,9 +2781,9 @@ INSERT INTO `worldstates` VALUES (67,0,NULL), (68,0,NULL), (69,0,NULL), -(3781,9000000,NULL), +(3781,0,NULL), (3801,0,NULL), -(3802,1,NULL), +(3802,0,NULL), (20001,0,'NextArenaPointDistributionTime'), (20002,0,'NextWeeklyQuestResetTime'), (20003,0,'NextBGRandomDailyResetTime'), @@ -2803,4 +2803,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2019-07-15 5:57:44 +-- Dump completed on 2019-08-16 6:25:11 diff --git a/sql/base/dev/world_database.sql b/sql/base/dev/world_database.sql index 32d12d9dcb5..82243763ca4 100644 --- a/sql/base/dev/world_database.sql +++ b/sql/base/dev/world_database.sql @@ -2261,6 +2261,21 @@ CREATE TABLE `player_levelstats` ( ) ENGINE=MyISAM DEFAULT CHARSET=utf8 PACK_KEYS=0 COMMENT='Stores levels stats.'; /*!40101 SET character_set_client = @saved_cs_client */; +-- +-- Table structure for table `player_totem_model` +-- + +DROP TABLE IF EXISTS `player_totem_model`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `player_totem_model` ( + `TotemSlot` tinyint(3) unsigned NOT NULL, + `RaceId` tinyint(3) unsigned NOT NULL, + `DisplayId` int(10) unsigned NOT NULL DEFAULT '0', + PRIMARY KEY (`TotemSlot`,`RaceId`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + -- -- Table structure for table `player_xp_for_level` -- @@ -2415,68 +2430,19 @@ CREATE TABLE `points_of_interest_locale` ( /*!40101 SET character_set_client = @saved_cs_client */; -- --- Table structure for table `pool_creature` +-- Table structure for table `pool_members` -- -DROP TABLE IF EXISTS `pool_creature`; +DROP TABLE IF EXISTS `pool_members`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; -CREATE TABLE `pool_creature` ( - `guid` int(10) unsigned NOT NULL DEFAULT '0', - `pool_entry` mediumint(8) unsigned NOT NULL DEFAULT '0', - `chance` float unsigned NOT NULL DEFAULT '0', - `description` varchar(255) DEFAULT NULL, - PRIMARY KEY (`guid`), - KEY `idx_guid` (`guid`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Table structure for table `pool_gameobject` --- - -DROP TABLE IF EXISTS `pool_gameobject`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `pool_gameobject` ( - `guid` int(10) unsigned NOT NULL DEFAULT '0', - `pool_entry` mediumint(8) unsigned NOT NULL DEFAULT '0', - `chance` float unsigned NOT NULL DEFAULT '0', - `description` varchar(255) DEFAULT NULL, - PRIMARY KEY (`guid`), - KEY `idx_guid` (`guid`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Table structure for table `pool_pool` --- - -DROP TABLE IF EXISTS `pool_pool`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `pool_pool` ( - `pool_id` mediumint(8) unsigned NOT NULL DEFAULT '0', - `mother_pool` mediumint(8) unsigned NOT NULL DEFAULT '0', - `chance` float NOT NULL DEFAULT '0', - `description` varchar(255) DEFAULT NULL, - PRIMARY KEY (`pool_id`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Table structure for table `pool_quest` --- - -DROP TABLE IF EXISTS `pool_quest`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `pool_quest` ( - `entry` int(10) unsigned NOT NULL DEFAULT '0', - `pool_entry` mediumint(8) unsigned NOT NULL DEFAULT '0', +CREATE TABLE `pool_members` ( + `type` smallint(10) unsigned NOT NULL, + `spawnId` int(10) unsigned NOT NULL, + `poolSpawnId` int(10) unsigned NOT NULL, + `chance` double unsigned NOT NULL, `description` varchar(255) DEFAULT NULL, - PRIMARY KEY (`entry`), - KEY `idx_guid` (`entry`) + PRIMARY KEY (`type`,`spawnId`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; @@ -2668,6 +2634,37 @@ CREATE TABLE `quest_poi_points` ( ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; +-- +-- Table structure for table `quest_pool_members` +-- + +DROP TABLE IF EXISTS `quest_pool_members`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `quest_pool_members` ( + `questId` int(10) unsigned NOT NULL, + `poolId` int(10) unsigned NOT NULL, + `poolIndex` tinyint(2) unsigned NOT NULL COMMENT 'Multiple quests with the same index will always spawn together!', + `description` varchar(255) DEFAULT NULL, + PRIMARY KEY (`questId`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `quest_pool_template` +-- + +DROP TABLE IF EXISTS `quest_pool_template`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `quest_pool_template` ( + `poolId` mediumint(8) unsigned NOT NULL, + `numActive` int(10) unsigned NOT NULL COMMENT 'Number of indices to have active at any time', + `description` varchar(255) DEFAULT NULL, + PRIMARY KEY (`poolId`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + -- -- Table structure for table `quest_request_items` -- @@ -2952,6 +2949,7 @@ CREATE TABLE `script_spline_chain_meta` ( `splineId` tinyint(3) unsigned NOT NULL, `expectedDuration` int(10) unsigned NOT NULL, `msUntilNext` int(10) unsigned NOT NULL, + `velocity` float unsigned DEFAULT '0', PRIMARY KEY (`entry`,`chainId`,`splineId`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; @@ -3844,4 +3842,4 @@ CREATE TABLE `waypoints` ( /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2019-07-15 5:57:44 +-- Dump completed on 2019-08-16 6:25:11 -- cgit v1.2.3