aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
author_manuel_ <manue.l@live.com.ar>2010-03-21 15:07:13 -0300
committer_manuel_ <manue.l@live.com.ar>2010-03-21 15:07:13 -0300
commit2318d74dde1a8ec939a782cf66b31f91a7f83b79 (patch)
tree53b54a2da6058b295ce508989c169c70be6d1a29 /sql
parentfae77f26210b4090271bb9227083c8c5240b715c (diff)
Added missing sql for last commit.
--HG-- branch : trunk
Diffstat (limited to 'sql')
-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