TDB 335.60 - 2015/11/07TDB335.60

9 files changed, 1 insertions, 66 deletions

diff --git a/sql/updates/characters/2015_08_26_00_characters_335.sql b/sql/updates/characters/2015_08_26_00_characters_335.sql
deleted file mode 100644
index 1f46c5dd7f7..00000000000
--- a/sql/updates/characters/2015_08_26_00_characters_335.sql
+++ /dev/null
@@ -1,16 +0,0 @@
--- 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/updates/characters/2015_09_28_00_characters_335.sql b/sql/updates/characters/2015_09_28_00_characters_335.sql
deleted file mode 100644
index f2ce50fd4c6..00000000000
--- a/sql/updates/characters/2015_09_28_00_characters_335.sql
+++ /dev/null
@@ -1,5 +0,0 @@
-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/updates/characters/2015_10_06_00_characters.sql b/sql/updates/characters/2015_10_06_00_characters.sql
deleted file mode 100644
index c8d8e3211f4..00000000000
--- a/sql/updates/characters/2015_10_06_00_characters.sql
+++ /dev/null
@@ -1,2 +0,0 @@
-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/updates/characters/2015_10_07_00_characters.sql b/sql/updates/characters/2015_10_07_00_characters.sql
deleted file mode 100644
index a03fffcd77a..00000000000
--- a/sql/updates/characters/2015_10_07_00_characters.sql
+++ /dev/null
@@ -1,3 +0,0 @@
-ALTER TABLE `pet_aura`
-DROP PRIMARY KEY,
-ADD PRIMARY KEY (`guid`,`casterGuid`,`spell`,`effectMask`);
diff --git a/sql/updates/characters/2015_10_12_00_characters.sql b/sql/updates/characters/2015_10_12_00_characters.sql
deleted file mode 100644
index d7d4fb90f02..00000000000
--- a/sql/updates/characters/2015_10_12_00_characters.sql
+++ /dev/null
@@ -1,17 +0,0 @@
--- 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/updates/characters/2015_10_28_00_characters.sql b/sql/updates/characters/2015_10_28_00_characters.sql
deleted file mode 100644
index 9d353773a33..00000000000
--- a/sql/updates/characters/2015_10_28_00_characters.sql
+++ /dev/null
@@ -1,6 +0,0 @@
-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/updates/characters/2015_10_29_00_characters_335.sql b/sql/updates/characters/2015_10_29_00_characters_335.sql
deleted file mode 100644
index 94c9066c6ae..00000000000
--- a/sql/updates/characters/2015_10_29_00_characters_335.sql
+++ /dev/null
@@ -1,7 +0,0 @@
-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/updates/characters/2015_11_03_00_characters.sql b/sql/updates/characters/2015_11_03_00_characters.sql
deleted file mode 100644
index b74824477be..00000000000
--- a/sql/updates/characters/2015_11_03_00_characters.sql
+++ /dev/null
@@ -1,10 +0,0 @@
-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`;
diff --git a/sql/updates/characters/2015_11_07_00_characters.sql b/sql/updates/characters/2015_11_07_00_characters.sql
new file mode 100644
index 00000000000..be8a4d21b66
--- /dev/null
+++ b/sql/updates/characters/2015_11_07_00_characters.sql
@@ -0,0 +1 @@
+UPDATE `updates` SET `state`='ARCHIVED';