TDB 1027.24051 - 2024/05/11TDB1027.24051

4 files changed, 195 insertions, 41 deletions

diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql
index 2b41768025b..1aa273034f3 100644
--- a/sql/base/auth_database.sql
+++ b/sql/base/auth_database.sql
@@ -2,7 +2,7 @@
 --
 -- Host: localhost    Database: auth
 -- ------------------------------------------------------
--- Server version	8.0.36-0ubuntu0.20.04.1
+-- Server version	8.0.36-0ubuntu0.22.04.1
 
 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
 /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
@@ -2814,19 +2814,20 @@ INSERT INTO `updates` VALUES
 ('2024_02_01_00_auth.sql','1822B9B3E28AB0E77CF253C6A96F78EB5020447A','ARCHIVED','2024-02-01 10:46:27',0),
 ('2024_02_07_00_auth.sql','F6A65673A7020B4C64083AFC1CAD4206BC960170','ARCHIVED','2024-02-07 12:26:24',0),
 ('2024_02_08_00_auth.sql','E62D51C3D536FDF79EBEDFE060EB9D232ACE1EDD','ARCHIVED','2024-02-08 00:56:26',0),
-('2024_02_08_01_auth.sql','9972EE1527DFC182527FA3C1AC086B189574BDF0','RELEASED','2024-02-08 22:32:41',0),
-('2024_02_24_00_auth.sql','BEB6F94703C4574088289DFFC8E7660D223E2841','RELEASED','2024-02-24 00:27:13',0),
-('2024_03_05_00_auth.sql','61341FABF7243FBCBB6BDE35CECE1F7DFD988F26','RELEASED','2024-03-05 20:43:51',0),
-('2024_03_21_00_auth.sql','5D4F3479B0F4E16E59B1CC9EB21E5CE5531555B9','RELEASED','2024-03-21 16:56:21',0),
-('2024_03_22_00_auth.sql','4F184E4BF361195C560A569E57A6FF6429077849','RELEASED','2024-03-22 20:29:29',0),
-('2024_03_25_00_auth.sql','B4EF57DE84195E0B886B070ACE58B66853FFC52C','RELEASED','2024-03-25 23:20:57',0),
-('2024_03_29_00_auth.sql','F1F62C913F5DFB277DB3D1258022EC334EFC419B','RELEASED','2024-03-29 10:49:54',0),
-('2024_04_08_00_auth.sql','B05516DB306A06982206180A2A18407D9E0012DE','RELEASED','2024-04-08 21:56:33',0),
-('2024_04_12_00_auth.sql','3D2DCEA21AE5104EF192CACAAFBB5131AD355791','RELEASED','2024-04-12 12:07:49',0),
-('2024_04_22_00_auth.sql','83566EA54235D588697D747D8130CD6D37445CC5','RELEASED','2024-04-22 23:05:46',0),
-('2024_05_01_00_auth.sql','2A1C2B4E54706BDD1FDD57AFB943058BEE8D8852','RELEASED','2024-05-01 21:32:43',0),
-('2024_05_08_00_auth.sql','F2EEE0D225CB82DBB3A478E0BF6A0116C9265355','RELEASED','2024-05-08 20:35:53',0),
-('2024_05_10_00_auth.sql','8A6E48012413EA769601A8E4C9F82BEFBE1FCA5C','RELEASED','2024-05-10 00:50:46',0);
+('2024_02_08_01_auth.sql','9972EE1527DFC182527FA3C1AC086B189574BDF0','ARCHIVED','2024-02-08 22:32:41',0),
+('2024_02_24_00_auth.sql','BEB6F94703C4574088289DFFC8E7660D223E2841','ARCHIVED','2024-02-24 00:27:13',0),
+('2024_03_05_00_auth.sql','61341FABF7243FBCBB6BDE35CECE1F7DFD988F26','ARCHIVED','2024-03-05 20:43:51',0),
+('2024_03_21_00_auth.sql','5D4F3479B0F4E16E59B1CC9EB21E5CE5531555B9','ARCHIVED','2024-03-21 16:56:21',0),
+('2024_03_22_00_auth.sql','4F184E4BF361195C560A569E57A6FF6429077849','ARCHIVED','2024-03-22 20:29:29',0),
+('2024_03_25_00_auth.sql','B4EF57DE84195E0B886B070ACE58B66853FFC52C','ARCHIVED','2024-03-25 23:20:57',0),
+('2024_03_29_00_auth.sql','F1F62C913F5DFB277DB3D1258022EC334EFC419B','ARCHIVED','2024-03-29 10:49:54',0),
+('2024_04_08_00_auth.sql','B05516DB306A06982206180A2A18407D9E0012DE','ARCHIVED','2024-04-08 21:56:33',0),
+('2024_04_12_00_auth.sql','3D2DCEA21AE5104EF192CACAAFBB5131AD355791','ARCHIVED','2024-04-12 12:07:49',0),
+('2024_04_22_00_auth.sql','83566EA54235D588697D747D8130CD6D37445CC5','ARCHIVED','2024-04-22 23:05:46',0),
+('2024_05_01_00_auth.sql','2A1C2B4E54706BDD1FDD57AFB943058BEE8D8852','ARCHIVED','2024-05-01 21:32:43',0),
+('2024_05_08_00_auth.sql','F2EEE0D225CB82DBB3A478E0BF6A0116C9265355','ARCHIVED','2024-05-08 20:35:53',0),
+('2024_05_10_00_auth.sql','8A6E48012413EA769601A8E4C9F82BEFBE1FCA5C','ARCHIVED','2024-05-10 00:50:46',0),
+('2024_05_11_00_auth.sql','8D703BE97247DBC4A4935EAEA9CB681B0EEFBB3C','ARCHIVED','2024-05-11 03:06:52',0);
 /*!40000 ALTER TABLE `updates` ENABLE KEYS */;
 UNLOCK TABLES;
 
