From 390257b2f6d4d4b03a3226a39b478b3ea92b4dea Mon Sep 17 00:00:00 2001
From: Anubisss <none@none>
Date: Thu, 27 Aug 2009 01:49:02 +0200
Subject: *Delete table spell_affect's structure from world.sql *If you didnt
 drop it just run: 4542_8191_world_spell_affect.sql from sql's updates.

--HG--
branch : trunk
---
 sql/world.sql | 17 -----------------
 1 file changed, 17 deletions(-)

(limited to 'sql/world.sql')

diff --git a/sql/world.sql b/sql/world.sql
index 94d3658aa89..e4ee3ea2b3a 100644
--- a/sql/world.sql
+++ b/sql/world.sql
@@ -2704,23 +2704,6 @@ CREATE TABLE `skinning_loot_template` (
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Loot System';
 SET character_set_client = @saved_cs_client;
 
---
--- Table structure for table `spell_affect`
---
-
-DROP TABLE IF EXISTS `spell_affect`;
-SET @saved_cs_client     = @@character_set_client;
-SET character_set_client = utf8;
-CREATE TABLE `spell_affect` (
-  `entry` smallint(5) unsigned NOT NULL default '0',
-  `effectId` tinyint(3) unsigned NOT NULL default '0',
-  `SpellClassMask0` int(5) unsigned NOT NULL default '0',
-  `SpellClassMask1` int(5) unsigned NOT NULL default '0',
-  `SpellClassMask2` int(5) unsigned NOT NULL default '0',
-  PRIMARY KEY  (`entry`,`effectId`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-SET character_set_client = @saved_cs_client;
-
 --
 -- Table structure for table `spell_area`
 --
-- 
cgit v1.2.3

