AzerothCore 中文

用户工具

站点工具

您的足迹:
数据库:world数据库:creature

差别

这里会显示出您选择的修订版和当前版本之间的差别。

到此差别页面的链接

两侧同时换到之前的修订记录前一修订版
数据库:world数据库:creature [2023/09/24 17:37] – [creature 表] admin数据库:world数据库:creature [2023/09/24 17:41] (当前版本) – 已恢复为旧版 (2023/09/24 15:26) admin
行 7: 行 7:
 **表结构** **表结构**
 ^Field^Type^Attributes^Key^Null^Default^Extra^Comment^ ^Field^Type^Attributes^Key^Null^Default^Extra^Comment^
-|[[#entry|entry]]|MEDIUMINT|UNSIGNED|PRI|NO|0| | | +|[[#guid|guid]]|INT|UNSIGNED|PRI|NO|NULL|Auto Increment|Global Unique Identifier| 
-|[[#difficulty_entry_1|difficulty_entry_1]]|MEDIUMINT|UNSIGNED| |NO|0| | | +|[[#id1|id1]]|INT|UNSIGNED| |NO|0| |Creature Identifier| 
-|[[#difficulty_entry_2|difficulty_entry_2]]|MEDIUMINT|UNSIGNED| |NO|0| | | +|[[#id2|id2]]|INT|UNSIGNED| |NO|0| |Creature Identifier| 
-|[[#difficulty_entry_3|difficulty_entry_3]]|MEDIUMINT|UNSIGNED| |NO|0| | | +|[[#id3|id3]]|INT|UNSIGNED| |NO|0| |Creature Identifier| 
-|[[#KillCredit1|KillCredit1]]|INT|UNSIGNED| |NO|0| | | +|[[#map|map]]|SMALLINT|UNSIGNED| |NO|0| |Map Identifier| 
-|[[#KillCredit2|KillCredit2]]|INT|UNSIGNED| |NO|0| | | +|[[#zoneId|zoneId]]|SMALLINT|UNSIGNED| |NO|0| |Zone Identifier| 
-|[[#modelid1|modelid1]]|MEDIUMINT|UNSIGNED| |NO|0| | | +|[[#areaId|areaId]]|SMALLINT|UNSIGNED| |NO|0| |Area Identifier| 
-|[[#modelid2|modelid2]]|MEDIUMINT|UNSIGNED| |NO|0| | | +|[[#spawnMask|spawnMask]]|TINYINT|UNSIGNED| |NO|1| | | 
-|[[#modelid3|modelid3]]|MEDIUMINT|UNSIGNED| |NO|0| | | +|[[#phaseMask|phaseMask]]|SMALLINT|UNSIGNED| |NO|1| | | 
-|[[#modelid4|modelid4]]|MEDIUMINT|UNSIGNED| |NO|0| | | +|[[#equipment_id|equipment_id]]|TINYINT|UNSIGNED| |NO|1| | | 
-|[[#name|name]]|char(100)| |MUL|NO|0| | | +|[[#position_x|position_x]]|FLOAT|SIGNED| |NO|0| | | 
-|[[#subname|subname]]|char(100)| | |YES|(NULL)| | | +|[[#position_y|position_y]]|FLOAT|SIGNED| |NO|0| | | 
-|[[#IconName|IconName]]|char(100)| | |YES|(NULL)| | | +|[[#position_z|position_z]]|FLOAT|SIGNED| |NO|0| | | 
-|[[#gossip_menu_id|gossip_menu_id]]|MEDIUMINT|UNSIGNED| |NO|0| | | +|[[#orientation|orientation]]|FLOAT|SIGNED| |NO|0| | | 
-|[[#minlevel|minlevel]]|TINYINT|UNSIGNED| |NO|1| | | +|[[#spawntimesecs|spawntimesecs]]|INT|UNSIGNED| |NO|120| | | 
-|[[#maxlevel|maxlevel]]|TINYINT|UNSIGNED| |NO|1| | | +|[[#wander_distance|wander_distance]]|FLOAT|SIGNED| |NO|5| |Dist in yards for random movement.| 
-|[[#exp|exp]]|SMALLINT| | |NO|0| | | +|[[#currentwaypoint|currentwaypoint]]|INT|UNSIGNED| |NO|0| |Storage used by core. "Always set as 0"| 
-|[[#faction|faction]]|MEDIUMINT|UNSIGNED| |NO|0| | | +|[[#curhealth|curhealth]]|INT|UNSIGNED| |NO|1| |Storage used by core. "Always set as 1"| 
-|[[#npcflag|npcflag]]|INT|UNSIGNED| |NO|0| | | +|[[#curmana|curmana]]|INT|UNSIGNED| |NO|0| |Storage used by core. "Always set as 0"| 
-|[[#speed_walk|speed_walk]]|FLOAT| | |NO|1| |Result of 2.5/2.5, most common value| +|[[#MovementType|MovementType]]|TINYINT|UNSIGNED| |NO|0| |0 No movement, 1 random, 2 path| 
-|[[#speed_run|speed_run]]|FLOAT| | |NO|1.14286| |Result of 8.0/7.0, most common value| +|[[#npcflag|npcflag]]|INT|UNSIGNED| |NO|0| |creature_template override| 
-|[[#speed_swim|speed_swim]]|FLOAT| | |NO|1| | | +|[[#unit_flags|unit_flags]]|INT|UNSIGNED| |NO|0| |creature_template override| 
-|[[#speed_swim|speed_swim]]|FLOAT| | |NO|1| | | +|[[#dynamicflags|dynamicflags]]|INT|UNSIGNED| |NO|0| |creature_template override| 
-|[[#detection_range|detection_range]]|FLOAT| | |NO|20| | | +|[[#ScriptName|ScriptName]]|CHAR| | |YES|NULL| | | 
-|[[#scale|scale]]|FLOAT| | |NO|1| | | +|[[#VerifiedBuild|VerifiedBuild]]|INT|SIGNED| |YES|NULL| |Not used by the core.| 
-|[[#rank|rank]]|TINYINT|UNSIGNED| |NO|0| | | +|[[#CreateObject|CreateObject]]|TINYINT|UNSIGNED| |NO|0| |Not used by the core.| 
-|[[#dmgschool|dmgschool]]|TINYINT| | |NO|0| | | +|[[#Comment|Comment]]|TEXT| | |YES|NULL| |Not used by the core.|
-|[[#BaseAttackTime|BaseAttackTime]]|INT|UNSIGNED| |NO|0| | | +
-|[[#RangeAttackTime|RangeAttackTime]]|INT|UNSIGNED| |NO|0| | | +
-|[[#BaseVariance|BaseVariance]]|FLOAT| | |NO|1| | | +
-|[[#RangeVariance|RangeVariance]]|FLOAT| | |NO|1| | | +
-|[[#unit_class|unit_class]]|TINYINT|UNSIGNED| |NO|0| | | +
-|[[#unit_flags|unit_flags]]|INT|UNSIGNED| |NO|0| | | +
-|[[#unit_flags2|unit_flags2]]|INT|UNSIGNED| |NO|0| | | +
-|[[#dynamicflags|dynamicflags]]|INT|UNSIGNED| |NO|0| | | +
-|[[#family|family]]|TINYINT| | |NO|0| | | +
-|[[#trainer_type|trainer_type]]|TINYINT| | |NO|0| | | +
-|[[#trainer_spell|trainer_spell]]|MEDIUMINT|UNSIGNED| |NO|0| | | +
-|[[#trainer_class|trainer_class]]|TINYINT|UNSIGNED| |NO|0| | | +
-|[[#trainer_race|trainer_race]]|TINYINT|UNSIGNED| |NO|0| | | +
-|[[#type|type]]|TINYINT|UNSIGNED| |NO|0| | | +
-|[[#type_flags|type_flags]]|INT|UNSIGNED| |NO|0| | | +
-|[[#lootid|lootid]]|MEDIUMINT|UNSIGNED| |NO|0| | | +
-|[[#pickpocketloot|pickpocketloot]]|MEDIUMINT|UNSIGNED| |NO|0| | | +
-|[[#skinloot|skinloot]]|MEDIUMINT|UNSIGNED| |NO|0| | | +
-|[[#PetSpellDataId|PetSpellDataId]]|MEDIUMINT|UNSIGNED| |NO|0| | | +
-|[[#VehicleId|VehicleId]]|MEDIUMINT|UNSIGNED| |NO|0| | | +
-|[[#mingold|mingold]]|MEDIUMINT|UNSIGNED| |NO|0| | | +
-|[[#maxgold|maxgold]]|MEDIUMINT|UNSIGNED| |NO|0| | | +
-|[[#AIName|AIName]]|char(64)| | |NO| | | | +
-|[[#MovementType|MovementType]]|TINYINT|UNSIGNED| |NO|0| | | +
-|[[#HoverHeight|HoverHeight]]|FLOAT| | |NO|1| | | +
-|[[#HealthModifier|HealthModifier]]|FLOAT| | |NO|1| | | +
-|[[#ManaModifier|ManaModifier]]|FLOAT| | |NO|1| | | +
-|[[#ArmorModifier|ArmorModifier]]|FLOAT| | |NO|1| | | +
-|[[#DamageModifier|DamageModifier]]|FLOAT| | |NO|1| | | +
-|[[#ExperienceModifier|ExperienceModifier]]|FLOAT| | |NO|1| | | +
-|[[#RacialLeader|RacialLeader]]|TINYINT|UNSIGNED| |NO|0| | | +
-|[[#movementId|movementId]]|INT|UNSIGNED| |NO|0| | | +
-|[[#RegenHealth|RegenHealth]]|TINYINT|UNSIGNED| |NO|1| | | +
-|[[#mechanic_immune_mask|mechanic_immune_mask]]|INT|UNSIGNED| |NO|0| | | +
-|[[#spell_school_immune_mask|spell_school_immune_mask]]|INT|UNSIGNED| |NO|0| | | +
-|[[#flags_extra|flags_extra]]|INT|UNSIGNED| |NO|0| | | +
-|[[#ScriptName|ScriptName]]|char(64)| | |NO| | | | +
-|[[#VerifiedBuild|VerifiedBuild]]|SMALLINT| | |YES|0| | | +
  
 ===== 字段说明 ===== ===== 字段说明 =====
数据库/world数据库/creature.1695548262.txt.gz · 最后更改: 2023/09/24 17:37 由 admin
Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki