* Implemented non-hacky, CMake-way of automagically installing *.sql files without specifying all of them in CMakeLists.

* Moved "sql/TBC-WLK converter" to "sql/TBC-WLK_converter" for compatibility.

--HG--
branch : trunk
rename : sql/TBC-WLK converter/Readme.txt => sql/TBC-WLK_converter/Readme.txt
rename : sql/TBC-WLK converter/TBC-WLK_characters.sql => sql/TBC-WLK_converter/TBC-WLK_characters.sql
rename : sql/TBC-WLK converter/TBC-WLK_world.sql => sql/TBC-WLK_converter/TBC-WLK_world.sql
rename : sql/TBC-WLK converter/TBC-WLK_world_run_only_once.sql => sql/TBC-WLK_converter/TBC-WLK_world_run_only_once.sql

9 files changed, 20 insertions, 273 deletions

diff --git a/sql/CMakeLists.txt b/sql/CMakeLists.txt
index dfdbfd0cf20..d8461bf3df2 100644
--- a/sql/CMakeLists.txt
+++ b/sql/CMakeLists.txt
@@ -1,7 +1,9 @@
+add_subdirectory(TBC-WLK_converter)
 add_subdirectory(updates)
 add_subdirectory(tools)
 
-
 ########### install files ###############
 
-install(FILES  world.sql      realmd.sql      characters.sql      create_mysql.sql      world_scripts_full.sql      world_scripts_structure.sql      drop_mysql.sql DESTINATION share/trinity/sql)
+FILE(GLOB _SQL *.sql)
+
+install(FILES ${_SQL} DESTINATION share/trinity/sql)
diff --git a/sql/TBC-WLK_converter/CMakeLists.txt b/sql/TBC-WLK_converter/CMakeLists.txt
new file mode 100644
index 00000000000..9862f23cef3
--- /dev/null
+++ b/sql/TBC-WLK_converter/CMakeLists.txt
@@ -0,0 +1,5 @@
+########### install files ###############
+
+FILE(GLOB _SQL_TBC_WLK *.sql)
+
+install(FILES ${_SQL_TBC_WLK} Readme.txt DESTINATION share/trinity/sql/TBC-WLK_converter)
diff --git a/sql/TBC-WLK converter/Readme.txt b/sql/TBC-WLK_converter/Readme.txt
index c9f3bec5a9a..c9f3bec5a9a 100644
--- a/sql/TBC-WLK converter/Readme.txt
+++ b/sql/TBC-WLK_converter/Readme.txt
diff --git a/sql/TBC-WLK converter/TBC-WLK_characters.sql b/sql/TBC-WLK_converter/TBC-WLK_characters.sql
index 214c19fef14..214c19fef14 100644
--- a/sql/TBC-WLK converter/TBC-WLK_characters.sql
+++ b/sql/TBC-WLK_converter/TBC-WLK_characters.sql
diff --git a/sql/TBC-WLK converter/TBC-WLK_world.sql b/sql/TBC-WLK_converter/TBC-WLK_world.sql
index a2e3833c2e4..a2e3833c2e4 100644
--- a/sql/TBC-WLK converter/TBC-WLK_world.sql
+++ b/sql/TBC-WLK_converter/TBC-WLK_world.sql
diff --git a/sql/TBC-WLK converter/TBC-WLK_world_run_only_once.sql b/sql/TBC-WLK_converter/TBC-WLK_world_run_only_once.sql
index 798d296370c..798d296370c 100644
--- a/sql/TBC-WLK converter/TBC-WLK_world_run_only_once.sql
+++ b/sql/TBC-WLK_converter/TBC-WLK_world_run_only_once.sql
diff --git a/sql/tools/CMakeLists.txt b/sql/tools/CMakeLists.txt
index bcf0c7a8343..d69a6cdbd2b 100644
--- a/sql/tools/CMakeLists.txt
+++ b/sql/tools/CMakeLists.txt
@@ -1,4 +1,6 @@
 
 ########### install files ###############
 
