所有MYSQL表的详细说明

worldmap_info:  副本/战场定义
- mapid - name says all  地图代号
- screenid - screen for instance loading usally the same as mapid but not always.  画面代号，通常跟地图代号相同
- type - 0 - other/default , 2 - instance, 3 battleground  类型
0：约定类型，2：副本，3：战场

- maxplayers - <value>    最大玩家数
- repop x,y,z,mapid - coords where playered is beeing port when he tries to join an invaild instance.  该地图关联的墓地

- area_name - <varchar>  地区名称
- flags - 1 - continent, 3 - bg/instance from wow, 9 - TBC instance/bg　标志
1：陆地，3：WOW的战场或副本，9：TBC的战场或副本
- cooldown - time needed to pass until next time player can join instance in milisecounds
刷新周期，单位毫秒

vendors:  商人
- vendorGuid - vendor id  商人代号
- itemGuid - item id   物品代号
- amount - its for stackable items like arrows food etc... 
一次可购买的最大数量

trainerspelloverride:
- spellid - spell id  法术代号

- cost - in copper    花费，单位：铜币

- requiredspell - required spell id 学习该法术需要的前提法术

- deletespell – id 学习该法术后需要删除的法术

- requiredskill – skillid 学习该法术需要的技能

- requiredskillvalue - req skill level 学习该法术需要的技能等级

- reqlevel - ...name says all 学习该法术需要的玩家等级

- requiredclass - bitwise for mixed classes (warrior - 1, pally - 2, hunter - 4, rouge - 8, priest - 16, shaman - 64, mage - 128, warlock - 256, druid - 

职业：1：战士，2：圣骑士，4：猎人，8：盗贼，16：牧师，64：撒满，128：法师，256：术士，1024：德鲁依

traniers:  训练师
- creatureid - traniner id  生物代号，训练师编号（与生物表同，为什么不用entry,非得另起一名称）

- skilllineXX - skillline id from skilline.dbc   技能索引
　
totemspells:
- spellid - totem spell id  图腾魔法代号

- spelltocast1 - spell that is beeing casted by totem <look for them on thotbot>  图腾能施展的法术1

- spelltocast2 - same as above   图腾能施展的法术2

- spelltocast3 - ...  图腾能施展的法术3

quests:  任务
this db is preety easy all you need are flags here...
classes warrior - 1, pally - 2, hunter - 4, rouge - 8, priest - 16, shaman - 64, mage - 128, warlock - 256, druid - 1024
- scritem - for deliver quests <itemid>  赋予任务的物品代号

- race - i dont remember all of them anyway 77 - ally, 176 for horde   种族

- flags (taken from source)  任务类别FLAG

QUEST_FLAG_NONE = 0,    无

QUEST_FLAG_DELIVER = 1,    赋予

QUEST_FLAG_KILL = 2,     杀某生物

QUEST_FLAG_SPEAKTO = 4,   跟某生物说话

QUEST_FLAG_REPEATABLE = 8,  可重复的

QUEST_FLAG_EXPLORATION = 16,  勘查

QUEST_FLAG_TIMED = 32,    有时间限制

QUEST_FLAG_REPUTATION = 128,  跟名誉相关


pvpareas:  ＰＶＰ区域
- areaid - name says all   地区代号

- areaname <varchar>    地区名称

- pvptype - 1 -horde territory, 2 -ally territory, 3 –contested
1部落地盘 2联盟地盘  3争夺中的地区

gameobject_quest_item_binding:  任务物品连结

its for go's lootable only for certain quest

- gameobject_entry – goid   游戏物件实体

- quest_id - <---     任务代码

- item_id ...        物品代码

- itemcount - chance is always 100% for those go's here you can set how many quest items r droped on loot   物品量  

gameobject_quest_pickup_relation   任务取得关联

this one is used for quests that require go interaction

- gameobject_entry – goid  游戏物件实体

- quest_id - <---     任务代码

- required_count     需求数量


areatriggers:  区域触发
- AreaTriggerID - obvious crap (areatriggers.dbc) 区域触发代号，由areatriggers.dbc定义

- type - 1 - instance entrance, 3 - inn, city for resting system, 4 - portal (w/o loadning screen or sth i have it for rutheran portal and wizards sanctum) 
　类型。1：副本入口，3：旅店或者城市，4：没明白

- mapid - map id for tp  地图代号

- screen - usally same as mapid for loading screen  画面代号，通常跟地图代号相同

- name <varchar100 latin>  名称
- x,y,z - coords for tp
　触发该触发点将传送到的坐标，与mapid构成完整的传送点坐标。

- required_honor_rank ... 需要的荣誉

- required_level ...      需要的等级