diff options
| author | n0n4m3 <none@none> | 2010-04-11 11:38:52 +0400 |
|---|---|---|
| committer | n0n4m3 <none@none> | 2010-04-11 11:38:52 +0400 |
| commit | 5d0c5c244811625224d779b799e2e2a24f35b819 (patch) | |
| tree | e4cb5d2c77edc4bed5dfde5a0a9b24e849441f9e /sql | |
| parent | c03240d79b58c3e30f45b6effdb7b438bd539349 (diff) | |
Fix load spell.dbc, sql table spell_dbc also drop unused fields.
--HG--
branch : trunk
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/7846_world_spell_dbc.sql | 6 | ||||
| -rw-r--r-- | sql/world.sql | 6 |
2 files changed, 6 insertions, 6 deletions
diff --git a/sql/updates/7846_world_spell_dbc.sql b/sql/updates/7846_world_spell_dbc.sql new file mode 100644 index 00000000000..0173fb01c53 --- /dev/null +++ b/sql/updates/7846_world_spell_dbc.sql @@ -0,0 +1,6 @@ +ALTER TABLE spell_dbc DROP EffectBaseDice1; +ALTER TABLE spell_dbc DROP EffectBaseDice2; +ALTER TABLE spell_dbc DROP EffectBaseDice3; +ALTER TABLE spell_dbc DROP EffectDicePerLevel1; +ALTER TABLE spell_dbc DROP EffectDicePerLevel2; +ALTER TABLE spell_dbc DROP EffectDicePerLevel3; diff --git a/sql/world.sql b/sql/world.sql index 4d3f4c5ab91..8cda40b82e2 100644 --- a/sql/world.sql +++ b/sql/world.sql @@ -5118,12 +5118,6 @@ CREATE TABLE `spell_dbc` ( `EffectDieSides1` int(11) NOT NULL DEFAULT '0', `EffectDieSides2` int(11) NOT NULL DEFAULT '0', `EffectDieSides3` int(11) NOT NULL DEFAULT '0', - `EffectBaseDice1` int(11) NOT NULL DEFAULT '0', - `EffectBaseDice2` int(11) NOT NULL DEFAULT '0', - `EffectBaseDice3` int(11) NOT NULL DEFAULT '0', - `EffectDicePerLevel1` float NOT NULL DEFAULT '0', - `EffectDicePerLevel2` float NOT NULL DEFAULT '0', - `EffectDicePerLevel3` float NOT NULL DEFAULT '0', `EffectRealPointsPerLevel1` float NOT NULL DEFAULT '0', `EffectRealPointsPerLevel2` float NOT NULL DEFAULT '0', `EffectRealPointsPerLevel3` float NOT NULL DEFAULT '0', |