aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorAnubisss <none@none>2009-08-27 01:49:02 +0200
committerAnubisss <none@none>2009-08-27 01:49:02 +0200
commit390257b2f6d4d4b03a3226a39b478b3ea92b4dea (patch)
treefb038a797d04f51b1419d2dac9494545523e2089
parent185219d0879c1cac563b3f87d1f8fa034f80f695 (diff)
*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
-rw-r--r--sql/world.sql17
1 files changed, 0 insertions, 17 deletions
diff --git a/sql/world.sql b/sql/world.sql
index 94d3658aa89..e4ee3ea2b3a 100644
--- a/sql/world.sql
+++ b/sql/world.sql
@@ -2705,23 +2705,6 @@ CREATE TABLE `skinning_loot_template` (
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`
--