aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--revision_data.h.in.cmake4
-rw-r--r--sql/base/auth_database.sql25
-rw-r--r--sql/base/characters_database.sql11
-rw-r--r--sql/base/dev/hotfixes_database.sql184
-rw-r--r--sql/base/dev/world_database.sql14
-rw-r--r--sql/old/11.x/auth/24092_2024_11_16/2024_09_23_00_auth.sql (renamed from sql/updates/auth/master/2024_09_23_00_auth.sql)0
-rw-r--r--sql/old/11.x/auth/24092_2024_11_16/2024_09_26_00_auth.sql (renamed from sql/updates/auth/master/2024_09_26_00_auth.sql)0
-rw-r--r--sql/old/11.x/auth/24092_2024_11_16/2024_10_01_00_auth.sql (renamed from sql/updates/auth/master/2024_10_01_00_auth.sql)0
-rw-r--r--sql/old/11.x/auth/24092_2024_11_16/2024_10_23_00_auth.sql (renamed from sql/updates/auth/master/2024_10_23_00_auth.sql)0
-rw-r--r--sql/old/11.x/auth/24092_2024_11_16/2024_10_23_01_auth.sql (renamed from sql/updates/auth/master/2024_10_23_01_auth.sql)0
-rw-r--r--sql/old/11.x/auth/24092_2024_11_16/2024_10_30_00_auth.sql (renamed from sql/updates/auth/master/2024_10_30_00_auth.sql)0
-rw-r--r--sql/old/11.x/auth/24092_2024_11_16/2024_11_01_00_auth.sql (renamed from sql/updates/auth/master/2024_11_01_00_auth.sql)0
-rw-r--r--sql/old/11.x/auth/24092_2024_11_16/2024_11_11_00_auth.sql (renamed from sql/updates/auth/master/2024_11_11_00_auth.sql)0
-rw-r--r--sql/old/11.x/auth/24092_2024_11_16/2024_11_12_00_auth.sql (renamed from sql/updates/auth/master/2024_11_12_00_auth.sql)0
-rw-r--r--sql/old/11.x/auth/24092_2024_11_16/2024_11_14_00_auth.sql (renamed from sql/updates/auth/master/2024_11_14_00_auth.sql)0
-rw-r--r--sql/old/11.x/characters/24092_2024_11_16/2024_09_23_00_characters.sql (renamed from sql/updates/characters/master/2024_09_23_00_characters.sql)0
-rw-r--r--sql/old/11.x/characters/24092_2024_11_16/2024_10_03_00_characters.sql (renamed from sql/updates/characters/master/2024_10_03_00_characters.sql)0
-rw-r--r--sql/old/11.x/characters/24092_2024_11_16/2024_11_04_00_characters.sql (renamed from sql/updates/characters/master/2024_11_04_00_characters.sql)0
-rw-r--r--sql/old/11.x/hotfixes/24092_2024_11_16/2024_09_23_11_hotfixes.sql (renamed from sql/updates/hotfixes/master/2024_09_23_11_hotfixes.sql)0
-rw-r--r--sql/old/11.x/hotfixes/24092_2024_11_16/2024_09_27_00_hotfixes.sql (renamed from sql/updates/hotfixes/master/2024_09_27_00_hotfixes.sql)0
-rw-r--r--sql/old/11.x/hotfixes/24092_2024_11_16/2024_10_06_00_hotfixes.sql (renamed from sql/updates/hotfixes/master/2024_10_06_00_hotfixes.sql)0
-rw-r--r--sql/old/11.x/hotfixes/24092_2024_11_16/2024_10_07_00_hotfixes.sql (renamed from sql/updates/hotfixes/master/2024_10_07_00_hotfixes.sql)0
-rw-r--r--sql/old/11.x/hotfixes/24092_2024_11_16/2024_10_09_00_hotfixes.sql (renamed from sql/updates/hotfixes/master/2024_10_09_00_hotfixes.sql)0
-rw-r--r--sql/old/11.x/hotfixes/24092_2024_11_16/2024_10_23_00_hotfixes.sql (renamed from sql/updates/hotfixes/master/2024_10_23_00_hotfixes.sql)0
-rw-r--r--sql/old/11.x/hotfixes/24092_2024_11_16/2024_11_16_00_hotfixes_enUS.sql (renamed from sql/updates/hotfixes/master/2024_11_16_00_hotfixes_enUS.sql)0
-rw-r--r--sql/old/11.x/hotfixes/24092_2024_11_16/2024_11_16_01_hotfixes_deDE.sql (renamed from sql/updates/hotfixes/master/2024_11_16_01_hotfixes_deDE.sql)0
-rw-r--r--sql/old/11.x/hotfixes/24092_2024_11_16/2024_11_16_02_hotfixes_esES.sql (renamed from sql/updates/hotfixes/master/2024_11_16_02_hotfixes_esES.sql)0
-rw-r--r--sql/old/11.x/hotfixes/24092_2024_11_16/2024_11_16_03_hotfixes_esMX.sql (renamed from sql/updates/hotfixes/master/2024_11_16_03_hotfixes_esMX.sql)0
-rw-r--r--sql/old/11.x/hotfixes/24092_2024_11_16/2024_11_16_04_hotfixes_frFR.sql (renamed from sql/updates/hotfixes/master/2024_11_16_04_hotfixes_frFR.sql)0
-rw-r--r--sql/old/11.x/hotfixes/24092_2024_11_16/2024_11_16_05_hotfixes_itIT.sql (renamed from sql/updates/hotfixes/master/2024_11_16_05_hotfixes_itIT.sql)0
-rw-r--r--sql/old/11.x/hotfixes/24092_2024_11_16/2024_11_16_06_hotfixes_koKR.sql (renamed from sql/updates/hotfixes/master/2024_11_16_06_hotfixes_koKR.sql)0
-rw-r--r--sql/old/11.x/hotfixes/24092_2024_11_16/2024_11_16_07_hotfixes_ptBR.sql (renamed from sql/updates/hotfixes/master/2024_11_16_07_hotfixes_ptBR.sql)0
-rw-r--r--sql/old/11.x/hotfixes/24092_2024_11_16/2024_11_16_08_hotfixes_ruRU.sql (renamed from sql/updates/hotfixes/master/2024_11_16_08_hotfixes_ruRU.sql)0
-rw-r--r--sql/old/11.x/hotfixes/24092_2024_11_16/2024_11_16_09_hotfixes_zhCN.sql (renamed from sql/updates/hotfixes/master/2024_11_16_09_hotfixes_zhCN.sql)0
-rw-r--r--sql/old/11.x/hotfixes/24092_2024_11_16/2024_11_16_10_hotfixes_zhTW.sql (renamed from sql/updates/hotfixes/master/2024_11_16_10_hotfixes_zhTW.sql)0
-rw-r--r--sql/old/11.x/hotfixes/24092_2024_11_16/2024_11_16_11_hotfixes_enUS.sql (renamed from sql/updates/hotfixes/master/2024_11_16_11_hotfixes_enUS.sql)0
-rw-r--r--sql/old/11.x/hotfixes/24092_2024_11_16/2024_11_16_12_hotfixes_deDE.sql (renamed from sql/updates/hotfixes/master/2024_11_16_12_hotfixes_deDE.sql)0
-rw-r--r--sql/old/11.x/hotfixes/24092_2024_11_16/2024_11_16_13_hotfixes_esES.sql (renamed from sql/updates/hotfixes/master/2024_11_16_13_hotfixes_esES.sql)0
-rw-r--r--sql/old/11.x/hotfixes/24092_2024_11_16/2024_11_16_14_hotfixes_esMX.sql (renamed from sql/updates/hotfixes/master/2024_11_16_14_hotfixes_esMX.sql)0
-rw-r--r--sql/old/11.x/hotfixes/24092_2024_11_16/2024_11_16_15_hotfixes_frFR.sql (renamed from sql/updates/hotfixes/master/2024_11_16_15_hotfixes_frFR.sql)0
-rw-r--r--sql/old/11.x/hotfixes/24092_2024_11_16/2024_11_16_16_hotfixes_itIT.sql (renamed from sql/updates/hotfixes/master/2024_11_16_16_hotfixes_itIT.sql)0
-rw-r--r--sql/old/11.x/hotfixes/24092_2024_11_16/2024_11_16_17_hotfixes_koKR.sql (renamed from sql/updates/hotfixes/master/2024_11_16_17_hotfixes_koKR.sql)0
-rw-r--r--sql/old/11.x/hotfixes/24092_2024_11_16/2024_11_16_18_hotfixes_ptBR.sql (renamed from sql/updates/hotfixes/master/2024_11_16_18_hotfixes_ptBR.sql)0
-rw-r--r--sql/old/11.x/hotfixes/24092_2024_11_16/2024_11_16_19_hotfixes_ruRU.sql (renamed from sql/updates/hotfixes/master/2024_11_16_19_hotfixes_ruRU.sql)0
-rw-r--r--sql/old/11.x/hotfixes/24092_2024_11_16/2024_11_16_20_hotfixes_zhCN.sql (renamed from sql/updates/hotfixes/master/2024_11_16_20_hotfixes_zhCN.sql)0
-rw-r--r--sql/old/11.x/hotfixes/24092_2024_11_16/2024_11_16_21_hotfixes_zhTW.sql (renamed from sql/updates/hotfixes/master/2024_11_16_21_hotfixes_zhTW.sql)0
-rw-r--r--sql/old/11.x/hotfixes/24092_2024_11_16/2024_11_16_22_hotfixes.sql (renamed from sql/updates/hotfixes/master/2024_11_16_22_hotfixes.sql)0
-rw-r--r--sql/old/11.x/world/24092_2024_11_16/2024_09_23_00_world.sql (renamed from sql/updates/world/master/2024_09_23_00_world.sql)0
-rw-r--r--sql/old/11.x/world/24092_2024_11_16/2024_09_25_00_world.sql (renamed from sql/updates/world/master/2024_09_25_00_world.sql)0
-rw-r--r--sql/old/11.x/world/24092_2024_11_16/2024_09_28_00_world.sql (renamed from sql/updates/world/master/2024_09_28_00_world.sql)0
-rw-r--r--sql/old/11.x/world/24092_2024_11_16/2024_09_29_00_world.sql (renamed from sql/updates/world/master/2024_09_29_00_world.sql)0
-rw-r--r--sql/old/11.x/world/24092_2024_11_16/2024_09_29_01_world.sql (renamed from sql/updates/world/master/2024_09_29_01_world.sql)0
-rw-r--r--sql/old/11.x/world/24092_2024_11_16/2024_09_30_00_world.sql (renamed from sql/updates/world/master/2024_09_30_00_world.sql)0
-rw-r--r--sql/old/11.x/world/24092_2024_11_16/2024_09_30_01_world.sql (renamed from sql/updates/world/master/2024_09_30_01_world.sql)0
-rw-r--r--sql/old/11.x/world/24092_2024_11_16/2024_10_02_00_world.sql (renamed from sql/updates/world/master/2024_10_02_00_world.sql)0
-rw-r--r--sql/old/11.x/world/24092_2024_11_16/2024_10_04_00_world.sql (renamed from sql/updates/world/master/2024_10_04_00_world.sql)0
-rw-r--r--sql/old/11.x/world/24092_2024_11_16/2024_10_04_01_world.sql (renamed from sql/updates/world/master/2024_10_04_01_world.sql)0
-rw-r--r--sql/old/11.x/world/24092_2024_11_16/2024_10_06_00_world.sql (renamed from sql/updates/world/master/2024_10_06_00_world.sql)0
-rw-r--r--sql/old/11.x/world/24092_2024_11_16/2024_10_07_00_world.sql (renamed from sql/updates/world/master/2024_10_07_00_world.sql)0
-rw-r--r--sql/old/11.x/world/24092_2024_11_16/2024_10_07_01_world.sql (renamed from sql/updates/world/master/2024_10_07_01_world.sql)0
-rw-r--r--sql/old/11.x/world/24092_2024_11_16/2024_10_09_00_world.sql (renamed from sql/updates/world/master/2024_10_09_00_world.sql)0
-rw-r--r--sql/old/11.x/world/24092_2024_11_16/2024_10_12_00_world.sql (renamed from sql/updates/world/master/2024_10_12_00_world.sql)0
-rw-r--r--sql/old/11.x/world/24092_2024_11_16/2024_10_12_01_world.sql (renamed from sql/updates/world/master/2024_10_12_01_world.sql)0
-rw-r--r--sql/old/11.x/world/24092_2024_11_16/2024_10_12_02_world.sql (renamed from sql/updates/world/master/2024_10_12_02_world.sql)0
-rw-r--r--sql/old/11.x/world/24092_2024_11_16/2024_10_12_03_world.sql (renamed from sql/updates/world/master/2024_10_12_03_world.sql)0
-rw-r--r--sql/old/11.x/world/24092_2024_11_16/2024_10_15_00_world.sql (renamed from sql/updates/world/master/2024_10_15_00_world.sql)0
-rw-r--r--sql/old/11.x/world/24092_2024_11_16/2024_10_15_01_world.sql (renamed from sql/updates/world/master/2024_10_15_01_world.sql)0
-rw-r--r--sql/old/11.x/world/24092_2024_11_16/2024_10_16_00_world.sql (renamed from sql/updates/world/master/2024_10_16_00_world.sql)0
-rw-r--r--sql/old/11.x/world/24092_2024_11_16/2024_10_17_00_world.sql (renamed from sql/updates/world/master/2024_10_17_00_world.sql)0
-rw-r--r--sql/old/11.x/world/24092_2024_11_16/2024_10_18_00_world.sql (renamed from sql/updates/world/master/2024_10_18_00_world.sql)0
-rw-r--r--sql/old/11.x/world/24092_2024_11_16/2024_10_18_01_world.sql (renamed from sql/updates/world/master/2024_10_18_01_world.sql)0
-rw-r--r--sql/old/11.x/world/24092_2024_11_16/2024_10_20_00_world.sql (renamed from sql/updates/world/master/2024_10_20_00_world.sql)0
-rw-r--r--sql/old/11.x/world/24092_2024_11_16/2024_10_20_01_world.sql (renamed from sql/updates/world/master/2024_10_20_01_world.sql)0
-rw-r--r--sql/old/11.x/world/24092_2024_11_16/2024_10_20_02_world.sql (renamed from sql/updates/world/master/2024_10_20_02_world.sql)0
-rw-r--r--sql/old/11.x/world/24092_2024_11_16/2024_10_20_03_world.sql (renamed from sql/updates/world/master/2024_10_20_03_world.sql)0
-rw-r--r--sql/old/11.x/world/24092_2024_11_16/2024_10_22_00_world.sql (renamed from sql/updates/world/master/2024_10_22_00_world.sql)0
-rw-r--r--sql/old/11.x/world/24092_2024_11_16/2024_10_22_01_world.sql (renamed from sql/updates/world/master/2024_10_22_01_world.sql)0
-rw-r--r--sql/old/11.x/world/24092_2024_11_16/2024_10_22_02_world.sql (renamed from sql/updates/world/master/2024_10_22_02_world.sql)0
-rw-r--r--sql/old/11.x/world/24092_2024_11_16/2024_10_22_03_world.sql (renamed from sql/updates/world/master/2024_10_22_03_world.sql)0
-rw-r--r--sql/old/11.x/world/24092_2024_11_16/2024_10_22_04_world.sql (renamed from sql/updates/world/master/2024_10_22_04_world.sql)0
-rw-r--r--sql/old/11.x/world/24092_2024_11_16/2024_10_22_05_world.sql (renamed from sql/updates/world/master/2024_10_22_05_world.sql)0
-rw-r--r--sql/old/11.x/world/24092_2024_11_16/2024_10_24_00_world.sql (renamed from sql/updates/world/master/2024_10_24_00_world.sql)0
-rw-r--r--sql/old/11.x/world/24092_2024_11_16/2024_10_24_01_world.sql (renamed from sql/updates/world/master/2024_10_24_01_world.sql)0
-rw-r--r--sql/old/11.x/world/24092_2024_11_16/2024_10_24_02_world.sql (renamed from sql/updates/world/master/2024_10_24_02_world.sql)0
-rw-r--r--sql/old/11.x/world/24092_2024_11_16/2024_10_24_03_world.sql (renamed from sql/updates/world/master/2024_10_24_03_world.sql)0
-rw-r--r--sql/old/11.x/world/24092_2024_11_16/2024_10_27_00_world.sql (renamed from sql/updates/world/master/2024_10_27_00_world.sql)0
-rw-r--r--sql/old/11.x/world/24092_2024_11_16/2024_10_27_01_world.sql (renamed from sql/updates/world/master/2024_10_27_01_world.sql)0
-rw-r--r--sql/old/11.x/world/24092_2024_11_16/2024_10_27_02_world.sql (renamed from sql/updates/world/master/2024_10_27_02_world.sql)0
-rw-r--r--sql/old/11.x/world/24092_2024_11_16/2024_10_27_03_world.sql (renamed from sql/updates/world/master/2024_10_27_03_world.sql)0
-rw-r--r--sql/old/11.x/world/24092_2024_11_16/2024_11_01_00_world.sql (renamed from sql/updates/world/master/2024_11_01_00_world.sql)0
-rw-r--r--sql/old/11.x/world/24092_2024_11_16/2024_11_03_00_world.sql (renamed from sql/updates/world/master/2024_11_03_00_world.sql)0
-rw-r--r--sql/old/11.x/world/24092_2024_11_16/2024_11_05_00_world.sql (renamed from sql/updates/world/master/2024_11_05_00_world.sql)0
-rw-r--r--sql/old/11.x/world/24092_2024_11_16/2024_11_05_01_world.sql (renamed from sql/updates/world/master/2024_11_05_01_world.sql)0
-rw-r--r--sql/old/11.x/world/24092_2024_11_16/2024_11_05_02_world.sql (renamed from sql/updates/world/master/2024_11_05_02_world.sql)0
-rw-r--r--sql/old/11.x/world/24092_2024_11_16/2024_11_05_03_world.sql (renamed from sql/updates/world/master/2024_11_05_03_world.sql)0
-rw-r--r--sql/old/11.x/world/24092_2024_11_16/2024_11_05_04_world.sql (renamed from sql/updates/world/master/2024_11_05_04_world.sql)0
-rw-r--r--sql/old/11.x/world/24092_2024_11_16/2024_11_05_05_world.sql (renamed from sql/updates/world/master/2024_11_05_05_world.sql)0
-rw-r--r--sql/old/11.x/world/24092_2024_11_16/2024_11_06_00_world.sql (renamed from sql/updates/world/master/2024_11_06_00_world.sql)0
-rw-r--r--sql/old/11.x/world/24092_2024_11_16/2024_11_06_01_world.sql (renamed from sql/updates/world/master/2024_11_06_01_world.sql)0
-rw-r--r--sql/old/11.x/world/24092_2024_11_16/2024_11_06_02_world.sql (renamed from sql/updates/world/master/2024_11_06_02_world.sql)0
-rw-r--r--sql/old/11.x/world/24092_2024_11_16/2024_11_06_03_world.sql (renamed from sql/updates/world/master/2024_11_06_03_world.sql)0
-rw-r--r--sql/old/11.x/world/24092_2024_11_16/2024_11_06_04_world.sql (renamed from sql/updates/world/master/2024_11_06_04_world.sql)0
-rw-r--r--sql/old/11.x/world/24092_2024_11_16/2024_11_06_05_world.sql (renamed from sql/updates/world/master/2024_11_06_05_world.sql)0
-rw-r--r--sql/old/11.x/world/24092_2024_11_16/2024_11_06_06_world.sql (renamed from sql/updates/world/master/2024_11_06_06_world.sql)0
-rw-r--r--sql/old/11.x/world/24092_2024_11_16/2024_11_06_07_world.sql (renamed from sql/updates/world/master/2024_11_06_07_world.sql)0
-rw-r--r--sql/old/11.x/world/24092_2024_11_16/2024_11_06_08_world.sql (renamed from sql/updates/world/master/2024_11_06_08_world.sql)0
-rw-r--r--sql/old/11.x/world/24092_2024_11_16/2024_11_08_00_world.sql (renamed from sql/updates/world/master/2024_11_08_00_world.sql)0
-rw-r--r--sql/old/11.x/world/24092_2024_11_16/2024_11_08_01_world.sql (renamed from sql/updates/world/master/2024_11_08_01_world.sql)0
-rw-r--r--sql/old/11.x/world/24092_2024_11_16/2024_11_08_02_world.sql (renamed from sql/updates/world/master/2024_11_08_02_world.sql)0
-rw-r--r--sql/old/11.x/world/24092_2024_11_16/2024_11_08_03_world.sql (renamed from sql/updates/world/master/2024_11_08_03_world.sql)0
-rw-r--r--sql/old/11.x/world/24092_2024_11_16/2024_11_08_04_world.sql (renamed from sql/updates/world/master/2024_11_08_04_world.sql)0
-rw-r--r--sql/old/11.x/world/24092_2024_11_16/2024_11_08_05_world.sql (renamed from sql/updates/world/master/2024_11_08_05_world.sql)0
-rw-r--r--sql/old/11.x/world/24092_2024_11_16/2024_11_08_06_world.sql (renamed from sql/updates/world/master/2024_11_08_06_world.sql)0
-rw-r--r--sql/old/11.x/world/24092_2024_11_16/2024_11_08_07_world.sql (renamed from sql/updates/world/master/2024_11_08_07_world.sql)0
-rw-r--r--sql/old/11.x/world/24092_2024_11_16/2024_11_09_00_world.sql (renamed from sql/updates/world/master/2024_11_09_00_world.sql)0
-rw-r--r--sql/old/11.x/world/24092_2024_11_16/2024_11_09_01_world.sql (renamed from sql/updates/world/master/2024_11_09_01_world.sql)0
-rw-r--r--sql/old/11.x/world/24092_2024_11_16/2024_11_09_02_world.sql (renamed from sql/updates/world/master/2024_11_09_02_world.sql)0
-rw-r--r--sql/old/11.x/world/24092_2024_11_16/2024_11_09_03_world.sql (renamed from sql/updates/world/master/2024_11_09_03_world.sql)0
-rw-r--r--sql/old/11.x/world/24092_2024_11_16/2024_11_09_04_world.sql (renamed from sql/updates/world/master/2024_11_09_04_world.sql)0
-rw-r--r--sql/old/11.x/world/24092_2024_11_16/2024_11_12_00_world.sql (renamed from sql/updates/world/master/2024_11_12_00_world.sql)0
-rw-r--r--sql/old/11.x/world/24092_2024_11_16/2024_11_15_00_world.sql (renamed from sql/updates/world/master/2024_11_15_00_world.sql)0
-rw-r--r--sql/old/11.x/world/24092_2024_11_16/2024_11_15_01_world.sql (renamed from sql/updates/world/master/2024_11_15_01_world.sql)0
-rw-r--r--sql/old/11.x/world/24092_2024_11_16/2024_11_15_02_world.sql (renamed from sql/updates/world/master/2024_11_15_02_world.sql)0
-rw-r--r--sql/old/11.x/world/24092_2024_11_16/2024_11_15_03_world.sql (renamed from sql/updates/world/master/2024_11_15_03_world.sql)0
-rw-r--r--sql/old/11.x/world/24092_2024_11_16/2024_11_15_04_world.sql (renamed from sql/updates/world/master/2024_11_15_04_world.sql)0
-rw-r--r--sql/old/11.x/world/24092_2024_11_16/2024_11_16_00_world_enUS.sql (renamed from sql/updates/world/master/2024_11_16_00_world_enUS.sql)0
-rw-r--r--sql/old/11.x/world/24092_2024_11_16/2024_11_16_01_world_deDE.sql (renamed from sql/updates/world/master/2024_11_16_01_world_deDE.sql)0
-rw-r--r--sql/old/11.x/world/24092_2024_11_16/2024_11_16_02_world_esES.sql (renamed from sql/updates/world/master/2024_11_16_02_world_esES.sql)0
-rw-r--r--sql/old/11.x/world/24092_2024_11_16/2024_11_16_03_world_esMX.sql (renamed from sql/updates/world/master/2024_11_16_03_world_esMX.sql)0
-rw-r--r--sql/old/11.x/world/24092_2024_11_16/2024_11_16_04_world_frFR.sql (renamed from sql/updates/world/master/2024_11_16_04_world_frFR.sql)0
-rw-r--r--sql/old/11.x/world/24092_2024_11_16/2024_11_16_05_world_itIT.sql (renamed from sql/updates/world/master/2024_11_16_05_world_itIT.sql)0
-rw-r--r--sql/old/11.x/world/24092_2024_11_16/2024_11_16_06_world_koKR.sql (renamed from sql/updates/world/master/2024_11_16_06_world_koKR.sql)0
-rw-r--r--sql/old/11.x/world/24092_2024_11_16/2024_11_16_07_world_ptBR.sql (renamed from sql/updates/world/master/2024_11_16_07_world_ptBR.sql)0
-rw-r--r--sql/old/11.x/world/24092_2024_11_16/2024_11_16_08_world_ruRU.sql (renamed from sql/updates/world/master/2024_11_16_08_world_ruRU.sql)0
-rw-r--r--sql/old/11.x/world/24092_2024_11_16/2024_11_16_09_world_zhCN.sql (renamed from sql/updates/world/master/2024_11_16_09_world_zhCN.sql)0
-rw-r--r--sql/old/11.x/world/24092_2024_11_16/2024_11_16_10_world_zhTW.sql (renamed from sql/updates/world/master/2024_11_16_10_world_zhTW.sql)0
-rw-r--r--sql/old/11.x/world/24092_2024_11_16/2024_11_16_11_world_creature_difficulty.sql (renamed from sql/updates/world/master/2024_11_16_11_world_creature_difficulty.sql)0
-rw-r--r--sql/old/11.x/world/24092_2024_11_16/2024_11_16_12_world_quest_poi.sql (renamed from sql/updates/world/master/2024_11_16_12_world_quest_poi.sql)0
-rw-r--r--sql/updates/auth/master/2024_11_16_00_auth.sql3
-rw-r--r--sql/updates/characters/master/2024_11_16_00_characters.sql3
-rw-r--r--sql/updates/hotfixes/master/2024_11_16_23_hotfixes.sql3
-rw-r--r--sql/updates/world/master/2024_11_16_13_world.sql4
142 files changed, 153 insertions, 98 deletions
diff --git a/revision_data.h.in.cmake b/revision_data.h.in.cmake
index 8a214ab9620..6ca21a857c0 100644
--- a/revision_data.h.in.cmake
+++ b/revision_data.h.in.cmake
@@ -40,8 +40,8 @@
// Database updater base information
#define DATABASE_MYSQL_EXECUTABLE R"(@MYSQL_EXECUTABLE@)"
-#define DATABASE_FULL_DATABASE "TDB_full_world_1102.24092_2024_09_23.sql"
-#define DATABASE_HOTFIXES_DATABASE "TDB_full_hotfixes_1102.24092_2024_09_23.sql"
+#define DATABASE_FULL_DATABASE "TDB_full_world_1105.24111_2024_11_16.sql"
+#define DATABASE_HOTFIXES_DATABASE "TDB_full_hotfixes_1105.24111_2024_11_16.sql"
// Windows resource defines
#define VER_COMPANYNAME_STR "TrinityCore Developers"
diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql
index af17b05c335..08ee25584ea 100644
--- a/sql/base/auth_database.sql
+++ b/sql/base/auth_database.sql
@@ -1,8 +1,8 @@
--- MySQL dump 10.13 Distrib 8.0.39, for Linux (x86_64)
+-- MySQL dump 10.13 Distrib 8.0.40, for Linux (x86_64)
--
-- Host: localhost Database: auth
-- ------------------------------------------------------
--- Server version 8.0.39-0ubuntu0.22.04.1
+-- Server version 8.0.40-0ubuntu0.22.04.1
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
@@ -3292,15 +3292,16 @@ INSERT INTO `updates` VALUES
('2024_09_18_00_auth.sql','073B6E954B585CD81BFADD58CDAD166E85D2653A','ARCHIVED','2024-09-18 10:26:42',0),
('2024_09_18_01_auth.sql','6AE1437E24D4837EB2347ADAA80A4093CA9F6D67','ARCHIVED','2024-09-18 21:30:31',0),
('2024_09_23_00_auth.sql','CBAB00B40360D8942AD1E4EDBE0F0097F3F6FC9B','ARCHIVED','2024-09-23 22:48:10',0),
-('2024_09_26_00_auth.sql','E37C3997FD7851EA360774AC568912846C448272','RELEASED','2024-09-26 18:27:26',0),
-('2024_10_01_00_auth.sql','665EC51B03F52C373F713D96A1426054D7DF98C8','RELEASED','2024-10-01 23:39:44',0),
-('2024_10_23_00_auth.sql','78203AE9051E866F103CC7B8A6EE09D5C25BCB9A','RELEASED','2024-10-23 15:48:13',0),
-('2024_10_23_01_auth.sql','06257BB5FF23564549529C14822DD5780AA7F7C3','RELEASED','2024-10-23 22:30:54',0),
-('2024_10_30_00_auth.sql','B4C930B0CE499704CEBF208A71871061DC27008C','RELEASED','2024-10-30 13:04:40',0),
-('2024_11_01_00_auth.sql','62EF7FC9CD2DCD8D24CE1BCED3BF9E2917B6674B','RELEASED','2024-11-01 13:26:56',0),
-('2024_11_11_00_auth.sql','F47CDFB857DB4105306739AF4FBBB3C92CA43363','RELEASED','2024-11-11 13:34:09',0),
-('2024_11_12_00_auth.sql','5A236A557291758C0F2C46FDEC02692E7C53F751','RELEASED','2024-11-12 11:42:13',0),
-('2024_11_14_00_auth.sql','646A438FAD5A83D80DCDDEDC71BB6CF21A1FE490','RELEASED','2024-11-14 10:29:52',0);
+('2024_09_26_00_auth.sql','E37C3997FD7851EA360774AC568912846C448272','ARCHIVED','2024-09-26 18:27:26',0),
+('2024_10_01_00_auth.sql','665EC51B03F52C373F713D96A1426054D7DF98C8','ARCHIVED','2024-10-01 23:39:44',0),
+('2024_10_23_00_auth.sql','78203AE9051E866F103CC7B8A6EE09D5C25BCB9A','ARCHIVED','2024-10-23 15:48:13',0),
+('2024_10_23_01_auth.sql','06257BB5FF23564549529C14822DD5780AA7F7C3','ARCHIVED','2024-10-23 22:30:54',0),
+('2024_10_30_00_auth.sql','B4C930B0CE499704CEBF208A71871061DC27008C','ARCHIVED','2024-10-30 13:04:40',0),
+('2024_11_01_00_auth.sql','62EF7FC9CD2DCD8D24CE1BCED3BF9E2917B6674B','ARCHIVED','2024-11-01 13:26:56',0),
+('2024_11_11_00_auth.sql','F47CDFB857DB4105306739AF4FBBB3C92CA43363','ARCHIVED','2024-11-11 13:34:09',0),
+('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);
/*!40000 ALTER TABLE `updates` ENABLE KEYS */;
UNLOCK TABLES;
@@ -3444,4 +3445,4 @@ SET character_set_client = @saved_cs_client;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
--- Dump completed on 2024-09-23 22:48:12
+-- Dump completed on 2024-11-16 21:57:41
diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql
index ee2d369cebf..740766a4264 100644
--- a/sql/base/characters_database.sql
+++ b/sql/base/characters_database.sql
@@ -1,8 +1,8 @@
--- MySQL dump 10.13 Distrib 8.0.39, for Linux (x86_64)
+-- MySQL dump 10.13 Distrib 8.0.40, for Linux (x86_64)
--
-- Host: localhost Database: characters
-- ------------------------------------------------------
--- Server version 8.0.39-0ubuntu0.22.04.1
+-- Server version 8.0.40-0ubuntu0.22.04.1
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
@@ -3749,8 +3749,9 @@ INSERT INTO `updates` VALUES
('2024_08_26_00_characters.sql','68EEBE1D639D59B24F5121008C2D103CA67FFC9A','ARCHIVED','2024-08-26 00:49:08',0),
('2024_09_03_00_characters.sql','71ECC73A3F324EB64DA19B0CC4DF72A85E022BDC','ARCHIVED','2024-09-03 00:47:42',0),
('2024_09_23_00_characters.sql','D8491BCEE728F40D55D47E3A4BC5A5F083EBD02E','ARCHIVED','2024-09-23 22:48:10',0),
-('2024_10_03_00_characters.sql','408249A6992999A36EB94089D184972E8E0767A3','RELEASED','2024-10-03 11:10:18',0),
-('2024_11_04_00_characters.sql','F7980E0CEE728FF866703693690F76F932E7C764','RELEASED','2024-11-04 17:14:03',0);
+('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);
/*!40000 ALTER TABLE `updates` ENABLE KEYS */;
UNLOCK TABLES;
@@ -3878,4 +3879,4 @@ UNLOCK TABLES;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
--- Dump completed on 2024-09-23 22:48:12
+-- Dump completed on 2024-11-16 21:57:41
diff --git a/sql/base/dev/hotfixes_database.sql b/sql/base/dev/hotfixes_database.sql
index 0e424df11e3..ca4e827e340 100644
--- a/sql/base/dev/hotfixes_database.sql
+++ b/sql/base/dev/hotfixes_database.sql
@@ -1,8 +1,8 @@
--- MySQL dump 10.13 Distrib 8.0.39, for Linux (x86_64)
+-- MySQL dump 10.13 Distrib 8.0.40, for Linux (x86_64)
--
-- Host: localhost Database: hotfixes
-- ------------------------------------------------------
--- Server version 8.0.39-0ubuntu0.22.04.1
+-- Server version 8.0.40-0ubuntu0.22.04.1
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
@@ -34,7 +34,7 @@ CREATE TABLE `achievement` (
`MinimumCriteria` tinyint NOT NULL DEFAULT '0',
`Points` tinyint NOT NULL DEFAULT '0',
`Flags` int NOT NULL DEFAULT '0',
- `UiOrder` smallint NOT NULL DEFAULT '0',
+ `UiOrder` smallint unsigned NOT NULL DEFAULT '0',
`IconFileID` int NOT NULL DEFAULT '0',
`RewardItemID` int NOT NULL DEFAULT '0',
`CriteriaTree` int unsigned NOT NULL DEFAULT '0',
@@ -58,7 +58,7 @@ CREATE TABLE `achievement_category` (
`Name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`ID` int unsigned NOT NULL DEFAULT '0',
`Parent` smallint NOT NULL DEFAULT '0',
- `UiOrder` tinyint NOT NULL DEFAULT '0',
+ `UiOrder` tinyint unsigned NOT NULL DEFAULT '0',
`VerifiedBuild` int NOT NULL DEFAULT '0',
PRIMARY KEY (`ID`,`VerifiedBuild`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@@ -374,7 +374,7 @@ CREATE TABLE `area_trigger` (
`PosY` float NOT NULL DEFAULT '0',
`PosZ` float NOT NULL DEFAULT '0',
`ID` int unsigned NOT NULL DEFAULT '0',
- `ContinentID` smallint NOT NULL DEFAULT '0',
+ `ContinentID` smallint unsigned NOT NULL DEFAULT '0',
`PhaseUseFlags` int NOT NULL DEFAULT '0',
`PhaseID` smallint NOT NULL DEFAULT '0',
`PhaseGroupID` smallint NOT NULL DEFAULT '0',
@@ -614,7 +614,7 @@ CREATE TABLE `artifact_power` (
`MaxPurchasableRank` tinyint unsigned NOT NULL DEFAULT '0',
`Label` int NOT NULL DEFAULT '0',
`Flags` tinyint unsigned NOT NULL DEFAULT '0',
- `Tier` tinyint NOT NULL DEFAULT '0',
+ `Tier` tinyint unsigned NOT NULL DEFAULT '0',
`VerifiedBuild` int NOT NULL DEFAULT '0',
PRIMARY KEY (`ID`,`VerifiedBuild`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@@ -981,10 +981,10 @@ DROP TABLE IF EXISTS `azerite_power_set_member`;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `azerite_power_set_member` (
`ID` int unsigned NOT NULL DEFAULT '0',
- `AzeritePowerSetID` int NOT NULL DEFAULT '0',
+ `AzeritePowerSetID` int unsigned NOT NULL DEFAULT '0',
`AzeritePowerID` int NOT NULL DEFAULT '0',
`Class` int NOT NULL DEFAULT '0',
- `Tier` tinyint NOT NULL DEFAULT '0',
+ `Tier` tinyint unsigned NOT NULL DEFAULT '0',
`OrderIndex` int NOT NULL DEFAULT '0',
`VerifiedBuild` int NOT NULL DEFAULT '0',
PRIMARY KEY (`ID`,`VerifiedBuild`)
@@ -1184,7 +1184,7 @@ CREATE TABLE `battle_pet_breed_quality` (
`ID` int unsigned NOT NULL DEFAULT '0',
`MaxQualityRoll` int NOT NULL DEFAULT '0',
`StateMultiplier` float NOT NULL DEFAULT '0',
- `QualityEnum` tinyint NOT NULL DEFAULT '0',
+ `QualityEnum` tinyint unsigned NOT NULL DEFAULT '0',
`VerifiedBuild` int NOT NULL DEFAULT '0',
PRIMARY KEY (`ID`,`VerifiedBuild`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@@ -1392,9 +1392,9 @@ DROP TABLE IF EXISTS `broadcast_text_duration`;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `broadcast_text_duration` (
`ID` int unsigned NOT NULL DEFAULT '0',
- `BroadcastTextID` int NOT NULL DEFAULT '0',
`Locale` int NOT NULL DEFAULT '0',
`Duration` int NOT NULL DEFAULT '0',
+ `BroadcastTextID` 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;
@@ -1588,7 +1588,7 @@ CREATE TABLE `character_loadout` (
`RaceMask` bigint NOT NULL DEFAULT '0',
`ChrClassID` tinyint NOT NULL DEFAULT '0',
`Purpose` int NOT NULL DEFAULT '0',
- `ItemContext` tinyint NOT NULL DEFAULT '0',
+ `ItemContext` tinyint unsigned NOT NULL DEFAULT '0',
`VerifiedBuild` int NOT NULL DEFAULT '0',
PRIMARY KEY (`ID`,`VerifiedBuild`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@@ -1786,7 +1786,7 @@ DROP TABLE IF EXISTS `chr_customization_choice`;
CREATE TABLE `chr_customization_choice` (
`Name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`ID` int unsigned NOT NULL DEFAULT '0',
- `ChrCustomizationOptionID` int NOT NULL DEFAULT '0',
+ `ChrCustomizationOptionID` int unsigned NOT NULL DEFAULT '0',
`ChrCustomizationReqID` int NOT NULL DEFAULT '0',
`ChrCustomizationVisReqID` int NOT NULL DEFAULT '0',
`SortOrder` smallint unsigned NOT NULL DEFAULT '0',
@@ -1886,9 +1886,7 @@ 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 NOT NULL DEFAULT '0',
+ `ChrModelID` int unsigned NOT NULL DEFAULT '0',
`SortIndex` int NOT NULL DEFAULT '0',
`ChrCustomizationCategoryID` int NOT NULL DEFAULT '0',
`OptionType` int NOT NULL DEFAULT '0',
@@ -2010,7 +2008,7 @@ CREATE TABLE `chr_model` (
`CustomizeOffset3` float NOT NULL DEFAULT '0',
`ID` int unsigned NOT NULL DEFAULT '0',
`Sex` tinyint NOT NULL DEFAULT '0',
- `DisplayID` int NOT NULL DEFAULT '0',
+ `DisplayID` int unsigned NOT NULL DEFAULT '0',
`CharComponentTextureLayoutID` int NOT NULL DEFAULT '0',
`Flags` int NOT NULL DEFAULT '0',
`SkeletonFileDataID` int NOT NULL DEFAULT '0',
@@ -2037,7 +2035,7 @@ DROP TABLE IF EXISTS `chr_race_x_chr_model`;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `chr_race_x_chr_model` (
`ID` int unsigned NOT NULL DEFAULT '0',
- `ChrRacesID` int NOT NULL DEFAULT '0',
+ `ChrRacesID` int unsigned NOT NULL DEFAULT '0',
`ChrModelID` int NOT NULL DEFAULT '0',
`Sex` int NOT NULL DEFAULT '0',
`AllowedTransmogSlots` int NOT NULL DEFAULT '0',
@@ -2173,7 +2171,7 @@ CREATE TABLE `chr_specialization` (
`FemaleName` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`Description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`ID` int unsigned NOT NULL DEFAULT '0',
- `ClassID` tinyint NOT NULL DEFAULT '0',
+ `ClassID` tinyint unsigned NOT NULL DEFAULT '0',
`OrderIndex` tinyint NOT NULL DEFAULT '0',
`PetTalentType` tinyint NOT NULL DEFAULT '0',
`Role` tinyint NOT NULL DEFAULT '0',
@@ -2270,7 +2268,7 @@ DROP TABLE IF EXISTS `conditional_chr_model`;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `conditional_chr_model` (
`ID` int unsigned NOT NULL DEFAULT '0',
- `ChrModelID` int NOT NULL DEFAULT '0',
+ `ChrModelID` int unsigned NOT NULL DEFAULT '0',
`ChrCustomizationReqID` int NOT NULL DEFAULT '0',
`PlayerConditionID` int NOT NULL DEFAULT '0',
`Flags` int NOT NULL DEFAULT '0',
@@ -2946,11 +2944,12 @@ CREATE TABLE `difficulty` (
`MinPlayers` tinyint unsigned NOT NULL DEFAULT '0',
`MaxPlayers` tinyint unsigned NOT NULL DEFAULT '0',
`Flags` smallint unsigned NOT NULL DEFAULT '0',
- `ItemContext` tinyint NOT NULL DEFAULT '0',
+ `ItemContext` tinyint unsigned NOT NULL DEFAULT '0',
`ToggleDifficultyID` tinyint unsigned NOT NULL DEFAULT '0',
`GroupSizeHealthCurveID` int unsigned NOT NULL DEFAULT '0',
`GroupSizeDmgCurveID` int unsigned NOT NULL DEFAULT '0',
`GroupSizeSpellPointsCurveID` int unsigned NOT NULL DEFAULT '0',
+ `Unknown1105` int NOT NULL DEFAULT '0',
`VerifiedBuild` int NOT NULL DEFAULT '0',
PRIMARY KEY (`ID`,`VerifiedBuild`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@@ -2993,7 +2992,7 @@ DROP TABLE IF EXISTS `dungeon_encounter`;
CREATE TABLE `dungeon_encounter` (
`Name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`ID` int unsigned NOT NULL DEFAULT '0',
- `MapID` smallint NOT NULL DEFAULT '0',
+ `MapID` smallint unsigned NOT NULL DEFAULT '0',
`DifficultyID` int NOT NULL DEFAULT '0',
`OrderIndex` int NOT NULL DEFAULT '0',
`CompleteWorldStateID` int NOT NULL DEFAULT '0',
@@ -3309,6 +3308,45 @@ CREATE TABLE `faction_template` (
/*!40101 SET character_set_client = @saved_cs_client */;
--
+-- Table structure for table `flight_capability`
+--
+
+DROP TABLE IF EXISTS `flight_capability`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!50503 SET character_set_client = utf8mb4 */;
+CREATE TABLE `flight_capability` (
+ `ID` int unsigned NOT NULL DEFAULT '0',
+ `AirFriction` float NOT NULL DEFAULT '0',
+ `MaxVel` float NOT NULL DEFAULT '0',
+ `Unknown1000_2` float NOT NULL DEFAULT '0',
+ `DoubleJumpVelMod` float NOT NULL DEFAULT '0',
+ `LiftCoefficient` float NOT NULL DEFAULT '0',
+ `GlideStartMinHeight` float NOT NULL DEFAULT '0',
+ `AddImpulseMaxSpeed` float NOT NULL DEFAULT '0',
+ `BankingRateMin` float NOT NULL DEFAULT '0',
+ `BankingRateMax` float NOT NULL DEFAULT '0',
+ `PitchingRateDownMin` float NOT NULL DEFAULT '0',
+ `PitchingRateDownMax` float NOT NULL DEFAULT '0',
+ `PitchingRateUpMin` float NOT NULL DEFAULT '0',
+ `PitchingRateUpMax` float NOT NULL DEFAULT '0',
+ `TurnVelocityThresholdMin` float NOT NULL DEFAULT '0',
+ `TurnVelocityThresholdMax` float NOT NULL DEFAULT '0',
+ `SurfaceFriction` float NOT NULL DEFAULT '0',
+ `OverMaxDeceleration` float NOT NULL DEFAULT '0',
+ `Unknown1000_17` float NOT NULL DEFAULT '0',
+ `Unknown1000_18` float NOT NULL DEFAULT '0',
+ `Unknown1000_19` float NOT NULL DEFAULT '0',
+ `Unknown1000_20` float NOT NULL DEFAULT '0',
+ `Unknown1000_21` float NOT NULL DEFAULT '0',
+ `LaunchSpeedCoefficient` float NOT NULL DEFAULT '0',
+ `VigorRegenMaxVelCoefficient` float NOT NULL DEFAULT '0',
+ `SpellID` 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 `friendship_rep_reaction`
--
@@ -3318,7 +3356,7 @@ DROP TABLE IF EXISTS `friendship_rep_reaction`;
CREATE TABLE `friendship_rep_reaction` (
`ID` int unsigned NOT NULL DEFAULT '0',
`Reaction` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
- `FriendshipRepID` int NOT NULL DEFAULT '0',
+ `FriendshipRepID` int unsigned NOT NULL DEFAULT '0',
`ReactionThreshold` int NOT NULL DEFAULT '0',
`OverrideColor` int NOT NULL DEFAULT '0',
`VerifiedBuild` int NOT NULL DEFAULT '0',
@@ -3465,7 +3503,7 @@ CREATE TABLE `gameobjects` (
`Rot3` float NOT NULL DEFAULT '0',
`Rot4` float NOT NULL DEFAULT '0',
`ID` int unsigned NOT NULL DEFAULT '0',
- `OwnerID` int NOT NULL DEFAULT '0',
+ `OwnerID` int unsigned NOT NULL DEFAULT '0',
`DisplayID` int NOT NULL DEFAULT '0',
`Scale` float NOT NULL DEFAULT '0',
`TypeID` int NOT NULL DEFAULT '0',
@@ -3576,7 +3614,7 @@ CREATE TABLE `garr_building` (
`Description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`Tooltip` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`GarrTypeID` tinyint NOT NULL DEFAULT '0',
- `BuildingType` tinyint NOT NULL DEFAULT '0',
+ `BuildingType` tinyint unsigned NOT NULL DEFAULT '0',
`HordeGameObjectID` int NOT NULL DEFAULT '0',
`AllianceGameObjectID` int NOT NULL DEFAULT '0',
`GarrSiteID` int NOT NULL DEFAULT '0',
@@ -3820,7 +3858,7 @@ CREATE TABLE `garr_mission` (
`EnvGarrMechanicID` int unsigned NOT NULL DEFAULT '0',
`EnvGarrMechanicTypeID` int NOT NULL DEFAULT '0',
`PlayerConditionID` int unsigned NOT NULL DEFAULT '0',
- `GarrMissionSetID` int NOT NULL DEFAULT '0',
+ `GarrMissionSetID` int unsigned NOT NULL DEFAULT '0',
`TargetLevel` tinyint NOT NULL DEFAULT '0',
`TargetItemLevel` smallint unsigned NOT NULL DEFAULT '0',
`MissionDuration` int NOT NULL DEFAULT '0',
@@ -3879,7 +3917,7 @@ DROP TABLE IF EXISTS `garr_plot`;
CREATE TABLE `garr_plot` (
`ID` int unsigned NOT NULL DEFAULT '0',
`Name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
- `PlotType` tinyint NOT NULL DEFAULT '0',
+ `PlotType` tinyint unsigned NOT NULL DEFAULT '0',
`HordeConstructObjID` int NOT NULL DEFAULT '0',
`AllianceConstructObjID` int NOT NULL DEFAULT '0',
`Flags` tinyint unsigned NOT NULL DEFAULT '0',
@@ -3985,7 +4023,7 @@ CREATE TABLE `garr_talent_tree` (
`GarrTalentTreeType` int NOT NULL DEFAULT '0',
`PlayerConditionID` int NOT NULL DEFAULT '0',
`FeatureTypeIndex` tinyint unsigned NOT NULL DEFAULT '0',
- `FeatureSubtypeIndex` tinyint NOT NULL DEFAULT '0',
+ `FeatureSubtypeIndex` tinyint unsigned NOT NULL DEFAULT '0',
`CurrencyID` int NOT NULL DEFAULT '0',
`VerifiedBuild` int NOT NULL DEFAULT '0',
PRIMARY KEY (`ID`,`VerifiedBuild`)
@@ -4077,7 +4115,7 @@ DROP TABLE IF EXISTS `glyph_properties`;
CREATE TABLE `glyph_properties` (
`ID` int unsigned NOT NULL DEFAULT '0',
`SpellID` int unsigned NOT NULL DEFAULT '0',
- `GlyphType` tinyint NOT NULL DEFAULT '0',
+ `GlyphType` tinyint unsigned NOT NULL DEFAULT '0',
`GlyphExclusiveCategoryID` tinyint unsigned NOT NULL DEFAULT '0',
`SpellIconFileDataID` int NOT NULL DEFAULT '0',
`VerifiedBuild` int NOT NULL DEFAULT '0',
@@ -4619,7 +4657,7 @@ DROP TABLE IF EXISTS `item_bonus_list_group_entry`;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `item_bonus_list_group_entry` (
`ID` int unsigned NOT NULL DEFAULT '0',
- `ItemBonusListGroupID` int NOT NULL DEFAULT '0',
+ `ItemBonusListGroupID` int unsigned NOT NULL DEFAULT '0',
`ItemBonusListID` int NOT NULL DEFAULT '0',
`ItemLevelSelectorID` int NOT NULL DEFAULT '0',
`SequenceValue` int NOT NULL DEFAULT '0',
@@ -4672,7 +4710,7 @@ DROP TABLE IF EXISTS `item_bonus_tree_node`;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `item_bonus_tree_node` (
`ID` int unsigned NOT NULL DEFAULT '0',
- `ItemContext` tinyint NOT NULL DEFAULT '0',
+ `ItemContext` tinyint unsigned NOT NULL DEFAULT '0',
`ChildItemBonusTreeID` smallint unsigned NOT NULL DEFAULT '0',
`ChildItemBonusListID` smallint unsigned NOT NULL DEFAULT '0',
`ChildItemLevelSelectorID` smallint unsigned NOT NULL DEFAULT '0',
@@ -4695,7 +4733,7 @@ DROP TABLE IF EXISTS `item_child_equipment`;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `item_child_equipment` (
`ID` int unsigned NOT NULL DEFAULT '0',
- `ParentItemID` int NOT NULL DEFAULT '0',
+ `ParentItemID` int unsigned NOT NULL DEFAULT '0',
`ChildItemID` int NOT NULL DEFAULT '0',
`ChildItemEquipSlot` tinyint unsigned NOT NULL DEFAULT '0',
`VerifiedBuild` int NOT NULL DEFAULT '0',
@@ -4757,7 +4795,7 @@ DROP TABLE IF EXISTS `item_context_picker_entry`;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `item_context_picker_entry` (
`ID` int unsigned NOT NULL DEFAULT '0',
- `ItemCreationContext` tinyint NOT NULL DEFAULT '0',
+ `ItemCreationContext` tinyint unsigned NOT NULL DEFAULT '0',
`OrderIndex` tinyint unsigned NOT NULL DEFAULT '0',
`PVal` int NOT NULL DEFAULT '0',
`LabelID` int NOT NULL DEFAULT '0',
@@ -4778,7 +4816,7 @@ DROP TABLE IF EXISTS `item_currency_cost`;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `item_currency_cost` (
`ID` int unsigned NOT NULL DEFAULT '0',
- `ItemID` int NOT NULL DEFAULT '0',
+ `ItemID` 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;
@@ -5097,7 +5135,7 @@ DROP TABLE IF EXISTS `item_modified_appearance`;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `item_modified_appearance` (
`ID` int unsigned NOT NULL DEFAULT '0',
- `ItemID` int NOT NULL DEFAULT '0',
+ `ItemID` int unsigned NOT NULL DEFAULT '0',
`ItemAppearanceModifierID` int NOT NULL DEFAULT '0',
`ItemAppearanceID` int NOT NULL DEFAULT '0',
`OrderIndex` int NOT NULL DEFAULT '0',
@@ -5907,7 +5945,7 @@ CREATE TABLE `lfg_dungeons` (
`Name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`Description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`TypeID` tinyint unsigned NOT NULL DEFAULT '0',
- `Subtype` tinyint NOT NULL DEFAULT '0',
+ `Subtype` tinyint unsigned NOT NULL DEFAULT '0',
`Faction` tinyint NOT NULL DEFAULT '0',
`IconTextureFileID` int NOT NULL DEFAULT '0',
`RewardsBgTextureFileID` int NOT NULL DEFAULT '0',
@@ -5931,6 +5969,7 @@ CREATE TABLE `lfg_dungeons` (
`BonusReputationAmount` smallint unsigned NOT NULL DEFAULT '0',
`MentorItemLevel` smallint unsigned NOT NULL DEFAULT '0',
`MentorCharLevel` tinyint unsigned NOT NULL DEFAULT '0',
+ `MaxPremadeGroupSize` tinyint unsigned NOT NULL DEFAULT '0',
`ContentTuningID` int NOT NULL DEFAULT '0',
`Flags1` int NOT NULL DEFAULT '0',
`Flags2` int NOT NULL DEFAULT '0',
@@ -6276,7 +6315,7 @@ CREATE TABLE `map_difficulty` (
`Message` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`DifficultyID` int NOT NULL DEFAULT '0',
`LockID` int NOT NULL DEFAULT '0',
- `ResetInterval` tinyint NOT NULL DEFAULT '0',
+ `ResetInterval` 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',
@@ -6401,7 +6440,7 @@ DROP TABLE IF EXISTS `maw_power`;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `maw_power` (
`ID` int unsigned NOT NULL DEFAULT '0',
- `SpellID` int NOT NULL DEFAULT '0',
+ `SpellID` int unsigned NOT NULL DEFAULT '0',
`MawPowerRarityID` int NOT NULL DEFAULT '0',
`VerifiedBuild` int NOT NULL DEFAULT '0',
PRIMARY KEY (`ID`,`VerifiedBuild`)
@@ -6843,7 +6882,7 @@ CREATE TABLE `player_condition` (
`ChrSpecializationRole` tinyint NOT NULL DEFAULT '0',
`ModifierTreeID` int unsigned NOT NULL DEFAULT '0',
`PowerType` tinyint NOT NULL DEFAULT '0',
- `PowerTypeComp` tinyint NOT NULL DEFAULT '0',
+ `PowerTypeComp` tinyint unsigned NOT NULL DEFAULT '0',
`PowerTypeValue` tinyint unsigned NOT NULL DEFAULT '0',
`WeaponSubclassMask` int NOT NULL DEFAULT '0',
`MaxGuildLevel` tinyint unsigned NOT NULL DEFAULT '0',
@@ -7141,7 +7180,7 @@ DROP TABLE IF EXISTS `pvp_stat`;
CREATE TABLE `pvp_stat` (
`Description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`ID` int unsigned NOT NULL DEFAULT '0',
- `MapID` int NOT NULL DEFAULT '0',
+ `MapID` 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;
@@ -7184,7 +7223,7 @@ DROP TABLE IF EXISTS `pvp_talent`;
CREATE TABLE `pvp_talent` (
`Description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`ID` int unsigned NOT NULL DEFAULT '0',
- `SpecID` int NOT NULL DEFAULT '0',
+ `SpecID` int unsigned NOT NULL DEFAULT '0',
`SpellID` int NOT NULL DEFAULT '0',
`OverridesSpellID` int NOT NULL DEFAULT '0',
`Flags` int NOT NULL DEFAULT '0',
@@ -7271,7 +7310,7 @@ CREATE TABLE `pvp_tier` (
`MaxRating` smallint NOT NULL DEFAULT '0',
`PrevTier` int NOT NULL DEFAULT '0',
`NextTier` int NOT NULL DEFAULT '0',
- `BracketID` tinyint NOT NULL DEFAULT '0',
+ `BracketID` tinyint unsigned NOT NULL DEFAULT '0',
`Rank` tinyint NOT NULL DEFAULT '0',
`RankIconFileDataID` int NOT NULL DEFAULT '0',
`VerifiedBuild` int NOT NULL DEFAULT '0',
@@ -7867,7 +7906,7 @@ CREATE TABLE `skill_line_ability` (
`AbilityVerb` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`AbilityAllVerb` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`ID` int unsigned NOT NULL DEFAULT '0',
- `SkillLine` smallint NOT NULL DEFAULT '0',
+ `SkillLine` smallint unsigned NOT NULL DEFAULT '0',
`Spell` int NOT NULL DEFAULT '0',
`MinSkillLineRank` smallint NOT NULL DEFAULT '0',
`ClassMask` int NOT NULL DEFAULT '0',
@@ -7952,7 +7991,7 @@ DROP TABLE IF EXISTS `skill_line_x_trait_tree`;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `skill_line_x_trait_tree` (
`ID` int unsigned NOT NULL DEFAULT '0',
- `SkillLineID` int NOT NULL DEFAULT '0',
+ `SkillLineID` int unsigned NOT NULL DEFAULT '0',
`TraitTreeID` int NOT NULL DEFAULT '0',
`OrderIndex` int NOT NULL DEFAULT '0',
`VerifiedBuild` int NOT NULL DEFAULT '0',
@@ -7970,7 +8009,7 @@ DROP TABLE IF EXISTS `skill_race_class_info`;
CREATE TABLE `skill_race_class_info` (
`ID` int unsigned NOT NULL DEFAULT '0',
`RaceMask` bigint NOT NULL DEFAULT '0',
- `SkillID` smallint NOT NULL DEFAULT '0',
+ `SkillID` smallint unsigned NOT NULL DEFAULT '0',
`ClassMask` int NOT NULL DEFAULT '0',
`Flags` int NOT NULL DEFAULT '0',
`Availability` int NOT NULL DEFAULT '0',
@@ -8629,7 +8668,7 @@ DROP TABLE IF EXISTS `spell_learn_spell`;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `spell_learn_spell` (
`ID` int unsigned NOT NULL DEFAULT '0',
- `SpellID` int NOT NULL DEFAULT '0',
+ `SpellID` int unsigned NOT NULL DEFAULT '0',
`LearnSpellID` int NOT NULL DEFAULT '0',
`OverridesSpellID` int NOT NULL DEFAULT '0',
`VerifiedBuild` int NOT NULL DEFAULT '0',
@@ -8681,6 +8720,7 @@ CREATE TABLE `spell_misc` (
`Attributes13` int NOT NULL DEFAULT '0',
`Attributes14` int NOT NULL DEFAULT '0',
`Attributes15` int NOT NULL DEFAULT '0',
+ `Attributes16` int NOT NULL DEFAULT '0',
`DifficultyID` tinyint unsigned NOT NULL DEFAULT '0',
`CastingTimeIndex` smallint unsigned NOT NULL DEFAULT '0',
`DurationIndex` smallint unsigned NOT NULL DEFAULT '0',
@@ -8945,7 +8985,7 @@ DROP TABLE IF EXISTS `spell_reagents_currency`;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `spell_reagents_currency` (
`ID` int unsigned NOT NULL DEFAULT '0',
- `SpellID` int NOT NULL DEFAULT '0',
+ `SpellID` int unsigned NOT NULL DEFAULT '0',
`CurrencyTypesID` smallint unsigned NOT NULL DEFAULT '0',
`CurrencyCount` smallint unsigned NOT NULL DEFAULT '0',
`VerifiedBuild` int NOT NULL DEFAULT '0',
@@ -9537,7 +9577,7 @@ DROP TABLE IF EXISTS `trait_cond`;
CREATE TABLE `trait_cond` (
`ID` int unsigned NOT NULL DEFAULT '0',
`CondType` int NOT NULL DEFAULT '0',
- `TraitTreeID` int NOT NULL DEFAULT '0',
+ `TraitTreeID` int unsigned NOT NULL DEFAULT '0',
`GrantedRanks` int NOT NULL DEFAULT '0',
`QuestID` int NOT NULL DEFAULT '0',
`AchievementID` int NOT NULL DEFAULT '0',
@@ -9602,7 +9642,7 @@ DROP TABLE IF EXISTS `trait_currency_source`;
CREATE TABLE `trait_currency_source` (
`Requirement` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`ID` int unsigned NOT NULL DEFAULT '0',
- `TraitCurrencyID` int NOT NULL DEFAULT '0',
+ `TraitCurrencyID` int unsigned NOT NULL DEFAULT '0',
`Amount` int NOT NULL DEFAULT '0',
`QuestID` int NOT NULL DEFAULT '0',
`AchievementID` int NOT NULL DEFAULT '0',
@@ -9671,7 +9711,7 @@ DROP TABLE IF EXISTS `trait_definition_effect_points`;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `trait_definition_effect_points` (
`ID` int unsigned NOT NULL DEFAULT '0',
- `TraitDefinitionID` int NOT NULL DEFAULT '0',
+ `TraitDefinitionID` int unsigned NOT NULL DEFAULT '0',
`EffectIndex` int NOT NULL DEFAULT '0',
`OperationType` int NOT NULL DEFAULT '0',
`CurveID` int NOT NULL DEFAULT '0',
@@ -9719,7 +9759,7 @@ DROP TABLE IF EXISTS `trait_edge`;
CREATE TABLE `trait_edge` (
`ID` int unsigned NOT NULL DEFAULT '0',
`VisualStyle` int NOT NULL DEFAULT '0',
- `LeftTraitNodeID` int NOT NULL DEFAULT '0',
+ `LeftTraitNodeID` int unsigned NOT NULL DEFAULT '0',
`RightTraitNodeID` int NOT NULL DEFAULT '0',
`Type` int NOT NULL DEFAULT '0',
`VerifiedBuild` int NOT NULL DEFAULT '0',
@@ -9736,7 +9776,7 @@ DROP TABLE IF EXISTS `trait_node`;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `trait_node` (
`ID` int unsigned NOT NULL DEFAULT '0',
- `TraitTreeID` int NOT NULL DEFAULT '0',
+ `TraitTreeID` int unsigned NOT NULL DEFAULT '0',
`PosX` int NOT NULL DEFAULT '0',
`PosY` int NOT NULL DEFAULT '0',
`Type` tinyint unsigned NOT NULL DEFAULT '0',
@@ -9775,7 +9815,7 @@ DROP TABLE IF EXISTS `trait_node_entry_x_trait_cond`;
CREATE TABLE `trait_node_entry_x_trait_cond` (
`ID` int unsigned NOT NULL DEFAULT '0',
`TraitCondID` int NOT NULL DEFAULT '0',
- `TraitNodeEntryID` int NOT NULL DEFAULT '0',
+ `TraitNodeEntryID` 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;
@@ -9790,7 +9830,7 @@ DROP TABLE IF EXISTS `trait_node_entry_x_trait_cost`;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `trait_node_entry_x_trait_cost` (
`ID` int unsigned NOT NULL DEFAULT '0',
- `TraitNodeEntryID` int NOT NULL DEFAULT '0',
+ `TraitNodeEntryID` int unsigned NOT NULL DEFAULT '0',
`TraitCostID` int NOT NULL DEFAULT '0',
`VerifiedBuild` int NOT NULL DEFAULT '0',
PRIMARY KEY (`ID`,`VerifiedBuild`)
@@ -9806,7 +9846,7 @@ DROP TABLE IF EXISTS `trait_node_group`;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `trait_node_group` (
`ID` int unsigned NOT NULL DEFAULT '0',
- `TraitTreeID` int NOT NULL DEFAULT '0',
+ `TraitTreeID` int unsigned NOT NULL DEFAULT '0',
`Flags` int NOT NULL DEFAULT '0',
`VerifiedBuild` int NOT NULL DEFAULT '0',
PRIMARY KEY (`ID`,`VerifiedBuild`)
@@ -9823,7 +9863,7 @@ DROP TABLE IF EXISTS `trait_node_group_x_trait_cond`;
CREATE TABLE `trait_node_group_x_trait_cond` (
`ID` int unsigned NOT NULL DEFAULT '0',
`TraitCondID` int NOT NULL DEFAULT '0',
- `TraitNodeGroupID` int NOT NULL DEFAULT '0',
+ `TraitNodeGroupID` 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;
@@ -9838,7 +9878,7 @@ DROP TABLE IF EXISTS `trait_node_group_x_trait_cost`;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `trait_node_group_x_trait_cost` (
`ID` int unsigned NOT NULL DEFAULT '0',
- `TraitNodeGroupID` int NOT NULL DEFAULT '0',
+ `TraitNodeGroupID` int unsigned NOT NULL DEFAULT '0',
`TraitCostID` int NOT NULL DEFAULT '0',
`VerifiedBuild` int NOT NULL DEFAULT '0',
PRIMARY KEY (`ID`,`VerifiedBuild`)
@@ -9854,7 +9894,7 @@ DROP TABLE IF EXISTS `trait_node_group_x_trait_node`;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `trait_node_group_x_trait_node` (
`ID` int unsigned NOT NULL DEFAULT '0',
- `TraitNodeGroupID` int NOT NULL DEFAULT '0',
+ `TraitNodeGroupID` int unsigned NOT NULL DEFAULT '0',
`TraitNodeID` int NOT NULL DEFAULT '0',
`Index` int NOT NULL DEFAULT '0',
`VerifiedBuild` int NOT NULL DEFAULT '0',
@@ -9872,7 +9912,7 @@ DROP TABLE IF EXISTS `trait_node_x_trait_cond`;
CREATE TABLE `trait_node_x_trait_cond` (
`ID` int unsigned NOT NULL DEFAULT '0',
`TraitCondID` int NOT NULL DEFAULT '0',
- `TraitNodeID` int NOT NULL DEFAULT '0',
+ `TraitNodeID` 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;
@@ -9887,7 +9927,7 @@ DROP TABLE IF EXISTS `trait_node_x_trait_cost`;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `trait_node_x_trait_cost` (
`ID` int unsigned NOT NULL DEFAULT '0',
- `TraitNodeID` int NOT NULL DEFAULT '0',
+ `TraitNodeID` int unsigned NOT NULL DEFAULT '0',
`TraitCostID` int NOT NULL DEFAULT '0',
`VerifiedBuild` int NOT NULL DEFAULT '0',
PRIMARY KEY (`ID`,`VerifiedBuild`)
@@ -9903,7 +9943,7 @@ DROP TABLE IF EXISTS `trait_node_x_trait_node_entry`;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `trait_node_x_trait_node_entry` (
`ID` int unsigned NOT NULL DEFAULT '0',
- `TraitNodeID` int NOT NULL DEFAULT '0',
+ `TraitNodeID` int unsigned NOT NULL DEFAULT '0',
`TraitNodeEntryID` int NOT NULL DEFAULT '0',
`Index` int NOT NULL DEFAULT '0',
`VerifiedBuild` int NOT NULL DEFAULT '0',
@@ -9923,7 +9963,7 @@ CREATE TABLE `trait_sub_tree` (
`Description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`ID` int unsigned NOT NULL DEFAULT '0',
`UiTextureAtlasElementID` int NOT NULL DEFAULT '0',
- `TraitTreeID` int NOT NULL DEFAULT '0',
+ `TraitTreeID` 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;
@@ -9966,7 +10006,7 @@ DROP TABLE IF EXISTS `trait_tree`;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `trait_tree` (
`ID` int unsigned NOT NULL DEFAULT '0',
- `TraitSystemID` int NOT NULL DEFAULT '0',
+ `TraitSystemID` int unsigned NOT NULL DEFAULT '0',
`Unused1000_1` int NOT NULL DEFAULT '0',
`FirstTraitNodeID` int NOT NULL DEFAULT '0',
`PlayerConditionID` int NOT NULL DEFAULT '0',
@@ -9987,7 +10027,7 @@ DROP TABLE IF EXISTS `trait_tree_loadout`;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `trait_tree_loadout` (
`ID` int unsigned NOT NULL DEFAULT '0',
- `TraitTreeID` int NOT NULL DEFAULT '0',
+ `TraitTreeID` int unsigned NOT NULL DEFAULT '0',
`ChrSpecializationID` int NOT NULL DEFAULT '0',
`VerifiedBuild` int NOT NULL DEFAULT '0',
PRIMARY KEY (`ID`,`VerifiedBuild`)
@@ -10003,7 +10043,7 @@ DROP TABLE IF EXISTS `trait_tree_loadout_entry`;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `trait_tree_loadout_entry` (
`ID` int unsigned NOT NULL DEFAULT '0',
- `TraitTreeLoadoutID` int NOT NULL DEFAULT '0',
+ `TraitTreeLoadoutID` int unsigned NOT NULL DEFAULT '0',
`SelectedTraitNodeID` int NOT NULL DEFAULT '0',
`SelectedTraitNodeEntryID` int NOT NULL DEFAULT '0',
`NumPoints` int NOT NULL DEFAULT '0',
@@ -10039,7 +10079,7 @@ DROP TABLE IF EXISTS `trait_tree_x_trait_currency`;
CREATE TABLE `trait_tree_x_trait_currency` (
`ID` int unsigned NOT NULL DEFAULT '0',
`Index` int NOT NULL DEFAULT '0',
- `TraitTreeID` int NOT NULL DEFAULT '0',
+ `TraitTreeID` int unsigned NOT NULL DEFAULT '0',
`TraitCurrencyID` int NOT NULL DEFAULT '0',
`VerifiedBuild` int NOT NULL DEFAULT '0',
PRIMARY KEY (`ID`,`VerifiedBuild`)
@@ -10094,7 +10134,7 @@ CREATE TABLE `transmog_set` (
`Flags` int NOT NULL DEFAULT '0',
`TransmogSetGroupID` int NOT NULL DEFAULT '0',
`ItemNameDescriptionID` int NOT NULL DEFAULT '0',
- `ParentTransmogSetID` int NOT NULL DEFAULT '0',
+ `ParentTransmogSetID` int unsigned NOT NULL DEFAULT '0',
`Unknown810` int NOT NULL DEFAULT '0',
`ExpansionID` int NOT NULL DEFAULT '0',
`PatchID` int NOT NULL DEFAULT '0',
@@ -10241,9 +10281,9 @@ DROP TABLE IF EXISTS `ui_map`;
CREATE TABLE `ui_map` (
`Name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`ID` int unsigned NOT NULL DEFAULT '0',
- `ParentUiMapID` int NOT NULL DEFAULT '0',
+ `ParentUiMapID` int unsigned NOT NULL DEFAULT '0',
`Flags` int NOT NULL DEFAULT '0',
- `System` tinyint NOT NULL DEFAULT '0',
+ `System` tinyint unsigned NOT NULL DEFAULT '0',
`Type` tinyint unsigned NOT NULL DEFAULT '0',
`BountySetID` int NOT NULL DEFAULT '0',
`BountyDisplayLocation` int unsigned NOT NULL DEFAULT '0',
@@ -10279,7 +10319,7 @@ CREATE TABLE `ui_map_assignment` (
`Region2Y` float NOT NULL DEFAULT '0',
`Region2Z` float NOT NULL DEFAULT '0',
`ID` int unsigned NOT NULL DEFAULT '0',
- `UiMapID` int NOT NULL DEFAULT '0',
+ `UiMapID` int unsigned NOT NULL DEFAULT '0',
`OrderIndex` int NOT NULL DEFAULT '0',
`MapID` int NOT NULL DEFAULT '0',
`AreaID` int NOT NULL DEFAULT '0',
@@ -10303,7 +10343,7 @@ CREATE TABLE `ui_map_link` (
`UiMaxX` float NOT NULL DEFAULT '0',
`UiMaxY` float NOT NULL DEFAULT '0',
`ID` int unsigned NOT NULL DEFAULT '0',
- `ParentUiMapID` int NOT NULL DEFAULT '0',
+ `ParentUiMapID` int unsigned NOT NULL DEFAULT '0',
`OrderIndex` int NOT NULL DEFAULT '0',
`ChildUiMapID` int NOT NULL DEFAULT '0',
`PlayerConditionID` int NOT NULL DEFAULT '0',
@@ -10377,7 +10417,7 @@ CREATE TABLE `ui_splash_screen` (
`RightFeatureDesc` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`AllianceQuestID` int NOT NULL DEFAULT '0',
`HordeQuestID` int NOT NULL DEFAULT '0',
- `ScreenType` tinyint NOT NULL DEFAULT '0',
+ `ScreenType` tinyint unsigned NOT NULL DEFAULT '0',
`TextureKitID` int NOT NULL DEFAULT '0',
`SoundKitID` int NOT NULL DEFAULT '0',
`PlayerConditionID` int NOT NULL DEFAULT '0',
@@ -10864,4 +10904,4 @@ CREATE TABLE `world_state_expression` (
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
--- Dump completed on 2024-09-23 22:48:16
+-- Dump completed on 2024-11-16 21:57:45
diff --git a/sql/base/dev/world_database.sql b/sql/base/dev/world_database.sql
index e35107b5ea3..94e00c15396 100644
--- a/sql/base/dev/world_database.sql
+++ b/sql/base/dev/world_database.sql
@@ -1,8 +1,8 @@
--- MySQL dump 10.13 Distrib 8.0.39, for Linux (x86_64)
+-- MySQL dump 10.13 Distrib 8.0.40, for Linux (x86_64)
--
-- Host: localhost Database: world
-- ------------------------------------------------------
--- Server version 8.0.39-0ubuntu0.22.04.1
+-- Server version 8.0.40-0ubuntu0.22.04.1
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
@@ -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=2167 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Tele Command';
+) ENGINE=InnoDB AUTO_INCREMENT=2183 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Tele Command';
/*!40101 SET character_set_client = @saved_cs_client */;
--
@@ -4932,7 +4932,7 @@ CREATE TABLE `world_state` (
/*!50001 SET character_set_results = utf8mb3 */;
/*!50001 SET collation_connection = utf8mb3_general_ci */;
/*!50001 CREATE ALGORITHM=UNDEFINED */
-/*!50013 */
+/*!50013 SQL SECURITY DEFINER */
/*!50001 VIEW `vw_conditions_with_labels` AS select (case when (`conditions`.`SourceTypeOrReferenceId` = 0) then 'CONDITION_SOURCE_TYPE_NONE' when (`conditions`.`SourceTypeOrReferenceId` = 1) then 'CONDITION_SOURCE_TYPE_CREATURE_LOOT_TEMPLATE' when (`conditions`.`SourceTypeOrReferenceId` = 2) then 'CONDITION_SOURCE_TYPE_DISENCHANT_LOOT_TEMPLATE' when (`conditions`.`SourceTypeOrReferenceId` = 3) then 'CONDITION_SOURCE_TYPE_FISHING_LOOT_TEMPLATE' when (`conditions`.`SourceTypeOrReferenceId` = 4) then 'CONDITION_SOURCE_TYPE_GAMEOBJECT_LOOT_TEMPLATE' when (`conditions`.`SourceTypeOrReferenceId` = 5) then 'CONDITION_SOURCE_TYPE_ITEM_LOOT_TEMPLATE' when (`conditions`.`SourceTypeOrReferenceId` = 6) then 'CONDITION_SOURCE_TYPE_MAIL_LOOT_TEMPLATE' when (`conditions`.`SourceTypeOrReferenceId` = 7) then 'CONDITION_SOURCE_TYPE_MILLING_LOOT_TEMPLATE' when (`conditions`.`SourceTypeOrReferenceId` = 8) then 'CONDITION_SOURCE_TYPE_PICKPOCKETING_LOOT_TEMPLATE' when (`conditions`.`SourceTypeOrReferenceId` = 9) then 'CONDITION_SOURCE_TYPE_PROSPECTING_LOOT_TEMPLATE' when (`conditions`.`SourceTypeOrReferenceId` = 10) then 'CONDITION_SOURCE_TYPE_REFERENCE_LOOT_TEMPLATE' when (`conditions`.`SourceTypeOrReferenceId` = 11) then 'CONDITION_SOURCE_TYPE_SKINNING_LOOT_TEMPLATE' when (`conditions`.`SourceTypeOrReferenceId` = 12) then 'CONDITION_SOURCE_TYPE_SPELL_LOOT_TEMPLATE' when (`conditions`.`SourceTypeOrReferenceId` = 13) then 'CONDITION_SOURCE_TYPE_SPELL_IMPLICIT_TARGET' when (`conditions`.`SourceTypeOrReferenceId` = 14) then 'CONDITION_SOURCE_TYPE_GOSSIP_MENU' when (`conditions`.`SourceTypeOrReferenceId` = 15) then 'CONDITION_SOURCE_TYPE_GOSSIP_MENU_OPTION' when (`conditions`.`SourceTypeOrReferenceId` = 16) then 'CONDITION_SOURCE_TYPE_CREATURE_TEMPLATE_VEHICLE' when (`conditions`.`SourceTypeOrReferenceId` = 17) then 'CONDITION_SOURCE_TYPE_SPELL' when (`conditions`.`SourceTypeOrReferenceId` = 18) then 'CONDITION_SOURCE_TYPE_SPELL_CLICK_EVENT' when (`conditions`.`SourceTypeOrReferenceId` = 19) then 'CONDITION_SOURCE_TYPE_QUEST_AVAILABLE' when (`conditions`.`SourceTypeOrReferenceId` = 21) then 'CONDITION_SOURCE_TYPE_VEHICLE_SPELL' when (`conditions`.`SourceTypeOrReferenceId` = 22) then 'CONDITION_SOURCE_TYPE_SMART_EVENT' when (`conditions`.`SourceTypeOrReferenceId` = 23) then 'CONDITION_SOURCE_TYPE_NPC_VENDOR' when (`conditions`.`SourceTypeOrReferenceId` = 24) then 'CONDITION_SOURCE_TYPE_SPELL_PROC' when (`conditions`.`SourceTypeOrReferenceId` = 25) then 'CONDITION_SOURCE_TYPE_TERRAIN_SWAP' when (`conditions`.`SourceTypeOrReferenceId` = 26) then 'CONDITION_SOURCE_TYPE_PHASE' when (`conditions`.`SourceTypeOrReferenceId` = 27) then 'CONDITION_SOURCE_TYPE_GRAVEYARD' when (`conditions`.`SourceTypeOrReferenceId` = 28) then 'CONDITION_SOURCE_TYPE_AREATRIGGER' when (`conditions`.`SourceTypeOrReferenceId` = 29) then 'CONDITION_SOURCE_TYPE_CONVERSATION_LINE' when (`conditions`.`SourceTypeOrReferenceId` = 30) then 'CONDITION_SOURCE_TYPE_AREATRIGGER_CLIENT_TRIGGERED' when (`conditions`.`SourceTypeOrReferenceId` = 31) then 'CONDITION_SOURCE_TYPE_TRAINER_SPELL' when (`conditions`.`SourceTypeOrReferenceId` = 32) then 'CONDITION_SOURCE_TYPE_OBJECT_ID_VISIBILITY' else `conditions`.`SourceTypeOrReferenceId` end) AS `SourceTypeOrReferenceId`,`conditions`.`SourceGroup` AS `SourceGroup`,`conditions`.`SourceEntry` AS `SourceEntry`,`conditions`.`SourceId` AS `SourceId`,`conditions`.`ElseGroup` AS `ElseGroup`,(case when (`conditions`.`SourceTypeOrReferenceId` = 0) then 'CONDITION_NONE' when (`conditions`.`SourceTypeOrReferenceId` = 1) then 'CONDITION_AURA' when (`conditions`.`SourceTypeOrReferenceId` = 2) then 'CONDITION_ITEM' when (`conditions`.`SourceTypeOrReferenceId` = 3) then 'CONDITION_ITEM_EQUIPPED' when (`conditions`.`SourceTypeOrReferenceId` = 4) then 'CONDITION_ZONEID' when (`conditions`.`SourceTypeOrReferenceId` = 5) then 'CONDITION_REPUTATION_RANK' when (`conditions`.`SourceTypeOrReferenceId` = 6) then 'CONDITION_TEAM' when (`conditions`.`SourceTypeOrReferenceId` = 7) then 'CONDITION_SKILL' when (`conditions`.`SourceTypeOrReferenceId` = 8) then 'CONDITION_QUESTREWARDED' when (`conditions`.`SourceTypeOrReferenceId` = 9) then 'CONDITION_QUESTTAKEN' when (`conditions`.`SourceTypeOrReferenceId` = 10) then 'CONDITION_DRUNKENSTATE' when (`conditions`.`SourceTypeOrReferenceId` = 11) then 'CONDITION_WORLD_STATE' when (`conditions`.`SourceTypeOrReferenceId` = 12) then 'CONDITION_ACTIVE_EVENT' when (`conditions`.`SourceTypeOrReferenceId` = 13) then 'CONDITION_INSTANCE_INFO' when (`conditions`.`SourceTypeOrReferenceId` = 14) then 'CONDITION_QUEST_NONE' when (`conditions`.`SourceTypeOrReferenceId` = 15) then 'CONDITION_CLASS' when (`conditions`.`SourceTypeOrReferenceId` = 16) then 'CONDITION_RACE' when (`conditions`.`SourceTypeOrReferenceId` = 17) then 'CONDITION_ACHIEVEMENT' when (`conditions`.`SourceTypeOrReferenceId` = 18) then 'CONDITION_TITLE' when (`conditions`.`SourceTypeOrReferenceId` = 19) then 'CONDITION_SPAWNMASK' when (`conditions`.`SourceTypeOrReferenceId` = 20) then 'CONDITION_GENDER' when (`conditions`.`SourceTypeOrReferenceId` = 21) then 'CONDITION_UNIT_STATE' when (`conditions`.`SourceTypeOrReferenceId` = 22) then 'CONDITION_MAPID' when (`conditions`.`SourceTypeOrReferenceId` = 23) then 'CONDITION_AREAID' when (`conditions`.`SourceTypeOrReferenceId` = 24) then 'CONDITION_CREATURE_TYPE' when (`conditions`.`SourceTypeOrReferenceId` = 25) then 'CONDITION_SPELL' when (`conditions`.`SourceTypeOrReferenceId` = 26) then 'CONDITION_PHASEMASK' when (`conditions`.`SourceTypeOrReferenceId` = 27) then 'CONDITION_LEVEL' when (`conditions`.`SourceTypeOrReferenceId` = 28) then 'CONDITION_QUEST_COMPLETE' when (`conditions`.`SourceTypeOrReferenceId` = 29) then 'CONDITION_NEAR_CREATURE' when (`conditions`.`SourceTypeOrReferenceId` = 30) then 'CONDITION_NEAR_GAMEOBJECT' when (`conditions`.`SourceTypeOrReferenceId` = 31) then 'CONDITION_OBJECT_ENTRY_GUID_LEGACY' when (`conditions`.`SourceTypeOrReferenceId` = 32) then 'CONDITION_TYPE_MASK_LEGACY' when (`conditions`.`SourceTypeOrReferenceId` = 33) then 'CONDITION_RELATION_TO' when (`conditions`.`SourceTypeOrReferenceId` = 34) then 'CONDITION_REACTION_TO' when (`conditions`.`SourceTypeOrReferenceId` = 35) then 'CONDITION_DISTANCE_TO' when (`conditions`.`SourceTypeOrReferenceId` = 36) then 'CONDITION_ALIVE' when (`conditions`.`SourceTypeOrReferenceId` = 37) then 'CONDITION_HP_VAL' when (`conditions`.`SourceTypeOrReferenceId` = 38) then 'CONDITION_HP_PCT' when (`conditions`.`SourceTypeOrReferenceId` = 39) then 'CONDITION_REALM_ACHIEVEMENT' when (`conditions`.`SourceTypeOrReferenceId` = 40) then 'CONDITION_IN_WATER' when (`conditions`.`SourceTypeOrReferenceId` = 41) then 'CONDITION_TERRAIN_SWAP' when (`conditions`.`SourceTypeOrReferenceId` = 42) then 'CONDITION_STAND_STATE' when (`conditions`.`SourceTypeOrReferenceId` = 43) then 'CONDITION_DAILY_QUEST_DONE' when (`conditions`.`SourceTypeOrReferenceId` = 44) then 'CONDITION_CHARMED' when (`conditions`.`SourceTypeOrReferenceId` = 45) then 'CONDITION_PET_TYPE' when (`conditions`.`SourceTypeOrReferenceId` = 46) then 'CONDITION_TAXI' when (`conditions`.`SourceTypeOrReferenceId` = 47) then 'CONDITION_QUESTSTATE' when (`conditions`.`SourceTypeOrReferenceId` = 48) then 'CONDITION_QUEST_OBJECTIVE_PROGRESS' when (`conditions`.`SourceTypeOrReferenceId` = 49) then 'CONDITION_DIFFICULTY_ID' when (`conditions`.`SourceTypeOrReferenceId` = 50) then 'CONDITION_GAMEMASTER' when (`conditions`.`SourceTypeOrReferenceId` = 51) then 'CONDITION_OBJECT_ENTRY_GUID' when (`conditions`.`SourceTypeOrReferenceId` = 52) then 'CONDITION_TYPE_MASK' else `conditions`.`ConditionTypeOrReference` end) AS `ConditionTypeOrReference`,`conditions`.`ConditionTarget` AS `ConditionTarget`,`conditions`.`ConditionValue1` AS `ConditionValue1`,`conditions`.`ConditionValue2` AS `ConditionValue2`,`conditions`.`ConditionValue3` AS `ConditionValue3`,`conditions`.`NegativeCondition` AS `NegativeCondition`,`conditions`.`ErrorType` AS `ErrorType`,`conditions`.`ErrorTextId` AS `ErrorTextId`,`conditions`.`ScriptName` AS `ScriptName`,`conditions`.`Comment` AS `Comment` from `conditions` */;
/*!50001 SET character_set_client = @saved_cs_client */;
/*!50001 SET character_set_results = @saved_cs_results */;
@@ -4950,7 +4950,7 @@ CREATE TABLE `world_state` (
/*!50001 SET character_set_results = utf8mb3 */;
/*!50001 SET collation_connection = utf8mb3_general_ci */;
/*!50001 CREATE ALGORITHM=UNDEFINED */
-/*!50013 */
+/*!50013 SQL SECURITY DEFINER */
/*!50001 VIEW `vw_disables_with_labels` AS select (case when (`disables`.`sourceType` = 0) then 'DISABLE_TYPE_SPELL' when (`disables`.`sourceType` = 1) then 'DISABLE_TYPE_QUEST' when (`disables`.`sourceType` = 2) then 'DISABLE_TYPE_MAP' when (`disables`.`sourceType` = 3) then 'DISABLE_TYPE_BATTLEGROUND' when (`disables`.`sourceType` = 4) then 'DISABLE_TYPE_ACHIEVEMENT_CRITERIA' when (`disables`.`sourceType` = 5) then 'DISABLE_TYPE_OUTDOORPVP' when (`disables`.`sourceType` = 6) then 'DISABLE_TYPE_VMAP' when (`disables`.`sourceType` = 7) then 'DISABLE_TYPE_MMAP' when (`disables`.`sourceType` = 8) then 'DISABLE_TYPE_LFG_MAP' else `disables`.`sourceType` end) AS `sourceType`,`disables`.`entry` AS `entry`,`disables`.`flags` AS `flags`,`disables`.`params_0` AS `params_0`,`disables`.`params_1` AS `params_1`,`disables`.`comment` AS `comment` from `disables` */;
/*!50001 SET character_set_client = @saved_cs_client */;
/*!50001 SET character_set_results = @saved_cs_results */;
@@ -4968,7 +4968,7 @@ CREATE TABLE `world_state` (
/*!50001 SET character_set_results = utf8mb3 */;
/*!50001 SET collation_connection = utf8mb3_general_ci */;
/*!50001 CREATE ALGORITHM=UNDEFINED */
-/*!50013 */
+/*!50013 SQL SECURITY DEFINER */
/*!50001 VIEW `vw_smart_scripts_with_labels` AS select `smart_scripts`.`entryorguid` AS `entryorguid`,`smart_scripts`.`source_type` AS `source_type`,`smart_scripts`.`id` AS `id`,`smart_scripts`.`link` AS `link`,(case `smart_scripts`.`event_type` when 0 then 'SMART_EVENT_UPDATE_IC' when 1 then 'SMART_EVENT_UPDATE_OOC' when 2 then 'SMART_EVENT_HEALTH_PCT' when 3 then 'SMART_EVENT_MANA_PCT' when 4 then 'SMART_EVENT_AGGRO' when 5 then 'SMART_EVENT_KILL' when 6 then 'SMART_EVENT_DEATH' when 7 then 'SMART_EVENT_EVADE' when 8 then 'SMART_EVENT_SPELLHIT' when 9 then 'SMART_EVENT_RANGE' when 10 then 'SMART_EVENT_OOC_LOS' when 11 then 'SMART_EVENT_RESPAWN' when 12 then 'SMART_EVENT_TARGET_HEALTH_PCT' when 13 then 'SMART_EVENT_VICTIM_CASTING' when 14 then 'SMART_EVENT_FRIENDLY_HEALTH' when 15 then 'SMART_EVENT_FRIENDLY_IS_CC' when 16 then 'SMART_EVENT_FRIENDLY_MISSING_BUFF' when 17 then 'SMART_EVENT_SUMMONED_UNIT' when 18 then 'SMART_EVENT_TARGET_MANA_PCT' when 19 then 'SMART_EVENT_ACCEPTED_QUEST' when 20 then 'SMART_EVENT_REWARD_QUEST' when 21 then 'SMART_EVENT_REACHED_HOME' when 22 then 'SMART_EVENT_RECEIVE_EMOTE' when 23 then 'SMART_EVENT_HAS_AURA' when 24 then 'SMART_EVENT_TARGET_BUFFED' when 25 then 'SMART_EVENT_RESET' when 26 then 'SMART_EVENT_IC_LOS' when 27 then 'SMART_EVENT_PASSENGER_BOARDED' when 28 then 'SMART_EVENT_PASSENGER_REMOVED' when 29 then 'SMART_EVENT_CHARMED' when 30 then 'SMART_EVENT_CHARMED_TARGET' when 31 then 'SMART_EVENT_SPELLHIT_TARGET' when 32 then 'SMART_EVENT_DAMAGED' when 33 then 'SMART_EVENT_DAMAGED_TARGET' when 34 then 'SMART_EVENT_MOVEMENTINFORM' when 35 then 'SMART_EVENT_SUMMON_DESPAWNED' when 36 then 'SMART_EVENT_CORPSE_REMOVED' when 37 then 'SMART_EVENT_AI_INIT' when 38 then 'SMART_EVENT_DATA_SET' when 39 then 'SMART_EVENT_WAYPOINT_START' when 40 then 'SMART_EVENT_WAYPOINT_REACHED' when 41 then 'SMART_EVENT_TRANSPORT_ADDPLAYER' when 42 then 'SMART_EVENT_TRANSPORT_ADDCREATURE' when 43 then 'SMART_EVENT_TRANSPORT_REMOVE_PLAYER' when 44 then 'SMART_EVENT_TRANSPORT_RELOCATE' when 45 then 'SMART_EVENT_INSTANCE_PLAYER_ENTER' when 46 then 'SMART_EVENT_AREATRIGGER_ONTRIGGER' when 47 then 'SMART_EVENT_QUEST_ACCEPTED' when 48 then 'SMART_EVENT_QUEST_OBJ_COPLETETION' when 49 then 'SMART_EVENT_QUEST_COMPLETION' when 50 then 'SMART_EVENT_QUEST_REWARDED' when 51 then 'SMART_EVENT_QUEST_FAIL' when 52 then 'SMART_EVENT_TEXT_OVER' when 53 then 'SMART_EVENT_RECEIVE_HEAL' when 54 then 'SMART_EVENT_JUST_SUMMONED' when 55 then 'SMART_EVENT_WAYPOINT_PAUSED' when 56 then 'SMART_EVENT_WAYPOINT_RESUMED' when 57 then 'SMART_EVENT_WAYPOINT_STOPPED' when 58 then 'SMART_EVENT_WAYPOINT_ENDED' when 59 then 'SMART_EVENT_TIMED_EVENT_TRIGGERED' when 60 then 'SMART_EVENT_UPDATE' when 61 then 'SMART_EVENT_LINK' when 62 then 'SMART_EVENT_GOSSIP_SELECT' when 63 then 'SMART_EVENT_JUST_CREATED' when 64 then 'SMART_EVENT_GOSSIP_HELLO' when 65 then 'SMART_EVENT_FOLLOW_COMPLETED' when 66 then 'SMART_EVENT_EVENT_PHASE_CHANGE' when 67 then 'SMART_EVENT_IS_BEHIND_TARGET' when 68 then 'SMART_EVENT_GAME_EVENT_START' when 69 then 'SMART_EVENT_GAME_EVENT_END' when 70 then 'SMART_EVENT_GO_LOOT_STATE_CHANGED' when 71 then 'SMART_EVENT_GO_EVENT_INFORM' when 72 then 'SMART_EVENT_ACTION_DONE' when 73 then 'SMART_EVENT_ON_SPELLCLICK' when 74 then 'SMART_EVENT_FRIENDLY_HEALTH_PCT' when 75 then 'SMART_EVENT_DISTANCE_CREATURE' when 76 then 'SMART_EVENT_DISTANCE_GAMEOBJECT' when 77 then 'SMART_EVENT_COUNTER_SET' when 78 then 'SMART_EVENT_SCENE_START' when 79 then 'SMART_EVENT_SCENE_TRIGGER' when 80 then 'SMART_EVENT_SCENE_CANCEL' when 81 then 'SMART_EVENT_SCENE_COMPLETE' when 82 then 'SMART_EVENT_SUMMONED_UNIT_DIES' else `smart_scripts`.`event_type` end) AS `event_type`,`smart_scripts`.`event_phase_mask` AS `event_phase_mask`,`smart_scripts`.`event_chance` AS `event_chance`,`smart_scripts`.`event_flags` AS `event_flags`,`smart_scripts`.`event_param1` AS `event_param1`,`smart_scripts`.`event_param2` AS `event_param2`,`smart_scripts`.`event_param3` AS `event_param3`,`smart_scripts`.`event_param4` AS `event_param4`,`smart_scripts`.`event_param5` AS `event_param5`,(case `smart_scripts`.`action_type` when 0 then 'SMART_ACTION_NONE' when 1 then 'SMART_ACTION_TALK' when 2 then 'SMART_ACTION_SET_FACTION' when 3 then 'SMART_ACTION_MORPH_TO_ENTRY_OR_MODEL' when 4 then 'SMART_ACTION_SOUND' when 5 then 'SMART_ACTION_PLAY_EMOTE' when 6 then 'SMART_ACTION_FAIL_QUEST' when 7 then 'SMART_ACTION_OFFER_QUEST' when 8 then 'SMART_ACTION_SET_REACT_STATE' when 9 then 'SMART_ACTION_ACTIVATE_GOBJECT' when 10 then 'SMART_ACTION_RANDOM_EMOTE' when 11 then 'SMART_ACTION_CAST' when 12 then 'SMART_ACTION_SUMMON_CREATURE' when 13 then 'SMART_ACTION_THREAT_SINGLE_PCT' when 14 then 'SMART_ACTION_THREAT_ALL_PCT' when 15 then 'SMART_ACTION_CALL_AREAEXPLOREDOREVENTHAPPENS' when 16 then 'SMART_ACTION_SET_INGAME_PHASE_GROUP' when 17 then 'SMART_ACTION_SET_EMOTE_STATE' when 18 then 'SMART_ACTION_SET_UNIT_FLAG' when 19 then 'SMART_ACTION_REMOVE_UNIT_FLAG' when 20 then 'SMART_ACTION_AUTO_ATTACK' when 21 then 'SMART_ACTION_ALLOW_COMBAT_MOVEMENT' when 22 then 'SMART_ACTION_SET_EVENT_PHASE' when 23 then 'SMART_ACTION_INC_EVENT_PHASE' when 24 then 'SMART_ACTION_EVADE' when 25 then 'SMART_ACTION_FLEE_FOR_ASSIST' when 26 then 'SMART_ACTION_CALL_GROUPEVENTHAPPENS' when 27 then 'SMART_ACTION_COMBAT_STOP' when 28 then 'SMART_ACTION_REMOVEAURASFROMSPELL' when 29 then 'SMART_ACTION_FOLLOW' when 30 then 'SMART_ACTION_RANDOM_PHASE' when 31 then 'SMART_ACTION_RANDOM_PHASE_RANGE' when 32 then 'SMART_ACTION_RESET_GOBJECT' when 33 then 'SMART_ACTION_CALL_KILLEDMONSTER' when 34 then 'SMART_ACTION_SET_INST_DATA' when 35 then 'SMART_ACTION_SET_INST_DATA64' when 36 then 'SMART_ACTION_UPDATE_TEMPLATE' when 37 then 'SMART_ACTION_DIE' when 38 then 'SMART_ACTION_SET_IN_COMBAT_WITH_ZONE' when 39 then 'SMART_ACTION_CALL_FOR_HELP' when 40 then 'SMART_ACTION_SET_SHEATH' when 41 then 'SMART_ACTION_FORCE_DESPAWN' when 42 then 'SMART_ACTION_SET_INVINCIBILITY_HP_LEVEL' when 43 then 'SMART_ACTION_MOUNT_TO_ENTRY_OR_MODEL' when 44 then 'SMART_ACTION_SET_INGAME_PHASE_ID' when 45 then 'SMART_ACTION_SET_DATA' when 46 then 'SMART_ACTION_ATTACK_STOP' when 47 then 'SMART_ACTION_SET_VISIBILITY' when 48 then 'SMART_ACTION_SET_ACTIVE' when 49 then 'SMART_ACTION_ATTACK_START' when 50 then 'SMART_ACTION_SUMMON_GO' when 51 then 'SMART_ACTION_KILL_UNIT' when 52 then 'SMART_ACTION_ACTIVATE_TAXI' when 53 then 'SMART_ACTION_WP_START' when 54 then 'SMART_ACTION_WP_PAUSE' when 55 then 'SMART_ACTION_WP_STOP' when 56 then 'SMART_ACTION_ADD_ITEM' when 57 then 'SMART_ACTION_REMOVE_ITEM' when 58 then 'SMART_ACTION_INSTALL_AI_TEMPLATE' when 59 then 'SMART_ACTION_SET_RUN' when 60 then 'SMART_ACTION_SET_DISABLE_GRAVITY' when 61 then 'SMART_ACTION_SET_SWIM' when 62 then 'SMART_ACTION_TELEPORT' when 63 then 'SMART_ACTION_SET_COUNTER' when 64 then 'SMART_ACTION_STORE_TARGET_LIST' when 65 then 'SMART_ACTION_WP_RESUME' when 66 then 'SMART_ACTION_SET_ORIENTATION' when 67 then 'SMART_ACTION_CREATE_TIMED_EVENT' when 68 then 'SMART_ACTION_PLAYMOVIE' when 69 then 'SMART_ACTION_MOVE_TO_POS' when 70 then 'SMART_ACTION_ENABLE_TEMP_GOBJ' when 71 then 'SMART_ACTION_EQUIP' when 72 then 'SMART_ACTION_CLOSE_GOSSIP' when 73 then 'SMART_ACTION_TRIGGER_TIMED_EVENT' when 74 then 'SMART_ACTION_REMOVE_TIMED_EVENT' when 75 then 'SMART_ACTION_ADD_AURA' when 76 then 'SMART_ACTION_OVERRIDE_SCRIPT_BASE_OBJECT' when 77 then 'SMART_ACTION_RESET_SCRIPT_BASE_OBJECT' when 78 then 'SMART_ACTION_CALL_SCRIPT_RESET' when 79 then 'SMART_ACTION_SET_RANGED_MOVEMENT' when 80 then 'SMART_ACTION_CALL_TIMED_ACTIONLIST' when 81 then 'SMART_ACTION_SET_NPC_FLAG' when 82 then 'SMART_ACTION_ADD_NPC_FLAG' when 83 then 'SMART_ACTION_REMOVE_NPC_FLAG' when 84 then 'SMART_ACTION_SIMPLE_TALK' when 85 then 'SMART_ACTION_SELF_CAST' when 86 then 'SMART_ACTION_CROSS_CAST' when 87 then 'SMART_ACTION_CALL_RANDOM_TIMED_ACTIONLIST' when 88 then 'SMART_ACTION_CALL_RANDOM_RANGE_TIMED_ACTIONLIST' when 89 then 'SMART_ACTION_RANDOM_MOVE' when 90 then 'SMART_ACTION_SET_UNIT_FIELD_BYTES_1' when 91 then 'SMART_ACTION_REMOVE_UNIT_FIELD_BYTES_1' when 92 then 'SMART_ACTION_INTERRUPT_SPELL' when 93 then 'SMART_ACTION_SEND_GO_CUSTOM_ANIM' when 94 then 'SMART_ACTION_SET_DYNAMIC_FLAG' when 95 then 'SMART_ACTION_ADD_DYNAMIC_FLAG' when 96 then 'SMART_ACTION_REMOVE_DYNAMIC_FLAG' when 97 then 'SMART_ACTION_JUMP_TO_POS' when 98 then 'SMART_ACTION_SEND_GOSSIP_MENU' when 99 then 'SMART_ACTION_GO_SET_LOOT_STATE' when 100 then 'SMART_ACTION_SEND_TARGET_TO_TARGET' when 101 then 'SMART_ACTION_SET_HOME_POS' when 102 then 'SMART_ACTION_SET_HEALTH_REGEN' when 103 then 'SMART_ACTION_SET_ROOT' when 104 then 'SMART_ACTION_SET_GO_FLAG' when 105 then 'SMART_ACTION_ADD_GO_FLAG' when 106 then 'SMART_ACTION_REMOVE_GO_FLAG' when 107 then 'SMART_ACTION_SUMMON_CREATURE_GROUP' when 108 then 'SMART_ACTION_SET_POWER' when 109 then 'SMART_ACTION_ADD_POWER' when 110 then 'SMART_ACTION_REMOVE_POWER' when 111 then 'SMART_ACTION_GAME_EVENT_STOP' when 112 then 'SMART_ACTION_GAME_EVENT_START' when 113 then 'SMART_ACTION_START_CLOSEST_WAYPOINT' when 114 then 'SMART_ACTION_MOVE_OFFSET' when 115 then 'SMART_ACTION_RANDOM_SOUND' when 116 then 'SMART_ACTION_SET_CORPSE_DELAY' when 117 then 'SMART_ACTION_DISABLE_EVADE' when 118 then 'SMART_ACTION_GO_SET_GO_STATE' when 119 then 'SMART_ACTION_SET_CAN_FLY' when 120 then 'SMART_ACTION_REMOVE_AURAS_BY_TYPE' when 121 then 'SMART_ACTION_SET_SIGHT_DIST' when 122 then 'SMART_ACTION_FLEE' when 123 then 'SMART_ACTION_ADD_THREAT' when 124 then 'SMART_ACTION_LOAD_EQUIPMENT' when 125 then 'SMART_ACTION_TRIGGER_RANDOM_TIMED_EVENT' when 126 then 'SMART_ACTION_REMOVE_ALL_GAMEOBJECTS' when 127 then 'SMART_ACTION_PAUSE_MOVEMENT' when 128 then 'SMART_ACTION_PLAY_ANIMKIT' when 129 then 'SMART_ACTION_SCENE_PLAY' when 130 then 'SMART_ACTION_SCENE_CANCEL' when 131 then 'SMART_ACTION_SPAWN_SPAWNGROUP' when 132 then 'SMART_ACTION_DESPAWN_SPAWNGROUP' when 133 then 'SMART_ACTION_RESPAWN_BY_SPAWNID' when 134 then 'SMART_ACTION_INVOKER_CAST' when 135 then 'SMART_ACTION_PLAY_CINEMATIC' when 136 then 'SMART_ACTION_SET_MOVEMENT_SPEED' when 137 then 'SMART_ACTION_PLAY_SPELL_VISUAL_KIT' when 138 then 'SMART_ACTION_OVERRIDE_LIGHT' when 139 then 'SMART_ACTION_OVERRIDE_WEATHER' when 143 then 'SMART_ACTION_CREATE_CONVERSATION' when 144 then 'SMART_ACTION_SET_IMMUNE_PC' when 145 then 'SMART_ACTION_SET_IMMUNE_NPC' when 146 then 'SMART_ACTION_SET_UNINTERACTIBLE' when 147 then 'SMART_ACTION_ACTIVATE_GAMEOBJECT' when 148 then 'SMART_ACTION_ADD_TO_STORED_TARGET_LIST' when 149 then 'SMART_ACTION_BECOME_PERSONAL_CLONE_FOR_PLAYER' else `smart_scripts`.`action_type` end) AS `action_type`,`smart_scripts`.`action_param1` AS `action_param1`,`smart_scripts`.`action_param2` AS `action_param2`,`smart_scripts`.`action_param3` AS `action_param3`,`smart_scripts`.`action_param4` AS `action_param4`,`smart_scripts`.`action_param5` AS `action_param5`,`smart_scripts`.`action_param6` AS `action_param6`,(case `smart_scripts`.`target_type` when 0 then 'SMART_TARGET_NONE' when 1 then 'SMART_TARGET_SELF' when 2 then 'SMART_TARGET_VICTIM' when 3 then 'SMART_TARGET_HOSTILE_SECOND_AGGRO' when 4 then 'SMART_TARGET_HOSTILE_LAST_AGGRO' when 5 then 'SMART_TARGET_HOSTILE_RANDOM' when 6 then 'SMART_TARGET_HOSTILE_RANDOM_NOT_TOP' when 7 then 'SMART_TARGET_ACTION_INVOKER' when 8 then 'SMART_TARGET_POSITION' when 9 then 'SMART_TARGET_CREATURE_RANGE' when 10 then 'SMART_TARGET_CREATURE_GUID' when 11 then 'SMART_TARGET_CREATURE_DISTANCE' when 12 then 'SMART_TARGET_STORED' when 13 then 'SMART_TARGET_GAMEOBJECT_RANGE' when 14 then 'SMART_TARGET_GAMEOBJECT_GUID' when 15 then 'SMART_TARGET_GAMEOBJECT_DISTANCE' when 16 then 'SMART_TARGET_INVOKER_PARTY' when 17 then 'SMART_TARGET_PLAYER_RANGE' when 18 then 'SMART_TARGET_PLAYER_DISTANCE' when 19 then 'SMART_TARGET_CLOSEST_CREATURE' when 20 then 'SMART_TARGET_CLOSEST_GAMEOBJECT' when 21 then 'SMART_TARGET_CLOSEST_PLAYER' when 22 then 'SMART_TARGET_ACTION_INVOKER_VEHICLE' when 23 then 'SMART_TARGET_OWNER_OR_SUMMONER' when 24 then 'SMART_TARGET_THREAT_LIST' when 25 then 'SMART_TARGET_CLOSEST_ENEMY' when 26 then 'SMART_TARGET_CLOSEST_FRIENDLY' when 27 then 'SMART_TARGET_LOOT_RECIPIENTS' when 28 then 'SMART_TARGET_FARTHEST' when 29 then 'SMART_TARGET_VEHICLE_PASSENGER' when 30 then 'SMART_TARGET_CLOSEST_UNSPAWNED_GAMEOBJECT' else `smart_scripts`.`target_type` end) AS `target_type`,`smart_scripts`.`target_param1` AS `target_param1`,`smart_scripts`.`target_param2` AS `target_param2`,`smart_scripts`.`target_param3` AS `target_param3`,`smart_scripts`.`target_param4` AS `target_param4`,`smart_scripts`.`target_x` AS `target_x`,`smart_scripts`.`target_y` AS `target_y`,`smart_scripts`.`target_z` AS `target_z`,`smart_scripts`.`target_o` AS `target_o`,`smart_scripts`.`comment` AS `comment` from `smart_scripts` */;
/*!50001 SET character_set_client = @saved_cs_client */;
/*!50001 SET character_set_results = @saved_cs_results */;
@@ -4983,4 +4983,4 @@ CREATE TABLE `world_state` (
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
--- Dump completed on 2024-09-23 22:48:14
+-- Dump completed on 2024-11-16 21:57:43
diff --git a/sql/updates/auth/master/2024_09_23_00_auth.sql b/sql/old/11.x/auth/24092_2024_11_16/2024_09_23_00_auth.sql
index c4d4e867cdd..c4d4e867cdd 100644
--- a/sql/updates/auth/master/2024_09_23_00_auth.sql
+++ b/sql/old/11.x/auth/24092_2024_11_16/2024_09_23_00_auth.sql
diff --git a/sql/updates/auth/master/2024_09_26_00_auth.sql b/sql/old/11.x/auth/24092_2024_11_16/2024_09_26_00_auth.sql
index a5c75e51c38..a5c75e51c38 100644
--- a/sql/updates/auth/master/2024_09_26_00_auth.sql
+++ b/sql/old/11.x/auth/24092_2024_11_16/2024_09_26_00_auth.sql
diff --git a/sql/updates/auth/master/2024_10_01_00_auth.sql b/sql/old/11.x/auth/24092_2024_11_16/2024_10_01_00_auth.sql
index 5853468e2c7..5853468e2c7 100644
--- a/sql/updates/auth/master/2024_10_01_00_auth.sql
+++ b/sql/old/11.x/auth/24092_2024_11_16/2024_10_01_00_auth.sql
diff --git a/sql/updates/auth/master/2024_10_23_00_auth.sql b/sql/old/11.x/auth/24092_2024_11_16/2024_10_23_00_auth.sql
index c7b7fde410c..c7b7fde410c 100644
--- a/sql/updates/auth/master/2024_10_23_00_auth.sql
+++ b/sql/old/11.x/auth/24092_2024_11_16/2024_10_23_00_auth.sql
diff --git a/sql/updates/auth/master/2024_10_23_01_auth.sql b/sql/old/11.x/auth/24092_2024_11_16/2024_10_23_01_auth.sql
index ac2f4583146..ac2f4583146 100644
--- a/sql/updates/auth/master/2024_10_23_01_auth.sql
+++ b/sql/old/11.x/auth/24092_2024_11_16/2024_10_23_01_auth.sql
diff --git a/sql/updates/auth/master/2024_10_30_00_auth.sql b/sql/old/11.x/auth/24092_2024_11_16/2024_10_30_00_auth.sql
index 41431443a1b..41431443a1b 100644
--- a/sql/updates/auth/master/2024_10_30_00_auth.sql
+++ b/sql/old/11.x/auth/24092_2024_11_16/2024_10_30_00_auth.sql
diff --git a/sql/updates/auth/master/2024_11_01_00_auth.sql b/sql/old/11.x/auth/24092_2024_11_16/2024_11_01_00_auth.sql
index 8785a0705d3..8785a0705d3 100644
--- a/sql/updates/auth/master/2024_11_01_00_auth.sql
+++ b/sql/old/11.x/auth/24092_2024_11_16/2024_11_01_00_auth.sql
diff --git a/sql/updates/auth/master/2024_11_11_00_auth.sql b/sql/old/11.x/auth/24092_2024_11_16/2024_11_11_00_auth.sql
index 58b45dc37cd..58b45dc37cd 100644
--- a/sql/updates/auth/master/2024_11_11_00_auth.sql
+++ b/sql/old/11.x/auth/24092_2024_11_16/2024_11_11_00_auth.sql
diff --git a/sql/updates/auth/master/2024_11_12_00_auth.sql b/sql/old/11.x/auth/24092_2024_11_16/2024_11_12_00_auth.sql
index 3eb0af6c898..3eb0af6c898 100644
--- a/sql/updates/auth/master/2024_11_12_00_auth.sql
+++ b/sql/old/11.x/auth/24092_2024_11_16/2024_11_12_00_auth.sql
diff --git a/sql/updates/auth/master/2024_11_14_00_auth.sql b/sql/old/11.x/auth/24092_2024_11_16/2024_11_14_00_auth.sql
index a32fafed936..a32fafed936 100644
--- a/sql/updates/auth/master/2024_11_14_00_auth.sql
+++ b/sql/old/11.x/auth/24092_2024_11_16/2024_11_14_00_auth.sql
diff --git a/sql/updates/characters/master/2024_09_23_00_characters.sql b/sql/old/11.x/characters/24092_2024_11_16/2024_09_23_00_characters.sql
index b385b929e1b..b385b929e1b 100644
--- a/sql/updates/characters/master/2024_09_23_00_characters.sql
+++ b/sql/old/11.x/characters/24092_2024_11_16/2024_09_23_00_characters.sql
diff --git a/sql/updates/characters/master/2024_10_03_00_characters.sql b/sql/old/11.x/characters/24092_2024_11_16/2024_10_03_00_characters.sql
index 7b5a6fcf357..7b5a6fcf357 100644
--- a/sql/updates/characters/master/2024_10_03_00_characters.sql
+++ b/sql/old/11.x/characters/24092_2024_11_16/2024_10_03_00_characters.sql
diff --git a/sql/updates/characters/master/2024_11_04_00_characters.sql b/sql/old/11.x/characters/24092_2024_11_16/2024_11_04_00_characters.sql
index b056282ea77..b056282ea77 100644
--- a/sql/updates/characters/master/2024_11_04_00_characters.sql
+++ b/sql/old/11.x/characters/24092_2024_11_16/2024_11_04_00_characters.sql
diff --git a/sql/updates/hotfixes/master/2024_09_23_11_hotfixes.sql b/sql/old/11.x/hotfixes/24092_2024_11_16/2024_09_23_11_hotfixes.sql
index 7edd4006d4d..7edd4006d4d 100644
--- a/sql/updates/hotfixes/master/2024_09_23_11_hotfixes.sql
+++ b/sql/old/11.x/hotfixes/24092_2024_11_16/2024_09_23_11_hotfixes.sql
diff --git a/sql/updates/hotfixes/master/2024_09_27_00_hotfixes.sql b/sql/old/11.x/hotfixes/24092_2024_11_16/2024_09_27_00_hotfixes.sql
index c879f9c7b0a..c879f9c7b0a 100644
--- a/sql/updates/hotfixes/master/2024_09_27_00_hotfixes.sql
+++ b/sql/old/11.x/hotfixes/24092_2024_11_16/2024_09_27_00_hotfixes.sql
diff --git a/sql/updates/hotfixes/master/2024_10_06_00_hotfixes.sql b/sql/old/11.x/hotfixes/24092_2024_11_16/2024_10_06_00_hotfixes.sql
index 9e841bf32ad..9e841bf32ad 100644
--- a/sql/updates/hotfixes/master/2024_10_06_00_hotfixes.sql
+++ b/sql/old/11.x/hotfixes/24092_2024_11_16/2024_10_06_00_hotfixes.sql
diff --git a/sql/updates/hotfixes/master/2024_10_07_00_hotfixes.sql b/sql/old/11.x/hotfixes/24092_2024_11_16/2024_10_07_00_hotfixes.sql
index 174d3d09e4c..174d3d09e4c 100644
--- a/sql/updates/hotfixes/master/2024_10_07_00_hotfixes.sql
+++ b/sql/old/11.x/hotfixes/24092_2024_11_16/2024_10_07_00_hotfixes.sql
diff --git a/sql/updates/hotfixes/master/2024_10_09_00_hotfixes.sql b/sql/old/11.x/hotfixes/24092_2024_11_16/2024_10_09_00_hotfixes.sql
index f6cd6cfb83c..f6cd6cfb83c 100644
--- a/sql/updates/hotfixes/master/2024_10_09_00_hotfixes.sql
+++ b/sql/old/11.x/hotfixes/24092_2024_11_16/2024_10_09_00_hotfixes.sql
diff --git a/sql/updates/hotfixes/master/2024_10_23_00_hotfixes.sql b/sql/old/11.x/hotfixes/24092_2024_11_16/2024_10_23_00_hotfixes.sql
index 30d26be018b..30d26be018b 100644
--- a/sql/updates/hotfixes/master/2024_10_23_00_hotfixes.sql
+++ b/sql/old/11.x/hotfixes/24092_2024_11_16/2024_10_23_00_hotfixes.sql
diff --git a/sql/updates/hotfixes/master/2024_11_16_00_hotfixes_enUS.sql b/sql/old/11.x/hotfixes/24092_2024_11_16/2024_11_16_00_hotfixes_enUS.sql
index 69483755a73..69483755a73 100644
--- a/sql/updates/hotfixes/master/2024_11_16_00_hotfixes_enUS.sql
+++ b/sql/old/11.x/hotfixes/24092_2024_11_16/2024_11_16_00_hotfixes_enUS.sql
diff --git a/sql/updates/hotfixes/master/2024_11_16_01_hotfixes_deDE.sql b/sql/old/11.x/hotfixes/24092_2024_11_16/2024_11_16_01_hotfixes_deDE.sql
index 837b73482c9..837b73482c9 100644
--- a/sql/updates/hotfixes/master/2024_11_16_01_hotfixes_deDE.sql
+++ b/sql/old/11.x/hotfixes/24092_2024_11_16/2024_11_16_01_hotfixes_deDE.sql
diff --git a/sql/updates/hotfixes/master/2024_11_16_02_hotfixes_esES.sql b/sql/old/11.x/hotfixes/24092_2024_11_16/2024_11_16_02_hotfixes_esES.sql
index a0cce26e06a..a0cce26e06a 100644
--- a/sql/updates/hotfixes/master/2024_11_16_02_hotfixes_esES.sql
+++ b/sql/old/11.x/hotfixes/24092_2024_11_16/2024_11_16_02_hotfixes_esES.sql
diff --git a/sql/updates/hotfixes/master/2024_11_16_03_hotfixes_esMX.sql b/sql/old/11.x/hotfixes/24092_2024_11_16/2024_11_16_03_hotfixes_esMX.sql
index d7694869123..d7694869123 100644
--- a/sql/updates/hotfixes/master/2024_11_16_03_hotfixes_esMX.sql
+++ b/sql/old/11.x/hotfixes/24092_2024_11_16/2024_11_16_03_hotfixes_esMX.sql
diff --git a/sql/updates/hotfixes/master/2024_11_16_04_hotfixes_frFR.sql b/sql/old/11.x/hotfixes/24092_2024_11_16/2024_11_16_04_hotfixes_frFR.sql
index 38e42715993..38e42715993 100644
--- a/sql/updates/hotfixes/master/2024_11_16_04_hotfixes_frFR.sql
+++ b/sql/old/11.x/hotfixes/24092_2024_11_16/2024_11_16_04_hotfixes_frFR.sql
diff --git a/sql/updates/hotfixes/master/2024_11_16_05_hotfixes_itIT.sql b/sql/old/11.x/hotfixes/24092_2024_11_16/2024_11_16_05_hotfixes_itIT.sql
index 8b4dca78a66..8b4dca78a66 100644
--- a/sql/updates/hotfixes/master/2024_11_16_05_hotfixes_itIT.sql
+++ b/sql/old/11.x/hotfixes/24092_2024_11_16/2024_11_16_05_hotfixes_itIT.sql
diff --git a/sql/updates/hotfixes/master/2024_11_16_06_hotfixes_koKR.sql b/sql/old/11.x/hotfixes/24092_2024_11_16/2024_11_16_06_hotfixes_koKR.sql
index f1053878e35..f1053878e35 100644
--- a/sql/updates/hotfixes/master/2024_11_16_06_hotfixes_koKR.sql
+++ b/sql/old/11.x/hotfixes/24092_2024_11_16/2024_11_16_06_hotfixes_koKR.sql
diff --git a/sql/updates/hotfixes/master/2024_11_16_07_hotfixes_ptBR.sql b/sql/old/11.x/hotfixes/24092_2024_11_16/2024_11_16_07_hotfixes_ptBR.sql
index 805bd101285..805bd101285 100644
--- a/sql/updates/hotfixes/master/2024_11_16_07_hotfixes_ptBR.sql
+++ b/sql/old/11.x/hotfixes/24092_2024_11_16/2024_11_16_07_hotfixes_ptBR.sql
diff --git a/sql/updates/hotfixes/master/2024_11_16_08_hotfixes_ruRU.sql b/sql/old/11.x/hotfixes/24092_2024_11_16/2024_11_16_08_hotfixes_ruRU.sql
index f31bb837e29..f31bb837e29 100644
--- a/sql/updates/hotfixes/master/2024_11_16_08_hotfixes_ruRU.sql
+++ b/sql/old/11.x/hotfixes/24092_2024_11_16/2024_11_16_08_hotfixes_ruRU.sql
diff --git a/sql/updates/hotfixes/master/2024_11_16_09_hotfixes_zhCN.sql b/sql/old/11.x/hotfixes/24092_2024_11_16/2024_11_16_09_hotfixes_zhCN.sql
index 848f157434e..848f157434e 100644
--- a/sql/updates/hotfixes/master/2024_11_16_09_hotfixes_zhCN.sql
+++ b/sql/old/11.x/hotfixes/24092_2024_11_16/2024_11_16_09_hotfixes_zhCN.sql
diff --git a/sql/updates/hotfixes/master/2024_11_16_10_hotfixes_zhTW.sql b/sql/old/11.x/hotfixes/24092_2024_11_16/2024_11_16_10_hotfixes_zhTW.sql
index 75a2eadd426..75a2eadd426 100644
--- a/sql/updates/hotfixes/master/2024_11_16_10_hotfixes_zhTW.sql
+++ b/sql/old/11.x/hotfixes/24092_2024_11_16/2024_11_16_10_hotfixes_zhTW.sql
diff --git a/sql/updates/hotfixes/master/2024_11_16_11_hotfixes_enUS.sql b/sql/old/11.x/hotfixes/24092_2024_11_16/2024_11_16_11_hotfixes_enUS.sql
index 990661ec0c8..990661ec0c8 100644
--- a/sql/updates/hotfixes/master/2024_11_16_11_hotfixes_enUS.sql
+++ b/sql/old/11.x/hotfixes/24092_2024_11_16/2024_11_16_11_hotfixes_enUS.sql
diff --git a/sql/updates/hotfixes/master/2024_11_16_12_hotfixes_deDE.sql b/sql/old/11.x/hotfixes/24092_2024_11_16/2024_11_16_12_hotfixes_deDE.sql
index 6eca2e661c3..6eca2e661c3 100644
--- a/sql/updates/hotfixes/master/2024_11_16_12_hotfixes_deDE.sql
+++ b/sql/old/11.x/hotfixes/24092_2024_11_16/2024_11_16_12_hotfixes_deDE.sql
diff --git a/sql/updates/hotfixes/master/2024_11_16_13_hotfixes_esES.sql b/sql/old/11.x/hotfixes/24092_2024_11_16/2024_11_16_13_hotfixes_esES.sql
index ee815a37ef6..ee815a37ef6 100644
--- a/sql/updates/hotfixes/master/2024_11_16_13_hotfixes_esES.sql
+++ b/sql/old/11.x/hotfixes/24092_2024_11_16/2024_11_16_13_hotfixes_esES.sql
diff --git a/sql/updates/hotfixes/master/2024_11_16_14_hotfixes_esMX.sql b/sql/old/11.x/hotfixes/24092_2024_11_16/2024_11_16_14_hotfixes_esMX.sql
index 232e3cc3f1a..232e3cc3f1a 100644
--- a/sql/updates/hotfixes/master/2024_11_16_14_hotfixes_esMX.sql
+++ b/sql/old/11.x/hotfixes/24092_2024_11_16/2024_11_16_14_hotfixes_esMX.sql
diff --git a/sql/updates/hotfixes/master/2024_11_16_15_hotfixes_frFR.sql b/sql/old/11.x/hotfixes/24092_2024_11_16/2024_11_16_15_hotfixes_frFR.sql
index da255e7c274..da255e7c274 100644
--- a/sql/updates/hotfixes/master/2024_11_16_15_hotfixes_frFR.sql
+++ b/sql/old/11.x/hotfixes/24092_2024_11_16/2024_11_16_15_hotfixes_frFR.sql
diff --git a/sql/updates/hotfixes/master/2024_11_16_16_hotfixes_itIT.sql b/sql/old/11.x/hotfixes/24092_2024_11_16/2024_11_16_16_hotfixes_itIT.sql
index 408773acfc5..408773acfc5 100644
--- a/sql/updates/hotfixes/master/2024_11_16_16_hotfixes_itIT.sql
+++ b/sql/old/11.x/hotfixes/24092_2024_11_16/2024_11_16_16_hotfixes_itIT.sql
diff --git a/sql/updates/hotfixes/master/2024_11_16_17_hotfixes_koKR.sql b/sql/old/11.x/hotfixes/24092_2024_11_16/2024_11_16_17_hotfixes_koKR.sql
index a94406cc106..a94406cc106 100644
--- a/sql/updates/hotfixes/master/2024_11_16_17_hotfixes_koKR.sql
+++ b/sql/old/11.x/hotfixes/24092_2024_11_16/2024_11_16_17_hotfixes_koKR.sql
diff --git a/sql/updates/hotfixes/master/2024_11_16_18_hotfixes_ptBR.sql b/sql/old/11.x/hotfixes/24092_2024_11_16/2024_11_16_18_hotfixes_ptBR.sql
index 44e71cca4e3..44e71cca4e3 100644
--- a/sql/updates/hotfixes/master/2024_11_16_18_hotfixes_ptBR.sql
+++ b/sql/old/11.x/hotfixes/24092_2024_11_16/2024_11_16_18_hotfixes_ptBR.sql
diff --git a/sql/updates/hotfixes/master/2024_11_16_19_hotfixes_ruRU.sql b/sql/old/11.x/hotfixes/24092_2024_11_16/2024_11_16_19_hotfixes_ruRU.sql
index df1baa04fb2..df1baa04fb2 100644
--- a/sql/updates/hotfixes/master/2024_11_16_19_hotfixes_ruRU.sql
+++ b/sql/old/11.x/hotfixes/24092_2024_11_16/2024_11_16_19_hotfixes_ruRU.sql
diff --git a/sql/updates/hotfixes/master/2024_11_16_20_hotfixes_zhCN.sql b/sql/old/11.x/hotfixes/24092_2024_11_16/2024_11_16_20_hotfixes_zhCN.sql
index f6bd0da0ba2..f6bd0da0ba2 100644
--- a/sql/updates/hotfixes/master/2024_11_16_20_hotfixes_zhCN.sql
+++ b/sql/old/11.x/hotfixes/24092_2024_11_16/2024_11_16_20_hotfixes_zhCN.sql
diff --git a/sql/updates/hotfixes/master/2024_11_16_21_hotfixes_zhTW.sql b/sql/old/11.x/hotfixes/24092_2024_11_16/2024_11_16_21_hotfixes_zhTW.sql
index 7f5ea102441..7f5ea102441 100644
--- a/sql/updates/hotfixes/master/2024_11_16_21_hotfixes_zhTW.sql
+++ b/sql/old/11.x/hotfixes/24092_2024_11_16/2024_11_16_21_hotfixes_zhTW.sql
diff --git a/sql/updates/hotfixes/master/2024_11_16_22_hotfixes.sql b/sql/old/11.x/hotfixes/24092_2024_11_16/2024_11_16_22_hotfixes.sql
index 7ec93d565d8..7ec93d565d8 100644
--- a/sql/updates/hotfixes/master/2024_11_16_22_hotfixes.sql
+++ b/sql/old/11.x/hotfixes/24092_2024_11_16/2024_11_16_22_hotfixes.sql
diff --git a/sql/updates/world/master/2024_09_23_00_world.sql b/sql/old/11.x/world/24092_2024_11_16/2024_09_23_00_world.sql
index ce874f7f33d..ce874f7f33d 100644
--- a/sql/updates/world/master/2024_09_23_00_world.sql
+++ b/sql/old/11.x/world/24092_2024_11_16/2024_09_23_00_world.sql
diff --git a/sql/updates/world/master/2024_09_25_00_world.sql b/sql/old/11.x/world/24092_2024_11_16/2024_09_25_00_world.sql
index da7d19decac..da7d19decac 100644
--- a/sql/updates/world/master/2024_09_25_00_world.sql
+++ b/sql/old/11.x/world/24092_2024_11_16/2024_09_25_00_world.sql
diff --git a/sql/updates/world/master/2024_09_28_00_world.sql b/sql/old/11.x/world/24092_2024_11_16/2024_09_28_00_world.sql
index c35abeee616..c35abeee616 100644
--- a/sql/updates/world/master/2024_09_28_00_world.sql
+++ b/sql/old/11.x/world/24092_2024_11_16/2024_09_28_00_world.sql
diff --git a/sql/updates/world/master/2024_09_29_00_world.sql b/sql/old/11.x/world/24092_2024_11_16/2024_09_29_00_world.sql
index e4bc8f0ff26..e4bc8f0ff26 100644
--- a/sql/updates/world/master/2024_09_29_00_world.sql
+++ b/sql/old/11.x/world/24092_2024_11_16/2024_09_29_00_world.sql
diff --git a/sql/updates/world/master/2024_09_29_01_world.sql b/sql/old/11.x/world/24092_2024_11_16/2024_09_29_01_world.sql
index ea2bf4bd21e..ea2bf4bd21e 100644
--- a/sql/updates/world/master/2024_09_29_01_world.sql
+++ b/sql/old/11.x/world/24092_2024_11_16/2024_09_29_01_world.sql
diff --git a/sql/updates/world/master/2024_09_30_00_world.sql b/sql/old/11.x/world/24092_2024_11_16/2024_09_30_00_world.sql
index c412c452734..c412c452734 100644
--- a/sql/updates/world/master/2024_09_30_00_world.sql
+++ b/sql/old/11.x/world/24092_2024_11_16/2024_09_30_00_world.sql
diff --git a/sql/updates/world/master/2024_09_30_01_world.sql b/sql/old/11.x/world/24092_2024_11_16/2024_09_30_01_world.sql
index c26eb876898..c26eb876898 100644
--- a/sql/updates/world/master/2024_09_30_01_world.sql
+++ b/sql/old/11.x/world/24092_2024_11_16/2024_09_30_01_world.sql
diff --git a/sql/updates/world/master/2024_10_02_00_world.sql b/sql/old/11.x/world/24092_2024_11_16/2024_10_02_00_world.sql
index 0dbb55df60a..0dbb55df60a 100644
--- a/sql/updates/world/master/2024_10_02_00_world.sql
+++ b/sql/old/11.x/world/24092_2024_11_16/2024_10_02_00_world.sql
diff --git a/sql/updates/world/master/2024_10_04_00_world.sql b/sql/old/11.x/world/24092_2024_11_16/2024_10_04_00_world.sql
index bc567cf1fa4..bc567cf1fa4 100644
--- a/sql/updates/world/master/2024_10_04_00_world.sql
+++ b/sql/old/11.x/world/24092_2024_11_16/2024_10_04_00_world.sql
diff --git a/sql/updates/world/master/2024_10_04_01_world.sql b/sql/old/11.x/world/24092_2024_11_16/2024_10_04_01_world.sql
index 15bec4ec9d0..15bec4ec9d0 100644
--- a/sql/updates/world/master/2024_10_04_01_world.sql
+++ b/sql/old/11.x/world/24092_2024_11_16/2024_10_04_01_world.sql
diff --git a/sql/updates/world/master/2024_10_06_00_world.sql b/sql/old/11.x/world/24092_2024_11_16/2024_10_06_00_world.sql
index ac37408a36b..ac37408a36b 100644
--- a/sql/updates/world/master/2024_10_06_00_world.sql
+++ b/sql/old/11.x/world/24092_2024_11_16/2024_10_06_00_world.sql
diff --git a/sql/updates/world/master/2024_10_07_00_world.sql b/sql/old/11.x/world/24092_2024_11_16/2024_10_07_00_world.sql
index 7fa2d440a95..7fa2d440a95 100644
--- a/sql/updates/world/master/2024_10_07_00_world.sql
+++ b/sql/old/11.x/world/24092_2024_11_16/2024_10_07_00_world.sql
diff --git a/sql/updates/world/master/2024_10_07_01_world.sql b/sql/old/11.x/world/24092_2024_11_16/2024_10_07_01_world.sql
index ede09cea921..ede09cea921 100644
--- a/sql/updates/world/master/2024_10_07_01_world.sql
+++ b/sql/old/11.x/world/24092_2024_11_16/2024_10_07_01_world.sql
diff --git a/sql/updates/world/master/2024_10_09_00_world.sql b/sql/old/11.x/world/24092_2024_11_16/2024_10_09_00_world.sql
index ab1ec8e13cc..ab1ec8e13cc 100644
--- a/sql/updates/world/master/2024_10_09_00_world.sql
+++ b/sql/old/11.x/world/24092_2024_11_16/2024_10_09_00_world.sql
diff --git a/sql/updates/world/master/2024_10_12_00_world.sql b/sql/old/11.x/world/24092_2024_11_16/2024_10_12_00_world.sql
index 330919a3ab2..330919a3ab2 100644
--- a/sql/updates/world/master/2024_10_12_00_world.sql
+++ b/sql/old/11.x/world/24092_2024_11_16/2024_10_12_00_world.sql
diff --git a/sql/updates/world/master/2024_10_12_01_world.sql b/sql/old/11.x/world/24092_2024_11_16/2024_10_12_01_world.sql
index 3361b19a391..3361b19a391 100644
--- a/sql/updates/world/master/2024_10_12_01_world.sql
+++ b/sql/old/11.x/world/24092_2024_11_16/2024_10_12_01_world.sql
diff --git a/sql/updates/world/master/2024_10_12_02_world.sql b/sql/old/11.x/world/24092_2024_11_16/2024_10_12_02_world.sql
index 2cc8a5bd53d..2cc8a5bd53d 100644
--- a/sql/updates/world/master/2024_10_12_02_world.sql
+++ b/sql/old/11.x/world/24092_2024_11_16/2024_10_12_02_world.sql
diff --git a/sql/updates/world/master/2024_10_12_03_world.sql b/sql/old/11.x/world/24092_2024_11_16/2024_10_12_03_world.sql
index ef44153ba66..ef44153ba66 100644
--- a/sql/updates/world/master/2024_10_12_03_world.sql
+++ b/sql/old/11.x/world/24092_2024_11_16/2024_10_12_03_world.sql
diff --git a/sql/updates/world/master/2024_10_15_00_world.sql b/sql/old/11.x/world/24092_2024_11_16/2024_10_15_00_world.sql
index 6ee47359541..6ee47359541 100644
--- a/sql/updates/world/master/2024_10_15_00_world.sql
+++ b/sql/old/11.x/world/24092_2024_11_16/2024_10_15_00_world.sql
diff --git a/sql/updates/world/master/2024_10_15_01_world.sql b/sql/old/11.x/world/24092_2024_11_16/2024_10_15_01_world.sql
index c1f7618d830..c1f7618d830 100644
--- a/sql/updates/world/master/2024_10_15_01_world.sql
+++ b/sql/old/11.x/world/24092_2024_11_16/2024_10_15_01_world.sql
diff --git a/sql/updates/world/master/2024_10_16_00_world.sql b/sql/old/11.x/world/24092_2024_11_16/2024_10_16_00_world.sql
index e0cf2684294..e0cf2684294 100644
--- a/sql/updates/world/master/2024_10_16_00_world.sql
+++ b/sql/old/11.x/world/24092_2024_11_16/2024_10_16_00_world.sql
diff --git a/sql/updates/world/master/2024_10_17_00_world.sql b/sql/old/11.x/world/24092_2024_11_16/2024_10_17_00_world.sql
index a6160e2ff54..a6160e2ff54 100644
--- a/sql/updates/world/master/2024_10_17_00_world.sql
+++ b/sql/old/11.x/world/24092_2024_11_16/2024_10_17_00_world.sql
diff --git a/sql/updates/world/master/2024_10_18_00_world.sql b/sql/old/11.x/world/24092_2024_11_16/2024_10_18_00_world.sql
index 55b22fb9acc..55b22fb9acc 100644
--- a/sql/updates/world/master/2024_10_18_00_world.sql
+++ b/sql/old/11.x/world/24092_2024_11_16/2024_10_18_00_world.sql
diff --git a/sql/updates/world/master/2024_10_18_01_world.sql b/sql/old/11.x/world/24092_2024_11_16/2024_10_18_01_world.sql
index f9656c16dfa..f9656c16dfa 100644
--- a/sql/updates/world/master/2024_10_18_01_world.sql
+++ b/sql/old/11.x/world/24092_2024_11_16/2024_10_18_01_world.sql
diff --git a/sql/updates/world/master/2024_10_20_00_world.sql b/sql/old/11.x/world/24092_2024_11_16/2024_10_20_00_world.sql
index bedd21a143c..bedd21a143c 100644
--- a/sql/updates/world/master/2024_10_20_00_world.sql
+++ b/sql/old/11.x/world/24092_2024_11_16/2024_10_20_00_world.sql
diff --git a/sql/updates/world/master/2024_10_20_01_world.sql b/sql/old/11.x/world/24092_2024_11_16/2024_10_20_01_world.sql
index b44e18e615d..b44e18e615d 100644
--- a/sql/updates/world/master/2024_10_20_01_world.sql
+++ b/sql/old/11.x/world/24092_2024_11_16/2024_10_20_01_world.sql
diff --git a/sql/updates/world/master/2024_10_20_02_world.sql b/sql/old/11.x/world/24092_2024_11_16/2024_10_20_02_world.sql
index 40ac972ef25..40ac972ef25 100644
--- a/sql/updates/world/master/2024_10_20_02_world.sql
+++ b/sql/old/11.x/world/24092_2024_11_16/2024_10_20_02_world.sql
diff --git a/sql/updates/world/master/2024_10_20_03_world.sql b/sql/old/11.x/world/24092_2024_11_16/2024_10_20_03_world.sql
index fe6f1714502..fe6f1714502 100644
--- a/sql/updates/world/master/2024_10_20_03_world.sql
+++ b/sql/old/11.x/world/24092_2024_11_16/2024_10_20_03_world.sql
diff --git a/sql/updates/world/master/2024_10_22_00_world.sql b/sql/old/11.x/world/24092_2024_11_16/2024_10_22_00_world.sql
index d43e7775605..d43e7775605 100644
--- a/sql/updates/world/master/2024_10_22_00_world.sql
+++ b/sql/old/11.x/world/24092_2024_11_16/2024_10_22_00_world.sql
diff --git a/sql/updates/world/master/2024_10_22_01_world.sql b/sql/old/11.x/world/24092_2024_11_16/2024_10_22_01_world.sql
index 1f6287412c1..1f6287412c1 100644
--- a/sql/updates/world/master/2024_10_22_01_world.sql
+++ b/sql/old/11.x/world/24092_2024_11_16/2024_10_22_01_world.sql
diff --git a/sql/updates/world/master/2024_10_22_02_world.sql b/sql/old/11.x/world/24092_2024_11_16/2024_10_22_02_world.sql
index 56efa49ab55..56efa49ab55 100644
--- a/sql/updates/world/master/2024_10_22_02_world.sql
+++ b/sql/old/11.x/world/24092_2024_11_16/2024_10_22_02_world.sql
diff --git a/sql/updates/world/master/2024_10_22_03_world.sql b/sql/old/11.x/world/24092_2024_11_16/2024_10_22_03_world.sql
index 697d82f7bd7..697d82f7bd7 100644
--- a/sql/updates/world/master/2024_10_22_03_world.sql
+++ b/sql/old/11.x/world/24092_2024_11_16/2024_10_22_03_world.sql
diff --git a/sql/updates/world/master/2024_10_22_04_world.sql b/sql/old/11.x/world/24092_2024_11_16/2024_10_22_04_world.sql
index 0a3c55da309..0a3c55da309 100644
--- a/sql/updates/world/master/2024_10_22_04_world.sql
+++ b/sql/old/11.x/world/24092_2024_11_16/2024_10_22_04_world.sql
diff --git a/sql/updates/world/master/2024_10_22_05_world.sql b/sql/old/11.x/world/24092_2024_11_16/2024_10_22_05_world.sql
index c89040aecc3..c89040aecc3 100644
--- a/sql/updates/world/master/2024_10_22_05_world.sql
+++ b/sql/old/11.x/world/24092_2024_11_16/2024_10_22_05_world.sql
diff --git a/sql/updates/world/master/2024_10_24_00_world.sql b/sql/old/11.x/world/24092_2024_11_16/2024_10_24_00_world.sql
index 83391206bde..83391206bde 100644
--- a/sql/updates/world/master/2024_10_24_00_world.sql
+++ b/sql/old/11.x/world/24092_2024_11_16/2024_10_24_00_world.sql
diff --git a/sql/updates/world/master/2024_10_24_01_world.sql b/sql/old/11.x/world/24092_2024_11_16/2024_10_24_01_world.sql
index d777dcaa09b..d777dcaa09b 100644
--- a/sql/updates/world/master/2024_10_24_01_world.sql
+++ b/sql/old/11.x/world/24092_2024_11_16/2024_10_24_01_world.sql
diff --git a/sql/updates/world/master/2024_10_24_02_world.sql b/sql/old/11.x/world/24092_2024_11_16/2024_10_24_02_world.sql
index fc8c7c447cd..fc8c7c447cd 100644
--- a/sql/updates/world/master/2024_10_24_02_world.sql
+++ b/sql/old/11.x/world/24092_2024_11_16/2024_10_24_02_world.sql
diff --git a/sql/updates/world/master/2024_10_24_03_world.sql b/sql/old/11.x/world/24092_2024_11_16/2024_10_24_03_world.sql
index b7ee57d479c..b7ee57d479c 100644
--- a/sql/updates/world/master/2024_10_24_03_world.sql
+++ b/sql/old/11.x/world/24092_2024_11_16/2024_10_24_03_world.sql
diff --git a/sql/updates/world/master/2024_10_27_00_world.sql b/sql/old/11.x/world/24092_2024_11_16/2024_10_27_00_world.sql
index f9f939c5437..f9f939c5437 100644
--- a/sql/updates/world/master/2024_10_27_00_world.sql
+++ b/sql/old/11.x/world/24092_2024_11_16/2024_10_27_00_world.sql
diff --git a/sql/updates/world/master/2024_10_27_01_world.sql b/sql/old/11.x/world/24092_2024_11_16/2024_10_27_01_world.sql
index 27a6d3fb130..27a6d3fb130 100644
--- a/sql/updates/world/master/2024_10_27_01_world.sql
+++ b/sql/old/11.x/world/24092_2024_11_16/2024_10_27_01_world.sql
diff --git a/sql/updates/world/master/2024_10_27_02_world.sql b/sql/old/11.x/world/24092_2024_11_16/2024_10_27_02_world.sql
index 3e472af60b1..3e472af60b1 100644
--- a/sql/updates/world/master/2024_10_27_02_world.sql
+++ b/sql/old/11.x/world/24092_2024_11_16/2024_10_27_02_world.sql
diff --git a/sql/updates/world/master/2024_10_27_03_world.sql b/sql/old/11.x/world/24092_2024_11_16/2024_10_27_03_world.sql
index 912698f475c..912698f475c 100644
--- a/sql/updates/world/master/2024_10_27_03_world.sql
+++ b/sql/old/11.x/world/24092_2024_11_16/2024_10_27_03_world.sql
diff --git a/sql/updates/world/master/2024_11_01_00_world.sql b/sql/old/11.x/world/24092_2024_11_16/2024_11_01_00_world.sql
index cba16561106..cba16561106 100644
--- a/sql/updates/world/master/2024_11_01_00_world.sql
+++ b/sql/old/11.x/world/24092_2024_11_16/2024_11_01_00_world.sql
diff --git a/sql/updates/world/master/2024_11_03_00_world.sql b/sql/old/11.x/world/24092_2024_11_16/2024_11_03_00_world.sql
index 64334de0636..64334de0636 100644
--- a/sql/updates/world/master/2024_11_03_00_world.sql
+++ b/sql/old/11.x/world/24092_2024_11_16/2024_11_03_00_world.sql
diff --git a/sql/updates/world/master/2024_11_05_00_world.sql b/sql/old/11.x/world/24092_2024_11_16/2024_11_05_00_world.sql
index 794502aa58b..794502aa58b 100644
--- a/sql/updates/world/master/2024_11_05_00_world.sql
+++ b/sql/old/11.x/world/24092_2024_11_16/2024_11_05_00_world.sql
diff --git a/sql/updates/world/master/2024_11_05_01_world.sql b/sql/old/11.x/world/24092_2024_11_16/2024_11_05_01_world.sql
index 1684ba68205..1684ba68205 100644
--- a/sql/updates/world/master/2024_11_05_01_world.sql
+++ b/sql/old/11.x/world/24092_2024_11_16/2024_11_05_01_world.sql
diff --git a/sql/updates/world/master/2024_11_05_02_world.sql b/sql/old/11.x/world/24092_2024_11_16/2024_11_05_02_world.sql
index 274a410beb8..274a410beb8 100644
--- a/sql/updates/world/master/2024_11_05_02_world.sql
+++ b/sql/old/11.x/world/24092_2024_11_16/2024_11_05_02_world.sql
diff --git a/sql/updates/world/master/2024_11_05_03_world.sql b/sql/old/11.x/world/24092_2024_11_16/2024_11_05_03_world.sql
index b3e5423bca6..b3e5423bca6 100644
--- a/sql/updates/world/master/2024_11_05_03_world.sql
+++ b/sql/old/11.x/world/24092_2024_11_16/2024_11_05_03_world.sql
diff --git a/sql/updates/world/master/2024_11_05_04_world.sql b/sql/old/11.x/world/24092_2024_11_16/2024_11_05_04_world.sql
index 1b75f05b760..1b75f05b760 100644
--- a/sql/updates/world/master/2024_11_05_04_world.sql
+++ b/sql/old/11.x/world/24092_2024_11_16/2024_11_05_04_world.sql
diff --git a/sql/updates/world/master/2024_11_05_05_world.sql b/sql/old/11.x/world/24092_2024_11_16/2024_11_05_05_world.sql
index d7766a23664..d7766a23664 100644
--- a/sql/updates/world/master/2024_11_05_05_world.sql
+++ b/sql/old/11.x/world/24092_2024_11_16/2024_11_05_05_world.sql
diff --git a/sql/updates/world/master/2024_11_06_00_world.sql b/sql/old/11.x/world/24092_2024_11_16/2024_11_06_00_world.sql
index 095999bbdb7..095999bbdb7 100644
--- a/sql/updates/world/master/2024_11_06_00_world.sql
+++ b/sql/old/11.x/world/24092_2024_11_16/2024_11_06_00_world.sql
diff --git a/sql/updates/world/master/2024_11_06_01_world.sql b/sql/old/11.x/world/24092_2024_11_16/2024_11_06_01_world.sql
index 58b207ad90b..58b207ad90b 100644
--- a/sql/updates/world/master/2024_11_06_01_world.sql
+++ b/sql/old/11.x/world/24092_2024_11_16/2024_11_06_01_world.sql
diff --git a/sql/updates/world/master/2024_11_06_02_world.sql b/sql/old/11.x/world/24092_2024_11_16/2024_11_06_02_world.sql
index 141b8e6d7ea..141b8e6d7ea 100644
--- a/sql/updates/world/master/2024_11_06_02_world.sql
+++ b/sql/old/11.x/world/24092_2024_11_16/2024_11_06_02_world.sql
diff --git a/sql/updates/world/master/2024_11_06_03_world.sql b/sql/old/11.x/world/24092_2024_11_16/2024_11_06_03_world.sql
index 0a7c2304024..0a7c2304024 100644
--- a/sql/updates/world/master/2024_11_06_03_world.sql
+++ b/sql/old/11.x/world/24092_2024_11_16/2024_11_06_03_world.sql
diff --git a/sql/updates/world/master/2024_11_06_04_world.sql b/sql/old/11.x/world/24092_2024_11_16/2024_11_06_04_world.sql
index 8e20c9cfe71..8e20c9cfe71 100644
--- a/sql/updates/world/master/2024_11_06_04_world.sql
+++ b/sql/old/11.x/world/24092_2024_11_16/2024_11_06_04_world.sql
diff --git a/sql/updates/world/master/2024_11_06_05_world.sql b/sql/old/11.x/world/24092_2024_11_16/2024_11_06_05_world.sql
index 58e9150d270..58e9150d270 100644
--- a/sql/updates/world/master/2024_11_06_05_world.sql
+++ b/sql/old/11.x/world/24092_2024_11_16/2024_11_06_05_world.sql
diff --git a/sql/updates/world/master/2024_11_06_06_world.sql b/sql/old/11.x/world/24092_2024_11_16/2024_11_06_06_world.sql
index d0a4141e922..d0a4141e922 100644
--- a/sql/updates/world/master/2024_11_06_06_world.sql
+++ b/sql/old/11.x/world/24092_2024_11_16/2024_11_06_06_world.sql
diff --git a/sql/updates/world/master/2024_11_06_07_world.sql b/sql/old/11.x/world/24092_2024_11_16/2024_11_06_07_world.sql
index ec7c9fdf171..ec7c9fdf171 100644
--- a/sql/updates/world/master/2024_11_06_07_world.sql
+++ b/sql/old/11.x/world/24092_2024_11_16/2024_11_06_07_world.sql
diff --git a/sql/updates/world/master/2024_11_06_08_world.sql b/sql/old/11.x/world/24092_2024_11_16/2024_11_06_08_world.sql
index 6edc9050fa1..6edc9050fa1 100644
--- a/sql/updates/world/master/2024_11_06_08_world.sql
+++ b/sql/old/11.x/world/24092_2024_11_16/2024_11_06_08_world.sql
diff --git a/sql/updates/world/master/2024_11_08_00_world.sql b/sql/old/11.x/world/24092_2024_11_16/2024_11_08_00_world.sql
index ec3fbf294f5..ec3fbf294f5 100644
--- a/sql/updates/world/master/2024_11_08_00_world.sql
+++ b/sql/old/11.x/world/24092_2024_11_16/2024_11_08_00_world.sql
diff --git a/sql/updates/world/master/2024_11_08_01_world.sql b/sql/old/11.x/world/24092_2024_11_16/2024_11_08_01_world.sql
index ee6cf532c83..ee6cf532c83 100644
--- a/sql/updates/world/master/2024_11_08_01_world.sql
+++ b/sql/old/11.x/world/24092_2024_11_16/2024_11_08_01_world.sql
diff --git a/sql/updates/world/master/2024_11_08_02_world.sql b/sql/old/11.x/world/24092_2024_11_16/2024_11_08_02_world.sql
index aa49815180a..aa49815180a 100644
--- a/sql/updates/world/master/2024_11_08_02_world.sql
+++ b/sql/old/11.x/world/24092_2024_11_16/2024_11_08_02_world.sql
diff --git a/sql/updates/world/master/2024_11_08_03_world.sql b/sql/old/11.x/world/24092_2024_11_16/2024_11_08_03_world.sql
index fa046010362..fa046010362 100644
--- a/sql/updates/world/master/2024_11_08_03_world.sql
+++ b/sql/old/11.x/world/24092_2024_11_16/2024_11_08_03_world.sql
diff --git a/sql/updates/world/master/2024_11_08_04_world.sql b/sql/old/11.x/world/24092_2024_11_16/2024_11_08_04_world.sql
index a78b4ecc4cd..a78b4ecc4cd 100644
--- a/sql/updates/world/master/2024_11_08_04_world.sql
+++ b/sql/old/11.x/world/24092_2024_11_16/2024_11_08_04_world.sql
diff --git a/sql/updates/world/master/2024_11_08_05_world.sql b/sql/old/11.x/world/24092_2024_11_16/2024_11_08_05_world.sql
index 5b3feda1210..5b3feda1210 100644
--- a/sql/updates/world/master/2024_11_08_05_world.sql
+++ b/sql/old/11.x/world/24092_2024_11_16/2024_11_08_05_world.sql
diff --git a/sql/updates/world/master/2024_11_08_06_world.sql b/sql/old/11.x/world/24092_2024_11_16/2024_11_08_06_world.sql
index 467e02f407c..467e02f407c 100644
--- a/sql/updates/world/master/2024_11_08_06_world.sql
+++ b/sql/old/11.x/world/24092_2024_11_16/2024_11_08_06_world.sql
diff --git a/sql/updates/world/master/2024_11_08_07_world.sql b/sql/old/11.x/world/24092_2024_11_16/2024_11_08_07_world.sql
index 544b9beb8e0..544b9beb8e0 100644
--- a/sql/updates/world/master/2024_11_08_07_world.sql
+++ b/sql/old/11.x/world/24092_2024_11_16/2024_11_08_07_world.sql
diff --git a/sql/updates/world/master/2024_11_09_00_world.sql b/sql/old/11.x/world/24092_2024_11_16/2024_11_09_00_world.sql
index 4560734b87f..4560734b87f 100644
--- a/sql/updates/world/master/2024_11_09_00_world.sql
+++ b/sql/old/11.x/world/24092_2024_11_16/2024_11_09_00_world.sql
diff --git a/sql/updates/world/master/2024_11_09_01_world.sql b/sql/old/11.x/world/24092_2024_11_16/2024_11_09_01_world.sql
index 39e12ed53c5..39e12ed53c5 100644
--- a/sql/updates/world/master/2024_11_09_01_world.sql
+++ b/sql/old/11.x/world/24092_2024_11_16/2024_11_09_01_world.sql
diff --git a/sql/updates/world/master/2024_11_09_02_world.sql b/sql/old/11.x/world/24092_2024_11_16/2024_11_09_02_world.sql
index d9772563f75..d9772563f75 100644
--- a/sql/updates/world/master/2024_11_09_02_world.sql
+++ b/sql/old/11.x/world/24092_2024_11_16/2024_11_09_02_world.sql
diff --git a/sql/updates/world/master/2024_11_09_03_world.sql b/sql/old/11.x/world/24092_2024_11_16/2024_11_09_03_world.sql
index 126e3104f79..126e3104f79 100644
--- a/sql/updates/world/master/2024_11_09_03_world.sql
+++ b/sql/old/11.x/world/24092_2024_11_16/2024_11_09_03_world.sql
diff --git a/sql/updates/world/master/2024_11_09_04_world.sql b/sql/old/11.x/world/24092_2024_11_16/2024_11_09_04_world.sql
index 4fd623f5036..4fd623f5036 100644
--- a/sql/updates/world/master/2024_11_09_04_world.sql
+++ b/sql/old/11.x/world/24092_2024_11_16/2024_11_09_04_world.sql
diff --git a/sql/updates/world/master/2024_11_12_00_world.sql b/sql/old/11.x/world/24092_2024_11_16/2024_11_12_00_world.sql
index 971cb99c3a4..971cb99c3a4 100644
--- a/sql/updates/world/master/2024_11_12_00_world.sql
+++ b/sql/old/11.x/world/24092_2024_11_16/2024_11_12_00_world.sql
diff --git a/sql/updates/world/master/2024_11_15_00_world.sql b/sql/old/11.x/world/24092_2024_11_16/2024_11_15_00_world.sql
index ea7e23f6575..ea7e23f6575 100644
--- a/sql/updates/world/master/2024_11_15_00_world.sql
+++ b/sql/old/11.x/world/24092_2024_11_16/2024_11_15_00_world.sql
diff --git a/sql/updates/world/master/2024_11_15_01_world.sql b/sql/old/11.x/world/24092_2024_11_16/2024_11_15_01_world.sql
index e6f9a7cbfc9..e6f9a7cbfc9 100644
--- a/sql/updates/world/master/2024_11_15_01_world.sql
+++ b/sql/old/11.x/world/24092_2024_11_16/2024_11_15_01_world.sql
diff --git a/sql/updates/world/master/2024_11_15_02_world.sql b/sql/old/11.x/world/24092_2024_11_16/2024_11_15_02_world.sql
index 0e56c0ccf99..0e56c0ccf99 100644
--- a/sql/updates/world/master/2024_11_15_02_world.sql
+++ b/sql/old/11.x/world/24092_2024_11_16/2024_11_15_02_world.sql
diff --git a/sql/updates/world/master/2024_11_15_03_world.sql b/sql/old/11.x/world/24092_2024_11_16/2024_11_15_03_world.sql
index 25addbd3014..25addbd3014 100644
--- a/sql/updates/world/master/2024_11_15_03_world.sql
+++ b/sql/old/11.x/world/24092_2024_11_16/2024_11_15_03_world.sql
diff --git a/sql/updates/world/master/2024_11_15_04_world.sql b/sql/old/11.x/world/24092_2024_11_16/2024_11_15_04_world.sql
index 47791028632..47791028632 100644
--- a/sql/updates/world/master/2024_11_15_04_world.sql
+++ b/sql/old/11.x/world/24092_2024_11_16/2024_11_15_04_world.sql
diff --git a/sql/updates/world/master/2024_11_16_00_world_enUS.sql b/sql/old/11.x/world/24092_2024_11_16/2024_11_16_00_world_enUS.sql
index 674afe83f2f..674afe83f2f 100644
--- a/sql/updates/world/master/2024_11_16_00_world_enUS.sql
+++ b/sql/old/11.x/world/24092_2024_11_16/2024_11_16_00_world_enUS.sql
diff --git a/sql/updates/world/master/2024_11_16_01_world_deDE.sql b/sql/old/11.x/world/24092_2024_11_16/2024_11_16_01_world_deDE.sql
index 69686183467..69686183467 100644
--- a/sql/updates/world/master/2024_11_16_01_world_deDE.sql
+++ b/sql/old/11.x/world/24092_2024_11_16/2024_11_16_01_world_deDE.sql
diff --git a/sql/updates/world/master/2024_11_16_02_world_esES.sql b/sql/old/11.x/world/24092_2024_11_16/2024_11_16_02_world_esES.sql
index cd88f664869..cd88f664869 100644
--- a/sql/updates/world/master/2024_11_16_02_world_esES.sql
+++ b/sql/old/11.x/world/24092_2024_11_16/2024_11_16_02_world_esES.sql
diff --git a/sql/updates/world/master/2024_11_16_03_world_esMX.sql b/sql/old/11.x/world/24092_2024_11_16/2024_11_16_03_world_esMX.sql
index 7dd1d17b109..7dd1d17b109 100644
--- a/sql/updates/world/master/2024_11_16_03_world_esMX.sql
+++ b/sql/old/11.x/world/24092_2024_11_16/2024_11_16_03_world_esMX.sql
diff --git a/sql/updates/world/master/2024_11_16_04_world_frFR.sql b/sql/old/11.x/world/24092_2024_11_16/2024_11_16_04_world_frFR.sql
index f859c5370aa..f859c5370aa 100644
--- a/sql/updates/world/master/2024_11_16_04_world_frFR.sql
+++ b/sql/old/11.x/world/24092_2024_11_16/2024_11_16_04_world_frFR.sql
diff --git a/sql/updates/world/master/2024_11_16_05_world_itIT.sql b/sql/old/11.x/world/24092_2024_11_16/2024_11_16_05_world_itIT.sql
index dd9c4aa184f..dd9c4aa184f 100644
--- a/sql/updates/world/master/2024_11_16_05_world_itIT.sql
+++ b/sql/old/11.x/world/24092_2024_11_16/2024_11_16_05_world_itIT.sql
diff --git a/sql/updates/world/master/2024_11_16_06_world_koKR.sql b/sql/old/11.x/world/24092_2024_11_16/2024_11_16_06_world_koKR.sql
index dd76056ceef..dd76056ceef 100644
--- a/sql/updates/world/master/2024_11_16_06_world_koKR.sql
+++ b/sql/old/11.x/world/24092_2024_11_16/2024_11_16_06_world_koKR.sql
diff --git a/sql/updates/world/master/2024_11_16_07_world_ptBR.sql b/sql/old/11.x/world/24092_2024_11_16/2024_11_16_07_world_ptBR.sql
index af548ae086c..af548ae086c 100644
--- a/sql/updates/world/master/2024_11_16_07_world_ptBR.sql
+++ b/sql/old/11.x/world/24092_2024_11_16/2024_11_16_07_world_ptBR.sql
diff --git a/sql/updates/world/master/2024_11_16_08_world_ruRU.sql b/sql/old/11.x/world/24092_2024_11_16/2024_11_16_08_world_ruRU.sql
index 5bfed4e63d8..5bfed4e63d8 100644
--- a/sql/updates/world/master/2024_11_16_08_world_ruRU.sql
+++ b/sql/old/11.x/world/24092_2024_11_16/2024_11_16_08_world_ruRU.sql
diff --git a/sql/updates/world/master/2024_11_16_09_world_zhCN.sql b/sql/old/11.x/world/24092_2024_11_16/2024_11_16_09_world_zhCN.sql
index bb9d3aec3f8..bb9d3aec3f8 100644
--- a/sql/updates/world/master/2024_11_16_09_world_zhCN.sql
+++ b/sql/old/11.x/world/24092_2024_11_16/2024_11_16_09_world_zhCN.sql
diff --git a/sql/updates/world/master/2024_11_16_10_world_zhTW.sql b/sql/old/11.x/world/24092_2024_11_16/2024_11_16_10_world_zhTW.sql
index ab5f365e59f..ab5f365e59f 100644
--- a/sql/updates/world/master/2024_11_16_10_world_zhTW.sql
+++ b/sql/old/11.x/world/24092_2024_11_16/2024_11_16_10_world_zhTW.sql
diff --git a/sql/updates/world/master/2024_11_16_11_world_creature_difficulty.sql b/sql/old/11.x/world/24092_2024_11_16/2024_11_16_11_world_creature_difficulty.sql
index 73b49c13268..73b49c13268 100644
--- a/sql/updates/world/master/2024_11_16_11_world_creature_difficulty.sql
+++ b/sql/old/11.x/world/24092_2024_11_16/2024_11_16_11_world_creature_difficulty.sql
diff --git a/sql/updates/world/master/2024_11_16_12_world_quest_poi.sql b/sql/old/11.x/world/24092_2024_11_16/2024_11_16_12_world_quest_poi.sql
index 9a08ee0a44e..9a08ee0a44e 100644
--- a/sql/updates/world/master/2024_11_16_12_world_quest_poi.sql
+++ b/sql/old/11.x/world/24092_2024_11_16/2024_11_16_12_world_quest_poi.sql
diff --git a/sql/updates/auth/master/2024_11_16_00_auth.sql b/sql/updates/auth/master/2024_11_16_00_auth.sql
new file mode 100644
index 00000000000..7f039313880
--- /dev/null
+++ b/sql/updates/auth/master/2024_11_16_00_auth.sql
@@ -0,0 +1,3 @@
+-- TDB 1105.24111 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_11_16_00_characters.sql b/sql/updates/characters/master/2024_11_16_00_characters.sql
new file mode 100644
index 00000000000..d293d2af437
--- /dev/null
+++ b/sql/updates/characters/master/2024_11_16_00_characters.sql
@@ -0,0 +1,3 @@
+-- TDB 1105.24111 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_11_16_23_hotfixes.sql b/sql/updates/hotfixes/master/2024_11_16_23_hotfixes.sql
new file mode 100644
index 00000000000..99b822bd772
--- /dev/null
+++ b/sql/updates/hotfixes/master/2024_11_16_23_hotfixes.sql
@@ -0,0 +1,3 @@
+-- TDB 1105.24111 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_11_16_13_world.sql b/sql/updates/world/master/2024_11_16_13_world.sql
new file mode 100644
index 00000000000..947f3260015
--- /dev/null
+++ b/sql/updates/world/master/2024_11_16_13_world.sql
@@ -0,0 +1,4 @@
+-- TDB 1105.24111 world
+UPDATE `version` SET `db_version`='TDB 1105.24111', `cache_id`=24111 LIMIT 1;
+UPDATE `updates` SET `state`='ARCHIVED',`speed`=0;
+REPLACE INTO `updates_include` (`path`, `state`) VALUES ('$/sql/old/11.x/world', 'ARCHIVED');