diff options
| author | megamage <none@none> | 2009-07-23 09:30:05 +0800 |
|---|---|---|
| committer | megamage <none@none> | 2009-07-23 09:30:05 +0800 |
| commit | f481e7b14db88700631c01c58b23a1a2f7f4efb6 (patch) | |
| tree | a0f9d08fec1f7e2a69782d4902b378da7ffb3634 /sql/mangos.sql | |
| parent | e79656b75a3a4272f25457b11856f8ca9df29ba4 (diff) | |
[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
Diffstat (limited to 'sql/mangos.sql')
| -rw-r--r-- | sql/mangos.sql | 25 |
1 files changed, 1 insertions, 24 deletions
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'; -- @@ -13542,29 +13542,6 @@ LOCK TABLES `skinning_loot_template` WRITE; 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` -- |