“characters” table

The characters table holds TODO

Table structure

Field Type Null Key Default Extra
guid int(11) unsigned NO PRI 0  
account int(11) unsigned NO MUL 0  
name varchar(12) NO MUL    
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 NO   0  
position_y float NO   0  
position_z float NO   0  
map int(11) unsigned NO   0  
orientation float NO   0  
taximask longtext YES   NULL  
online tinyint(3) unsigned NO MUL 0  
cinematic tinyint(3) unsigned NO   0  
totaltime int(11) unsigned NO   0  
leveltime int(11) unsigned NO   0  
logout_time bigint(20) unsigned NO   0  
is_logout_resting tinyint(3) unsigned NO   0  
rest_bonus float NO   0  
resettalents_cost int(11) unsigned NO   0  
resettalents_time bigint(20) 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(20) unsigned NO   0  
extra_flags int(11) unsigned NO   0  
stable_slots tinyint(1) unsigned NO   0  
at_login int(11) unsigned NO   0  
zone int(11) unsigned NO   0  
death_expire_time bigint(20) unsigned NO   0  
taxi_path text YES   NULL  
honor_highest_rank int(11) unsigned NO   0  
honor_standing int(11) unsigned NO   0  
stored_honor_rating float NO   0  
stored_dishonorable_kills int(11) NO   0  
stored_honorable_kills int(11) NO   0  
watchedFaction int(10) unsigned NO   0  
drunk smallint(5) unsigned NO   0  
health int(10) unsigned NO   0  
power1 int(10) unsigned NO   0  
power2 int(10) unsigned NO   0  
power3 int(10) unsigned NO   0  
power4 int(10) unsigned NO   0  
power5 int(10) unsigned NO   0  
exploredZones longtext YES   NULL  
equipmentCache longtext YES   NULL  
ammoId int(10) unsigned NO   0  
actionBars tinyint(3) unsigned NO   0  
deleteInfos_Account int(11) unsigned YES   NULL  
deleteInfos_Name varchar(12) YES   NULL  
deleteDate bigint(20) unsigned YES   NULL  

Fields

guid

account

name

race

class

gender

level

xp

money

playerBytes

playerBytes2

playerFlags

position_x

position_y

position_z

map

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

honor_highest_rank

honor_standing

stored_honor_rating

stored_dishonorable_kills

stored_honorable_kills

watchedFaction

drunk

health

power1

power2

power3

power4

power5

exploredZones

equipmentCache

ammoId

actionBars

deleteInfos_Account

deleteInfos_Name

deleteDate