diff options
| author | Shauren <shauren.trinity@gmail.com> | 2024-04-09 12:55:31 +0200 |
|---|---|---|
| committer | Ovahlord <dreadkiller@gmx.de> | 2024-05-28 16:40:14 +0200 |
| commit | 33ab88ac96c49ae02961158d82e4a55774101ccb (patch) | |
| tree | 3771ad4c18069cd0a62bde6c7cbe5b7384541b66 /sql/base | |
| parent | 0b57e7980d1551d2d1a7e512762046692f0af783 (diff) | |
DB: Drop columns unused for almost 8 years
(cherry picked from commit 9ac03bf2b84f15f70bf37481cf563dcfe3cac626)
# Conflicts:
# sql/base/characters_database.sql
Diffstat (limited to 'sql/base')
| -rw-r--r-- | sql/base/characters_database.sql | 5 |
1 files changed, 2 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; |