From ba9197236c3d295d868fa36d6564c8f8f8fbff9e Mon Sep 17 00:00:00 2001 From: Brian Date: Sun, 31 Jan 2010 13:19:43 -0700 Subject: * Backed out changeset af19f9ff6dd8 * Spell ranks are handled by the (imagine this) spell_ranks table * Data already in spell_ranks for these spells * Thanks QAston --HG-- branch : trunk --- sql/updates/7270_world_spell_required.sql | 6 ------ sql/world.sql | 4 ---- 2 files changed, 10 deletions(-) delete mode 100644 sql/updates/7270_world_spell_required.sql (limited to 'sql') diff --git a/sql/updates/7270_world_spell_required.sql b/sql/updates/7270_world_spell_required.sql deleted file mode 100644 index 828e1d22333..00000000000 --- a/sql/updates/7270_world_spell_required.sql +++ /dev/null @@ -1,6 +0,0 @@ --- adding spell requied for Totem of Wrath-Rank 2,3,4 -DELETE FROM `spell_required` WHERE `spell_id` IN (57720,57721,57722); -INSERT INTO `spell_required` (`spell_id`,`req_spell`) VALUES -(57720,30706), -- Totem of Wrath rank 2 (must know rank 1) -(57721,57720), -- Totem of Wrath rank 3 (must know rank 2) -(57722,57721); -- Totem of Wrath rank 4 (must know rank 3) diff --git a/sql/world.sql b/sql/world.sql index f272b47d750..27bc5244405 100644 --- a/sql/world.sql +++ b/sql/world.sql @@ -6654,10 +6654,6 @@ CREATE TABLE `spell_required` ( LOCK TABLES `spell_required` WRITE; /*!40000 ALTER TABLE `spell_required` DISABLE KEYS */; -INSERT INTO `spell_required` (`spell_id`,`req_spell`) VALUES -(57720,30706), -- Totem of Wrath rank 2 (must know rank 1) -(57721,57720), -- Totem of Wrath rank 3 (must know rank 2) -(57722,57721); -- Totem of Wrath rank 4 (must know rank 3) /*!40000 ALTER TABLE `spell_required` ENABLE KEYS */; UNLOCK TABLES; -- cgit v1.2.3