diff options
Diffstat (limited to 'sql')
-rw-r--r-- | sql/base/auth_database.sql | 13 | ||||
-rw-r--r-- | sql/base/characters_database.sql | 5 | ||||
-rw-r--r-- | sql/base/dev/hotfixes_database.sql | 14 | ||||
-rw-r--r-- | sql/base/dev/world_database.sql | 2 | ||||
-rw-r--r-- | sql/old/11.x/auth/24091_2024_09_23/2024_09_03_00_auth.sql (renamed from sql/updates/auth/master/2024_09_03_00_auth.sql) | 0 | ||||
-rw-r--r-- | sql/old/11.x/auth/24091_2024_09_23/2024_09_05_00_auth.sql (renamed from sql/updates/auth/master/2024_09_05_00_auth.sql) | 0 | ||||
-rw-r--r-- | sql/old/11.x/auth/24091_2024_09_23/2024_09_05_01_auth.sql (renamed from sql/updates/auth/master/2024_09_05_01_auth.sql) | 0 | ||||
-rw-r--r-- | sql/old/11.x/auth/24091_2024_09_23/2024_09_11_00_auth.sql (renamed from sql/updates/auth/master/2024_09_11_00_auth.sql) | 0 | ||||
-rw-r--r-- | sql/old/11.x/auth/24091_2024_09_23/2024_09_18_00_auth.sql (renamed from sql/updates/auth/master/2024_09_18_00_auth.sql) | 0 | ||||
-rw-r--r-- | sql/old/11.x/auth/24091_2024_09_23/2024_09_18_01_auth.sql (renamed from sql/updates/auth/master/2024_09_18_01_auth.sql) | 0 | ||||
-rw-r--r-- | sql/old/11.x/characters/24091_2024_09_23/2024_09_03_00_characters.sql (renamed from sql/updates/characters/master/2024_09_03_00_characters.sql) | 0 | ||||
-rw-r--r-- | sql/old/11.x/hotfixes/24091_2024_09_23/2024_09_03_01_hotfixes.sql (renamed from sql/updates/hotfixes/master/2024_09_03_01_hotfixes.sql) | 0 | ||||
-rw-r--r-- | sql/old/11.x/hotfixes/24091_2024_09_23/2024_09_22_00_hotfixes.sql (renamed from sql/updates/hotfixes/master/2024_09_22_00_hotfixes.sql) | 0 | ||||
-rw-r--r-- | sql/old/11.x/hotfixes/24091_2024_09_23/2024_09_23_00_hotfixes.sql (renamed from sql/updates/hotfixes/master/2024_09_23_00_hotfixes.sql) | 0 | ||||
-rw-r--r-- | sql/old/11.x/hotfixes/24091_2024_09_23/2024_09_23_01_hotfixes_deDE.sql (renamed from sql/updates/hotfixes/master/2024_09_23_01_hotfixes_deDE.sql) | 0 | ||||
-rw-r--r-- | sql/old/11.x/hotfixes/24091_2024_09_23/2024_09_23_02_hotfixes_esES.sql (renamed from sql/updates/hotfixes/master/2024_09_23_02_hotfixes_esES.sql) | 0 | ||||
-rw-r--r-- | sql/old/11.x/hotfixes/24091_2024_09_23/2024_09_23_03_hotfixes_esMX.sql (renamed from sql/updates/hotfixes/master/2024_09_23_03_hotfixes_esMX.sql) | 0 | ||||
-rw-r--r-- | sql/old/11.x/hotfixes/24091_2024_09_23/2024_09_23_04_hotfixes_frFR.sql (renamed from sql/updates/hotfixes/master/2024_09_23_04_hotfixes_frFR.sql) | 0 | ||||
-rw-r--r-- | sql/old/11.x/hotfixes/24091_2024_09_23/2024_09_23_05_hotfixes_itIT.sql (renamed from sql/updates/hotfixes/master/2024_09_23_05_hotfixes_itIT.sql) | 0 | ||||
-rw-r--r-- | sql/old/11.x/hotfixes/24091_2024_09_23/2024_09_23_06_hotfixes_koKR.sql (renamed from sql/updates/hotfixes/master/2024_09_23_06_hotfixes_koKR.sql) | 0 | ||||
-rw-r--r-- | sql/old/11.x/hotfixes/24091_2024_09_23/2024_09_23_07_hotfixes_ptBR.sql (renamed from sql/updates/hotfixes/master/2024_09_23_07_hotfixes_ptBR.sql) | 0 | ||||
-rw-r--r-- | sql/old/11.x/hotfixes/24091_2024_09_23/2024_09_23_08_hotfixes_ruRU.sql (renamed from sql/updates/hotfixes/master/2024_09_23_08_hotfixes_ruRU.sql) | 0 | ||||
-rw-r--r-- | sql/old/11.x/hotfixes/24091_2024_09_23/2024_09_23_09_hotfixes_zhCN.sql (renamed from sql/updates/hotfixes/master/2024_09_23_09_hotfixes_zhCN.sql) | 0 | ||||
-rw-r--r-- | sql/old/11.x/hotfixes/24091_2024_09_23/2024_09_23_10_hotfixes_zhTW.sql (renamed from sql/updates/hotfixes/master/2024_09_23_10_hotfixes_zhTW.sql) | 0 | ||||
-rw-r--r-- | sql/old/11.x/world/24091_2024_09_23/2024_09_03_04_world.sql (renamed from sql/updates/world/master/2024_09_03_04_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/11.x/world/24091_2024_09_23/2024_09_03_05_world.sql (renamed from sql/updates/world/master/2024_09_03_05_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/11.x/world/24091_2024_09_23/2024_09_04_00_world.sql (renamed from sql/updates/world/master/2024_09_04_00_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/11.x/world/24091_2024_09_23/2024_09_04_01_world.sql (renamed from sql/updates/world/master/2024_09_04_01_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/11.x/world/24091_2024_09_23/2024_09_04_02_world.sql (renamed from sql/updates/world/master/2024_09_04_02_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/11.x/world/24091_2024_09_23/2024_09_04_03_world.sql (renamed from sql/updates/world/master/2024_09_04_03_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/11.x/world/24091_2024_09_23/2024_09_06_00_world.sql (renamed from sql/updates/world/master/2024_09_06_00_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/11.x/world/24091_2024_09_23/2024_09_06_01_world.sql (renamed from sql/updates/world/master/2024_09_06_01_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/11.x/world/24091_2024_09_23/2024_09_06_02_world.sql (renamed from sql/updates/world/master/2024_09_06_02_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/11.x/world/24091_2024_09_23/2024_09_06_03_world.sql (renamed from sql/updates/world/master/2024_09_06_03_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/11.x/world/24091_2024_09_23/2024_09_06_04_world.sql (renamed from sql/updates/world/master/2024_09_06_04_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/11.x/world/24091_2024_09_23/2024_09_07_00_world.sql (renamed from sql/updates/world/master/2024_09_07_00_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/11.x/world/24091_2024_09_23/2024_09_07_01_world.sql (renamed from sql/updates/world/master/2024_09_07_01_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/11.x/world/24091_2024_09_23/2024_09_07_02_world.sql (renamed from sql/updates/world/master/2024_09_07_02_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/11.x/world/24091_2024_09_23/2024_09_08_00_world.sql (renamed from sql/updates/world/master/2024_09_08_00_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/11.x/world/24091_2024_09_23/2024_09_08_01_world.sql (renamed from sql/updates/world/master/2024_09_08_01_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/11.x/world/24091_2024_09_23/2024_09_09_00_world.sql (renamed from sql/updates/world/master/2024_09_09_00_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/11.x/world/24091_2024_09_23/2024_09_09_01_world.sql (renamed from sql/updates/world/master/2024_09_09_01_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/11.x/world/24091_2024_09_23/2024_09_09_02_world.sql (renamed from sql/updates/world/master/2024_09_09_02_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/11.x/world/24091_2024_09_23/2024_09_10_00_world.sql (renamed from sql/updates/world/master/2024_09_10_00_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/11.x/world/24091_2024_09_23/2024_09_12_00_world.sql (renamed from sql/updates/world/master/2024_09_12_00_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/11.x/world/24091_2024_09_23/2024_09_12_01_world.sql (renamed from sql/updates/world/master/2024_09_12_01_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/11.x/world/24091_2024_09_23/2024_09_12_02_world.sql (renamed from sql/updates/world/master/2024_09_12_02_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/11.x/world/24091_2024_09_23/2024_09_14_00_world.sql (renamed from sql/updates/world/master/2024_09_14_00_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/11.x/world/24091_2024_09_23/2024_09_14_01_world.sql (renamed from sql/updates/world/master/2024_09_14_01_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/11.x/world/24091_2024_09_23/2024_09_14_02_world.sql (renamed from sql/updates/world/master/2024_09_14_02_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/11.x/world/24091_2024_09_23/2024_09_15_00_world.sql (renamed from sql/updates/world/master/2024_09_15_00_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/11.x/world/24091_2024_09_23/2024_09_15_01_world.sql (renamed from sql/updates/world/master/2024_09_15_01_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/11.x/world/24091_2024_09_23/2024_09_16_00_world.sql (renamed from sql/updates/world/master/2024_09_16_00_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/11.x/world/24091_2024_09_23/2024_09_17_00_world.sql (renamed from sql/updates/world/master/2024_09_17_00_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/11.x/world/24091_2024_09_23/2024_09_17_01_world.sql (renamed from sql/updates/world/master/2024_09_17_01_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/11.x/world/24091_2024_09_23/2024_09_18_00_world.sql (renamed from sql/updates/world/master/2024_09_18_00_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/11.x/world/24091_2024_09_23/2024_09_18_01_world.sql (renamed from sql/updates/world/master/2024_09_18_01_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/11.x/world/24091_2024_09_23/2024_09_20_00_world.sql (renamed from sql/updates/world/master/2024_09_20_00_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/11.x/world/24091_2024_09_23/2024_09_21_00_world.sql (renamed from sql/updates/world/master/2024_09_21_00_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/11.x/world/24091_2024_09_23/2024_09_21_01_world.sql (renamed from sql/updates/world/master/2024_09_21_01_world.sql) | 0 | ||||
-rw-r--r-- | sql/updates/auth/master/2024_09_23_00_auth.sql | 3 | ||||
-rw-r--r-- | sql/updates/characters/master/2024_09_23_00_characters.sql | 3 | ||||
-rw-r--r-- | sql/updates/hotfixes/master/2024_09_23_11_hotfixes.sql | 3 | ||||
-rw-r--r-- | sql/updates/world/master/2024_09_23_00_world.sql | 4 |
64 files changed, 31 insertions, 16 deletions
diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql index e69f4eac84b..c75dbf91a11 100644 --- a/sql/base/auth_database.sql +++ b/sql/base/auth_database.sql @@ -3236,11 +3236,12 @@ INSERT INTO `updates` VALUES ('2024_08_31_00_auth.sql','D10F12D25D526A2C5E12FCEA2DEB55C342879F06','ARCHIVED','2024-08-31 10:32:16',0), ('2024_08_31_01_auth.sql','3ADC34DAE405697983EDDD32D0F3FC6F122CA819','ARCHIVED','2024-09-01 15:48:43',0), ('2024_09_03_00_auth.sql','BF65B550256CA64F0936D98A619E8A2A7E7A9B59','ARCHIVED','2024-09-03 00:47:42',0), -('2024_09_05_00_auth.sql','9CD84EB94AE50F14A392C216E7CA7BA33E92376E','RELEASED','2024-09-05 13:38:34',0), -('2024_09_05_01_auth.sql','42D5E703382C57C4ADD862CF215F1166625100E5','RELEASED','2024-09-05 23:42:10',0), -('2024_09_11_00_auth.sql','8B810B5EB20D769A50A2D01411BBD065732E4EE6','RELEASED','2024-09-11 12:23:18',0), -('2024_09_18_00_auth.sql','073B6E954B585CD81BFADD58CDAD166E85D2653A','RELEASED','2024-09-18 10:26:42',0), -('2024_09_18_01_auth.sql','6AE1437E24D4837EB2347ADAA80A4093CA9F6D67','RELEASED','2024-09-18 21:30:31',0); +('2024_09_05_00_auth.sql','9CD84EB94AE50F14A392C216E7CA7BA33E92376E','ARCHIVED','2024-09-05 13:38:34',0), +('2024_09_05_01_auth.sql','42D5E703382C57C4ADD862CF215F1166625100E5','ARCHIVED','2024-09-05 23:42:10',0), +('2024_09_11_00_auth.sql','8B810B5EB20D769A50A2D01411BBD065732E4EE6','ARCHIVED','2024-09-11 12:23:18',0), +('2024_09_18_00_auth.sql','073B6E954B585CD81BFADD58CDAD166E85D2653A','ARCHIVED','2024-09-18 10:26:42',0), +('2024_09_18_01_auth.sql','6AE1437E24D4837EB2347ADAA80A4093CA9F6D67','ARCHIVED','2024-09-18 21:30:31',0), +('2024_09_23_00_auth.sql','CBAB00B40360D8942AD1E4EDBE0F0097F3F6FC9B','ARCHIVED','2024-09-23 22:48:10',0); /*!40000 ALTER TABLE `updates` ENABLE KEYS */; UNLOCK TABLES; @@ -3384,4 +3385,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-09-03 0:47:44 +-- Dump completed on 2024-09-23 22:48:12 diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql index 556f50eb348..5a01bb9d82d 100644 --- a/sql/base/characters_database.sql +++ b/sql/base/characters_database.sql @@ -3747,7 +3747,8 @@ INSERT INTO `updates` VALUES ('2024_08_04_00_characters.sql','7D153C59998416E6EA1455086730A2321AD0F2A8','ARCHIVED','2024-08-04 17:58:59',0), ('2024_08_05_00_characters.sql','7E4AE28F9EC370A1B22DBD8DD718EE027A321F33','ARCHIVED','2024-08-05 11:19:40',0), ('2024_08_26_00_characters.sql','68EEBE1D639D59B24F5121008C2D103CA67FFC9A','ARCHIVED','2024-08-26 00:49:08',0), -('2024_09_03_00_characters.sql','71ECC73A3F324EB64DA19B0CC4DF72A85E022BDC','ARCHIVED','2024-09-03 00:47:42',0); +('2024_09_03_00_characters.sql','71ECC73A3F324EB64DA19B0CC4DF72A85E022BDC','ARCHIVED','2024-09-03 00:47:42',0), +('2024_09_23_00_characters.sql','D8491BCEE728F40D55D47E3A4BC5A5F083EBD02E','ARCHIVED','2024-09-23 22:48:10',0); /*!40000 ALTER TABLE `updates` ENABLE KEYS */; UNLOCK TABLES; @@ -3875,4 +3876,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2024-09-03 0:47:44 +-- Dump completed on 2024-09-23 22:48:12 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 diff --git a/sql/base/dev/world_database.sql b/sql/base/dev/world_database.sql index 7793ce17634..e35107b5ea3 100644 --- a/sql/base/dev/world_database.sql +++ b/sql/base/dev/world_database.sql @@ -4983,4 +4983,4 @@ CREATE TABLE `world_state` ( /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2024-09-03 0:47:46 +-- Dump completed on 2024-09-23 22:48:14 diff --git a/sql/updates/auth/master/2024_09_03_00_auth.sql b/sql/old/11.x/auth/24091_2024_09_23/2024_09_03_00_auth.sql index f953e7436c4..f953e7436c4 100644 --- a/sql/updates/auth/master/2024_09_03_00_auth.sql +++ b/sql/old/11.x/auth/24091_2024_09_23/2024_09_03_00_auth.sql diff --git a/sql/updates/auth/master/2024_09_05_00_auth.sql b/sql/old/11.x/auth/24091_2024_09_23/2024_09_05_00_auth.sql index 5008d467ab1..5008d467ab1 100644 --- a/sql/updates/auth/master/2024_09_05_00_auth.sql +++ b/sql/old/11.x/auth/24091_2024_09_23/2024_09_05_00_auth.sql diff --git a/sql/updates/auth/master/2024_09_05_01_auth.sql b/sql/old/11.x/auth/24091_2024_09_23/2024_09_05_01_auth.sql index d8db68e7325..d8db68e7325 100644 --- a/sql/updates/auth/master/2024_09_05_01_auth.sql +++ b/sql/old/11.x/auth/24091_2024_09_23/2024_09_05_01_auth.sql diff --git a/sql/updates/auth/master/2024_09_11_00_auth.sql b/sql/old/11.x/auth/24091_2024_09_23/2024_09_11_00_auth.sql index c69af833d34..c69af833d34 100644 --- a/sql/updates/auth/master/2024_09_11_00_auth.sql +++ b/sql/old/11.x/auth/24091_2024_09_23/2024_09_11_00_auth.sql diff --git a/sql/updates/auth/master/2024_09_18_00_auth.sql b/sql/old/11.x/auth/24091_2024_09_23/2024_09_18_00_auth.sql index 951d4b5ccc1..951d4b5ccc1 100644 --- a/sql/updates/auth/master/2024_09_18_00_auth.sql +++ b/sql/old/11.x/auth/24091_2024_09_23/2024_09_18_00_auth.sql diff --git a/sql/updates/auth/master/2024_09_18_01_auth.sql b/sql/old/11.x/auth/24091_2024_09_23/2024_09_18_01_auth.sql index 4df91310654..4df91310654 100644 --- a/sql/updates/auth/master/2024_09_18_01_auth.sql +++ b/sql/old/11.x/auth/24091_2024_09_23/2024_09_18_01_auth.sql diff --git a/sql/updates/characters/master/2024_09_03_00_characters.sql b/sql/old/11.x/characters/24091_2024_09_23/2024_09_03_00_characters.sql index 223b65274d7..223b65274d7 100644 --- a/sql/updates/characters/master/2024_09_03_00_characters.sql +++ b/sql/old/11.x/characters/24091_2024_09_23/2024_09_03_00_characters.sql diff --git a/sql/updates/hotfixes/master/2024_09_03_01_hotfixes.sql b/sql/old/11.x/hotfixes/24091_2024_09_23/2024_09_03_01_hotfixes.sql index cb40afc53e6..cb40afc53e6 100644 --- a/sql/updates/hotfixes/master/2024_09_03_01_hotfixes.sql +++ b/sql/old/11.x/hotfixes/24091_2024_09_23/2024_09_03_01_hotfixes.sql diff --git a/sql/updates/hotfixes/master/2024_09_22_00_hotfixes.sql b/sql/old/11.x/hotfixes/24091_2024_09_23/2024_09_22_00_hotfixes.sql index ed0eb609975..ed0eb609975 100644 --- a/sql/updates/hotfixes/master/2024_09_22_00_hotfixes.sql +++ b/sql/old/11.x/hotfixes/24091_2024_09_23/2024_09_22_00_hotfixes.sql diff --git a/sql/updates/hotfixes/master/2024_09_23_00_hotfixes.sql b/sql/old/11.x/hotfixes/24091_2024_09_23/2024_09_23_00_hotfixes.sql index df4f2746472..df4f2746472 100644 --- a/sql/updates/hotfixes/master/2024_09_23_00_hotfixes.sql +++ b/sql/old/11.x/hotfixes/24091_2024_09_23/2024_09_23_00_hotfixes.sql diff --git a/sql/updates/hotfixes/master/2024_09_23_01_hotfixes_deDE.sql b/sql/old/11.x/hotfixes/24091_2024_09_23/2024_09_23_01_hotfixes_deDE.sql index ba9f4e1bce4..ba9f4e1bce4 100644 --- a/sql/updates/hotfixes/master/2024_09_23_01_hotfixes_deDE.sql +++ b/sql/old/11.x/hotfixes/24091_2024_09_23/2024_09_23_01_hotfixes_deDE.sql diff --git a/sql/updates/hotfixes/master/2024_09_23_02_hotfixes_esES.sql b/sql/old/11.x/hotfixes/24091_2024_09_23/2024_09_23_02_hotfixes_esES.sql index 2d138791896..2d138791896 100644 --- a/sql/updates/hotfixes/master/2024_09_23_02_hotfixes_esES.sql +++ b/sql/old/11.x/hotfixes/24091_2024_09_23/2024_09_23_02_hotfixes_esES.sql diff --git a/sql/updates/hotfixes/master/2024_09_23_03_hotfixes_esMX.sql b/sql/old/11.x/hotfixes/24091_2024_09_23/2024_09_23_03_hotfixes_esMX.sql index 3afd4d67e0f..3afd4d67e0f 100644 --- a/sql/updates/hotfixes/master/2024_09_23_03_hotfixes_esMX.sql +++ b/sql/old/11.x/hotfixes/24091_2024_09_23/2024_09_23_03_hotfixes_esMX.sql diff --git a/sql/updates/hotfixes/master/2024_09_23_04_hotfixes_frFR.sql b/sql/old/11.x/hotfixes/24091_2024_09_23/2024_09_23_04_hotfixes_frFR.sql index a3405cf5cd0..a3405cf5cd0 100644 --- a/sql/updates/hotfixes/master/2024_09_23_04_hotfixes_frFR.sql +++ b/sql/old/11.x/hotfixes/24091_2024_09_23/2024_09_23_04_hotfixes_frFR.sql diff --git a/sql/updates/hotfixes/master/2024_09_23_05_hotfixes_itIT.sql b/sql/old/11.x/hotfixes/24091_2024_09_23/2024_09_23_05_hotfixes_itIT.sql index 70fa3954e86..70fa3954e86 100644 --- a/sql/updates/hotfixes/master/2024_09_23_05_hotfixes_itIT.sql +++ b/sql/old/11.x/hotfixes/24091_2024_09_23/2024_09_23_05_hotfixes_itIT.sql diff --git a/sql/updates/hotfixes/master/2024_09_23_06_hotfixes_koKR.sql b/sql/old/11.x/hotfixes/24091_2024_09_23/2024_09_23_06_hotfixes_koKR.sql index ac61cae0780..ac61cae0780 100644 --- a/sql/updates/hotfixes/master/2024_09_23_06_hotfixes_koKR.sql +++ b/sql/old/11.x/hotfixes/24091_2024_09_23/2024_09_23_06_hotfixes_koKR.sql diff --git a/sql/updates/hotfixes/master/2024_09_23_07_hotfixes_ptBR.sql b/sql/old/11.x/hotfixes/24091_2024_09_23/2024_09_23_07_hotfixes_ptBR.sql index a7cbab0b4fa..a7cbab0b4fa 100644 --- a/sql/updates/hotfixes/master/2024_09_23_07_hotfixes_ptBR.sql +++ b/sql/old/11.x/hotfixes/24091_2024_09_23/2024_09_23_07_hotfixes_ptBR.sql diff --git a/sql/updates/hotfixes/master/2024_09_23_08_hotfixes_ruRU.sql b/sql/old/11.x/hotfixes/24091_2024_09_23/2024_09_23_08_hotfixes_ruRU.sql index 3d7e6d3e9ac..3d7e6d3e9ac 100644 --- a/sql/updates/hotfixes/master/2024_09_23_08_hotfixes_ruRU.sql +++ b/sql/old/11.x/hotfixes/24091_2024_09_23/2024_09_23_08_hotfixes_ruRU.sql diff --git a/sql/updates/hotfixes/master/2024_09_23_09_hotfixes_zhCN.sql b/sql/old/11.x/hotfixes/24091_2024_09_23/2024_09_23_09_hotfixes_zhCN.sql index 997366547fb..997366547fb 100644 --- a/sql/updates/hotfixes/master/2024_09_23_09_hotfixes_zhCN.sql +++ b/sql/old/11.x/hotfixes/24091_2024_09_23/2024_09_23_09_hotfixes_zhCN.sql diff --git a/sql/updates/hotfixes/master/2024_09_23_10_hotfixes_zhTW.sql b/sql/old/11.x/hotfixes/24091_2024_09_23/2024_09_23_10_hotfixes_zhTW.sql index 8bef672bcd3..8bef672bcd3 100644 --- a/sql/updates/hotfixes/master/2024_09_23_10_hotfixes_zhTW.sql +++ b/sql/old/11.x/hotfixes/24091_2024_09_23/2024_09_23_10_hotfixes_zhTW.sql diff --git a/sql/updates/world/master/2024_09_03_04_world.sql b/sql/old/11.x/world/24091_2024_09_23/2024_09_03_04_world.sql index 0f5dd34331b..0f5dd34331b 100644 --- a/sql/updates/world/master/2024_09_03_04_world.sql +++ b/sql/old/11.x/world/24091_2024_09_23/2024_09_03_04_world.sql diff --git a/sql/updates/world/master/2024_09_03_05_world.sql b/sql/old/11.x/world/24091_2024_09_23/2024_09_03_05_world.sql index 879fe147c03..879fe147c03 100644 --- a/sql/updates/world/master/2024_09_03_05_world.sql +++ b/sql/old/11.x/world/24091_2024_09_23/2024_09_03_05_world.sql diff --git a/sql/updates/world/master/2024_09_04_00_world.sql b/sql/old/11.x/world/24091_2024_09_23/2024_09_04_00_world.sql index 82aa3c1531d..82aa3c1531d 100644 --- a/sql/updates/world/master/2024_09_04_00_world.sql +++ b/sql/old/11.x/world/24091_2024_09_23/2024_09_04_00_world.sql diff --git a/sql/updates/world/master/2024_09_04_01_world.sql b/sql/old/11.x/world/24091_2024_09_23/2024_09_04_01_world.sql index d18f3f9b4fc..d18f3f9b4fc 100644 --- a/sql/updates/world/master/2024_09_04_01_world.sql +++ b/sql/old/11.x/world/24091_2024_09_23/2024_09_04_01_world.sql diff --git a/sql/updates/world/master/2024_09_04_02_world.sql b/sql/old/11.x/world/24091_2024_09_23/2024_09_04_02_world.sql index 0b239db8970..0b239db8970 100644 --- a/sql/updates/world/master/2024_09_04_02_world.sql +++ b/sql/old/11.x/world/24091_2024_09_23/2024_09_04_02_world.sql diff --git a/sql/updates/world/master/2024_09_04_03_world.sql b/sql/old/11.x/world/24091_2024_09_23/2024_09_04_03_world.sql index 6ac9ceca518..6ac9ceca518 100644 --- a/sql/updates/world/master/2024_09_04_03_world.sql +++ b/sql/old/11.x/world/24091_2024_09_23/2024_09_04_03_world.sql diff --git a/sql/updates/world/master/2024_09_06_00_world.sql b/sql/old/11.x/world/24091_2024_09_23/2024_09_06_00_world.sql index b584b1613aa..b584b1613aa 100644 --- a/sql/updates/world/master/2024_09_06_00_world.sql +++ b/sql/old/11.x/world/24091_2024_09_23/2024_09_06_00_world.sql diff --git a/sql/updates/world/master/2024_09_06_01_world.sql b/sql/old/11.x/world/24091_2024_09_23/2024_09_06_01_world.sql index e7fd81506a5..e7fd81506a5 100644 --- a/sql/updates/world/master/2024_09_06_01_world.sql +++ b/sql/old/11.x/world/24091_2024_09_23/2024_09_06_01_world.sql diff --git a/sql/updates/world/master/2024_09_06_02_world.sql b/sql/old/11.x/world/24091_2024_09_23/2024_09_06_02_world.sql index 2e066c40f0f..2e066c40f0f 100644 --- a/sql/updates/world/master/2024_09_06_02_world.sql +++ b/sql/old/11.x/world/24091_2024_09_23/2024_09_06_02_world.sql diff --git a/sql/updates/world/master/2024_09_06_03_world.sql b/sql/old/11.x/world/24091_2024_09_23/2024_09_06_03_world.sql index a7c3517f380..a7c3517f380 100644 --- a/sql/updates/world/master/2024_09_06_03_world.sql +++ b/sql/old/11.x/world/24091_2024_09_23/2024_09_06_03_world.sql diff --git a/sql/updates/world/master/2024_09_06_04_world.sql b/sql/old/11.x/world/24091_2024_09_23/2024_09_06_04_world.sql index eb2ff304cb8..eb2ff304cb8 100644 --- a/sql/updates/world/master/2024_09_06_04_world.sql +++ b/sql/old/11.x/world/24091_2024_09_23/2024_09_06_04_world.sql diff --git a/sql/updates/world/master/2024_09_07_00_world.sql b/sql/old/11.x/world/24091_2024_09_23/2024_09_07_00_world.sql index 026c315dbe1..026c315dbe1 100644 --- a/sql/updates/world/master/2024_09_07_00_world.sql +++ b/sql/old/11.x/world/24091_2024_09_23/2024_09_07_00_world.sql diff --git a/sql/updates/world/master/2024_09_07_01_world.sql b/sql/old/11.x/world/24091_2024_09_23/2024_09_07_01_world.sql index 5008e78a006..5008e78a006 100644 --- a/sql/updates/world/master/2024_09_07_01_world.sql +++ b/sql/old/11.x/world/24091_2024_09_23/2024_09_07_01_world.sql diff --git a/sql/updates/world/master/2024_09_07_02_world.sql b/sql/old/11.x/world/24091_2024_09_23/2024_09_07_02_world.sql index 148156601a2..148156601a2 100644 --- a/sql/updates/world/master/2024_09_07_02_world.sql +++ b/sql/old/11.x/world/24091_2024_09_23/2024_09_07_02_world.sql diff --git a/sql/updates/world/master/2024_09_08_00_world.sql b/sql/old/11.x/world/24091_2024_09_23/2024_09_08_00_world.sql index 9239c5d47f2..9239c5d47f2 100644 --- a/sql/updates/world/master/2024_09_08_00_world.sql +++ b/sql/old/11.x/world/24091_2024_09_23/2024_09_08_00_world.sql diff --git a/sql/updates/world/master/2024_09_08_01_world.sql b/sql/old/11.x/world/24091_2024_09_23/2024_09_08_01_world.sql index c25ee8e25a1..c25ee8e25a1 100644 --- a/sql/updates/world/master/2024_09_08_01_world.sql +++ b/sql/old/11.x/world/24091_2024_09_23/2024_09_08_01_world.sql diff --git a/sql/updates/world/master/2024_09_09_00_world.sql b/sql/old/11.x/world/24091_2024_09_23/2024_09_09_00_world.sql index f98f37bc2d4..f98f37bc2d4 100644 --- a/sql/updates/world/master/2024_09_09_00_world.sql +++ b/sql/old/11.x/world/24091_2024_09_23/2024_09_09_00_world.sql diff --git a/sql/updates/world/master/2024_09_09_01_world.sql b/sql/old/11.x/world/24091_2024_09_23/2024_09_09_01_world.sql index a0c1582f39a..a0c1582f39a 100644 --- a/sql/updates/world/master/2024_09_09_01_world.sql +++ b/sql/old/11.x/world/24091_2024_09_23/2024_09_09_01_world.sql diff --git a/sql/updates/world/master/2024_09_09_02_world.sql b/sql/old/11.x/world/24091_2024_09_23/2024_09_09_02_world.sql index 1bab8e08a71..1bab8e08a71 100644 --- a/sql/updates/world/master/2024_09_09_02_world.sql +++ b/sql/old/11.x/world/24091_2024_09_23/2024_09_09_02_world.sql diff --git a/sql/updates/world/master/2024_09_10_00_world.sql b/sql/old/11.x/world/24091_2024_09_23/2024_09_10_00_world.sql index 8182c8a1a89..8182c8a1a89 100644 --- a/sql/updates/world/master/2024_09_10_00_world.sql +++ b/sql/old/11.x/world/24091_2024_09_23/2024_09_10_00_world.sql diff --git a/sql/updates/world/master/2024_09_12_00_world.sql b/sql/old/11.x/world/24091_2024_09_23/2024_09_12_00_world.sql index 86cb8ed78db..86cb8ed78db 100644 --- a/sql/updates/world/master/2024_09_12_00_world.sql +++ b/sql/old/11.x/world/24091_2024_09_23/2024_09_12_00_world.sql diff --git a/sql/updates/world/master/2024_09_12_01_world.sql b/sql/old/11.x/world/24091_2024_09_23/2024_09_12_01_world.sql index e71947422f7..e71947422f7 100644 --- a/sql/updates/world/master/2024_09_12_01_world.sql +++ b/sql/old/11.x/world/24091_2024_09_23/2024_09_12_01_world.sql diff --git a/sql/updates/world/master/2024_09_12_02_world.sql b/sql/old/11.x/world/24091_2024_09_23/2024_09_12_02_world.sql index abf36df7dcb..abf36df7dcb 100644 --- a/sql/updates/world/master/2024_09_12_02_world.sql +++ b/sql/old/11.x/world/24091_2024_09_23/2024_09_12_02_world.sql diff --git a/sql/updates/world/master/2024_09_14_00_world.sql b/sql/old/11.x/world/24091_2024_09_23/2024_09_14_00_world.sql index fb71f7cdb6e..fb71f7cdb6e 100644 --- a/sql/updates/world/master/2024_09_14_00_world.sql +++ b/sql/old/11.x/world/24091_2024_09_23/2024_09_14_00_world.sql diff --git a/sql/updates/world/master/2024_09_14_01_world.sql b/sql/old/11.x/world/24091_2024_09_23/2024_09_14_01_world.sql index 3d5421a852e..3d5421a852e 100644 --- a/sql/updates/world/master/2024_09_14_01_world.sql +++ b/sql/old/11.x/world/24091_2024_09_23/2024_09_14_01_world.sql diff --git a/sql/updates/world/master/2024_09_14_02_world.sql b/sql/old/11.x/world/24091_2024_09_23/2024_09_14_02_world.sql index 27559419cfd..27559419cfd 100644 --- a/sql/updates/world/master/2024_09_14_02_world.sql +++ b/sql/old/11.x/world/24091_2024_09_23/2024_09_14_02_world.sql diff --git a/sql/updates/world/master/2024_09_15_00_world.sql b/sql/old/11.x/world/24091_2024_09_23/2024_09_15_00_world.sql index 9514593bed0..9514593bed0 100644 --- a/sql/updates/world/master/2024_09_15_00_world.sql +++ b/sql/old/11.x/world/24091_2024_09_23/2024_09_15_00_world.sql diff --git a/sql/updates/world/master/2024_09_15_01_world.sql b/sql/old/11.x/world/24091_2024_09_23/2024_09_15_01_world.sql index f758fce55b3..f758fce55b3 100644 --- a/sql/updates/world/master/2024_09_15_01_world.sql +++ b/sql/old/11.x/world/24091_2024_09_23/2024_09_15_01_world.sql diff --git a/sql/updates/world/master/2024_09_16_00_world.sql b/sql/old/11.x/world/24091_2024_09_23/2024_09_16_00_world.sql index 1b5ed037eec..1b5ed037eec 100644 --- a/sql/updates/world/master/2024_09_16_00_world.sql +++ b/sql/old/11.x/world/24091_2024_09_23/2024_09_16_00_world.sql diff --git a/sql/updates/world/master/2024_09_17_00_world.sql b/sql/old/11.x/world/24091_2024_09_23/2024_09_17_00_world.sql index 68817d38592..68817d38592 100644 --- a/sql/updates/world/master/2024_09_17_00_world.sql +++ b/sql/old/11.x/world/24091_2024_09_23/2024_09_17_00_world.sql diff --git a/sql/updates/world/master/2024_09_17_01_world.sql b/sql/old/11.x/world/24091_2024_09_23/2024_09_17_01_world.sql index e6df25d08bf..e6df25d08bf 100644 --- a/sql/updates/world/master/2024_09_17_01_world.sql +++ b/sql/old/11.x/world/24091_2024_09_23/2024_09_17_01_world.sql diff --git a/sql/updates/world/master/2024_09_18_00_world.sql b/sql/old/11.x/world/24091_2024_09_23/2024_09_18_00_world.sql index d92be32e5f3..d92be32e5f3 100644 --- a/sql/updates/world/master/2024_09_18_00_world.sql +++ b/sql/old/11.x/world/24091_2024_09_23/2024_09_18_00_world.sql diff --git a/sql/updates/world/master/2024_09_18_01_world.sql b/sql/old/11.x/world/24091_2024_09_23/2024_09_18_01_world.sql index bc0602e41e8..bc0602e41e8 100644 --- a/sql/updates/world/master/2024_09_18_01_world.sql +++ b/sql/old/11.x/world/24091_2024_09_23/2024_09_18_01_world.sql diff --git a/sql/updates/world/master/2024_09_20_00_world.sql b/sql/old/11.x/world/24091_2024_09_23/2024_09_20_00_world.sql index ea42cb0b070..ea42cb0b070 100644 --- a/sql/updates/world/master/2024_09_20_00_world.sql +++ b/sql/old/11.x/world/24091_2024_09_23/2024_09_20_00_world.sql diff --git a/sql/updates/world/master/2024_09_21_00_world.sql b/sql/old/11.x/world/24091_2024_09_23/2024_09_21_00_world.sql index 1e6ee1f3b11..1e6ee1f3b11 100644 --- a/sql/updates/world/master/2024_09_21_00_world.sql +++ b/sql/old/11.x/world/24091_2024_09_23/2024_09_21_00_world.sql diff --git a/sql/updates/world/master/2024_09_21_01_world.sql b/sql/old/11.x/world/24091_2024_09_23/2024_09_21_01_world.sql index 8cad2f6a5c4..8cad2f6a5c4 100644 --- a/sql/updates/world/master/2024_09_21_01_world.sql +++ b/sql/old/11.x/world/24091_2024_09_23/2024_09_21_01_world.sql diff --git a/sql/updates/auth/master/2024_09_23_00_auth.sql b/sql/updates/auth/master/2024_09_23_00_auth.sql new file mode 100644 index 00000000000..c4d4e867cdd --- /dev/null +++ b/sql/updates/auth/master/2024_09_23_00_auth.sql @@ -0,0 +1,3 @@ +-- TDB 1102.24092 auth +UPDATE `updates` SET `state`='ARCHIVED',`speed`=0; +REPLACE INTO `updates_include` (`path`, `state`) VALUES ('$/sql/old/11.x/auth', 'ARCHIVED'); diff --git a/sql/updates/characters/master/2024_09_23_00_characters.sql b/sql/updates/characters/master/2024_09_23_00_characters.sql new file mode 100644 index 00000000000..b385b929e1b --- /dev/null +++ b/sql/updates/characters/master/2024_09_23_00_characters.sql @@ -0,0 +1,3 @@ +-- TDB 1102.24092 characters +UPDATE `updates` SET `state`='ARCHIVED',`speed`=0; +REPLACE INTO `updates_include` (`path`, `state`) VALUES ('$/sql/old/11.x/characters', 'ARCHIVED'); diff --git a/sql/updates/hotfixes/master/2024_09_23_11_hotfixes.sql b/sql/updates/hotfixes/master/2024_09_23_11_hotfixes.sql new file mode 100644 index 00000000000..7edd4006d4d --- /dev/null +++ b/sql/updates/hotfixes/master/2024_09_23_11_hotfixes.sql @@ -0,0 +1,3 @@ +-- TDB 1102.24092 hotfixes +UPDATE `updates` SET `state`='ARCHIVED',`speed`=0; +REPLACE INTO `updates_include` (`path`, `state`) VALUES ('$/sql/old/11.x/hotfixes', 'ARCHIVED'); diff --git a/sql/updates/world/master/2024_09_23_00_world.sql b/sql/updates/world/master/2024_09_23_00_world.sql new file mode 100644 index 00000000000..ce874f7f33d --- /dev/null +++ b/sql/updates/world/master/2024_09_23_00_world.sql @@ -0,0 +1,4 @@ +-- TDB 1102.24092 world +UPDATE `version` SET `db_version`='TDB 1102.24092', `cache_id`=24092 LIMIT 1; +UPDATE `updates` SET `state`='ARCHIVED',`speed`=0; +REPLACE INTO `updates_include` (`path`, `state`) VALUES ('$/sql/old/11.x/world', 'ARCHIVED'); |