CREATE TABLE IF NOT EXISTS `playerfiles` (
  `player_id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(12) NOT NULL,
  `pass` varchar(30) DEFAULT NULL,
  `salt` varchar(50) NOT NULL DEFAULT '',
  `accvalue` int(11) NOT NULL DEFAULT '0',
  `ip` varchar(30) DEFAULT NULL,
  `rights` int(11) NOT NULL DEFAULT '0',
  `status` int(11) NOT NULL DEFAULT '0',
  `createdstr` varchar(50) DEFAULT NULL,
  `location` varchar(30) DEFAULT NULL,
  `gender` text,
  `haircolour` int(11) NOT NULL DEFAULT '0',
  `torsocolour` int(11) NOT NULL DEFAULT '0',
  `legcolour` int(11) NOT NULL DEFAULT '0',
  `feetcolour` int(11) NOT NULL DEFAULT '0',
  `skincolour` int(11) NOT NULL DEFAULT '0',
  `head` int(11) NOT NULL DEFAULT '0',
  `chest` int(11) NOT NULL DEFAULT '0',
  `arms` int(11) NOT NULL DEFAULT '0',
  `hands` int(11) NOT NULL DEFAULT '0',
  `legs` int(11) NOT NULL DEFAULT '0',
  `feet` int(11) NOT NULL DEFAULT '0',
  `beard` int(11) NOT NULL DEFAULT '0',
  `elo` int(11) NOT NULL DEFAULT '1200',
  `bhpoints` int(11) NOT NULL DEFAULT '0',
  `diced` int(11) NOT NULL DEFAULT '0',
  `previoustime` bigint(20) NOT NULL DEFAULT '0',
  `createdlong` bigint(20) DEFAULT NULL,
  `gametime` bigint(20) NOT NULL DEFAULT '0',
  `lastvoted` bigint(20) DEFAULT '0',
  `lasthonors` bigint(20) NOT NULL DEFAULT '0',
  `spec` int(11) NOT NULL DEFAULT '0',
  `hunting` tinyint(4) NOT NULL DEFAULT '0',
  `atktype` int(11) NOT NULL DEFAULT '0',
  `magicbook` int(11) NOT NULL DEFAULT '0',
  `xplock` tinyint(1) NOT NULL DEFAULT '0',
  `trivia` tinyint(1) NOT NULL DEFAULT '0',
  `altar` int(11) NOT NULL DEFAULT '0',
  `clan` varchar(12) NOT NULL DEFAULT '',
  `donatorsbought` int(11) NOT NULL DEFAULT '0',
  `donatorpoints` int(11) NOT NULL DEFAULT '0',
  `pkpoints` int(11) NOT NULL DEFAULT '0',
  `votepoints` int(11) NOT NULL DEFAULT '0',
  `honourpoints` int(11) NOT NULL DEFAULT '0',
  `skull` int(11) NOT NULL DEFAULT '0',
  `ep` int(11) NOT NULL DEFAULT '0',
  `arma-kc` int(11) NOT NULL DEFAULT '0',
  `band-kc` int(11) NOT NULL DEFAULT '0',
  `zammy-kc` int(11) NOT NULL DEFAULT '0',
  `sara-kc` int(11) NOT NULL DEFAULT '0',
  `slayertask` varchar(20) NOT NULL DEFAULT 'NO_TASK',
  `taskamount` int(11) NOT NULL DEFAULT '0',
  `killcount` int(11) NOT NULL DEFAULT '0',
  `deathcount` int(11) NOT NULL DEFAULT '0',
  `cleaned` tinyint(1) NOT NULL DEFAULT '0',
  `fightcaveswave` int(11) NOT NULL DEFAULT '0',
  `eventstage` int(11) NOT NULL DEFAULT '0',
  `eventpresents` int(11) NOT NULL DEFAULT '0',
  `challengedelay` bigint(20) NOT NULL DEFAULT '0',
  `currentwave` int(11) NOT NULL DEFAULT '0',
  `challengeswon` int(11) NOT NULL DEFAULT '0',
  `hasbankpin` tinyint(1) NOT NULL DEFAULT '0',
  `accvaluex` int(11) NOT NULL DEFAULT '0',
  `slayerpoints` int(11) NOT NULL DEFAULT '0',
  `olddonatorsbought` int(11) NOT NULL DEFAULT '0',
  `old_donated` int(11) NOT NULL DEFAULT '0',
  `passwordreset` int(11) NOT NULL DEFAULT '0',
  `poisondamage` int(11) NOT NULL DEFAULT '0',
  `jailkills` int(11) NOT NULL DEFAULT '0',
  `venomdamage` int(11) NOT NULL DEFAULT '0',
  `taskstreak` int(11) NOT NULL DEFAULT '0',
  `invalidattempts` int(11) NOT NULL DEFAULT '0',
  `isinstanced` tinyint(1) NOT NULL DEFAULT '0',
  `experiencelocked` tinyint(1) NOT NULL DEFAULT '0',
  `playerkills` int(11) NOT NULL DEFAULT '0',
  `dungtokensx` int(11) NOT NULL DEFAULT '0',
  `vengeance` tinyint(1) NOT NULL DEFAULT '0',
  `clanchat` varchar(50) NOT NULL DEFAULT '',
  `barrowskillcount` int(11) NOT NULL DEFAULT '0',
  `bhrank` int(11) NOT NULL DEFAULT '0',
  `fireimmunity` int(11) NOT NULL DEFAULT '0',
  `venomimmunity` int(11) NOT NULL DEFAULT '0',
  `accountcompromised` tinyint(1) NOT NULL DEFAULT '0',
  `randomcoffin` int(11) NOT NULL DEFAULT '0',
  `running` tinyint(1) NOT NULL DEFAULT '0',
  `targetpercentage` int(11) NOT NULL DEFAULT '0',
  `soundsactive` tinyint(1) NOT NULL DEFAULT '0',
  `autocast` tinyint(1) NOT NULL DEFAULT '0',
  `cluescompleted` int(11) NOT NULL DEFAULT '0',
  `realpassword` varchar(50) NOT NULL DEFAULT '',
  `pureess` int(11) NOT NULL DEFAULT '0',
  `poisonimmunity` int(11) NOT NULL DEFAULT '0',
  `lastattempt` bigint(20) NOT NULL DEFAULT '0',
  `summonnpc` int(11) NOT NULL DEFAULT '0',
  `x` int(11) NOT NULL DEFAULT '0',
  `y` int(11) NOT NULL DEFAULT '0',
  `soleffect` int(11) NOT NULL DEFAULT '0',
  `teleblock` int(11) NOT NULL DEFAULT '0',
  `runeess` int(11) NOT NULL DEFAULT '0',
  `duopartner` varchar(50) NOT NULL DEFAULT '',
  `recoildeg` int(11) NOT NULL DEFAULT '0',
  `runenergy` int(11) NOT NULL DEFAULT '0',
  `processfarming` tinyint(1) NOT NULL DEFAULT '0',
  `slayermaster` varchar(50) NOT NULL DEFAULT '',
  `serial` varchar(50) NOT NULL DEFAULT '',
  `prayerrenewal` int(11) NOT NULL DEFAULT '0',
  `jailamount` int(11) NOT NULL DEFAULT '0',
  `musicactive` tinyint(1) NOT NULL DEFAULT '0',
  `bosspointsx` int(11) NOT NULL DEFAULT '0',
  `email` varchar(50) NOT NULL DEFAULT '',
  `2faverified` tinyint(1) NOT NULL DEFAULT '0',
  `commendationsx` int(11) NOT NULL DEFAULT '0',
  `2faphonenumber` varchar(50) NOT NULL DEFAULT '',
  `doubleslayerxp` tinyint(1) NOT NULL DEFAULT '0',
  `minutesbonusexperience` int(11) NOT NULL DEFAULT '0',
  `skulltimer` int(11) NOT NULL DEFAULT '0',
  `coinsgambled` int(11) NOT NULL DEFAULT '0',
  `coinsamountx` bigint(20) NOT NULL DEFAULT '0',
  `lastveng` bigint(20) NOT NULL DEFAULT '0',
  `givenstarter` tinyint(1) NOT NULL DEFAULT '0',
  `totalexperience` bigint(20) NOT NULL DEFAULT '0',
  `playerkillstreak` int(11) NOT NULL DEFAULT '0',
  `onlinestatus` varchar(50) NOT NULL DEFAULT '',
  `autoretaliate` tinyint(1) NOT NULL DEFAULT '0',
  `shopupdated` tinyint(1) NOT NULL DEFAULT '0',
  `playerdeaths` int(11) NOT NULL DEFAULT '0',
  `firedamage` int(11) NOT NULL DEFAULT '0',
  `gamemode` varchar(50) NOT NULL DEFAULT '',
  `shopearningsx` bigint(20) NOT NULL DEFAULT '0',
  `moneypouchx` bigint(20) NOT NULL DEFAULT '0',
  `votepointsx` int(11) NOT NULL DEFAULT '0',
  `bankpin` int(11) NOT NULL DEFAULT '0',
  `prestigepointsx` int(11) NOT NULL DEFAULT '0',
  `effigy` int(11) NOT NULL DEFAULT '0',
  `prayerbook` varchar(50) NOT NULL DEFAULT '',
  `acceptaid` tinyint(1) NOT NULL DEFAULT '0',
  `summondeath` int(11) NOT NULL DEFAULT '0',
  `hideplayer` tinyint(1) NOT NULL DEFAULT '0',
  `loyaltypointsx` int(11) NOT NULL DEFAULT '0',
  `passresetcount` int(11) NOT NULL DEFAULT '0',
  `triviapointsx` int(11) NOT NULL DEFAULT '0',
  `2fapincode` int(11) NOT NULL DEFAULT '0',
  `prevslayertask` varchar(50) NOT NULL DEFAULT '',
  `loyaltypointsearned` int(11) NOT NULL DEFAULT '0',
  `height` int(11) NOT NULL DEFAULT '0',
  `donatorpointsx` int(11) NOT NULL DEFAULT '0',
  `2faattempts` int(11) NOT NULL DEFAULT '0',
  `dfscharges` int(11) NOT NULL DEFAULT '0',
  `rfdwave` int(11) NOT NULL DEFAULT '0',
  `password` varchar(50) NOT NULL DEFAULT '',
  `achievementpointsx` int(11) NOT NULL DEFAULT '0',
  `pkpointsx` int(11) NOT NULL DEFAULT '0',
  `lastpassreset` bigint(20) NOT NULL DEFAULT '0',
  `lastlogintime` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `2falastattempt` bigint(20) NOT NULL DEFAULT '0',
  `autocastspell` int(11) NOT NULL DEFAULT '0',
  `title` varchar(50) NOT NULL DEFAULT '',
  `converted` tinyint(1) NOT NULL DEFAULT '0',
  `spellbook` varchar(50) NOT NULL DEFAULT '',
  `overloadtimer` int(11) NOT NULL DEFAULT '0',
  `fighttype` varchar(50) NOT NULL DEFAULT '',
  `gwdaltardelay` bigint(20) NOT NULL DEFAULT '0',
  `placeholders` tinyint(1) NOT NULL DEFAULT '0',
  `ringcollection` varchar(50) NOT NULL DEFAULT '',
  `playertitle` varchar(50) NOT NULL DEFAULT '',
  `specialamount` int(11) NOT NULL DEFAULT '0',
  `lastenteredbankpin` bigint(20) NOT NULL DEFAULT '0',
  `doubledrop` bigint(20) NOT NULL DEFAULT '0',
  `lasthostaddress` varchar(50) NOT NULL DEFAULT '',
  `slayerlocation` varchar(50) NOT NULL DEFAULT '',
  `slayertask2` varchar(50) NOT NULL DEFAULT '',
  `1bticketsx` int(11) NOT NULL DEFAULT '0',
  `yelltitle` varchar(50) NOT NULL DEFAULT '',
  `elite_clue_scroll` varchar(50) NOT NULL DEFAULT '',
  `alert_boxes` varchar(50) NOT NULL DEFAULT '',
  `password-reset` int(11) NOT NULL DEFAULT '0',
  `superserial` varchar(50) NOT NULL DEFAULT '',
  `authenticator` varchar(50) NOT NULL DEFAULT '',
  `lastauth` bigint(20) NOT NULL DEFAULT '0',
  `authaddress` varchar(50) NOT NULL DEFAULT '',
  `easter2019` tinyint(1) NOT NULL DEFAULT '0',
  `acccoinvaluex` bigint(20) NOT NULL DEFAULT '0',
  `ignoreemptywarning` tinyint(1) NOT NULL DEFAULT '0',
  `ignoreemptywarningtimer` bigint(20) NOT NULL DEFAULT '0',
  `message_times` varchar(50) NOT NULL DEFAULT '',
  `forgingdeg` int(11) NOT NULL DEFAULT '0',
  `tutorialstage` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`player_id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=42911 DEFAULT CHARSET=latin1;