diff options
| author | Shauren <shauren.trinity@gmail.com> | 2024-04-09 12:55:31 +0200 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2024-04-09 12:55:31 +0200 |
| commit | 9ac03bf2b84f15f70bf37481cf563dcfe3cac626 (patch) | |
| tree | 81011f0156f4d663e5c5523b5de74c80446ebb3b | |
| parent | b1b16cc139b6b3cfc68e212eb1cadd5fcacaa007 (diff) | |
DB: Drop columns unused for almost 8 years
| -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 f5806f977f6..4bd698adac4 100644 --- a/sql/base/characters_database.sql +++ b/sql/base/characters_database.sql @@ -2706,8 +2706,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', @@ -3724,7 +3722,8 @@ INSERT INTO `updates` VALUES ('2023_11_02_00_characters.sql','1A76A843F204901C8598DA5682029E815477E427','ARCHIVED','2023-11-02 18:59:41',0), ('2023_11_09_00_characters.sql','1A3D7CA6890353DA55793FE8D925CC8C54965A69','ARCHIVED','2023-11-09 00:56:31',0), ('2023_11_15_00_characters.sql','441E0F17DE3E3945307AC400DF86FCDF06C61653','ARCHIVED','2023-11-15 00:53:47',0), -('2024_02_08_00_characters.sql','743A11042AA17CDBD5F3D510D24509A10838DB5A','ARCHIVED','2024-02-08 00:56:26',0); +('2024_02_08_00_characters.sql','743A11042AA17CDBD5F3D510D24509A10838DB5A','ARCHIVED','2024-02-08 00:56: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; |