TDB 335.60 - 2015/11/07TDB335.60

8 files changed, 66 insertions, 0 deletions

diff --git a/sql/old/3.3.5a/characters/59_2015_11_07/2015_08_26_00_characters_335.sql b/sql/old/3.3.5a/characters/59_2015_11_07/2015_08_26_00_characters_335.sql
new file mode 100644
index 00000000000..1f46c5dd7f7
--- /dev/null
+++ b/sql/old/3.3.5a/characters/59_2015_11_07/2015_08_26_00_characters_335.sql
@@ -0,0 +1,16 @@
+-- Keep only the highest guid PvE or PvP (not bones) corpse per player guid
+DELETE c FROM `corpse` c LEFT JOIN
+(
+    SELECT MAX(`corpseGuid`) AS id
+    FROM `corpse`
+    WHERE `corpseType` IN (1,2)
+    GROUP BY `guid`
+) corpsetemp
+ON c.`corpseGuid` = corpsetemp.`id`
+WHERE corpsetemp.`id` IS NULL;
+
+-- Remove corpseGUID and set key to player guid
+ALTER TABLE `corpse`
+  DROP `corpseGuid`,
+  DROP INDEX `idx_player`,
+  ADD PRIMARY KEY (`guid`);
diff --git a/sql/old/3.3.5a/characters/59_2015_11_07/2015_09_28_00_characters_335.sql b/sql/old/3.3.5a/characters/59_2015_11_07/2015_09_28_00_characters_335.sql
new file mode 100644
index 00000000000..f2ce50fd4c6
--- /dev/null
+++ b/sql/old/3.3.5a/characters/59_2015_11_07/2015_09_28_00_characters_335.sql
@@ -0,0 +1,5 @@
+UPDATE `auctionhouse`
+SET `time` = 0, `auctioneerguid` = 7;
+
+ALTER TABLE `auctionhouse`
+  CHANGE COLUMN `auctioneerguid`    `houseid`   TINYINT(3)  UNSIGNED NOT NULL DEFAULT '7' AFTER `id`;
diff --git a/sql/old/3.3.5a/characters/59_2015_11_07/2015_10_06_00_characters.sql b/sql/old/3.3.5a/characters/59_2015_11_07/2015_10_06_00_characters.sql
new file mode 100644
index 00000000000..c8d8e3211f4
--- /dev/null
+++ b/sql/old/3.3.5a/characters/59_2015_11_07/2015_10_06_00_characters.sql
@@ -0,0 +1,2 @@
+ALTER TABLE `gm_ticket`
+  ADD COLUMN `resolvedBy` INT(10) NOT NULL DEFAULT '0' COMMENT 'GUID of GM who resolved the ticket' AFTER `needMoreHelp`;
diff --git a/sql/old/3.3.5a/characters/59_2015_11_07/2015_10_07_00_characters.sql b/sql/old/3.3.5a/characters/59_2015_11_07/2015_10_07_00_characters.sql
new file mode 100644
index 00000000000..a03fffcd77a
--- /dev/null
+++ b/sql/old/3.3.5a/characters/59_2015_11_07/2015_10_07_00_characters.sql
@@ -0,0 +1,3 @@
+ALTER TABLE `pet_aura`
+DROP PRIMARY KEY,
+ADD PRIMARY KEY (`guid`,`casterGuid`,`spell`,`effectMask`);
diff --git a/sql/old/3.3.5a/characters/59_2015_11_07/2015_10_12_00_characters.sql b/sql/old/3.3.5a/characters/59_2015_11_07/2015_10_12_00_characters.sql
new file mode 100644
index 00000000000..d7d4fb90f02
--- /dev/null
+++ b/sql/old/3.3.5a/characters/59_2015_11_07/2015_10_12_00_characters.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)
+);
diff --git a/sql/old/3.3.5a/characters/59_2015_11_07/2015_10_28_00_characters.sql b/sql/old/3.3.5a/characters/59_2015_11_07/2015_10_28_00_characters.sql
new file mode 100644
index 00000000000..9d353773a33
--- /dev/null
+++ b/sql/old/3.3.5a/characters/59_2015_11_07/2015_10_28_00_characters.sql
@@ -0,0 +1,6 @@
+DROP TABLE IF EXISTS `battleground_deserters`;
+CREATE TABLE `battleground_deserters` (
+	`guid` INT(10) UNSIGNED NOT NULL COMMENT 'characters.guid',
+	`type` TINYINT(3) UNSIGNED NOT NULL COMMENT 'type of the desertion',
+	`datetime` DATETIME NOT NULL COMMENT 'datetime of the desertion'
+);
diff --git a/sql/old/3.3.5a/characters/59_2015_11_07/2015_10_29_00_characters_335.sql b/sql/old/3.3.5a/characters/59_2015_11_07/2015_10_29_00_characters_335.sql
new file mode 100644
index 00000000000..94c9066c6ae
--- /dev/null
+++ b/sql/old/3.3.5a/characters/59_2015_11_07/2015_10_29_00_characters_335.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/3.3.5a/characters/59_2015_11_07/2015_11_03_00_characters.sql b/sql/old/3.3.5a/characters/59_2015_11_07/2015_11_03_00_characters.sql
new file mode 100644
index 00000000000..b74824477be
--- /dev/null
+++ b/sql/old/3.3.5a/characters/59_2015_11_07/2015_11_03_00_characters.sql
@@ -0,0 +1,10 @@
+ALTER TABLE `gm_ticket`
+  ADD COLUMN `type` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0' COMMENT '0 open, 1 closed, 2 character deleted' AFTER `id`;
+
+UPDATE `gm_ticket` SET `type` = 1 WHERE `closedBy` != 0 OR `completed` != 0 OR `resolvedBy` != 0;
+UPDATE `gm_ticket` SET `closedBy` = 0 WHERE `closedBy` < 0;
+UPDATE `gm_ticket` SET `resolvedBy` = 0 WHERE `resolvedBy` < 0;
+
+ALTER TABLE `gm_ticket`
+  CHANGE COLUMN `closedBy` `closedBy` INT(10) UNSIGNED NOT NULL DEFAULT '0' AFTER `lastModifiedTime`,
+  CHANGE COLUMN `resolvedBy` `resolvedBy` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'GUID of GM who resolved the ticket' AFTER `needMoreHelp`;