TDB 6.03 - 2015/11/08TDB6.03

12 files changed, 1 insertions, 67 deletions

diff --git a/sql/updates/auth/2015_07_16_00_auth.sql b/sql/updates/auth/2015_07_16_00_auth.sql
deleted file mode 100644
index 6ab58a4ed40..00000000000
--- a/sql/updates/auth/2015_07_16_00_auth.sql
+++ /dev/null
@@ -1 +0,0 @@
-UPDATE `battlenet_components` SET `Build`=20253 WHERE `Program`='WoW' AND `Platform` IN ('Mc64','Win','Wn64') AND `Build`=20216;
diff --git a/sql/updates/auth/2015_07_29_00_auth.sql b/sql/updates/auth/2015_07_29_00_auth.sql
deleted file mode 100644
index f52cdee6f52..00000000000
--- a/sql/updates/auth/2015_07_29_00_auth.sql
+++ /dev/null
@@ -1 +0,0 @@
-UPDATE `battlenet_components` SET `Build`=20338 WHERE `Program`='WoW' AND `Platform` IN ('Mc64','Win','Wn64') AND `Build`=20253;
diff --git a/sql/updates/auth/2015_08_26_00_auth.sql b/sql/updates/auth/2015_08_26_00_auth.sql
deleted file mode 100644
index e01f9c50a24..00000000000
--- a/sql/updates/auth/2015_08_26_00_auth.sql
+++ /dev/null
@@ -1,8 +0,0 @@
-DROP TABLE IF EXISTS `battlenet_account_toys`;
-
-CREATE TABLE `battlenet_account_toys` (
-  `accountId` int(10) unsigned NOT NULL,
-  `itemId` int(11) NOT NULL DEFAULT '0',
-  `isFavourite` tinyint(1) DEFAULT '0',
-  PRIMARY KEY (`accountId`,`itemId`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;
diff --git a/sql/updates/auth/2015_09_05_00_auth.sql b/sql/updates/auth/2015_09_05_00_auth.sql
deleted file mode 100644
index d6858d8a6d4..00000000000
--- a/sql/updates/auth/2015_09_05_00_auth.sql
+++ /dev/null
@@ -1,2 +0,0 @@
-UPDATE `battlenet_components` SET `Build`=20444 WHERE `Program`='WoW' AND `Platform` IN ('Mc64','Win','Wn64') AND `Build`=20444;
-UPDATE `realmlist` SET `gamebuild`=20444 WHERE `gamebuild`=20182;
diff --git a/sql/updates/auth/2015_09_05_01_auth.sql b/sql/updates/auth/2015_09_05_01_auth.sql
deleted file mode 100644
index bac1e817dc1..00000000000
--- a/sql/updates/auth/2015_09_05_01_auth.sql
+++ /dev/null
@@ -1,2 +0,0 @@
-UPDATE `battlenet_components` SET `Build`=20444 WHERE `Program`='WoW' AND `Platform`='base' AND `Build`=20182;
-UPDATE `battlenet_components` SET `Build`=20444 WHERE `Program`='WoW' AND `Platform` IN ('Mc64','Win','Wn64') AND `Build`=20338;
diff --git a/sql/updates/auth/2015_09_09_00_auth.sql b/sql/updates/auth/2015_09_09_00_auth.sql
deleted file mode 100644
index ccb5d97cf4a..00000000000
--- a/sql/updates/auth/2015_09_09_00_auth.sql
+++ /dev/null
@@ -1,31 +0,0 @@
---
--- Table structure for table `battle_pets`
---
-
-DROP TABLE IF EXISTS `battle_pets`;
-CREATE TABLE `battle_pets` (
-  `guid` bigint(20) NOT NULL,
-  `battlenetAccountId` int(10) NOT NULL,
-  `species` int(10) NOT NULL,
-  `breed` smallint(5) NOT NULL,
-  `level` smallint(5) NOT NULL DEFAULT '1',
-  `exp` smallint(5) NOT NULL DEFAULT '0',
-  `health` int(10) NOT NULL DEFAULT '1',
-  `quality` tinyint(3) NOT NULL DEFAULT '0',
-  `flags` smallint(5) NOT NULL DEFAULT '0',
-  `name` varchar(12) NOT NULL,
-  PRIMARY KEY (`guid`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-
---
--- Table structure for table `battle_pet_slots`
---
-
-DROP TABLE IF EXISTS `battle_pet_slots`;
-CREATE TABLE `battle_pet_slots` (
-  `id` tinyint(3) NOT NULL,
-  `battlenetAccountId` int(10) NOT NULL,
-  `battlePetGuid` bigint(20) NOT NULL,
-  `locked` tinyint(3) NOT NULL DEFAULT '1',
-  PRIMARY KEY (`id`,`battlenetAccountId`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
diff --git a/sql/updates/auth/2015_09_15_00_auth.sql b/sql/updates/auth/2015_09_15_00_auth.sql
deleted file mode 100644
index 0e84db63361..00000000000
--- a/sql/updates/auth/2015_09_15_00_auth.sql
+++ /dev/null
@@ -1,4 +0,0 @@
-UPDATE `battlenet_components` SET `Build`=20490 WHERE `Program`='WoW' AND `Platform`='base' AND `Build`=20444;
-UPDATE `battlenet_components` SET `Build`=20490 WHERE `Program`='WoW' AND `Platform` IN ('Mc64','Win','Wn64') AND `Build`=20444;
-
-UPDATE `realmlist` SET `gamebuild`=20490 WHERE `gamebuild`=20444;
diff --git a/sql/updates/auth/2015_10_09_00_auth.sql b/sql/updates/auth/2015_10_09_00_auth.sql
deleted file mode 100644
index 4b7509f4a44..00000000000
--- a/sql/updates/auth/2015_10_09_00_auth.sql
+++ /dev/null
@@ -1,4 +0,0 @@
-UPDATE `battlenet_components` SET `Build`=20574 WHERE `Program`='WoW' AND `Platform`='base' AND `Build`=20490;
-UPDATE `battlenet_components` SET `Build`=20574 WHERE `Program`='WoW' AND `Platform` IN ('Mc64','Win','Wn64') AND `Build`=20490;
-
-UPDATE `realmlist` SET `gamebuild`=20574 WHERE `gamebuild`=20490;
diff --git a/sql/updates/auth/2015_10_16_00_auth.sql b/sql/updates/auth/2015_10_16_00_auth.sql
deleted file mode 100644
index 1efefca6c9a..00000000000
--- a/sql/updates/auth/2015_10_16_00_auth.sql
+++ /dev/null
@@ -1,8 +0,0 @@
-DROP TABLE IF EXISTS `battlenet_account_heirlooms`;
-
-CREATE TABLE `battlenet_account_heirlooms` (
-  `accountId` int(10) unsigned NOT NULL,
-  `itemId` int(11) unsigned NOT NULL DEFAULT '0',
-  `flags` int(10) unsigned NOT NULL DEFAULT '0',
-  PRIMARY KEY (`accountId`,`itemId`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
diff --git a/sql/updates/auth/2015_10_17_00_auth.sql b/sql/updates/auth/2015_10_17_00_auth.sql
deleted file mode 100644
index 504a0aa1450..00000000000
--- a/sql/updates/auth/2015_10_17_00_auth.sql
+++ /dev/null
@@ -1 +0,0 @@
-ALTER TABLE `battlenet_account_toys` ENGINE=InnoDB;
diff --git a/sql/updates/auth/2015_11_01_00_auth_2015_08_21_00.sql b/sql/updates/auth/2015_11_01_00_auth_2015_08_21_00.sql
deleted file mode 100644
index f4396cc68c0..00000000000
--- a/sql/updates/auth/2015_11_01_00_auth_2015_08_21_00.sql
+++ /dev/null
@@ -1,5 +0,0 @@
-DELETE FROM `rbac_permissions` WHERE `id` = 835;
-INSERT INTO `rbac_permissions` (`id`, `name`) VALUES (835, 'Command: debug loadcells');
-
-DELETE FROM `rbac_linked_permissions` WHERE `id` = 192 AND `linkedId` = 835;
-INSERT INTO `rbac_linked_permissions` (`id`, `linkedId`) VALUES (192, 835);
diff --git a/sql/updates/auth/2015_11_08_00_auth.sql b/sql/updates/auth/2015_11_08_00_auth.sql
new file mode 100644
index 00000000000..be8a4d21b66
--- /dev/null
+++ b/sql/updates/auth/2015_11_08_00_auth.sql
@@ -0,0 +1 @@
+UPDATE `updates` SET `state`='ARCHIVED';