TDB 830.20061 - 2020/06/17TDB830.20061

15 files changed, 168 insertions, 0 deletions

diff --git a/sql/old/8.x/characters/19071_2020_06_17/2019_07_15_00_characters.sql b/sql/old/8.x/characters/19071_2020_06_17/2019_07_15_00_characters.sql
new file mode 100644
index 00000000000..4116c0691cb
--- /dev/null
+++ b/sql/old/8.x/characters/19071_2020_06_17/2019_07_15_00_characters.sql
@@ -0,0 +1,2 @@
+-- TDB 820.19071 characters
+UPDATE `updates` SET `state`='ARCHIVED';
diff --git a/sql/old/8.x/characters/19071_2020_06_17/2019_10_26_00_characters.sql b/sql/old/8.x/characters/19071_2020_06_17/2019_10_26_00_characters.sql
new file mode 100644
index 00000000000..37de4489e91
--- /dev/null
+++ b/sql/old/8.x/characters/19071_2020_06_17/2019_10_26_00_characters.sql
@@ -0,0 +1,25 @@
+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/old/8.x/characters/19071_2020_06_17/2019_10_26_01_characters.sql b/sql/old/8.x/characters/19071_2020_06_17/2019_10_26_01_characters.sql
new file mode 100644
index 00000000000..037153b8932
--- /dev/null
+++ b/sql/old/8.x/characters/19071_2020_06_17/2019_10_26_01_characters.sql
@@ -0,0 +1,2 @@
+ALTER TABLE `character_void_storage` DROP `upgradeId`;
+ALTER TABLE `item_instance` DROP `upgradeId`;
diff --git a/sql/old/8.x/characters/19071_2020_06_17/2019_11_03_00_characters.sql b/sql/old/8.x/characters/19071_2020_06_17/2019_11_03_00_characters.sql
new file mode 100644
index 00000000000..2cdfefe0ef7
--- /dev/null
+++ b/sql/old/8.x/characters/19071_2020_06_17/2019_11_03_00_characters.sql
@@ -0,0 +1 @@
+ALTER TABLE `characters` DROP `grantableLevels`;
diff --git a/sql/old/8.x/characters/19071_2020_06_17/2019_11_12_00_characters.sql b/sql/old/8.x/characters/19071_2020_06_17/2019_11_12_00_characters.sql
new file mode 100644
index 00000000000..010e1693298
--- /dev/null
+++ b/sql/old/8.x/characters/19071_2020_06_17/2019_11_12_00_characters.sql
@@ -0,0 +1,11 @@
+--
+-- 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/old/8.x/characters/19071_2020_06_17/2019_11_22_00_characters.sql b/sql/old/8.x/characters/19071_2020_06_17/2019_11_22_00_characters.sql
new file mode 100644
index 00000000000..97671dfbbde
--- /dev/null
+++ b/sql/old/8.x/characters/19071_2020_06_17/2019_11_22_00_characters.sql
@@ -0,0 +1,38 @@
+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/old/8.x/characters/19071_2020_06_17/2019_11_30_00_characters.sql b/sql/old/8.x/characters/19071_2020_06_17/2019_11_30_00_characters.sql
new file mode 100644
index 00000000000..70279def138
--- /dev/null
+++ b/sql/old/8.x/characters/19071_2020_06_17/2019_11_30_00_characters.sql
@@ -0,0 +1 @@
+ALTER TABLE `character_aura` ADD `castItemId` int(10) unsigned NOT NULL DEFAULT '0' AFTER `remainCharges`;
diff --git a/sql/old/8.x/characters/19071_2020_06_17/2019_12_05_00_characters.sql b/sql/old/8.x/characters/19071_2020_06_17/2019_12_05_00_characters.sql
new file mode 100644
index 00000000000..647ce02ec86
--- /dev/null
+++ b/sql/old/8.x/characters/19071_2020_06_17/2019_12_05_00_characters.sql
@@ -0,0 +1,15 @@
+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/old/8.x/characters/19071_2020_06_17/2020_02_17_00_characters.sql b/sql/old/8.x/characters/19071_2020_06_17/2020_02_17_00_characters.sql
new file mode 100644
index 00000000000..ed834a9dd6f
--- /dev/null
+++ b/sql/old/8.x/characters/19071_2020_06_17/2020_02_17_00_characters.sql
@@ -0,0 +1,7 @@
+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/old/8.x/characters/19071_2020_06_17/2020_04_20_00_characters.sql b/sql/old/8.x/characters/19071_2020_06_17/2020_04_20_00_characters.sql
new file mode 100644
index 00000000000..689f2ea4b9e
--- /dev/null
+++ b/sql/old/8.x/characters/19071_2020_06_17/2020_04_20_00_characters.sql
@@ -0,0 +1,46 @@
+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/old/8.x/characters/19071_2020_06_17/2020_04_24_00_characters.sql b/sql/old/8.x/characters/19071_2020_06_17/2020_04_24_00_characters.sql
new file mode 100644
index 00000000000..6b7cbbf8496
--- /dev/null
+++ b/sql/old/8.x/characters/19071_2020_06_17/2020_04_24_00_characters.sql
@@ -0,0 +1 @@
+UPDATE `item_instance_azerite` SET `knowledgeLevel`=15;
diff --git a/sql/old/8.x/characters/19071_2020_06_17/2020_04_25_00_characters_2017_04_03_00_characters.sql b/sql/old/8.x/characters/19071_2020_06_17/2020_04_25_00_characters_2017_04_03_00_characters.sql
new file mode 100644
index 00000000000..3a962753a55
--- /dev/null
+++ b/sql/old/8.x/characters/19071_2020_06_17/2020_04_25_00_characters_2017_04_03_00_characters.sql
@@ -0,0 +1,11 @@
+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/old/8.x/characters/19071_2020_06_17/2020_04_26_00_characters_2017_04_12_00_characters.sql b/sql/old/8.x/characters/19071_2020_06_17/2020_04_26_00_characters_2017_04_12_00_characters.sql
new file mode 100644
index 00000000000..5340fbfca3e
--- /dev/null
+++ b/sql/old/8.x/characters/19071_2020_06_17/2020_04_26_00_characters_2017_04_12_00_characters.sql
@@ -0,0 +1,2 @@
+ALTER TABLE `item_loot_money`
+CHANGE `money` `money` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'money loot (in copper)';
diff --git a/sql/old/8.x/characters/19071_2020_06_17/2020_04_26_01_characters_2017_04_12_01_characters.sql b/sql/old/8.x/characters/19071_2020_06_17/2020_04_26_01_characters_2017_04_12_01_characters.sql
new file mode 100644
index 00000000000..ed5617d2750
--- /dev/null
+++ b/sql/old/8.x/characters/19071_2020_06_17/2020_04_26_01_characters_2017_04_12_01_characters.sql
@@ -0,0 +1,4 @@
+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/old/8.x/characters/19071_2020_06_17/2020_06_12_00_characters.sql b/sql/old/8.x/characters/19071_2020_06_17/2020_06_12_00_characters.sql
new file mode 100644
index 00000000000..885111dc1f7
--- /dev/null
+++ b/sql/old/8.x/characters/19071_2020_06_17/2020_06_12_00_characters.sql
@@ -0,0 +1,2 @@
+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`;