Core/Conversations: Fix conversation data handling (#26375)

1 files changed, 9 insertions, 0 deletions

diff --git a/sql/updates/world/master/2021_04_26_00_world.sql b/sql/updates/world/master/2021_04_26_00_world.sql
new file mode 100644
index 00000000000..a796650e5f4
--- /dev/null
+++ b/sql/updates/world/master/2021_04_26_00_world.sql
@@ -0,0 +1,9 @@
+ALTER TABLE `conversation_actors`
+  ADD COLUMN `CreatureId` int(10) unsigned NOT NULL DEFAULT '0' AFTER `Idx`,
+  ADD COLUMN `CreatureDisplayInfoId` int(10) unsigned NOT NULL DEFAULT '0' AFTER `CreatureId`;
+
+UPDATE `conversation_actors` AS ca
+INNER JOIN `conversation_actor_template` AS cat ON (ca.ConversationActorId = cat.Id)
+SET ca.CreatureId = cat.CreatureId, ca.CreatureDisplayInfoId = cat.CreatureModelId;
+
+DROP TABLE `conversation_actor_template`;