diff options
| author | megamage <none@none> | 2009-07-30 11:37:08 +0800 |
|---|---|---|
| committer | megamage <none@none> | 2009-07-30 11:37:08 +0800 |
| commit | af2d5e3fd4a57147280d265d1bc5ac1c2b70a3a3 (patch) | |
| tree | eddb20436980a4ce6be2d5d623fa25d2a653d653 /sql/updates | |
| parent | 7121d98480d58a4214abcc2e22f678bad76cdecf (diff) | |
[8250] Cleanup code and data for `spell_threat` Author: nos4r2zod
* Load table data to std::map instead SQLStorage and add check loaded spell existance.
* Drop from table not existed spells.
--HG--
branch : trunk
Diffstat (limited to 'sql/updates')
| -rw-r--r-- | sql/updates/4649_world_8250_spell_threat.sql | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/sql/updates/4649_world_8250_spell_threat.sql b/sql/updates/4649_world_8250_spell_threat.sql new file mode 100644 index 00000000000..a19513363bd --- /dev/null +++ b/sql/updates/4649_world_8250_spell_threat.sql @@ -0,0 +1,3 @@ +-- ALTER TABLE db_version CHANGE COLUMN required_8249_02_mangos_spell_chain required_8250_01_mangos_spell_threat bit; + +DELETE FROM `spell_threat` WHERE `entry` IN (778,9749,9907,14274,15629,15630,15631,15632,17390,17391,17392,26993,27011);
\ No newline at end of file |