diff options
author | TDB Release <tdb-release@build.bot> | 2025-05-11 10:44:50 +0000 |
---|---|---|
committer | TDB Release <tdb-release@build.bot> | 2025-05-11 10:44:50 +0000 |
commit | aeb1cf905731fca78b462e10a10cdfaadfc85533 (patch) | |
tree | 5ab1874737092afe016e4ad31989b9b8d0f96a34 /sql | |
parent | 8e0be127399e82a5082a9e740054b7e9fda259bc (diff) |
TDB 442.25051 - 2025/05/11TDB442.25051
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 | 299 | ||||
-rw-r--r-- | sql/base/dev/world_database.sql | 18 | ||||
-rw-r--r-- | sql/old/4.4.x/auth/25021_2025_05_11/2025_02_13_00_auth.sql (renamed from sql/updates/auth/cata_classic/2025_02_13_00_auth.sql) | 0 | ||||
-rw-r--r-- | sql/old/4.4.x/auth/25021_2025_05_11/2025_02_19_01_auth.sql (renamed from sql/updates/auth/cata_classic/2025_02_19_01_auth.sql) | 0 | ||||
-rw-r--r-- | sql/old/4.4.x/auth/25021_2025_05_11/2025_02_20_00_auth.sql (renamed from sql/updates/auth/cata_classic/2025_02_20_00_auth.sql) | 0 | ||||
-rw-r--r-- | sql/old/4.4.x/auth/25021_2025_05_11/2025_04_05_00_auth.sql (renamed from sql/updates/auth/cata_classic/2025_04_05_00_auth.sql) | 0 | ||||
-rw-r--r-- | sql/old/4.4.x/auth/25021_2025_05_11/2025_04_06_00_auth.sql (renamed from sql/updates/auth/cata_classic/2025_04_06_00_auth.sql) | 0 | ||||
-rw-r--r-- | sql/old/4.4.x/auth/25021_2025_05_11/2025_04_09_01_auth.sql (renamed from sql/updates/auth/cata_classic/2025_04_09_01_auth.sql) | 0 | ||||
-rw-r--r-- | sql/old/4.4.x/characters/25021_2025_05_11/2025_02_13_00_characters.sql (renamed from sql/updates/characters/cata_classic/2025_02_13_00_characters.sql) | 0 | ||||
-rw-r--r-- | sql/old/4.4.x/characters/25021_2025_05_11/2025_04_15_00_characters.sql (renamed from sql/updates/characters/cata_classic/2025_04_15_00_characters.sql) | 0 | ||||
-rw-r--r-- | sql/old/4.4.x/hotfixes/25021_2025_05_11/2025_02_13_00_hotfixes.sql (renamed from sql/updates/hotfixes/cata_classic/2025_02_13_00_hotfixes.sql) | 0 | ||||
-rw-r--r-- | sql/old/4.4.x/hotfixes/25021_2025_05_11/2025_02_23_00_hotfixes.sql (renamed from sql/updates/hotfixes/cata_classic/2025_02_23_00_hotfixes.sql) | 0 | ||||
-rw-r--r-- | sql/old/4.4.x/hotfixes/25021_2025_05_11/2025_04_11_00_hotfixes.sql (renamed from sql/updates/hotfixes/cata_classic/2025_04_11_00_hotfixes.sql) | 0 | ||||
-rw-r--r-- | sql/old/4.4.x/hotfixes/25021_2025_05_11/2025_04_11_01_hotfixes.sql (renamed from sql/updates/hotfixes/cata_classic/2025_04_11_01_hotfixes.sql) | 0 | ||||
-rw-r--r-- | sql/old/4.4.x/hotfixes/25021_2025_05_11/2025_04_13_00_hotfixes.sql (renamed from sql/updates/hotfixes/cata_classic/2025_04_13_00_hotfixes.sql) | 0 | ||||
-rw-r--r-- | sql/old/4.4.x/hotfixes/25021_2025_05_11/2025_04_13_01_hotfixes.sql (renamed from sql/updates/hotfixes/cata_classic/2025_04_13_01_hotfixes.sql) | 0 | ||||
-rw-r--r-- | sql/old/4.4.x/hotfixes/25021_2025_05_11/2025_04_13_02_hotfixes.sql (renamed from sql/updates/hotfixes/cata_classic/2025_04_13_02_hotfixes.sql) | 0 | ||||
-rw-r--r-- | sql/old/4.4.x/hotfixes/25021_2025_05_11/2025_04_13_03_hotfixes.sql (renamed from sql/updates/hotfixes/cata_classic/2025_04_13_03_hotfixes.sql) | 0 | ||||
-rw-r--r-- | sql/old/4.4.x/hotfixes/25021_2025_05_11/2025_04_13_04_hotfixes.sql (renamed from sql/updates/hotfixes/cata_classic/2025_04_13_04_hotfixes.sql) | 0 | ||||
-rw-r--r-- | sql/old/4.4.x/hotfixes/25021_2025_05_11/2025_04_13_05_hotfixes.sql (renamed from sql/updates/hotfixes/cata_classic/2025_04_13_05_hotfixes.sql) | 0 | ||||
-rw-r--r-- | sql/old/4.4.x/hotfixes/25021_2025_05_11/2025_04_13_06_hotfixes.sql (renamed from sql/updates/hotfixes/cata_classic/2025_04_13_06_hotfixes.sql) | 0 | ||||
-rw-r--r-- | sql/old/4.4.x/hotfixes/25021_2025_05_11/2025_04_13_07_hotfixes.sql (renamed from sql/updates/hotfixes/cata_classic/2025_04_13_07_hotfixes.sql) | 0 | ||||
-rw-r--r-- | sql/old/4.4.x/hotfixes/25021_2025_05_11/2025_04_15_00_hotfixes.sql (renamed from sql/updates/hotfixes/cata_classic/2025_04_15_00_hotfixes.sql) | 0 | ||||
-rw-r--r-- | sql/old/4.4.x/world/25021_2025_05_11/2025_02_13_00_world.sql (renamed from sql/updates/world/cata_classic/2025_02_13_00_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/4.4.x/world/25021_2025_05_11/2025_04_05_00_world.sql (renamed from sql/updates/world/cata_classic/2025_04_05_00_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/4.4.x/world/25021_2025_05_11/2025_04_05_01_world.sql (renamed from sql/updates/world/cata_classic/2025_04_05_01_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/4.4.x/world/25021_2025_05_11/2025_04_05_02_world.sql (renamed from sql/updates/world/cata_classic/2025_04_05_02_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/4.4.x/world/25021_2025_05_11/2025_04_08_00_world.sql (renamed from sql/updates/world/cata_classic/2025_04_08_00_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/4.4.x/world/25021_2025_05_11/2025_04_12_00_world.sql (renamed from sql/updates/world/cata_classic/2025_04_12_00_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/4.4.x/world/25021_2025_05_11/2025_04_12_01_world.sql (renamed from sql/updates/world/cata_classic/2025_04_12_01_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/4.4.x/world/25021_2025_05_11/2025_04_12_02_world.sql (renamed from sql/updates/world/cata_classic/2025_04_12_02_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/4.4.x/world/25021_2025_05_11/2025_04_12_03_world.sql (renamed from sql/updates/world/cata_classic/2025_04_12_03_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/4.4.x/world/25021_2025_05_11/2025_04_12_04_world.sql (renamed from sql/updates/world/cata_classic/2025_04_12_04_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/4.4.x/world/25021_2025_05_11/2025_04_12_05_world.sql (renamed from sql/updates/world/cata_classic/2025_04_12_05_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/4.4.x/world/25021_2025_05_11/2025_04_12_06_world.sql (renamed from sql/updates/world/cata_classic/2025_04_12_06_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/4.4.x/world/25021_2025_05_11/2025_04_12_07_world_2025_04_12_02_world.sql (renamed from sql/updates/world/cata_classic/2025_04_12_07_world_2025_04_12_02_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/4.4.x/world/25021_2025_05_11/2025_04_12_08_world.sql (renamed from sql/updates/world/cata_classic/2025_04_12_08_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/4.4.x/world/25021_2025_05_11/2025_04_12_09_world.sql (renamed from sql/updates/world/cata_classic/2025_04_12_09_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/4.4.x/world/25021_2025_05_11/2025_04_12_10_world.sql (renamed from sql/updates/world/cata_classic/2025_04_12_10_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/4.4.x/world/25021_2025_05_11/2025_04_12_11_world.sql (renamed from sql/updates/world/cata_classic/2025_04_12_11_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/4.4.x/world/25021_2025_05_11/2025_04_12_12_world.sql (renamed from sql/updates/world/cata_classic/2025_04_12_12_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/4.4.x/world/25021_2025_05_11/2025_04_12_13_world.sql (renamed from sql/updates/world/cata_classic/2025_04_12_13_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/4.4.x/world/25021_2025_05_11/2025_04_12_14_world.sql (renamed from sql/updates/world/cata_classic/2025_04_12_14_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/4.4.x/world/25021_2025_05_11/2025_04_13_00_world.sql (renamed from sql/updates/world/cata_classic/2025_04_13_00_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/4.4.x/world/25021_2025_05_11/2025_04_13_01_world.sql (renamed from sql/updates/world/cata_classic/2025_04_13_01_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/4.4.x/world/25021_2025_05_11/2025_04_13_02_world.sql (renamed from sql/updates/world/cata_classic/2025_04_13_02_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/4.4.x/world/25021_2025_05_11/2025_04_13_03_world.sql (renamed from sql/updates/world/cata_classic/2025_04_13_03_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/4.4.x/world/25021_2025_05_11/2025_04_13_04_world.sql (renamed from sql/updates/world/cata_classic/2025_04_13_04_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/4.4.x/world/25021_2025_05_11/2025_04_13_05_world.sql (renamed from sql/updates/world/cata_classic/2025_04_13_05_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/4.4.x/world/25021_2025_05_11/2025_04_13_06_world.sql (renamed from sql/updates/world/cata_classic/2025_04_13_06_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/4.4.x/world/25021_2025_05_11/2025_04_13_07_world.sql (renamed from sql/updates/world/cata_classic/2025_04_13_07_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/4.4.x/world/25021_2025_05_11/2025_04_13_08_world.sql (renamed from sql/updates/world/cata_classic/2025_04_13_08_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/4.4.x/world/25021_2025_05_11/2025_04_13_09_world.sql (renamed from sql/updates/world/cata_classic/2025_04_13_09_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/4.4.x/world/25021_2025_05_11/2025_04_14_00_world.sql (renamed from sql/updates/world/cata_classic/2025_04_14_00_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/4.4.x/world/25021_2025_05_11/2025_04_14_01_world.sql (renamed from sql/updates/world/cata_classic/2025_04_14_01_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/4.4.x/world/25021_2025_05_11/2025_04_14_02_world.sql (renamed from sql/updates/world/cata_classic/2025_04_14_02_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/4.4.x/world/25021_2025_05_11/2025_04_14_03_world.sql (renamed from sql/updates/world/cata_classic/2025_04_14_03_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/4.4.x/world/25021_2025_05_11/2025_04_14_04_world.sql (renamed from sql/updates/world/cata_classic/2025_04_14_04_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/4.4.x/world/25021_2025_05_11/2025_04_14_05_world.sql (renamed from sql/updates/world/cata_classic/2025_04_14_05_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/4.4.x/world/25021_2025_05_11/2025_04_14_06_world.sql (renamed from sql/updates/world/cata_classic/2025_04_14_06_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/4.4.x/world/25021_2025_05_11/2025_04_14_07_world.sql (renamed from sql/updates/world/cata_classic/2025_04_14_07_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/4.4.x/world/25021_2025_05_11/2025_04_15_00_world.sql (renamed from sql/updates/world/cata_classic/2025_04_15_00_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/4.4.x/world/25021_2025_05_11/2025_04_15_01_world.sql (renamed from sql/updates/world/cata_classic/2025_04_15_01_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/4.4.x/world/25021_2025_05_11/2025_04_15_02_world.sql (renamed from sql/updates/world/cata_classic/2025_04_15_02_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/4.4.x/world/25021_2025_05_11/2025_04_15_03_world.sql (renamed from sql/updates/world/cata_classic/2025_04_15_03_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/4.4.x/world/25021_2025_05_11/2025_04_15_04_world.sql (renamed from sql/updates/world/cata_classic/2025_04_15_04_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/4.4.x/world/25021_2025_05_11/2025_04_15_05_world.sql (renamed from sql/updates/world/cata_classic/2025_04_15_05_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/4.4.x/world/25021_2025_05_11/2025_04_16_00_world.sql (renamed from sql/updates/world/cata_classic/2025_04_16_00_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/4.4.x/world/25021_2025_05_11/2025_04_16_01_world.sql (renamed from sql/updates/world/cata_classic/2025_04_16_01_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/4.4.x/world/25021_2025_05_11/2025_04_16_02_world.sql (renamed from sql/updates/world/cata_classic/2025_04_16_02_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/4.4.x/world/25021_2025_05_11/2025_04_16_03_world.sql (renamed from sql/updates/world/cata_classic/2025_04_16_03_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/4.4.x/world/25021_2025_05_11/2025_04_16_04_world.sql (renamed from sql/updates/world/cata_classic/2025_04_16_04_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/4.4.x/world/25021_2025_05_11/2025_04_16_05_world.sql (renamed from sql/updates/world/cata_classic/2025_04_16_05_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/4.4.x/world/25021_2025_05_11/2025_04_16_06_world.sql (renamed from sql/updates/world/cata_classic/2025_04_16_06_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/4.4.x/world/25021_2025_05_11/2025_04_16_07_world.sql (renamed from sql/updates/world/cata_classic/2025_04_16_07_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/4.4.x/world/25021_2025_05_11/2025_04_16_08_world.sql (renamed from sql/updates/world/cata_classic/2025_04_16_08_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/4.4.x/world/25021_2025_05_11/2025_04_16_09_world.sql (renamed from sql/updates/world/cata_classic/2025_04_16_09_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/4.4.x/world/25021_2025_05_11/2025_04_17_00_world.sql (renamed from sql/updates/world/cata_classic/2025_04_17_00_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/4.4.x/world/25021_2025_05_11/2025_04_17_01_world.sql (renamed from sql/updates/world/cata_classic/2025_04_17_01_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/4.4.x/world/25021_2025_05_11/2025_04_18_00_world.sql (renamed from sql/updates/world/cata_classic/2025_04_18_00_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/4.4.x/world/25021_2025_05_11/2025_04_18_01_world.sql (renamed from sql/updates/world/cata_classic/2025_04_18_01_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/4.4.x/world/25021_2025_05_11/2025_05_11_00_world_2025_04_19_01_world.sql (renamed from sql/updates/world/cata_classic/2025_05_11_00_world_2025_04_19_01_world.sql) | 0 | ||||
-rw-r--r-- | sql/updates/auth/cata_classic/2025_05_11_00_auth.sql | 3 | ||||
-rw-r--r-- | sql/updates/characters/cata_classic/2025_05_11_00_characters.sql | 3 | ||||
-rw-r--r-- | sql/updates/hotfixes/cata_classic/2025_05_11_00_hotfixes.sql | 3 | ||||
-rw-r--r-- | sql/updates/world/cata_classic/2025_05_11_01_world.sql | 4 |
88 files changed, 305 insertions, 43 deletions
diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql index 3ca17900408..76015286092 100644 --- a/sql/base/auth_database.sql +++ b/sql/base/auth_database.sql @@ -3233,11 +3233,12 @@ INSERT INTO `updates` VALUES ('2025_01_14_00_auth.sql','CA944A0F0028B8888F5576E8166115AD31264F84','ARCHIVED','2025-01-14 09:50:31',0), ('2025_02_12_00_auth.sql','AF96D2CBDEED3AA8E1D489FEA6AA084771B3AC21','ARCHIVED','2025-02-12 10:13:07',0), ('2025_02_13_00_auth.sql','85B38293CCFFC74094F56A6A1ACAB87E7DC5BB7E','ARCHIVED','2025-02-13 16:45:59',0), -('2025_02_19_01_auth.sql','9435D6201F67CB303DA4C66F76061056BD744792','RELEASED','2025-02-19 14:30:51',0), -('2025_02_20_00_auth.sql','AB6B8CAF5D4B7BDADE896EF9E54FE9384D0BFF61','RELEASED','2025-02-20 10:49:50',0), -('2025_04_05_00_auth.sql','2523EEC30D3456441CF4EA8ED5E529506CED238B','RELEASED','2025-04-05 15:16:45',0), -('2025_04_06_00_auth.sql','D65E53E402A789FC413131E1720830B43FEAD967','RELEASED','2025-04-06 19:08:23',0), -('2025_04_09_01_auth.sql','07470857CD49E55C61714A9BB855EF49D645266B','RELEASED','2025-04-09 10:07:46',0); +('2025_02_19_01_auth.sql','9435D6201F67CB303DA4C66F76061056BD744792','ARCHIVED','2025-02-19 14:30:51',0), +('2025_02_20_00_auth.sql','AB6B8CAF5D4B7BDADE896EF9E54FE9384D0BFF61','ARCHIVED','2025-02-20 10:49:50',0), +('2025_04_05_00_auth.sql','2523EEC30D3456441CF4EA8ED5E529506CED238B','ARCHIVED','2025-04-05 15:16:45',0), +('2025_04_06_00_auth.sql','D65E53E402A789FC413131E1720830B43FEAD967','ARCHIVED','2025-04-06 19:08:23',0), +('2025_04_09_01_auth.sql','07470857CD49E55C61714A9BB855EF49D645266B','ARCHIVED','2025-04-09 10:07:46',0), +('2025_05_11_00_auth.sql','5024DAF97BDADC8ABAD06A893F920BACD45A59EC','ARCHIVED','2025-05-11 10:42:32',0); /*!40000 ALTER TABLE `updates` ENABLE KEYS */; UNLOCK TABLES; @@ -3381,4 +3382,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 2025-02-13 16:46:00 +-- Dump completed on 2025-05-11 10:42:34 diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql index 1d4a5c18371..0e5977f6aca 100644 --- a/sql/base/characters_database.sql +++ b/sql/base/characters_database.sql @@ -3386,7 +3386,8 @@ INSERT INTO `updates` VALUES ('2024_10_27_00_characters.sql','94ABF0B022E253C4F1B1AF165BF46C0CE4551C44','ARCHIVED','2024-10-27 19:22:40',0), ('2024_12_13_00_characters.sql','4A00C51BA33639F5555AAE40EC672AE47126F7B6','ARCHIVED','2024-12-13 00:17:03',0), ('2025_02_13_00_characters.sql','52DC4928863A53ED85BEC39C35F4F4EF779872D2','ARCHIVED','2025-02-13 16:45:59',0), -('2025_04_15_00_characters.sql','332E776137FC0A0056C370601619141C9A0BE1F4','RELEASED','2025-04-15 19:12:00',0); +('2025_04_15_00_characters.sql','332E776137FC0A0056C370601619141C9A0BE1F4','ARCHIVED','2025-04-15 19:12:00',0), +('2025_05_11_00_characters.sql','726C64A997C1B4D9B2CC69F2C4F4123762717517','ARCHIVED','2025-05-11 10:42:33',0); /*!40000 ALTER TABLE `updates` ENABLE KEYS */; UNLOCK TABLES; @@ -3514,4 +3515,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2025-02-13 16:46:00 +-- Dump completed on 2025-05-11 10:42:34 diff --git a/sql/base/dev/hotfixes_database.sql b/sql/base/dev/hotfixes_database.sql index 530abd54ff5..531df0fce3e 100644 --- a/sql/base/dev/hotfixes_database.sql +++ b/sql/base/dev/hotfixes_database.sql @@ -260,7 +260,7 @@ CREATE TABLE `area_trigger` ( `BoxYaw` float NOT NULL DEFAULT '0', `ShapeType` tinyint NOT NULL DEFAULT '0', `ShapeID` smallint NOT NULL DEFAULT '0', - `AreaTriggerActionSetID` smallint NOT NULL DEFAULT '0', + `AreaTriggerActionSetID` int NOT NULL DEFAULT '0', `Flags` tinyint NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`VerifiedBuild`) @@ -722,9 +722,9 @@ DROP TABLE IF EXISTS `broadcast_text_locale`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `broadcast_text_locale` ( `ID` int unsigned NOT NULL DEFAULT '0', - `locale` varchar(4) COLLATE utf8mb4_unicode_ci NOT NULL, - `Text_lang` text COLLATE utf8mb4_unicode_ci, - `Text1_lang` text COLLATE utf8mb4_unicode_ci, + `locale` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, + `Text_lang` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + `Text1_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 @@ -971,6 +971,7 @@ CREATE TABLE `chr_classes` ( `LowResScreenFileDataID` int unsigned NOT NULL DEFAULT '0', `Flags` int NOT NULL DEFAULT '0', `StartingLevel` int NOT NULL DEFAULT '0', + `SpellTextureBlobFileDataID` int unsigned NOT NULL DEFAULT '0', `ArmorTypeMask` int unsigned NOT NULL DEFAULT '0', `CinematicSequenceID` smallint unsigned NOT NULL DEFAULT '0', `DefaultSpec` smallint unsigned NOT NULL DEFAULT '0', @@ -1144,8 +1145,6 @@ CREATE TABLE `chr_customization_option` ( `ID` int unsigned NOT NULL DEFAULT '0', `SecondaryID` smallint unsigned NOT NULL DEFAULT '0', `Flags` int NOT NULL DEFAULT '0', - `ChrRacesID` int NOT NULL DEFAULT '0', - `Sex` int NOT NULL DEFAULT '0', `ChrModelID` int unsigned NOT NULL DEFAULT '0', `OrderIndex` int NOT NULL DEFAULT '0', `ChrCustomizationCategoryID` int NOT NULL DEFAULT '0', @@ -3813,6 +3812,105 @@ CREATE TABLE `item_price_base` ( /*!40101 SET character_set_client = @saved_cs_client */; -- +-- Table structure for table `item_random_properties` +-- + +DROP TABLE IF EXISTS `item_random_properties`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!50503 SET character_set_client = utf8mb4 */; +CREATE TABLE `item_random_properties` ( + `ID` int unsigned NOT NULL DEFAULT '0', + `Name` text COLLATE utf8mb4_unicode_ci, + `Enchantment1` int NOT NULL DEFAULT '0', + `Enchantment2` int NOT NULL DEFAULT '0', + `Enchantment3` int NOT NULL DEFAULT '0', + `Enchantment4` int NOT NULL DEFAULT '0', + `Enchantment5` int 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 `item_random_properties_locale` +-- + +DROP TABLE IF EXISTS `item_random_properties_locale`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!50503 SET character_set_client = utf8mb4 */; +CREATE TABLE `item_random_properties_locale` ( + `ID` int unsigned NOT NULL DEFAULT '0', + `locale` varchar(4) COLLATE utf8mb4_unicode_ci NOT NULL, + `Name_lang` text COLLATE utf8mb4_unicode_ci, + `VerifiedBuild` int NOT NULL DEFAULT '0', + PRIMARY KEY (`ID`,`locale`,`VerifiedBuild`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci +/*!50500 PARTITION BY LIST COLUMNS(locale) +(PARTITION deDE VALUES IN ('deDE') ENGINE = InnoDB, + PARTITION esES VALUES IN ('esES') ENGINE = InnoDB, + PARTITION esMX VALUES IN ('esMX') ENGINE = InnoDB, + PARTITION frFR VALUES IN ('frFR') ENGINE = InnoDB, + PARTITION itIT VALUES IN ('itIT') ENGINE = InnoDB, + PARTITION koKR VALUES IN ('koKR') ENGINE = InnoDB, + PARTITION ptBR VALUES IN ('ptBR') ENGINE = InnoDB, + PARTITION ruRU VALUES IN ('ruRU') ENGINE = InnoDB, + PARTITION zhCN VALUES IN ('zhCN') ENGINE = InnoDB, + PARTITION zhTW VALUES IN ('zhTW') ENGINE = InnoDB) */; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `item_random_suffix` +-- + +DROP TABLE IF EXISTS `item_random_suffix`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!50503 SET character_set_client = utf8mb4 */; +CREATE TABLE `item_random_suffix` ( + `ID` int unsigned NOT NULL DEFAULT '0', + `Name` text COLLATE utf8mb4_unicode_ci, + `Enchantment1` int NOT NULL DEFAULT '0', + `Enchantment2` int NOT NULL DEFAULT '0', + `Enchantment3` int NOT NULL DEFAULT '0', + `Enchantment4` int NOT NULL DEFAULT '0', + `Enchantment5` int NOT NULL DEFAULT '0', + `AllocationPct1` int NOT NULL DEFAULT '0', + `AllocationPct2` int NOT NULL DEFAULT '0', + `AllocationPct3` int NOT NULL DEFAULT '0', + `AllocationPct4` int NOT NULL DEFAULT '0', + `AllocationPct5` int 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 `item_random_suffix_locale` +-- + +DROP TABLE IF EXISTS `item_random_suffix_locale`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!50503 SET character_set_client = utf8mb4 */; +CREATE TABLE `item_random_suffix_locale` ( + `ID` int unsigned NOT NULL DEFAULT '0', + `locale` varchar(4) COLLATE utf8mb4_unicode_ci NOT NULL, + `Name_lang` text COLLATE utf8mb4_unicode_ci, + `VerifiedBuild` int NOT NULL DEFAULT '0', + PRIMARY KEY (`ID`,`locale`,`VerifiedBuild`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci +/*!50500 PARTITION BY LIST COLUMNS(locale) +(PARTITION deDE VALUES IN ('deDE') ENGINE = InnoDB, + PARTITION esES VALUES IN ('esES') ENGINE = InnoDB, + PARTITION esMX VALUES IN ('esMX') ENGINE = InnoDB, + PARTITION frFR VALUES IN ('frFR') ENGINE = InnoDB, + PARTITION itIT VALUES IN ('itIT') ENGINE = InnoDB, + PARTITION koKR VALUES IN ('koKR') ENGINE = InnoDB, + PARTITION ptBR VALUES IN ('ptBR') ENGINE = InnoDB, + PARTITION ruRU VALUES IN ('ruRU') ENGINE = InnoDB, + PARTITION zhCN VALUES IN ('zhCN') ENGINE = InnoDB, + PARTITION zhTW VALUES IN ('zhTW') ENGINE = InnoDB) */; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- -- Table structure for table `item_reforge` -- @@ -4565,6 +4663,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', @@ -4904,16 +5005,17 @@ 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 COLLATE utf8mb4_unicode_ci, - `ItemContextPickerID` int unsigned NOT NULL DEFAULT '0', - `ContentTuningID` int NOT NULL DEFAULT '0', - `ItemContext` int NOT NULL DEFAULT '0', - `DifficultyID` tinyint unsigned NOT NULL DEFAULT '0', - `LockID` tinyint unsigned NOT NULL DEFAULT '0', + `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', - `MaxPlayers` tinyint unsigned NOT NULL DEFAULT '0', - `Flags` tinyint unsigned NOT NULL DEFAULT '0', + `MaxPlayers` int NOT NULL DEFAULT '0', + `ItemContext` tinyint unsigned NOT NULL DEFAULT '0', + `ItemContextPickerID` int NOT NULL DEFAULT '0', + `Flags` int NOT NULL DEFAULT '0', + `ContentTuningID` int NOT NULL DEFAULT '0', + `WorldStateExpressionID` int NOT NULL DEFAULT '0', `MapID` int unsigned NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`VerifiedBuild`) @@ -5410,14 +5512,14 @@ DROP TABLE IF EXISTS `player_condition`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `player_condition` ( + `ID` int unsigned NOT NULL DEFAULT '0', `RaceMask` bigint NOT NULL DEFAULT '0', `FailureDescription` text COLLATE utf8mb4_unicode_ci, - `ID` int unsigned NOT NULL DEFAULT '0', `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` tinyint unsigned NOT NULL DEFAULT '0', + `LanguageID` int NOT NULL DEFAULT '0', `MinLanguage` tinyint unsigned NOT NULL DEFAULT '0', `MaxLanguage` int NOT NULL DEFAULT '0', `MaxFactionID` smallint unsigned NOT NULL DEFAULT '0', @@ -5433,7 +5535,7 @@ CREATE TABLE `player_condition` ( `ItemFlags` tinyint unsigned NOT NULL DEFAULT '0', `AuraSpellLogic` int unsigned NOT NULL DEFAULT '0', `WorldStateExpressionID` smallint unsigned NOT NULL DEFAULT '0', - `WeatherID` tinyint unsigned NOT NULL DEFAULT '0', + `WeatherID` int NOT NULL DEFAULT '0', `PartyStatus` tinyint unsigned NOT NULL DEFAULT '0', `LifetimeMaxPVPRank` tinyint unsigned NOT NULL DEFAULT '0', `AchievementLogic` int unsigned NOT NULL DEFAULT '0', @@ -5442,7 +5544,7 @@ CREATE TABLE `player_condition` ( `AreaLogic` int unsigned NOT NULL DEFAULT '0', `LfgLogic` int unsigned NOT NULL DEFAULT '0', `CurrencyLogic` int unsigned NOT NULL DEFAULT '0', - `QuestKillID` int unsigned NOT NULL DEFAULT '0', + `QuestKillID` int NOT NULL DEFAULT '0', `QuestKillLogic` int unsigned NOT NULL DEFAULT '0', `MinExpansionLevel` tinyint NOT NULL DEFAULT '0', `MaxExpansionLevel` tinyint NOT NULL DEFAULT '0', @@ -5467,6 +5569,9 @@ CREATE TABLE `player_condition` ( `MinExpansionTier` tinyint NOT NULL DEFAULT '0', `MinPVPRank` tinyint unsigned NOT NULL DEFAULT '0', `MaxPVPRank` tinyint unsigned NOT NULL DEFAULT '0', + `ContentTuningID` int NOT NULL DEFAULT '0', + `CovenantID` int NOT NULL DEFAULT '0', + `TraitNodeEntryLogic` int unsigned NOT NULL DEFAULT '0', `SkillID1` smallint unsigned NOT NULL DEFAULT '0', `SkillID2` smallint unsigned NOT NULL DEFAULT '0', `SkillID3` smallint unsigned NOT NULL DEFAULT '0', @@ -5485,18 +5590,18 @@ CREATE TABLE `player_condition` ( `MinReputation1` tinyint unsigned NOT NULL DEFAULT '0', `MinReputation2` tinyint unsigned NOT NULL DEFAULT '0', `MinReputation3` tinyint unsigned NOT NULL DEFAULT '0', - `PrevQuestID1` int unsigned NOT NULL DEFAULT '0', - `PrevQuestID2` int unsigned NOT NULL DEFAULT '0', - `PrevQuestID3` int unsigned NOT NULL DEFAULT '0', - `PrevQuestID4` int unsigned NOT NULL DEFAULT '0', - `CurrQuestID1` int unsigned NOT NULL DEFAULT '0', - `CurrQuestID2` int unsigned NOT NULL DEFAULT '0', - `CurrQuestID3` int unsigned NOT NULL DEFAULT '0', - `CurrQuestID4` int unsigned NOT NULL DEFAULT '0', - `CurrentCompletedQuestID1` int unsigned NOT NULL DEFAULT '0', - `CurrentCompletedQuestID2` int unsigned NOT NULL DEFAULT '0', - `CurrentCompletedQuestID3` int unsigned NOT NULL DEFAULT '0', - `CurrentCompletedQuestID4` int unsigned NOT NULL DEFAULT '0', + `PrevQuestID1` int NOT NULL DEFAULT '0', + `PrevQuestID2` int NOT NULL DEFAULT '0', + `PrevQuestID3` int NOT NULL DEFAULT '0', + `PrevQuestID4` int NOT NULL DEFAULT '0', + `CurrQuestID1` int NOT NULL DEFAULT '0', + `CurrQuestID2` int NOT NULL DEFAULT '0', + `CurrQuestID3` int NOT NULL DEFAULT '0', + `CurrQuestID4` int NOT NULL DEFAULT '0', + `CurrentCompletedQuestID1` int NOT NULL DEFAULT '0', + `CurrentCompletedQuestID2` int NOT NULL DEFAULT '0', + `CurrentCompletedQuestID3` int NOT NULL DEFAULT '0', + `CurrentCompletedQuestID4` int NOT NULL DEFAULT '0', `SpellID1` int NOT NULL DEFAULT '0', `SpellID2` int NOT NULL DEFAULT '0', `SpellID3` int NOT NULL DEFAULT '0', @@ -5557,6 +5662,18 @@ CREATE TABLE `player_condition` ( `QuestKillMonster6` int unsigned NOT NULL DEFAULT '0', `MovementFlags1` int NOT NULL DEFAULT '0', `MovementFlags2` int NOT NULL DEFAULT '0', + `TraitNodeEntryID1` int NOT NULL DEFAULT '0', + `TraitNodeEntryID2` int NOT NULL DEFAULT '0', + `TraitNodeEntryID3` int NOT NULL DEFAULT '0', + `TraitNodeEntryID4` int NOT NULL DEFAULT '0', + `TraitNodeEntryMinRank1` smallint unsigned NOT NULL DEFAULT '0', + `TraitNodeEntryMinRank2` smallint unsigned NOT NULL DEFAULT '0', + `TraitNodeEntryMinRank3` smallint unsigned NOT NULL DEFAULT '0', + `TraitNodeEntryMinRank4` smallint unsigned NOT NULL DEFAULT '0', + `TraitNodeEntryMaxRank1` smallint unsigned NOT NULL DEFAULT '0', + `TraitNodeEntryMaxRank2` smallint unsigned NOT NULL DEFAULT '0', + `TraitNodeEntryMaxRank3` smallint unsigned NOT NULL DEFAULT '0', + `TraitNodeEntryMaxRank4` smallint unsigned NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`VerifiedBuild`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -5616,9 +5733,9 @@ DROP TABLE IF EXISTS `power_type`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `power_type` ( - `ID` int unsigned NOT NULL DEFAULT '0', `NameGlobalStringTag` text COLLATE utf8mb4_unicode_ci, `CostGlobalStringTag` text COLLATE utf8mb4_unicode_ci, + `ID` int unsigned NOT NULL DEFAULT '0', `PowerTypeEnum` tinyint NOT NULL DEFAULT '0', `MinPower` int NOT NULL DEFAULT '0', `MaxBasePower` int NOT NULL DEFAULT '0', @@ -6102,6 +6219,119 @@ CREATE TABLE `reward_pack_x_item` ( /*!40101 SET character_set_client = @saved_cs_client */; -- +-- Table structure for table `scaling_stat_distribution` +-- + +DROP TABLE IF EXISTS `scaling_stat_distribution`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!50503 SET character_set_client = utf8mb4 */; +CREATE TABLE `scaling_stat_distribution` ( + `ID` int unsigned NOT NULL DEFAULT '0', + `PlayerLevelToItemLevelCurveID` smallint unsigned NOT NULL DEFAULT '0', + `Minlevel` int NOT NULL DEFAULT '0', + `Maxlevel` int NOT NULL DEFAULT '0', + `Bonus1` int NOT NULL DEFAULT '0', + `Bonus2` int NOT NULL DEFAULT '0', + `Bonus3` int NOT NULL DEFAULT '0', + `Bonus4` int NOT NULL DEFAULT '0', + `Bonus5` int NOT NULL DEFAULT '0', + `Bonus6` int NOT NULL DEFAULT '0', + `Bonus7` int NOT NULL DEFAULT '0', + `Bonus8` int NOT NULL DEFAULT '0', + `Bonus9` int NOT NULL DEFAULT '0', + `Bonus10` int NOT NULL DEFAULT '0', + `StatID1` int NOT NULL DEFAULT '0', + `StatID2` int NOT NULL DEFAULT '0', + `StatID3` int NOT NULL DEFAULT '0', + `StatID4` int NOT NULL DEFAULT '0', + `StatID5` int NOT NULL DEFAULT '0', + `StatID6` int NOT NULL DEFAULT '0', + `StatID7` int NOT NULL DEFAULT '0', + `StatID8` int NOT NULL DEFAULT '0', + `StatID9` int NOT NULL DEFAULT '0', + `StatID10` int 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 `scaling_stat_values` +-- + +DROP TABLE IF EXISTS `scaling_stat_values`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!50503 SET character_set_client = utf8mb4 */; +CREATE TABLE `scaling_stat_values` ( + `ID` int unsigned NOT NULL DEFAULT '0', + `Charlevel` int NOT NULL DEFAULT '0', + `WeaponDPS1H` int NOT NULL DEFAULT '0', + `WeaponDPS2H` int NOT NULL DEFAULT '0', + `SpellcasterDPS1H` int NOT NULL DEFAULT '0', + `SpellcasterDPS2H` int NOT NULL DEFAULT '0', + `RangedDPS` int NOT NULL DEFAULT '0', + `WandDPS` int NOT NULL DEFAULT '0', + `SpellPower` int NOT NULL DEFAULT '0', + `BudgetPrimary` int NOT NULL DEFAULT '0', + `BudgetSecondary` int NOT NULL DEFAULT '0', + `BudgetTertiary` int NOT NULL DEFAULT '0', + `BudgetSub` int NOT NULL DEFAULT '0', + `BudgetTrivial` int NOT NULL DEFAULT '0', + `ClothCloakArmor` int NOT NULL DEFAULT '0', + `Unk440_0` int NOT NULL DEFAULT '0', + `Unk440_1` int NOT NULL DEFAULT '0', + `Unk440_2` int NOT NULL DEFAULT '0', + `Unk440_3` int NOT NULL DEFAULT '0', + `Unk440_4` int NOT NULL DEFAULT '0', + `Unk440_5` int NOT NULL DEFAULT '0', + `Unk440_6` int NOT NULL DEFAULT '0', + `Unk440_7` int NOT NULL DEFAULT '0', + `Unk440_8` int NOT NULL DEFAULT '0', + `Unk440_9` int NOT NULL DEFAULT '0', + `Unk440_10` int NOT NULL DEFAULT '0', + `Unk440_11` int NOT NULL DEFAULT '0', + `Unk440_12` int NOT NULL DEFAULT '0', + `Unk440_13` int NOT NULL DEFAULT '0', + `Unk440_14` int NOT NULL DEFAULT '0', + `Unk440_15` int NOT NULL DEFAULT '0', + `ShoulderArmor1` int NOT NULL DEFAULT '0', + `ShoulderArmor2` int NOT NULL DEFAULT '0', + `ShoulderArmor3` int NOT NULL DEFAULT '0', + `ShoulderArmor4` int NOT NULL DEFAULT '0', + `ChestArmor1` int NOT NULL DEFAULT '0', + `ChestArmor2` int NOT NULL DEFAULT '0', + `ChestArmor3` int NOT NULL DEFAULT '0', + `ChestArmor4` int NOT NULL DEFAULT '0', + `HeadArmor1` int NOT NULL DEFAULT '0', + `HeadArmor2` int NOT NULL DEFAULT '0', + `HeadArmor3` int NOT NULL DEFAULT '0', + `HeadArmor4` int NOT NULL DEFAULT '0', + `LegsArmor1` int NOT NULL DEFAULT '0', + `LegsArmor2` int NOT NULL DEFAULT '0', + `LegsArmor3` int NOT NULL DEFAULT '0', + `LegsArmor4` int NOT NULL DEFAULT '0', + `FeetArmor1` int NOT NULL DEFAULT '0', + `FeetArmor2` int NOT NULL DEFAULT '0', + `FeetArmor3` int NOT NULL DEFAULT '0', + `FeetArmor4` int NOT NULL DEFAULT '0', + `WaistArmor1` int NOT NULL DEFAULT '0', + `WaistArmor2` int NOT NULL DEFAULT '0', + `WaistArmor3` int NOT NULL DEFAULT '0', + `WaistArmor4` int NOT NULL DEFAULT '0', + `HandsArmor1` int NOT NULL DEFAULT '0', + `HandsArmor2` int NOT NULL DEFAULT '0', + `HandsArmor3` int NOT NULL DEFAULT '0', + `HandsArmor4` int NOT NULL DEFAULT '0', + `WristsArmor1` int NOT NULL DEFAULT '0', + `WristsArmor2` int NOT NULL DEFAULT '0', + `WristsArmor3` int NOT NULL DEFAULT '0', + `WristsArmor4` int 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 `scenario` -- @@ -6155,12 +6385,12 @@ DROP TABLE IF EXISTS `scenario_step`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `scenario_step` ( - `ID` int unsigned NOT NULL DEFAULT '0', `Description` text COLLATE utf8mb4_unicode_ci, `Title` text COLLATE utf8mb4_unicode_ci, + `ID` int unsigned NOT NULL DEFAULT '0', `ScenarioID` smallint unsigned NOT NULL DEFAULT '0', `CriteriatreeID` int unsigned NOT NULL DEFAULT '0', - `RewardQuestID` int unsigned NOT NULL DEFAULT '0', + `RewardQuestID` int NOT NULL DEFAULT '0', `RelatedStep` int NOT NULL DEFAULT '0', `Supersedes` smallint unsigned NOT NULL DEFAULT '0', `OrderIndex` tinyint unsigned NOT NULL DEFAULT '0', @@ -8552,6 +8782,7 @@ CREATE TABLE `vignette` ( `MinHeight` float NOT NULL DEFAULT '0', `VignetteType` tinyint NOT NULL DEFAULT '0', `RewardQuestID` int NOT NULL DEFAULT '0', + `Unknown1156` tinyint NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`VerifiedBuild`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -8716,4 +8947,4 @@ CREATE TABLE `world_state_expression` ( /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2025-02-13 16:46:04 +-- Dump completed on 2025-05-11 10:42:38 diff --git a/sql/base/dev/world_database.sql b/sql/base/dev/world_database.sql index 0ed81c014ab..e18bb3afe38 100644 --- a/sql/base/dev/world_database.sql +++ b/sql/base/dev/world_database.sql @@ -2136,6 +2136,22 @@ CREATE TABLE `item_random_bonus_list_template` ( /*!40101 SET character_set_client = @saved_cs_client */; -- +-- Table structure for table `item_random_enchantment_template` +-- + +DROP TABLE IF EXISTS `item_random_enchantment_template`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!50503 SET character_set_client = utf8mb4 */; +CREATE TABLE `item_random_enchantment_template` ( + `Id` int unsigned NOT NULL DEFAULT '0', + `EnchantmentType` tinyint unsigned NOT NULL, + `EnchantmentId` int unsigned NOT NULL DEFAULT '0', + `Chance` float NOT NULL DEFAULT '0', + PRIMARY KEY (`Id`,`EnchantmentType`,`EnchantmentId`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- -- Table structure for table `item_script_names` -- @@ -4961,4 +4977,4 @@ CREATE TABLE `world_state` ( /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2025-02-13 16:46:02 +-- Dump completed on 2025-05-11 10:42:36 diff --git a/sql/updates/auth/cata_classic/2025_02_13_00_auth.sql b/sql/old/4.4.x/auth/25021_2025_05_11/2025_02_13_00_auth.sql index c4b0c0180ac..c4b0c0180ac 100644 --- a/sql/updates/auth/cata_classic/2025_02_13_00_auth.sql +++ b/sql/old/4.4.x/auth/25021_2025_05_11/2025_02_13_00_auth.sql diff --git a/sql/updates/auth/cata_classic/2025_02_19_01_auth.sql b/sql/old/4.4.x/auth/25021_2025_05_11/2025_02_19_01_auth.sql index 07931000574..07931000574 100644 --- a/sql/updates/auth/cata_classic/2025_02_19_01_auth.sql +++ b/sql/old/4.4.x/auth/25021_2025_05_11/2025_02_19_01_auth.sql diff --git a/sql/updates/auth/cata_classic/2025_02_20_00_auth.sql b/sql/old/4.4.x/auth/25021_2025_05_11/2025_02_20_00_auth.sql index 7f9a968fa17..7f9a968fa17 100644 --- a/sql/updates/auth/cata_classic/2025_02_20_00_auth.sql +++ b/sql/old/4.4.x/auth/25021_2025_05_11/2025_02_20_00_auth.sql diff --git a/sql/updates/auth/cata_classic/2025_04_05_00_auth.sql b/sql/old/4.4.x/auth/25021_2025_05_11/2025_04_05_00_auth.sql index bcc41ed03e0..bcc41ed03e0 100644 --- a/sql/updates/auth/cata_classic/2025_04_05_00_auth.sql +++ b/sql/old/4.4.x/auth/25021_2025_05_11/2025_04_05_00_auth.sql diff --git a/sql/updates/auth/cata_classic/2025_04_06_00_auth.sql b/sql/old/4.4.x/auth/25021_2025_05_11/2025_04_06_00_auth.sql index a317fba72b4..a317fba72b4 100644 --- a/sql/updates/auth/cata_classic/2025_04_06_00_auth.sql +++ b/sql/old/4.4.x/auth/25021_2025_05_11/2025_04_06_00_auth.sql diff --git a/sql/updates/auth/cata_classic/2025_04_09_01_auth.sql b/sql/old/4.4.x/auth/25021_2025_05_11/2025_04_09_01_auth.sql index 78e39395658..78e39395658 100644 --- a/sql/updates/auth/cata_classic/2025_04_09_01_auth.sql +++ b/sql/old/4.4.x/auth/25021_2025_05_11/2025_04_09_01_auth.sql diff --git a/sql/updates/characters/cata_classic/2025_02_13_00_characters.sql b/sql/old/4.4.x/characters/25021_2025_05_11/2025_02_13_00_characters.sql index 75db35cd2d6..75db35cd2d6 100644 --- a/sql/updates/characters/cata_classic/2025_02_13_00_characters.sql +++ b/sql/old/4.4.x/characters/25021_2025_05_11/2025_02_13_00_characters.sql diff --git a/sql/updates/characters/cata_classic/2025_04_15_00_characters.sql b/sql/old/4.4.x/characters/25021_2025_05_11/2025_04_15_00_characters.sql index 964c3f7e24c..964c3f7e24c 100644 --- a/sql/updates/characters/cata_classic/2025_04_15_00_characters.sql +++ b/sql/old/4.4.x/characters/25021_2025_05_11/2025_04_15_00_characters.sql diff --git a/sql/updates/hotfixes/cata_classic/2025_02_13_00_hotfixes.sql b/sql/old/4.4.x/hotfixes/25021_2025_05_11/2025_02_13_00_hotfixes.sql index a9fb842a304..a9fb842a304 100644 --- a/sql/updates/hotfixes/cata_classic/2025_02_13_00_hotfixes.sql +++ b/sql/old/4.4.x/hotfixes/25021_2025_05_11/2025_02_13_00_hotfixes.sql diff --git a/sql/updates/hotfixes/cata_classic/2025_02_23_00_hotfixes.sql b/sql/old/4.4.x/hotfixes/25021_2025_05_11/2025_02_23_00_hotfixes.sql index 20b05c7aac2..20b05c7aac2 100644 --- a/sql/updates/hotfixes/cata_classic/2025_02_23_00_hotfixes.sql +++ b/sql/old/4.4.x/hotfixes/25021_2025_05_11/2025_02_23_00_hotfixes.sql diff --git a/sql/updates/hotfixes/cata_classic/2025_04_11_00_hotfixes.sql b/sql/old/4.4.x/hotfixes/25021_2025_05_11/2025_04_11_00_hotfixes.sql index 0cab817f6c0..0cab817f6c0 100644 --- a/sql/updates/hotfixes/cata_classic/2025_04_11_00_hotfixes.sql +++ b/sql/old/4.4.x/hotfixes/25021_2025_05_11/2025_04_11_00_hotfixes.sql diff --git a/sql/updates/hotfixes/cata_classic/2025_04_11_01_hotfixes.sql b/sql/old/4.4.x/hotfixes/25021_2025_05_11/2025_04_11_01_hotfixes.sql index 5d9656dcedb..5d9656dcedb 100644 --- a/sql/updates/hotfixes/cata_classic/2025_04_11_01_hotfixes.sql +++ b/sql/old/4.4.x/hotfixes/25021_2025_05_11/2025_04_11_01_hotfixes.sql diff --git a/sql/updates/hotfixes/cata_classic/2025_04_13_00_hotfixes.sql b/sql/old/4.4.x/hotfixes/25021_2025_05_11/2025_04_13_00_hotfixes.sql index 4edca4a323a..4edca4a323a 100644 --- a/sql/updates/hotfixes/cata_classic/2025_04_13_00_hotfixes.sql +++ b/sql/old/4.4.x/hotfixes/25021_2025_05_11/2025_04_13_00_hotfixes.sql diff --git a/sql/updates/hotfixes/cata_classic/2025_04_13_01_hotfixes.sql b/sql/old/4.4.x/hotfixes/25021_2025_05_11/2025_04_13_01_hotfixes.sql index 4e7ca9719b0..4e7ca9719b0 100644 --- a/sql/updates/hotfixes/cata_classic/2025_04_13_01_hotfixes.sql +++ b/sql/old/4.4.x/hotfixes/25021_2025_05_11/2025_04_13_01_hotfixes.sql diff --git a/sql/updates/hotfixes/cata_classic/2025_04_13_02_hotfixes.sql b/sql/old/4.4.x/hotfixes/25021_2025_05_11/2025_04_13_02_hotfixes.sql index 2434a791181..2434a791181 100644 --- a/sql/updates/hotfixes/cata_classic/2025_04_13_02_hotfixes.sql +++ b/sql/old/4.4.x/hotfixes/25021_2025_05_11/2025_04_13_02_hotfixes.sql diff --git a/sql/updates/hotfixes/cata_classic/2025_04_13_03_hotfixes.sql b/sql/old/4.4.x/hotfixes/25021_2025_05_11/2025_04_13_03_hotfixes.sql index 59b0f1ccd0e..59b0f1ccd0e 100644 --- a/sql/updates/hotfixes/cata_classic/2025_04_13_03_hotfixes.sql +++ b/sql/old/4.4.x/hotfixes/25021_2025_05_11/2025_04_13_03_hotfixes.sql diff --git a/sql/updates/hotfixes/cata_classic/2025_04_13_04_hotfixes.sql b/sql/old/4.4.x/hotfixes/25021_2025_05_11/2025_04_13_04_hotfixes.sql index a3d95f0797c..a3d95f0797c 100644 --- a/sql/updates/hotfixes/cata_classic/2025_04_13_04_hotfixes.sql +++ b/sql/old/4.4.x/hotfixes/25021_2025_05_11/2025_04_13_04_hotfixes.sql diff --git a/sql/updates/hotfixes/cata_classic/2025_04_13_05_hotfixes.sql b/sql/old/4.4.x/hotfixes/25021_2025_05_11/2025_04_13_05_hotfixes.sql index 595416dc43e..595416dc43e 100644 --- a/sql/updates/hotfixes/cata_classic/2025_04_13_05_hotfixes.sql +++ b/sql/old/4.4.x/hotfixes/25021_2025_05_11/2025_04_13_05_hotfixes.sql diff --git a/sql/updates/hotfixes/cata_classic/2025_04_13_06_hotfixes.sql b/sql/old/4.4.x/hotfixes/25021_2025_05_11/2025_04_13_06_hotfixes.sql index eb50889cdb6..eb50889cdb6 100644 --- a/sql/updates/hotfixes/cata_classic/2025_04_13_06_hotfixes.sql +++ b/sql/old/4.4.x/hotfixes/25021_2025_05_11/2025_04_13_06_hotfixes.sql diff --git a/sql/updates/hotfixes/cata_classic/2025_04_13_07_hotfixes.sql b/sql/old/4.4.x/hotfixes/25021_2025_05_11/2025_04_13_07_hotfixes.sql index 600a0821064..600a0821064 100644 --- a/sql/updates/hotfixes/cata_classic/2025_04_13_07_hotfixes.sql +++ b/sql/old/4.4.x/hotfixes/25021_2025_05_11/2025_04_13_07_hotfixes.sql diff --git a/sql/updates/hotfixes/cata_classic/2025_04_15_00_hotfixes.sql b/sql/old/4.4.x/hotfixes/25021_2025_05_11/2025_04_15_00_hotfixes.sql index 885398b04fd..885398b04fd 100644 --- a/sql/updates/hotfixes/cata_classic/2025_04_15_00_hotfixes.sql +++ b/sql/old/4.4.x/hotfixes/25021_2025_05_11/2025_04_15_00_hotfixes.sql diff --git a/sql/updates/world/cata_classic/2025_02_13_00_world.sql b/sql/old/4.4.x/world/25021_2025_05_11/2025_02_13_00_world.sql index b844228a2cd..b844228a2cd 100644 --- a/sql/updates/world/cata_classic/2025_02_13_00_world.sql +++ b/sql/old/4.4.x/world/25021_2025_05_11/2025_02_13_00_world.sql diff --git a/sql/updates/world/cata_classic/2025_04_05_00_world.sql b/sql/old/4.4.x/world/25021_2025_05_11/2025_04_05_00_world.sql index e9899a5a60b..e9899a5a60b 100644 --- a/sql/updates/world/cata_classic/2025_04_05_00_world.sql +++ b/sql/old/4.4.x/world/25021_2025_05_11/2025_04_05_00_world.sql diff --git a/sql/updates/world/cata_classic/2025_04_05_01_world.sql b/sql/old/4.4.x/world/25021_2025_05_11/2025_04_05_01_world.sql index 4fb9cde40c1..4fb9cde40c1 100644 --- a/sql/updates/world/cata_classic/2025_04_05_01_world.sql +++ b/sql/old/4.4.x/world/25021_2025_05_11/2025_04_05_01_world.sql diff --git a/sql/updates/world/cata_classic/2025_04_05_02_world.sql b/sql/old/4.4.x/world/25021_2025_05_11/2025_04_05_02_world.sql index b9499d24ceb..b9499d24ceb 100644 --- a/sql/updates/world/cata_classic/2025_04_05_02_world.sql +++ b/sql/old/4.4.x/world/25021_2025_05_11/2025_04_05_02_world.sql diff --git a/sql/updates/world/cata_classic/2025_04_08_00_world.sql b/sql/old/4.4.x/world/25021_2025_05_11/2025_04_08_00_world.sql index c541197d478..c541197d478 100644 --- a/sql/updates/world/cata_classic/2025_04_08_00_world.sql +++ b/sql/old/4.4.x/world/25021_2025_05_11/2025_04_08_00_world.sql diff --git a/sql/updates/world/cata_classic/2025_04_12_00_world.sql b/sql/old/4.4.x/world/25021_2025_05_11/2025_04_12_00_world.sql index 67ecfcf7922..67ecfcf7922 100644 --- a/sql/updates/world/cata_classic/2025_04_12_00_world.sql +++ b/sql/old/4.4.x/world/25021_2025_05_11/2025_04_12_00_world.sql diff --git a/sql/updates/world/cata_classic/2025_04_12_01_world.sql b/sql/old/4.4.x/world/25021_2025_05_11/2025_04_12_01_world.sql index c5dc1d1c906..c5dc1d1c906 100644 --- a/sql/updates/world/cata_classic/2025_04_12_01_world.sql +++ b/sql/old/4.4.x/world/25021_2025_05_11/2025_04_12_01_world.sql diff --git a/sql/updates/world/cata_classic/2025_04_12_02_world.sql b/sql/old/4.4.x/world/25021_2025_05_11/2025_04_12_02_world.sql index 4e0453f8694..4e0453f8694 100644 --- a/sql/updates/world/cata_classic/2025_04_12_02_world.sql +++ b/sql/old/4.4.x/world/25021_2025_05_11/2025_04_12_02_world.sql diff --git a/sql/updates/world/cata_classic/2025_04_12_03_world.sql b/sql/old/4.4.x/world/25021_2025_05_11/2025_04_12_03_world.sql index c91bb37faa2..c91bb37faa2 100644 --- a/sql/updates/world/cata_classic/2025_04_12_03_world.sql +++ b/sql/old/4.4.x/world/25021_2025_05_11/2025_04_12_03_world.sql diff --git a/sql/updates/world/cata_classic/2025_04_12_04_world.sql b/sql/old/4.4.x/world/25021_2025_05_11/2025_04_12_04_world.sql index c3d291dbed7..c3d291dbed7 100644 --- a/sql/updates/world/cata_classic/2025_04_12_04_world.sql +++ b/sql/old/4.4.x/world/25021_2025_05_11/2025_04_12_04_world.sql diff --git a/sql/updates/world/cata_classic/2025_04_12_05_world.sql b/sql/old/4.4.x/world/25021_2025_05_11/2025_04_12_05_world.sql index b4ba41fcb23..b4ba41fcb23 100644 --- a/sql/updates/world/cata_classic/2025_04_12_05_world.sql +++ b/sql/old/4.4.x/world/25021_2025_05_11/2025_04_12_05_world.sql diff --git a/sql/updates/world/cata_classic/2025_04_12_06_world.sql b/sql/old/4.4.x/world/25021_2025_05_11/2025_04_12_06_world.sql index 9e17b11b1c4..9e17b11b1c4 100644 --- a/sql/updates/world/cata_classic/2025_04_12_06_world.sql +++ b/sql/old/4.4.x/world/25021_2025_05_11/2025_04_12_06_world.sql diff --git a/sql/updates/world/cata_classic/2025_04_12_07_world_2025_04_12_02_world.sql b/sql/old/4.4.x/world/25021_2025_05_11/2025_04_12_07_world_2025_04_12_02_world.sql index a6a3a89ccc0..a6a3a89ccc0 100644 --- a/sql/updates/world/cata_classic/2025_04_12_07_world_2025_04_12_02_world.sql +++ b/sql/old/4.4.x/world/25021_2025_05_11/2025_04_12_07_world_2025_04_12_02_world.sql diff --git a/sql/updates/world/cata_classic/2025_04_12_08_world.sql b/sql/old/4.4.x/world/25021_2025_05_11/2025_04_12_08_world.sql index 78cac37d486..78cac37d486 100644 --- a/sql/updates/world/cata_classic/2025_04_12_08_world.sql +++ b/sql/old/4.4.x/world/25021_2025_05_11/2025_04_12_08_world.sql diff --git a/sql/updates/world/cata_classic/2025_04_12_09_world.sql b/sql/old/4.4.x/world/25021_2025_05_11/2025_04_12_09_world.sql index a82d87589a0..a82d87589a0 100644 --- a/sql/updates/world/cata_classic/2025_04_12_09_world.sql +++ b/sql/old/4.4.x/world/25021_2025_05_11/2025_04_12_09_world.sql diff --git a/sql/updates/world/cata_classic/2025_04_12_10_world.sql b/sql/old/4.4.x/world/25021_2025_05_11/2025_04_12_10_world.sql index 00b73128f0e..00b73128f0e 100644 --- a/sql/updates/world/cata_classic/2025_04_12_10_world.sql +++ b/sql/old/4.4.x/world/25021_2025_05_11/2025_04_12_10_world.sql diff --git a/sql/updates/world/cata_classic/2025_04_12_11_world.sql b/sql/old/4.4.x/world/25021_2025_05_11/2025_04_12_11_world.sql index 9017656381d..9017656381d 100644 --- a/sql/updates/world/cata_classic/2025_04_12_11_world.sql +++ b/sql/old/4.4.x/world/25021_2025_05_11/2025_04_12_11_world.sql diff --git a/sql/updates/world/cata_classic/2025_04_12_12_world.sql b/sql/old/4.4.x/world/25021_2025_05_11/2025_04_12_12_world.sql index b7de430970d..b7de430970d 100644 --- a/sql/updates/world/cata_classic/2025_04_12_12_world.sql +++ b/sql/old/4.4.x/world/25021_2025_05_11/2025_04_12_12_world.sql diff --git a/sql/updates/world/cata_classic/2025_04_12_13_world.sql b/sql/old/4.4.x/world/25021_2025_05_11/2025_04_12_13_world.sql index 91cccaa8f8c..91cccaa8f8c 100644 --- a/sql/updates/world/cata_classic/2025_04_12_13_world.sql +++ b/sql/old/4.4.x/world/25021_2025_05_11/2025_04_12_13_world.sql diff --git a/sql/updates/world/cata_classic/2025_04_12_14_world.sql b/sql/old/4.4.x/world/25021_2025_05_11/2025_04_12_14_world.sql index aa51ece13ae..aa51ece13ae 100644 --- a/sql/updates/world/cata_classic/2025_04_12_14_world.sql +++ b/sql/old/4.4.x/world/25021_2025_05_11/2025_04_12_14_world.sql diff --git a/sql/updates/world/cata_classic/2025_04_13_00_world.sql b/sql/old/4.4.x/world/25021_2025_05_11/2025_04_13_00_world.sql index 11b1f5b0c1a..11b1f5b0c1a 100644 --- a/sql/updates/world/cata_classic/2025_04_13_00_world.sql +++ b/sql/old/4.4.x/world/25021_2025_05_11/2025_04_13_00_world.sql diff --git a/sql/updates/world/cata_classic/2025_04_13_01_world.sql b/sql/old/4.4.x/world/25021_2025_05_11/2025_04_13_01_world.sql index 01d536804e0..01d536804e0 100644 --- a/sql/updates/world/cata_classic/2025_04_13_01_world.sql +++ b/sql/old/4.4.x/world/25021_2025_05_11/2025_04_13_01_world.sql diff --git a/sql/updates/world/cata_classic/2025_04_13_02_world.sql b/sql/old/4.4.x/world/25021_2025_05_11/2025_04_13_02_world.sql index 0a3c86558c6..0a3c86558c6 100644 --- a/sql/updates/world/cata_classic/2025_04_13_02_world.sql +++ b/sql/old/4.4.x/world/25021_2025_05_11/2025_04_13_02_world.sql diff --git a/sql/updates/world/cata_classic/2025_04_13_03_world.sql b/sql/old/4.4.x/world/25021_2025_05_11/2025_04_13_03_world.sql index 718045a351c..718045a351c 100644 --- a/sql/updates/world/cata_classic/2025_04_13_03_world.sql +++ b/sql/old/4.4.x/world/25021_2025_05_11/2025_04_13_03_world.sql diff --git a/sql/updates/world/cata_classic/2025_04_13_04_world.sql b/sql/old/4.4.x/world/25021_2025_05_11/2025_04_13_04_world.sql index 40467751e6d..40467751e6d 100644 --- a/sql/updates/world/cata_classic/2025_04_13_04_world.sql +++ b/sql/old/4.4.x/world/25021_2025_05_11/2025_04_13_04_world.sql diff --git a/sql/updates/world/cata_classic/2025_04_13_05_world.sql b/sql/old/4.4.x/world/25021_2025_05_11/2025_04_13_05_world.sql index 5595191965b..5595191965b 100644 --- a/sql/updates/world/cata_classic/2025_04_13_05_world.sql +++ b/sql/old/4.4.x/world/25021_2025_05_11/2025_04_13_05_world.sql diff --git a/sql/updates/world/cata_classic/2025_04_13_06_world.sql b/sql/old/4.4.x/world/25021_2025_05_11/2025_04_13_06_world.sql index 38dccdd23b6..38dccdd23b6 100644 --- a/sql/updates/world/cata_classic/2025_04_13_06_world.sql +++ b/sql/old/4.4.x/world/25021_2025_05_11/2025_04_13_06_world.sql diff --git a/sql/updates/world/cata_classic/2025_04_13_07_world.sql b/sql/old/4.4.x/world/25021_2025_05_11/2025_04_13_07_world.sql index 87286e01c55..87286e01c55 100644 --- a/sql/updates/world/cata_classic/2025_04_13_07_world.sql +++ b/sql/old/4.4.x/world/25021_2025_05_11/2025_04_13_07_world.sql diff --git a/sql/updates/world/cata_classic/2025_04_13_08_world.sql b/sql/old/4.4.x/world/25021_2025_05_11/2025_04_13_08_world.sql index 60d8d552831..60d8d552831 100644 --- a/sql/updates/world/cata_classic/2025_04_13_08_world.sql +++ b/sql/old/4.4.x/world/25021_2025_05_11/2025_04_13_08_world.sql diff --git a/sql/updates/world/cata_classic/2025_04_13_09_world.sql b/sql/old/4.4.x/world/25021_2025_05_11/2025_04_13_09_world.sql index d2c93f299bb..d2c93f299bb 100644 --- a/sql/updates/world/cata_classic/2025_04_13_09_world.sql +++ b/sql/old/4.4.x/world/25021_2025_05_11/2025_04_13_09_world.sql diff --git a/sql/updates/world/cata_classic/2025_04_14_00_world.sql b/sql/old/4.4.x/world/25021_2025_05_11/2025_04_14_00_world.sql index 08ebc34915f..08ebc34915f 100644 --- a/sql/updates/world/cata_classic/2025_04_14_00_world.sql +++ b/sql/old/4.4.x/world/25021_2025_05_11/2025_04_14_00_world.sql diff --git a/sql/updates/world/cata_classic/2025_04_14_01_world.sql b/sql/old/4.4.x/world/25021_2025_05_11/2025_04_14_01_world.sql index 566d66b9119..566d66b9119 100644 --- a/sql/updates/world/cata_classic/2025_04_14_01_world.sql +++ b/sql/old/4.4.x/world/25021_2025_05_11/2025_04_14_01_world.sql diff --git a/sql/updates/world/cata_classic/2025_04_14_02_world.sql b/sql/old/4.4.x/world/25021_2025_05_11/2025_04_14_02_world.sql index 9eb1cfde883..9eb1cfde883 100644 --- a/sql/updates/world/cata_classic/2025_04_14_02_world.sql +++ b/sql/old/4.4.x/world/25021_2025_05_11/2025_04_14_02_world.sql diff --git a/sql/updates/world/cata_classic/2025_04_14_03_world.sql b/sql/old/4.4.x/world/25021_2025_05_11/2025_04_14_03_world.sql index 046eef14e47..046eef14e47 100644 --- a/sql/updates/world/cata_classic/2025_04_14_03_world.sql +++ b/sql/old/4.4.x/world/25021_2025_05_11/2025_04_14_03_world.sql diff --git a/sql/updates/world/cata_classic/2025_04_14_04_world.sql b/sql/old/4.4.x/world/25021_2025_05_11/2025_04_14_04_world.sql index 411f9d8016e..411f9d8016e 100644 --- a/sql/updates/world/cata_classic/2025_04_14_04_world.sql +++ b/sql/old/4.4.x/world/25021_2025_05_11/2025_04_14_04_world.sql diff --git a/sql/updates/world/cata_classic/2025_04_14_05_world.sql b/sql/old/4.4.x/world/25021_2025_05_11/2025_04_14_05_world.sql index 4909c8dbef6..4909c8dbef6 100644 --- a/sql/updates/world/cata_classic/2025_04_14_05_world.sql +++ b/sql/old/4.4.x/world/25021_2025_05_11/2025_04_14_05_world.sql diff --git a/sql/updates/world/cata_classic/2025_04_14_06_world.sql b/sql/old/4.4.x/world/25021_2025_05_11/2025_04_14_06_world.sql index ed338739198..ed338739198 100644 --- a/sql/updates/world/cata_classic/2025_04_14_06_world.sql +++ b/sql/old/4.4.x/world/25021_2025_05_11/2025_04_14_06_world.sql diff --git a/sql/updates/world/cata_classic/2025_04_14_07_world.sql b/sql/old/4.4.x/world/25021_2025_05_11/2025_04_14_07_world.sql index 5cba740bbc8..5cba740bbc8 100644 --- a/sql/updates/world/cata_classic/2025_04_14_07_world.sql +++ b/sql/old/4.4.x/world/25021_2025_05_11/2025_04_14_07_world.sql diff --git a/sql/updates/world/cata_classic/2025_04_15_00_world.sql b/sql/old/4.4.x/world/25021_2025_05_11/2025_04_15_00_world.sql index 7d78a774157..7d78a774157 100644 --- a/sql/updates/world/cata_classic/2025_04_15_00_world.sql +++ b/sql/old/4.4.x/world/25021_2025_05_11/2025_04_15_00_world.sql diff --git a/sql/updates/world/cata_classic/2025_04_15_01_world.sql b/sql/old/4.4.x/world/25021_2025_05_11/2025_04_15_01_world.sql index f5c13c76ab2..f5c13c76ab2 100644 --- a/sql/updates/world/cata_classic/2025_04_15_01_world.sql +++ b/sql/old/4.4.x/world/25021_2025_05_11/2025_04_15_01_world.sql diff --git a/sql/updates/world/cata_classic/2025_04_15_02_world.sql b/sql/old/4.4.x/world/25021_2025_05_11/2025_04_15_02_world.sql index d57fe51376e..d57fe51376e 100644 --- a/sql/updates/world/cata_classic/2025_04_15_02_world.sql +++ b/sql/old/4.4.x/world/25021_2025_05_11/2025_04_15_02_world.sql diff --git a/sql/updates/world/cata_classic/2025_04_15_03_world.sql b/sql/old/4.4.x/world/25021_2025_05_11/2025_04_15_03_world.sql index 240ba3b1fe2..240ba3b1fe2 100644 --- a/sql/updates/world/cata_classic/2025_04_15_03_world.sql +++ b/sql/old/4.4.x/world/25021_2025_05_11/2025_04_15_03_world.sql diff --git a/sql/updates/world/cata_classic/2025_04_15_04_world.sql b/sql/old/4.4.x/world/25021_2025_05_11/2025_04_15_04_world.sql index 7bb6acb053b..7bb6acb053b 100644 --- a/sql/updates/world/cata_classic/2025_04_15_04_world.sql +++ b/sql/old/4.4.x/world/25021_2025_05_11/2025_04_15_04_world.sql diff --git a/sql/updates/world/cata_classic/2025_04_15_05_world.sql b/sql/old/4.4.x/world/25021_2025_05_11/2025_04_15_05_world.sql index e00cf15cecd..e00cf15cecd 100644 --- a/sql/updates/world/cata_classic/2025_04_15_05_world.sql +++ b/sql/old/4.4.x/world/25021_2025_05_11/2025_04_15_05_world.sql diff --git a/sql/updates/world/cata_classic/2025_04_16_00_world.sql b/sql/old/4.4.x/world/25021_2025_05_11/2025_04_16_00_world.sql index c26e6f2c4c6..c26e6f2c4c6 100644 --- a/sql/updates/world/cata_classic/2025_04_16_00_world.sql +++ b/sql/old/4.4.x/world/25021_2025_05_11/2025_04_16_00_world.sql diff --git a/sql/updates/world/cata_classic/2025_04_16_01_world.sql b/sql/old/4.4.x/world/25021_2025_05_11/2025_04_16_01_world.sql index 338dea6e092..338dea6e092 100644 --- a/sql/updates/world/cata_classic/2025_04_16_01_world.sql +++ b/sql/old/4.4.x/world/25021_2025_05_11/2025_04_16_01_world.sql diff --git a/sql/updates/world/cata_classic/2025_04_16_02_world.sql b/sql/old/4.4.x/world/25021_2025_05_11/2025_04_16_02_world.sql index e22d975e8f3..e22d975e8f3 100644 --- a/sql/updates/world/cata_classic/2025_04_16_02_world.sql +++ b/sql/old/4.4.x/world/25021_2025_05_11/2025_04_16_02_world.sql diff --git a/sql/updates/world/cata_classic/2025_04_16_03_world.sql b/sql/old/4.4.x/world/25021_2025_05_11/2025_04_16_03_world.sql index 6b53f56bc80..6b53f56bc80 100644 --- a/sql/updates/world/cata_classic/2025_04_16_03_world.sql +++ b/sql/old/4.4.x/world/25021_2025_05_11/2025_04_16_03_world.sql diff --git a/sql/updates/world/cata_classic/2025_04_16_04_world.sql b/sql/old/4.4.x/world/25021_2025_05_11/2025_04_16_04_world.sql index 39ce057b7aa..39ce057b7aa 100644 --- a/sql/updates/world/cata_classic/2025_04_16_04_world.sql +++ b/sql/old/4.4.x/world/25021_2025_05_11/2025_04_16_04_world.sql diff --git a/sql/updates/world/cata_classic/2025_04_16_05_world.sql b/sql/old/4.4.x/world/25021_2025_05_11/2025_04_16_05_world.sql index c01b53805dc..c01b53805dc 100644 --- a/sql/updates/world/cata_classic/2025_04_16_05_world.sql +++ b/sql/old/4.4.x/world/25021_2025_05_11/2025_04_16_05_world.sql diff --git a/sql/updates/world/cata_classic/2025_04_16_06_world.sql b/sql/old/4.4.x/world/25021_2025_05_11/2025_04_16_06_world.sql index 785b8684aae..785b8684aae 100644 --- a/sql/updates/world/cata_classic/2025_04_16_06_world.sql +++ b/sql/old/4.4.x/world/25021_2025_05_11/2025_04_16_06_world.sql diff --git a/sql/updates/world/cata_classic/2025_04_16_07_world.sql b/sql/old/4.4.x/world/25021_2025_05_11/2025_04_16_07_world.sql index ba8d1e23525..ba8d1e23525 100644 --- a/sql/updates/world/cata_classic/2025_04_16_07_world.sql +++ b/sql/old/4.4.x/world/25021_2025_05_11/2025_04_16_07_world.sql diff --git a/sql/updates/world/cata_classic/2025_04_16_08_world.sql b/sql/old/4.4.x/world/25021_2025_05_11/2025_04_16_08_world.sql index 1d119d6c306..1d119d6c306 100644 --- a/sql/updates/world/cata_classic/2025_04_16_08_world.sql +++ b/sql/old/4.4.x/world/25021_2025_05_11/2025_04_16_08_world.sql diff --git a/sql/updates/world/cata_classic/2025_04_16_09_world.sql b/sql/old/4.4.x/world/25021_2025_05_11/2025_04_16_09_world.sql index ff1a6f662e7..ff1a6f662e7 100644 --- a/sql/updates/world/cata_classic/2025_04_16_09_world.sql +++ b/sql/old/4.4.x/world/25021_2025_05_11/2025_04_16_09_world.sql diff --git a/sql/updates/world/cata_classic/2025_04_17_00_world.sql b/sql/old/4.4.x/world/25021_2025_05_11/2025_04_17_00_world.sql index 5619477ff98..5619477ff98 100644 --- a/sql/updates/world/cata_classic/2025_04_17_00_world.sql +++ b/sql/old/4.4.x/world/25021_2025_05_11/2025_04_17_00_world.sql diff --git a/sql/updates/world/cata_classic/2025_04_17_01_world.sql b/sql/old/4.4.x/world/25021_2025_05_11/2025_04_17_01_world.sql index 305e9ba411a..305e9ba411a 100644 --- a/sql/updates/world/cata_classic/2025_04_17_01_world.sql +++ b/sql/old/4.4.x/world/25021_2025_05_11/2025_04_17_01_world.sql diff --git a/sql/updates/world/cata_classic/2025_04_18_00_world.sql b/sql/old/4.4.x/world/25021_2025_05_11/2025_04_18_00_world.sql index 66e1de1b5c5..66e1de1b5c5 100644 --- a/sql/updates/world/cata_classic/2025_04_18_00_world.sql +++ b/sql/old/4.4.x/world/25021_2025_05_11/2025_04_18_00_world.sql diff --git a/sql/updates/world/cata_classic/2025_04_18_01_world.sql b/sql/old/4.4.x/world/25021_2025_05_11/2025_04_18_01_world.sql index 1bd59ee2ba4..1bd59ee2ba4 100644 --- a/sql/updates/world/cata_classic/2025_04_18_01_world.sql +++ b/sql/old/4.4.x/world/25021_2025_05_11/2025_04_18_01_world.sql diff --git a/sql/updates/world/cata_classic/2025_05_11_00_world_2025_04_19_01_world.sql b/sql/old/4.4.x/world/25021_2025_05_11/2025_05_11_00_world_2025_04_19_01_world.sql index a164db46d72..a164db46d72 100644 --- a/sql/updates/world/cata_classic/2025_05_11_00_world_2025_04_19_01_world.sql +++ b/sql/old/4.4.x/world/25021_2025_05_11/2025_05_11_00_world_2025_04_19_01_world.sql diff --git a/sql/updates/auth/cata_classic/2025_05_11_00_auth.sql b/sql/updates/auth/cata_classic/2025_05_11_00_auth.sql new file mode 100644 index 00000000000..cb4f95af0d5 --- /dev/null +++ b/sql/updates/auth/cata_classic/2025_05_11_00_auth.sql @@ -0,0 +1,3 @@ +-- TDB 442.25051 auth +UPDATE `updates` SET `state`='ARCHIVED',`speed`=0; +REPLACE INTO `updates_include` (`path`, `state`) VALUES ('$/sql/old/4.4.x/auth', 'ARCHIVED'); diff --git a/sql/updates/characters/cata_classic/2025_05_11_00_characters.sql b/sql/updates/characters/cata_classic/2025_05_11_00_characters.sql new file mode 100644 index 00000000000..43d0904b945 --- /dev/null +++ b/sql/updates/characters/cata_classic/2025_05_11_00_characters.sql @@ -0,0 +1,3 @@ +-- TDB 442.25051 characters +UPDATE `updates` SET `state`='ARCHIVED',`speed`=0; +REPLACE INTO `updates_include` (`path`, `state`) VALUES ('$/sql/old/4.4.x/characters', 'ARCHIVED'); diff --git a/sql/updates/hotfixes/cata_classic/2025_05_11_00_hotfixes.sql b/sql/updates/hotfixes/cata_classic/2025_05_11_00_hotfixes.sql new file mode 100644 index 00000000000..0db893b74a5 --- /dev/null +++ b/sql/updates/hotfixes/cata_classic/2025_05_11_00_hotfixes.sql @@ -0,0 +1,3 @@ +-- TDB 442.25051 hotfixes +UPDATE `updates` SET `state`='ARCHIVED',`speed`=0; +REPLACE INTO `updates_include` (`path`, `state`) VALUES ('$/sql/old/4.4.x/hotfixes', 'ARCHIVED'); diff --git a/sql/updates/world/cata_classic/2025_05_11_01_world.sql b/sql/updates/world/cata_classic/2025_05_11_01_world.sql new file mode 100644 index 00000000000..d83f6870087 --- /dev/null +++ b/sql/updates/world/cata_classic/2025_05_11_01_world.sql @@ -0,0 +1,4 @@ +-- TDB 442.25051 world +UPDATE `version` SET `db_version`='TDB 442.25051', `cache_id`=25051 LIMIT 1; +UPDATE `updates` SET `state`='ARCHIVED',`speed`=0; +REPLACE INTO `updates_include` (`path`, `state`) VALUES ('$/sql/old/4.4.x/world', 'ARCHIVED'); |