TDB 720.00 - 2016/04/18TDB720.00

16 files changed, 4 insertions, 53 deletions

diff --git a/sql/updates/auth/master/2016_10_17_00_auth.sql b/sql/updates/auth/master/2016_10_17_00_auth.sql
deleted file mode 100644
index 4e3ed5809bf..00000000000
--- a/sql/updates/auth/master/2016_10_17_00_auth.sql
+++ /dev/null
@@ -1 +0,0 @@
-UPDATE `updates` SET `state`='ARCHIVED'; -- TDB 703.00
diff --git a/sql/updates/auth/master/2016_10_25_00_auth.sql b/sql/updates/auth/master/2016_10_25_00_auth.sql
deleted file mode 100644
index b9e0e5abd3a..00000000000
--- a/sql/updates/auth/master/2016_10_25_00_auth.sql
+++ /dev/null
@@ -1,3 +0,0 @@
-UPDATE `realmlist` SET `gamebuild`=22900 WHERE `gamebuild`=22810;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int(10) unsigned NOT NULL DEFAULT '22900';
diff --git a/sql/updates/auth/master/2016_10_28_00_auth.sql b/sql/updates/auth/master/2016_10_28_00_auth.sql
deleted file mode 100644
index 9e877092c44..00000000000
--- a/sql/updates/auth/master/2016_10_28_00_auth.sql
+++ /dev/null
@@ -1,3 +0,0 @@
-UPDATE `realmlist` SET `gamebuild`=22908 WHERE `gamebuild`=22900;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int(10) unsigned NOT NULL DEFAULT '22908';
diff --git a/sql/updates/auth/master/2016_11_04_00_auth.sql b/sql/updates/auth/master/2016_11_04_00_auth.sql
deleted file mode 100644
index 438f5307af5..00000000000
--- a/sql/updates/auth/master/2016_11_04_00_auth.sql
+++ /dev/null
@@ -1,3 +0,0 @@
-UPDATE `realmlist` SET `gamebuild`=22950 WHERE `gamebuild`=22908;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int(10) unsigned NOT NULL DEFAULT '22950';
diff --git a/sql/updates/auth/master/2016_11_09_00_auth.sql b/sql/updates/auth/master/2016_11_09_00_auth.sql
deleted file mode 100644
index c2fc4825f09..00000000000
--- a/sql/updates/auth/master/2016_11_09_00_auth.sql
+++ /dev/null
@@ -1,3 +0,0 @@
-UPDATE `realmlist` SET `gamebuild`=22995 WHERE `gamebuild`=22950;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int(10) unsigned NOT NULL DEFAULT '22995';
diff --git a/sql/updates/auth/master/2016_11_17_00_auth.sql b/sql/updates/auth/master/2016_11_17_00_auth.sql
deleted file mode 100644
index 69d7c5b42f2..00000000000
--- a/sql/updates/auth/master/2016_11_17_00_auth.sql
+++ /dev/null
@@ -1,3 +0,0 @@
-UPDATE `realmlist` SET `gamebuild`=22996 WHERE `gamebuild`=22995;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int(10) unsigned NOT NULL DEFAULT '22996';
diff --git a/sql/updates/auth/master/2016_12_04_00_auth.sql b/sql/updates/auth/master/2016_12_04_00_auth.sql
deleted file mode 100644
index 2d697e7f293..00000000000
--- a/sql/updates/auth/master/2016_12_04_00_auth.sql
+++ /dev/null
@@ -1,3 +0,0 @@
-UPDATE `realmlist` SET `gamebuild`=23171 WHERE `gamebuild`=22996;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int(10) unsigned NOT NULL DEFAULT '23171';
diff --git a/sql/updates/auth/master/2016_12_11_00_auth.sql b/sql/updates/auth/master/2016_12_11_00_auth.sql
deleted file mode 100644
index cca5e6db8b6..00000000000
--- a/sql/updates/auth/master/2016_12_11_00_auth.sql
+++ /dev/null
@@ -1,3 +0,0 @@
-UPDATE `realmlist` SET `gamebuild`=23222 WHERE `gamebuild`=23171;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int(10) unsigned NOT NULL DEFAULT '23222';
diff --git a/sql/updates/auth/master/2016_12_18_00_auth.sql b/sql/updates/auth/master/2016_12_18_00_auth.sql
deleted file mode 100644
index 2a513fcd146..00000000000
--- a/sql/updates/auth/master/2016_12_18_00_auth.sql
+++ /dev/null
@@ -1,7 +0,0 @@
-DELETE FROM `rbac_permissions` WHERE `id`=830;
-INSERT INTO `rbac_permissions` (`id`,`name`) VALUES
-(830,'Command: .bnetaccount listgameaccounts');
-
-DELETE FROM `rbac_linked_permissions` WHERE `id`=196 AND `linkedId`=830;
-INSERT INTO `rbac_linked_permissions` (`id`, `linkedId`) VALUES
-(196, 830);
diff --git a/sql/updates/auth/master/2017_01_14_00_auth.sql b/sql/updates/auth/master/2017_01_14_00_auth.sql
deleted file mode 100644
index 910c1ae3c90..00000000000
--- a/sql/updates/auth/master/2017_01_14_00_auth.sql
+++ /dev/null
@@ -1,3 +0,0 @@
-UPDATE `realmlist` SET `gamebuild`=23360 WHERE `gamebuild`=23222;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int(10) unsigned NOT NULL DEFAULT '23360';
diff --git a/sql/updates/auth/master/2017_01_26_00_auth.sql b/sql/updates/auth/master/2017_01_26_00_auth.sql
deleted file mode 100644
index 4d9bd155040..00000000000
--- a/sql/updates/auth/master/2017_01_26_00_auth.sql
+++ /dev/null
@@ -1,3 +0,0 @@
-UPDATE `realmlist` SET `gamebuild`=23420 WHERE `gamebuild`=23360;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int(10) unsigned NOT NULL DEFAULT '23420';
diff --git a/sql/updates/auth/master/2017_01_29_00_auth.sql b/sql/updates/auth/master/2017_01_29_00_auth.sql
deleted file mode 100644
index 53397d5d880..00000000000
--- a/sql/updates/auth/master/2017_01_29_00_auth.sql
+++ /dev/null
@@ -1,9 +0,0 @@
-SET @PERMISSION := 851;
-
-DELETE FROM `rbac_permissions` WHERE `id` = @PERMISSION;
-INSERT INTO `rbac_permissions` (`id`, `name`) VALUES
-(@PERMISSION, 'Command: reload areatrigger_templates' );
-
-DELETE FROM `rbac_linked_permissions` WHERE `id` = 192 AND `linkedId` = @PERMISSION;
-INSERT INTO `rbac_linked_permissions` (`id`, `linkedId`) VALUES
-(192, @PERMISSION);
diff --git a/sql/updates/auth/master/2017_03_11_00_auth.sql b/sql/updates/auth/master/2017_03_11_00_auth.sql
deleted file mode 100644
index 4d158f5ed8f..00000000000
--- a/sql/updates/auth/master/2017_03_11_00_auth.sql
+++ /dev/null
@@ -1,5 +0,0 @@
-UPDATE `rbac_permissions` SET `name`='Command: event info' WHERE  `id`=367;
-DELETE FROM `rbac_permissions` WHERE `id` = 852;
-INSERT INTO `rbac_permissions` (`id`, `name`) VALUES (852, 'Command: go offset');
-DELETE FROM `rbac_linked_permissions` WHERE `id` = 198 AND `linkedId` = 852;
-INSERT INTO `rbac_linked_permissions` (`id`, `linkedId`) VALUES (198, 852);
diff --git a/sql/updates/auth/master/2017_03_17_00_auth.sql b/sql/updates/auth/master/2017_03_17_00_auth.sql
deleted file mode 100644
index 3c0f547fcbe..00000000000
--- a/sql/updates/auth/master/2017_03_17_00_auth.sql
+++ /dev/null
@@ -1 +0,0 @@
-UPDATE rbac_permissions SET `name` = 'Skip character creation death knight min level check' WHERE id = 18;
diff --git a/sql/updates/auth/master/2017_04_17_00_auth.sql b/sql/updates/auth/master/2017_04_17_00_auth.sql
deleted file mode 100644
index f4f5af9acec..00000000000
--- a/sql/updates/auth/master/2017_04_17_00_auth.sql
+++ /dev/null
@@ -1,3 +0,0 @@
-UPDATE `realmlist` SET `gamebuild`=23911 WHERE `gamebuild`=23420;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int(10) unsigned NOT NULL DEFAULT '23911';
diff --git a/sql/updates/auth/master/2017_04_19_00_auth.sql b/sql/updates/auth/master/2017_04_19_00_auth.sql
new file mode 100644
index 00000000000..cc9e3b957a9
--- /dev/null
+++ b/sql/updates/auth/master/2017_04_19_00_auth.sql
@@ -0,0 +1,4 @@
+-- TDB 720.00 auth
+DELETE FROM `updates_include` WHERE `path`='$/sql/old/7/auth';
+INSERT INTO `updates_include` (`path`, `state`) VALUES ('$/sql/old/7/auth', 'ARCHIVED');
+UPDATE `updates` SET `state`='ARCHIVED';