aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorteacher <none@none>2010-03-21 19:57:00 +0100
committerteacher <none@none>2010-03-21 19:57:00 +0100
commitfd3b4ec90827839857a6550bf6c5b5ec4a3d32ea (patch)
tree64f8b01c63fb795d2ee37b4d537b9110352db46e
parente34a7d31347358b298a1d7a36a429eb490c4498b (diff)
Added missing sql file for rev 7656 (by Machiavelli).
Removed DB content data from previous commit. --HG-- branch : trunk
-rw-r--r--sql/updates/7656_world_instance_template.sql2
-rw-r--r--sql/updates/7660_world_creature_template.sql3
-rw-r--r--sql/world.sql1
3 files changed, 4 insertions, 2 deletions
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';
diff --git a/sql/world.sql b/sql/world.sql
index 55257a3713a..1ac1ee4e7e9 100644
--- a/sql/world.sql
+++ b/sql/world.sql
@@ -2644,6 +2644,7 @@ CREATE TABLE `instance_template` (
`startLocZ` float DEFAULT NULL,
`startLocO` float DEFAULT NULL,
`script` varchar(128) NOT NULL DEFAULT '',
+ `allowMount` tinyint(1) NOT NULL DEFAULT '0';
PRIMARY KEY (`map`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;