aboutsummaryrefslogtreecommitdiff
path: root/sql/base/characters_database.sql
diff options
context:
space:
mode:
authorShauren <shauren.trinity@gmail.com>2024-04-09 12:55:31 +0200
committerShauren <shauren.trinity@gmail.com>2024-04-09 12:55:31 +0200
commit9ac03bf2b84f15f70bf37481cf563dcfe3cac626 (patch)
tree81011f0156f4d663e5c5523b5de74c80446ebb3b /sql/base/characters_database.sql
parentb1b16cc139b6b3cfc68e212eb1cadd5fcacaa007 (diff)
DB: Drop columns unused for almost 8 years
Diffstat (limited to 'sql/base/characters_database.sql')
-rw-r--r--sql/base/characters_database.sql5
1 files changed, 2 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;