diff options
| -rw-r--r-- | sql/base/characters_database.sql | 5 | ||||
| -rw-r--r-- | sql/updates/characters/master/2024_04_09_00_characters.sql | 15 |
2 files changed, 17 insertions, 3 deletions
diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql index 759f207e814..7fa54e7707f 100644 --- a/sql/base/characters_database.sql +++ b/sql/base/characters_database.sql @@ -2574,8 +2574,6 @@ CREATE TABLE `item_instance` ( `durability` smallint unsigned NOT NULL DEFAULT '0', `playedTime` int unsigned NOT NULL DEFAULT '0', `text` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, - `transmogrification` int unsigned NOT NULL DEFAULT '0', - `enchantIllusion` int unsigned NOT NULL DEFAULT '0', `battlePetSpeciesId` int unsigned NOT NULL DEFAULT '0', `battlePetBreedData` int unsigned NOT NULL DEFAULT '0', `battlePetLevel` smallint unsigned NOT NULL DEFAULT '0', @@ -3476,7 +3474,8 @@ INSERT INTO `updates` VALUES ('2024_02_08_00_characters.sql','743A11042AA17CDBD5F3D510D24509A10838DB5A','RELEASED','2024-02-08 00:56:26',0), ('2024_03_12_00_characters.sql','C91A51EA86C26F3AB60445FE147B0E4B220716A0','RELEASED','2024-03-13 17:10:46',0), ('2024_03_13_00_characters.sql','6360F50059E5DB1F248FA8A270CDC4788A03A0EC','RELEASED','2024-03-13 17:10:46',0), -('2024_03_19_00_characters.sql','1D200630578074A4E3A373F891323DB867D00B02','RELEASED','2024-03-19 19:59:26',0); +('2024_03_19_00_characters.sql','1D200630578074A4E3A373F891323DB867D00B02','RELEASED','2024-03-19 19:59:26',0), +('2024_04_09_00_characters.sql','07AC79B4E489B1CD073852EC57D12939C2A1D4B1','RELEASED','2024-04-09 12:54:11',0); /*!40000 ALTER TABLE `updates` ENABLE KEYS */; UNLOCK TABLES; 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; |