From ce25d51b4c56110decdfde0f385fb222cb09c457 Mon Sep 17 00:00:00 2001 From: TDB Release Date: Mon, 25 Jul 2022 18:51:32 +0000 Subject: TDB 925.22071 - 2022/07/25 --- sql/base/auth_database.sql | 55 +++++++++---------- sql/base/characters_database.sql | 27 +++++----- sql/base/dev/hotfixes_database.sql | 38 ++++++------- sql/base/dev/world_database.sql | 107 ++++++++++++++++++++++++++++--------- 4 files changed, 145 insertions(+), 82 deletions(-) (limited to 'sql/base') diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql index 2a8535ff992..7e9449f847c 100644 --- a/sql/base/auth_database.sql +++ b/sql/base/auth_database.sql @@ -1,8 +1,8 @@ --- MySQL dump 10.13 Distrib 8.0.26, for Linux (x86_64) +-- MySQL dump 10.13 Distrib 8.0.29, for Linux (x86_64) -- -- Host: localhost Database: auth -- ------------------------------------------------------ --- Server version 8.0.26 +-- Server version 8.0.29-0ubuntu0.20.04.3 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; @@ -2588,25 +2588,26 @@ INSERT INTO `updates` VALUES ('2022_03_02_00_auth.sql','928C11D145B98E90FB82D2A871C2456C848AB6C1','ARCHIVED','2022-03-02 10:10:19',0), ('2022_03_03_00_auth.sql','408CCCF7D47FB5C876E976F883B4BDBFFEC5D146','ARCHIVED','2022-03-03 01:09:55',0), ('2022_03_06_00_auth.sql','2883FD8D2CB8B2FC3DF7D20D3216301262E7A7C3','ARCHIVED','2022-03-06 15:12:24',0), -('2022_03_08_00_auth.sql','E2C6B4E26FE55F5827C587CD668F6518EB2B51E8','RELEASED','2022-03-08 15:24:10',0), -('2022_03_12_00_auth.sql','1A476DB06BC1F096E6F15225078373B3AD094C1B','RELEASED','2022-03-12 05:52:02',0), -('2022_03_22_00_auth.sql','16A58234A1EF4F13ABD6EF78733BDBF5152AA70C','RELEASED','2022-03-22 00:32:54',0), -('2022_03_25_00_auth.sql','173D4F7B5417AF11DDDE6EC1A58ECFA6783C7FAF','RELEASED','2022-03-25 00:26:53',0), -('2022_03_30_00_auth.sql','37177AB41D7DF26CF4F908C0522EDEAF13094D7E','RELEASED','2022-03-30 00:37:34',0), -('2022_03_30_01_auth.sql','AACD3E4E8673F6D90677C97D5B0B0F292D0C1763','RELEASED','2022-03-30 04:28:42',0), -('2022_04_08_00_auth.sql','C0BE7634D6B84D860111AF5EEDF1D023875F3137','RELEASED','2022-04-08 21:01:16',0), -('2022_04_14_00_auth.sql','4D79D1C7282CA8F1626D957AF17E711BFF94334B','RELEASED','2022-04-14 04:39:49',0), -('2022_04_22_00_auth.sql','835EE2D6981AD7A7467490242D6A4B0E0B69E4F4','RELEASED','2022-04-22 20:04:53',0), -('2022_05_03_00_auth.sql','0874FBE9821F2659BA51B91E9D69B9E6CA6D2EC9','RELEASED','2022-05-03 11:07:21',0), -('2022_06_01_00_auth.sql','DCFC7EC6C52993769B568EAF87CA2DAA10359AEB','RELEASED','2022-06-02 00:52:17',0), -('2022_06_06_00_auth.sql','68D73F068598D37FD6FBC84362F1BA7BA4EC2709','RELEASED','2022-06-06 21:35:16',0), -('2022_06_07_00_auth.sql','76B4D21F13B0024445E5C0B48C630C1DF7E80966','RELEASED','2022-06-07 16:09:58',0), -('2022_06_08_00_auth.sql','250081465C76AC9668E3F66D386CE2AAC05379E9','RELEASED','2022-06-08 10:45:01',0), -('2022_06_09_00_auth.sql','29C2A4209FB977373440666F00B2E04F0E095247','RELEASED','2022-06-09 18:31:38',0), -('2022_06_15_00_auth.sql','137223C2750CC3559EFE11AFF1A780D5DA070193','RELEASED','2022-06-15 11:16:51',0), -('2022_06_18_00_auth.sql','63B75F9D79D83581AB3257C9EF86EDB626D8FDDA','RELEASED','2022-06-18 11:48:42',0), -('2022_06_27_00_auth.sql','CF613CCAAF8B6F08AAE1C48DBC4AF4D224291D8D','RELEASED','2022-06-27 21:13:58',0), -('2022_07_23_00_auth.sql','4BF2E43EBAC4D5B3E3B0063DEA06BB34E437F7A9','RELEASED','2022-07-23 01:27:24',0); +('2022_03_08_00_auth.sql','E2C6B4E26FE55F5827C587CD668F6518EB2B51E8','ARCHIVED','2022-03-08 15:24:10',0), +('2022_03_12_00_auth.sql','1A476DB06BC1F096E6F15225078373B3AD094C1B','ARCHIVED','2022-03-12 05:52:02',0), +('2022_03_22_00_auth.sql','16A58234A1EF4F13ABD6EF78733BDBF5152AA70C','ARCHIVED','2022-03-22 00:32:54',0), +('2022_03_25_00_auth.sql','173D4F7B5417AF11DDDE6EC1A58ECFA6783C7FAF','ARCHIVED','2022-03-25 00:26:53',0), +('2022_03_30_00_auth.sql','37177AB41D7DF26CF4F908C0522EDEAF13094D7E','ARCHIVED','2022-03-30 00:37:34',0), +('2022_03_30_01_auth.sql','AACD3E4E8673F6D90677C97D5B0B0F292D0C1763','ARCHIVED','2022-03-30 04:28:42',0), +('2022_04_08_00_auth.sql','C0BE7634D6B84D860111AF5EEDF1D023875F3137','ARCHIVED','2022-04-08 21:01:16',0), +('2022_04_14_00_auth.sql','4D79D1C7282CA8F1626D957AF17E711BFF94334B','ARCHIVED','2022-04-14 04:39:49',0), +('2022_04_22_00_auth.sql','835EE2D6981AD7A7467490242D6A4B0E0B69E4F4','ARCHIVED','2022-04-22 20:04:53',0), +('2022_05_03_00_auth.sql','0874FBE9821F2659BA51B91E9D69B9E6CA6D2EC9','ARCHIVED','2022-05-03 11:07:21',0), +('2022_06_01_00_auth.sql','DCFC7EC6C52993769B568EAF87CA2DAA10359AEB','ARCHIVED','2022-06-02 00:52:17',0), +('2022_06_06_00_auth.sql','68D73F068598D37FD6FBC84362F1BA7BA4EC2709','ARCHIVED','2022-06-06 21:35:16',0), +('2022_06_07_00_auth.sql','76B4D21F13B0024445E5C0B48C630C1DF7E80966','ARCHIVED','2022-06-07 16:09:58',0), +('2022_06_08_00_auth.sql','250081465C76AC9668E3F66D386CE2AAC05379E9','ARCHIVED','2022-06-08 10:45:01',0), +('2022_06_09_00_auth.sql','29C2A4209FB977373440666F00B2E04F0E095247','ARCHIVED','2022-06-09 18:31:38',0), +('2022_06_15_00_auth.sql','137223C2750CC3559EFE11AFF1A780D5DA070193','ARCHIVED','2022-06-15 11:16:51',0), +('2022_06_18_00_auth.sql','63B75F9D79D83581AB3257C9EF86EDB626D8FDDA','ARCHIVED','2022-06-18 11:48:42',0), +('2022_06_27_00_auth.sql','CF613CCAAF8B6F08AAE1C48DBC4AF4D224291D8D','ARCHIVED','2022-06-27 21:13:58',0), +('2022_07_23_00_auth.sql','FEA7A8DA363F097A090F3BB39401C3FD7AE8E9B5','ARCHIVED','2022-07-25 18:40:38',0), +('2022_07_25_00_auth.sql','8F5BA8F7E010EDCA70F49FDE947B2F89476A2F95','ARCHIVED','2022-07-25 18:44:10',0); /*!40000 ALTER TABLE `updates` ENABLE KEYS */; UNLOCK TABLES; @@ -2685,13 +2686,13 @@ SET @saved_cs_client = @@character_set_client; SET character_set_client = @saved_cs_client; -- --- Temporary table structure for view `vw_rbac` +-- Temporary view structure for view `vw_rbac` -- DROP TABLE IF EXISTS `vw_rbac`; /*!50001 DROP VIEW IF EXISTS `vw_rbac`*/; SET @saved_cs_client = @@character_set_client; -SET character_set_client = utf8; +/*!50503 SET character_set_client = utf8mb4 */; /*!50001 CREATE VIEW `vw_rbac` AS SELECT 1 AS `Permission ID`, 1 AS `Permission Group`, @@ -2729,12 +2730,12 @@ SET character_set_client = @saved_cs_client; /*!50001 SET @saved_cs_client = @@character_set_client */; /*!50001 SET @saved_cs_results = @@character_set_results */; /*!50001 SET @saved_col_connection = @@collation_connection */; -/*!50001 SET character_set_client = utf8 */; -/*!50001 SET character_set_results = utf8 */; +/*!50001 SET character_set_client = utf8mb3 */; +/*!50001 SET character_set_results = utf8mb3 */; /*!50001 SET collation_connection = utf8_general_ci */; /*!50001 CREATE ALGORITHM=UNDEFINED */ /*!50013 */ -/*!50001 VIEW `vw_rbac` AS (select `t1`.`linkedId` AS `Permission ID`,`t1`.`id` AS `Permission Group`,ifnull(`t2`.`secId`,'linked') AS `Security Level`,`t3`.`name` AS `Permission` from ((`rbac_linked_permissions` `t1` left join `rbac_default_permissions` `t2` on((`t1`.`id` = `t2`.`permissionId`))) left join `rbac_permissions` `t3` on((`t1`.`linkedId` = `t3`.`id`)))) */; +/*!50001 VIEW `vw_rbac` AS select `t1`.`linkedId` AS `Permission ID`,`t1`.`id` AS `Permission Group`,ifnull(`t2`.`secId`,'linked') AS `Security Level`,`t3`.`name` AS `Permission` from ((`rbac_linked_permissions` `t1` left join `rbac_default_permissions` `t2` on((`t1`.`id` = `t2`.`permissionId`))) left join `rbac_permissions` `t3` on((`t1`.`linkedId` = `t3`.`id`))) */; /*!50001 SET character_set_client = @saved_cs_client */; /*!50001 SET character_set_results = @saved_cs_results */; /*!50001 SET collation_connection = @saved_col_connection */; @@ -2748,4 +2749,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 2022-03-06 15:12:26 +-- Dump completed on 2022-07-25 18:44:12 diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql index 0358dfb8939..22b65f86168 100644 --- a/sql/base/characters_database.sql +++ b/sql/base/characters_database.sql @@ -1,8 +1,8 @@ --- MySQL dump 10.13 Distrib 8.0.26, for Linux (x86_64) +-- MySQL dump 10.13 Distrib 8.0.29, for Linux (x86_64) -- -- Host: localhost Database: characters -- ------------------------------------------------------ --- Server version 8.0.26 +-- Server version 8.0.29-0ubuntu0.20.04.3 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; @@ -2982,7 +2982,7 @@ CREATE TABLE `item_loot_items` ( `container_id` bigint unsigned NOT NULL DEFAULT '0' COMMENT 'guid of container (item_instance.guid)', `item_id` int unsigned NOT NULL DEFAULT '0' COMMENT 'loot item entry (item_instance.itemEntry)', `item_count` int NOT NULL DEFAULT '0' COMMENT 'stack size', - `item_index` int(10) unsigned NOT NULL DEFAULT '0', + `item_index` int unsigned NOT NULL DEFAULT '0', `follow_rules` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'follow loot rules', `ffa` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'free-for-all', `blocked` tinyint(1) NOT NULL DEFAULT '0', @@ -3670,10 +3670,11 @@ INSERT INTO `updates` VALUES ('2022_01_31_02_characters.sql','6E3A3F02276287DD540BC4C17E246DFB850260D8','ARCHIVED','2022-01-31 21:43:38',0), ('2022_02_28_00_characters_2020_09_27_00_characters.sql','2292A1ED0E7F46DEC41384F75FA6D9461464EEB8','ARCHIVED','2022-02-28 12:43:58',0), ('2022_03_06_00_characters.sql','474AAF9D03E6A56017899C968DC9875368301934','ARCHIVED','2022-03-06 15:12:24',0), -('2022_03_11_00_characters_2021_07_18_00_characters.sql','0BA579ED21F4E75AC2B4797421B5029568B3F6E2','RELEASED','2022-03-11 18:56:07',0), -('2022_06_01_00_characters.sql','582AC6E256F8365F83AB70BA165CCC8B218E19FF','RELEASED','2022-06-01 21:16:56',0), -('2022_07_03_00_characters.sql','D3F04078C0846BCF7C8330AC20C39B8C3AEE7002','RELEASED','2022-07-03 23:37:24',0), -('2022_07_14_00_characters.sql','2EAD57D77FC39F6678F2D2A7D9C24046E6B836D8','RELEASED','2022-07-14 21:44:35',0); +('2022_03_11_00_characters_2021_07_18_00_characters.sql','0BA579ED21F4E75AC2B4797421B5029568B3F6E2','ARCHIVED','2022-03-11 18:56:07',0), +('2022_06_01_00_characters.sql','582AC6E256F8365F83AB70BA165CCC8B218E19FF','ARCHIVED','2022-06-01 21:16:56',0), +('2022_07_03_00_characters.sql','D3F04078C0846BCF7C8330AC20C39B8C3AEE7002','ARCHIVED','2022-07-03 23:37:24',0), +('2022_07_14_00_characters.sql','2EAD57D77FC39F6678F2D2A7D9C24046E6B836D8','ARCHIVED','2022-07-14 21:44:35',0), +('2022_07_25_00_characters.sql','3159BB2F3C346A7881920AB2B1F8108247CF13EE','ARCHIVED','2022-07-25 18:44:10',0); /*!40000 ALTER TABLE `updates` ENABLE KEYS */; UNLOCK TABLES; @@ -3774,15 +3775,15 @@ CREATE TABLE `world_variable` ( LOCK TABLES `world_variable` WRITE; /*!40000 ALTER TABLE `world_variable` DISABLE KEYS */; INSERT INTO `world_variable` VALUES -('NextCurrencyResetTime',0), -('NextWeeklyQuestResetTime',0), ('NextBGRandomDailyResetTime',0), -('PersistentCharacterCleanFlags',0), +('NextCurrencyResetTime',0), +('NextDailyQuestResetTime',0), ('NextGuildDailyResetTime',0), +('NextGuildWeeklyResetTime',0), ('NextMonthlyQuestResetTime',0), -('NextDailyQuestResetTime',0), ('NextOldCalendarEventDeletionTime',0), -('NextGuildWeeklyResetTime',0); +('NextWeeklyQuestResetTime',0), +('PersistentCharacterCleanFlags',0); /*!40000 ALTER TABLE `world_variable` ENABLE KEYS */; UNLOCK TABLES; @@ -3799,4 +3800,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2022-03-06 15:12:27 +-- Dump completed on 2022-07-25 18:44:12 diff --git a/sql/base/dev/hotfixes_database.sql b/sql/base/dev/hotfixes_database.sql index fd093213132..4de0f6a48ce 100644 --- a/sql/base/dev/hotfixes_database.sql +++ b/sql/base/dev/hotfixes_database.sql @@ -1,8 +1,8 @@ --- MySQL dump 10.13 Distrib 8.0.26, for Linux (x86_64) +-- MySQL dump 10.13 Distrib 8.0.29, for Linux (x86_64) -- -- Host: localhost Database: hotfixes -- ------------------------------------------------------ --- Server version 8.0.26 +-- Server version 8.0.29-0ubuntu0.20.04.3 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; @@ -134,7 +134,7 @@ CREATE TABLE `adventure_journal` ( `ContinueDescription` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `Type` tinyint unsigned NOT NULL DEFAULT '0', `PlayerConditionID` int unsigned NOT NULL DEFAULT '0', - `Flags` tinyint unsigned NOT NULL DEFAULT '0', + `Flags` int NOT NULL DEFAULT '0', `ButtonActionType` tinyint unsigned NOT NULL DEFAULT '0', `TextureFileDataID` int NOT NULL DEFAULT '0', `LfgDungeonID` smallint unsigned NOT NULL DEFAULT '0', @@ -1549,7 +1549,7 @@ CREATE TABLE `chr_classes` ( `SelectScreenFileDataID` int unsigned NOT NULL DEFAULT '0', `IconFileDataID` int unsigned NOT NULL DEFAULT '0', `LowResScreenFileDataID` int unsigned NOT NULL DEFAULT '0', - `Flags` int unsigned NOT NULL DEFAULT '0', + `Flags` int NOT NULL DEFAULT '0', `SpellTextureBlobFileDataID` int unsigned NOT NULL DEFAULT '0', `RolesMask` int unsigned NOT NULL DEFAULT '0', `ArmorTypeMask` int unsigned NOT NULL DEFAULT '0', @@ -1822,7 +1822,7 @@ CREATE TABLE `chr_model` ( `CustomizeOffset2` float NOT NULL DEFAULT '0', `CustomizeOffset3` float NOT NULL DEFAULT '0', `ID` int unsigned NOT NULL DEFAULT '0', - `Sex` int NOT NULL DEFAULT '0', + `Sex` tinyint NOT NULL DEFAULT '0', `DisplayID` int NOT NULL DEFAULT '0', `CharComponentTextureLayoutID` int NOT NULL DEFAULT '0', `Flags` int NOT NULL DEFAULT '0', @@ -2627,8 +2627,8 @@ CREATE TABLE `curve_point` ( `ID` int unsigned NOT NULL DEFAULT '0', `PosX` float NOT NULL DEFAULT '0', `PosY` float NOT NULL DEFAULT '0', - `PosPreSquishX` float NOT NULL DEFAULT '0', - `PosPreSquishY` float NOT NULL DEFAULT '0', + `PreSLSquishPosX` float NOT NULL DEFAULT '0', + `PreSLSquishPosY` float NOT NULL DEFAULT '0', `CurveID` smallint unsigned NOT NULL DEFAULT '0', `OrderIndex` tinyint unsigned NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', @@ -4284,8 +4284,8 @@ CREATE TABLE `item_bonus_tree_node` ( `ChildItemBonusTreeID` smallint unsigned NOT NULL DEFAULT '0', `ChildItemBonusListID` smallint unsigned NOT NULL DEFAULT '0', `ChildItemLevelSelectorID` smallint unsigned NOT NULL DEFAULT '0', - `ItemBonusListGroupID` int NOT NULL DEFAULT '0', - `ParentItemBonusTreeNodeID` int NOT NULL DEFAULT '0', + `ChildItemBonusListGroupID` int NOT NULL DEFAULT '0', + `IblGroupPointsModSetID` int NOT NULL DEFAULT '0', `ParentItemBonusTreeID` int unsigned NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`VerifiedBuild`) @@ -4929,6 +4929,8 @@ CREATE TABLE `item_sparse` ( `DurationInInventory` int unsigned NOT NULL DEFAULT '0', `QualityModifier` float NOT NULL DEFAULT '0', `BagFamily` int unsigned NOT NULL DEFAULT '0', + `StartQuestID` int NOT NULL DEFAULT '0', + `LanguageID` int NOT NULL DEFAULT '0', `ItemRange` float NOT NULL DEFAULT '0', `StatPercentageOfSocket1` float NOT NULL DEFAULT '0', `StatPercentageOfSocket2` float NOT NULL DEFAULT '0', @@ -4977,7 +4979,6 @@ CREATE TABLE `item_sparse` ( `ZoneBound2` smallint unsigned NOT NULL DEFAULT '0', `ItemSet` smallint unsigned NOT NULL DEFAULT '0', `LockID` smallint unsigned NOT NULL DEFAULT '0', - `StartQuestID` int NOT NULL DEFAULT '0', `PageID` smallint unsigned NOT NULL DEFAULT '0', `ItemDelay` smallint unsigned NOT NULL DEFAULT '0', `MinFactionID` smallint unsigned NOT NULL DEFAULT '0', @@ -4994,7 +4995,6 @@ CREATE TABLE `item_sparse` ( `SheatheType` tinyint unsigned NOT NULL DEFAULT '0', `Material` tinyint unsigned NOT NULL DEFAULT '0', `PageMaterialID` tinyint unsigned NOT NULL DEFAULT '0', - `LanguageID` int NOT NULL DEFAULT '0', `Bonding` tinyint unsigned NOT NULL DEFAULT '0', `DamageDamageType` tinyint unsigned NOT NULL DEFAULT '0', `StatModifierBonusStat1` tinyint NOT NULL DEFAULT '0', @@ -5137,7 +5137,7 @@ CREATE TABLE `journal_encounter` ( `FirstSectionID` smallint unsigned NOT NULL DEFAULT '0', `UiMapID` smallint unsigned NOT NULL DEFAULT '0', `MapDisplayConditionID` int unsigned NOT NULL DEFAULT '0', - `Flags` tinyint unsigned NOT NULL DEFAULT '0', + `Flags` int NOT NULL DEFAULT '0', `DifficultyMask` tinyint NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`VerifiedBuild`) @@ -5193,8 +5193,8 @@ CREATE TABLE `journal_encounter_section` ( `UiModelSceneID` int NOT NULL DEFAULT '0', `SpellID` int NOT NULL DEFAULT '0', `IconFileDataID` int NOT NULL DEFAULT '0', - `Flags` smallint unsigned NOT NULL DEFAULT '0', - `IconFlags` smallint unsigned NOT NULL DEFAULT '0', + `Flags` int NOT NULL DEFAULT '0', + `IconFlags` int NOT NULL DEFAULT '0', `DifficultyMask` tinyint NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`VerifiedBuild`) @@ -5246,7 +5246,7 @@ CREATE TABLE `journal_instance` ( `ButtonSmallFileDataID` int NOT NULL DEFAULT '0', `LoreFileDataID` int NOT NULL DEFAULT '0', `OrderIndex` tinyint unsigned NOT NULL DEFAULT '0', - `Flags` tinyint unsigned NOT NULL DEFAULT '0', + `Flags` int NOT NULL DEFAULT '0', `AreaID` smallint unsigned NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`VerifiedBuild`) @@ -5488,7 +5488,7 @@ CREATE TABLE `lfg_dungeons` ( `Name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `Description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `TypeID` tinyint unsigned NOT NULL DEFAULT '0', - `Subtype` tinyint unsigned NOT NULL DEFAULT '0', + `Subtype` tinyint NOT NULL DEFAULT '0', `Faction` tinyint NOT NULL DEFAULT '0', `IconTextureFileID` int NOT NULL DEFAULT '0', `RewardsBgTextureFileID` int NOT NULL DEFAULT '0', @@ -5768,6 +5768,7 @@ CREATE TABLE `map` ( `WdtFileDataID` int NOT NULL DEFAULT '0', `Flags1` int NOT NULL DEFAULT '0', `Flags2` int NOT NULL DEFAULT '0', + `Flags3` int NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`VerifiedBuild`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -8487,7 +8488,8 @@ CREATE TABLE `summon_properties` ( `Faction` int NOT NULL DEFAULT '0', `Title` int NOT NULL DEFAULT '0', `Slot` int NOT NULL DEFAULT '0', - `Flags` int NOT NULL DEFAULT '0', + `Flags1` int NOT NULL DEFAULT '0', + `Flags2` int NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`VerifiedBuild`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -9527,4 +9529,4 @@ CREATE TABLE `world_state_expression` ( /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2022-03-06 15:12:33 +-- Dump completed on 2022-07-25 18:44:18 diff --git a/sql/base/dev/world_database.sql b/sql/base/dev/world_database.sql index 1bd518da591..b1ad795474f 100644 --- a/sql/base/dev/world_database.sql +++ b/sql/base/dev/world_database.sql @@ -1,8 +1,8 @@ --- MySQL dump 10.13 Distrib 8.0.26, for Linux (x86_64) +-- MySQL dump 10.13 Distrib 8.0.29, for Linux (x86_64) -- -- Host: localhost Database: world -- ------------------------------------------------------ --- Server version 8.0.26 +-- Server version 8.0.29-0ubuntu0.20.04.3 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; @@ -133,6 +133,8 @@ CREATE TABLE `areatrigger` ( `ShapeData3` float NOT NULL DEFAULT '0', `ShapeData4` float NOT NULL DEFAULT '0', `ShapeData5` float NOT NULL DEFAULT '0', + `ShapeData6` float NOT NULL DEFAULT '0', + `ShapeData7` float NOT NULL DEFAULT '0', `ScriptName` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `Comment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`SpawnId`) @@ -529,6 +531,8 @@ CREATE TABLE `conversation_actors` ( `Idx` smallint unsigned NOT NULL DEFAULT '0', `CreatureId` int unsigned NOT NULL DEFAULT '0', `CreatureDisplayInfoId` int unsigned NOT NULL DEFAULT '0', + `NoActorObject` tinyint unsigned DEFAULT '0', + `ActivePlayerObject` tinyint unsigned DEFAULT '0', `VerifiedBuild` int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`ConversationId`,`Idx`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -622,6 +626,7 @@ CREATE TABLE `creature_addon` ( `guid` bigint unsigned NOT NULL DEFAULT '0', `path_id` int unsigned NOT NULL DEFAULT '0', `mount` int unsigned NOT NULL DEFAULT '0', + `MountCreatureID` int unsigned NOT NULL DEFAULT '0', `bytes1` int unsigned NOT NULL DEFAULT '0', `bytes2` int unsigned NOT NULL DEFAULT '1', `emote` int unsigned NOT NULL DEFAULT '0', @@ -734,6 +739,21 @@ CREATE TABLE `creature_model_info` ( ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Creature System (Model related info)'; /*!40101 SET character_set_client = @saved_cs_client */; +-- +-- Table structure for table `creature_movement_info` +-- + +DROP TABLE IF EXISTS `creature_movement_info`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!50503 SET character_set_client = utf8mb4 */; +CREATE TABLE `creature_movement_info` ( + `MovementID` int unsigned NOT NULL DEFAULT '0' COMMENT 'creature_template.movementId value', + `WalkSpeed` float DEFAULT NULL, + `RunSpeed` float DEFAULT NULL, + PRIMARY KEY (`MovementID`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; +/*!40101 SET character_set_client = @saved_cs_client */; + -- -- Table structure for table `creature_movement_override` -- @@ -786,6 +806,7 @@ DROP TABLE IF EXISTS `creature_questender`; CREATE TABLE `creature_questender` ( `id` int unsigned NOT NULL DEFAULT '0' COMMENT 'Identifier', `quest` int unsigned NOT NULL DEFAULT '0' COMMENT 'Quest Identifier', + `VerifiedBuild` int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`,`quest`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Creature System'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -816,6 +837,7 @@ DROP TABLE IF EXISTS `creature_queststarter`; CREATE TABLE `creature_queststarter` ( `id` int unsigned NOT NULL DEFAULT '0' COMMENT 'Identifier', `quest` int unsigned NOT NULL DEFAULT '0' COMMENT 'Quest Identifier', + `VerifiedBuild` int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`,`quest`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Creature System'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -842,6 +864,22 @@ CREATE TABLE `creature_summon_groups` ( ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; +-- +-- Table structure for table `creature_summoned_data` +-- + +DROP TABLE IF EXISTS `creature_summoned_data`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!50503 SET character_set_client = utf8mb4 */; +CREATE TABLE `creature_summoned_data` ( + `CreatureID` int unsigned NOT NULL, + `CreatureIDVisibleToSummoner` int DEFAULT NULL, + `GroundMountDisplayID` int unsigned DEFAULT NULL, + `FlyingMountDisplayID` int unsigned DEFAULT NULL, + PRIMARY KEY (`CreatureID`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; +/*!40101 SET character_set_client = @saved_cs_client */; + -- -- Table structure for table `creature_template` -- @@ -930,6 +968,7 @@ CREATE TABLE `creature_template_addon` ( `entry` int unsigned NOT NULL DEFAULT '0', `path_id` int unsigned NOT NULL DEFAULT '0', `mount` int unsigned NOT NULL DEFAULT '0', + `MountCreatureID` int unsigned NOT NULL DEFAULT '0', `bytes1` int unsigned NOT NULL DEFAULT '0', `bytes2` int unsigned NOT NULL DEFAULT '1', `emote` int unsigned NOT NULL DEFAULT '0', @@ -1183,7 +1222,7 @@ CREATE TABLE `event_scripts` ( `y` float NOT NULL DEFAULT '0', `z` float NOT NULL DEFAULT '0', `o` float NOT NULL DEFAULT '0', - `Comment` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' + `Comment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -1471,7 +1510,7 @@ DROP TABLE IF EXISTS `game_tele`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `game_tele` ( - `id` int unsigned NOT NULL, + `id` int unsigned NOT NULL AUTO_INCREMENT, `position_x` float NOT NULL DEFAULT '0', `position_y` float NOT NULL DEFAULT '0', `position_z` float NOT NULL DEFAULT '0', @@ -1479,7 +1518,7 @@ CREATE TABLE `game_tele` ( `map` smallint unsigned NOT NULL DEFAULT '0', `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', PRIMARY KEY (`id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Tele Command'; +) ENGINE=InnoDB AUTO_INCREMENT=1824 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Tele Command'; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -1611,6 +1650,7 @@ DROP TABLE IF EXISTS `gameobject_questender`; CREATE TABLE `gameobject_questender` ( `id` int unsigned NOT NULL DEFAULT '0', `quest` int unsigned NOT NULL DEFAULT '0' COMMENT 'Quest Identifier', + `VerifiedBuild` int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`,`quest`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -1641,6 +1681,7 @@ DROP TABLE IF EXISTS `gameobject_queststarter`; CREATE TABLE `gameobject_queststarter` ( `id` int unsigned NOT NULL DEFAULT '0', `quest` int unsigned NOT NULL DEFAULT '0' COMMENT 'Quest Identifier', + `VerifiedBuild` int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`,`quest`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -1821,7 +1862,7 @@ CREATE TABLE `gossip_menu_option` ( `ActionPoiID` int unsigned NOT NULL DEFAULT '0', `BoxCoded` tinyint unsigned NOT NULL DEFAULT '0', `BoxMoney` int unsigned NOT NULL DEFAULT '0', - `BoxText` mediumtext COLLATE utf8mb4_unicode_ci, + `BoxText` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `BoxBroadcastTextID` int unsigned NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`MenuID`,`OptionID`) @@ -2497,7 +2538,7 @@ CREATE TABLE `playerchoice` ( `SoundKitId` int unsigned NOT NULL DEFAULT '0', `CloseSoundKitId` int unsigned NOT NULL DEFAULT '0', `Duration` bigint NOT NULL DEFAULT '0', - `PendingChoiceText` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `PendingChoiceText` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `Question` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `HideWarboardHeader` tinyint(1) NOT NULL DEFAULT '0', `KeepOpenAfterChoice` tinyint unsigned NOT NULL DEFAULT '0', @@ -2835,7 +2876,7 @@ DROP TABLE IF EXISTS `pool_members`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `pool_members` ( `type` smallint unsigned NOT NULL, - `spawnId` int unsigned NOT NULL, + `spawnId` bigint unsigned NOT NULL, `poolSpawnId` int unsigned NOT NULL, `chance` float NOT NULL, `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, @@ -3002,10 +3043,10 @@ DROP TABLE IF EXISTS `quest_offer_reward`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `quest_offer_reward` ( `ID` int unsigned NOT NULL DEFAULT '0', - `Emote1` smallint unsigned NOT NULL DEFAULT '0', - `Emote2` smallint unsigned NOT NULL DEFAULT '0', - `Emote3` smallint unsigned NOT NULL DEFAULT '0', - `Emote4` smallint unsigned NOT NULL DEFAULT '0', + `Emote1` smallint NOT NULL DEFAULT '0', + `Emote2` smallint NOT NULL DEFAULT '0', + `Emote3` smallint NOT NULL DEFAULT '0', + `Emote4` smallint NOT NULL DEFAULT '0', `EmoteDelay1` int unsigned NOT NULL DEFAULT '0', `EmoteDelay2` int unsigned NOT NULL DEFAULT '0', `EmoteDelay3` int unsigned NOT NULL DEFAULT '0', @@ -4153,7 +4194,7 @@ CREATE TABLE `spell_scripts` ( `y` float NOT NULL DEFAULT '0', `z` float NOT NULL DEFAULT '0', `o` float NOT NULL DEFAULT '0', - `Comment` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' + `Comment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -4545,7 +4586,7 @@ DROP TABLE IF EXISTS `warden_checks`; CREATE TABLE `warden_checks` ( `id` smallint unsigned NOT NULL AUTO_INCREMENT, `type` tinyint unsigned DEFAULT NULL, - `str` varchar(170) COLLATE utf8mb4_unicode_ci DEFAULT NULL, + `str` varchar(170) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `address` int unsigned DEFAULT NULL, `length` tinyint unsigned DEFAULT NULL, `comment` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, @@ -4568,7 +4609,7 @@ CREATE TABLE `waypoint_data` ( `position_x` float NOT NULL DEFAULT '0', `position_y` float NOT NULL DEFAULT '0', `position_z` float NOT NULL DEFAULT '0', - `orientation` float NOT NULL DEFAULT '0', + `orientation` float DEFAULT NULL, `delay` int unsigned NOT NULL DEFAULT '0', `move_type` int NOT NULL DEFAULT '0', `action` int NOT NULL DEFAULT '0', @@ -4597,7 +4638,7 @@ CREATE TABLE `waypoint_scripts` ( `z` float NOT NULL DEFAULT '0', `o` float NOT NULL DEFAULT '0', `guid` int NOT NULL DEFAULT '0', - `Comment` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `Comment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', PRIMARY KEY (`guid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -4615,7 +4656,7 @@ CREATE TABLE `waypoints` ( `position_x` float NOT NULL DEFAULT '0', `position_y` float NOT NULL DEFAULT '0', `position_z` float NOT NULL DEFAULT '0', - `orientation` float NOT NULL DEFAULT '0', + `orientation` float DEFAULT NULL, `delay` int unsigned NOT NULL DEFAULT '0', `point_comment` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`entry`,`pointid`) @@ -4641,6 +4682,24 @@ CREATE TABLE `world_safe_locs` ( ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; +-- +-- Table structure for table `world_state` +-- + +DROP TABLE IF EXISTS `world_state`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!50503 SET character_set_client = utf8mb4 */; +CREATE TABLE `world_state` ( + `ID` int NOT NULL, + `DefaultValue` int NOT NULL, + `MapIDs` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, + `AreaIDs` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, + `ScriptName` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `Comment` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + PRIMARY KEY (`ID`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; +/*!40101 SET character_set_client = @saved_cs_client */; + -- -- Dumping routines for database 'world' -- @@ -4653,8 +4712,8 @@ CREATE TABLE `world_safe_locs` ( /*!50001 SET @saved_cs_client = @@character_set_client */; /*!50001 SET @saved_cs_results = @@character_set_results */; /*!50001 SET @saved_col_connection = @@collation_connection */; -/*!50001 SET character_set_client = utf8 */; -/*!50001 SET character_set_results = utf8 */; +/*!50001 SET character_set_client = utf8mb3 */; +/*!50001 SET character_set_results = utf8mb3 */; /*!50001 SET collation_connection = utf8_general_ci */; /*!50001 CREATE ALGORITHM=UNDEFINED */ /*!50013 */ @@ -4671,8 +4730,8 @@ CREATE TABLE `world_safe_locs` ( /*!50001 SET @saved_cs_client = @@character_set_client */; /*!50001 SET @saved_cs_results = @@character_set_results */; /*!50001 SET @saved_col_connection = @@collation_connection */; -/*!50001 SET character_set_client = utf8 */; -/*!50001 SET character_set_results = utf8 */; +/*!50001 SET character_set_client = utf8mb3 */; +/*!50001 SET character_set_results = utf8mb3 */; /*!50001 SET collation_connection = utf8_general_ci */; /*!50001 CREATE ALGORITHM=UNDEFINED */ /*!50013 */ @@ -4689,8 +4748,8 @@ CREATE TABLE `world_safe_locs` ( /*!50001 SET @saved_cs_client = @@character_set_client */; /*!50001 SET @saved_cs_results = @@character_set_results */; /*!50001 SET @saved_col_connection = @@collation_connection */; -/*!50001 SET character_set_client = utf8 */; -/*!50001 SET character_set_results = utf8 */; +/*!50001 SET character_set_client = utf8mb3 */; +/*!50001 SET character_set_results = utf8mb3 */; /*!50001 SET collation_connection = utf8_general_ci */; /*!50001 CREATE ALGORITHM=UNDEFINED */ /*!50013 */ @@ -4708,4 +4767,4 @@ CREATE TABLE `world_safe_locs` ( /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2022-03-06 15:12:29 +-- Dump completed on 2022-07-25 18:44:14 -- cgit v1.2.3