diff options
| -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 */; |