diff options
| author | TDB Release <tdb-release@build.bot> | 2024-09-23 22:53:02 +0000 |
|---|---|---|
| committer | TDB Release <tdb-release@build.bot> | 2024-09-23 22:53:02 +0000 |
| commit | acf1ec4e2fe7118e5f1727dfc7b26bc9b68536bc (patch) | |
| tree | d1b13e6268e5b70b98b50476bfe07352dd2e6722 /sql/base/dev/hotfixes_database.sql | |
| parent | 0ab591058da82b571685dff5043851e0b900d283 (diff) | |
TDB 1102.24092 - 2024/09/23TDB1102.24092
Diffstat (limited to 'sql/base/dev/hotfixes_database.sql')
| -rw-r--r-- | sql/base/dev/hotfixes_database.sql | 14 |
1 files changed, 7 insertions, 7 deletions
diff --git a/sql/base/dev/hotfixes_database.sql b/sql/base/dev/hotfixes_database.sql index 5b32be0a424..0e424df11e3 100644 --- a/sql/base/dev/hotfixes_database.sql +++ b/sql/base/dev/hotfixes_database.sql @@ -4672,7 +4672,7 @@ DROP TABLE IF EXISTS `item_bonus_tree_node`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `item_bonus_tree_node` ( `ID` int unsigned NOT NULL DEFAULT '0', - `ItemContext` tinyint unsigned NOT NULL DEFAULT '0', + `ItemContext` tinyint NOT NULL DEFAULT '0', `ChildItemBonusTreeID` smallint unsigned NOT NULL DEFAULT '0', `ChildItemBonusListID` smallint unsigned NOT NULL DEFAULT '0', `ChildItemLevelSelectorID` smallint unsigned NOT NULL DEFAULT '0', @@ -9919,8 +9919,8 @@ DROP TABLE IF EXISTS `trait_sub_tree`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `trait_sub_tree` ( - `Name` text COLLATE utf8mb4_unicode_ci, - `Description` text COLLATE utf8mb4_unicode_ci, + `Name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + `Description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `ID` int unsigned NOT NULL DEFAULT '0', `UiTextureAtlasElementID` int NOT NULL DEFAULT '0', `TraitTreeID` int NOT NULL DEFAULT '0', @@ -9938,9 +9938,9 @@ DROP TABLE IF EXISTS `trait_sub_tree_locale`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `trait_sub_tree_locale` ( `ID` int unsigned NOT NULL DEFAULT '0', - `locale` varchar(4) COLLATE utf8mb4_unicode_ci NOT NULL, - `Name_lang` text COLLATE utf8mb4_unicode_ci, - `Description_lang` text COLLATE utf8mb4_unicode_ci, + `locale` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, + `Name_lang` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + `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 @@ -10864,4 +10864,4 @@ CREATE TABLE `world_state_expression` ( /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2024-09-03 0:47:48 +-- Dump completed on 2024-09-23 22:48:16 |