rendered paste body/*
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
);