Core/PacketIO: Updated opcodes and packet structures to 7.3.5

2 files changed, 15 insertions, 0 deletions

diff --git a/sql/updates/characters/master/2018_02_08_00_characters.sql b/sql/updates/characters/master/2018_02_08_00_characters.sql
new file mode 100644
index 00000000000..5e8f8dbac02
--- /dev/null
+++ b/sql/updates/characters/master/2018_02_08_00_characters.sql
@@ -0,0 +1 @@
+ALTER TABLE `characters` ADD `lastLoginBuild` int(10) unsigned NOT NULL DEFAULT '0' AFTER `honorRestBonus`;
diff --git a/sql/updates/world/master/2018_02_08_00_world.sql b/sql/updates/world/master/2018_02_08_00_world.sql
new file mode 100644
index 00000000000..181eb7991f4
--- /dev/null
+++ b/sql/updates/world/master/2018_02_08_00_world.sql
@@ -0,0 +1,14 @@
+ALTER TABLE `guild_rewards` CHANGE `RaceMask` `RaceMask` bigint(20) unsigned DEFAULT '0';
+
+ALTER TABLE `playerchoice`
+  ADD `UiTextureKitId` int(11) NOT NULL DEFAULT '0' AFTER `ChoiceId`,
+  ADD `HideWarboardHeader` tinyint(1) NOT NULL DEFAULT '0' AFTER `Question`;
+
+ALTER TABLE `quest_poi` ADD `AlwaysAllowMergingBlobs` tinyint(1) unsigned NOT NULL DEFAULT '0' AFTER `WoDUnk1`;
+
+ALTER TABLE `quest_template`
+  ADD `MaxScalingLevel` int(11) NOT NULL DEFAULT '255' AFTER `QuestLevel`,
+  CHANGE `AllowableRaces` `AllowableRaces` bigint(20) unsigned NOT NULL DEFAULT 0xFFFFFFFFFFFFFFFF;
+
+RENAME TABLE `race_expansion_requirement` TO `race_unlock_requirement`;
+ALTER TABLE `race_unlock_requirement` ADD `achievementId` int(10) unsigned NOT NULL DEFAULT '0';