@@ -2969,4 +2970,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 2024-02-08  0:56:27
+-- Dump completed on 2024-05-11  3:06:54
diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql
index 3aa5babc9d9..54948e86426 100644
--- a/sql/base/characters_database.sql
+++ b/sql/base/characters_database.sql
@@ -2,7 +2,7 @@
 --
 -- Host: localhost    Database: characters
 -- ------------------------------------------------------
--- Server version	8.0.36-0ubuntu0.20.04.1
+-- Server version	8.0.36-0ubuntu0.22.04.1
 
 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
 /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
@@ -3738,9 +3738,10 @@ INSERT INTO `updates` VALUES
 ('2023_11_09_00_characters.sql','1A3D7CA6890353DA55793FE8D925CC8C54965A69','ARCHIVED','2023-11-09 00:56:31',0),
 ('2023_11_15_00_characters.sql','441E0F17DE3E3945307AC400DF86FCDF06C61653','ARCHIVED','2023-11-15 00:53:47',0),
 ('2024_02_08_00_characters.sql','743A11042AA17CDBD5F3D510D24509A10838DB5A','ARCHIVED','2024-02-08 00:56:26',0),
-('2024_04_09_00_characters.sql','07AC79B4E489B1CD073852EC57D12939C2A1D4B1','RELEASED','2024-04-09 12:54:11',0),
-('2024_04_12_00_characters.sql','043E023F998DA77170C9D2D0162CAA340290B215','RELEASED','2024-04-12 00:23:51',0),
-('2024_04_28_00_characters.sql','F80F476704BE535B5DCB0BCEBDD56024FCFBBAA2','RELEASED','2024-04-28 19:26:58',0);
+('2024_04_09_00_characters.sql','07AC79B4E489B1CD073852EC57D12939C2A1D4B1','ARCHIVED','2024-04-09 12:54:11',0),
+('2024_04_12_00_characters.sql','043E023F998DA77170C9D2D0162CAA340290B215','ARCHIVED','2024-04-12 00:23:51',0),
+('2024_04_28_00_characters.sql','F80F476704BE535B5DCB0BCEBDD56024FCFBBAA2','ARCHIVED','2024-04-28 19:26:58',0),
+('2024_05_11_00_characters.sql','A65765D87C1BA181561A6517040DC1A3A8103B71','ARCHIVED','2024-05-11 03:06:52',0);
 /*!40000 ALTER TABLE `updates` ENABLE KEYS */;
 UNLOCK TABLES;
 
