aboutsummaryrefslogtreecommitdiff
path: root/sql/updates
diff options
context:
space:
mode:
author_manuel_ <manue.l@live.com.ar>2010-03-21 15:22:40 -0300
committer_manuel_ <manue.l@live.com.ar>2010-03-21 15:22:40 -0300
commite34a7d31347358b298a1d7a36a429eb490c4498b (patch)
tree9431f7827117d8e8cd0ea2f745764b94b3588b49 /sql/updates
parenta4e98f50d0f18e6ae59145aca31a719ff754c703 (diff)
parent2318d74dde1a8ec939a782cf66b31f91a7f83b79 (diff)
Merge
--HG-- branch : trunk
Diffstat (limited to 'sql/updates')
-rw-r--r--sql/updates/7660_world_creature_template.sql3
1 files changed, 3 insertions, 0 deletions
diff --git a/sql/updates/7660_world_creature_template.sql b/sql/updates/7660_world_creature_template.sql
new file mode 100644
index 00000000000..b687511b1a2
--- /dev/null
+++ b/sql/updates/7660_world_creature_template.sql
@@ -0,0 +1,3 @@
+ALTER TABLE creature_template ADD COLUMN speed_run float NOT NULL default '1.14286' COMMENT 'Result of 8.0/7.0, most common value' AFTER speed;
+UPDATE creature_template SET speed=1 WHERE speed IS NULL;
+ALTER TABLE creature_template CHANGE COLUMN speed speed_walk FLOAT NOT NULL DEFAULT '1' COMMENT 'Result of 2.5/2.5, most common value'; \ No newline at end of file