TDB 735.00 - 2018/02/19TDB735.00

19 files changed, 2 insertions, 88 deletions

diff --git a/sql/updates/auth/master/2017_04_19_00_auth.sql b/sql/updates/auth/master/2017_04_19_00_auth.sql
deleted file mode 100644
index cc9e3b957a9..00000000000
--- a/sql/updates/auth/master/2017_04_19_00_auth.sql
+++ /dev/null
@@ -1,4 +0,0 @@
--- 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';
diff --git a/sql/updates/auth/master/2017_04_22_00_auth.sql b/sql/updates/auth/master/2017_04_22_00_auth.sql
deleted file mode 100644
index ef99165e22c..00000000000
--- a/sql/updates/auth/master/2017_04_22_00_auth.sql
+++ /dev/null
@@ -1,3 +0,0 @@
-UPDATE `realmlist` SET `gamebuild`=23937 WHERE `gamebuild`=23911;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int(10) unsigned NOT NULL DEFAULT '23937';
diff --git a/sql/updates/auth/master/2017_04_27_00_auth.sql b/sql/updates/auth/master/2017_04_27_00_auth.sql
deleted file mode 100644
index 583a282abdf..00000000000
--- a/sql/updates/auth/master/2017_04_27_00_auth.sql
+++ /dev/null
@@ -1,3 +0,0 @@
-UPDATE `realmlist` SET `gamebuild`=24015 WHERE `gamebuild`=23937;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int(10) unsigned NOT NULL DEFAULT '24015';
diff --git a/sql/updates/auth/master/2017_05_14_00_auth.sql b/sql/updates/auth/master/2017_05_14_00_auth.sql
deleted file mode 100644
index 792ba10bc06..00000000000
--- a/sql/updates/auth/master/2017_05_14_00_auth.sql
+++ /dev/null
@@ -1,9 +0,0 @@
-DELETE FROM `rbac_permissions` WHERE `id` IN (853, 854);
-INSERT INTO `rbac_permissions` (`id`, `name`) VALUES
-(853, 'Command: .reload conversation_template'),
-(854, 'Command: .debug conversation');
-
-DELETE FROM `rbac_linked_permissions` WHERE `id` = 192 AND `linkedId` IN (853, 854);
-INSERT INTO `rbac_linked_permissions` (`id`, `linkedId`) VALUES
-(192, 853),
-(192, 854);
diff --git a/sql/updates/auth/master/2017_06_15_00_auth.sql b/sql/updates/auth/master/2017_06_15_00_auth.sql
deleted file mode 100644
index 6adc6f59653..00000000000
--- a/sql/updates/auth/master/2017_06_15_00_auth.sql
+++ /dev/null
@@ -1,3 +0,0 @@
-UPDATE `realmlist` SET `gamebuild`=24330 WHERE `gamebuild`=24015;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int(10) unsigned NOT NULL DEFAULT '24330';
diff --git a/sql/updates/auth/master/2017_06_18_00_auth.sql b/sql/updates/auth/master/2017_06_18_00_auth.sql
deleted file mode 100644
index 08a8926053f..00000000000
--- a/sql/updates/auth/master/2017_06_18_00_auth.sql
+++ /dev/null
@@ -1,3 +0,0 @@
-UPDATE `realmlist` SET `gamebuild`=24367 WHERE `gamebuild`=24330;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int(10) unsigned NOT NULL DEFAULT '24367';
diff --git a/sql/updates/auth/master/2017_06_25_00_auth.sql b/sql/updates/auth/master/2017_06_25_00_auth.sql
deleted file mode 100644
index 8df778b89a4..00000000000
--- a/sql/updates/auth/master/2017_06_25_00_auth.sql
+++ /dev/null
@@ -1,3 +0,0 @@
-UPDATE `realmlist` SET `gamebuild`=24415 WHERE `gamebuild`=24367;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int(10) unsigned NOT NULL DEFAULT '24415';
diff --git a/sql/updates/auth/master/2017_06_28_00_auth.sql b/sql/updates/auth/master/2017_06_28_00_auth.sql
deleted file mode 100644
index 9924b951cb1..00000000000
--- a/sql/updates/auth/master/2017_06_28_00_auth.sql
+++ /dev/null
@@ -1,3 +0,0 @@
-UPDATE `realmlist` SET `gamebuild`=24430 WHERE `gamebuild`=24415;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int(10) unsigned NOT NULL DEFAULT '24430';
diff --git a/sql/updates/auth/master/2017_06_30_00_auth.sql b/sql/updates/auth/master/2017_06_30_00_auth.sql
deleted file mode 100644
index 30ba5433ec7..00000000000
--- a/sql/updates/auth/master/2017_06_30_00_auth.sql
+++ /dev/null
@@ -1,3 +0,0 @@
-UPDATE `realmlist` SET `gamebuild`=24461 WHERE `gamebuild`=24430;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int(10) unsigned NOT NULL DEFAULT '24461';
diff --git a/sql/updates/auth/master/2017_08_04_00_auth.sql b/sql/updates/auth/master/2017_08_04_00_auth.sql
deleted file mode 100644
index 90e1647b6e1..00000000000
--- a/sql/updates/auth/master/2017_08_04_00_auth.sql
+++ /dev/null
@@ -1,3 +0,0 @@
-UPDATE `realmlist` SET `gamebuild`=24742 WHERE `gamebuild`=24461;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int(10) unsigned NOT NULL DEFAULT '24742';
diff --git a/sql/updates/auth/master/2017_08_13_00_auth_2016_09_22_00_auth.sql b/sql/updates/auth/master/2017_08_13_00_auth_2016_09_22_00_auth.sql
deleted file mode 100644
index 324bd800ad2..00000000000
--- a/sql/updates/auth/master/2017_08_13_00_auth_2016_09_22_00_auth.sql
+++ /dev/null
@@ -1 +0,0 @@
-DELETE FROM `rbac_permissions` WHERE `id` = 698;
diff --git a/sql/updates/auth/master/2017_09_22_00_auth.sql b/sql/updates/auth/master/2017_09_22_00_auth.sql
deleted file mode 100644
index 1b2fe2850a3..00000000000
--- a/sql/updates/auth/master/2017_09_22_00_auth.sql
+++ /dev/null
@@ -1,3 +0,0 @@
-ALTER TABLE `battlenet_accounts`
-  ADD `LoginTicket` varchar(64),
-  ADD `LoginTicketExpiry` int(10) unsigned;
diff --git a/sql/updates/auth/master/2017_11_11_01_auth.sql b/sql/updates/auth/master/2017_11_11_01_auth.sql
deleted file mode 100644
index e046cca6bdc..00000000000
--- a/sql/updates/auth/master/2017_11_11_01_auth.sql
+++ /dev/null
@@ -1,7 +0,0 @@
---
-DELETE FROM `rbac_permissions` WHERE `id`=867;
-INSERT INTO `rbac_permissions` (`id`, `name`) VALUES
-(867, 'Command: modify power');
-
-DELETE FROM `rbac_linked_permissions` WHERE `id`=198 AND `linkedId`=867;
-INSERT INTO `rbac_linked_permissions` (`id`, `linkedId`) VALUES (198, 867);
diff --git a/sql/updates/auth/master/2017_12_30_00_auth.sql b/sql/updates/auth/master/2017_12_30_00_auth.sql
deleted file mode 100644
index 5939777034f..00000000000
--- a/sql/updates/auth/master/2017_12_30_00_auth.sql
+++ /dev/null
@@ -1,5 +0,0 @@
-ALTER TABLE `account` CHANGE `sessionkey` `sessionkey` varchar(128) NOT NULL DEFAULT '';
-
-UPDATE `realmlist` SET `gamebuild`=25549 WHERE `gamebuild`=24742;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int(10) unsigned NOT NULL DEFAULT '25549';
diff --git a/sql/updates/auth/master/2017_12_30_01_auth.sql b/sql/updates/auth/master/2017_12_30_01_auth.sql
deleted file mode 100644
index b1c9a297968..00000000000
--- a/sql/updates/auth/master/2017_12_30_01_auth.sql
+++ /dev/null
@@ -1,11 +0,0 @@
---
-DELETE FROM `rbac_linked_permissions` WHERE `id`=198 AND `linkedId`=867;
-DELETE FROM `rbac_permissions` WHERE `id`=867;
---
-DELETE FROM `rbac_linked_permissions` WHERE `id`=198 AND `linkedId`=868;
-DELETE FROM `rbac_permissions` WHERE `id`=868;
-INSERT INTO `rbac_permissions` (`id`, `name`) VALUES
-(868, 'Command: modify power');
-
-INSERT INTO `rbac_linked_permissions` (`id`, `linkedId`) VALUES
-(198, 868);
diff --git a/sql/updates/auth/master/2017_12_31_00_auth.sql b/sql/updates/auth/master/2017_12_31_00_auth.sql
deleted file mode 100644
index 7348c426b5f..00000000000
--- a/sql/updates/auth/master/2017_12_31_00_auth.sql
+++ /dev/null
@@ -1,7 +0,0 @@
-DELETE FROM `rbac_permissions` WHERE `id`=869;
-INSERT INTO `rbac_permissions` (`id`,`name`) VALUES
-(869,'Command: debug send playerchoice');
-
-DELETE FROM `rbac_linked_permissions` WHERE `linkedId`=869;
-INSERT INTO `rbac_linked_permissions` (`id`,`linkedId`) VALUES
-(196,869);
diff --git a/sql/updates/auth/master/2018_01_02_00_auth.sql b/sql/updates/auth/master/2018_01_02_00_auth.sql
deleted file mode 100644
index 891380c76be..00000000000
--- a/sql/updates/auth/master/2018_01_02_00_auth.sql
+++ /dev/null
@@ -1,14 +0,0 @@
-SET @sql_mode = @@session.sql_mode;
-SET SESSION sql_mode = '';
-
-ALTER TABLE `account`
-  CHANGE `last_login` `last_login` TIMESTAMP NULL;
-
-UPDATE `account` SET `last_login`=NULL WHERE `last_login`='0000-00-00 00:00:00';
-
-ALTER TABLE `battlenet_accounts`
-  CHANGE `last_login` `last_login` TIMESTAMP NULL;
-
-UPDATE `battlenet_accounts` SET `last_login`=NULL WHERE `last_login`='0000-00-00 00:00:00';
-
-SET SESSION sql_mode = @@sql_mode;
diff --git a/sql/updates/auth/master/2018_02_18_00_auth.sql b/sql/updates/auth/master/2018_02_18_00_auth.sql
deleted file mode 100644
index 4e3f05cc5af..00000000000
--- a/sql/updates/auth/master/2018_02_18_00_auth.sql
+++ /dev/null
@@ -1,3 +0,0 @@
-UPDATE `realmlist` SET `gamebuild`=25996 WHERE `gamebuild`=25549;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int(10) unsigned NOT NULL DEFAULT '25996';
diff --git a/sql/updates/auth/master/2018_02_19_00_auth.sql b/sql/updates/auth/master/2018_02_19_00_auth.sql
new file mode 100644
index 00000000000..ff96110bac2
--- /dev/null
+++ b/sql/updates/auth/master/2018_02_19_00_auth.sql
@@ -0,0 +1,2 @@
+-- TDB 735.00 auth
+UPDATE `updates` SET `state`='ARCHIVED';