aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorShauren <shauren.trinity@gmail.com>2014-08-04 23:53:27 +0200
committerShauren <shauren.trinity@gmail.com>2014-08-04 23:53:27 +0200
commitd3c6a03c3b17bbd5f36abb3ce40dd09451e4757b (patch)
treefe26ce1ed36145f41c938ce7d20a96bf9f224544
parent50338edac55b24c49cd9dc6d544380441a875e5d (diff)
Delete 2014_08_03_03_world_creature_template_sql
This must come together with proper damage calculations in core - to be done
-rw-r--r--sql/updates/world/2014_08_03_03_world_creature_template_sql14
1 files changed, 0 insertions, 14 deletions
diff --git a/sql/updates/world/2014_08_03_03_world_creature_template_sql b/sql/updates/world/2014_08_03_03_world_creature_template_sql
deleted file mode 100644
index 3d71dd0e289..00000000000
--- a/sql/updates/world/2014_08_03_03_world_creature_template_sql
+++ /dev/null
@@ -1,14 +0,0 @@
--- Update creature_template damage
-ALTER TABLE creature_template CHANGE dmg_multiplier Damage_mod FLOAT NOT NULL DEFAULT 1 AFTER Mana_mod;
-ALTER TABLE creature_template ADD Experience_mod FLOAT NOT NULL DEFAULT 1 AFTER Damage_mod;
-ALTER TABLE creature_template CHANGE baseattacktime Base_attacktime int(10) NOT NULL DEFAULT 0;
-ALTER TABLE creature_template CHANGE rangeattacktime Range_attacktime int(10) NOT NULL DEFAULT 0;
-ALTER TABLE creature_template ADD Base_variance FLOAT NOT NULL DEFAULT 0 AFTER Base_attacktime;
-ALTER TABLE creature_template ADD Range_variance FLOAT NOT NULL DEFAULT 0 AFTER Range_attacktime;
-
-ALTER TABLE creature_template DROP COLUMN mindmg;
-ALTER TABLE creature_template DROP COLUMN maxdmg;
-ALTER TABLE creature_template DROP COLUMN attackpower;
-ALTER TABLE creature_template DROP COLUMN minrangedmg;
-ALTER TABLE creature_template DROP COLUMN maxrangedmg;
-ALTER TABLE creature_template DROP COLUMN rangedattackpower;