diff options
author | TDB Release <tdb-release@build.bot> | 2024-12-22 03:01:09 +0000 |
---|---|---|
committer | TDB Release <tdb-release@build.bot> | 2024-12-22 03:01:09 +0000 |
commit | 76d16440dc36baa8bd92a1d1ccb771e97a44201f (patch) | |
tree | 34df19c88ac926e61723200cf12c4a84a258ecce /sql | |
parent | e58847779134325d9adada3fa9059478d3f350de (diff) |
TDB 1107.24121 - 2024/12/22TDB1107.24121
Diffstat (limited to 'sql')
-rw-r--r-- | sql/base/auth_database.sql | 11 | ||||
-rw-r--r-- | sql/base/characters_database.sql | 5 | ||||
-rw-r--r-- | sql/base/dev/hotfixes_database.sql | 63 | ||||
-rw-r--r-- | sql/base/dev/world_database.sql | 4 | ||||
-rw-r--r-- | sql/old/11.x/auth/24111_2024_12_22/2024_11_16_00_auth.sql (renamed from sql/updates/auth/master/2024_11_16_00_auth.sql) | 0 | ||||
-rw-r--r-- | sql/old/11.x/auth/24111_2024_12_22/2024_11_20_00_auth.sql (renamed from sql/updates/auth/master/2024_11_20_00_auth.sql) | 0 | ||||
-rw-r--r-- | sql/old/11.x/auth/24111_2024_12_22/2024_12_18_00_auth.sql (renamed from sql/updates/auth/master/2024_12_18_00_auth.sql) | 0 | ||||
-rw-r--r-- | sql/old/11.x/auth/24111_2024_12_22/2024_12_19_00_auth.sql (renamed from sql/updates/auth/master/2024_12_19_00_auth.sql) | 0 | ||||
-rw-r--r-- | sql/old/11.x/auth/24111_2024_12_22/2024_12_21_00_auth.sql (renamed from sql/updates/auth/master/2024_12_21_00_auth.sql) | 0 | ||||
-rw-r--r-- | sql/old/11.x/characters/24111_2024_12_22/2024_11_16_00_characters.sql (renamed from sql/updates/characters/master/2024_11_16_00_characters.sql) | 0 | ||||
-rw-r--r-- | sql/old/11.x/characters/24111_2024_12_22/2024_12_13_00_characters.sql (renamed from sql/updates/characters/master/2024_12_13_00_characters.sql) | 0 | ||||
-rw-r--r-- | sql/old/11.x/hotfixes/24111_2024_12_22/2024_11_16_23_hotfixes.sql (renamed from sql/updates/hotfixes/master/2024_11_16_23_hotfixes.sql) | 0 | ||||
-rw-r--r-- | sql/old/11.x/hotfixes/24111_2024_12_22/2024_11_19_00_hotfixes.sql (renamed from sql/updates/hotfixes/master/2024_11_19_00_hotfixes.sql) | 0 | ||||
-rw-r--r-- | sql/old/11.x/hotfixes/24111_2024_12_22/2024_12_02_00_hotfixes.sql (renamed from sql/updates/hotfixes/master/2024_12_02_00_hotfixes.sql) | 0 | ||||
-rw-r--r-- | sql/old/11.x/hotfixes/24111_2024_12_22/2024_12_18_00_hotfixes.sql (renamed from sql/updates/hotfixes/master/2024_12_18_00_hotfixes.sql) | 0 | ||||
-rw-r--r-- | sql/old/11.x/hotfixes/24111_2024_12_22/2024_12_21_00_hotfixes.sql (renamed from sql/updates/hotfixes/master/2024_12_21_00_hotfixes.sql) | 0 | ||||
-rw-r--r-- | sql/old/11.x/hotfixes/24111_2024_12_22/2024_12_22_00_hotfixes_deDE.sql (renamed from sql/updates/hotfixes/master/2024_12_22_00_hotfixes_deDE.sql) | 0 | ||||
-rw-r--r-- | sql/old/11.x/hotfixes/24111_2024_12_22/2024_12_22_01_hotfixes_esES.sql (renamed from sql/updates/hotfixes/master/2024_12_22_01_hotfixes_esES.sql) | 0 | ||||
-rw-r--r-- | sql/old/11.x/hotfixes/24111_2024_12_22/2024_12_22_02_hotfixes_esMX.sql (renamed from sql/updates/hotfixes/master/2024_12_22_02_hotfixes_esMX.sql) | 0 | ||||
-rw-r--r-- | sql/old/11.x/hotfixes/24111_2024_12_22/2024_12_22_03_hotfixes_frFR.sql (renamed from sql/updates/hotfixes/master/2024_12_22_03_hotfixes_frFR.sql) | 0 | ||||
-rw-r--r-- | sql/old/11.x/hotfixes/24111_2024_12_22/2024_12_22_04_hotfixes_itIT.sql (renamed from sql/updates/hotfixes/master/2024_12_22_04_hotfixes_itIT.sql) | 0 | ||||
-rw-r--r-- | sql/old/11.x/hotfixes/24111_2024_12_22/2024_12_22_05_hotfixes_ptBR.sql (renamed from sql/updates/hotfixes/master/2024_12_22_05_hotfixes_ptBR.sql) | 0 | ||||
-rw-r--r-- | sql/old/11.x/hotfixes/24111_2024_12_22/2024_12_22_06_hotfixes_koKR.sql (renamed from sql/updates/hotfixes/master/2024_12_22_06_hotfixes_koKR.sql) | 0 | ||||
-rw-r--r-- | sql/old/11.x/hotfixes/24111_2024_12_22/2024_12_22_07_hotfixes_ruRU.sql (renamed from sql/updates/hotfixes/master/2024_12_22_07_hotfixes_ruRU.sql) | 0 | ||||
-rw-r--r-- | sql/old/11.x/hotfixes/24111_2024_12_22/2024_12_22_08_hotfixes_zhCN.sql (renamed from sql/updates/hotfixes/master/2024_12_22_08_hotfixes_zhCN.sql) | 0 | ||||
-rw-r--r-- | sql/old/11.x/hotfixes/24111_2024_12_22/2024_12_22_09_hotfixes_zhTW.sql (renamed from sql/updates/hotfixes/master/2024_12_22_09_hotfixes_zhTW.sql) | 0 | ||||
-rw-r--r-- | sql/old/11.x/world/24111_2024_12_22/2024_11_16_13_world.sql (renamed from sql/updates/world/master/2024_11_16_13_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/11.x/world/24111_2024_12_22/2024_11_17_00_world.sql (renamed from sql/updates/world/master/2024_11_17_00_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/11.x/world/24111_2024_12_22/2024_11_17_01_world.sql (renamed from sql/updates/world/master/2024_11_17_01_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/11.x/world/24111_2024_12_22/2024_11_17_02_world.sql (renamed from sql/updates/world/master/2024_11_17_02_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/11.x/world/24111_2024_12_22/2024_11_19_00_world.sql (renamed from sql/updates/world/master/2024_11_19_00_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/11.x/world/24111_2024_12_22/2024_11_22_00_world.sql (renamed from sql/updates/world/master/2024_11_22_00_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/11.x/world/24111_2024_12_22/2024_11_22_01_world.sql (renamed from sql/updates/world/master/2024_11_22_01_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/11.x/world/24111_2024_12_22/2024_11_22_02_world.sql (renamed from sql/updates/world/master/2024_11_22_02_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/11.x/world/24111_2024_12_22/2024_11_23_00_world.sql (renamed from sql/updates/world/master/2024_11_23_00_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/11.x/world/24111_2024_12_22/2024_11_24_00_world.sql (renamed from sql/updates/world/master/2024_11_24_00_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/11.x/world/24111_2024_12_22/2024_11_24_01_world.sql (renamed from sql/updates/world/master/2024_11_24_01_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/11.x/world/24111_2024_12_22/2024_11_27_00_world.sql (renamed from sql/updates/world/master/2024_11_27_00_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/11.x/world/24111_2024_12_22/2024_11_27_01_world.sql (renamed from sql/updates/world/master/2024_11_27_01_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/11.x/world/24111_2024_12_22/2024_11_27_02_world.sql (renamed from sql/updates/world/master/2024_11_27_02_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/11.x/world/24111_2024_12_22/2024_11_27_03_world.sql (renamed from sql/updates/world/master/2024_11_27_03_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/11.x/world/24111_2024_12_22/2024_11_27_04_world.sql (renamed from sql/updates/world/master/2024_11_27_04_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/11.x/world/24111_2024_12_22/2024_11_28_00_world.sql (renamed from sql/updates/world/master/2024_11_28_00_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/11.x/world/24111_2024_12_22/2024_11_28_01_world.sql (renamed from sql/updates/world/master/2024_11_28_01_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/11.x/world/24111_2024_12_22/2024_11_29_00_world.sql (renamed from sql/updates/world/master/2024_11_29_00_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/11.x/world/24111_2024_12_22/2024_11_29_01_world.sql (renamed from sql/updates/world/master/2024_11_29_01_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/11.x/world/24111_2024_12_22/2024_11_30_00_world.sql (renamed from sql/updates/world/master/2024_11_30_00_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/11.x/world/24111_2024_12_22/2024_12_01_00_world.sql (renamed from sql/updates/world/master/2024_12_01_00_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/11.x/world/24111_2024_12_22/2024_12_01_01_world.sql (renamed from sql/updates/world/master/2024_12_01_01_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/11.x/world/24111_2024_12_22/2024_12_01_02_world.sql (renamed from sql/updates/world/master/2024_12_01_02_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/11.x/world/24111_2024_12_22/2024_12_01_03_world.sql (renamed from sql/updates/world/master/2024_12_01_03_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/11.x/world/24111_2024_12_22/2024_12_02_00_world.sql (renamed from sql/updates/world/master/2024_12_02_00_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/11.x/world/24111_2024_12_22/2024_12_02_01_world.sql (renamed from sql/updates/world/master/2024_12_02_01_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/11.x/world/24111_2024_12_22/2024_12_03_00_world.sql (renamed from sql/updates/world/master/2024_12_03_00_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/11.x/world/24111_2024_12_22/2024_12_03_01_world.sql (renamed from sql/updates/world/master/2024_12_03_01_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/11.x/world/24111_2024_12_22/2024_12_03_02_world.sql (renamed from sql/updates/world/master/2024_12_03_02_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/11.x/world/24111_2024_12_22/2024_12_04_00_world.sql (renamed from sql/updates/world/master/2024_12_04_00_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/11.x/world/24111_2024_12_22/2024_12_04_01_world.sql (renamed from sql/updates/world/master/2024_12_04_01_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/11.x/world/24111_2024_12_22/2024_12_04_02_world.sql (renamed from sql/updates/world/master/2024_12_04_02_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/11.x/world/24111_2024_12_22/2024_12_05_00_world.sql (renamed from sql/updates/world/master/2024_12_05_00_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/11.x/world/24111_2024_12_22/2024_12_07_00_world.sql (renamed from sql/updates/world/master/2024_12_07_00_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/11.x/world/24111_2024_12_22/2024_12_08_00_world.sql (renamed from sql/updates/world/master/2024_12_08_00_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/11.x/world/24111_2024_12_22/2024_12_09_00_world.sql (renamed from sql/updates/world/master/2024_12_09_00_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/11.x/world/24111_2024_12_22/2024_12_09_01_world.sql (renamed from sql/updates/world/master/2024_12_09_01_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/11.x/world/24111_2024_12_22/2024_12_10_00_world.sql (renamed from sql/updates/world/master/2024_12_10_00_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/11.x/world/24111_2024_12_22/2024_12_11_00_world.sql (renamed from sql/updates/world/master/2024_12_11_00_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/11.x/world/24111_2024_12_22/2024_12_11_01_world.sql (renamed from sql/updates/world/master/2024_12_11_01_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/11.x/world/24111_2024_12_22/2024_12_11_02_world.sql (renamed from sql/updates/world/master/2024_12_11_02_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/11.x/world/24111_2024_12_22/2024_12_12_00_world.sql (renamed from sql/updates/world/master/2024_12_12_00_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/11.x/world/24111_2024_12_22/2024_12_12_01_world.sql (renamed from sql/updates/world/master/2024_12_12_01_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/11.x/world/24111_2024_12_22/2024_12_15_00_world.sql (renamed from sql/updates/world/master/2024_12_15_00_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/11.x/world/24111_2024_12_22/2024_12_16_00_world.sql (renamed from sql/updates/world/master/2024_12_16_00_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/11.x/world/24111_2024_12_22/2024_12_20_00_world.sql (renamed from sql/updates/world/master/2024_12_20_00_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/11.x/world/24111_2024_12_22/2024_12_20_01_world.sql (renamed from sql/updates/world/master/2024_12_20_01_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/11.x/world/24111_2024_12_22/2024_12_20_02_world.sql (renamed from sql/updates/world/master/2024_12_20_02_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/11.x/world/24111_2024_12_22/2024_12_20_03_world.sql (renamed from sql/updates/world/master/2024_12_20_03_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/11.x/world/24111_2024_12_22/2024_12_20_04_world.sql (renamed from sql/updates/world/master/2024_12_20_04_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/11.x/world/24111_2024_12_22/2024_12_21_00_world.sql (renamed from sql/updates/world/master/2024_12_21_00_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/11.x/world/24111_2024_12_22/2024_12_21_01_world.sql (renamed from sql/updates/world/master/2024_12_21_01_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/11.x/world/24111_2024_12_22/2024_12_22_00_world_deDE.sql (renamed from sql/updates/world/master/2024_12_22_00_world_deDE.sql) | 0 | ||||
-rw-r--r-- | sql/old/11.x/world/24111_2024_12_22/2024_12_22_01_world_esES.sql (renamed from sql/updates/world/master/2024_12_22_01_world_esES.sql) | 0 | ||||
-rw-r--r-- | sql/old/11.x/world/24111_2024_12_22/2024_12_22_02_world_esMX.sql (renamed from sql/updates/world/master/2024_12_22_02_world_esMX.sql) | 0 | ||||
-rw-r--r-- | sql/old/11.x/world/24111_2024_12_22/2024_12_22_03_world_frFR.sql (renamed from sql/updates/world/master/2024_12_22_03_world_frFR.sql) | 0 | ||||
-rw-r--r-- | sql/old/11.x/world/24111_2024_12_22/2024_12_22_04_world_itIT.sql (renamed from sql/updates/world/master/2024_12_22_04_world_itIT.sql) | 0 | ||||
-rw-r--r-- | sql/old/11.x/world/24111_2024_12_22/2024_12_22_05_world_ptBR.sql (renamed from sql/updates/world/master/2024_12_22_05_world_ptBR.sql) | 0 | ||||
-rw-r--r-- | sql/old/11.x/world/24111_2024_12_22/2024_12_22_06_world_koKR.sql (renamed from sql/updates/world/master/2024_12_22_06_world_koKR.sql) | 0 | ||||
-rw-r--r-- | sql/old/11.x/world/24111_2024_12_22/2024_12_22_07_world_ruRU.sql (renamed from sql/updates/world/master/2024_12_22_07_world_ruRU.sql) | 0 | ||||
-rw-r--r-- | sql/old/11.x/world/24111_2024_12_22/2024_12_22_08_world_zhCN.sql (renamed from sql/updates/world/master/2024_12_22_08_world_zhCN.sql) | 0 | ||||
-rw-r--r-- | sql/old/11.x/world/24111_2024_12_22/2024_12_22_09_world_zhTW.sql (renamed from sql/updates/world/master/2024_12_22_09_world_zhTW.sql) | 0 | ||||
-rw-r--r-- | sql/updates/auth/master/2024_12_22_00_auth.sql | 3 | ||||
-rw-r--r-- | sql/updates/characters/master/2024_12_22_00_characters.sql | 3 | ||||
-rw-r--r-- | sql/updates/hotfixes/master/2024_12_22_10_hotfixes.sql | 3 | ||||
-rw-r--r-- | sql/updates/world/master/2024_12_22_10_world.sql | 4 |
93 files changed, 84 insertions, 12 deletions
diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql index ee36f98fba5..34c934d4d01 100644 --- a/sql/base/auth_database.sql +++ b/sql/base/auth_database.sql @@ -3350,10 +3350,11 @@ INSERT INTO `updates` VALUES ('2024_11_12_00_auth.sql','5A236A557291758C0F2C46FDEC02692E7C53F751','ARCHIVED','2024-11-12 11:42:13',0), ('2024_11_14_00_auth.sql','646A438FAD5A83D80DCDDEDC71BB6CF21A1FE490','ARCHIVED','2024-11-14 10:29:52',0), ('2024_11_16_00_auth.sql','94794542B3320D76E4A3615DB2418EEF38BDFEA1','ARCHIVED','2024-11-16 21:57:39',0), -('2024_11_20_00_auth.sql','444C765DD16E9B70C1D1163155238E8EE481B17D','RELEASED','2024-11-20 20:39:53',0), -('2024_12_18_00_auth.sql','1F3145F30A79FEE13F5CD9817F54FAFA9A85DEE6','RELEASED','2024-12-18 22:04:44',0), -('2024_12_19_00_auth.sql','B01D54F8420CF680F0DDA903210028F0174E310D','RELEASED','2024-12-19 11:32:53',0), -('2024_12_21_00_auth.sql','9DA5E7911D231D46FE9630D20BDD4AEA0B3CF650','RELEASED','2024-12-21 01:03:37',0); +('2024_11_20_00_auth.sql','444C765DD16E9B70C1D1163155238E8EE481B17D','ARCHIVED','2024-11-20 20:39:53',0), +('2024_12_18_00_auth.sql','1F3145F30A79FEE13F5CD9817F54FAFA9A85DEE6','ARCHIVED','2024-12-18 22:04:44',0), +('2024_12_19_00_auth.sql','B01D54F8420CF680F0DDA903210028F0174E310D','ARCHIVED','2024-12-19 11:32:53',0), +('2024_12_21_00_auth.sql','9DA5E7911D231D46FE9630D20BDD4AEA0B3CF650','ARCHIVED','2024-12-21 01:03:37',0), +('2024_12_22_00_auth.sql','6FDF0ABE9952CC96BE04A6BAA0F1161900B4AB88','ARCHIVED','2024-12-22 02:56:17',0); /*!40000 ALTER TABLE `updates` ENABLE KEYS */; UNLOCK TABLES; @@ -3497,4 +3498,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-11-16 21:57:41 +-- Dump completed on 2024-12-22 2:56:19 diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql index fdd39eb4413..f994bf8bd72 100644 --- a/sql/base/characters_database.sql +++ b/sql/base/characters_database.sql @@ -3752,7 +3752,8 @@ INSERT INTO `updates` VALUES ('2024_10_03_00_characters.sql','408249A6992999A36EB94089D184972E8E0767A3','ARCHIVED','2024-10-03 11:10:18',0), ('2024_11_04_00_characters.sql','F7980E0CEE728FF866703693690F76F932E7C764','ARCHIVED','2024-11-04 17:14:03',0), ('2024_11_16_00_characters.sql','9D9D87FB8DEB99F074EB499A5BD230FD9C993669','ARCHIVED','2024-11-16 21:57:39',0), -('2024_12_13_00_characters.sql','4A00C51BA33639F5555AAE40EC672AE47126F7B6','RELEASED','2024-12-13 00:17:03',0); +('2024_12_13_00_characters.sql','4A00C51BA33639F5555AAE40EC672AE47126F7B6','ARCHIVED','2024-12-13 00:17:03',0), +('2024_12_22_00_characters.sql','A2F24564430C5BCC96C279E843FA3548B1F831EE','ARCHIVED','2024-12-22 02:56:17',0); /*!40000 ALTER TABLE `updates` ENABLE KEYS */; UNLOCK TABLES; @@ -3880,4 +3881,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2024-11-16 21:57:41 +-- Dump completed on 2024-12-22 2:56:19 diff --git a/sql/base/dev/hotfixes_database.sql b/sql/base/dev/hotfixes_database.sql index ca4e827e340..9221f7828ed 100644 --- a/sql/base/dev/hotfixes_database.sql +++ b/sql/base/dev/hotfixes_database.sql @@ -1367,7 +1367,7 @@ CREATE TABLE `broadcast_text` ( `LanguageID` int NOT NULL DEFAULT '0', `ConditionID` int NOT NULL DEFAULT '0', `EmotesID` smallint unsigned NOT NULL DEFAULT '0', - `Flags` tinyint unsigned NOT NULL DEFAULT '0', + `Flags` smallint unsigned NOT NULL DEFAULT '0', `ChatBubbleDurationMs` int unsigned NOT NULL DEFAULT '0', `VoiceOverPriorityID` int NOT NULL DEFAULT '0', `SoundKitID1` int unsigned NOT NULL DEFAULT '0', @@ -2575,6 +2575,22 @@ CREATE TABLE `creature_family_locale` ( /*!40101 SET character_set_client = @saved_cs_client */; -- +-- Table structure for table `creature_label` +-- + +DROP TABLE IF EXISTS `creature_label`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!50503 SET character_set_client = utf8mb4 */; +CREATE TABLE `creature_label` ( + `ID` int unsigned NOT NULL DEFAULT '0', + `LabelID` int NOT NULL DEFAULT '0', + `CreatureDifficultyID` 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 `creature_model_data` -- @@ -3487,6 +3503,22 @@ CREATE TABLE `gameobject_display_info` ( /*!40101 SET character_set_client = @saved_cs_client */; -- +-- Table structure for table `gameobject_label` +-- + +DROP TABLE IF EXISTS `gameobject_label`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!50503 SET character_set_client = utf8mb4 */; +CREATE TABLE `gameobject_label` ( + `ID` int unsigned NOT NULL DEFAULT '0', + `LabelID` int NOT NULL DEFAULT '0', + `GameObjectID` 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 `gameobjects` -- @@ -5966,6 +5998,9 @@ CREATE TABLE `lfg_dungeons` ( `MinCountTank` tinyint unsigned NOT NULL DEFAULT '0', `MinCountHealer` tinyint unsigned NOT NULL DEFAULT '0', `MinCountDamage` tinyint unsigned NOT NULL DEFAULT '0', + `MaxPremadeCountTank` tinyint unsigned NOT NULL DEFAULT '0', + `MaxPremadeCountHealer` tinyint unsigned NOT NULL DEFAULT '0', + `MaxPremadeCountDamage` tinyint unsigned NOT NULL DEFAULT '0', `BonusReputationAmount` smallint unsigned NOT NULL DEFAULT '0', `MentorItemLevel` smallint unsigned NOT NULL DEFAULT '0', `MentorCharLevel` tinyint unsigned NOT NULL DEFAULT '0', @@ -6311,8 +6346,8 @@ DROP TABLE IF EXISTS `map_difficulty`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `map_difficulty` ( - `ID` int unsigned NOT NULL DEFAULT '0', `Message` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + `ID` int unsigned NOT NULL DEFAULT '0', `DifficultyID` int NOT NULL DEFAULT '0', `LockID` int NOT NULL DEFAULT '0', `ResetInterval` tinyint unsigned NOT NULL DEFAULT '0', @@ -6518,6 +6553,24 @@ CREATE TABLE `mount_capability` ( /*!40101 SET character_set_client = @saved_cs_client */; -- +-- Table structure for table `mount_equipment` +-- + +DROP TABLE IF EXISTS `mount_equipment`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!50503 SET character_set_client = utf8mb4 */; +CREATE TABLE `mount_equipment` ( + `ID` int unsigned NOT NULL DEFAULT '0', + `Item` int NOT NULL DEFAULT '0', + `BuffSpell` int NOT NULL DEFAULT '0', + `Unknown820` int NOT NULL DEFAULT '0', + `LearnedBySpell` 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 `mount_locale` -- @@ -6839,6 +6892,8 @@ CREATE TABLE `player_condition` ( `ID` int unsigned NOT NULL DEFAULT '0', `RaceMask` bigint NOT NULL DEFAULT '0', `FailureDescription` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + `MinLevel` smallint unsigned NOT NULL DEFAULT '0', + `MaxLevel` smallint unsigned NOT NULL DEFAULT '0', `ClassMask` int NOT NULL DEFAULT '0', `SkillLogic` int unsigned NOT NULL DEFAULT '0', `LanguageID` int NOT NULL DEFAULT '0', @@ -10740,6 +10795,8 @@ CREATE TABLE `vignette` ( `VignetteType` tinyint NOT NULL DEFAULT '0', `RewardQuestID` int NOT NULL DEFAULT '0', `UiWidgetSetID` int NOT NULL DEFAULT '0', + `UiMapPinInfoID` int NOT NULL DEFAULT '0', + `ObjectiveType` tinyint NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`VerifiedBuild`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -10904,4 +10961,4 @@ CREATE TABLE `world_state_expression` ( /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2024-11-16 21:57:45 +-- Dump completed on 2024-12-22 2:56:24 diff --git a/sql/base/dev/world_database.sql b/sql/base/dev/world_database.sql index 94e00c15396..8d4788433f2 100644 --- a/sql/base/dev/world_database.sql +++ b/sql/base/dev/world_database.sql @@ -1630,7 +1630,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=2183 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Tele Command'; +) ENGINE=InnoDB AUTO_INCREMENT=2189 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Tele Command'; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -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-11-16 21:57:43 +-- Dump completed on 2024-12-22 2:56:21 diff --git a/sql/updates/auth/master/2024_11_16_00_auth.sql b/sql/old/11.x/auth/24111_2024_12_22/2024_11_16_00_auth.sql index 7f039313880..7f039313880 100644 --- a/sql/updates/auth/master/2024_11_16_00_auth.sql +++ b/sql/old/11.x/auth/24111_2024_12_22/2024_11_16_00_auth.sql diff --git a/sql/updates/auth/master/2024_11_20_00_auth.sql b/sql/old/11.x/auth/24111_2024_12_22/2024_11_20_00_auth.sql index 886c8a7313a..886c8a7313a 100644 --- a/sql/updates/auth/master/2024_11_20_00_auth.sql +++ b/sql/old/11.x/auth/24111_2024_12_22/2024_11_20_00_auth.sql diff --git a/sql/updates/auth/master/2024_12_18_00_auth.sql b/sql/old/11.x/auth/24111_2024_12_22/2024_12_18_00_auth.sql index 510444839aa..510444839aa 100644 --- a/sql/updates/auth/master/2024_12_18_00_auth.sql +++ b/sql/old/11.x/auth/24111_2024_12_22/2024_12_18_00_auth.sql diff --git a/sql/updates/auth/master/2024_12_19_00_auth.sql b/sql/old/11.x/auth/24111_2024_12_22/2024_12_19_00_auth.sql index baace5a1f1c..baace5a1f1c 100644 --- a/sql/updates/auth/master/2024_12_19_00_auth.sql +++ b/sql/old/11.x/auth/24111_2024_12_22/2024_12_19_00_auth.sql diff --git a/sql/updates/auth/master/2024_12_21_00_auth.sql b/sql/old/11.x/auth/24111_2024_12_22/2024_12_21_00_auth.sql index cf04c9bc407..cf04c9bc407 100644 --- a/sql/updates/auth/master/2024_12_21_00_auth.sql +++ b/sql/old/11.x/auth/24111_2024_12_22/2024_12_21_00_auth.sql diff --git a/sql/updates/characters/master/2024_11_16_00_characters.sql b/sql/old/11.x/characters/24111_2024_12_22/2024_11_16_00_characters.sql index d293d2af437..d293d2af437 100644 --- a/sql/updates/characters/master/2024_11_16_00_characters.sql +++ b/sql/old/11.x/characters/24111_2024_12_22/2024_11_16_00_characters.sql diff --git a/sql/updates/characters/master/2024_12_13_00_characters.sql b/sql/old/11.x/characters/24111_2024_12_22/2024_12_13_00_characters.sql index d32b5511299..d32b5511299 100644 --- a/sql/updates/characters/master/2024_12_13_00_characters.sql +++ b/sql/old/11.x/characters/24111_2024_12_22/2024_12_13_00_characters.sql diff --git a/sql/updates/hotfixes/master/2024_11_16_23_hotfixes.sql b/sql/old/11.x/hotfixes/24111_2024_12_22/2024_11_16_23_hotfixes.sql index 99b822bd772..99b822bd772 100644 --- a/sql/updates/hotfixes/master/2024_11_16_23_hotfixes.sql +++ b/sql/old/11.x/hotfixes/24111_2024_12_22/2024_11_16_23_hotfixes.sql diff --git a/sql/updates/hotfixes/master/2024_11_19_00_hotfixes.sql b/sql/old/11.x/hotfixes/24111_2024_12_22/2024_11_19_00_hotfixes.sql index 678c526c8e2..678c526c8e2 100644 --- a/sql/updates/hotfixes/master/2024_11_19_00_hotfixes.sql +++ b/sql/old/11.x/hotfixes/24111_2024_12_22/2024_11_19_00_hotfixes.sql diff --git a/sql/updates/hotfixes/master/2024_12_02_00_hotfixes.sql b/sql/old/11.x/hotfixes/24111_2024_12_22/2024_12_02_00_hotfixes.sql index a3946e51902..a3946e51902 100644 --- a/sql/updates/hotfixes/master/2024_12_02_00_hotfixes.sql +++ b/sql/old/11.x/hotfixes/24111_2024_12_22/2024_12_02_00_hotfixes.sql diff --git a/sql/updates/hotfixes/master/2024_12_18_00_hotfixes.sql b/sql/old/11.x/hotfixes/24111_2024_12_22/2024_12_18_00_hotfixes.sql index 5a18de9e7b1..5a18de9e7b1 100644 --- a/sql/updates/hotfixes/master/2024_12_18_00_hotfixes.sql +++ b/sql/old/11.x/hotfixes/24111_2024_12_22/2024_12_18_00_hotfixes.sql diff --git a/sql/updates/hotfixes/master/2024_12_21_00_hotfixes.sql b/sql/old/11.x/hotfixes/24111_2024_12_22/2024_12_21_00_hotfixes.sql index ad31157f15f..ad31157f15f 100644 --- a/sql/updates/hotfixes/master/2024_12_21_00_hotfixes.sql +++ b/sql/old/11.x/hotfixes/24111_2024_12_22/2024_12_21_00_hotfixes.sql diff --git a/sql/updates/hotfixes/master/2024_12_22_00_hotfixes_deDE.sql b/sql/old/11.x/hotfixes/24111_2024_12_22/2024_12_22_00_hotfixes_deDE.sql index e47eda777de..e47eda777de 100644 --- a/sql/updates/hotfixes/master/2024_12_22_00_hotfixes_deDE.sql +++ b/sql/old/11.x/hotfixes/24111_2024_12_22/2024_12_22_00_hotfixes_deDE.sql diff --git a/sql/updates/hotfixes/master/2024_12_22_01_hotfixes_esES.sql b/sql/old/11.x/hotfixes/24111_2024_12_22/2024_12_22_01_hotfixes_esES.sql index d8a754a9869..d8a754a9869 100644 --- a/sql/updates/hotfixes/master/2024_12_22_01_hotfixes_esES.sql +++ b/sql/old/11.x/hotfixes/24111_2024_12_22/2024_12_22_01_hotfixes_esES.sql diff --git a/sql/updates/hotfixes/master/2024_12_22_02_hotfixes_esMX.sql b/sql/old/11.x/hotfixes/24111_2024_12_22/2024_12_22_02_hotfixes_esMX.sql index 1127dd847aa..1127dd847aa 100644 --- a/sql/updates/hotfixes/master/2024_12_22_02_hotfixes_esMX.sql +++ b/sql/old/11.x/hotfixes/24111_2024_12_22/2024_12_22_02_hotfixes_esMX.sql diff --git a/sql/updates/hotfixes/master/2024_12_22_03_hotfixes_frFR.sql b/sql/old/11.x/hotfixes/24111_2024_12_22/2024_12_22_03_hotfixes_frFR.sql index ae483f079b8..ae483f079b8 100644 --- a/sql/updates/hotfixes/master/2024_12_22_03_hotfixes_frFR.sql +++ b/sql/old/11.x/hotfixes/24111_2024_12_22/2024_12_22_03_hotfixes_frFR.sql diff --git a/sql/updates/hotfixes/master/2024_12_22_04_hotfixes_itIT.sql b/sql/old/11.x/hotfixes/24111_2024_12_22/2024_12_22_04_hotfixes_itIT.sql index 572961d060f..572961d060f 100644 --- a/sql/updates/hotfixes/master/2024_12_22_04_hotfixes_itIT.sql +++ b/sql/old/11.x/hotfixes/24111_2024_12_22/2024_12_22_04_hotfixes_itIT.sql diff --git a/sql/updates/hotfixes/master/2024_12_22_05_hotfixes_ptBR.sql b/sql/old/11.x/hotfixes/24111_2024_12_22/2024_12_22_05_hotfixes_ptBR.sql index c61f4615fba..c61f4615fba 100644 --- a/sql/updates/hotfixes/master/2024_12_22_05_hotfixes_ptBR.sql +++ b/sql/old/11.x/hotfixes/24111_2024_12_22/2024_12_22_05_hotfixes_ptBR.sql diff --git a/sql/updates/hotfixes/master/2024_12_22_06_hotfixes_koKR.sql b/sql/old/11.x/hotfixes/24111_2024_12_22/2024_12_22_06_hotfixes_koKR.sql index 39d1b60c4a1..39d1b60c4a1 100644 --- a/sql/updates/hotfixes/master/2024_12_22_06_hotfixes_koKR.sql +++ b/sql/old/11.x/hotfixes/24111_2024_12_22/2024_12_22_06_hotfixes_koKR.sql diff --git a/sql/updates/hotfixes/master/2024_12_22_07_hotfixes_ruRU.sql b/sql/old/11.x/hotfixes/24111_2024_12_22/2024_12_22_07_hotfixes_ruRU.sql index 9f23f526db6..9f23f526db6 100644 --- a/sql/updates/hotfixes/master/2024_12_22_07_hotfixes_ruRU.sql +++ b/sql/old/11.x/hotfixes/24111_2024_12_22/2024_12_22_07_hotfixes_ruRU.sql diff --git a/sql/updates/hotfixes/master/2024_12_22_08_hotfixes_zhCN.sql b/sql/old/11.x/hotfixes/24111_2024_12_22/2024_12_22_08_hotfixes_zhCN.sql index 6e042d73bfc..6e042d73bfc 100644 --- a/sql/updates/hotfixes/master/2024_12_22_08_hotfixes_zhCN.sql +++ b/sql/old/11.x/hotfixes/24111_2024_12_22/2024_12_22_08_hotfixes_zhCN.sql diff --git a/sql/updates/hotfixes/master/2024_12_22_09_hotfixes_zhTW.sql b/sql/old/11.x/hotfixes/24111_2024_12_22/2024_12_22_09_hotfixes_zhTW.sql index 4f560052d74..4f560052d74 100644 --- a/sql/updates/hotfixes/master/2024_12_22_09_hotfixes_zhTW.sql +++ b/sql/old/11.x/hotfixes/24111_2024_12_22/2024_12_22_09_hotfixes_zhTW.sql diff --git a/sql/updates/world/master/2024_11_16_13_world.sql b/sql/old/11.x/world/24111_2024_12_22/2024_11_16_13_world.sql index 947f3260015..947f3260015 100644 --- a/sql/updates/world/master/2024_11_16_13_world.sql +++ b/sql/old/11.x/world/24111_2024_12_22/2024_11_16_13_world.sql diff --git a/sql/updates/world/master/2024_11_17_00_world.sql b/sql/old/11.x/world/24111_2024_12_22/2024_11_17_00_world.sql index 2ba75476211..2ba75476211 100644 --- a/sql/updates/world/master/2024_11_17_00_world.sql +++ b/sql/old/11.x/world/24111_2024_12_22/2024_11_17_00_world.sql diff --git a/sql/updates/world/master/2024_11_17_01_world.sql b/sql/old/11.x/world/24111_2024_12_22/2024_11_17_01_world.sql index 79602f19c9b..79602f19c9b 100644 --- a/sql/updates/world/master/2024_11_17_01_world.sql +++ b/sql/old/11.x/world/24111_2024_12_22/2024_11_17_01_world.sql diff --git a/sql/updates/world/master/2024_11_17_02_world.sql b/sql/old/11.x/world/24111_2024_12_22/2024_11_17_02_world.sql index 71775d2a51f..71775d2a51f 100644 --- a/sql/updates/world/master/2024_11_17_02_world.sql +++ b/sql/old/11.x/world/24111_2024_12_22/2024_11_17_02_world.sql diff --git a/sql/updates/world/master/2024_11_19_00_world.sql b/sql/old/11.x/world/24111_2024_12_22/2024_11_19_00_world.sql index dc2c1212fb1..dc2c1212fb1 100644 --- a/sql/updates/world/master/2024_11_19_00_world.sql +++ b/sql/old/11.x/world/24111_2024_12_22/2024_11_19_00_world.sql diff --git a/sql/updates/world/master/2024_11_22_00_world.sql b/sql/old/11.x/world/24111_2024_12_22/2024_11_22_00_world.sql index d83952b75ad..d83952b75ad 100644 --- a/sql/updates/world/master/2024_11_22_00_world.sql +++ b/sql/old/11.x/world/24111_2024_12_22/2024_11_22_00_world.sql diff --git a/sql/updates/world/master/2024_11_22_01_world.sql b/sql/old/11.x/world/24111_2024_12_22/2024_11_22_01_world.sql index 25051f72ea3..25051f72ea3 100644 --- a/sql/updates/world/master/2024_11_22_01_world.sql +++ b/sql/old/11.x/world/24111_2024_12_22/2024_11_22_01_world.sql diff --git a/sql/updates/world/master/2024_11_22_02_world.sql b/sql/old/11.x/world/24111_2024_12_22/2024_11_22_02_world.sql index c2aaa1522eb..c2aaa1522eb 100644 --- a/sql/updates/world/master/2024_11_22_02_world.sql +++ b/sql/old/11.x/world/24111_2024_12_22/2024_11_22_02_world.sql diff --git a/sql/updates/world/master/2024_11_23_00_world.sql b/sql/old/11.x/world/24111_2024_12_22/2024_11_23_00_world.sql index e4daa9ab37a..e4daa9ab37a 100644 --- a/sql/updates/world/master/2024_11_23_00_world.sql +++ b/sql/old/11.x/world/24111_2024_12_22/2024_11_23_00_world.sql diff --git a/sql/updates/world/master/2024_11_24_00_world.sql b/sql/old/11.x/world/24111_2024_12_22/2024_11_24_00_world.sql index 34cec28b8d8..34cec28b8d8 100644 --- a/sql/updates/world/master/2024_11_24_00_world.sql +++ b/sql/old/11.x/world/24111_2024_12_22/2024_11_24_00_world.sql diff --git a/sql/updates/world/master/2024_11_24_01_world.sql b/sql/old/11.x/world/24111_2024_12_22/2024_11_24_01_world.sql index 4d429e8d730..4d429e8d730 100644 --- a/sql/updates/world/master/2024_11_24_01_world.sql +++ b/sql/old/11.x/world/24111_2024_12_22/2024_11_24_01_world.sql diff --git a/sql/updates/world/master/2024_11_27_00_world.sql b/sql/old/11.x/world/24111_2024_12_22/2024_11_27_00_world.sql index 4a68aac8665..4a68aac8665 100644 --- a/sql/updates/world/master/2024_11_27_00_world.sql +++ b/sql/old/11.x/world/24111_2024_12_22/2024_11_27_00_world.sql diff --git a/sql/updates/world/master/2024_11_27_01_world.sql b/sql/old/11.x/world/24111_2024_12_22/2024_11_27_01_world.sql index 007e3cf5610..007e3cf5610 100644 --- a/sql/updates/world/master/2024_11_27_01_world.sql +++ b/sql/old/11.x/world/24111_2024_12_22/2024_11_27_01_world.sql diff --git a/sql/updates/world/master/2024_11_27_02_world.sql b/sql/old/11.x/world/24111_2024_12_22/2024_11_27_02_world.sql index 3aff2bf626f..3aff2bf626f 100644 --- a/sql/updates/world/master/2024_11_27_02_world.sql +++ b/sql/old/11.x/world/24111_2024_12_22/2024_11_27_02_world.sql diff --git a/sql/updates/world/master/2024_11_27_03_world.sql b/sql/old/11.x/world/24111_2024_12_22/2024_11_27_03_world.sql index 1c845cf4c69..1c845cf4c69 100644 --- a/sql/updates/world/master/2024_11_27_03_world.sql +++ b/sql/old/11.x/world/24111_2024_12_22/2024_11_27_03_world.sql diff --git a/sql/updates/world/master/2024_11_27_04_world.sql b/sql/old/11.x/world/24111_2024_12_22/2024_11_27_04_world.sql index b716d7f2149..b716d7f2149 100644 --- a/sql/updates/world/master/2024_11_27_04_world.sql +++ b/sql/old/11.x/world/24111_2024_12_22/2024_11_27_04_world.sql diff --git a/sql/updates/world/master/2024_11_28_00_world.sql b/sql/old/11.x/world/24111_2024_12_22/2024_11_28_00_world.sql index 6b7243f737d..6b7243f737d 100644 --- a/sql/updates/world/master/2024_11_28_00_world.sql +++ b/sql/old/11.x/world/24111_2024_12_22/2024_11_28_00_world.sql diff --git a/sql/updates/world/master/2024_11_28_01_world.sql b/sql/old/11.x/world/24111_2024_12_22/2024_11_28_01_world.sql index 898140cff06..898140cff06 100644 --- a/sql/updates/world/master/2024_11_28_01_world.sql +++ b/sql/old/11.x/world/24111_2024_12_22/2024_11_28_01_world.sql diff --git a/sql/updates/world/master/2024_11_29_00_world.sql b/sql/old/11.x/world/24111_2024_12_22/2024_11_29_00_world.sql index a8cd29fc6e1..a8cd29fc6e1 100644 --- a/sql/updates/world/master/2024_11_29_00_world.sql +++ b/sql/old/11.x/world/24111_2024_12_22/2024_11_29_00_world.sql diff --git a/sql/updates/world/master/2024_11_29_01_world.sql b/sql/old/11.x/world/24111_2024_12_22/2024_11_29_01_world.sql index 3d6ccd34dce..3d6ccd34dce 100644 --- a/sql/updates/world/master/2024_11_29_01_world.sql +++ b/sql/old/11.x/world/24111_2024_12_22/2024_11_29_01_world.sql diff --git a/sql/updates/world/master/2024_11_30_00_world.sql b/sql/old/11.x/world/24111_2024_12_22/2024_11_30_00_world.sql index 5b69673a725..5b69673a725 100644 --- a/sql/updates/world/master/2024_11_30_00_world.sql +++ b/sql/old/11.x/world/24111_2024_12_22/2024_11_30_00_world.sql diff --git a/sql/updates/world/master/2024_12_01_00_world.sql b/sql/old/11.x/world/24111_2024_12_22/2024_12_01_00_world.sql index 1184d438e52..1184d438e52 100644 --- a/sql/updates/world/master/2024_12_01_00_world.sql +++ b/sql/old/11.x/world/24111_2024_12_22/2024_12_01_00_world.sql diff --git a/sql/updates/world/master/2024_12_01_01_world.sql b/sql/old/11.x/world/24111_2024_12_22/2024_12_01_01_world.sql index 6afc6ac6606..6afc6ac6606 100644 --- a/sql/updates/world/master/2024_12_01_01_world.sql +++ b/sql/old/11.x/world/24111_2024_12_22/2024_12_01_01_world.sql diff --git a/sql/updates/world/master/2024_12_01_02_world.sql b/sql/old/11.x/world/24111_2024_12_22/2024_12_01_02_world.sql index 4588bd5c44b..4588bd5c44b 100644 --- a/sql/updates/world/master/2024_12_01_02_world.sql +++ b/sql/old/11.x/world/24111_2024_12_22/2024_12_01_02_world.sql diff --git a/sql/updates/world/master/2024_12_01_03_world.sql b/sql/old/11.x/world/24111_2024_12_22/2024_12_01_03_world.sql index be87ffdae7b..be87ffdae7b 100644 --- a/sql/updates/world/master/2024_12_01_03_world.sql +++ b/sql/old/11.x/world/24111_2024_12_22/2024_12_01_03_world.sql diff --git a/sql/updates/world/master/2024_12_02_00_world.sql b/sql/old/11.x/world/24111_2024_12_22/2024_12_02_00_world.sql index 1c8cca588e7..1c8cca588e7 100644 --- a/sql/updates/world/master/2024_12_02_00_world.sql +++ b/sql/old/11.x/world/24111_2024_12_22/2024_12_02_00_world.sql diff --git a/sql/updates/world/master/2024_12_02_01_world.sql b/sql/old/11.x/world/24111_2024_12_22/2024_12_02_01_world.sql index f3baa7eeb47..f3baa7eeb47 100644 --- a/sql/updates/world/master/2024_12_02_01_world.sql +++ b/sql/old/11.x/world/24111_2024_12_22/2024_12_02_01_world.sql diff --git a/sql/updates/world/master/2024_12_03_00_world.sql b/sql/old/11.x/world/24111_2024_12_22/2024_12_03_00_world.sql index fe0cd9ca780..fe0cd9ca780 100644 --- a/sql/updates/world/master/2024_12_03_00_world.sql +++ b/sql/old/11.x/world/24111_2024_12_22/2024_12_03_00_world.sql diff --git a/sql/updates/world/master/2024_12_03_01_world.sql b/sql/old/11.x/world/24111_2024_12_22/2024_12_03_01_world.sql index 7901397605d..7901397605d 100644 --- a/sql/updates/world/master/2024_12_03_01_world.sql +++ b/sql/old/11.x/world/24111_2024_12_22/2024_12_03_01_world.sql diff --git a/sql/updates/world/master/2024_12_03_02_world.sql b/sql/old/11.x/world/24111_2024_12_22/2024_12_03_02_world.sql index 21e4edbe349..21e4edbe349 100644 --- a/sql/updates/world/master/2024_12_03_02_world.sql +++ b/sql/old/11.x/world/24111_2024_12_22/2024_12_03_02_world.sql diff --git a/sql/updates/world/master/2024_12_04_00_world.sql b/sql/old/11.x/world/24111_2024_12_22/2024_12_04_00_world.sql index 22a3b393730..22a3b393730 100644 --- a/sql/updates/world/master/2024_12_04_00_world.sql +++ b/sql/old/11.x/world/24111_2024_12_22/2024_12_04_00_world.sql diff --git a/sql/updates/world/master/2024_12_04_01_world.sql b/sql/old/11.x/world/24111_2024_12_22/2024_12_04_01_world.sql index 2b5893cb05c..2b5893cb05c 100644 --- a/sql/updates/world/master/2024_12_04_01_world.sql +++ b/sql/old/11.x/world/24111_2024_12_22/2024_12_04_01_world.sql diff --git a/sql/updates/world/master/2024_12_04_02_world.sql b/sql/old/11.x/world/24111_2024_12_22/2024_12_04_02_world.sql index b5c88b1ce54..b5c88b1ce54 100644 --- a/sql/updates/world/master/2024_12_04_02_world.sql +++ b/sql/old/11.x/world/24111_2024_12_22/2024_12_04_02_world.sql diff --git a/sql/updates/world/master/2024_12_05_00_world.sql b/sql/old/11.x/world/24111_2024_12_22/2024_12_05_00_world.sql index 3d727564d6a..3d727564d6a 100644 --- a/sql/updates/world/master/2024_12_05_00_world.sql +++ b/sql/old/11.x/world/24111_2024_12_22/2024_12_05_00_world.sql diff --git a/sql/updates/world/master/2024_12_07_00_world.sql b/sql/old/11.x/world/24111_2024_12_22/2024_12_07_00_world.sql index bbb45a2731f..bbb45a2731f 100644 --- a/sql/updates/world/master/2024_12_07_00_world.sql +++ b/sql/old/11.x/world/24111_2024_12_22/2024_12_07_00_world.sql diff --git a/sql/updates/world/master/2024_12_08_00_world.sql b/sql/old/11.x/world/24111_2024_12_22/2024_12_08_00_world.sql index d4e65c2f745..d4e65c2f745 100644 --- a/sql/updates/world/master/2024_12_08_00_world.sql +++ b/sql/old/11.x/world/24111_2024_12_22/2024_12_08_00_world.sql diff --git a/sql/updates/world/master/2024_12_09_00_world.sql b/sql/old/11.x/world/24111_2024_12_22/2024_12_09_00_world.sql index 1d57e039af2..1d57e039af2 100644 --- a/sql/updates/world/master/2024_12_09_00_world.sql +++ b/sql/old/11.x/world/24111_2024_12_22/2024_12_09_00_world.sql diff --git a/sql/updates/world/master/2024_12_09_01_world.sql b/sql/old/11.x/world/24111_2024_12_22/2024_12_09_01_world.sql index 5e4a2b806de..5e4a2b806de 100644 --- a/sql/updates/world/master/2024_12_09_01_world.sql +++ b/sql/old/11.x/world/24111_2024_12_22/2024_12_09_01_world.sql diff --git a/sql/updates/world/master/2024_12_10_00_world.sql b/sql/old/11.x/world/24111_2024_12_22/2024_12_10_00_world.sql index f5fa4ee2dcc..f5fa4ee2dcc 100644 --- a/sql/updates/world/master/2024_12_10_00_world.sql +++ b/sql/old/11.x/world/24111_2024_12_22/2024_12_10_00_world.sql diff --git a/sql/updates/world/master/2024_12_11_00_world.sql b/sql/old/11.x/world/24111_2024_12_22/2024_12_11_00_world.sql index 3d358f66ed1..3d358f66ed1 100644 --- a/sql/updates/world/master/2024_12_11_00_world.sql +++ b/sql/old/11.x/world/24111_2024_12_22/2024_12_11_00_world.sql diff --git a/sql/updates/world/master/2024_12_11_01_world.sql b/sql/old/11.x/world/24111_2024_12_22/2024_12_11_01_world.sql index 33437fd1d38..33437fd1d38 100644 --- a/sql/updates/world/master/2024_12_11_01_world.sql +++ b/sql/old/11.x/world/24111_2024_12_22/2024_12_11_01_world.sql diff --git a/sql/updates/world/master/2024_12_11_02_world.sql b/sql/old/11.x/world/24111_2024_12_22/2024_12_11_02_world.sql index 18fec8692f9..18fec8692f9 100644 --- a/sql/updates/world/master/2024_12_11_02_world.sql +++ b/sql/old/11.x/world/24111_2024_12_22/2024_12_11_02_world.sql diff --git a/sql/updates/world/master/2024_12_12_00_world.sql b/sql/old/11.x/world/24111_2024_12_22/2024_12_12_00_world.sql index b7c0b661b7b..b7c0b661b7b 100644 --- a/sql/updates/world/master/2024_12_12_00_world.sql +++ b/sql/old/11.x/world/24111_2024_12_22/2024_12_12_00_world.sql diff --git a/sql/updates/world/master/2024_12_12_01_world.sql b/sql/old/11.x/world/24111_2024_12_22/2024_12_12_01_world.sql index ecb80c21633..ecb80c21633 100644 --- a/sql/updates/world/master/2024_12_12_01_world.sql +++ b/sql/old/11.x/world/24111_2024_12_22/2024_12_12_01_world.sql diff --git a/sql/updates/world/master/2024_12_15_00_world.sql b/sql/old/11.x/world/24111_2024_12_22/2024_12_15_00_world.sql index e72c6628fb0..e72c6628fb0 100644 --- a/sql/updates/world/master/2024_12_15_00_world.sql +++ b/sql/old/11.x/world/24111_2024_12_22/2024_12_15_00_world.sql diff --git a/sql/updates/world/master/2024_12_16_00_world.sql b/sql/old/11.x/world/24111_2024_12_22/2024_12_16_00_world.sql index 5ebc7cb648c..5ebc7cb648c 100644 --- a/sql/updates/world/master/2024_12_16_00_world.sql +++ b/sql/old/11.x/world/24111_2024_12_22/2024_12_16_00_world.sql diff --git a/sql/updates/world/master/2024_12_20_00_world.sql b/sql/old/11.x/world/24111_2024_12_22/2024_12_20_00_world.sql index f85eccdaa76..f85eccdaa76 100644 --- a/sql/updates/world/master/2024_12_20_00_world.sql +++ b/sql/old/11.x/world/24111_2024_12_22/2024_12_20_00_world.sql diff --git a/sql/updates/world/master/2024_12_20_01_world.sql b/sql/old/11.x/world/24111_2024_12_22/2024_12_20_01_world.sql index 46e9de14d48..46e9de14d48 100644 --- a/sql/updates/world/master/2024_12_20_01_world.sql +++ b/sql/old/11.x/world/24111_2024_12_22/2024_12_20_01_world.sql diff --git a/sql/updates/world/master/2024_12_20_02_world.sql b/sql/old/11.x/world/24111_2024_12_22/2024_12_20_02_world.sql index 5d9aa8e40b9..5d9aa8e40b9 100644 --- a/sql/updates/world/master/2024_12_20_02_world.sql +++ b/sql/old/11.x/world/24111_2024_12_22/2024_12_20_02_world.sql diff --git a/sql/updates/world/master/2024_12_20_03_world.sql b/sql/old/11.x/world/24111_2024_12_22/2024_12_20_03_world.sql index fb6150e9f23..fb6150e9f23 100644 --- a/sql/updates/world/master/2024_12_20_03_world.sql +++ b/sql/old/11.x/world/24111_2024_12_22/2024_12_20_03_world.sql diff --git a/sql/updates/world/master/2024_12_20_04_world.sql b/sql/old/11.x/world/24111_2024_12_22/2024_12_20_04_world.sql index d387da6e079..d387da6e079 100644 --- a/sql/updates/world/master/2024_12_20_04_world.sql +++ b/sql/old/11.x/world/24111_2024_12_22/2024_12_20_04_world.sql diff --git a/sql/updates/world/master/2024_12_21_00_world.sql b/sql/old/11.x/world/24111_2024_12_22/2024_12_21_00_world.sql index f78f33639f6..f78f33639f6 100644 --- a/sql/updates/world/master/2024_12_21_00_world.sql +++ b/sql/old/11.x/world/24111_2024_12_22/2024_12_21_00_world.sql diff --git a/sql/updates/world/master/2024_12_21_01_world.sql b/sql/old/11.x/world/24111_2024_12_22/2024_12_21_01_world.sql index 7a4552d2214..7a4552d2214 100644 --- a/sql/updates/world/master/2024_12_21_01_world.sql +++ b/sql/old/11.x/world/24111_2024_12_22/2024_12_21_01_world.sql diff --git a/sql/updates/world/master/2024_12_22_00_world_deDE.sql b/sql/old/11.x/world/24111_2024_12_22/2024_12_22_00_world_deDE.sql index 3863c9e669e..3863c9e669e 100644 --- a/sql/updates/world/master/2024_12_22_00_world_deDE.sql +++ b/sql/old/11.x/world/24111_2024_12_22/2024_12_22_00_world_deDE.sql diff --git a/sql/updates/world/master/2024_12_22_01_world_esES.sql b/sql/old/11.x/world/24111_2024_12_22/2024_12_22_01_world_esES.sql index 5168d802283..5168d802283 100644 --- a/sql/updates/world/master/2024_12_22_01_world_esES.sql +++ b/sql/old/11.x/world/24111_2024_12_22/2024_12_22_01_world_esES.sql diff --git a/sql/updates/world/master/2024_12_22_02_world_esMX.sql b/sql/old/11.x/world/24111_2024_12_22/2024_12_22_02_world_esMX.sql index feb52b6dd86..feb52b6dd86 100644 --- a/sql/updates/world/master/2024_12_22_02_world_esMX.sql +++ b/sql/old/11.x/world/24111_2024_12_22/2024_12_22_02_world_esMX.sql diff --git a/sql/updates/world/master/2024_12_22_03_world_frFR.sql b/sql/old/11.x/world/24111_2024_12_22/2024_12_22_03_world_frFR.sql index 16e08faa3fd..16e08faa3fd 100644 --- a/sql/updates/world/master/2024_12_22_03_world_frFR.sql +++ b/sql/old/11.x/world/24111_2024_12_22/2024_12_22_03_world_frFR.sql diff --git a/sql/updates/world/master/2024_12_22_04_world_itIT.sql b/sql/old/11.x/world/24111_2024_12_22/2024_12_22_04_world_itIT.sql index 61f6026acea..61f6026acea 100644 --- a/sql/updates/world/master/2024_12_22_04_world_itIT.sql +++ b/sql/old/11.x/world/24111_2024_12_22/2024_12_22_04_world_itIT.sql diff --git a/sql/updates/world/master/2024_12_22_05_world_ptBR.sql b/sql/old/11.x/world/24111_2024_12_22/2024_12_22_05_world_ptBR.sql index 37020fc35ce..37020fc35ce 100644 --- a/sql/updates/world/master/2024_12_22_05_world_ptBR.sql +++ b/sql/old/11.x/world/24111_2024_12_22/2024_12_22_05_world_ptBR.sql diff --git a/sql/updates/world/master/2024_12_22_06_world_koKR.sql b/sql/old/11.x/world/24111_2024_12_22/2024_12_22_06_world_koKR.sql index 623237331a1..623237331a1 100644 --- a/sql/updates/world/master/2024_12_22_06_world_koKR.sql +++ b/sql/old/11.x/world/24111_2024_12_22/2024_12_22_06_world_koKR.sql diff --git a/sql/updates/world/master/2024_12_22_07_world_ruRU.sql b/sql/old/11.x/world/24111_2024_12_22/2024_12_22_07_world_ruRU.sql index 4c572601c7b..4c572601c7b 100644 --- a/sql/updates/world/master/2024_12_22_07_world_ruRU.sql +++ b/sql/old/11.x/world/24111_2024_12_22/2024_12_22_07_world_ruRU.sql diff --git a/sql/updates/world/master/2024_12_22_08_world_zhCN.sql b/sql/old/11.x/world/24111_2024_12_22/2024_12_22_08_world_zhCN.sql index dd7b4f31fdd..dd7b4f31fdd 100644 --- a/sql/updates/world/master/2024_12_22_08_world_zhCN.sql +++ b/sql/old/11.x/world/24111_2024_12_22/2024_12_22_08_world_zhCN.sql diff --git a/sql/updates/world/master/2024_12_22_09_world_zhTW.sql b/sql/old/11.x/world/24111_2024_12_22/2024_12_22_09_world_zhTW.sql index a51b6ea05ab..a51b6ea05ab 100644 --- a/sql/updates/world/master/2024_12_22_09_world_zhTW.sql +++ b/sql/old/11.x/world/24111_2024_12_22/2024_12_22_09_world_zhTW.sql diff --git a/sql/updates/auth/master/2024_12_22_00_auth.sql b/sql/updates/auth/master/2024_12_22_00_auth.sql new file mode 100644 index 00000000000..a43db5fca0b --- /dev/null +++ b/sql/updates/auth/master/2024_12_22_00_auth.sql @@ -0,0 +1,3 @@ +-- TDB 1107.24121 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_12_22_00_characters.sql b/sql/updates/characters/master/2024_12_22_00_characters.sql new file mode 100644 index 00000000000..f8e4e599012 --- /dev/null +++ b/sql/updates/characters/master/2024_12_22_00_characters.sql @@ -0,0 +1,3 @@ +-- TDB 1107.24121 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_12_22_10_hotfixes.sql b/sql/updates/hotfixes/master/2024_12_22_10_hotfixes.sql new file mode 100644 index 00000000000..08df808dd5a --- /dev/null +++ b/sql/updates/hotfixes/master/2024_12_22_10_hotfixes.sql @@ -0,0 +1,3 @@ +-- TDB 1107.24121 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_12_22_10_world.sql b/sql/updates/world/master/2024_12_22_10_world.sql new file mode 100644 index 00000000000..709e3f22c00 --- /dev/null +++ b/sql/updates/world/master/2024_12_22_10_world.sql @@ -0,0 +1,4 @@ +-- TDB 1107.24121 world +UPDATE `version` SET `db_version`='TDB 1107.24121', `cache_id`=24121 LIMIT 1; +UPDATE `updates` SET `state`='ARCHIVED',`speed`=0; +REPLACE INTO `updates_include` (`path`, `state`) VALUES ('$/sql/old/11.x/world', 'ARCHIVED'); |