-install(FILES  characters_item_duplicates_remove.sql      characters_pet_data_cleanup.sql      README DESTINATION share/trinity/sql/tools)
+FILE(GLOB _SQL_TOOLS *.sql)
+
+install(FILES ${_SQL_TOOLS} README DESTINATION share/trinity/sql/tools)
diff --git a/sql/updates/2.4.3_updates/CMakeLists.txt b/sql/updates/2.4.3_updates/CMakeLists.txt
index fb25060338f..fc28dd652cb 100644
--- a/sql/updates/2.4.3_updates/CMakeLists.txt
+++ b/sql/updates/2.4.3_updates/CMakeLists.txt
@@ -1,176 +1,5 @@
+FILE(GLOB _SQL_243 *.sql)
+
 INSTALL(FILES
-11_characters.sql
-45_characters.sql
-54_world.sql
-57_world_scripts.sql
-66_world_scripts.sql
-68_world.sql
-70_world_scripts.sql
-78_world.sql
-79_characters.sql
-79_world.sql
-82_world_scripts.sql
-83_realmd.sql
-84_world.sql
-86_world_scripts.sql
-90_world.sql
-102_world.sql
-112_world_scripts.sql
-116_world.sql
-117_world_scripts.sql
-120_world.sql
-123_world_scripts.sql
-125_world_scripts.sql
-133_world_scripts.sql
-140_world.sql
-145_world_scripts.sql
-146_world.sql
-147_world.sql
-152_world.sql
-153_world.sql
-171_world.sql
-172_world_scripts.sql
-175_world_scripts.sql
-176_world.sql
-182_world.sql
-212_world_scripts.sql
-220_characters.sql
-230_world_blacktemple.sql
-230_world_scripts.sql
-230_world_serpent_shrine.sql
-230_world.sql
-231_world_scripts.sql
-233_world.sql
-238_world.sql
-240_world.sql
-241_world.sql
-247_world.sql
-262_characters.sql
-262_realmd.sql
-262_world.sql
-273_world_scripts.sql
-285_world.sql
-287_world_scripts.sql
-329_world.sql
-332_world.sql
-333_world.sql
-334_world.sql
-341_world.sql
-356_world.sql
-373_world_scripts.sql
-377_world_scripts.sql
-389_world.sql
-400_world.sql
-410_characters.sql
-426_world_scripts.sql
-427_world_scripts.sql
-444_world.sql
-452_world.sql
-455_world.sql
-471_world.sql
-480_world_scripts.sql
-488_world_scripts.sql
-502_world_scripts.sql
-505_world.sql
-506_world.sql
-513_world_scripts.sql
-519_world.sql
-537_world.sql
-541_characters.sql
-541_world.sql
-542_characters.sql
-551_world.sql
-566_world.sql
-571_world.sql
-572_world.sql
-575_world_scripts.sql
-583_world_scripts.sql
-586_world_scripts.sql
-588_world.sql
-608_world.sql
-615_world.sql
-636_world_scripts.sql
-640_world.sql
-645_world_scripts.sql
-667_world_scripts.sql
-676_world.sql
-679_world_scripts.sql
-683_world_scripts.sql
-686_world_scripts.sql
-691_world_scripts.sql
-692_world.sql
-708_world_scripts.sql
-722_world_script_texts.sql
-724_world.sql
-725_characters.sql
-725_world.sql
-728_world_scripts.sql
-733_characters.sql
-739_characters.sql
-741_characters.sql
-741_world.sql
-747_world.sql
-748_world_scripts.sql
-758_world_scripts.sql
-762_world.sql
-764_world_scripts.sql
-765_world_scripts.sql
-773_world_scripts.sql
-780_characters.sql
-783_world.sql
-785_world.sql
-789_world.sql
-807_world_scripts.sql
-817_world_scripts.sql
-822_world_scripts.sql
-826_world_scripts.sql
-833_world_scripts.sql
-834_world_scripts.sql
-837_world_scripts.sql
-838_world_scripts.sql
-839_world_scripts.sql
-840_world_scripts.sql
-841_world_scripts.sql
-842_world.sql
-850_world_scripts.sql
-852_world_scripts.sql
-857_world_scripts.sql
-863_world_scripts.sql
-871_world.sql
-884_world.sql
-905_world_scripts.sql
-917_world.sql
-919_world.sql
-927_characters.sql
-930_characters.sql
-933_world_scripts.sql
-935_world_scripts.sql
-940_world_scripts.sql
-945_world_scripts.sql
-947_world_scripts.sql
-948_world_scripts.sql
-950_world_scripts.sql
-951_world_scripts.sql
-952_world_scripts.sql
-953_world_scripts.sql
-954_world_scripts.sql
-955_world_scripts.sql
-956_world_scripts.sql
-957_world_scripts.sql
-963_world_scripts.sql
-965_world_scripts.sql
-966_world_scripts.sql
-970_world_scripts.sql
-973_world_scripts.sql
-1018_world.sql
-1026_world.sql
-1028_world_scripts.sql
-1069_world_scripts.sql
-1073_world_scripts.sql
-1074_world_scripts.sql
-1138_world.sql
-1142_world.sql
-1159_world.sql
-1160_world.sql
-1164_characters.sql
-DESTINATION share/trinity/sql/updates/2.4.3_updates)
\ No newline at end of file
+${_SQL_243}
+DESTINATION share/trinity/sql/updates/2.4.3_updates)
diff --git a/sql/updates/CMakeLists.txt b/sql/updates/CMakeLists.txt
index 3318d59537e..2300dd5c5f3 100644
--- a/sql/updates/CMakeLists.txt
+++ b/sql/updates/CMakeLists.txt
@@ -1,98 +1,7 @@
 add_subdirectory(2.4.3_updates)
 
