TDB 6.03 - 2015/11/08TDB6.03

8 files changed, 124 insertions, 0 deletions

diff --git a/sql/old/6.x/characters/02_2015_11_08/2015_07_28_00_characters.sql b/sql/old/6.x/characters/02_2015_11_08/2015_07_28_00_characters.sql
new file mode 100644
index 00000000000..29af7731d19
--- /dev/null
+++ b/sql/old/6.x/characters/02_2015_11_08/2015_07_28_00_characters.sql
@@ -0,0 +1,20 @@
+ALTER TABLE `calendar_invites`
+    CHANGE COLUMN `id` `InviteID` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0' FIRST,
+    CHANGE COLUMN `event` `EventID` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0' AFTER `InviteID`,
+    CHANGE COLUMN `invitee` `Invitee` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0' AFTER `EventID`,
+    CHANGE COLUMN `sender` `Sender` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0' AFTER `Invitee`,
+    CHANGE COLUMN `status` `Status` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0' AFTER `Sender`,
+    CHANGE COLUMN `statustime` `ResponseTime` INT(10) UNSIGNED NOT NULL DEFAULT '0' AFTER `Status`,
+    CHANGE COLUMN `rank` `ModerationRank` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0' AFTER `ResponseTime`,
+    CHANGE COLUMN `text` `Note` VARCHAR(255) NOT NULL DEFAULT '' AFTER `ModerationRank`;
+
+ALTER TABLE `calendar_events`
+    CHANGE COLUMN `id` `EventID` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0' FIRST,
+    CHANGE COLUMN `creator` `Owner` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0' AFTER `EventID`,
+    CHANGE COLUMN `title` `Title` VARCHAR(255) NOT NULL DEFAULT '' AFTER `Owner`,
+    CHANGE COLUMN `description` `Description` VARCHAR(255) NOT NULL DEFAULT '' AFTER `Title`,
+    CHANGE COLUMN `type` `EventType` TINYINT(1) UNSIGNED NOT NULL DEFAULT '4' AFTER `Description`,
+    CHANGE COLUMN `dungeon` `TextureID` INT(10) NOT NULL DEFAULT '-1' AFTER `EventType`,
+    CHANGE COLUMN `eventtime` `Date` INT(10) UNSIGNED NOT NULL DEFAULT '0' AFTER `TextureID`,
+    CHANGE COLUMN `flags` `Flags` INT(10) UNSIGNED NOT NULL DEFAULT '0' AFTER `Date`,
+    CHANGE COLUMN `time2` `LockDate` INT(10) UNSIGNED NOT NULL DEFAULT '0' AFTER `Flags`;
diff --git a/sql/old/6.x/characters/02_2015_11_08/2015_08_08_00_characters.sql b/sql/old/6.x/characters/02_2015_11_08/2015_08_08_00_characters.sql
new file mode 100644
index 00000000000..5e009e10fd4
--- /dev/null
+++ b/sql/old/6.x/characters/02_2015_11_08/2015_08_08_00_characters.sql
@@ -0,0 +1 @@
+ALTER TABLE `characters` ADD `lootSpecId` INT(10) UNSIGNED NOT NULL DEFAULT '0' AFTER `activeTalentGroup`;
diff --git a/sql/old/6.x/characters/02_2015_11_08/2015_08_12_00_characters.sql b/sql/old/6.x/characters/02_2015_11_08/2015_08_12_00_characters.sql
new file mode 100644
index 00000000000..9abe6972718
--- /dev/null
+++ b/sql/old/6.x/characters/02_2015_11_08/2015_08_12_00_characters.sql
@@ -0,0 +1,3 @@
+ALTER TABLE `character_void_storage`
+  ADD `upgradeId` INT(10) UNSIGNED NOT NULL DEFAULT '0' AFTER `suffixFactor`,
+  ADD `bonusListIDs` TEXT AFTER `upgradeId`;
diff --git a/sql/old/6.x/characters/02_2015_11_08/2015_09_05_00_characters.sql b/sql/old/6.x/characters/02_2015_11_08/2015_09_05_00_characters.sql
new file mode 100644
index 00000000000..f6294e6234a
--- /dev/null
+++ b/sql/old/6.x/characters/02_2015_11_08/2015_09_05_00_characters.sql
@@ -0,0 +1 @@
+UPDATE `characters` SET `knownTitles`=SUBSTRING_INDEX(CONCAT(`knownTitles`, ' 0 0 0 0 0 0 0 0 0 0 0 0'), ' ', 12);
diff --git a/sql/old/6.x/characters/02_2015_11_08/2015_09_09_00_characters.sql b/sql/old/6.x/characters/02_2015_11_08/2015_09_09_00_characters.sql
new file mode 100644
index 00000000000..d6ceca53f38
--- /dev/null
+++ b/sql/old/6.x/characters/02_2015_11_08/2015_09_09_00_characters.sql
@@ -0,0 +1,5 @@
+ALTER TABLE `item_instance`
+  ADD `battlePetSpeciesId` int(10) unsigned NOT NULL DEFAULT '0' AFTER `enchantIllusion`,
+  ADD `battlePetBreedData` int(10) unsigned NOT NULL DEFAULT '0' AFTER `battlePetSpeciesId`,
+  ADD `battlePetLevel` smallint(5) unsigned NOT NULL DEFAULT '0' AFTER `battlePetBreedData`,
+  ADD `battlePetDisplayId` int(10) unsigned NOT NULL DEFAULT '0' AFTER `battlePetLevel`;
diff --git a/sql/old/6.x/characters/02_2015_11_08/2015_09_10_00_characters.sql b/sql/old/6.x/characters/02_2015_11_08/2015_09_10_00_characters.sql
new file mode 100644
index 00000000000..94c9066c6ae
--- /dev/null
+++ b/sql/old/6.x/characters/02_2015_11_08/2015_09_10_00_characters.sql
@@ -0,0 +1,7 @@
+ALTER TABLE `character_spell_cooldown`
+  ADD `categoryId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Spell category Id' AFTER `time`,
+  ADD `categoryEnd` int(10) unsigned NOT NULL DEFAULT '0' AFTER `categoryId`;
+
+ALTER TABLE `pet_spell_cooldown`
+  ADD `categoryId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Spell category Id' AFTER `time`,
+  ADD `categoryEnd` int(10) unsigned NOT NULL DEFAULT '0' AFTER `categoryId`;
diff --git a/sql/old/6.x/characters/02_2015_11_08/2015_10_16_00_characters.sql b/sql/old/6.x/characters/02_2015_11_08/2015_10_16_00_characters.sql
new file mode 100644
index 00000000000..549797fee96
--- /dev/null
+++ b/sql/old/6.x/characters/02_2015_11_08/2015_10_16_00_characters.sql
@@ -0,0 +1,70 @@
+--
+UPDATE `item_instance` SET `itemEntry`=122353 WHERE `itemEntry` IN(42947, 93854);
+UPDATE `item_instance` SET `itemEntry`=122365 WHERE `itemEntry` IN(44092, 93851);
+UPDATE `item_instance` SET `itemEntry`=122363 WHERE `itemEntry` IN(79131, 93844);
+UPDATE `item_instance` SET `itemEntry`=122352 WHERE `itemEntry` IN(42946, 93855);
+UPDATE `item_instance` SET `itemEntry`=122356 WHERE `itemEntry` IN(42950, 93887);
+UPDATE `item_instance` SET `itemEntry`=122349 WHERE `itemEntry` IN(42943, 93843);
+UPDATE `item_instance` SET `itemEntry`=122351 WHERE `itemEntry` IN(42945, 93856);
+UPDATE `item_instance` SET `itemEntry`=122376 WHERE `itemEntry` IN(44103, 93867);
+UPDATE `item_instance` SET `itemEntry`=122355 WHERE `itemEntry` IN(42949, 93890);
+UPDATE `item_instance` SET `itemEntry`=122358 WHERE `itemEntry` IN(42952, 93862);
+UPDATE `item_instance` SET `itemEntry`=122350 WHERE `itemEntry` IN(42944, 93857);
+UPDATE `item_instance` SET `itemEntry`=122359 WHERE `itemEntry` IN(42984, 93864);
+UPDATE `item_instance` SET `itemEntry`=122362 WHERE `itemEntry` IN(42992, 93897);
+UPDATE `item_instance` SET `itemEntry`=122357 WHERE `itemEntry` IN(42951, 93876);
+UPDATE `item_instance` SET `itemEntry`=122360 WHERE `itemEntry` IN(42985, 93859);
+UPDATE `item_instance` SET `itemEntry`=122377 WHERE `itemEntry` IN(44105, 93866);
+UPDATE `item_instance` SET `itemEntry`=122354 WHERE `itemEntry` IN(42948, 93853);
+UPDATE `item_instance` SET `itemEntry`=122364 WHERE `itemEntry` IN(44091, 93852);
+UPDATE `item_instance` SET `itemEntry`=122366 WHERE `itemEntry` IN(44093, 93841);
+UPDATE `item_instance` SET `itemEntry`=122367 WHERE `itemEntry` IN(44094, 93850);
+UPDATE `item_instance` SET `itemEntry`=122370 WHERE `itemEntry` IN(44097, 93898);
+UPDATE `item_instance` SET `itemEntry`=122368 WHERE `itemEntry` IN(44095, 93849);
+UPDATE `item_instance` SET `itemEntry`=122369 WHERE `itemEntry` IN(44096, 93848);
+UPDATE `item_instance` SET `itemEntry`=122361 WHERE `itemEntry` IN(42991, 93896);
+UPDATE `item_instance` SET `itemEntry`=122378 WHERE `itemEntry` IN(44107, 93861);
+UPDATE `item_instance` SET `itemEntry`=122372 WHERE `itemEntry` IN(44099, 93895);
+UPDATE `item_instance` SET `itemEntry`=122373 WHERE `itemEntry` IN(44100, 93894);
+UPDATE `item_instance` SET `itemEntry`=122374 WHERE `itemEntry` IN(44101, 93886);
+UPDATE `item_instance` SET `itemEntry`=122375 WHERE `itemEntry` IN(44102, 93889);
+UPDATE `item_instance` SET `itemEntry`=122371 WHERE `itemEntry` IN(44098, 93899);
+UPDATE `item_instance` SET `itemEntry`=122529 WHERE `itemEntry` IN(50255);
+UPDATE `item_instance` SET `itemEntry`=122384 WHERE `itemEntry` IN(48691, 93860);
+UPDATE `item_instance` SET `itemEntry`=122382 WHERE `itemEntry` IN(48687, 93865);
+UPDATE `item_instance` SET `itemEntry`=122383 WHERE `itemEntry` IN(48689, 93863);
+UPDATE `item_instance` SET `itemEntry`=122380 WHERE `itemEntry` IN(48683, 93885);
+UPDATE `item_instance` SET `itemEntry`=122381 WHERE `itemEntry` IN(48685, 93891);
+UPDATE `item_instance` SET `itemEntry`=122386 WHERE `itemEntry` IN(48718, 93846);
+UPDATE `item_instance` SET `itemEntry`=122385 WHERE `itemEntry` IN(48716, 93847);
+UPDATE `item_instance` SET `itemEntry`=122379 WHERE `itemEntry` IN(48677, 93888);
+UPDATE `item_instance` SET `itemEntry`=122261 WHERE `itemEntry` IN(62039);
+UPDATE `item_instance` SET `itemEntry`=122262 WHERE `itemEntry` IN(62040);
+UPDATE `item_instance` SET `itemEntry`=122260 WHERE `itemEntry` IN(62038);
+UPDATE `item_instance` SET `itemEntry`=122255 WHERE `itemEntry` IN(62027);
+UPDATE `item_instance` SET `itemEntry`=122251 WHERE `itemEntry` IN(62023);
+UPDATE `item_instance` SET `itemEntry`=122252 WHERE `itemEntry` IN(62024);
+UPDATE `item_instance` SET `itemEntry`=122253 WHERE `itemEntry` IN(62025);
+UPDATE `item_instance` SET `itemEntry`=122254 WHERE `itemEntry` IN(62026);
+UPDATE `item_instance` SET `itemEntry`=122245 WHERE `itemEntry` IN(61931);
+UPDATE `item_instance` SET `itemEntry`=122256 WHERE `itemEntry` IN(62029);
+UPDATE `item_instance` SET `itemEntry`=122249 WHERE `itemEntry` IN(61942);
+UPDATE `item_instance` SET `itemEntry`=122250 WHERE `itemEntry` IN(61958);
+UPDATE `item_instance` SET `itemEntry`=122248 WHERE `itemEntry` IN(61937);
+UPDATE `item_instance` SET `itemEntry`=122246 WHERE `itemEntry` IN(61935);
+UPDATE `item_instance` SET `itemEntry`=122247 WHERE `itemEntry` IN(61936);
+UPDATE `item_instance` SET `itemEntry`=122263 WHERE `itemEntry` IN(69887);
+UPDATE `item_instance` SET `itemEntry`=122264 WHERE `itemEntry` IN(69888);
+UPDATE `item_instance` SET `itemEntry`=122387 WHERE `itemEntry` IN(69889, 93892);
+UPDATE `item_instance` SET `itemEntry`=122388 WHERE `itemEntry` IN(69890, 93893);
+UPDATE `item_instance` SET `itemEntry`=122389 WHERE `itemEntry` IN(69893, 93845);
+UPDATE `item_instance` SET `itemEntry`=122266 WHERE `itemEntry` IN(69892);
+UPDATE `item_instance` SET `itemEntry`=122392 WHERE `itemEntry` IN(93903);
+UPDATE `item_instance` SET `itemEntry`=122396 WHERE `itemEntry` IN(92948, 93858);
+UPDATE `item_instance` SET `itemEntry`=122390 WHERE `itemEntry` IN(93904);
+UPDATE `item_instance` SET `itemEntry`=122530 WHERE `itemEntry` IN(93900);
+UPDATE `item_instance` SET `itemEntry`=122391 WHERE `itemEntry` IN(93902);
+UPDATE `item_instance` SET `itemEntry`=128173 WHERE `itemEntry` IN(44102, 93889);
+UPDATE `item_instance` SET `itemEntry`=128169 WHERE `itemEntry` IN(44102, 93889);
+UPDATE `item_instance` SET `itemEntry`=128172 WHERE `itemEntry` IN(44102, 93889);
+UPDATE `item_instance` SET `itemEntry`=128318 WHERE `itemEntry` IN(42992);
diff --git a/sql/old/6.x/characters/02_2015_11_08/2015_11_06_00_characters_2015_10_12_00.sql b/sql/old/6.x/characters/02_2015_11_08/2015_11_06_00_characters_2015_10_12_00.sql
new file mode 100644
index 00000000000..d7d4fb90f02
--- /dev/null
+++ b/sql/old/6.x/characters/02_2015_11_08/2015_11_06_00_characters_2015_10_12_00.sql
@@ -0,0 +1,17 @@
+-- Add new winner field, bound to player
+ALTER TABLE `pvpstats_players`
+  ADD COLUMN `winner` BIT(1) NOT NULL AFTER `character_guid`;
+
+-- Resolve horde players victories
+UPDATE `pvpstats_players` SET `winner` = 1 WHERE `battleground_id` IN (
+    SELECT `id` FROM `pvpstats_battlegrounds` WHERE `winner_faction` = 0
+) AND `character_guid` IN (
+    SELECT `guid` FROM `characters` WHERE `race` IN (2, 5, 6, 8, 9, 10)
+);
+
+-- Resolve alliance players victories
+UPDATE `pvpstats_players` SET `winner` = 1 WHERE `battleground_id` IN (
+    SELECT `id` FROM `pvpstats_battlegrounds` WHERE `winner_faction` = 1
+) AND `character_guid` IN (
+    SELECT `guid` FROM `characters` WHERE `race` IN (1, 3, 4, 7, 11, 22)
+);