Core/PacketIO: Updated packet structures to 9.2.0

1 files changed, 14 insertions, 0 deletions

diff --git a/sql/updates/world/master/2022_02_22_00_world.sql b/sql/updates/world/master/2022_02_22_00_world.sql
new file mode 100644
index 00000000000..91036b68b79
--- /dev/null
+++ b/sql/updates/world/master/2022_02_22_00_world.sql
@@ -0,0 +1,14 @@
+ALTER TABLE `areatrigger_create_properties` 
+  ADD `ShapeData6` float NOT NULL DEFAULT 0 AFTER `ShapeData5`,
+  ADD `ShapeData7` float NOT NULL DEFAULT 0 AFTER `ShapeData6`;
+
+ALTER TABLE `areatrigger_template` 
+  ADD `Data6` float NOT NULL DEFAULT 0 AFTER `Data5`,
+  ADD `Data7` float NOT NULL DEFAULT 0 AFTER `Data6`;
+
+ALTER TABLE `gossip_menu_option` ADD `Language` int unsigned NOT NULL DEFAULT 0 AFTER `OptionNpcFlag`;
+
+ALTER TABLE `playerchoice`
+  ADD `CloseSoundKitId` int unsigned NOT NULL DEFAULT 0 AFTER `SoundKitId`,
+  ADD `Duration` bigint NOT NULL DEFAULT 0 AFTER `CloseSoundKitId`,
+  ADD `PendingChoiceText` VARCHAR(255) NOT NULL DEFAULT '' AFTER `Duration`;