From 390257b2f6d4d4b03a3226a39b478b3ea92b4dea Mon Sep 17 00:00:00 2001 From: Anubisss 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