aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorShauren <shauren.trinity@gmail.com>2021-03-12 22:24:56 +0100
committerShauren <shauren.trinity@gmail.com>2021-03-12 22:24:56 +0100
commit71112d4d169ef192f8c3c9eb1303bdd880336eaa (patch)
tree36624310c8cece29fc26c0c9054225284fd8ee86
parent2bd70b41eb0d2d2aad16ddb17525c2f24acde2c5 (diff)
DB/Spells: Remove serverside spell data for spells that exist in db2
-rw-r--r--sql/updates/world/master/2021_03_12_01_world_serverside_spells_cleanup.sql2
1 files changed, 2 insertions, 0 deletions
diff --git a/sql/updates/world/master/2021_03_12_01_world_serverside_spells_cleanup.sql b/sql/updates/world/master/2021_03_12_01_world_serverside_spells_cleanup.sql
new file mode 100644
index 00000000000..dde59c1ee64
--- /dev/null
+++ b/sql/updates/world/master/2021_03_12_01_world_serverside_spells_cleanup.sql
@@ -0,0 +1,2 @@
+DELETE FROM `serverside_spell` WHERE `Id` IN (34145,62388,5302,29153,31348,34915,35479,41951,77608,77996);
+DELETE FROM `serverside_spell_effect` WHERE `SpellId` IN (34145,62388,5302,29153,31348,34915,35479,41951,77608,77996);