From f481e7b14db88700631c01c58b23a1a2f7f4efb6 Mon Sep 17 00:00:00 2001
From: megamage <none@none>
Date: Thu, 23 Jul 2009 09:30:05 +0800
Subject:     [8191] Drop code related to use long time empty `spell_affect`
 table. Author: XTZGZoReX

    After switch to 3.x.x all data get explcitly from ClassMask fields in spell.dbc
    and no need in custom values.

--HG--
branch : trunk
---
 sql/FULL/world_spell_full.sql                |  8 --------
 sql/mangos.sql                               | 25 +------------------------
 sql/updates/4542_8191_world_spell_affect.sql |  3 +++
 3 files changed, 4 insertions(+), 32 deletions(-)
 create mode 100644 sql/updates/4542_8191_world_spell_affect.sql

(limited to 'sql')

diff --git a/sql/FULL/world_spell_full.sql b/sql/FULL/world_spell_full.sql
index 006373cddf1..667b2346950 100644
--- a/sql/FULL/world_spell_full.sql
+++ b/sql/FULL/world_spell_full.sql
@@ -1923,14 +1923,6 @@ INSERT INTO `spell_elixir` (`entry`, `mask`) VALUES
 (60347, 0x2),
 (62380, 0x3);
 
--- --------
--- SPELL AFFECT
--- --------
-
-TRUNCATE TABLE `spell_affect`;
-INSERT INTO `spell_affect` (`entry`, `effectId`, `SpellClassMask0`, `SpellClassMask1`, `SpellClassMask2`) VALUES
-(44544,0,685904631,1151048,0); -- Fingers of frost
-
 -- --------
 -- Death Knight
 -- --------
diff --git a/sql/mangos.sql b/sql/mangos.sql
index 7d551217827..ed429442af9 100644
--- a/sql/mangos.sql
+++ b/sql/mangos.sql
@@ -23,7 +23,7 @@ DROP TABLE IF EXISTS `db_version`;
 CREATE TABLE `db_version` (
   `version` varchar(120) default NULL,
   `creature_ai_version` varchar(120) default NULL,
-  `required_8190_01_mangos_creature_template` bit(1) default NULL
+  `required_8191_01_mangos_spell_affect` bit(1) default NULL
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Used DB version notes';
 
 --
@@ -13541,29 +13541,6 @@ LOCK TABLES `skinning_loot_template` WRITE;
 /*!40000 ALTER TABLE `skinning_loot_template` ENABLE KEYS */;
 UNLOCK TABLES;
 
---
--- Table structure for table `spell_affect`
---
-
-DROP TABLE IF EXISTS `spell_affect`;
-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;
-
---
--- Dumping data for table `spell_affect`
---
-
-LOCK TABLES `spell_affect` WRITE;
-/*!40000 ALTER TABLE `spell_affect` DISABLE KEYS */;
-/*!40000 ALTER TABLE `spell_affect` ENABLE KEYS */;
-UNLOCK TABLES;
-
 --
 -- Table structure for table `spell_area`
 --
diff --git a/sql/updates/4542_8191_world_spell_affect.sql b/sql/updates/4542_8191_world_spell_affect.sql
new file mode 100644
index 00000000000..74e28a00b59
--- /dev/null
+++ b/sql/updates/4542_8191_world_spell_affect.sql
@@ -0,0 +1,3 @@
+-- ALTER TABLE db_version CHANGE COLUMN required_8190_01_mangos_creature_template required_8191_01_mangos_spell_affect bit;
+
+DROP TABLE IF EXISTS `spell_affect`;
-- 
cgit v1.2.3