+FILE(GLOB _SQL_UPDATES *.sql)
+
 INSTALL(FILES
-805_world_scripts.sql
-875_mangos_7047_01_characters_character_spell.sql
-875_mangos_7059_01_characters_pet_spell.sql
-1026_mangos_7113_01_characters_character_achievement_progress.sql
-1028_mangos_7141_01_world_instance_template.sql
-1028_mangos_7147_01_world_creature_template.sql
-1028_mangos_7150_01_world_playercreateinfo_spell.sql
-1084_mangos_7168_01_world_command.sql
-1094_mangos_7193_01_world_trinity_string.sql
-1108_mangos_7196_02_world_spell_bonus_data.sql
-1108_mangos_7198_01_characters_characters.sql
-1108_mangos_7199_01_world_spell_bonus_data.sql
-1135_mangos_7207_01_world_creature.sql
-1135_mangos_7207_02_world_gameobject.sql
-1135_mangos_7207_03_characters_corpse.sql
-1140_mangos_7209_01_world_spell_bonus_data.sql
-1185_mangos_7214_01_world_command.sql
-1185_mangos_7214_02_world_trinity_string.sql
-1185_mangos_7214_03_world_spell_proc_event.sql
-1206_world_scripts.sql
-1207_world_scripts.sql
-1237_mangos_7230_01_world_spell_bonus_data.sql
-1248_mangos_7235_01_world_command.sql
-1288_mangos_7242_01_world_spell_bonus_data.sql
-1293_mangos_7249_01_world_spell_proc_event.sql
-1296_mangos_7252_01_world_command.sql
-1296_mangos_7252_02_world_trinity_string.sql
-1299_mangos_7255_01_characters_characters.sql
-1307_world.sql
-1312_world.sql
-1327_world.sql
-1351_world.sql
-1396_mangos_7267_01_characters_auctionhouse.sql
-1414_world_scripts.sql
-1423_mangos_7290_01_world_command.sql
-1426_mangos_7292_01_world_points_of_interest.sql
-1426_mangos_7292_02_world_locales_points_of_interest.sql
-1463_mangos_7303_01_world_pools.sql
-1470_world_scripts.sql
-1484_mangos_7307_01_characters_arena_team_member.sql
-1495_mangos_7312_01_world_trinity_string.sql
-1497_mangos_7314_01_characters_guild_rank.sql
-1525_world_scripts.sql
-1531_mangos_7324_01_characters_character_spell.sql
-1531_mangos_7324_02_characters_character_aura.sql
-1555_mangos_7331_01_world_command.sql
-1558_world.sql
-1559_world.sql
-1576_mangos_7332_01_world_command.sql
-1605_mangos_7349_01_world_spell_area.sql
-1613_world_scripts.sql
-1614_characters_auctionhouse.sql
-1618_world.sql
-1646_mangos_7369_01_world_quest_template.sql
-1654_world.sql
-1657_world.sql
-1661_world.sql
-1663_mangos_7376_01_world_spell_area.sql
-1688_mangos_7382_01_world_creature_template.sql
-1693_world.sql
-1694_world.sql
-1697_mangos_7388_01_world_trinity_string.sql
-1703_world.sql
-1709_mangos_7393_01_world_game_event.sql
-1724_mangos_7399_01_world_trinity_string.sql
-1727_world.sql
-1727_world_script.sql
-1729_world.sql
-1730_world.sql
-1732_world.sql
-1755_world.sql
-1764_world.sql
-1766_world.sql
-1791_mangos_7422_01_world_trinity_string.sql
-1814_world.sql
-1825_world.sql
-1828_world.sql
-1877_mangos_7439_01_world_trinity_string.sql
-1884_world.sql
-1886_world.sql
-1911_world.sql
-1912_world.sql
-1927_world.sql
-1939_word.sql
-1957_word.sql
-1962_mangos_7472_01_world_trinity_string.sql
-2013_world.sql
-2021_world.sql
-2025_mangos_7493_01_world_command.sql
-2025_mangos_7495_01_world_trinity_string.sql
-2031_realmd.sql
-2057_world.sql
-2064_world.sql
-2080_mangos_7503_01_world_command.sql
-DESTINATION share/trinity/sql/updates)
\ No newline at end of file
+${_SQL_UPDATES}
+DESTINATION share/trinity/sql/updates)