diff options
Diffstat (limited to 'sql/base')
| -rw-r--r-- | sql/base/auth_database.sql | 15 | ||||
| -rw-r--r-- | sql/base/characters_database.sql | 11 | ||||
| -rw-r--r-- | sql/base/dev/hotfixes_database.sql | 30 | ||||
| -rw-r--r-- | sql/base/dev/world_database.sql | 297 |
4 files changed, 261 insertions, 92 deletions
diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql index 31ce83c922d..55b324d49c8 100644 --- a/sql/base/auth_database.sql +++ b/sql/base/auth_database.sql @@ -2535,12 +2535,13 @@ INSERT INTO `updates` VALUES ('2022_01_02_00_auth.sql','F0AF198C5F7529508A5DB1F29D153256368AD1B4','ARCHIVED','2022-01-02 21:22:35',0), ('2022_01_08_00_auth.sql','3C9853058A77817DD62943D0332418D84CA6BDA1','ARCHIVED','2022-01-15 23:21:37',0), ('2022_01_15_00_auth.sql','11552D29BEDF73626FB8D932AB4362882964B4F0','ARCHIVED','2022-01-15 23:24:57',0), -('2022_01_22_00_auth.sql','24A9BB761E805608EFDD8F647BF733602B337018','RELEASED','2022-01-22 01:39:01',0), -('2022_02_25_00_auth.sql','1556FEDB9B46643634AE5BD0E38E7FF447FFC081','RELEASED','2022-02-25 12:39:15',0), -('2022_02_26_00_auth.sql','955F8E13B0D91CA06FEEAD4E6C75E5495DA6DDF3','RELEASED','2022-02-26 01:01:22',0), -('2022_03_01_00_auth.sql','53636BBB7DF4FFC2496456C1EEF2BD271D1C87E0','RELEASED','2022-03-01 16:07:38',0), -('2022_03_02_00_auth.sql','928C11D145B98E90FB82D2A871C2456C848AB6C1','RELEASED','2022-03-02 10:10:19',0), -('2022_03_03_00_auth.sql','408CCCF7D47FB5C876E976F883B4BDBFFEC5D146','RELEASED','2022-03-03 01:09:55',0); +('2022_01_22_00_auth.sql','24A9BB761E805608EFDD8F647BF733602B337018','ARCHIVED','2022-01-22 01:39:01',0), +('2022_02_25_00_auth.sql','1556FEDB9B46643634AE5BD0E38E7FF447FFC081','ARCHIVED','2022-02-25 12:39:15',0), +('2022_02_26_00_auth.sql','955F8E13B0D91CA06FEEAD4E6C75E5495DA6DDF3','ARCHIVED','2022-02-26 01:01:22',0), +('2022_03_01_00_auth.sql','53636BBB7DF4FFC2496456C1EEF2BD271D1C87E0','ARCHIVED','2022-03-01 16:07:38',0), +('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); /*!40000 ALTER TABLE `updates` ENABLE KEYS */; UNLOCK TABLES; @@ -2649,4 +2650,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-01-15 23:25:00 +-- Dump completed on 2022-03-06 15:12:26 diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql index 191899bb165..8600cf4905b 100644 --- a/sql/base/characters_database.sql +++ b/sql/base/characters_database.sql @@ -3661,10 +3661,11 @@ INSERT INTO `updates` VALUES ('2022_01_02_00_characters.sql','5169A5BBACB42E6CEDE405D3C4843FD386CDF92E','ARCHIVED','2022-01-02 21:22:35',0), ('2022_01_09_00_characters.sql','3AC51F589821C17027CBA861EF762A709430CDB3','ARCHIVED','2022-01-09 21:29:45',0), ('2022_01_15_00_characters.sql','884EFB6592DC8A765E0C0BF8BF907B4E4733BB0C','ARCHIVED','2022-01-15 23:24:58',0), -('2022_01_31_00_characters.sql','19551474AA6079F0616B565F254914C5DD9ED1A1','RELEASED','2022-01-31 14:32:49',0), -('2022_01_31_01_characters.sql','E0A1FA670F4621AEB594D7ACBA4921CB298F54FF','RELEASED','2022-01-31 20:47:59',0), -('2022_01_31_02_characters.sql','6E3A3F02276287DD540BC4C17E246DFB850260D8','RELEASED','2022-01-31 21:43:38',0), -('2022_02_28_00_characters_2020_09_27_00_characters.sql','2292A1ED0E7F46DEC41384F75FA6D9461464EEB8','RELEASED','2022-02-28 12:43:58',0); +('2022_01_31_00_characters.sql','19551474AA6079F0616B565F254914C5DD9ED1A1','ARCHIVED','2022-01-31 14:32:49',0), +('2022_01_31_01_characters.sql','E0A1FA670F4621AEB594D7ACBA4921CB298F54FF','ARCHIVED','2022-01-31 20:47:59',0), +('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); /*!40000 ALTER TABLE `updates` ENABLE KEYS */; UNLOCK TABLES; @@ -3766,4 +3767,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2022-01-15 23:25:01 +-- Dump completed on 2022-03-06 15:12:27 diff --git a/sql/base/dev/hotfixes_database.sql b/sql/base/dev/hotfixes_database.sql index 6019c1f03f3..fd093213132 100644 --- a/sql/base/dev/hotfixes_database.sql +++ b/sql/base/dev/hotfixes_database.sql @@ -1304,6 +1304,7 @@ CREATE TABLE `broadcast_text` ( `EmotesID` smallint unsigned NOT NULL DEFAULT '0', `Flags` tinyint unsigned NOT NULL DEFAULT '0', `ChatBubbleDurationMs` int unsigned NOT NULL DEFAULT '0', + `VoiceOverPriorityID` int NOT NULL DEFAULT '0', `SoundKitID1` int unsigned NOT NULL DEFAULT '0', `SoundKitID2` int unsigned NOT NULL DEFAULT '0', `EmoteID1` smallint unsigned NOT NULL DEFAULT '0', @@ -3136,6 +3137,24 @@ CREATE TABLE `friendship_reputation_locale` ( /*!40101 SET character_set_client = @saved_cs_client */; -- +-- Table structure for table `gameobject_art_kit` +-- + +DROP TABLE IF EXISTS `gameobject_art_kit`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!50503 SET character_set_client = utf8mb4 */; +CREATE TABLE `gameobject_art_kit` ( + `ID` int unsigned NOT NULL DEFAULT '0', + `AttachModelFileID` int NOT NULL DEFAULT '0', + `TextureVariationFileID1` int NOT NULL DEFAULT '0', + `TextureVariationFileID2` int NOT NULL DEFAULT '0', + `TextureVariationFileID3` int NOT NULL DEFAULT '0', + `VerifiedBuild` int NOT NULL DEFAULT '0', + PRIMARY KEY (`ID`,`VerifiedBuild`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- -- Table structure for table `gameobject_display_info` -- @@ -4958,7 +4977,7 @@ 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` 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', @@ -4975,7 +4994,7 @@ 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` 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', @@ -5422,6 +5441,9 @@ DROP TABLE IF EXISTS `languages`; CREATE TABLE `languages` ( `ID` int unsigned NOT NULL DEFAULT '0', `Name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + `Flags` int NOT NULL DEFAULT '0', + `UiTextureKitID` int NOT NULL DEFAULT '0', + `UiTextureKitElementCount` int NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`VerifiedBuild`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -8572,7 +8594,7 @@ CREATE TABLE `taxi_nodes` ( `ContinentID` smallint unsigned NOT NULL DEFAULT '0', `ConditionID` int NOT NULL DEFAULT '0', `CharacterBitNumber` smallint unsigned NOT NULL DEFAULT '0', - `Flags` tinyint unsigned NOT NULL DEFAULT '0', + `Flags` smallint unsigned NOT NULL DEFAULT '0', `UiTextureKitID` int NOT NULL DEFAULT '0', `MinimapAtlasMemberID` int NOT NULL DEFAULT '0', `Facing` float NOT NULL DEFAULT '0', @@ -9505,4 +9527,4 @@ CREATE TABLE `world_state_expression` ( /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2022-01-15 23:25:07 +-- Dump completed on 2022-03-06 15:12:33 diff --git a/sql/base/dev/world_database.sql b/sql/base/dev/world_database.sql index 4b23b02c582..1bd518da591 100644 --- a/sql/base/dev/world_database.sql +++ b/sql/base/dev/world_database.sql @@ -94,6 +94,20 @@ CREATE TABLE `achievement_reward_locale` ( /*!40101 SET character_set_client = @saved_cs_client */; -- +-- Table structure for table `achievement_scripts` +-- + +DROP TABLE IF EXISTS `achievement_scripts`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!50503 SET character_set_client = utf8mb4 */; +CREATE TABLE `achievement_scripts` ( + `AchievementId` int NOT NULL, + `ScriptName` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, + PRIMARY KEY (`AchievementId`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- -- Table structure for table `areatrigger` -- @@ -151,6 +165,8 @@ CREATE TABLE `areatrigger_create_properties` ( `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 '', `VerifiedBuild` int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`Id`) @@ -291,6 +307,8 @@ CREATE TABLE `areatrigger_template` ( `Data3` float NOT NULL DEFAULT '0', `Data4` float NOT NULL DEFAULT '0', `Data5` float NOT NULL DEFAULT '0', + `Data6` float NOT NULL DEFAULT '0', + `Data7` float NOT NULL DEFAULT '0', `VerifiedBuild` int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`Id`,`IsServerSide`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -350,8 +368,8 @@ DROP TABLE IF EXISTS `battlefield_template`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `battlefield_template` ( `TypeId` tinyint unsigned NOT NULL, - `ScriptName` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL, - `comment` text COLLATE utf8mb4_unicode_ci, + `ScriptName` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, + `comment` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`TypeId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -465,7 +483,6 @@ DROP TABLE IF EXISTS `command`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `command` ( `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', - `permission` smallint unsigned NOT NULL DEFAULT '0', `help` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (`name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Chat System'; @@ -726,12 +743,13 @@ DROP TABLE IF EXISTS `creature_movement_override`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `creature_movement_override` ( `SpawnId` bigint unsigned NOT NULL DEFAULT '0', - `Ground` tinyint unsigned NOT NULL DEFAULT '1', - `Swim` tinyint unsigned NOT NULL DEFAULT '1', - `Flight` tinyint unsigned NOT NULL DEFAULT '0', - `Rooted` tinyint unsigned NOT NULL DEFAULT '0', - `Chase` tinyint unsigned NOT NULL DEFAULT '0', - `Random` tinyint unsigned NOT NULL DEFAULT '0', + `Ground` tinyint unsigned DEFAULT NULL, + `Swim` tinyint unsigned DEFAULT NULL, + `Flight` tinyint unsigned DEFAULT NULL, + `Rooted` tinyint unsigned DEFAULT NULL, + `Chase` tinyint unsigned DEFAULT NULL, + `Random` tinyint unsigned DEFAULT NULL, + `InteractionPauseTimer` int unsigned DEFAULT NULL COMMENT 'Time (in milliseconds) during which creature will not move after interaction with player', PRIMARY KEY (`SpawnId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -820,7 +838,7 @@ CREATE TABLE `creature_summon_groups` ( `orientation` float NOT NULL DEFAULT '0', `summonType` tinyint unsigned NOT NULL DEFAULT '0', `summonTime` int unsigned 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 */; @@ -970,12 +988,13 @@ DROP TABLE IF EXISTS `creature_template_movement`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `creature_template_movement` ( `CreatureId` int unsigned NOT NULL DEFAULT '0', - `Ground` tinyint unsigned NOT NULL DEFAULT '1', - `Swim` tinyint unsigned NOT NULL DEFAULT '1', - `Flight` tinyint unsigned NOT NULL DEFAULT '0', - `Rooted` tinyint unsigned NOT NULL DEFAULT '0', - `Chase` tinyint unsigned NOT NULL DEFAULT '0', - `Random` tinyint unsigned NOT NULL DEFAULT '0', + `Ground` tinyint unsigned DEFAULT NULL, + `Swim` tinyint unsigned DEFAULT NULL, + `Flight` tinyint unsigned DEFAULT NULL, + `Rooted` tinyint unsigned DEFAULT NULL, + `Chase` tinyint unsigned DEFAULT NULL, + `Random` tinyint unsigned DEFAULT NULL, + `InteractionPauseTimer` int unsigned DEFAULT NULL COMMENT 'Time (in milliseconds) during which creature will not move after interaction with player', PRIMARY KEY (`CreatureId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -1069,7 +1088,7 @@ CREATE TABLE `creature_text_locale` ( `ID` tinyint unsigned NOT NULL DEFAULT '0', `Locale` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `Text` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, - PRIMARY KEY (`CreatureID`,`GroupID`,`ID`) + PRIMARY KEY (`CreatureID`,`GroupID`,`ID`,`Locale`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -1081,11 +1100,11 @@ DROP TABLE IF EXISTS `creature_trainer`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `creature_trainer` ( - `CreatureId` int unsigned NOT NULL, - `TrainerId` int unsigned NOT NULL DEFAULT '0', - `MenuId` int unsigned NOT NULL DEFAULT '0', - `OptionIndex` int unsigned NOT NULL DEFAULT '0', - PRIMARY KEY (`CreatureId`,`MenuId`,`OptionIndex`) + `CreatureID` int unsigned NOT NULL DEFAULT '0', + `TrainerID` int unsigned NOT NULL DEFAULT '0', + `MenuID` int unsigned NOT NULL DEFAULT '0', + `OptionID` int unsigned NOT NULL DEFAULT '0', + PRIMARY KEY (`CreatureID`,`MenuID`,`OptionID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -1163,7 +1182,8 @@ CREATE TABLE `event_scripts` ( `x` float NOT NULL DEFAULT '0', `y` float NOT NULL DEFAULT '0', `z` float NOT NULL DEFAULT '0', - `o` float NOT NULL DEFAULT '0' + `o` float NOT NULL DEFAULT '0', + `Comment` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -1247,9 +1267,9 @@ DROP TABLE IF EXISTS `game_event_battleground_holiday`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `game_event_battleground_holiday` ( - `eventEntry` tinyint unsigned NOT NULL COMMENT 'Entry of the game event', - `bgflag` int unsigned NOT NULL DEFAULT '0', - PRIMARY KEY (`eventEntry`) + `EventEntry` tinyint unsigned NOT NULL COMMENT 'game_event EventEntry identifier', + `BattlegroundID` int unsigned NOT NULL DEFAULT '0', + PRIMARY KEY (`EventEntry`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -1698,6 +1718,11 @@ CREATE TABLE `gameobject_template_addon` ( `flags` int unsigned NOT NULL DEFAULT '0', `mingold` int unsigned NOT NULL DEFAULT '0', `maxgold` int unsigned NOT NULL DEFAULT '0', + `artkit0` int NOT NULL DEFAULT '0', + `artkit1` int NOT NULL DEFAULT '0', + `artkit2` int NOT NULL DEFAULT '0', + `artkit3` int NOT NULL DEFAULT '0', + `artkit4` int NOT NULL DEFAULT '0', `WorldEffectID` int unsigned NOT NULL DEFAULT '0', `AIAnimKitID` int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`entry`) @@ -1769,10 +1794,10 @@ DROP TABLE IF EXISTS `gossip_menu`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `gossip_menu` ( - `MenuId` int unsigned NOT NULL DEFAULT '0', - `TextId` int unsigned NOT NULL DEFAULT '0', + `MenuID` int unsigned NOT NULL DEFAULT '0', + `TextID` int unsigned NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', - PRIMARY KEY (`MenuId`,`TextId`) + PRIMARY KEY (`MenuID`,`TextID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -1784,49 +1809,22 @@ DROP TABLE IF EXISTS `gossip_menu_option`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `gossip_menu_option` ( - `MenuId` int unsigned NOT NULL DEFAULT '0', - `OptionIndex` int unsigned NOT NULL DEFAULT '0', + `MenuID` int unsigned NOT NULL DEFAULT '0', + `OptionID` int unsigned NOT NULL DEFAULT '0', `OptionIcon` tinyint unsigned NOT NULL DEFAULT '0', `OptionText` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, - `OptionBroadcastTextId` int unsigned NOT NULL DEFAULT '0', + `OptionBroadcastTextID` int unsigned NOT NULL DEFAULT '0', `OptionType` int unsigned NOT NULL DEFAULT '0', `OptionNpcFlag` bigint unsigned NOT NULL DEFAULT '0', - `VerifiedBuild` int NOT NULL DEFAULT '0', - PRIMARY KEY (`MenuId`,`OptionIndex`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Table structure for table `gossip_menu_option_action` --- - -DROP TABLE IF EXISTS `gossip_menu_option_action`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!50503 SET character_set_client = utf8mb4 */; -CREATE TABLE `gossip_menu_option_action` ( - `MenuId` int unsigned NOT NULL DEFAULT '0', - `OptionIndex` int unsigned NOT NULL DEFAULT '0', - `ActionMenuId` int unsigned NOT NULL DEFAULT '0', - `ActionPoiId` int unsigned NOT NULL DEFAULT '0', - PRIMARY KEY (`MenuId`,`OptionIndex`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Table structure for table `gossip_menu_option_box` --- - -DROP TABLE IF EXISTS `gossip_menu_option_box`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!50503 SET character_set_client = utf8mb4 */; -CREATE TABLE `gossip_menu_option_box` ( - `MenuId` int unsigned NOT NULL DEFAULT '0', - `OptionIndex` int unsigned NOT NULL DEFAULT '0', + `Language` int unsigned NOT NULL DEFAULT '0', + `ActionMenuID` int unsigned NOT NULL DEFAULT '0', + `ActionPoiID` int unsigned NOT NULL DEFAULT '0', `BoxCoded` tinyint unsigned NOT NULL DEFAULT '0', `BoxMoney` int unsigned NOT NULL DEFAULT '0', - `BoxText` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, - `BoxBroadcastTextId` int unsigned NOT NULL DEFAULT '0', - PRIMARY KEY (`MenuId`,`OptionIndex`) + `BoxText` mediumtext COLLATE utf8mb4_unicode_ci, + `BoxBroadcastTextID` int unsigned NOT NULL DEFAULT '0', + `VerifiedBuild` int NOT NULL DEFAULT '0', + PRIMARY KEY (`MenuID`,`OptionID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -1838,12 +1836,12 @@ DROP TABLE IF EXISTS `gossip_menu_option_locale`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `gossip_menu_option_locale` ( - `MenuId` int unsigned NOT NULL DEFAULT '0', - `OptionIndex` int unsigned NOT NULL DEFAULT '0', + `MenuID` int unsigned NOT NULL DEFAULT '0', + `OptionID` int unsigned NOT NULL DEFAULT '0', `Locale` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `OptionText` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `BoxText` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, - PRIMARY KEY (`MenuId`,`OptionIndex`,`Locale`) + PRIMARY KEY (`MenuID`,`OptionID`,`Locale`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -2378,6 +2376,7 @@ CREATE TABLE `player_classlevelstats` ( `agi` smallint unsigned NOT NULL COMMENT 'agility', `sta` smallint unsigned NOT NULL COMMENT 'stamina', `inte` smallint unsigned NOT NULL COMMENT 'intellect', + `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`class`,`level`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Stores levels stats.'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -2496,6 +2495,9 @@ CREATE TABLE `playerchoice` ( `ChoiceId` int NOT NULL, `UiTextureKitId` int NOT NULL DEFAULT '0', `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 '', `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', @@ -3200,7 +3202,6 @@ CREATE TABLE `quest_template` ( `RewardNextQuest` int unsigned NOT NULL DEFAULT '0', `RewardXPDifficulty` int unsigned NOT NULL DEFAULT '0', `RewardXPMultiplier` float NOT NULL DEFAULT '1', - `RewardMoney` int NOT NULL DEFAULT '0', `RewardMoneyDifficulty` int unsigned NOT NULL DEFAULT '0', `RewardMoneyMultiplier` float NOT NULL DEFAULT '1', `RewardBonusMoney` int unsigned NOT NULL DEFAULT '0', @@ -3657,6 +3658,7 @@ CREATE TABLE `serverside_spell` ( `ChannelInterruptFlags1` int unsigned NOT NULL DEFAULT '0', `ChannelInterruptFlags2` int unsigned NOT NULL DEFAULT '0', `ProcFlags` int unsigned NOT NULL DEFAULT '0', + `ProcFlags2` int unsigned NOT NULL DEFAULT '0', `ProcChance` int unsigned NOT NULL DEFAULT '0', `ProcCharges` int unsigned NOT NULL DEFAULT '0', `ProcCooldown` int unsigned NOT NULL DEFAULT '0', @@ -4090,6 +4092,7 @@ CREATE TABLE `spell_proc` ( `SpellFamilyMask2` int unsigned NOT NULL DEFAULT '0', `SpellFamilyMask3` int unsigned NOT NULL DEFAULT '0', `ProcFlags` int unsigned NOT NULL DEFAULT '0', + `ProcFlags2` int unsigned NOT NULL DEFAULT '0', `SpellTypeMask` int unsigned NOT NULL DEFAULT '0', `SpellPhaseMask` int unsigned NOT NULL DEFAULT '0', `HitMask` int unsigned NOT NULL DEFAULT '0', @@ -4149,7 +4152,8 @@ CREATE TABLE `spell_scripts` ( `x` float NOT NULL DEFAULT '0', `y` float NOT NULL DEFAULT '0', `z` float NOT NULL DEFAULT '0', - `o` float NOT NULL DEFAULT '0' + `o` float NOT NULL DEFAULT '0', + `Comment` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -4448,6 +4452,90 @@ CREATE TABLE `version` ( /*!40101 SET character_set_client = @saved_cs_client */; -- +-- Temporary view structure for view `vw_conditions_with_labels` +-- + +DROP TABLE IF EXISTS `vw_conditions_with_labels`; +/*!50001 DROP VIEW IF EXISTS `vw_conditions_with_labels`*/; +SET @saved_cs_client = @@character_set_client; +/*!50503 SET character_set_client = utf8mb4 */; +/*!50001 CREATE VIEW `vw_conditions_with_labels` AS SELECT + 1 AS `SourceTypeOrReferenceId`, + 1 AS `SourceGroup`, + 1 AS `SourceEntry`, + 1 AS `SourceId`, + 1 AS `ElseGroup`, + 1 AS `ConditionTypeOrReference`, + 1 AS `ConditionTarget`, + 1 AS `ConditionValue1`, + 1 AS `ConditionValue2`, + 1 AS `ConditionValue3`, + 1 AS `NegativeCondition`, + 1 AS `ErrorType`, + 1 AS `ErrorTextId`, + 1 AS `ScriptName`, + 1 AS `Comment`*/; +SET character_set_client = @saved_cs_client; + +-- +-- Temporary view structure for view `vw_disables_with_labels` +-- + +DROP TABLE IF EXISTS `vw_disables_with_labels`; +/*!50001 DROP VIEW IF EXISTS `vw_disables_with_labels`*/; +SET @saved_cs_client = @@character_set_client; +/*!50503 SET character_set_client = utf8mb4 */; +/*!50001 CREATE VIEW `vw_disables_with_labels` AS SELECT + 1 AS `sourceType`, + 1 AS `entry`, + 1 AS `flags`, + 1 AS `params_0`, + 1 AS `params_1`, + 1 AS `comment`*/; +SET character_set_client = @saved_cs_client; + +-- +-- Temporary view structure for view `vw_smart_scripts_with_labels` +-- + +DROP TABLE IF EXISTS `vw_smart_scripts_with_labels`; +/*!50001 DROP VIEW IF EXISTS `vw_smart_scripts_with_labels`*/; +SET @saved_cs_client = @@character_set_client; +/*!50503 SET character_set_client = utf8mb4 */; +/*!50001 CREATE VIEW `vw_smart_scripts_with_labels` AS SELECT + 1 AS `entryorguid`, + 1 AS `source_type`, + 1 AS `id`, + 1 AS `link`, + 1 AS `event_type`, + 1 AS `event_phase_mask`, + 1 AS `event_chance`, + 1 AS `event_flags`, + 1 AS `event_param1`, + 1 AS `event_param2`, + 1 AS `event_param3`, + 1 AS `event_param4`, + 1 AS `event_param5`, + 1 AS `action_type`, + 1 AS `action_param1`, + 1 AS `action_param2`, + 1 AS `action_param3`, + 1 AS `action_param4`, + 1 AS `action_param5`, + 1 AS `action_param6`, + 1 AS `target_type`, + 1 AS `target_param1`, + 1 AS `target_param2`, + 1 AS `target_param3`, + 1 AS `target_param4`, + 1 AS `target_x`, + 1 AS `target_y`, + 1 AS `target_z`, + 1 AS `target_o`, + 1 AS `comment`*/; +SET character_set_client = @saved_cs_client; + +-- -- Table structure for table `warden_checks` -- @@ -4457,14 +4545,14 @@ DROP TABLE IF EXISTS `warden_checks`; CREATE TABLE `warden_checks` ( `id` smallint unsigned NOT NULL AUTO_INCREMENT, `type` tinyint unsigned DEFAULT NULL, - `data` varchar(48) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, - `str` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, + `str` varchar(170) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `address` int unsigned DEFAULT NULL, `length` tinyint unsigned DEFAULT NULL, - `result` varchar(24) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `comment` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, + `data` binary(24) DEFAULT NULL, + `result` varbinary(24) DEFAULT NULL, PRIMARY KEY (`id`) -) ENGINE=InnoDB AUTO_INCREMENT=787 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; +) ENGINE=InnoDB AUTO_INCREMENT=791 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -4509,6 +4597,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 '', PRIMARY KEY (`guid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -4526,6 +4615,8 @@ 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', + `delay` int unsigned NOT NULL DEFAULT '0', `point_comment` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`entry`,`pointid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Creature waypoints'; @@ -4553,6 +4644,60 @@ CREATE TABLE `world_safe_locs` ( -- -- Dumping routines for database 'world' -- + +-- +-- Final view structure for view `vw_conditions_with_labels` +-- + +/*!50001 DROP VIEW IF EXISTS `vw_conditions_with_labels`*/; +/*!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 collation_connection = utf8_general_ci */; +/*!50001 CREATE ALGORITHM=UNDEFINED */ +/*!50013 */ +/*!50001 VIEW `vw_conditions_with_labels` AS select (case when (`conditions`.`SourceTypeOrReferenceId` = 0) then 'CONDITION_SOURCE_TYPE_NONE' when (`conditions`.`SourceTypeOrReferenceId` = 1) then 'CONDITION_SOURCE_TYPE_CREATURE_LOOT_TEMPLATE' when (`conditions`.`SourceTypeOrReferenceId` = 2) then 'CONDITION_SOURCE_TYPE_DISENCHANT_LOOT_TEMPLATE' when (`conditions`.`SourceTypeOrReferenceId` = 3) then 'CONDITION_SOURCE_TYPE_FISHING_LOOT_TEMPLATE' when (`conditions`.`SourceTypeOrReferenceId` = 4) then 'CONDITION_SOURCE_TYPE_GAMEOBJECT_LOOT_TEMPLATE' when (`conditions`.`SourceTypeOrReferenceId` = 5) then 'CONDITION_SOURCE_TYPE_ITEM_LOOT_TEMPLATE' when (`conditions`.`SourceTypeOrReferenceId` = 6) then 'CONDITION_SOURCE_TYPE_MAIL_LOOT_TEMPLATE' when (`conditions`.`SourceTypeOrReferenceId` = 7) then 'CONDITION_SOURCE_TYPE_MILLING_LOOT_TEMPLATE' when (`conditions`.`SourceTypeOrReferenceId` = 8) then 'CONDITION_SOURCE_TYPE_PICKPOCKETING_LOOT_TEMPLATE' when (`conditions`.`SourceTypeOrReferenceId` = 9) then 'CONDITION_SOURCE_TYPE_PROSPECTING_LOOT_TEMPLATE' when (`conditions`.`SourceTypeOrReferenceId` = 10) then 'CONDITION_SOURCE_TYPE_REFERENCE_LOOT_TEMPLATE' when (`conditions`.`SourceTypeOrReferenceId` = 11) then 'CONDITION_SOURCE_TYPE_SKINNING_LOOT_TEMPLATE' when (`conditions`.`SourceTypeOrReferenceId` = 12) then 'CONDITION_SOURCE_TYPE_SPELL_LOOT_TEMPLATE' when (`conditions`.`SourceTypeOrReferenceId` = 13) then 'CONDITION_SOURCE_TYPE_SPELL_IMPLICIT_TARGET' when (`conditions`.`SourceTypeOrReferenceId` = 14) then 'CONDITION_SOURCE_TYPE_GOSSIP_MENU' when (`conditions`.`SourceTypeOrReferenceId` = 15) then 'CONDITION_SOURCE_TYPE_GOSSIP_MENU_OPTION' when (`conditions`.`SourceTypeOrReferenceId` = 16) then 'CONDITION_SOURCE_TYPE_CREATURE_TEMPLATE_VEHICLE' when (`conditions`.`SourceTypeOrReferenceId` = 17) then 'CONDITION_SOURCE_TYPE_SPELL' when (`conditions`.`SourceTypeOrReferenceId` = 18) then 'CONDITION_SOURCE_TYPE_SPELL_CLICK_EVENT' when (`conditions`.`SourceTypeOrReferenceId` = 19) then 'CONDITION_SOURCE_TYPE_QUEST_AVAILABLE' when (`conditions`.`SourceTypeOrReferenceId` = 21) then 'CONDITION_SOURCE_TYPE_VEHICLE_SPELL' when (`conditions`.`SourceTypeOrReferenceId` = 22) then 'CONDITION_SOURCE_TYPE_SMART_EVENT' when (`conditions`.`SourceTypeOrReferenceId` = 23) then 'CONDITION_SOURCE_TYPE_NPC_VENDOR' when (`conditions`.`SourceTypeOrReferenceId` = 24) then 'CONDITION_SOURCE_TYPE_SPELL_PROC' when (`conditions`.`SourceTypeOrReferenceId` = 25) then 'CONDITION_SOURCE_TYPE_TERRAIN_SWAP' when (`conditions`.`SourceTypeOrReferenceId` = 26) then 'CONDITION_SOURCE_TYPE_PHASE' when (`conditions`.`SourceTypeOrReferenceId` = 27) then 'CONDITION_SOURCE_TYPE_GRAVEYARD' when (`conditions`.`SourceTypeOrReferenceId` = 28) then 'CONDITION_SOURCE_TYPE_AREATRIGGER' when (`conditions`.`SourceTypeOrReferenceId` = 29) then 'CONDITION_SOURCE_TYPE_CONVERSATION_LINE' when (`conditions`.`SourceTypeOrReferenceId` = 30) then 'CONDITION_SOURCE_TYPE_AREATRIGGER_CLIENT_TRIGGERED' when (`conditions`.`SourceTypeOrReferenceId` = 31) then 'CONDITION_SOURCE_TYPE_TRAINER_SPELL' when (`conditions`.`SourceTypeOrReferenceId` = 32) then 'CONDITION_SOURCE_TYPE_OBJECT_ID_VISIBILITY' else `conditions`.`SourceTypeOrReferenceId` end) AS `SourceTypeOrReferenceId`,`conditions`.`SourceGroup` AS `SourceGroup`,`conditions`.`SourceEntry` AS `SourceEntry`,`conditions`.`SourceId` AS `SourceId`,`conditions`.`ElseGroup` AS `ElseGroup`,(case when (`conditions`.`SourceTypeOrReferenceId` = 0) then 'CONDITION_NONE' when (`conditions`.`SourceTypeOrReferenceId` = 1) then 'CONDITION_AURA' when (`conditions`.`SourceTypeOrReferenceId` = 2) then 'CONDITION_ITEM' when (`conditions`.`SourceTypeOrReferenceId` = 3) then 'CONDITION_ITEM_EQUIPPED' when (`conditions`.`SourceTypeOrReferenceId` = 4) then 'CONDITION_ZONEID' when (`conditions`.`SourceTypeOrReferenceId` = 5) then 'CONDITION_REPUTATION_RANK' when (`conditions`.`SourceTypeOrReferenceId` = 6) then 'CONDITION_TEAM' when (`conditions`.`SourceTypeOrReferenceId` = 7) then 'CONDITION_SKILL' when (`conditions`.`SourceTypeOrReferenceId` = 8) then 'CONDITION_QUESTREWARDED' when (`conditions`.`SourceTypeOrReferenceId` = 9) then 'CONDITION_QUESTTAKEN' when (`conditions`.`SourceTypeOrReferenceId` = 10) then 'CONDITION_DRUNKENSTATE' when (`conditions`.`SourceTypeOrReferenceId` = 11) then 'CONDITION_WORLD_STATE' when (`conditions`.`SourceTypeOrReferenceId` = 12) then 'CONDITION_ACTIVE_EVENT' when (`conditions`.`SourceTypeOrReferenceId` = 13) then 'CONDITION_INSTANCE_INFO' when (`conditions`.`SourceTypeOrReferenceId` = 14) then 'CONDITION_QUEST_NONE' when (`conditions`.`SourceTypeOrReferenceId` = 15) then 'CONDITION_CLASS' when (`conditions`.`SourceTypeOrReferenceId` = 16) then 'CONDITION_RACE' when (`conditions`.`SourceTypeOrReferenceId` = 17) then 'CONDITION_ACHIEVEMENT' when (`conditions`.`SourceTypeOrReferenceId` = 18) then 'CONDITION_TITLE' when (`conditions`.`SourceTypeOrReferenceId` = 19) then 'CONDITION_SPAWNMASK' when (`conditions`.`SourceTypeOrReferenceId` = 20) then 'CONDITION_GENDER' when (`conditions`.`SourceTypeOrReferenceId` = 21) then 'CONDITION_UNIT_STATE' when (`conditions`.`SourceTypeOrReferenceId` = 22) then 'CONDITION_MAPID' when (`conditions`.`SourceTypeOrReferenceId` = 23) then 'CONDITION_AREAID' when (`conditions`.`SourceTypeOrReferenceId` = 24) then 'CONDITION_CREATURE_TYPE' when (`conditions`.`SourceTypeOrReferenceId` = 25) then 'CONDITION_SPELL' when (`conditions`.`SourceTypeOrReferenceId` = 26) then 'CONDITION_PHASEMASK' when (`conditions`.`SourceTypeOrReferenceId` = 27) then 'CONDITION_LEVEL' when (`conditions`.`SourceTypeOrReferenceId` = 28) then 'CONDITION_QUEST_COMPLETE' when (`conditions`.`SourceTypeOrReferenceId` = 29) then 'CONDITION_NEAR_CREATURE' when (`conditions`.`SourceTypeOrReferenceId` = 30) then 'CONDITION_NEAR_GAMEOBJECT' when (`conditions`.`SourceTypeOrReferenceId` = 31) then 'CONDITION_OBJECT_ENTRY_GUID_LEGACY' when (`conditions`.`SourceTypeOrReferenceId` = 32) then 'CONDITION_TYPE_MASK_LEGACY' when (`conditions`.`SourceTypeOrReferenceId` = 33) then 'CONDITION_RELATION_TO' when (`conditions`.`SourceTypeOrReferenceId` = 34) then 'CONDITION_REACTION_TO' when (`conditions`.`SourceTypeOrReferenceId` = 35) then 'CONDITION_DISTANCE_TO' when (`conditions`.`SourceTypeOrReferenceId` = 36) then 'CONDITION_ALIVE' when (`conditions`.`SourceTypeOrReferenceId` = 37) then 'CONDITION_HP_VAL' when (`conditions`.`SourceTypeOrReferenceId` = 38) then 'CONDITION_HP_PCT' when (`conditions`.`SourceTypeOrReferenceId` = 39) then 'CONDITION_REALM_ACHIEVEMENT' when (`conditions`.`SourceTypeOrReferenceId` = 40) then 'CONDITION_IN_WATER' when (`conditions`.`SourceTypeOrReferenceId` = 41) then 'CONDITION_TERRAIN_SWAP' when (`conditions`.`SourceTypeOrReferenceId` = 42) then 'CONDITION_STAND_STATE' when (`conditions`.`SourceTypeOrReferenceId` = 43) then 'CONDITION_DAILY_QUEST_DONE' when (`conditions`.`SourceTypeOrReferenceId` = 44) then 'CONDITION_CHARMED' when (`conditions`.`SourceTypeOrReferenceId` = 45) then 'CONDITION_PET_TYPE' when (`conditions`.`SourceTypeOrReferenceId` = 46) then 'CONDITION_TAXI' when (`conditions`.`SourceTypeOrReferenceId` = 47) then 'CONDITION_QUESTSTATE' when (`conditions`.`SourceTypeOrReferenceId` = 48) then 'CONDITION_QUEST_OBJECTIVE_PROGRESS' when (`conditions`.`SourceTypeOrReferenceId` = 49) then 'CONDITION_DIFFICULTY_ID' when (`conditions`.`SourceTypeOrReferenceId` = 50) then 'CONDITION_GAMEMASTER' when (`conditions`.`SourceTypeOrReferenceId` = 51) then 'CONDITION_OBJECT_ENTRY_GUID' when (`conditions`.`SourceTypeOrReferenceId` = 52) then 'CONDITION_TYPE_MASK' else `conditions`.`ConditionTypeOrReference` end) AS `ConditionTypeOrReference`,`conditions`.`ConditionTarget` AS `ConditionTarget`,`conditions`.`ConditionValue1` AS `ConditionValue1`,`conditions`.`ConditionValue2` AS `ConditionValue2`,`conditions`.`ConditionValue3` AS `ConditionValue3`,`conditions`.`NegativeCondition` AS `NegativeCondition`,`conditions`.`ErrorType` AS `ErrorType`,`conditions`.`ErrorTextId` AS `ErrorTextId`,`conditions`.`ScriptName` AS `ScriptName`,`conditions`.`Comment` AS `Comment` from `conditions` */; +/*!50001 SET character_set_client = @saved_cs_client */; +/*!50001 SET character_set_results = @saved_cs_results */; +/*!50001 SET collation_connection = @saved_col_connection */; + +-- +-- Final view structure for view `vw_disables_with_labels` +-- + +/*!50001 DROP VIEW IF EXISTS `vw_disables_with_labels`*/; +/*!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 collation_connection = utf8_general_ci */; +/*!50001 CREATE ALGORITHM=UNDEFINED */ +/*!50013 */ +/*!50001 VIEW `vw_disables_with_labels` AS select (case when (`disables`.`sourceType` = 0) then 'DISABLE_TYPE_SPELL' when (`disables`.`sourceType` = 1) then 'DISABLE_TYPE_QUEST' when (`disables`.`sourceType` = 2) then 'DISABLE_TYPE_MAP' when (`disables`.`sourceType` = 3) then 'DISABLE_TYPE_BATTLEGROUND' when (`disables`.`sourceType` = 4) then 'DISABLE_TYPE_ACHIEVEMENT_CRITERIA' when (`disables`.`sourceType` = 5) then 'DISABLE_TYPE_OUTDOORPVP' when (`disables`.`sourceType` = 6) then 'DISABLE_TYPE_VMAP' when (`disables`.`sourceType` = 7) then 'DISABLE_TYPE_MMAP' when (`disables`.`sourceType` = 8) then 'DISABLE_TYPE_LFG_MAP' else `disables`.`sourceType` end) AS `sourceType`,`disables`.`entry` AS `entry`,`disables`.`flags` AS `flags`,`disables`.`params_0` AS `params_0`,`disables`.`params_1` AS `params_1`,`disables`.`comment` AS `comment` from `disables` */; +/*!50001 SET character_set_client = @saved_cs_client */; +/*!50001 SET character_set_results = @saved_cs_results */; +/*!50001 SET collation_connection = @saved_col_connection */; + +-- +-- Final view structure for view `vw_smart_scripts_with_labels` +-- + +/*!50001 DROP VIEW IF EXISTS `vw_smart_scripts_with_labels`*/; +/*!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 collation_connection = utf8_general_ci */; +/*!50001 CREATE ALGORITHM=UNDEFINED */ +/*!50013 */ +/*!50001 VIEW `vw_smart_scripts_with_labels` AS select `smart_scripts`.`entryorguid` AS `entryorguid`,`smart_scripts`.`source_type` AS `source_type`,`smart_scripts`.`id` AS `id`,`smart_scripts`.`link` AS `link`,(case `smart_scripts`.`event_type` when 0 then 'SMART_EVENT_UPDATE_IC' when 1 then 'SMART_EVENT_UPDATE_OOC' when 2 then 'SMART_EVENT_HEALTH_PCT' when 3 then 'SMART_EVENT_MANA_PCT' when 4 then 'SMART_EVENT_AGGRO' when 5 then 'SMART_EVENT_KILL' when 6 then 'SMART_EVENT_DEATH' when 7 then 'SMART_EVENT_EVADE' when 8 then 'SMART_EVENT_SPELLHIT' when 9 then 'SMART_EVENT_RANGE' when 10 then 'SMART_EVENT_OOC_LOS' when 11 then 'SMART_EVENT_RESPAWN' when 12 then 'SMART_EVENT_TARGET_HEALTH_PCT' when 13 then 'SMART_EVENT_VICTIM_CASTING' when 14 then 'SMART_EVENT_FRIENDLY_HEALTH' when 15 then 'SMART_EVENT_FRIENDLY_IS_CC' when 16 then 'SMART_EVENT_FRIENDLY_MISSING_BUFF' when 17 then 'SMART_EVENT_SUMMONED_UNIT' when 18 then 'SMART_EVENT_TARGET_MANA_PCT' when 19 then 'SMART_EVENT_ACCEPTED_QUEST' when 20 then 'SMART_EVENT_REWARD_QUEST' when 21 then 'SMART_EVENT_REACHED_HOME' when 22 then 'SMART_EVENT_RECEIVE_EMOTE' when 23 then 'SMART_EVENT_HAS_AURA' when 24 then 'SMART_EVENT_TARGET_BUFFED' when 25 then 'SMART_EVENT_RESET' when 26 then 'SMART_EVENT_IC_LOS' when 27 then 'SMART_EVENT_PASSENGER_BOARDED' when 28 then 'SMART_EVENT_PASSENGER_REMOVED' when 29 then 'SMART_EVENT_CHARMED' when 30 then 'SMART_EVENT_CHARMED_TARGET' when 31 then 'SMART_EVENT_SPELLHIT_TARGET' when 32 then 'SMART_EVENT_DAMAGED' when 33 then 'SMART_EVENT_DAMAGED_TARGET' when 34 then 'SMART_EVENT_MOVEMENTINFORM' when 35 then 'SMART_EVENT_SUMMON_DESPAWNED' when 36 then 'SMART_EVENT_CORPSE_REMOVED' when 37 then 'SMART_EVENT_AI_INIT' when 38 then 'SMART_EVENT_DATA_SET' when 39 then 'SMART_EVENT_WAYPOINT_START' when 40 then 'SMART_EVENT_WAYPOINT_REACHED' when 41 then 'SMART_EVENT_TRANSPORT_ADDPLAYER' when 42 then 'SMART_EVENT_TRANSPORT_ADDCREATURE' when 43 then 'SMART_EVENT_TRANSPORT_REMOVE_PLAYER' when 44 then 'SMART_EVENT_TRANSPORT_RELOCATE' when 45 then 'SMART_EVENT_INSTANCE_PLAYER_ENTER' when 46 then 'SMART_EVENT_AREATRIGGER_ONTRIGGER' when 47 then 'SMART_EVENT_QUEST_ACCEPTED' when 48 then 'SMART_EVENT_QUEST_OBJ_COPLETETION' when 49 then 'SMART_EVENT_QUEST_COMPLETION' when 50 then 'SMART_EVENT_QUEST_REWARDED' when 51 then 'SMART_EVENT_QUEST_FAIL' when 52 then 'SMART_EVENT_TEXT_OVER' when 53 then 'SMART_EVENT_RECEIVE_HEAL' when 54 then 'SMART_EVENT_JUST_SUMMONED' when 55 then 'SMART_EVENT_WAYPOINT_PAUSED' when 56 then 'SMART_EVENT_WAYPOINT_RESUMED' when 57 then 'SMART_EVENT_WAYPOINT_STOPPED' when 58 then 'SMART_EVENT_WAYPOINT_ENDED' when 59 then 'SMART_EVENT_TIMED_EVENT_TRIGGERED' when 60 then 'SMART_EVENT_UPDATE' when 61 then 'SMART_EVENT_LINK' when 62 then 'SMART_EVENT_GOSSIP_SELECT' when 63 then 'SMART_EVENT_JUST_CREATED' when 64 then 'SMART_EVENT_GOSSIP_HELLO' when 65 then 'SMART_EVENT_FOLLOW_COMPLETED' when 66 then 'SMART_EVENT_EVENT_PHASE_CHANGE' when 67 then 'SMART_EVENT_IS_BEHIND_TARGET' when 68 then 'SMART_EVENT_GAME_EVENT_START' when 69 then 'SMART_EVENT_GAME_EVENT_END' when 70 then 'SMART_EVENT_GO_LOOT_STATE_CHANGED' when 71 then 'SMART_EVENT_GO_EVENT_INFORM' when 72 then 'SMART_EVENT_ACTION_DONE' when 73 then 'SMART_EVENT_ON_SPELLCLICK' when 74 then 'SMART_EVENT_FRIENDLY_HEALTH_PCT' when 75 then 'SMART_EVENT_DISTANCE_CREATURE' when 76 then 'SMART_EVENT_DISTANCE_GAMEOBJECT' when 77 then 'SMART_EVENT_COUNTER_SET' when 78 then 'SMART_EVENT_SCENE_START' when 79 then 'SMART_EVENT_SCENE_TRIGGER' when 80 then 'SMART_EVENT_SCENE_CANCEL' when 81 then 'SMART_EVENT_SCENE_COMPLETE' when 82 then 'SMART_EVENT_SUMMONED_UNIT_DIES' else `smart_scripts`.`event_type` end) AS `event_type`,`smart_scripts`.`event_phase_mask` AS `event_phase_mask`,`smart_scripts`.`event_chance` AS `event_chance`,`smart_scripts`.`event_flags` AS `event_flags`,`smart_scripts`.`event_param1` AS `event_param1`,`smart_scripts`.`event_param2` AS `event_param2`,`smart_scripts`.`event_param3` AS `event_param3`,`smart_scripts`.`event_param4` AS `event_param4`,`smart_scripts`.`event_param5` AS `event_param5`,(case `smart_scripts`.`action_type` when 0 then 'SMART_ACTION_NONE' when 1 then 'SMART_ACTION_TALK' when 2 then 'SMART_ACTION_SET_FACTION' when 3 then 'SMART_ACTION_MORPH_TO_ENTRY_OR_MODEL' when 4 then 'SMART_ACTION_SOUND' when 5 then 'SMART_ACTION_PLAY_EMOTE' when 6 then 'SMART_ACTION_FAIL_QUEST' when 7 then 'SMART_ACTION_OFFER_QUEST' when 8 then 'SMART_ACTION_SET_REACT_STATE' when 9 then 'SMART_ACTION_ACTIVATE_GOBJECT' when 10 then 'SMART_ACTION_RANDOM_EMOTE' when 11 then 'SMART_ACTION_CAST' when 12 then 'SMART_ACTION_SUMMON_CREATURE' when 13 then 'SMART_ACTION_THREAT_SINGLE_PCT' when 14 then 'SMART_ACTION_THREAT_ALL_PCT' when 15 then 'SMART_ACTION_CALL_AREAEXPLOREDOREVENTHAPPENS' when 16 then 'SMART_ACTION_SET_INGAME_PHASE_GROUP' when 17 then 'SMART_ACTION_SET_EMOTE_STATE' when 18 then 'SMART_ACTION_SET_UNIT_FLAG' when 19 then 'SMART_ACTION_REMOVE_UNIT_FLAG' when 20 then 'SMART_ACTION_AUTO_ATTACK' when 21 then 'SMART_ACTION_ALLOW_COMBAT_MOVEMENT' when 22 then 'SMART_ACTION_SET_EVENT_PHASE' when 23 then 'SMART_ACTION_INC_EVENT_PHASE' when 24 then 'SMART_ACTION_EVADE' when 25 then 'SMART_ACTION_FLEE_FOR_ASSIST' when 26 then 'SMART_ACTION_CALL_GROUPEVENTHAPPENS' when 27 then 'SMART_ACTION_COMBAT_STOP' when 28 then 'SMART_ACTION_REMOVEAURASFROMSPELL' when 29 then 'SMART_ACTION_FOLLOW' when 30 then 'SMART_ACTION_RANDOM_PHASE' when 31 then 'SMART_ACTION_RANDOM_PHASE_RANGE' when 32 then 'SMART_ACTION_RESET_GOBJECT' when 33 then 'SMART_ACTION_CALL_KILLEDMONSTER' when 34 then 'SMART_ACTION_SET_INST_DATA' when 35 then 'SMART_ACTION_SET_INST_DATA64' when 36 then 'SMART_ACTION_UPDATE_TEMPLATE' when 37 then 'SMART_ACTION_DIE' when 38 then 'SMART_ACTION_SET_IN_COMBAT_WITH_ZONE' when 39 then 'SMART_ACTION_CALL_FOR_HELP' when 40 then 'SMART_ACTION_SET_SHEATH' when 41 then 'SMART_ACTION_FORCE_DESPAWN' when 42 then 'SMART_ACTION_SET_INVINCIBILITY_HP_LEVEL' when 43 then 'SMART_ACTION_MOUNT_TO_ENTRY_OR_MODEL' when 44 then 'SMART_ACTION_SET_INGAME_PHASE_ID' when 45 then 'SMART_ACTION_SET_DATA' when 46 then 'SMART_ACTION_ATTACK_STOP' when 47 then 'SMART_ACTION_SET_VISIBILITY' when 48 then 'SMART_ACTION_SET_ACTIVE' when 49 then 'SMART_ACTION_ATTACK_START' when 50 then 'SMART_ACTION_SUMMON_GO' when 51 then 'SMART_ACTION_KILL_UNIT' when 52 then 'SMART_ACTION_ACTIVATE_TAXI' when 53 then 'SMART_ACTION_WP_START' when 54 then 'SMART_ACTION_WP_PAUSE' when 55 then 'SMART_ACTION_WP_STOP' when 56 then 'SMART_ACTION_ADD_ITEM' when 57 then 'SMART_ACTION_REMOVE_ITEM' when 58 then 'SMART_ACTION_INSTALL_AI_TEMPLATE' when 59 then 'SMART_ACTION_SET_RUN' when 60 then 'SMART_ACTION_SET_DISABLE_GRAVITY' when 61 then 'SMART_ACTION_SET_SWIM' when 62 then 'SMART_ACTION_TELEPORT' when 63 then 'SMART_ACTION_SET_COUNTER' when 64 then 'SMART_ACTION_STORE_TARGET_LIST' when 65 then 'SMART_ACTION_WP_RESUME' when 66 then 'SMART_ACTION_SET_ORIENTATION' when 67 then 'SMART_ACTION_CREATE_TIMED_EVENT' when 68 then 'SMART_ACTION_PLAYMOVIE' when 69 then 'SMART_ACTION_MOVE_TO_POS' when 70 then 'SMART_ACTION_ENABLE_TEMP_GOBJ' when 71 then 'SMART_ACTION_EQUIP' when 72 then 'SMART_ACTION_CLOSE_GOSSIP' when 73 then 'SMART_ACTION_TRIGGER_TIMED_EVENT' when 74 then 'SMART_ACTION_REMOVE_TIMED_EVENT' when 75 then 'SMART_ACTION_ADD_AURA' when 76 then 'SMART_ACTION_OVERRIDE_SCRIPT_BASE_OBJECT' when 77 then 'SMART_ACTION_RESET_SCRIPT_BASE_OBJECT' when 78 then 'SMART_ACTION_CALL_SCRIPT_RESET' when 79 then 'SMART_ACTION_SET_RANGED_MOVEMENT' when 80 then 'SMART_ACTION_CALL_TIMED_ACTIONLIST' when 81 then 'SMART_ACTION_SET_NPC_FLAG' when 82 then 'SMART_ACTION_ADD_NPC_FLAG' when 83 then 'SMART_ACTION_REMOVE_NPC_FLAG' when 84 then 'SMART_ACTION_SIMPLE_TALK' when 85 then 'SMART_ACTION_SELF_CAST' when 86 then 'SMART_ACTION_CROSS_CAST' when 87 then 'SMART_ACTION_CALL_RANDOM_TIMED_ACTIONLIST' when 88 then 'SMART_ACTION_CALL_RANDOM_RANGE_TIMED_ACTIONLIST' when 89 then 'SMART_ACTION_RANDOM_MOVE' when 90 then 'SMART_ACTION_SET_UNIT_FIELD_BYTES_1' when 91 then 'SMART_ACTION_REMOVE_UNIT_FIELD_BYTES_1' when 92 then 'SMART_ACTION_INTERRUPT_SPELL' when 93 then 'SMART_ACTION_SEND_GO_CUSTOM_ANIM' when 94 then 'SMART_ACTION_SET_DYNAMIC_FLAG' when 95 then 'SMART_ACTION_ADD_DYNAMIC_FLAG' when 96 then 'SMART_ACTION_REMOVE_DYNAMIC_FLAG' when 97 then 'SMART_ACTION_JUMP_TO_POS' when 98 then 'SMART_ACTION_SEND_GOSSIP_MENU' when 99 then 'SMART_ACTION_GO_SET_LOOT_STATE' when 100 then 'SMART_ACTION_SEND_TARGET_TO_TARGET' when 101 then 'SMART_ACTION_SET_HOME_POS' when 102 then 'SMART_ACTION_SET_HEALTH_REGEN' when 103 then 'SMART_ACTION_SET_ROOT' when 104 then 'SMART_ACTION_SET_GO_FLAG' when 105 then 'SMART_ACTION_ADD_GO_FLAG' when 106 then 'SMART_ACTION_REMOVE_GO_FLAG' when 107 then 'SMART_ACTION_SUMMON_CREATURE_GROUP' when 108 then 'SMART_ACTION_SET_POWER' when 109 then 'SMART_ACTION_ADD_POWER' when 110 then 'SMART_ACTION_REMOVE_POWER' when 111 then 'SMART_ACTION_GAME_EVENT_STOP' when 112 then 'SMART_ACTION_GAME_EVENT_START' when 113 then 'SMART_ACTION_START_CLOSEST_WAYPOINT' when 114 then 'SMART_ACTION_MOVE_OFFSET' when 115 then 'SMART_ACTION_RANDOM_SOUND' when 116 then 'SMART_ACTION_SET_CORPSE_DELAY' when 117 then 'SMART_ACTION_DISABLE_EVADE' when 118 then 'SMART_ACTION_GO_SET_GO_STATE' when 119 then 'SMART_ACTION_SET_CAN_FLY' when 120 then 'SMART_ACTION_REMOVE_AURAS_BY_TYPE' when 121 then 'SMART_ACTION_SET_SIGHT_DIST' when 122 then 'SMART_ACTION_FLEE' when 123 then 'SMART_ACTION_ADD_THREAT' when 124 then 'SMART_ACTION_LOAD_EQUIPMENT' when 125 then 'SMART_ACTION_TRIGGER_RANDOM_TIMED_EVENT' when 126 then 'SMART_ACTION_REMOVE_ALL_GAMEOBJECTS' when 127 then 'SMART_ACTION_PAUSE_MOVEMENT' when 128 then 'SMART_ACTION_PLAY_ANIMKIT' when 129 then 'SMART_ACTION_SCENE_PLAY' when 130 then 'SMART_ACTION_SCENE_CANCEL' when 131 then 'SMART_ACTION_SPAWN_SPAWNGROUP' when 132 then 'SMART_ACTION_DESPAWN_SPAWNGROUP' when 133 then 'SMART_ACTION_RESPAWN_BY_SPAWNID' when 134 then 'SMART_ACTION_INVOKER_CAST' when 135 then 'SMART_ACTION_PLAY_CINEMATIC' when 136 then 'SMART_ACTION_SET_MOVEMENT_SPEED' when 137 then 'SMART_ACTION_PLAY_SPELL_VISUAL_KIT' when 138 then 'SMART_ACTION_OVERRIDE_LIGHT' when 139 then 'SMART_ACTION_OVERRIDE_WEATHER' when 143 then 'SMART_ACTION_CREATE_CONVERSATION' when 144 then 'SMART_ACTION_SET_IMMUNE_PC' when 145 then 'SMART_ACTION_SET_IMMUNE_NPC' when 146 then 'SMART_ACTION_SET_UNINTERACTIBLE' when 147 then 'SMART_ACTION_ACTIVATE_GAMEOBJECT' when 148 then 'SMART_ACTION_ADD_TO_STORED_TARGET_LIST' when 149 then 'SMART_ACTION_BECOME_PERSONAL_CLONE_FOR_PLAYER' else `smart_scripts`.`action_type` end) AS `action_type`,`smart_scripts`.`action_param1` AS `action_param1`,`smart_scripts`.`action_param2` AS `action_param2`,`smart_scripts`.`action_param3` AS `action_param3`,`smart_scripts`.`action_param4` AS `action_param4`,`smart_scripts`.`action_param5` AS `action_param5`,`smart_scripts`.`action_param6` AS `action_param6`,(case `smart_scripts`.`target_type` when 0 then 'SMART_TARGET_NONE' when 1 then 'SMART_TARGET_SELF' when 2 then 'SMART_TARGET_VICTIM' when 3 then 'SMART_TARGET_HOSTILE_SECOND_AGGRO' when 4 then 'SMART_TARGET_HOSTILE_LAST_AGGRO' when 5 then 'SMART_TARGET_HOSTILE_RANDOM' when 6 then 'SMART_TARGET_HOSTILE_RANDOM_NOT_TOP' when 7 then 'SMART_TARGET_ACTION_INVOKER' when 8 then 'SMART_TARGET_POSITION' when 9 then 'SMART_TARGET_CREATURE_RANGE' when 10 then 'SMART_TARGET_CREATURE_GUID' when 11 then 'SMART_TARGET_CREATURE_DISTANCE' when 12 then 'SMART_TARGET_STORED' when 13 then 'SMART_TARGET_GAMEOBJECT_RANGE' when 14 then 'SMART_TARGET_GAMEOBJECT_GUID' when 15 then 'SMART_TARGET_GAMEOBJECT_DISTANCE' when 16 then 'SMART_TARGET_INVOKER_PARTY' when 17 then 'SMART_TARGET_PLAYER_RANGE' when 18 then 'SMART_TARGET_PLAYER_DISTANCE' when 19 then 'SMART_TARGET_CLOSEST_CREATURE' when 20 then 'SMART_TARGET_CLOSEST_GAMEOBJECT' when 21 then 'SMART_TARGET_CLOSEST_PLAYER' when 22 then 'SMART_TARGET_ACTION_INVOKER_VEHICLE' when 23 then 'SMART_TARGET_OWNER_OR_SUMMONER' when 24 then 'SMART_TARGET_THREAT_LIST' when 25 then 'SMART_TARGET_CLOSEST_ENEMY' when 26 then 'SMART_TARGET_CLOSEST_FRIENDLY' when 27 then 'SMART_TARGET_LOOT_RECIPIENTS' when 28 then 'SMART_TARGET_FARTHEST' when 29 then 'SMART_TARGET_VEHICLE_PASSENGER' when 30 then 'SMART_TARGET_CLOSEST_UNSPAWNED_GAMEOBJECT' else `smart_scripts`.`target_type` end) AS `target_type`,`smart_scripts`.`target_param1` AS `target_param1`,`smart_scripts`.`target_param2` AS `target_param2`,`smart_scripts`.`target_param3` AS `target_param3`,`smart_scripts`.`target_param4` AS `target_param4`,`smart_scripts`.`target_x` AS `target_x`,`smart_scripts`.`target_y` AS `target_y`,`smart_scripts`.`target_z` AS `target_z`,`smart_scripts`.`target_o` AS `target_o`,`smart_scripts`.`comment` AS `comment` from `smart_scripts` */; +/*!50001 SET character_set_client = @saved_cs_client */; +/*!50001 SET character_set_results = @saved_cs_results */; +/*!50001 SET collation_connection = @saved_col_connection */; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; @@ -4563,4 +4708,4 @@ CREATE TABLE `world_safe_locs` ( /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2022-01-15 23:25:03 +-- Dump completed on 2022-03-06 15:12:29 |