diff options
Diffstat (limited to 'sql/base/dev/hotfixes_database.sql')
| -rw-r--r-- | sql/base/dev/hotfixes_database.sql | 38 |
1 files changed, 19 insertions, 19 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 |