aboutsummaryrefslogtreecommitdiff
path: root/sql/old
AgeCommit message (Collapse)Author
2025-08-19SQL: Fix 2025_08_13_00_characters for characters that had items in bank but ↵Shauren
not unlocked any bank bags Closes #31219
2025-08-16TDB 1120.25081 - 2025/08/16TDB1120.25081TDB Release
2025-07-21TDB 1117.25071 - 2025/07/21TDB1117.25071TDB Release
2025-05-31TDB 1115.25051 - 2025/05/31TDB1115.25051TDB Release
2025-03-29TDB 1110.25031 - 2025/03/29TDB1110.25031TDB Release
2025-01-11SQL: Fix line endings in old sql filesShauren
2024-12-22TDB 1107.24121 - 2024/12/22TDB1107.24121TDB Release
2024-11-16TDB 1105.24111 - 2024/11/16TDB1105.24111TDB Release
2024-09-23TDB 1102.24092 - 2024/09/23TDB1102.24092TDB Release
2024-09-03TDB 1102.24091 - 2024/09/03TDB1102.24091TDB Release
2024-05-11TDB 1027.24051 - 2024/05/11TDB1027.24051TDB Release
2024-02-08TDB 1025.24021 - 2024/02/08TDB1025.24021TDB Release
2023-11-15TDB 1020.23111 - 2023/11/15TDB1020.23111TDB Release
2023-10-06TDB 1017.23101 - 2023/10/06TDB1017.23101TDB Release
2023-07-14TDB 1015.23071 - 2023/07/14TDB1015.23071TDB Release
2023-04-02TDB 1007.23041 - 2023/04/02TDB1007.23041TDB Release
2023-02-03TDB 1005.23021 - 2023/02/03TDB1005.23021TDB Release
2022-12-20TDB 1002.22121 - 2022/12/20TDB1002.22121TDB Release
2022-11-20TDB 927.22111 - 2022/11/20TDB927.22111TDB Release
2022-08-21TDB 927.22082 - 2022/08/21TDB927.22082TDB Release
2022-08-19TDB 927.22081 - 2022/08/19TDB927.22081TDB Release
2022-07-25TDB 925.22071 - 2022/07/25TDB925.22071TDB Release
2022-03-06TDB 920.22031 - 2022/03/06TDB920.22031TDB Release
2022-01-15TDB 915.22012 - 2022/01/15TDB915.22012TDB Release
2022-01-02TDB 915.22011 - 2022/01/02TDB915.22011TDB Release
2021-11-17TDB 915.21111 - 2021/11/17TDB915.21111TDB Release
2021-11-10Core/SAI: Add a 4th target parameter to SAIjackpoz
(cherry picked from commit 7634a57f64a38e1151d648eeacae8480c83d19df)
2021-10-15TDB 910.21101 - 2021/10/15TDB910.21101TDB Release
2021-08-18TDB 910.21081 - 2021/08/18TDB910.21081TDB Release
2021-07-04TDB 905.21071 - 2021/07/04TDB905.21071TDB Release
2021-05-16Scripts/Commands: New command: .debug threatinfoTreeston
(cherry picked from commit f45c211987794ff7e4192e0d3d4ca6bf67335fb5)
2020-10-20TDB 837.20101 - 2020/10/20TDB837.20101TDB Release
2020-08-14TDB 837.20081 - 2020/08/14TDB837.20081TDB Release
2020-07-16Combat/threat rewrite prep - merge RBAC/DB changes.treeston
(cherry picked from commit e35092c6a164e929f9684b350093b2beefee5d86)
2020-06-17TDB 830.20061 - 2020/06/17TDB830.20061TDB Release
2019-07-15TDB 820.19071 - 2019/07/15TDB820.19071Aokromes
2018-02-19TDB 735.00 - 2018/02/19TDB735.00DDuarte
2017-04-19TDB 720.00 - 2016/04/18TDB720.00DDuarte
2016-10-16TDB 703.00 - 2016/10/17TDB703.00DDuarte
2016-04-11TDB 6.04 - 2016/04/11TDB6.04DDuarte
2015-11-08TDB 6.03 - 2015/11/08TDB6.03Carbenium
2015-07-14TDB 6.0.2 - 2015/07/14TDB6.02DDuarte
2015-07-10CRLF to LFDDuarte
2015-03-21TDB 6.0.1 - 2015/03/21TDB6.01Nayd
Closes #13816 Closes #13792 Ref #14139
2015-03-21Core/Updates: Add an automatic database update system. Automatically detects ↵Naios
new and edited sql updates through file lists and hashing. Detects renames, deletes and is able to create and auto import full databases. * cleanups in main.cpp of world & bnetserver * refactoring in DatabaseWorkerPool.h & MySQLConnection.cpp Make sure you re-run cmake, because boost::iostreams was added as dependency. Maybe you need to install libboost-iostreams1.55-dev on unix as well. Import every update manual until (included) those INSERT IGNORE updates for each database. Thanks DDuarte and Shauren for your amazing ideas, help and advises. In hope that nobody gets a "Your database structure is not up to date..." anymore ,-) Signed-off-by: Naios <naios-dev@live.de> Signed-off-by: Nayd <dnpd.dd@gmail.com>
2015-01-19Line ending fix, sorry.Nayd
2014-10-19TDB 434.09 - 2014/10/19TDB434.09DDuarte
2014-10-19Merge remote-tracking branch 'origin/3.3.5' into 4.3.4DDuarte
Conflicts: sql/old/3.3.5a/TDB56_to_TDB57_updates/world/2014_09_21_03_world.sql sql/old/3.3.5a/TDB56_to_TDB57_updates/world/2014_09_21_04_world.sql sql/old/3.3.5a/TDB56_to_TDB57_updates/world/2014_09_21_05_world.sql sql/old/3.3.5a/TDB56_to_TDB57_updates/world/2014_09_21_06_world.sql sql/old/3.3.5a/TDB56_to_TDB57_updates/world/2014_09_21_07_world.sql sql/old/3.3.5a/TDB56_to_TDB57_updates/world/2014_09_22_00_world.sql sql/old/3.3.5a/TDB56_to_TDB57_updates/world/2014_09_23_00_world.sql sql/old/3.3.5a/TDB56_to_TDB57_updates/world/2014_09_23_01_world.sql sql/old/3.3.5a/TDB56_to_TDB57_updates/world/2014_09_23_02_world.sql sql/old/3.3.5a/TDB56_to_TDB57_updates/world/2014_09_23_03_world.sql sql/old/3.3.5a/TDB56_to_TDB57_updates/world/2014_09_23_04_world.sql sql/old/3.3.5a/TDB56_to_TDB57_updates/world/2014_09_24_00_world.sql sql/old/3.3.5a/TDB56_to_TDB57_updates/world/2014_09_24_01_world.sql sql/old/3.3.5a/TDB56_to_TDB57_updates/world/2014_09_25_00_world.sql sql/old/3.3.5a/TDB56_to_TDB57_updates/world/2014_09_25_01_world.sql sql/old/3.3.5a/TDB56_to_TDB57_updates/world/2014_09_25_02_world.sql sql/old/3.3.5a/TDB56_to_TDB57_updates/world/2014_09_26_00_world.sql sql/old/3.3.5a/TDB56_to_TDB57_updates/world/2014_09_26_01_world.sql sql/old/3.3.5a/TDB56_to_TDB57_updates/world/2014_09_26_02_world.sql sql/old/3.3.5a/TDB56_to_TDB57_updates/world/2014_09_26_03_world.sql sql/old/3.3.5a/TDB56_to_TDB57_updates/world/2014_09_27_00_world.sql sql/old/3.3.5a/TDB56_to_TDB57_updates/world/2014_09_27_01_world.sql sql/old/3.3.5a/TDB56_to_TDB57_updates/world/2014_09_27_02_world.sql sql/old/3.3.5a/TDB56_to_TDB57_updates/world/2014_09_27_03_world.sql sql/old/3.3.5a/TDB56_to_TDB57_updates/world/2014_09_28_00_world.sql sql/old/3.3.5a/TDB56_to_TDB57_updates/world/2014_09_28_01_world.sql sql/old/3.3.5a/TDB56_to_TDB57_updates/world/2014_09_29_00_world.sql sql/old/3.3.5a/TDB56_to_TDB57_updates/world/2014_09_29_01_world.sql sql/old/3.3.5a/TDB56_to_TDB57_updates/world/2014_09_29_02_world_335.sql sql/old/3.3.5a/TDB56_to_TDB57_updates/world/2014_09_29_03_world.sql sql/old/3.3.5a/TDB56_to_TDB57_updates/world/2014_09_30_00_world_335.sql sql/old/3.3.5a/TDB56_to_TDB57_updates/world/2014_09_30_01_world.sql sql/old/3.3.5a/TDB56_to_TDB57_updates/world/2014_09_30_02_world.sql sql/old/3.3.5a/TDB56_to_TDB57_updates/world/2014_10_01_00_world.sql sql/old/3.3.5a/TDB56_to_TDB57_updates/world/2014_10_01_01_world.sql sql/old/3.3.5a/TDB56_to_TDB57_updates/world/2014_10_02_00_world.sql sql/old/3.3.5a/TDB56_to_TDB57_updates/world/2014_10_04_00_world.sql sql/old/3.3.5a/TDB56_to_TDB57_updates/world/2014_10_04_01_world.sql sql/old/3.3.5a/TDB56_to_TDB57_updates/world/2014_10_05_00_world.sql sql/old/3.3.5a/TDB56_to_TDB57_updates/world/2014_10_05_01_world.sql sql/old/3.3.5a/TDB56_to_TDB57_updates/world/2014_10_05_02_world.sql sql/old/3.3.5a/TDB56_to_TDB57_updates/world/2014_10_05_03_world.sql sql/old/3.3.5a/TDB56_to_TDB57_updates/world/2014_10_05_04_world.sql sql/old/3.3.5a/TDB56_to_TDB57_updates/world/2014_10_05_05_world.sql sql/old/3.3.5a/TDB56_to_TDB57_updates/world/2014_10_05_06_world.sql sql/old/3.3.5a/TDB56_to_TDB57_updates/world/2014_10_05_07_world.sql sql/old/3.3.5a/TDB56_to_TDB57_updates/world/2014_10_06_00_world.sql sql/old/3.3.5a/TDB56_to_TDB57_updates/world/2014_10_06_01_world.sql sql/old/3.3.5a/TDB56_to_TDB57_updates/world/2014_10_06_02_world.sql sql/old/3.3.5a/TDB56_to_TDB57_updates/world/2014_10_06_03_world.sql sql/old/3.3.5a/TDB56_to_TDB57_updates/world/2014_10_06_04_world.sql sql/old/3.3.5a/TDB56_to_TDB57_updates/world/2014_10_06_05_world.sql sql/old/3.3.5a/TDB56_to_TDB57_updates/world/2014_10_06_06_world.sql sql/old/3.3.5a/TDB56_to_TDB57_updates/world/2014_10_07_00_world.sql sql/old/3.3.5a/TDB56_to_TDB57_updates/world/2014_10_07_01_world.sql sql/old/3.3.5a/TDB56_to_TDB57_updates/world/2014_10_08_00_world.sql sql/old/3.3.5a/TDB56_to_TDB57_updates/world/2014_10_08_01_world.sql sql/old/3.3.5a/TDB56_to_TDB57_updates/world/2014_10_08_02_world.sql sql/old/3.3.5a/TDB56_to_TDB57_updates/world/2014_10_09_00_world.sql sql/old/3.3.5a/TDB56_to_TDB57_updates/world/2014_10_09_01_world.sql sql/old/3.3.5a/TDB56_to_TDB57_updates/world/2014_10_09_02_world.sql sql/old/3.3.5a/TDB56_to_TDB57_updates/world/2014_10_10_00_world.sql sql/old/3.3.5a/TDB56_to_TDB57_updates/world/2014_10_10_01_world_335.sql sql/old/3.3.5a/TDB56_to_TDB57_updates/world/2014_10_10_02_world.sql sql/old/3.3.5a/TDB56_to_TDB57_updates/world/2014_10_10_03_world.sql sql/old/3.3.5a/TDB56_to_TDB57_updates/world/2014_10_10_04_world_335.sql sql/old/3.3.5a/TDB56_to_TDB57_updates/world/2014_10_10_05_world.sql sql/old/3.3.5a/TDB56_to_TDB57_updates/world/2014_10_10_06_world.sql sql/old/3.3.5a/TDB56_to_TDB57_updates/world/2014_10_11_00_world.sql sql/old/3.3.5a/TDB56_to_TDB57_updates/world/2014_10_11_01_world.sql sql/old/3.3.5a/TDB56_to_TDB57_updates/world/2014_10_11_02_world.sql sql/old/3.3.5a/TDB56_to_TDB57_updates/world/2014_10_11_03_world.sql sql/old/3.3.5a/TDB56_to_TDB57_updates/world/2014_10_11_04_world.sql sql/old/3.3.5a/TDB56_to_TDB57_updates/world/2014_10_11_05_world.sql sql/old/3.3.5a/TDB56_to_TDB57_updates/world/2014_10_11_06_world.sql sql/old/3.3.5a/TDB56_to_TDB57_updates/world/2014_10_11_07_world.sql sql/old/3.3.5a/TDB56_to_TDB57_updates/world/2014_10_12_00_world.sql sql/old/3.3.5a/TDB56_to_TDB57_updates/world/2014_10_12_01_world.sql sql/old/3.3.5a/TDB56_to_TDB57_updates/world/2014_10_12_02_world.sql sql/old/3.3.5a/TDB56_to_TDB57_updates/world/2014_10_12_03_world.sql sql/old/3.3.5a/TDB56_to_TDB57_updates/world/2014_10_12_04_world.sql sql/old/3.3.5a/TDB56_to_TDB57_updates/world/2014_10_12_05_world.sql sql/old/3.3.5a/TDB56_to_TDB57_updates/world/2014_10_12_06_world.sql sql/old/3.3.5a/TDB56_to_TDB57_updates/world/2014_10_12_07_world.sql sql/old/3.3.5a/TDB56_to_TDB57_updates/world/2014_10_13_00_world.sql sql/old/3.3.5a/TDB56_to_TDB57_updates/world/2014_10_13_01_world.sql sql/old/3.3.5a/TDB56_to_TDB57_updates/world/2014_10_15_00_world.sql sql/old/3.3.5a/TDB56_to_TDB57_updates/world/2014_10_16_00_world.sql sql/old/3.3.5a/TDB56_to_TDB57_updates/world/2014_10_17_00_world.sql sql/old/3.3.5a/TDB56_to_TDB57_updates/world/2014_10_18_00_world.sql sql/old/3.3.5a/TDB56_to_TDB57_updates/world/2014_10_18_01_world.sql sql/old/3.3.5a/TDB56_to_TDB57_updates/world/2014_10_18_02_world.sql sql/old/3.3.5a/TDB56_to_TDB57_updates/world/2014_10_18_03_world.sql sql/old/3.3.5a/TDB56_to_TDB57_updates/world/2014_10_18_04_world.sql sql/updates/world/017_2014_09_21_04_world.sql sql/updates/world/017_2014_09_21_05_world.sql sql/updates/world/017_2014_09_21_06_world.sql sql/updates/world/017_2014_09_21_07_world.sql sql/updates/world/040_2014_09_22_00_world.sql sql/updates/world/040_2014_09_23_00_world.sql sql/updates/world/040_2014_09_23_01_world.sql sql/updates/world/040_2014_09_23_02_world.sql sql/updates/world/040_2014_09_23_03_world.sql sql/updates/world/040_2014_09_23_04_world.sql sql/updates/world/040_2014_09_24_00_world.sql sql/updates/world/040_2014_09_24_01_world.sql sql/updates/world/040_2014_09_25_00_world.sql sql/updates/world/040_2014_09_25_01_world.sql sql/updates/world/040_2014_09_25_02_world.sql sql/updates/world/040_2014_09_26_00_world.sql sql/updates/world/040_2014_09_26_01_world.sql sql/updates/world/040_2014_09_26_02_world.sql sql/updates/world/040_2014_09_26_03_world.sql sql/updates/world/040_2014_09_27_00_world.sql sql/updates/world/040_2014_09_27_01_world.sql sql/updates/world/048_2014_09_27_02_world.sql sql/updates/world/048_2014_09_27_03_world.sql sql/updates/world/050_2014_09_28_00_world.sql sql/updates/world/050_2014_09_28_01_world.sql sql/updates/world/050_2014_09_29_00_world.sql sql/updates/world/050_2014_09_29_01_world.sql sql/updates/world/050_2014_09_29_02_world_335.sql sql/updates/world/050_2014_09_29_03_world.sql sql/updates/world/050_2014_09_30_00_world_335.sql sql/updates/world/051_2014_09_30_01_world.sql sql/updates/world/051_2014_09_30_02_world.sql sql/updates/world/052_2014_10_01_00_world.sql sql/updates/world/053_2014_10_01_01_world.sql sql/updates/world/054_2014_10_02_00_world.sql sql/updates/world/058_2014_10_04_00_world.sql sql/updates/world/062_2014_10_05_01_world.sql sql/updates/world/062_2014_10_05_02_world.sql sql/updates/world/062_2014_10_05_03_world.sql sql/updates/world/062_2014_10_05_04_world.sql sql/updates/world/062_2014_10_05_05_world.sql sql/updates/world/062_2014_10_05_06_world.sql sql/updates/world/062_2014_10_05_07_world.sql sql/updates/world/062_2014_10_06_00_world.sql sql/updates/world/062_2014_10_06_01_world.sql sql/updates/world/062_2014_10_06_02_world.sql sql/updates/world/062_2014_10_06_03_world.sql sql/updates/world/062_2014_10_06_04_world.sql sql/updates/world/062_2014_10_06_05_world.sql sql/updates/world/065_2014_10_06_06_world.sql sql/updates/world/065_2014_10_07_00_world.sql sql/updates/world/065_2014_10_07_01_world.sql sql/updates/world/065_2014_10_08_00_world.sql sql/updates/world/065_2014_10_08_01_world.sql sql/updates/world/065_2014_10_08_02_world.sql sql/updates/world/065_2014_10_09_00_world.sql sql/updates/world/065_2014_10_09_01_world.sql sql/updates/world/065_2014_10_09_02_world.sql sql/updates/world/071_2014_10_10_00_world.sql sql/updates/world/071_2014_10_10_01_world_335.sql sql/updates/world/071_2014_10_10_03_world.sql sql/updates/world/071_2014_10_10_04_world_335.sql sql/updates/world/071_2014_10_10_05_world.sql sql/updates/world/072_2014_10_04_01_world.sql sql/updates/world/072_2014_10_05_00_world.sql sql/updates/world/074_2014_10_10_06_world.sql sql/updates/world/074_2014_10_11_00_world.sql sql/updates/world/075_2014_10_11_01_world.sql sql/updates/world/075_2014_10_11_02_world.sql sql/updates/world/075_2014_10_11_03_world.sql sql/updates/world/075_2014_10_11_04_world.sql sql/updates/world/075_2014_10_11_05_world.sql sql/updates/world/075_2014_10_11_06_world.sql sql/updates/world/075_2014_10_11_07_world.sql sql/updates/world/075_2014_10_12_00_world.sql sql/updates/world/075_2014_10_12_01_world.sql sql/updates/world/075_2014_10_12_04_world.sql sql/updates/world/075_2014_10_12_06_world.sql sql/updates/world/075_2014_10_12_07_world.sql sql/updates/world/077_2014_10_13_00_world.sql sql/updates/world/077_2014_10_13_01_world.sql sql/updates/world/077_2014_10_15_00_world.sql sql/updates/world/077_2014_10_16_00_world.sql sql/updates/world/077_2014_10_17_00_world.sql sql/updates/world/077_2014_10_18_00_world.sql sql/updates/world/077_2014_10_18_01_world.sql sql/updates/world/077_2014_10_18_02_world.sql sql/updates/world/077_2014_10_18_03_world.sql sql/updates/world/077_2014_10_18_04_world.sql sql/updates/world/2014_09_21_04_world.sql sql/updates/world/2014_09_21_05_world.sql sql/updates/world/2014_09_21_06_world.sql sql/updates/world/2014_09_21_07_world.sql sql/updates/world/2014_09_22_00_world.sql sql/updates/world/2014_09_23_00_world.sql sql/updates/world/2014_09_23_01_world.sql sql/updates/world/2014_09_23_02_world.sql sql/updates/world/2014_09_23_03_world.sql sql/updates/world/2014_09_23_04_world.sql sql/updates/world/2014_09_24_00_world.sql sql/updates/world/2014_09_24_01_world.sql sql/updates/world/2014_09_25_00_world.sql sql/updates/world/2014_09_25_01_world.sql sql/updates/world/2014_09_25_02_world.sql sql/updates/world/2014_09_26_00_world.sql sql/updates/world/2014_09_26_01_world.sql sql/updates/world/2014_09_26_02_world.sql sql/updates/world/2014_09_26_03_world.sql sql/updates/world/2014_09_27_00_world.sql sql/updates/world/2014_09_27_01_world.sql sql/updates/world/2014_09_27_02_world.sql sql/updates/world/2014_09_27_03_world.sql sql/updates/world/2014_09_28_00_world.sql sql/updates/world/2014_09_28_01_world.sql sql/updates/world/2014_09_29_00_world.sql sql/updates/world/2014_09_29_01_world.sql sql/updates/world/2014_09_29_02_world_335.sql sql/updates/world/2014_09_29_03_world.sql sql/updates/world/2014_09_30_00_world_335.sql sql/updates/world/2014_09_30_01_world.sql sql/updates/world/2014_09_30_02_world.sql sql/updates/world/2014_10_01_00_world.sql sql/updates/world/2014_10_01_01_world.sql sql/updates/world/2014_10_02_00_world.sql sql/updates/world/2014_10_04_00_world.sql sql/updates/world/2014_10_04_01_world.sql sql/updates/world/2014_10_05_00_world.sql sql/updates/world/2014_10_05_01_world.sql sql/updates/world/2014_10_05_02_world.sql sql/updates/world/2014_10_05_03_world.sql sql/updates/world/2014_10_05_04_world.sql sql/updates/world/2014_10_05_05_world.sql sql/updates/world/2014_10_05_06_world.sql sql/updates/world/2014_10_05_07_world.sql sql/updates/world/2014_10_06_00_world.sql sql/updates/world/2014_10_06_01_world.sql sql/updates/world/2014_10_06_02_world.sql sql/updates/world/2014_10_06_03_world.sql sql/updates/world/2014_10_06_04_world.sql sql/updates/world/2014_10_06_05_world.sql sql/updates/world/2014_10_06_06_world.sql sql/updates/world/2014_10_07_00_world.sql sql/updates/world/2014_10_07_01_world.sql sql/updates/world/2014_10_08_00_world.sql sql/updates/world/2014_10_08_01_world.sql sql/updates/world/2014_10_08_02_world.sql sql/updates/world/2014_10_09_00_world.sql sql/updates/world/2014_10_09_01_world.sql sql/updates/world/2014_10_09_02_world.sql sql/updates/world/2014_10_10_00_world.sql sql/updates/world/2014_10_10_01_world_335.sql sql/updates/world/2014_10_10_03_world.sql sql/updates/world/2014_10_10_04_world_335.sql sql/updates/world/2014_10_10_05_world.sql sql/updates/world/2014_10_10_06_world.sql sql/updates/world/2014_10_11_00_world.sql sql/updates/world/2014_10_11_01_world.sql sql/updates/world/2014_10_11_02_world.sql sql/updates/world/2014_10_11_03_world.sql sql/updates/world/2014_10_11_04_world.sql sql/updates/world/2014_10_11_05_world.sql sql/updates/world/2014_10_11_06_world.sql sql/updates/world/2014_10_11_07_world.sql sql/updates/world/2014_10_12_00_world.sql sql/updates/world/2014_10_12_01_world.sql sql/updates/world/2014_10_12_04_world.sql sql/updates/world/2014_10_12_06_world.sql sql/updates/world/2014_10_12_07_world.sql sql/updates/world/2014_10_13_00_world.sql sql/updates/world/2014_10_13_01_world.sql sql/updates/world/2014_10_15_00_world.sql sql/updates/world/2014_10_16_00_world.sql sql/updates/world/2014_10_17_00_world.sql sql/updates/world/2014_10_18_00_world.sql sql/updates/world/2014_10_18_01_world.sql sql/updates/world/2014_10_18_02_world.sql sql/updates/world/2014_10_18_03_world.sql sql/updates/world/2014_10_18_04_world.sql
2014-10-19TDB 335.57 - 2014/10/20TDB335.57DDuarte
2014-10-19SQL: Add ALL sqls from the TDB 4.3.4 repoDDuarte