aboutsummaryrefslogtreecommitdiff
path: root/sql/base/dev
diff options
context:
space:
mode:
Diffstat (limited to 'sql/base/dev')
-rw-r--r--sql/base/dev/hotfixes_database.sql38
-rw-r--r--sql/base/dev/world_database.sql25
2 files changed, 36 insertions, 27 deletions
diff --git a/sql/base/dev/hotfixes_database.sql b/sql/base/dev/hotfixes_database.sql
index b954c2154a1..d9b81296107 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.31, for Linux (x86_64)
+-- MySQL dump 10.13 Distrib 8.0.32, for Linux (x86_64)
--
-- Host: localhost Database: hotfixes
-- ------------------------------------------------------
--- Server version 8.0.31-0ubuntu0.20.04.2
+-- Server version 8.0.32-0ubuntu0.20.04.2
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
@@ -1821,8 +1821,8 @@ DROP TABLE IF EXISTS `chr_customization_req_locale`;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `chr_customization_req_locale` (
`ID` int unsigned NOT NULL DEFAULT '0',
- `locale` varchar(4) COLLATE utf8mb4_unicode_ci NOT NULL,
- `ReqSource_lang` text COLLATE utf8mb4_unicode_ci,
+ `locale` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
+ `ReqSource_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
@@ -7404,9 +7404,9 @@ DROP TABLE IF EXISTS `skill_line_ability_locale`;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `skill_line_ability_locale` (
`ID` int unsigned NOT NULL DEFAULT '0',
- `locale` varchar(4) COLLATE utf8mb4_unicode_ci NOT NULL,
- `AbilityVerb_lang` text COLLATE utf8mb4_unicode_ci,
- `AbilityAllVerb_lang` text COLLATE utf8mb4_unicode_ci,
+ `locale` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
+ `AbilityVerb_lang` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+ `AbilityAllVerb_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
@@ -9022,7 +9022,7 @@ DROP TABLE IF EXISTS `trait_cost`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `trait_cost` (
- `InternalName` text COLLATE utf8mb4_unicode_ci,
+ `InternalName` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`ID` int unsigned NOT NULL DEFAULT '0',
`Amount` int NOT NULL DEFAULT '0',
`TraitCurrencyID` int NOT NULL DEFAULT '0',
@@ -9057,7 +9057,7 @@ DROP TABLE IF EXISTS `trait_currency_source`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `trait_currency_source` (
- `Requirement` text COLLATE utf8mb4_unicode_ci,
+ `Requirement` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`ID` int unsigned NOT NULL DEFAULT '0',
`TraitCurrencyID` int NOT NULL DEFAULT '0',
`Amount` int NOT NULL DEFAULT '0',
@@ -9080,8 +9080,8 @@ DROP TABLE IF EXISTS `trait_currency_source_locale`;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `trait_currency_source_locale` (
`ID` int unsigned NOT NULL DEFAULT '0',
- `locale` varchar(4) COLLATE utf8mb4_unicode_ci NOT NULL,
- `Requirement_lang` text COLLATE utf8mb4_unicode_ci,
+ `locale` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
+ `Requirement_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
@@ -9106,9 +9106,9 @@ DROP TABLE IF EXISTS `trait_definition`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `trait_definition` (
- `OverrideName` text COLLATE utf8mb4_unicode_ci,
- `OverrideSubtext` text COLLATE utf8mb4_unicode_ci,
- `OverrideDescription` text COLLATE utf8mb4_unicode_ci,
+ `OverrideName` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+ `OverrideSubtext` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+ `OverrideDescription` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`ID` int unsigned NOT NULL DEFAULT '0',
`SpellID` int NOT NULL DEFAULT '0',
`OverrideIcon` int NOT NULL DEFAULT '0',
@@ -9146,10 +9146,10 @@ DROP TABLE IF EXISTS `trait_definition_locale`;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `trait_definition_locale` (
`ID` int unsigned NOT NULL DEFAULT '0',
- `locale` varchar(4) COLLATE utf8mb4_unicode_ci NOT NULL,
- `OverrideName_lang` text COLLATE utf8mb4_unicode_ci,
- `OverrideSubtext_lang` text COLLATE utf8mb4_unicode_ci,
- `OverrideDescription_lang` text COLLATE utf8mb4_unicode_ci,
+ `locale` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
+ `OverrideName_lang` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+ `OverrideSubtext_lang` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+ `OverrideDescription_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
@@ -10219,4 +10219,4 @@ CREATE TABLE `world_state_expression` (
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
--- Dump completed on 2022-12-20 3:10:19
+-- Dump completed on 2023-02-03 1:14:00
diff --git a/sql/base/dev/world_database.sql b/sql/base/dev/world_database.sql
index 5b676a10ed4..361c4710a4d 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.31, for Linux (x86_64)
+-- MySQL dump 10.13 Distrib 8.0.32, for Linux (x86_64)
--
-- Host: localhost Database: world
-- ------------------------------------------------------
--- Server version 8.0.31-0ubuntu0.20.04.2
+-- Server version 8.0.32-0ubuntu0.20.04.2
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
@@ -608,6 +608,7 @@ CREATE TABLE `creature` (
`unit_flags3` int unsigned NOT NULL DEFAULT '0',
`dynamicflags` int unsigned NOT NULL DEFAULT '0',
`ScriptName` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
+ `StringId` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`VerifiedBuild` int NOT NULL DEFAULT '0',
PRIMARY KEY (`guid`),
KEY `idx_map` (`map`),
@@ -627,8 +628,11 @@ CREATE TABLE `creature_addon` (
`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',
+ `StandState` tinyint unsigned NOT NULL DEFAULT '0',
+ `AnimTier` tinyint unsigned NOT NULL DEFAULT '0',
+ `VisFlags` tinyint unsigned NOT NULL DEFAULT '0',
+ `SheathState` tinyint unsigned NOT NULL DEFAULT '1',
+ `PvPFlags` tinyint unsigned NOT NULL DEFAULT '0',
`emote` int unsigned NOT NULL DEFAULT '0',
`aiAnimKit` smallint NOT NULL DEFAULT '0',
`movementAnimKit` smallint NOT NULL DEFAULT '0',
@@ -952,6 +956,7 @@ CREATE TABLE `creature_template` (
`spell_school_immune_mask` int unsigned NOT NULL DEFAULT '0',
`flags_extra` int unsigned NOT NULL DEFAULT '0',
`ScriptName` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
+ `StringId` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`VerifiedBuild` int NOT NULL DEFAULT '0',
PRIMARY KEY (`entry`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Creature System';
@@ -969,8 +974,11 @@ CREATE TABLE `creature_template_addon` (
`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',
+ `StandState` tinyint unsigned NOT NULL DEFAULT '0',
+ `AnimTier` tinyint unsigned NOT NULL DEFAULT '0',
+ `VisFlags` tinyint unsigned NOT NULL DEFAULT '0',
+ `SheathState` tinyint unsigned NOT NULL DEFAULT '1',
+ `PvPFlags` tinyint unsigned NOT NULL DEFAULT '0',
`emote` int unsigned NOT NULL DEFAULT '0',
`aiAnimKit` smallint NOT NULL DEFAULT '0',
`movementAnimKit` smallint NOT NULL DEFAULT '0',
@@ -1518,7 +1526,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=1951 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Tele Command';
+) ENGINE=InnoDB AUTO_INCREMENT=1965 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Tele Command';
/*!40101 SET character_set_client = @saved_cs_client */;
--
@@ -4021,6 +4029,7 @@ CREATE TABLE `smart_scripts` (
`action_param4` int unsigned NOT NULL DEFAULT '0',
`action_param5` int unsigned NOT NULL DEFAULT '0',
`action_param6` int unsigned NOT NULL DEFAULT '0',
+ `action_param7` int unsigned NOT NULL DEFAULT '0',
`target_type` tinyint unsigned NOT NULL DEFAULT '0',
`target_param1` int unsigned NOT NULL DEFAULT '0',
`target_param2` int unsigned NOT NULL DEFAULT '0',
@@ -4865,4 +4874,4 @@ CREATE TABLE `world_state` (
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
--- Dump completed on 2022-12-20 3:10:14
+-- Dump completed on 2023-02-03 1:13:57