@@ -3867,4 +3868,4 @@ UNLOCK TABLES;
 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
 
--- Dump completed on 2024-02-08  0:56:28
+-- Dump completed on 2024-05-11  3:06:54
diff --git a/sql/base/dev/hotfixes_database.sql b/sql/base/dev/hotfixes_database.sql
index cf504e9cb3a..90420b08f7b 100644
--- a/sql/base/dev/hotfixes_database.sql
+++ b/sql/base/dev/hotfixes_database.sql
@@ -2,7 +2,7 @@
 --
 -- Host: localhost    Database: hotfixes
 -- ------------------------------------------------------
--- Server version	8.0.36-0ubuntu0.20.04.1
+-- Server version	8.0.36-0ubuntu0.22.04.1
 
 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
 /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
@@ -29,7 +29,7 @@ CREATE TABLE `achievement` (
   `ID` int unsigned NOT NULL DEFAULT '0',
   `InstanceID` smallint NOT NULL DEFAULT '0',
   `Faction` tinyint NOT NULL DEFAULT '0',
-  `Supercedes` smallint NOT NULL DEFAULT '0',
+  `Supercedes` int NOT NULL DEFAULT '0',
   `Category` smallint NOT NULL DEFAULT '0',
   `MinimumCriteria` tinyint NOT NULL DEFAULT '0',
   `Points` tinyint NOT NULL DEFAULT '0',
@@ -40,6 +40,8 @@ CREATE TABLE `achievement` (
   `CriteriaTree` int unsigned NOT NULL DEFAULT '0',
   `SharesCriteria` smallint NOT NULL DEFAULT '0',
   `CovenantID` int NOT NULL DEFAULT '0',
+  `HiddenBeforeDisplaySeason` int NOT NULL DEFAULT '0',
+  `LegacyAfterTimeEvent` int NOT NULL DEFAULT '0',
   `VerifiedBuild` int NOT NULL DEFAULT '0',
   PRIMARY KEY (`ID`,`VerifiedBuild`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@@ -142,8 +144,6 @@ CREATE TABLE `adventure_journal` (
   `BattleMasterListID` smallint unsigned NOT NULL DEFAULT '0',
   `PriorityMin` tinyint unsigned NOT NULL DEFAULT '0',
   `PriorityMax` tinyint unsigned NOT NULL DEFAULT '0',
-  `ItemID` int NOT NULL DEFAULT '0',
-  `ItemQuantity` int unsigned NOT NULL DEFAULT '0',
   `CurrencyType` smallint unsigned NOT NULL DEFAULT '0',
   `CurrencyQuantity` int unsigned NOT NULL DEFAULT '0',
   `UiMapID` smallint unsigned NOT NULL DEFAULT '0',
@@ -1501,6 +1501,23 @@ CREATE TABLE `challenge_mode_item_bonus_override` (
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
+-- Table structure for table `char_base_info`
+--
+
+DROP TABLE IF EXISTS `char_base_info`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!50503 SET character_set_client = utf8mb4 */;
+CREATE TABLE `char_base_info` (
+  `ID` int unsigned NOT NULL DEFAULT '0',
+  `RaceID` tinyint NOT NULL DEFAULT '0',
+  `ClassID` tinyint NOT NULL DEFAULT '0',
+  `OtherFactionRaceID` 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 `char_titles`
 --
 
@@ -2277,6 +2294,8 @@ CREATE TABLE `content_tuning` (
   `ID` int unsigned NOT NULL DEFAULT '0',
   `Flags` int NOT NULL DEFAULT '0',
   `ExpansionID` int NOT NULL DEFAULT '0',
+  `HealthItemLevelCurveID` int NOT NULL DEFAULT '0',
+  `DamageItemLevelCurveID` int NOT NULL DEFAULT '0',
   `MinLevel` int NOT NULL DEFAULT '0',
   `MaxLevel` int NOT NULL DEFAULT '0',
   `MinLevelType` int NOT NULL DEFAULT '0',
@@ -5061,6 +5080,7 @@ CREATE TABLE `item_modified_appearance` (
   `ItemAppearanceID` int NOT NULL DEFAULT '0',
   `OrderIndex` int NOT NULL DEFAULT '0',
   `TransmogSourceTypeEnum` tinyint unsigned NOT NULL DEFAULT '0',
+  `Flags` int NOT NULL DEFAULT '0',
   `VerifiedBuild` int NOT NULL DEFAULT '0',
   PRIMARY KEY (`ID`,`VerifiedBuild`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@@ -7015,7 +7035,7 @@ DROP TABLE IF EXISTS `pvp_stat`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `pvp_stat` (
-  `Description` text COLLATE utf8mb4_unicode_ci,
+  `Description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
   `ID` int unsigned NOT NULL DEFAULT '0',
   `MapID` int NOT NULL DEFAULT '0',
   `VerifiedBuild` int NOT NULL DEFAULT '0',
@@ -7032,8 +7052,8 @@ DROP TABLE IF EXISTS `pvp_stat_locale`;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `pvp_stat_locale` (
   `ID` int unsigned NOT NULL DEFAULT '0',
-  `locale` varchar(4) COLLATE utf8mb4_unicode_ci NOT NULL,
-  `Description_lang` text COLLATE utf8mb4_unicode_ci,
+  `locale` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
+  `Description_lang` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
   `VerifiedBuild` int NOT NULL DEFAULT '0',
   PRIMARY KEY (`ID`,`locale`,`VerifiedBuild`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
@@ -8231,6 +8251,39 @@ CREATE TABLE `spell_effect` (
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
+-- Table structure for table `spell_empower`
+--
+
+DROP TABLE IF EXISTS `spell_empower`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!50503 SET character_set_client = utf8mb4 */;
+CREATE TABLE `spell_empower` (
+  `ID` int unsigned NOT NULL DEFAULT '0',
+  `SpellID` int NOT NULL DEFAULT '0',
+  `Unused1000` 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 `spell_empower_stage`
+--
+
+DROP TABLE IF EXISTS `spell_empower_stage`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!50503 SET character_set_client = utf8mb4 */;
+CREATE TABLE `spell_empower_stage` (
+  `ID` int unsigned NOT NULL DEFAULT '0',
+  `Stage` int NOT NULL DEFAULT '0',
+  `DurationMs` int NOT NULL DEFAULT '0',
+  `SpellEmpowerID` int unsigned 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 `spell_equipped_items`
 --
 
@@ -10472,6 +10525,57 @@ CREATE TABLE `vehicle_seat` (
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
+-- Table structure for table `vignette`
+--
+
+DROP TABLE IF EXISTS `vignette`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!50503 SET character_set_client = utf8mb4 */;
+CREATE TABLE `vignette` (
+  `ID` int unsigned NOT NULL DEFAULT '0',
+  `Name` text COLLATE utf8mb4_unicode_ci,
+  `PlayerConditionID` int unsigned NOT NULL DEFAULT '0',
+  `VisibleTrackingQuestID` int unsigned NOT NULL DEFAULT '0',
+  `QuestFeedbackEffectID` int unsigned NOT NULL DEFAULT '0',
+  `Flags` int NOT NULL DEFAULT '0',
+  `MaxHeight` float NOT NULL DEFAULT '0',
+  `MinHeight` float NOT NULL DEFAULT '0',
+  `VignetteType` tinyint NOT NULL DEFAULT '0',
+  `RewardQuestID` int NOT NULL DEFAULT '0',
+  `UiWidgetSetID` 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 `vignette_locale`
+--
+
+DROP TABLE IF EXISTS `vignette_locale`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!50503 SET character_set_client = utf8mb4 */;
+CREATE TABLE `vignette_locale` (
+  `ID` int unsigned NOT NULL DEFAULT '0',
+  `locale` varchar(4) COLLATE utf8mb4_unicode_ci NOT NULL,
+  `Name_lang` text COLLATE utf8mb4_unicode_ci,
+  `VerifiedBuild` int NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`,`locale`,`VerifiedBuild`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
+/*!50500 PARTITION BY LIST  COLUMNS(locale)
+(PARTITION deDE VALUES IN ('deDE') ENGINE = InnoDB,
+ PARTITION esES VALUES IN ('esES') ENGINE = InnoDB,
+ PARTITION esMX VALUES IN ('esMX') ENGINE = InnoDB,
+ PARTITION frFR VALUES IN ('frFR') ENGINE = InnoDB,
+ PARTITION itIT VALUES IN ('itIT') ENGINE = InnoDB,
+ PARTITION koKR VALUES IN ('koKR') ENGINE = InnoDB,
+ PARTITION ptBR VALUES IN ('ptBR') ENGINE = InnoDB,
+ PARTITION ruRU VALUES IN ('ruRU') ENGINE = InnoDB,
+ PARTITION zhCN VALUES IN ('zhCN') ENGINE = InnoDB,
+ PARTITION zhTW VALUES IN ('zhTW') ENGINE = InnoDB) */;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
 -- Table structure for table `wmo_area_table`
 --
 
@@ -10603,4 +10707,4 @@ CREATE TABLE `world_state_expression` (
 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
 
--- Dump completed on 2024-02-08  0:56:32
+-- Dump completed on 2024-05-11  3:06:58
diff --git a/sql/base/dev/world_database.sql b/sql/base/dev/world_database.sql
index 3a995f20763..14d9b29da71 100644
--- a/sql/base/dev/world_database.sql
+++ b/sql/base/dev/world_database.sql
@@ -2,7 +2,7 @@
 --
 -- Host: localhost    Database: world
 -- ------------------------------------------------------
--- Server version	8.0.36-0ubuntu0.20.04.1
+-- Server version	8.0.36-0ubuntu0.22.04.1
 
 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
 /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
@@ -368,6 +368,21 @@ CREATE TABLE `battlefield_template` (
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
+-- Table structure for table `battleground_scripts`
+--
+
+DROP TABLE IF EXISTS `battleground_scripts`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!50503 SET character_set_client = utf8mb4 */;
+CREATE TABLE `battleground_scripts` (
+  `MapId` int NOT NULL,
+  `BattlemasterListId` int NOT NULL DEFAULT '0',
+  `ScriptName` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
+  PRIMARY KEY (`MapId`,`BattlemasterListId`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
 -- Table structure for table `battleground_template`
 --
 
@@ -593,8 +608,7 @@ CREATE TABLE `creature` (
   `spawntimesecs` int unsigned NOT NULL DEFAULT '120',
   `wander_distance` float NOT NULL DEFAULT '0',
   `currentwaypoint` int unsigned NOT NULL DEFAULT '0',
-  `curhealth` int unsigned NOT NULL DEFAULT '1',
-  `curmana` int unsigned NOT NULL DEFAULT '0',
+  `curHealthPct` int unsigned NOT NULL DEFAULT '100',
   `MovementType` tinyint unsigned NOT NULL DEFAULT '0',
   `npcflag` bigint unsigned DEFAULT NULL,
   `unit_flags` int unsigned DEFAULT NULL,
@@ -781,10 +795,7 @@ 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 DEFAULT NULL,
-  `Swim` tinyint unsigned DEFAULT NULL,
-  `Flight` tinyint unsigned DEFAULT NULL,
-  `Rooted` tinyint unsigned DEFAULT NULL,
+  `HoverInitiallyEnabled` 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',
@@ -877,6 +888,28 @@ CREATE TABLE `creature_queststarter` (
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
+-- Table structure for table `creature_static_flags_override`
+--
+
+DROP TABLE IF EXISTS `creature_static_flags_override`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!50503 SET character_set_client = utf8mb4 */;
+CREATE TABLE `creature_static_flags_override` (
+  `SpawnId` bigint unsigned NOT NULL,
+  `DifficultyId` tinyint unsigned NOT NULL DEFAULT '0',
+  `StaticFlags1` int unsigned DEFAULT NULL,
+  `StaticFlags2` int unsigned DEFAULT NULL,
+  `StaticFlags3` int unsigned DEFAULT NULL,
+  `StaticFlags4` int unsigned DEFAULT NULL,
+  `StaticFlags5` int unsigned DEFAULT NULL,
+  `StaticFlags6` int unsigned DEFAULT NULL,
+  `StaticFlags7` int unsigned DEFAULT NULL,
+  `StaticFlags8` int unsigned DEFAULT NULL,
+  PRIMARY KEY (`SpawnId`,`DifficultyId`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
 -- Table structure for table `creature_summon_groups`
 --
 
@@ -1096,10 +1129,7 @@ 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 DEFAULT NULL,
-  `Swim` tinyint unsigned DEFAULT NULL,
-  `Flight` tinyint unsigned DEFAULT NULL,
-  `Rooted` tinyint unsigned DEFAULT NULL,
+  `HoverInitiallyEnabled` 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',
@@ -1230,6 +1260,21 @@ CREATE TABLE `criteria_data` (
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
+-- Table structure for table `destructible_hitpoint`
+--
+
+DROP TABLE IF EXISTS `destructible_hitpoint`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!50503 SET character_set_client = utf8mb4 */;
+CREATE TABLE `destructible_hitpoint` (
+  `Id` int unsigned NOT NULL,
+  `IntactNumHits` int unsigned NOT NULL,
+  `DamagedNumHits` int unsigned NOT NULL,
+  PRIMARY KEY (`Id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='This table contains data about destructible building health';
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
 -- Table structure for table `disables`
 --
 
@@ -1583,7 +1628,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 AUTO_INCREMENT=2151 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Tele Command';
+) ENGINE=InnoDB AUTO_INCREMENT=2167 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Tele Command';
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -4073,11 +4118,13 @@ CREATE TABLE `smart_scripts` (
   `action_param5` int unsigned NOT NULL DEFAULT '0',
   `action_param6` int unsigned NOT NULL DEFAULT '0',
   `action_param7` int unsigned NOT NULL DEFAULT '0',
+  `action_param_string` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
   `target_type` tinyint unsigned NOT NULL DEFAULT '0',
   `target_param1` int unsigned NOT NULL DEFAULT '0',
   `target_param2` int unsigned NOT NULL DEFAULT '0',
   `target_param3` int unsigned NOT NULL DEFAULT '0',
   `target_param4` int unsigned NOT NULL DEFAULT '0',
+  `target_param_string` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
   `target_x` float NOT NULL DEFAULT '0',
   `target_y` float NOT NULL DEFAULT '0',
   `target_z` float NOT NULL DEFAULT '0',
@@ -4758,6 +4805,7 @@ CREATE TABLE `waypoint_path` (
   `PathId` int unsigned NOT NULL,
   `MoveType` tinyint unsigned NOT NULL DEFAULT '0',
   `Flags` tinyint unsigned NOT NULL DEFAULT '0',
+  `Velocity` float DEFAULT NULL,
   `Comment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
   PRIMARY KEY (`PathId`) USING BTREE
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
@@ -4886,4 +4934,4 @@ CREATE TABLE `world_state` (
 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
 
--- Dump completed on 2024-02-08  0:56:29
+-- Dump completed on 2024-05-11  3:06:56