diff options
Diffstat (limited to 'sql/updates')
| -rw-r--r-- | sql/updates/world/master/2023_07_03_01_world.sql | 13 |
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; |