aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorjackpoz <giacomopoz@gmail.com>2014-08-05 00:28:39 +0200
committerjackpoz <giacomopoz@gmail.com>2014-08-05 00:28:39 +0200
commit6c7ad9bc0bc35c6b948de484a4dfe9ff0687fad9 (patch)
treefe26ce1ed36145f41c938ce7d20a96bf9f224544
parent818ffd47e1abae0602abc1aa7f5b647fb6b76fe5 (diff)
Delete 2014_08_03_03_world_creature_template.sql
-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;