/*
SQLyog Community Edition- MySQL GUI
Host - 5.0.41-community-nt 
*********************************************************************
Server version : 5.0.41-community-nt
*/
/*!40101 SET NAMES utf8 */;

create table `characters` (
	`guid` double ,
	`acct` double ,
	`name` varchar (63),
	`race` tinyint (3),
	`class` tinyint (3),
	`gender` tinyint (3),
	`custom_faction` double ,
	`level` double ,
	`xp` double ,
	`exploration_data` blob ,
	`skills` blob ,
	`watched_faction_index` double ,
	`selected_pvp_title` double ,
	`available_pvp_titles` double ,
	`gold` double ,
	`ammo_id` double ,
	`available_prof_points` double ,
	`available_talent_points` double ,
	`current_hp` double ,
	`current_power` double ,
	`pvprank` tinyint (3),
	`bytes` double ,
	`bytes2` double ,
	`player_flags` double ,
	`player_bytes` double ,
	`positionX` float ,
	`positionY` float ,
	`positionZ` float ,
	`orientation` float ,
	`mapId` double ,
	`zoneId` double ,
	`taximask` blob ,
	`banned` double ,
	`banReason` varchar (150),
	`timestamp` double ,
	`online` double ,
	`bindpositionX` float ,
	`bindpositionY` float ,
	`bindpositionZ` float ,
	`bindmapId` double ,
	`bindzoneId` double ,
	`isResting` tinyint (3),
	`restState` tinyint (3),
	`restTime` double ,
	`playedtime` blob ,
	`deathstate` double ,
	`TalentResetTimes` double ,
	`first_login` tinyint (3),
	`forced_rename_pending` tinyint (3),
	`publicNote` varchar (96),
	`officerNote` varchar (96),
	`guildid` double ,
	`guildRank` double ,
	`arenaPoints` double ,
	`totalstableslots` double ,
	`instance_id` double ,
	`entrypointmap` double ,
	`entrypointx` float ,
	`entrypointy` float ,
	`entrypointz` float ,
	`entrypointo` float ,
	`entrypointinstance` double ,
	`taxi_path` double ,
	`taxi_lastnode` double ,
	`taxi_mountid` double ,
	`transporter` double ,
	`transporter_xdiff` float ,
	`transporter_ydiff` float ,
	`transporter_zdiff` float ,
	`spells` blob ,
	`deleted_spells` blob ,
	`reputation` blob ,
	`actions` blob ,
	`auras` blob ,
	`finished_quests` blob ,
	`honorPointsToAdd` double ,
	`killsToday` double ,
	`killsYesterday` double ,
	`killsLifeTime` double ,
	`honorToday` double ,
	`honorYesterday` double ,
	`honorPoints` double ,
	`difficulty` double 
);