diff options
| author | teacher <none@none> | 2010-03-21 19:57:00 +0100 |
|---|---|---|
| committer | teacher <none@none> | 2010-03-21 19:57:00 +0100 |
| commit | fd3b4ec90827839857a6550bf6c5b5ec4a3d32ea (patch) | |
| tree | 64f8b01c63fb795d2ee37b4d537b9110352db46e | |
| parent | e34a7d31347358b298a1d7a36a429eb490c4498b (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.sql | 2 | ||||
| -rw-r--r-- | sql/updates/7660_world_creature_template.sql | 3 | ||||
| -rw-r--r-- | sql/world.sql | 1 |
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 */; |
