characters (table)

jun 08, 2018

Back-to:Characters

The `characters` table

This table holds vital static information for each character. This information loaded and used to create the player objects in-game.

Structure

Field	Type	Attributes	Key	Null	Default	Extra	Comment
guid	int(10)	unsigned	PRI	NO	0	Unique	Global Unique Identifier
account	int(10)	unsigned		NO	0		Account Identifier
name	varchar(12)	signed		NO	NULL
race	tinyint(3)	unsigned		NO	0
class	tinyint(3)	unsigned		NO	0
gender	tinyint(3)	unsigned		NO	0
level	tinyint(3)	unsigned		NO	0
xp	int(10)	unsigned		NO	0
money	int(10)	unsigned		NO	0
playerBytes	int(10)	unsigned		NO	0
playerBytes2	int(10)	unsigned		NO	0
playerFlags	int(10)	unsigned		NO	0
position_x	float	signed		NO	0
position_y	float	signed		NO	0
position_z	float	signed		NO	0
map	smallint(5)	unsigned		NO	0		Map Identifier
instance_id	int(10)	unsigned		NO	0
instance_mode_mask	tinyint(3)	unsigned		NO	0
orientation	float	signed		NO	0
taximask	text	signed		NO	NULL
online	tinyint(3)	unsigned		NO	0
cinematic	tinyint(3)	unsigned		NO	0
totaltime	int(10)	unsigned		NO	0
leveltime	int(10)	unsigned		NO	0
logout_time	int(10)	unsigned		NO	0
is_logout_resting	tinyint(3)	unsigned		NO	0
rest_bonus	float	signed		NO	0
resettalents_cost	int(10)	unsigned		NO	0
resettalents_time	int(0)	unsigned		NO	0
trans_x	float	signed		NO	0
trans_y	float	signed		NO	0
trans_z	float	signed		NO	0
trans_o	float	signed		NO	0
transguid	mediumint(8)	unsigned		NO	0
extra_flags	smallint(5)	unsigned		NO	0
stable_slots	tinyint(3)	unsigned		NO	0
at_login	smallint(5)	unsigned		NO	0
zone	smallint(5)	unsigned		NO	0
death_expire_time	int(10)	unsigned