TDB 820.19071 - 2019/07/15TDB820.19071

17 files changed, 1 insertions, 50 deletions

diff --git a/sql/updates/auth/master/2018_02_28_00_auth.sql b/sql/updates/auth/master/2018_02_28_00_auth.sql
deleted file mode 100644
index 4b60b7f6868..00000000000
--- a/sql/updates/auth/master/2018_02_28_00_auth.sql
+++ /dev/null
@@ -1,3 +0,0 @@
-UPDATE `realmlist` SET `gamebuild`=26124 WHERE `gamebuild`=25996;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int(10) unsigned NOT NULL DEFAULT '26124';
diff --git a/sql/updates/auth/master/2018_03_14_00_auth.sql b/sql/updates/auth/master/2018_03_14_00_auth.sql
deleted file mode 100644
index ddaf1d13f0c..00000000000
--- a/sql/updates/auth/master/2018_03_14_00_auth.sql
+++ /dev/null
@@ -1,5 +0,0 @@
-DELETE FROM `rbac_permissions` WHERE `id`=872;
-INSERT INTO `rbac_permissions` (`id`, `name`) VALUES
-(872, 'Command: server debug');
-INSERT INTO `rbac_linked_permissions` (`id`, `linkedId`) VALUES
-(196, 872);
diff --git a/sql/updates/auth/master/2018_04_06_00_auth.sql b/sql/updates/auth/master/2018_04_06_00_auth.sql
deleted file mode 100644
index 8edc1a3f13e..00000000000
--- a/sql/updates/auth/master/2018_04_06_00_auth.sql
+++ /dev/null
@@ -1,3 +0,0 @@
-UPDATE `realmlist` SET `gamebuild`=26365 WHERE `gamebuild`=26124;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int(10) unsigned NOT NULL DEFAULT '26365';
diff --git a/sql/updates/auth/master/2018_05_13_00_auth.sql b/sql/updates/auth/master/2018_05_13_00_auth.sql
deleted file mode 100644
index 7df67812d21..00000000000
--- a/sql/updates/auth/master/2018_05_13_00_auth.sql
+++ /dev/null
@@ -1 +0,0 @@
-ALTER TABLE `realmlist` MODIFY `Region` tinyint(3) unsigned NOT NULL DEFAULT '1' AFTER `gamebuild`;
diff --git a/sql/updates/auth/master/2018_05_24_00_auth.sql b/sql/updates/auth/master/2018_05_24_00_auth.sql
deleted file mode 100644
index 6dd771b0afd..00000000000
--- a/sql/updates/auth/master/2018_05_24_00_auth.sql
+++ /dev/null
@@ -1,3 +0,0 @@
-UPDATE `realmlist` SET `gamebuild`=26654 WHERE `gamebuild`=26365;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int(10) unsigned NOT NULL DEFAULT '26654';
diff --git a/sql/updates/auth/master/2018_06_14_00_auth.sql b/sql/updates/auth/master/2018_06_14_00_auth.sql
deleted file mode 100644
index a0d2d4d2d0e..00000000000
--- a/sql/updates/auth/master/2018_06_14_00_auth.sql
+++ /dev/null
@@ -1,3 +0,0 @@
-UPDATE `realmlist` SET `gamebuild`=26822 WHERE `gamebuild`=26654;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int(10) unsigned NOT NULL DEFAULT '26822';
diff --git a/sql/updates/auth/master/2018_06_22_00_auth.sql b/sql/updates/auth/master/2018_06_22_00_auth.sql
deleted file mode 100644
index bb39f9b1671..00000000000
--- a/sql/updates/auth/master/2018_06_22_00_auth.sql
+++ /dev/null
@@ -1,3 +0,0 @@
-UPDATE `realmlist` SET `gamebuild`=26899 WHERE `gamebuild`=26822;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int(10) unsigned NOT NULL DEFAULT '26899';
diff --git a/sql/updates/auth/master/2018_06_23_00_auth.sql b/sql/updates/auth/master/2018_06_23_00_auth.sql
deleted file mode 100644
index 3bbe03f8c19..00000000000
--- a/sql/updates/auth/master/2018_06_23_00_auth.sql
+++ /dev/null
@@ -1,3 +0,0 @@
---
-DROP TABLE IF EXISTS `ip2nation`;
-DROP TABLE IF EXISTS `ip2nationCountries`;
diff --git a/sql/updates/auth/master/2018_06_29_00_auth.sql b/sql/updates/auth/master/2018_06_29_00_auth.sql
deleted file mode 100644
index 821431dde38..00000000000
--- a/sql/updates/auth/master/2018_06_29_00_auth.sql
+++ /dev/null
@@ -1,3 +0,0 @@
-UPDATE `realmlist` SET `gamebuild`=26972 WHERE `gamebuild`=26899;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int(10) unsigned NOT NULL DEFAULT '26972';
diff --git a/sql/updates/auth/master/2018_12_09_00_auth_2017_01_06_00_auth.sql b/sql/updates/auth/master/2018_12_09_00_auth_2017_01_06_00_auth.sql
deleted file mode 100644
index 0def4608ca2..00000000000
--- a/sql/updates/auth/master/2018_12_09_00_auth_2017_01_06_00_auth.sql
+++ /dev/null
@@ -1,5 +0,0 @@
-DELETE FROM `rbac_permissions` WHERE `id`=698;
-INSERT INTO `rbac_permissions` (`id`, `name`) VALUES
-(698, 'Command: character changeaccount');
-INSERT INTO `rbac_linked_permissions` (`id`, `linkedId`) VALUES
-(196, 698);
diff --git a/sql/updates/auth/master/2018_12_09_01_auth.sql b/sql/updates/auth/master/2018_12_09_01_auth.sql
deleted file mode 100644
index ba23941d720..00000000000
--- a/sql/updates/auth/master/2018_12_09_01_auth.sql
+++ /dev/null
@@ -1,7 +0,0 @@
-UPDATE `account` SET `expansion`=7 WHERE `expansion`=6;
-
-ALTER TABLE `account` CHANGE `expansion` `expansion` tinyint(3) unsigned NOT NULL DEFAULT '7';
-
-UPDATE `realmlist` SET `gamebuild`=28153 WHERE `gamebuild`=26972;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int(10) unsigned NOT NULL DEFAULT '28153';
diff --git a/sql/updates/auth/master/2019_06_08_00_auth.sql b/sql/updates/auth/master/2019_06_08_00_auth.sql
deleted file mode 100644
index a979ce76fe6..00000000000
--- a/sql/updates/auth/master/2019_06_08_00_auth.sql
+++ /dev/null
@@ -1 +0,0 @@
-ALTER TABLE `battlenet_account_toys` ADD `hasFanfare` tinyint(1) DEFAULT '0' AFTER `isFavourite`;
diff --git a/sql/updates/auth/master/2019_06_08_01_auth.sql b/sql/updates/auth/master/2019_06_08_01_auth.sql
deleted file mode 100644
index 1c4f66a2567..00000000000
--- a/sql/updates/auth/master/2019_06_08_01_auth.sql
+++ /dev/null
@@ -1,2 +0,0 @@
-DELETE FROM `rbac_linked_permissions` WHERE `linkedId` IN (307,308,313,332,333,334,338,546);
-DELETE FROM `rbac_permissions` WHERE `id` IN (307,308,313,332,333,334,338,546);
diff --git a/sql/updates/auth/master/2019_06_08_02_auth.sql b/sql/updates/auth/master/2019_06_08_02_auth.sql
deleted file mode 100644
index 83d1e41689a..00000000000
--- a/sql/updates/auth/master/2019_06_08_02_auth.sql
+++ /dev/null
@@ -1 +0,0 @@
-UPDATE `rbac_permissions` SET `name`='Command: reload item_random_bonus_list_template' WHERE `id`=653;
diff --git a/sql/updates/auth/master/2019_06_08_03_auth.sql b/sql/updates/auth/master/2019_06_08_03_auth.sql
deleted file mode 100644
index 743be78c441..00000000000
--- a/sql/updates/auth/master/2019_06_08_03_auth.sql
+++ /dev/null
@@ -1,3 +0,0 @@
-UPDATE `realmlist` SET `gamebuild`=30706 WHERE `gamebuild`=28153;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int(10) unsigned NOT NULL DEFAULT '30706';
diff --git a/sql/updates/auth/master/2019_07_14_00_auth.sql b/sql/updates/auth/master/2019_07_14_00_auth.sql
deleted file mode 100644
index d91db1dbbc8..00000000000
--- a/sql/updates/auth/master/2019_07_14_00_auth.sql
+++ /dev/null
@@ -1,3 +0,0 @@
-UPDATE `realmlist` SET `gamebuild`=30993 WHERE `gamebuild`=30706;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int(10) unsigned NOT NULL DEFAULT '30993';
diff --git a/sql/updates/auth/master/2018_02_19_00_auth.sql b/sql/updates/auth/master/2019_07_15_00_auth.sql
index ff96110bac2..ac13241781b 100644
--- a/sql/updates/auth/master/2018_02_19_00_auth.sql
+++ b/sql/updates/auth/master/2019_07_15_00_auth.sql
@@ -1,2 +1,2 @@
--- TDB 735.00 auth
+-- TDB 820.19071 auth
 UPDATE `updates` SET `state`='ARCHIVED';