TDB 6.03 - 2015/11/08TDB6.03

11 files changed, 67 insertions, 0 deletions

diff --git a/sql/old/6.x/auth/02_2015_11_08/2015_07_16_00_auth.sql b/sql/old/6.x/auth/02_2015_11_08/2015_07_16_00_auth.sql
new file mode 100644
index 00000000000..6ab58a4ed40
--- /dev/null
+++ b/sql/old/6.x/auth/02_2015_11_08/2015_07_16_00_auth.sql
@@ -0,0 +1 @@
+UPDATE `battlenet_components` SET `Build`=20253 WHERE `Program`='WoW' AND `Platform` IN ('Mc64','Win','Wn64') AND `Build`=20216;
diff --git a/sql/old/6.x/auth/02_2015_11_08/2015_07_29_00_auth.sql b/sql/old/6.x/auth/02_2015_11_08/2015_07_29_00_auth.sql
new file mode 100644
index 00000000000..f52cdee6f52
--- /dev/null
+++ b/sql/old/6.x/auth/02_2015_11_08/2015_07_29_00_auth.sql
@@ -0,0 +1 @@
+UPDATE `battlenet_components` SET `Build`=20338 WHERE `Program`='WoW' AND `Platform` IN ('Mc64','Win','Wn64') AND `Build`=20253;
diff --git a/sql/old/6.x/auth/02_2015_11_08/2015_08_26_00_auth.sql b/sql/old/6.x/auth/02_2015_11_08/2015_08_26_00_auth.sql
new file mode 100644
index 00000000000..e01f9c50a24
--- /dev/null
+++ b/sql/old/6.x/auth/02_2015_11_08/2015_08_26_00_auth.sql
@@ -0,0 +1,8 @@
+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/old/6.x/auth/02_2015_11_08/2015_09_05_00_auth.sql b/sql/old/6.x/auth/02_2015_11_08/2015_09_05_00_auth.sql
new file mode 100644
index 00000000000..d6858d8a6d4
--- /dev/null
+++ b/sql/old/6.x/auth/02_2015_11_08/2015_09_05_00_auth.sql
@@ -0,0 +1,2 @@
+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/old/6.x/auth/02_2015_11_08/2015_09_05_01_auth.sql b/sql/old/6.x/auth/02_2015_11_08/2015_09_05_01_auth.sql
new file mode 100644
index 00000000000..bac1e817dc1
--- /dev/null
+++ b/sql/old/6.x/auth/02_2015_11_08/2015_09_05_01_auth.sql
@@ -0,0 +1,2 @@
+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/old/6.x/auth/02_2015_11_08/2015_09_09_00_auth.sql b/sql/old/6.x/auth/02_2015_11_08/2015_09_09_00_auth.sql
new file mode 100644
index 00000000000..ccb5d97cf4a
--- /dev/null
+++ b/sql/old/6.x/auth/02_2015_11_08/2015_09_09_00_auth.sql
@@ -0,0 +1,31 @@
+--
+-- 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/old/6.x/auth/02_2015_11_08/2015_09_15_00_auth.sql b/sql/old/6.x/auth/02_2015_11_08/2015_09_15_00_auth.sql
new file mode 100644
index 00000000000..0e84db63361
--- /dev/null
+++ b/sql/old/6.x/auth/02_2015_11_08/2015_09_15_00_auth.sql
@@ -0,0 +1,4 @@
+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/old/6.x/auth/02_2015_11_08/2015_10_09_00_auth.sql b/sql/old/6.x/auth/02_2015_11_08/2015_10_09_00_auth.sql
new file mode 100644
index 00000000000..4b7509f4a44
--- /dev/null
+++ b/sql/old/6.x/auth/02_2015_11_08/2015_10_09_00_auth.sql
@@ -0,0 +1,4 @@
+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/old/6.x/auth/02_2015_11_08/2015_10_16_00_auth.sql b/sql/old/6.x/auth/02_2015_11_08/2015_10_16_00_auth.sql
new file mode 100644
index 00000000000..1efefca6c9a
--- /dev/null
+++ b/sql/old/6.x/auth/02_2015_11_08/2015_10_16_00_auth.sql
@@ -0,0 +1,8 @@
+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/old/6.x/auth/02_2015_11_08/2015_10_17_00_auth.sql b/sql/old/6.x/auth/02_2015_11_08/2015_10_17_00_auth.sql
new file mode 100644
index 00000000000..504a0aa1450
--- /dev/null
+++ b/sql/old/6.x/auth/02_2015_11_08/2015_10_17_00_auth.sql
@@ -0,0 +1 @@
+ALTER TABLE `battlenet_account_toys` ENGINE=InnoDB;
diff --git a/sql/old/6.x/auth/02_2015_11_08/2015_11_01_00_auth_2015_08_21_00.sql b/sql/old/6.x/auth/02_2015_11_08/2015_11_01_00_auth_2015_08_21_00.sql
new file mode 100644
index 00000000000..f4396cc68c0
--- /dev/null
+++ b/sql/old/6.x/auth/02_2015_11_08/2015_11_01_00_auth_2015_08_21_00.sql
@@ -0,0 +1,5 @@
+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);