aboutsummaryrefslogtreecommitdiff
path: root/sql/updates
diff options
context:
space:
mode:
authorQAston <none@none>2010-08-01 03:23:14 +0200
committerQAston <none@none>2010-08-01 03:23:14 +0200
commitd5e33bf4ba08b4728a06a8a90a1ebb52c831427f (patch)
tree80c916ae61bcff7af9be6e29b1d48fad609e7883 /sql/updates
parent4f3093f5e5f1132951f1bb89d7a221ca06eef912 (diff)
*Use spell_ranks table in spell scripts to not duplicate data.
--HG-- branch : trunk
Diffstat (limited to 'sql/updates')
-rw-r--r--sql/updates/9131_world_spell_ranks.sql4
1 files changed, 4 insertions, 0 deletions
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);