From 33ab88ac96c49ae02961158d82e4a55774101ccb Mon Sep 17 00:00:00 2001 From: Shauren Date: Tue, 9 Apr 2024 12:55:31 +0200 Subject: DB: Drop columns unused for almost 8 years (cherry picked from commit 9ac03bf2b84f15f70bf37481cf563dcfe3cac626) # Conflicts: # sql/base/characters_database.sql --- sql/base/characters_database.sql | 5 ++--- 1 file changed, 2 insertions(+), 3 deletions(-) (limited to 'sql/base') 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; -- cgit v1.2.3