TDB 830.20061 - 2020/06/17TDB830.20061

16 files changed, 3 insertions, 168 deletions

diff --git a/sql/updates/characters/master/2019_07_15_00_characters.sql b/sql/updates/characters/master/2019_07_15_00_characters.sql
deleted file mode 100644
index 4116c0691cb..00000000000
--- a/sql/updates/characters/master/2019_07_15_00_characters.sql
+++ /dev/null
@@ -1,2 +0,0 @@
--- TDB 820.19071 characters
-UPDATE `updates` SET `state`='ARCHIVED';
diff --git a/sql/updates/characters/master/2019_10_26_00_characters.sql b/sql/updates/characters/master/2019_10_26_00_characters.sql
deleted file mode 100644
index 37de4489e91..00000000000
--- a/sql/updates/characters/master/2019_10_26_00_characters.sql
+++ /dev/null
@@ -1,25 +0,0 @@
-UPDATE `characters` SET `equipmentCache`=CONCAT(
-CONCAT(SUBSTRING_INDEX(SUBSTRING_INDEX(`equipmentCache`, ' ', -70), ' ', 2), ' 0 0 '),
-CONCAT(SUBSTRING_INDEX(SUBSTRING_INDEX(`equipmentCache`, ' ', -67), ' ', 2), ' 0 0 '),
-CONCAT(SUBSTRING_INDEX(SUBSTRING_INDEX(`equipmentCache`, ' ', -64), ' ', 2), ' 0 0 '),
-CONCAT(SUBSTRING_INDEX(SUBSTRING_INDEX(`equipmentCache`, ' ', -61), ' ', 2), ' 0 0 '),
-CONCAT(SUBSTRING_INDEX(SUBSTRING_INDEX(`equipmentCache`, ' ', -58), ' ', 2), ' 0 0 '),
-CONCAT(SUBSTRING_INDEX(SUBSTRING_INDEX(`equipmentCache`, ' ', -55), ' ', 2), ' 0 0 '),
-CONCAT(SUBSTRING_INDEX(SUBSTRING_INDEX(`equipmentCache`, ' ', -52), ' ', 2), ' 0 0 '),
-CONCAT(SUBSTRING_INDEX(SUBSTRING_INDEX(`equipmentCache`, ' ', -49), ' ', 2), ' 0 0 '),
-CONCAT(SUBSTRING_INDEX(SUBSTRING_INDEX(`equipmentCache`, ' ', -46), ' ', 2), ' 0 0 '),
-CONCAT(SUBSTRING_INDEX(SUBSTRING_INDEX(`equipmentCache`, ' ', -43), ' ', 2), ' 0 0 '),
-CONCAT(SUBSTRING_INDEX(SUBSTRING_INDEX(`equipmentCache`, ' ', -40), ' ', 2), ' 0 0 '),
-CONCAT(SUBSTRING_INDEX(SUBSTRING_INDEX(`equipmentCache`, ' ', -37), ' ', 2), ' 0 0 '),
-CONCAT(SUBSTRING_INDEX(SUBSTRING_INDEX(`equipmentCache`, ' ', -34), ' ', 2), ' 0 0 '),
-CONCAT(SUBSTRING_INDEX(SUBSTRING_INDEX(`equipmentCache`, ' ', -31), ' ', 2), ' 0 0 '),
-CONCAT(SUBSTRING_INDEX(SUBSTRING_INDEX(`equipmentCache`, ' ', -28), ' ', 2), ' 0 0 '),
-CONCAT(SUBSTRING_INDEX(SUBSTRING_INDEX(`equipmentCache`, ' ', -25), ' ', 2), ' 0 0 '),
-CONCAT(SUBSTRING_INDEX(SUBSTRING_INDEX(`equipmentCache`, ' ', -22), ' ', 2), ' 0 0 '),
-CONCAT(SUBSTRING_INDEX(SUBSTRING_INDEX(`equipmentCache`, ' ', -19), ' ', 2), ' 0 0 '),
-CONCAT(SUBSTRING_INDEX(SUBSTRING_INDEX(`equipmentCache`, ' ', -16), ' ', 2), ' 0 0 '),
-CONCAT(SUBSTRING_INDEX(SUBSTRING_INDEX(`equipmentCache`, ' ', -13), ' ', 2), ' 0 0 '),
-CONCAT(SUBSTRING_INDEX(SUBSTRING_INDEX(`equipmentCache`, ' ', -10), ' ', 2), ' 0 0 '),
-CONCAT(SUBSTRING_INDEX(SUBSTRING_INDEX(`equipmentCache`, ' ',  -7), ' ', 2), ' 0 0 '),
-CONCAT(SUBSTRING_INDEX(SUBSTRING_INDEX(`equipmentCache`, ' ',  -4), ' ', 2), ' 0 0 ')
-) WHERE LENGTH(`equipmentCache`) > 0;
diff --git a/sql/updates/characters/master/2019_10_26_01_characters.sql b/sql/updates/characters/master/2019_10_26_01_characters.sql
deleted file mode 100644
index 037153b8932..00000000000
--- a/sql/updates/characters/master/2019_10_26_01_characters.sql
+++ /dev/null
@@ -1,2 +0,0 @@
-ALTER TABLE `character_void_storage` DROP `upgradeId`;
-ALTER TABLE `item_instance` DROP `upgradeId`;
diff --git a/sql/updates/characters/master/2019_11_03_00_characters.sql b/sql/updates/characters/master/2019_11_03_00_characters.sql
deleted file mode 100644
index 2cdfefe0ef7..00000000000
--- a/sql/updates/characters/master/2019_11_03_00_characters.sql
+++ /dev/null
@@ -1 +0,0 @@
-ALTER TABLE `characters` DROP `grantableLevels`;
diff --git a/sql/updates/characters/master/2019_11_12_00_characters.sql b/sql/updates/characters/master/2019_11_12_00_characters.sql
deleted file mode 100644
index 010e1693298..00000000000
--- a/sql/updates/characters/master/2019_11_12_00_characters.sql
+++ /dev/null
@@ -1,11 +0,0 @@
---
--- Table structure for table `item_instance_azerite`
---
-DROP TABLE IF EXISTS `item_instance_azerite`;
-CREATE TABLE `item_instance_azerite` (
-  `itemGuid` bigint(20) unsigned NOT NULL,
-  `xp` bigint(20) unsigned NOT NULL DEFAULT '0',
-  `level` int(10) unsigned NOT NULL DEFAULT '1',
-  `knowledgeLevel` int(10) unsigned NOT NULL DEFAULT '0',
-  PRIMARY KEY (`itemGuid`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
diff --git a/sql/updates/characters/master/2019_11_22_00_characters.sql b/sql/updates/characters/master/2019_11_22_00_characters.sql
deleted file mode 100644
index 97671dfbbde..00000000000
--- a/sql/updates/characters/master/2019_11_22_00_characters.sql
+++ /dev/null
@@ -1,38 +0,0 @@
-ALTER TABLE `item_instance_azerite` 
-  ADD `selectedAzeriteEssences1specId` int(10) unsigned NULL DEFAULT '0',
-  ADD `selectedAzeriteEssences1azeriteEssenceId1` int(10) unsigned NULL DEFAULT '0',
-  ADD `selectedAzeriteEssences1azeriteEssenceId2` int(10) unsigned NULL DEFAULT '0',
-  ADD `selectedAzeriteEssences1azeriteEssenceId3` int(10) unsigned NULL DEFAULT '0',
-  ADD `selectedAzeriteEssences2specId` int(10) unsigned NULL DEFAULT '0',
-  ADD `selectedAzeriteEssences2azeriteEssenceId1` int(10) unsigned NULL DEFAULT '0',
-  ADD `selectedAzeriteEssences2azeriteEssenceId2` int(10) unsigned NULL DEFAULT '0',
-  ADD `selectedAzeriteEssences2azeriteEssenceId3` int(10) unsigned NULL DEFAULT '0',
-  ADD `selectedAzeriteEssences3specId` int(10) unsigned NULL DEFAULT '0',
-  ADD `selectedAzeriteEssences3azeriteEssenceId1` int(10) unsigned NULL DEFAULT '0',
-  ADD `selectedAzeriteEssences3azeriteEssenceId2` int(10) unsigned NULL DEFAULT '0',
-  ADD `selectedAzeriteEssences3azeriteEssenceId3` int(10) unsigned NULL DEFAULT '0',
-  ADD `selectedAzeriteEssences4specId` int(10) unsigned NULL DEFAULT '0',
-  ADD `selectedAzeriteEssences4azeriteEssenceId1` int(10) unsigned NULL DEFAULT '0',
-  ADD `selectedAzeriteEssences4azeriteEssenceId2` int(10) unsigned NULL DEFAULT '0',
-  ADD `selectedAzeriteEssences4azeriteEssenceId3` int(10) unsigned NULL DEFAULT '0';
-
---
--- Table structure for table `item_instance_azerite_milestone_power`
---
-DROP TABLE IF EXISTS `item_instance_azerite_milestone_power`;
-CREATE TABLE `item_instance_azerite_milestone_power` (
-  `itemGuid` bigint(20) unsigned NOT NULL,
-  `azeriteItemMilestonePowerId` int(10) unsigned NOT NULL,
-  PRIMARY KEY (`itemGuid`,`azeriteItemMilestonePowerId`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-
---
--- Table structure for table `item_instance_azerite_unlocked_essence`
---
-DROP TABLE IF EXISTS `item_instance_azerite_unlocked_essence`;
-CREATE TABLE `item_instance_azerite_unlocked_essence` (
-  `itemGuid` bigint(20) unsigned NOT NULL,
-  `azeriteEssenceId` int(10) unsigned NOT NULL,
-  `rank` int(10) unsigned NOT NULL,
-  PRIMARY KEY (`itemGuid`,`azeriteEssenceId`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
diff --git a/sql/updates/characters/master/2019_11_30_00_characters.sql b/sql/updates/characters/master/2019_11_30_00_characters.sql
deleted file mode 100644
index 70279def138..00000000000
--- a/sql/updates/characters/master/2019_11_30_00_characters.sql
+++ /dev/null
@@ -1 +0,0 @@
-ALTER TABLE `character_aura` ADD `castItemId` int(10) unsigned NOT NULL DEFAULT '0' AFTER `remainCharges`;
diff --git a/sql/updates/characters/master/2019_12_05_00_characters.sql b/sql/updates/characters/master/2019_12_05_00_characters.sql
deleted file mode 100644
index 647ce02ec86..00000000000
--- a/sql/updates/characters/master/2019_12_05_00_characters.sql
+++ /dev/null
@@ -1,15 +0,0 @@
-ALTER TABLE `characters` ADD `numRespecs` tinyint(3) unsigned NOT NULL DEFAULT '0' AFTER `resettalents_time`;
-
---
--- Table structure for table `item_instance_azerite_empowered`
---
-DROP TABLE IF EXISTS `item_instance_azerite_empowered`;
-CREATE TABLE `item_instance_azerite_empowered` (
-  `itemGuid` bigint(20) unsigned NOT NULL,
-  `azeritePowerId1` int(11) NOT NULL,
-  `azeritePowerId2` int(11) NOT NULL,
-  `azeritePowerId3` int(11) NOT NULL,
-  `azeritePowerId4` int(11) NOT NULL,
-  `azeritePowerId5` int(11) NOT NULL,
-  PRIMARY KEY (`itemGuid`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
diff --git a/sql/updates/characters/master/2020_02_17_00_characters.sql b/sql/updates/characters/master/2020_02_17_00_characters.sql
deleted file mode 100644
index ed834a9dd6f..00000000000
--- a/sql/updates/characters/master/2020_02_17_00_characters.sql
+++ /dev/null
@@ -1,7 +0,0 @@
-UPDATE `character_inventory` SET `slot`=`slot`+4 WHERE `slot`>=47 AND `bag`=0;
-
-ALTER TABLE `item_instance_azerite`
-  ADD `selectedAzeriteEssences1azeriteEssenceId4` int(10) unsigned NULL DEFAULT '0' AFTER `selectedAzeriteEssences1azeriteEssenceId3`,
-  ADD `selectedAzeriteEssences2azeriteEssenceId4` int(10) unsigned NULL DEFAULT '0' AFTER `selectedAzeriteEssences2azeriteEssenceId3`,
-  ADD `selectedAzeriteEssences3azeriteEssenceId4` int(10) unsigned NULL DEFAULT '0' AFTER `selectedAzeriteEssences3azeriteEssenceId3`,
-  ADD `selectedAzeriteEssences4azeriteEssenceId4` int(10) unsigned NULL DEFAULT '0' AFTER `selectedAzeriteEssences4azeriteEssenceId3`;
diff --git a/sql/updates/characters/master/2020_04_20_00_characters.sql b/sql/updates/characters/master/2020_04_20_00_characters.sql
deleted file mode 100644
index 689f2ea4b9e..00000000000
--- a/sql/updates/characters/master/2020_04_20_00_characters.sql
+++ /dev/null
@@ -1,46 +0,0 @@
-ALTER TABLE `auctionhouse` ADD `auctionHouseId` int(10) unsigned NOT NULL DEFAULT '0' AFTER `id`;
-ALTER TABLE `auctionhouse` DROP `auctioneerguid`;
-
--- temporarily mark all auctions as coming from neutral AH (not goblin one) and expired
-UPDATE `auctionhouse` SET `auctionHouseId`=1, `time`=UNIX_TIMESTAMP();
-
-DROP TABLE IF EXISTS `auction_bidders`;
-CREATE TABLE `auction_bidders` (
-  `auctionId` int unsigned NOT NULL,
-  `playerGuid` bigint unsigned NOT NULL,
-  PRIMARY KEY (`auctionId`,`playerGuid`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-
-INSERT INTO `auction_bidders` SELECT `id`, `buyguid` FROM `auctionhouse`;
-
-DROP TABLE IF EXISTS `auction_items`;
-CREATE TABLE `auction_items` (
-  `auctionId` int unsigned NOT NULL,
-  `itemGuid` bigint unsigned NOT NULL,
-  PRIMARY KEY (`auctionId`,`itemGuid`),
-  UNIQUE KEY `idx_itemGuid` (`itemGuid`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-
-DROP TABLE IF EXISTS `character_favorite_auctions`;
-CREATE TABLE `character_favorite_auctions` (
-  `guid` bigint(20) unsigned NOT NULL,
-  `order` int(10) unsigned NOT NULL DEFAULT '0',
-  `itemId` int(10) unsigned NOT NULL DEFAULT '0',
-  `itemLevel` int(10) unsigned NOT NULL DEFAULT '0',
-  `battlePetSpeciesId` int(10) unsigned NOT NULL DEFAULT '0',
-  `suffixItemNameDescriptionId` int(10) unsigned NOT NULL DEFAULT '0',
-  PRIMARY KEY (`guid`,`order`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-
-INSERT INTO `auction_items` SELECT `id`, `itemguid` FROM `auctionhouse`;
-
-ALTER TABLE `auctionhouse` DROP INDEX `item_guid`;
-ALTER TABLE `auctionhouse` DROP `itemguid`;
-ALTER TABLE `auctionhouse` CHANGE `itemowner` `owner` bigint(20) unsigned NOT NULL DEFAULT '0' AFTER `auctionHouseId`;
-ALTER TABLE `auctionhouse` CHANGE `buyguid` `bidder` bigint(20) unsigned NOT NULL DEFAULT '0' AFTER `owner`;
-ALTER TABLE `auctionhouse` CHANGE `startbid` `minBid` bigint(20) unsigned NOT NULL DEFAULT '0' AFTER `bidder`;
-ALTER TABLE `auctionhouse` CHANGE `buyoutprice` `buyoutOrUnitPrice` bigint(20) unsigned NOT NULL DEFAULT '0' AFTER `lastbid`;
-ALTER TABLE `auctionhouse` MODIFY `deposit` bigint(20) unsigned NOT NULL DEFAULT '0' AFTER `buyoutOrUnitPrice`;
-ALTER TABLE `auctionhouse` CHANGE `lastbid` `bidAmount` bigint(20) unsigned NOT NULL DEFAULT '0' AFTER `deposit`;
-ALTER TABLE `auctionhouse` ADD `startTime` int(10) unsigned NOT NULL DEFAULT '0' AFTER `bidAmount`;
-ALTER TABLE `auctionhouse` CHANGE `time` `endTime` int(10) unsigned NOT NULL DEFAULT '0' AFTER `startTime`;
diff --git a/sql/updates/characters/master/2020_04_24_00_characters.sql b/sql/updates/characters/master/2020_04_24_00_characters.sql
deleted file mode 100644
index 6b7cbbf8496..00000000000
--- a/sql/updates/characters/master/2020_04_24_00_characters.sql
+++ /dev/null
@@ -1 +0,0 @@
-UPDATE `item_instance_azerite` SET `knowledgeLevel`=15;
diff --git a/sql/updates/characters/master/2020_04_25_00_characters_2017_04_03_00_characters.sql b/sql/updates/characters/master/2020_04_25_00_characters_2017_04_03_00_characters.sql
deleted file mode 100644
index 3a962753a55..00000000000
--- a/sql/updates/characters/master/2020_04_25_00_characters_2017_04_03_00_characters.sql
+++ /dev/null
@@ -1,11 +0,0 @@
-ALTER TABLE `character_arena_stats`
-CHANGE `guid` `guid` BIGINT(20) unsigned NOT NULL DEFAULT '0',
-CHANGE `slot` `slot` TINYINT(3) unsigned NOT NULL DEFAULT '0',
-CHANGE `matchMakerRating` `matchMakerRating` SMALLINT(5) unsigned NOT NULL DEFAULT 0;
-
-ALTER TABLE `character_equipmentsets`
-CHANGE `guid` `guid` BIGINT(20) unsigned NOT NULL DEFAULT '0',
-CHANGE `setguid` `setguid` BIGINT(20) unsigned NOT NULL AUTO_INCREMENT;
-
-ALTER TABLE `item_loot_money`
-CHANGE `container_id` `container_id` BIGINT(20) unsigned NOT NULL DEFAULT '0' COMMENT 'guid of container (item_instance.guid)';
diff --git a/sql/updates/characters/master/2020_04_26_00_characters_2017_04_12_00_characters.sql b/sql/updates/characters/master/2020_04_26_00_characters_2017_04_12_00_characters.sql
deleted file mode 100644
index 5340fbfca3e..00000000000
--- a/sql/updates/characters/master/2020_04_26_00_characters_2017_04_12_00_characters.sql
+++ /dev/null
@@ -1,2 +0,0 @@
-ALTER TABLE `item_loot_money`
-CHANGE `money` `money` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'money loot (in copper)';
diff --git a/sql/updates/characters/master/2020_04_26_01_characters_2017_04_12_01_characters.sql b/sql/updates/characters/master/2020_04_26_01_characters_2017_04_12_01_characters.sql
deleted file mode 100644
index ed5617d2750..00000000000
--- a/sql/updates/characters/master/2020_04_26_01_characters_2017_04_12_01_characters.sql
+++ /dev/null
@@ -1,4 +0,0 @@
-ALTER TABLE `creature_respawn` CHANGE `respawnTime` `respawnTime` bigint(20) unsigned NOT NULL DEFAULT '0';
-ALTER TABLE `gameobject_respawn` CHANGE `respawnTime` `respawnTime` bigint(20) unsigned NOT NULL DEFAULT '0';
-ALTER TABLE `instance` CHANGE `resettime` `resettime` bigint(20) unsigned NOT NULL DEFAULT '0';
-ALTER TABLE `instance_reset` CHANGE `resettime` `resettime` bigint(20) unsigned NOT NULL DEFAULT '0';
diff --git a/sql/updates/characters/master/2020_06_12_00_characters.sql b/sql/updates/characters/master/2020_06_12_00_characters.sql
deleted file mode 100644
index 885111dc1f7..00000000000
--- a/sql/updates/characters/master/2020_06_12_00_characters.sql
+++ /dev/null
@@ -1,2 +0,0 @@
-ALTER TABLE `character_aura` ADD `difficulty` tinyint(3) unsigned NOT NULL DEFAULT '0' AFTER `recalculateMask`;
-ALTER TABLE `pet_aura` ADD `difficulty` tinyint(3) unsigned NOT NULL DEFAULT '0' AFTER `recalculateMask`;
diff --git a/sql/updates/characters/master/2020_06_17_00_characters.sql b/sql/updates/characters/master/2020_06_17_00_characters.sql
new file mode 100644
index 00000000000..9d1a82d2dc1
--- /dev/null
+++ b/sql/updates/characters/master/2020_06_17_00_characters.sql
@@ -0,0 +1,3 @@
+-- TDB 830.20061 characters
+UPDATE `updates` SET `state`='ARCHIVED',`speed`=0;
+REPLACE INTO `updates_include` (`path`, `state`) VALUES ('$/sql/old/8.x/characters', 'ARCHIVED');