Core/Conversation: Added ChatType field to conversation_line_template

1 files changed, 13 insertions, 0 deletions

diff --git a/sql/updates/world/master/2023_07_03_01_world.sql b/sql/updates/world/master/2023_07_03_01_world.sql
new file mode 100644
index 00000000000..00a5ab8b2ba
--- /dev/null
+++ b/sql/updates/world/master/2023_07_03_01_world.sql
@@ -0,0 +1,13 @@
+DROP PROCEDURE IF EXISTS apply_if_not_exists_2023_07_03_01_world;
+
+DELIMITER ;;
+CREATE PROCEDURE apply_if_not_exists_2023_07_03_01_world() BEGIN
+  IF NOT EXISTS (SELECT * FROM `information_schema`.`columns` WHERE `table_schema`=SCHEMA() AND `table_name`='conversation_line_template' AND `column_name`='ChatType') THEN
+    ALTER TABLE `conversation_line_template` ADD COLUMN `ChatType` tinyint UNSIGNED NOT NULL DEFAULT 0 AFTER `Flags`;
+  END IF;
+END;;
+
+DELIMITER ;
+CALL apply_if_not_exists_2023_07_03_01_world;
+
+DROP PROCEDURE IF EXISTS apply_if_not_exists_2023_07_03_01_world;