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 | |
| 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')
| -rw-r--r-- | sql/mangos.sql | 15 | ||||
| -rw-r--r-- | sql/updates/4649_world_8250_spell_threat.sql | 3 |
2 files changed, 4 insertions, 14 deletions
diff --git a/sql/mangos.sql b/sql/mangos.sql index fa01abaa8e3..b3f451e44ed 100644 --- a/sql/mangos.sql +++ b/sql/mangos.sql @@ -23,7 +23,7 @@ DROP TABLE IF EXISTS `db_version`; CREATE TABLE `db_version` ( `version` varchar(120) default NULL, `creature_ai_version` varchar(120) default NULL, - `required_8249_02_mangos_spell_chain` bit(1) default NULL + `required_8250_01_mangos_spell_threat` bit(1) default NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Used DB version notes'; -- @@ -18110,7 +18110,6 @@ INSERT INTO `spell_threat` VALUES (284,39), (285,59), (770,108), -(778,108), (1608,78), (1672,180), (1715,61), @@ -18130,10 +18129,8 @@ INSERT INTO `spell_threat` VALUES (8380,180), (8972,118), (9745,148), -(9749,108), (9880,178), (9881,207), -(9907,108), (11556,43), (11564,98), (11565,118), @@ -18146,20 +18143,12 @@ INSERT INTO `spell_threat` VALUES (11600,275), (11601,315), (11775,395), -(14274,200), (14921,415), -(15629,300), -(15630,400), -(15631,500), -(15632,600), (16857,108), (17735,200), (17750,300), (17751,450), (17752,600), -(17390,108), -(17391,108), -(17392,108), (20569,100), (20736,100), (20925,20), @@ -18179,9 +18168,7 @@ INSERT INTO `spell_threat` VALUES (25286,175), (25288,355), (25289,60), -(26993,127), (26996,176), -(27011,127), (27179,54), (29704,230), (29707,196), 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 |