From ee2577dde63a8bf25198d6658fbf65c0c21e39dd Mon Sep 17 00:00:00 2001 From: ModoX Date: Mon, 3 Jul 2023 22:12:33 +0200 Subject: Core/Conversation: Added ChatType field to conversation_line_template --- sql/updates/world/master/2023_07_03_01_world.sql | 13 +++++++++++++ 1 file changed, 13 insertions(+) create mode 100644 sql/updates/world/master/2023_07_03_01_world.sql (limited to 'sql/updates') 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; -- cgit v1.2.3