aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/7846_world_spell_dbc.sql6
-rw-r--r--sql/world.sql6
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',