diff options
Diffstat (limited to 'sql/updates/characters')
9 files changed, 1 insertions, 124 deletions
diff --git a/sql/updates/characters/2015_07_28_00_characters.sql b/sql/updates/characters/2015_07_28_00_characters.sql deleted file mode 100644 index 29af7731d19..00000000000 --- a/sql/updates/characters/2015_07_28_00_characters.sql +++ /dev/null @@ -1,20 +0,0 @@ -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/updates/characters/2015_08_08_00_characters.sql b/sql/updates/characters/2015_08_08_00_characters.sql deleted file mode 100644 index 5e009e10fd4..00000000000 --- a/sql/updates/characters/2015_08_08_00_characters.sql +++ /dev/null @@ -1 +0,0 @@ -ALTER TABLE `characters` ADD `lootSpecId` INT(10) UNSIGNED NOT NULL DEFAULT '0' AFTER `activeTalentGroup`; diff --git a/sql/updates/characters/2015_08_12_00_characters.sql b/sql/updates/characters/2015_08_12_00_characters.sql deleted file mode 100644 index 9abe6972718..00000000000 --- a/sql/updates/characters/2015_08_12_00_characters.sql +++ /dev/null @@ -1,3 +0,0 @@ -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/updates/characters/2015_09_05_00_characters.sql b/sql/updates/characters/2015_09_05_00_characters.sql deleted file mode 100644 index f6294e6234a..00000000000 --- a/sql/updates/characters/2015_09_05_00_characters.sql +++ /dev/null @@ -1 +0,0 @@ -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/updates/characters/2015_09_09_00_characters.sql b/sql/updates/characters/2015_09_09_00_characters.sql deleted file mode 100644 index d6ceca53f38..00000000000 --- a/sql/updates/characters/2015_09_09_00_characters.sql +++ /dev/null @@ -1,5 +0,0 @@ -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/updates/characters/2015_09_10_00_characters.sql b/sql/updates/characters/2015_09_10_00_characters.sql deleted file mode 100644 index 94c9066c6ae..00000000000 --- a/sql/updates/characters/2015_09_10_00_characters.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_10_16_00_characters.sql b/sql/updates/characters/2015_10_16_00_characters.sql deleted file mode 100644 index 549797fee96..00000000000 --- a/sql/updates/characters/2015_10_16_00_characters.sql +++ /dev/null @@ -1,70 +0,0 @@ --- -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/updates/characters/2015_11_06_00_characters_2015_10_12_00.sql b/sql/updates/characters/2015_11_06_00_characters_2015_10_12_00.sql deleted file mode 100644 index d7d4fb90f02..00000000000 --- a/sql/updates/characters/2015_11_06_00_characters_2015_10_12_00.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_11_08_00_characters.sql b/sql/updates/characters/2015_11_08_00_characters.sql new file mode 100644 index 00000000000..be8a4d21b66 --- /dev/null +++ b/sql/updates/characters/2015_11_08_00_characters.sql @@ -0,0 +1 @@ +UPDATE `updates` SET `state`='ARCHIVED'; |