SQL: Cleanup WIP sql arrangement

25 files changed, 3 insertions, 0 deletions

diff --git a/sql/updates/auth/2016_xx_xx_xx_auth_legion_00.sql b/sql/updates/auth/6.x/2016_07_19_00_auth.sql
index 5cbb737f518..5cbb737f518 100644
--- a/sql/updates/auth/2016_xx_xx_xx_auth_legion_00.sql
+++ b/sql/updates/auth/6.x/2016_07_19_00_auth.sql
diff --git a/sql/updates/auth/6.x/2016_07_19_01_auth.sql b/sql/updates/auth/6.x/2016_07_19_01_auth.sql
new file mode 100644
index 00000000000..854872a48d0
--- /dev/null
+++ b/sql/updates/auth/6.x/2016_07_19_01_auth.sql
@@ -0,0 +1,3 @@
+UPDATE `realmlist` SET `gamebuild`=22248 WHERE `gamebuild`=21742;
+
+ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int(10) unsigned NOT NULL DEFAULT '22248';
diff --git a/sql/updates/characters/2016_xx_xx_xx_characters_legion_01.sql b/sql/updates/characters/6.x/2016_07_19_00_characters.sql
index 3cc4003e724..3cc4003e724 100644
--- a/sql/updates/characters/2016_xx_xx_xx_characters_legion_01.sql
+++ b/sql/updates/characters/6.x/2016_07_19_00_characters.sql
diff --git a/sql/updates/characters/2016_xx_xx_xx_characters_legion_02.sql b/sql/updates/characters/6.x/2016_07_19_01_characters.sql
index a2a74c11cb2..a2a74c11cb2 100644
--- a/sql/updates/characters/2016_xx_xx_xx_characters_legion_02.sql
+++ b/sql/updates/characters/6.x/2016_07_19_01_characters.sql
diff --git a/sql/updates/characters/2016_xx_xx_xx_characters_legion_03.sql b/sql/updates/characters/6.x/2016_07_19_02_characters.sql
index 03320194c94..03320194c94 100644
--- a/sql/updates/characters/2016_xx_xx_xx_characters_legion_03.sql
+++ b/sql/updates/characters/6.x/2016_07_19_02_characters.sql
diff --git a/sql/updates/characters/2016_xx_xx_xx_characters_legion_04.sql b/sql/updates/characters/6.x/2016_07_19_03_characters.sql
index c231fcff007..c231fcff007 100644
--- a/sql/updates/characters/2016_xx_xx_xx_characters_legion_04.sql
+++ b/sql/updates/characters/6.x/2016_07_19_03_characters.sql
diff --git a/sql/updates/characters/2016_xx_xx_xx_characters_legion_05.sql b/sql/updates/characters/6.x/2016_07_19_04_characters.sql
index ed820fc55df..ed820fc55df 100644
--- a/sql/updates/characters/2016_xx_xx_xx_characters_legion_05.sql
+++ b/sql/updates/characters/6.x/2016_07_19_04_characters.sql
diff --git a/sql/updates/characters/2016_xx_xx_xx_characters_legion_06.sql b/sql/updates/characters/6.x/2016_07_19_05_characters.sql
index 1b6c28cb328..1b6c28cb328 100644
--- a/sql/updates/characters/2016_xx_xx_xx_characters_legion_06.sql
+++ b/sql/updates/characters/6.x/2016_07_19_05_characters.sql
diff --git a/sql/updates/characters/2016_xx_xx_xx_characters_legion_07.sql b/sql/updates/characters/6.x/2016_07_19_06_characters.sql
index 96d45a97a01..96d45a97a01 100644
--- a/sql/updates/characters/2016_xx_xx_xx_characters_legion_07.sql
+++ b/sql/updates/characters/6.x/2016_07_19_06_characters.sql
diff --git a/sql/updates/characters/2016_xx_xx_xx_characters_legion_08.sql b/sql/updates/characters/6.x/2016_07_19_07_characters.sql
index 4efb4172e19..4efb4172e19 100644
--- a/sql/updates/characters/2016_xx_xx_xx_characters_legion_08.sql
+++ b/sql/updates/characters/6.x/2016_07_19_07_characters.sql
diff --git a/sql/updates/characters/2016_xx_xx_xx_characters_legion_09.sql b/sql/updates/characters/6.x/2016_07_19_08_characters.sql
index 993f227ce30..993f227ce30 100644
--- a/sql/updates/characters/2016_xx_xx_xx_characters_legion_09.sql
+++ b/sql/updates/characters/6.x/2016_07_19_08_characters.sql
diff --git a/sql/updates/hotfixes/2016_xx_xx_xx_hotfixes_legion_01.sql b/sql/updates/hotfixes/6.x/2016_07_19_00_hotfixes.sql
index b5a3512b1e1..b5a3512b1e1 100644
--- a/sql/updates/hotfixes/2016_xx_xx_xx_hotfixes_legion_01.sql
+++ b/sql/updates/hotfixes/6.x/2016_07_19_00_hotfixes.sql
diff --git a/sql/updates/hotfixes/2016_xx_xx_xx_hotfixes_legion_02.sql b/sql/updates/hotfixes/6.x/2016_07_19_01_hotfixes.sql
index 3f94f33dc1e..3f94f33dc1e 100644
--- a/sql/updates/hotfixes/2016_xx_xx_xx_hotfixes_legion_02.sql
+++ b/sql/updates/hotfixes/6.x/2016_07_19_01_hotfixes.sql
diff --git a/sql/updates/hotfixes/2016_xx_xx_xx_hotfixes_legion_03.sql b/sql/updates/hotfixes/6.x/2016_07_19_02_hotfixes.sql
index 959b3275e9d..959b3275e9d 100644
--- a/sql/updates/hotfixes/2016_xx_xx_xx_hotfixes_legion_03.sql
+++ b/sql/updates/hotfixes/6.x/2016_07_19_02_hotfixes.sql
diff --git a/sql/updates/hotfixes/2016_xx_xx_xx_hotfixes_legion_04.sql b/sql/updates/hotfixes/6.x/2016_07_19_03_hotfixes.sql
index d8bf16bf9d6..d8bf16bf9d6 100644
--- a/sql/updates/hotfixes/2016_xx_xx_xx_hotfixes_legion_04.sql
+++ b/sql/updates/hotfixes/6.x/2016_07_19_03_hotfixes.sql
diff --git a/sql/updates/hotfixes/2016_xx_xx_xx_hotfixes_legion_05.sql b/sql/updates/hotfixes/6.x/2016_07_19_04_hotfixes.sql
index f165d7f8ae2..f165d7f8ae2 100644
--- a/sql/updates/hotfixes/2016_xx_xx_xx_hotfixes_legion_05.sql
+++ b/sql/updates/hotfixes/6.x/2016_07_19_04_hotfixes.sql
diff --git a/sql/updates/hotfixes/2016_xx_xx_xx_hotfixes_legion_06.sql b/sql/updates/hotfixes/6.x/2016_07_19_05_hotfixes.sql
index bbb0075ac6b..bbb0075ac6b 100644
--- a/sql/updates/hotfixes/2016_xx_xx_xx_hotfixes_legion_06.sql
+++ b/sql/updates/hotfixes/6.x/2016_07_19_05_hotfixes.sql
diff --git a/sql/updates/hotfixes/2016_xx_xx_xx_hotfixes_legion_07.sql b/sql/updates/hotfixes/6.x/2016_07_19_06_hotfixes.sql
index 4d76e75fbf3..4d76e75fbf3 100644
--- a/sql/updates/hotfixes/2016_xx_xx_xx_hotfixes_legion_07.sql
+++ b/sql/updates/hotfixes/6.x/2016_07_19_06_hotfixes.sql
diff --git a/sql/updates/hotfixes/2016_xx_xx_xx_hotfixes_legion_08.sql b/sql/updates/hotfixes/6.x/2016_07_19_07_hotfixes.sql
index 6cce565b905..6cce565b905 100644
--- a/sql/updates/hotfixes/2016_xx_xx_xx_hotfixes_legion_08.sql
+++ b/sql/updates/hotfixes/6.x/2016_07_19_07_hotfixes.sql
diff --git a/sql/updates/hotfixes/2016_xx_xx_xx_hotfixes_legion_09.sql b/sql/updates/hotfixes/6.x/2016_07_19_08_hotfixes.sql
index faa3cabc66e..faa3cabc66e 100644
--- a/sql/updates/hotfixes/2016_xx_xx_xx_hotfixes_legion_09.sql
+++ b/sql/updates/hotfixes/6.x/2016_07_19_08_hotfixes.sql
diff --git a/sql/updates/hotfixes/2016_xx_xx_xx_hotfixes_legion_10.sql b/sql/updates/hotfixes/6.x/2016_07_19_09_hotfixes.sql
index bcd51ae80b9..bcd51ae80b9 100644
--- a/sql/updates/hotfixes/2016_xx_xx_xx_hotfixes_legion_10.sql
+++ b/sql/updates/hotfixes/6.x/2016_07_19_09_hotfixes.sql
diff --git a/sql/updates/hotfixes/2016_xx_xx_xx_hotfixes_legion_11.sql b/sql/updates/hotfixes/6.x/2016_07_19_10_hotfixes.sql
index ac0e9d5a81b..ac0e9d5a81b 100644
--- a/sql/updates/hotfixes/2016_xx_xx_xx_hotfixes_legion_11.sql
+++ b/sql/updates/hotfixes/6.x/2016_07_19_10_hotfixes.sql
diff --git a/sql/updates/hotfixes/2016_xx_xx_xx_hotfixes_legion_12.sql b/sql/updates/hotfixes/6.x/2016_07_19_11_hotfixes.sql
index 1d9354f9d15..1d9354f9d15 100644
--- a/sql/updates/hotfixes/2016_xx_xx_xx_hotfixes_legion_12.sql
+++ b/sql/updates/hotfixes/6.x/2016_07_19_11_hotfixes.sql
diff --git a/sql/updates/world/2016_xx_xx_xx_world_legion_01.sql b/sql/updates/world/6.x/2016_07_19_00_world.sql
index 5614bf76476..5614bf76476 100644
--- a/sql/updates/world/2016_xx_xx_xx_world_legion_01.sql
+++ b/sql/updates/world/6.x/2016_07_19_00_world.sql
diff --git a/sql/updates/world/2016_xx_xx_xx_world_legion_02.sql b/sql/updates/world/6.x/2016_07_19_01_world.sql
index c4b7fca6d19..c4b7fca6d19 100644
--- a/sql/updates/world/2016_xx_xx_xx_world_legion_02.sql
+++ b/sql/updates/world/6.x/2016_07_19_01_world.sql