characters

Field	Type	Attributes	Key	Null	Default	Comment
guid	bigint	unsigned	PRI	NO	0	Global Unique Identifier
account	int	unsigned	MUL	NO	0	Account Identifier
name	varchar(12)		MUL	NO
slot	tinyint	unsigned		NO	0
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	bigint	unsigned		NO	0
inventorySlots	tinyint	unsigned		NO	16
inventoryBagFlags	int	unsigned		NO	0
bagSlotFlags1	int	unsigned		NO	0
bagSlotFlags2	int	unsigned		NO	0
bagSlotFlags3	int	unsigned		NO	0
bagSlotFlags4	int	unsigned		NO	0
bagSlotFlags5	int	unsigned		NO	0
bankSlots	tinyint	unsigned		NO	0
bankBagFlags	int	unsigned		NO	0
bankBagSlotFlags1	int	unsigned		NO	0
bankBagSlotFlags2	int	unsigned		NO	0
bankBagSlotFlags3	int	unsigned		NO	0
bankBagSlotFlags4	int	unsigned		NO	0
bankBagSlotFlags5	int	unsigned		NO	0
bankBagSlotFlags6	int	unsigned		NO	0
bankBagSlotFlags7	int	unsigned		NO	0
restState	tinyint	unsigned		NO	0
playerFlags	int	unsigned		NO	0
playerFlagsEx	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
dungeonDifficulty	tinyint	unsigned		NO	1
raidDifficulty	tinyint	unsigned		NO	14
legacyRaidDifficulty	tinyint	unsigned		NO	3
orientation	float			NO	0
taximask	text			NO
online	tinyint	unsigned	MUL	NO	0
createTime	bigint	signed		NO	0
createMode	tinyint	signed		NO	0
cinematic	tinyint	unsigned		NO	0
totaltime	int	unsigned		NO	0
leveltime	int	unsigned		NO	0
logout_time	bigint	signed		NO	0
is_logout_resting	tinyint	unsigned		NO	0
rest_bonus	float			NO	0
resettalents_cost	int	unsigned		NO	0
resettalents_time	bigint	signed		NO	0
numRespecs	tinyint	unsigned		NO	0
primarySpecialization	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	bigint	unsigned		NO	0
extra_flags	smallint	unsigned		NO	0
summonedPetNumber	int	unsigned		NO	0
at_login	smallint	unsigned		NO	0
zone	smallint	unsigned		NO	0
death_expire_time	bigint	signed		NO	0
taxi_path	text			YES	NULL
totalKills	int	unsigned		NO	0
todayKills	smallint	unsigned		NO	0
yesterdayKills	smallint	unsigned		NO	0
chosenTitle	int	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
power8	int	unsigned		NO	0
power9	int	unsigned		NO	0
power10	int	unsigned		NO	0
latency	int	unsigned		NO	0
activeTalentGroup	tinyint	unsigned		NO	0
lootSpecId	int	unsigned		NO	0
exploredZones	longtext			YES	NULL
equipmentCache	longtext			YES	NULL
knownTitles	longtext			YES	NULL
actionBars	tinyint	unsigned		NO	0
deleteInfos_Account	int	unsigned		YES	NULL
deleteInfos_Name	varchar(12)			YES	NULL
deleteDate	bigint	signed		YES	NULL
honor	int	unsigned		NO	0
honorLevel	int	unsigned		NO	1
honorRestState	tinyint	unsigned		NO	2
honorRestBonus	float			NO	0
lastLoginBuild	int	unsigned		NO	0
personalTabardEmblemStyle	int	signed		NO	-1
personalTabardEmblemColor	int	signed		NO	-1
personalTabardBorderStyle	int	signed		NO	-1
personalTabardBorderColor	int	signed		NO	-1
personalTabardBackgroundColor	int	signed		NO	-1

¶ Structure

¶ Description of fields

¶ guid

¶ account

¶ name

¶ slot

¶ race

¶ class

¶ gender

¶ level

¶ xp

¶ money

¶ inventorySlots

¶ inventoryBagFlags

¶ bagSlotFlags1

¶ bagSlotFlags2

¶ bagSlotFlags3

¶ bagSlotFlags4

¶ bagSlotFlags5

¶ bankSlots

¶ bankBagFlags

¶ bankBagSlotFlags1

¶ bankBagSlotFlags2

¶ bankBagSlotFlags3

¶ bankBagSlotFlags4

¶ bankBagSlotFlags5

¶ bankBagSlotFlags6

¶ bankBagSlotFlags7

¶ restState

¶ playerFlags

¶ playerFlagsEx

¶ position_x

¶ position_y

¶ position_z

¶ map

¶ instance_id

¶ dungeonDifficulty

¶ raidDifficulty

¶ legacyRaidDifficulty

¶ orientation

¶ taximask

¶ online

¶ createTime

¶ createMode

¶ cinematic

¶ totaltime

¶ leveltime

¶ logout_time

¶ is_logout_resting

¶ rest_bonus

¶ resettalents_cost

¶ resettalents_time

¶ numRespecs

¶ primarySpecialization

¶ trans_x

¶ trans_y

¶ trans_z

¶ trans_o

¶ transguid

¶ extra_flags

¶ summonedPetNumber

¶ at_login

¶ zone

¶ death_expire_time

¶ taxi_path

¶ totalKills

¶ todayKills

¶ yesterdayKills

¶ chosenTitle

¶ watchedFaction

¶ drunk

¶ health

¶ power1

¶ power2

¶ power3

¶ power4

¶ power5

¶ power6

¶ power7

¶ power8