From 112b8799ffdc5288f1b24a4eee0457751bcef047 Mon Sep 17 00:00:00 2001 From: Shauren Date: Fri, 31 Dec 2021 16:14:19 +0100 Subject: DB: Purge mediumint columns from character db (change to full int) --- sql/updates/characters/master/2021_12_31_02_characters.sql | 11 +++++++++++ 1 file changed, 11 insertions(+) create mode 100644 sql/updates/characters/master/2021_12_31_02_characters.sql (limited to 'sql/updates') diff --git a/sql/updates/characters/master/2021_12_31_02_characters.sql b/sql/updates/characters/master/2021_12_31_02_characters.sql new file mode 100644 index 00000000000..2f8a30e8dd7 --- /dev/null +++ b/sql/updates/characters/master/2021_12_31_02_characters.sql @@ -0,0 +1,11 @@ +ALTER TABLE `character_battleground_data` MODIFY `mountSpell` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `character_pet` MODIFY `CreatedBySpell` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `character_spell` MODIFY `spell` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Spell Identifier'; +ALTER TABLE `character_talent` MODIFY `talentId` int(10) unsigned NOT NULL; +ALTER TABLE `character_void_storage` MODIFY `itemEntry` int(10) unsigned NOT NULL; +ALTER TABLE `characters` MODIFY `latency` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `guild_rank` MODIFY `rights` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `item_instance` MODIFY `itemEntry` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `item_instance` MODIFY `flags` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `pet_spell` MODIFY `spell` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Spell Identifier'; +ALTER TABLE `quest_tracker` MODIFY `id` int(10) unsigned NOT NULL DEFAULT '0'; -- cgit v1.2.3