diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/base/world_database.sql | 25 | ||||
| -rw-r--r-- | sql/updates/9578_world_vehicle_scaling_info.sql | 7 |
2 files changed, 32 insertions, 0 deletions
diff --git a/sql/base/world_database.sql b/sql/base/world_database.sql index 5857baec290..7c9b38ecdb4 100644 --- a/sql/base/world_database.sql +++ b/sql/base/world_database.sql @@ -15801,6 +15801,31 @@ LOCK TABLES `vehicle_accessory` WRITE; /*!40000 ALTER TABLE `vehicle_accessory` DISABLE KEYS */; /*!40000 ALTER TABLE `vehicle_accessory` ENABLE KEYS */; UNLOCK TABLES; + +-- +-- Table structure for table `vehicle_scaling_info` +-- + +DROP TABLE IF EXISTS `vehicle_scaling_info`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `vehicle_scaling_info` ( + `entry` mediumint(8) unsigned NOT NULL default '0', + `baseItemLevel` float NOT NULL default '0', + `scalingFactor` float NOT NULL default '0', + PRIMARY KEY (`entry`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Dumping data for table `vehicle_scaling_info` +-- + +LOCK TABLES `vehicle_scaling_info` WRITE; +/*!40000 ALTER TABLE `vehicle_scaling_info` DISABLE KEYS */; +/*!40000 ALTER TABLE `vehicle_scaling_info` ENABLE KEYS */; +UNLOCK TABLES; + -- -- Table structure for table `version` -- diff --git a/sql/updates/9578_world_vehicle_scaling_info.sql b/sql/updates/9578_world_vehicle_scaling_info.sql new file mode 100644 index 00000000000..88eabb88cb0 --- /dev/null +++ b/sql/updates/9578_world_vehicle_scaling_info.sql @@ -0,0 +1,7 @@ +DROP TABLE IF EXISTS `vehicle_scaling_info`; +CREATE TABLE `vehicle_scaling_info` ( + `entry` mediumint(8) unsigned NOT NULL default '0', + `baseItemLevel` float NOT NULL default '0', + `scalingFactor` float NOT NULL default '0', + PRIMARY KEY (`entry`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED; |