Core/PacketIO: Updated packet structures to 8.1.5

2 files changed, 19 insertions, 0 deletions

diff --git a/sql/updates/auth/master/2019_06_08_00_auth.sql b/sql/updates/auth/master/2019_06_08_00_auth.sql
new file mode 100644
index 00000000000..a979ce76fe6
--- /dev/null
+++ b/sql/updates/auth/master/2019_06_08_00_auth.sql
@@ -0,0 +1 @@
+ALTER TABLE `battlenet_account_toys` ADD `hasFanfare` tinyint(1) DEFAULT '0' AFTER `isFavourite`;
diff --git a/sql/updates/world/master/2019_06_08_00_world.sql b/sql/updates/world/master/2019_06_08_00_world.sql
new file mode 100644
index 00000000000..a2538fa77f8
--- /dev/null
+++ b/sql/updates/world/master/2019_06_08_00_world.sql
@@ -0,0 +1,18 @@
+ALTER TABLE `creature_template`
+  ADD `FadeRegionRadius` float NOT NULL DEFAULT '0' AFTER `movementId`,
+  ADD `WidgetSetID` int(11) NOT NULL DEFAULT '0' AFTER `FadeRegionRadius`,
+  ADD `WidgetSetUnitConditionID` int(11) NOT NULL DEFAULT '0' AFTER `WidgetSetID`;
+
+ALTER TABLE `playerchoice` ADD `SoundKitId` int(10) unsigned NOT NULL DEFAULT '0' AFTER `UiTextureKitId`;
+ALTER TABLE `playerchoice_response`
+  ADD `UiTextureAtlasElementID` int(10) unsigned NOT NULL DEFAULT '0' AFTER `WidgetSetID`,
+  ADD `SoundKitID` int(10) unsigned NOT NULL DEFAULT '0' AFTER `UiTextureAtlasElementID`,
+  ADD `SubHeader` varchar(100) NOT NULL DEFAULT '' AFTER `Header`,
+  ADD `ButtonTooltip` varchar(400) NOT NULL DEFAULT '' AFTER `SubHeader`,
+  ADD `RewardQuestID` int(10) unsigned DEFAULT NULL AFTER `Confirmation`;
+
+ALTER TABLE `playerchoice_response_locale`
+  ADD `SubHeader` varchar(100) NOT NULL DEFAULT '' AFTER `Header`,
+  ADD `ButtonTooltip` varchar(400) NOT NULL DEFAULT '' AFTER `SubHeader`;
+
+ALTER TABLE `quest_template` ADD `ManagedWorldStateID` int(11) NOT NULL DEFAULT '0' AFTER `Expansion`;