diff options
| -rw-r--r-- | sql/base/dev/world_database.sql | 27 |
1 files changed, 12 insertions, 15 deletions
diff --git a/sql/base/dev/world_database.sql b/sql/base/dev/world_database.sql index 633b59e0556..3224b5b73a7 100644 --- a/sql/base/dev/world_database.sql +++ b/sql/base/dev/world_database.sql @@ -519,13 +519,11 @@ CREATE TABLE `creature_template` ( `speed_run` float NOT NULL DEFAULT '1.14286' COMMENT 'Result of 8.0/7.0, most common value', `scale` float NOT NULL DEFAULT '1', `rank` tinyint(3) unsigned NOT NULL DEFAULT '0', - `mindmg` float NOT NULL DEFAULT '0', - `maxdmg` float NOT NULL DEFAULT '0', `dmgschool` tinyint(4) NOT NULL DEFAULT '0', - `attackpower` int(10) unsigned NOT NULL DEFAULT '0', - `dmg_multiplier` float NOT NULL DEFAULT '1', - `baseattacktime` int(10) unsigned NOT NULL DEFAULT '0', - `rangeattacktime` int(10) unsigned NOT NULL DEFAULT '0', + `BaseAttackTime` int(10) unsigned NOT NULL DEFAULT '0', + `RangeAttackTime` int(10) unsigned NOT NULL DEFAULT '0', + `BaseVariance` float NOT NULL DEFAULT '1', + `RangeVariance` float NOT NULL DEFAULT '1', `unit_class` tinyint(3) unsigned NOT NULL DEFAULT '0', `unit_flags` int(10) unsigned NOT NULL DEFAULT '0', `unit_flags2` int(10) unsigned NOT NULL DEFAULT '0', @@ -535,9 +533,6 @@ CREATE TABLE `creature_template` ( `trainer_spell` mediumint(8) unsigned NOT NULL DEFAULT '0', `trainer_class` tinyint(3) unsigned NOT NULL DEFAULT '0', `trainer_race` tinyint(3) unsigned NOT NULL DEFAULT '0', - `minrangedmg` float NOT NULL DEFAULT '0', - `maxrangedmg` float NOT NULL DEFAULT '0', - `rangedattackpower` smallint(5) unsigned NOT NULL DEFAULT '0', `type` tinyint(3) unsigned NOT NULL DEFAULT '0', `type_flags` int(10) unsigned NOT NULL DEFAULT '0', `lootid` mediumint(8) unsigned NOT NULL DEFAULT '0', @@ -565,9 +560,11 @@ CREATE TABLE `creature_template` ( `MovementType` tinyint(3) unsigned NOT NULL DEFAULT '0', `InhabitType` tinyint(3) unsigned NOT NULL DEFAULT '3', `HoverHeight` float NOT NULL DEFAULT '1', - `Health_mod` float NOT NULL DEFAULT '1', - `Mana_mod` float NOT NULL DEFAULT '1', - `Armor_mod` float NOT NULL DEFAULT '1', + `HealthModifier` float NOT NULL DEFAULT '1', + `ManaModifier` float NOT NULL DEFAULT '1', + `ArmorModifier` float NOT NULL DEFAULT '1', + `DamageModifier` float NOT NULL DEFAULT '1', + `ExperienceModifier` float NOT NULL DEFAULT '1', `RacialLeader` tinyint(3) unsigned NOT NULL DEFAULT '0', `questItem1` int(10) unsigned NOT NULL DEFAULT '0', `questItem2` int(10) unsigned NOT NULL DEFAULT '0', @@ -2510,7 +2507,7 @@ CREATE TABLE `playercreateinfo_skills` ( `rank` smallint(5) unsigned NOT NULL DEFAULT '0', `comment` varchar(255) DEFAULT NULL, PRIMARY KEY (`raceMask`,`classMask`,`skill`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -3597,7 +3594,7 @@ CREATE TABLE `waypoint_data` ( `position_z` float NOT NULL DEFAULT '0', `orientation` float NOT NULL DEFAULT '0', `delay` int(10) unsigned NOT NULL DEFAULT '0', - `move_flag` tinyint(4) NOT NULL DEFAULT '0', + `move_type` int(11) NOT NULL DEFAULT '0', `action` int(11) NOT NULL DEFAULT '0', `action_chance` smallint(6) NOT NULL DEFAULT '100', `wpguid` int(11) NOT NULL DEFAULT '0', @@ -3659,4 +3656,4 @@ CREATE TABLE `waypoints` ( /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2014-07-28 22:43:25 +-- Dump completed on 2014-08-27 14:06:19 |