TDB 720.00 - 2016/04/18TDB720.00

15 files changed, 53 insertions, 0 deletions

diff --git a/sql/old/7/auth/00_2017_04_18/2016_10_17_00_auth.sql b/sql/old/7/auth/00_2017_04_18/2016_10_17_00_auth.sql
new file mode 100644
index 00000000000..4e3ed5809bf
--- /dev/null
+++ b/sql/old/7/auth/00_2017_04_18/2016_10_17_00_auth.sql
@@ -0,0 +1 @@
+UPDATE `updates` SET `state`='ARCHIVED'; -- TDB 703.00
diff --git a/sql/old/7/auth/00_2017_04_18/2016_10_25_00_auth.sql b/sql/old/7/auth/00_2017_04_18/2016_10_25_00_auth.sql
new file mode 100644
index 00000000000..b9e0e5abd3a
--- /dev/null
+++ b/sql/old/7/auth/00_2017_04_18/2016_10_25_00_auth.sql
@@ -0,0 +1,3 @@
+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/old/7/auth/00_2017_04_18/2016_10_28_00_auth.sql b/sql/old/7/auth/00_2017_04_18/2016_10_28_00_auth.sql
new file mode 100644
index 00000000000..9e877092c44
--- /dev/null
+++ b/sql/old/7/auth/00_2017_04_18/2016_10_28_00_auth.sql
@@ -0,0 +1,3 @@
+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/old/7/auth/00_2017_04_18/2016_11_04_00_auth.sql b/sql/old/7/auth/00_2017_04_18/2016_11_04_00_auth.sql
new file mode 100644
index 00000000000..438f5307af5
--- /dev/null
+++ b/sql/old/7/auth/00_2017_04_18/2016_11_04_00_auth.sql
@@ -0,0 +1,3 @@
+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/old/7/auth/00_2017_04_18/2016_11_09_00_auth.sql b/sql/old/7/auth/00_2017_04_18/2016_11_09_00_auth.sql
new file mode 100644
index 00000000000..c2fc4825f09
--- /dev/null
+++ b/sql/old/7/auth/00_2017_04_18/2016_11_09_00_auth.sql
@@ -0,0 +1,3 @@
+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/old/7/auth/00_2017_04_18/2016_11_17_00_auth.sql b/sql/old/7/auth/00_2017_04_18/2016_11_17_00_auth.sql
new file mode 100644
index 00000000000..69d7c5b42f2
--- /dev/null
+++ b/sql/old/7/auth/00_2017_04_18/2016_11_17_00_auth.sql
@@ -0,0 +1,3 @@
+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/old/7/auth/00_2017_04_18/2016_12_04_00_auth.sql b/sql/old/7/auth/00_2017_04_18/2016_12_04_00_auth.sql
new file mode 100644
index 00000000000..2d697e7f293
--- /dev/null
+++ b/sql/old/7/auth/00_2017_04_18/2016_12_04_00_auth.sql
@@ -0,0 +1,3 @@
+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/old/7/auth/00_2017_04_18/2016_12_11_00_auth.sql b/sql/old/7/auth/00_2017_04_18/2016_12_11_00_auth.sql
new file mode 100644
index 00000000000..cca5e6db8b6
--- /dev/null
+++ b/sql/old/7/auth/00_2017_04_18/2016_12_11_00_auth.sql
@@ -0,0 +1,3 @@
+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/old/7/auth/00_2017_04_18/2016_12_18_00_auth.sql b/sql/old/7/auth/00_2017_04_18/2016_12_18_00_auth.sql
new file mode 100644
index 00000000000..2a513fcd146
--- /dev/null
+++ b/sql/old/7/auth/00_2017_04_18/2016_12_18_00_auth.sql
@@ -0,0 +1,7 @@
+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/old/7/auth/00_2017_04_18/2017_01_14_00_auth.sql b/sql/old/7/auth/00_2017_04_18/2017_01_14_00_auth.sql
new file mode 100644
index 00000000000..910c1ae3c90
--- /dev/null
+++ b/sql/old/7/auth/00_2017_04_18/2017_01_14_00_auth.sql
@@ -0,0 +1,3 @@
+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/old/7/auth/00_2017_04_18/2017_01_26_00_auth.sql b/sql/old/7/auth/00_2017_04_18/2017_01_26_00_auth.sql
new file mode 100644
index 00000000000..4d9bd155040
--- /dev/null
+++ b/sql/old/7/auth/00_2017_04_18/2017_01_26_00_auth.sql
@@ -0,0 +1,3 @@
+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/old/7/auth/00_2017_04_18/2017_01_29_00_auth.sql b/sql/old/7/auth/00_2017_04_18/2017_01_29_00_auth.sql
new file mode 100644
index 00000000000..53397d5d880
--- /dev/null
+++ b/sql/old/7/auth/00_2017_04_18/2017_01_29_00_auth.sql
@@ -0,0 +1,9 @@
+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/old/7/auth/00_2017_04_18/2017_03_11_00_auth.sql b/sql/old/7/auth/00_2017_04_18/2017_03_11_00_auth.sql
new file mode 100644
index 00000000000..4d158f5ed8f
--- /dev/null
+++ b/sql/old/7/auth/00_2017_04_18/2017_03_11_00_auth.sql
@@ -0,0 +1,5 @@
+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/old/7/auth/00_2017_04_18/2017_03_17_00_auth.sql b/sql/old/7/auth/00_2017_04_18/2017_03_17_00_auth.sql
new file mode 100644
index 00000000000..3c0f547fcbe
--- /dev/null
+++ b/sql/old/7/auth/00_2017_04_18/2017_03_17_00_auth.sql
@@ -0,0 +1 @@
+UPDATE rbac_permissions SET `name` = 'Skip character creation death knight min level check' WHERE id = 18;
diff --git a/sql/old/7/auth/00_2017_04_18/2017_04_17_00_auth.sql b/sql/old/7/auth/00_2017_04_18/2017_04_17_00_auth.sql
new file mode 100644
index 00000000000..f4f5af9acec
--- /dev/null
+++ b/sql/old/7/auth/00_2017_04_18/2017_04_17_00_auth.sql
@@ -0,0 +1,3 @@
+UPDATE `realmlist` SET `gamebuild`=23911 WHERE `gamebuild`=23420;
+
+ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int(10) unsigned NOT NULL DEFAULT '23911';