From d5e33bf4ba08b4728a06a8a90a1ebb52c831427f Mon Sep 17 00:00:00 2001 From: QAston Date: Sun, 1 Aug 2010 03:23:14 +0200 Subject: *Use spell_ranks table in spell scripts to not duplicate data. --HG-- branch : trunk --- sql/updates/9131_world_spell_ranks.sql | 4 ++++ 1 file changed, 4 insertions(+) create mode 100644 sql/updates/9131_world_spell_ranks.sql (limited to 'sql/updates') diff --git a/sql/updates/9131_world_spell_ranks.sql b/sql/updates/9131_world_spell_ranks.sql new file mode 100644 index 00000000000..7343f38c895 --- /dev/null +++ b/sql/updates/9131_world_spell_ranks.sql @@ -0,0 +1,4 @@ +DELETE FROM spell_ranks WHERE `spell_id` IN (52987, 52988); +INSERT INTO spell_ranks (`first_spell_id`, `spell_id`, `rank`) VALUES +(47757, 52987, 3), +(47757, 52988, 4); -- cgit v1.2.3