Core/Spells: Improved spell category cooldown handling

* Category cooldown is stored with the spell that started the cooldown (and only resetting cooldown on that spell will clear cooldowns on entire category - this fully mirrors client behavior)
* This significantly reduces the amount of data saved to database for cooldowns
* Spell casts from items that have a different category specified than on spell will now check for cooldown during the cast

Closes #15349

1 files changed, 7 insertions, 0 deletions

diff --git a/sql/updates/characters/2015_09_10_00_characters.sql b/sql/updates/characters/2015_09_10_00_characters.sql
new file mode 100644
index 00000000000..94c9066c6ae
--- /dev/null
+++ b/sql/updates/characters/2015_09_10_00_characters.sql
@@ -0,0 +1,7 @@
+ALTER TABLE `character_spell_cooldown`
+  ADD `categoryId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Spell category Id' AFTER `time`,
+  ADD `categoryEnd` int(10) unsigned NOT NULL DEFAULT '0' AFTER `categoryId`;
+
+ALTER TABLE `pet_spell_cooldown`
+  ADD `categoryId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Spell category Id' AFTER `time`,
+  ADD `categoryEnd` int(10) unsigned NOT NULL DEFAULT '0' AFTER `categoryId`;