From 9ac03bf2b84f15f70bf37481cf563dcfe3cac626 Mon Sep 17 00:00:00 2001
From: Shauren <shauren.trinity@gmail.com>
Date: Tue, 9 Apr 2024 12:55:31 +0200
Subject: DB: Drop columns unused for almost 8 years

---
 .../characters/master/2024_04_09_00_characters.sql        | 15 +++++++++++++++
 1 file changed, 15 insertions(+)
 create mode 100644 sql/updates/characters/master/2024_04_09_00_characters.sql

(limited to 'sql/updates')

diff --git a/sql/updates/characters/master/2024_04_09_00_characters.sql b/sql/updates/characters/master/2024_04_09_00_characters.sql
new file mode 100644
index 00000000000..7a9f88bbf5f
--- /dev/null
+++ b/sql/updates/characters/master/2024_04_09_00_characters.sql
@@ -0,0 +1,15 @@
+DELIMITER ;;
+CREATE PROCEDURE item_instance_deprecated_columns_2024_04_09_00() BEGIN
+  IF EXISTS (SELECT * FROM `information_schema`.`columns` WHERE `table_schema`=SCHEMA() AND `table_name`='item_instance' AND `column_name`='transmogrification') THEN
+
+    ALTER TABLE `item_instance` 
+      DROP `transmogrification`,
+      DROP `enchantIllusion`;
+
+  END IF;
+END;;
+
+DELIMITER ;
+CALL item_instance_deprecated_columns_2024_04_09_00();
+
+DROP PROCEDURE IF EXISTS item_instance_deprecated_columns_2024_04_09_00;
-- 
cgit v1.2.3