Code:
--
-- Table structure for table `characters`
--
DROP TABLE IF EXISTS `characters`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `characters` (
`guid` int(6) unsigned NOT NULL DEFAULT '0',
`acct` int(20) unsigned NOT NULL DEFAULT '0',
`name` varchar(21) NOT NULL DEFAULT '',
`race` smallint(3) NOT NULL,
`class` smallint(3) NOT NULL,
`gender` tinyint(1) NOT NULL,
`custom_faction` int(30) NOT NULL DEFAULT '0',
`level` int(3) NOT NULL,
`xp` int(30) NOT NULL,
`exploration_data` longtext NOT NULL,
`skills` longtext NOT NULL,
`watched_faction_index` bigint(40) NOT NULL,
`selected_pvp_title` int(30) NOT NULL,
`available_pvp_titles` int(30) NOT NULL,
`gold` int(30) NOT NULL,
`ammo_id` int(30) NOT NULL,
`available_prof_points` int(30) NOT NULL,
`available_talent_points` int(30) NOT NULL,
`current_hp` int(30) NOT NULL,
`current_power` int(30) NOT NULL,
`pvprank` int(30) NOT NULL,
`bytes` int(30) NOT NULL,
`bytes2` int(30) NOT NULL,
`player_flags` int(30) NOT NULL,
`player_bytes` int(30) NOT NULL,
`positionX` float NOT NULL DEFAULT '0',
`positionY` float NOT NULL DEFAULT '0',
`positionZ` float NOT NULL DEFAULT '0',
`orientation` float NOT NULL DEFAULT '0',
`mapId` int(8) unsigned NOT NULL DEFAULT '0',
`zoneId` int(8) unsigned NOT NULL DEFAULT '0',
`taximask` longtext NOT NULL,
`banned` int(40) unsigned NOT NULL DEFAULT '0',
`banReason` varchar(255) NOT NULL,
`timestamp` int(30) DEFAULT NULL,
`online` int(11) DEFAULT NULL,
`bindpositionX` float NOT NULL DEFAULT '0',
`bindpositionY` float NOT NULL DEFAULT '0',
`bindpositionZ` float NOT NULL DEFAULT '0',
`bindmapId` int(8) unsigned NOT NULL DEFAULT '0',
`bindzoneId` int(8) unsigned NOT NULL DEFAULT '0',
`isResting` int(3) NOT NULL DEFAULT '0',
`restState` int(5) NOT NULL DEFAULT '0',
`restTime` int(5) NOT NULL DEFAULT '0',
`playedtime` text NOT NULL,
`deathstate` int(5) NOT NULL DEFAULT '0',
`TalentResetTimes` int(5) NOT NULL DEFAULT '0',
`first_login` tinyint(1) NOT NULL DEFAULT '0',
`forced_rename_pending` tinyint(1) NOT NULL DEFAULT '0',
`arenaPoints` int(10) NOT NULL,
`totalstableslots` int(10) unsigned NOT NULL DEFAULT '0',
`instance_id` int(10) NOT NULL,
`entrypointmap` int(10) NOT NULL,
`entrypointx` float NOT NULL,
`entrypointy` float NOT NULL,
`entrypointz` float NOT NULL,
`entrypointo` float NOT NULL,
`entrypointinstance` int(10) NOT NULL,
`taxi_path` int(10) NOT NULL,
`taxi_lastnode` int(10) NOT NULL,
`taxi_mountid` int(10) NOT NULL,
`transporter` int(10) NOT NULL,
`transporter_xdiff` float NOT NULL,
`transporter_ydiff` float NOT NULL,
`transporter_zdiff` float NOT NULL,
`spells` longtext NOT NULL,
`deleted_spells` longtext NOT NULL,
`reputation` longtext NOT NULL,
`actions` longtext NOT NULL,
`auras` longtext NOT NULL,
`finished_quests` longtext NOT NULL,
`honorPointsToAdd` int(10) NOT NULL,
`killsToday` int(10) NOT NULL DEFAULT '0',
`killsYesterday` int(10) NOT NULL DEFAULT '0',
`killsLifeTime` int(10) NOT NULL DEFAULT '0',
`honorToday` int(10) NOT NULL DEFAULT '0',
`honorYesterday` int(10) NOT NULL DEFAULT '0',
`honorPoints` int(10) NOT NULL DEFAULT '0',
`difficulty` int(4) NOT NULL DEFAULT '0',
PRIMARY KEY (`guid`),
KEY `acct` (`acct`),
KEY `name` (`name`),
KEY `b` (`banned`),
KEY `c` (`online`),
KEY `d` (`forced_rename_pending`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `characters`
--
LOCK TABLES `characters` WRITE;
/*!40000 ALTER TABLE `characters` DISABLE KEYS */;
/*!40000 ALTER TABLE `characters` ENABLE KEYS */;
UNLOCK TABLES;
find it on: