From fd3b4ec90827839857a6550bf6c5b5ec4a3d32ea Mon Sep 17 00:00:00 2001 From: teacher Date: Sun, 21 Mar 2010 19:57:00 +0100 Subject: Added missing sql file for rev 7656 (by Machiavelli). Removed DB content data from previous commit. --HG-- branch : trunk --- sql/updates/7656_world_instance_template.sql | 2 ++ sql/updates/7660_world_creature_template.sql | 3 +-- 2 files changed, 3 insertions(+), 2 deletions(-) create mode 100644 sql/updates/7656_world_instance_template.sql (limited to 'sql/updates') diff --git a/sql/updates/7656_world_instance_template.sql b/sql/updates/7656_world_instance_template.sql new file mode 100644 index 00000000000..54d50b04e3f --- /dev/null +++ b/sql/updates/7656_world_instance_template.sql @@ -0,0 +1,2 @@ +ALTER TABLE `instance_template` ADD COLUMN `allowMount` tinyint(1) NOT NULL DEFAULT '0'; + diff --git a/sql/updates/7660_world_creature_template.sql b/sql/updates/7660_world_creature_template.sql index b687511b1a2..a21be0dfb86 100644 --- a/sql/updates/7660_world_creature_template.sql +++ b/sql/updates/7660_world_creature_template.sql @@ -1,3 +1,2 @@ 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 +ALTER TABLE creature_template CHANGE COLUMN speed speed_walk FLOAT NOT NULL DEFAULT '1' COMMENT 'Result of 2.5/2.5, most common value'; -- cgit v1.2.3