characters

Field	Type	Attributes	Key	Null	Default	Comment
guid	int	unsigned	PRI	NO	0	Global Unique Identifier
account	int	unsigned	MUL	NO	0	Account Identifier
name	varchar(12)		MUL	NO
race	tinyint	unsigned		NO	0
class	tinyint	unsigned		NO	0
gender	tinyint	unsigned		NO	0
level	tinyint	unsigned		NO	0
xp	int	unsigned		NO	0
money	int	unsigned		NO	0
skin	tinyint	unsigned		NO	0
face	tinyint	unsigned		NO	0
hairStyle	tinyint	unsigned		NO	0
hairColor	tinyint	unsigned		NO	0
facialStyle	tinyint	unsigned		NO	0
bankSlots	tinyint	unsigned		NO	0
restState	tinyint	unsigned		NO	0
playerFlags	int	unsigned		NO	0
position_x	float			NO	0
position_y	float			NO	0
position_z	float			NO	0
map	smallint	unsigned		NO	0	Map Identifier
instance_id	int	unsigned		NO	0
instance_mode_mask	tinyint	unsigned		NO	0
orientation	float			NO	0
taximask	text			NO
online	tinyint	unsigned	MUL	NO	0
cinematic	tinyint	unsigned		NO	0
totaltime	int	unsigned		NO	0
leveltime	int	unsigned		NO	0
logout_time	int	unsigned		NO	0
is_logout_resting	tinyint	unsigned		NO	0
rest_bonus	float			NO	0
resettalents_cost	int	unsigned		NO	0
resettalents_time	int	unsigned		NO	0
trans_x	float			NO	0
trans_y	float			NO	0
trans_z	float			NO	0
trans_o	float			NO	0
transguid	mediumint	unsigned		NO	0
extra_flags	smallint	unsigned		NO	0
stable_slots	tinyint	unsigned		NO	0
at_login	smallint	unsigned		NO	0
zone	smallint	unsigned		NO	0
death_expire_time	int	unsigned		NO	0
taxi_path	text			YES	NULL
arenaPoints	int	unsigned		NO	0
totalHonorPoints	int	unsigned		NO	0
todayHonorPoints	int	unsigned		NO	0
yesterdayHonorPoints	int	unsigned		NO	0
totalKills	int	unsigned		NO	0
todayKills	smallint	unsigned		NO	0
yesterdayKills	smallint	unsigned		NO	0
chosenTitle	int	unsigned		NO	0
knownCurrencies	bigint	unsigned		NO	0
watchedFaction	int	unsigned		NO	0
drunk	tinyint	unsigned		NO	0
health	int	unsigned		NO	0
power1	int	unsigned		NO	0
power2	int	unsigned		NO	0
power3	int	unsigned		NO	0
power4	int	unsigned		NO	0
power5	int	unsigned		NO	0
power6	int	unsigned		NO	0
power7	int	unsigned		NO	0
latency	mediumint	unsigned		NO	0
talentGroupsCount	tinyint	unsigned		NO	1
activeTalentGroup	tinyint	unsigned		NO	0
exploredZones	longtext			YES	NULL
equipmentCache	longtext			YES	NULL
ammoId	int	unsigned		NO	0
knownTitles	longtext			YES	NULL
actionBars	tinyint	unsigned		NO	0
grantableLevels	tinyint	unsigned		NO	0
deleteInfos_Account	int	unsigned		YES	NULL
deleteInfos_Name	varchar(12)			YES	NULL
deleteDate	int	unsigned		YES	NULL

¶ Structure

¶ Description of fields

¶ guid

¶ account

¶ name

¶ race

¶ class

¶ gender

¶ level

¶ xp

¶ money

¶ skin

¶ face

¶ hairStyle

¶ hairColor

¶ facialStyle

¶ bankSlots

¶ restState

¶ playerFlags

¶ position_x

¶ position_y

¶ position_z

¶ map

¶ instance_id

¶ instance_mode_mask

¶ orientation

¶ taximask

¶ online

¶ cinematic

¶ totaltime

¶ leveltime

¶ logout_time

¶ is_logout_resting

¶ rest_bonus

¶ resettalents_cost

¶ resettalents_time

¶ trans_x

¶ trans_y

¶ trans_z

¶ trans_o

¶ transguid

¶ extra_flags

¶ stable_slots

¶ at_login

¶ zone

¶ death_expire_time

¶ taxi_path

¶ arenaPoints

¶ totalHonorPoints

¶ todayHonorPoints

¶ yesterdayHonorPoints

¶ totalKills

¶ todayKills

¶ yesterdayKills

¶ chosenTitle

¶ knownCurrencies

¶ watchedFaction

¶ drunk

¶ health

¶ power1

¶ power2

¶ power3

¶ power4

¶ power5

¶ power6

¶ power7

¶ latency

¶ talentGroupsCount

¶ activeTalentGroup

¶ exploredZones

¶ equipmentCache

¶ ammoId

¶ knownTitles

¶ actionBars

¶ grantableLevels

¶ deleteInfos_Account

¶ deleteInfos_Name

¶ deleteDate