CREATE TABLE IF NOT EXISTS `server2146_characters` ( `id` int(11) NOT NULL DEFAULT '0', `name` varchar(25) NOT NULL DEFAULT '', `height` tinyint(4) NOT NULL DEFAULT '0', `x` smallint(6) NOT NULL DEFAULT '2606', `y` smallint(6) NOT NULL DEFAULT '3102', `fightStyle` tinyint(4) NOT NULL DEFAULT '1', `energy` int(11) DEFAULT '100', `questPoints` int(11) DEFAULT NULL, `skullTimer` int(11) DEFAULT NULL, `specAmount` int(11) DEFAULT '100', `teleBlockLength` int(11) DEFAULT NULL, `autoRetaliate` tinyint(4) DEFAULT NULL, `accountFlagged` tinyint(4) DEFAULT NULL, `mageArenaPoints` int(11) DEFAULT NULL, `taskId` int(11) DEFAULT NULL, `taskAmount` int(11) DEFAULT NULL, `slayerPoints` int(11) DEFAULT NULL, `bank` longtext, `equipment` longtext, `inventory` longtext, `look` longtext, `friends` longtext, `addStarter` tinyint(1) DEFAULT '1', `splitChat` tinyint(1) DEFAULT '1', `uuid` varchar(255) DEFAULT NULL, `playerVotePoints` int(11) DEFAULT '0', `playerLevelPoints` int(11) DEFAULT '0', `playerAssaultPoints` int(11) DEFAULT '0', `playerCWGames` int(11) DEFAULT '0', `playerLockedXP` int(1) DEFAULT '0', `playerMembership` int(1) DEFAULT '0', `playerXPModifier` decimal(10,0) DEFAULT '0', `playerLastLogin` datetime DEFAULT '0000-00-00 00:00:00', `playerDesertTreasure` int(11) DEFAULT '0', `playerDTKill` int(11) DEFAULT '0', `playerHFD` int(11) DEFAULT '0', `playerRFDRound` int(11) DEFAULT '0', `playerCookAss` int(11) DEFAULT '0', `playerRuneMysteries` int(1) DEFAULT '0', `playerDoricsQuest` int(1) DEFAULT '0', `playerDemonSlayer` int(1) DEFAULT '0', `playerIncantation` int(1) DEFAULT '0', `playerBoneSearch` int(1) DEFAULT '0', `playerCaptainbRov` int(1) DEFAULT '0', `playerTrailBorn` int(1) DEFAULT '0', `playerCrystalbowShots` int(11) DEFAULT '0', `playerJail` int(11) DEFAULT '0', `playerPlaytime` int(11) DEFAULT '0', `playerMagicBook` int(3) DEFAULT '1', `playerBrotherInfo` varchar(45) DEFAULT '0 0,1 0,2 0,3 0,4 0,5 0', `playerSelectedCoffin` int(3) DEFAULT '0', `playerBarrowsKills` int(11) DEFAULT '0', `playerPouch` varchar(45) DEFAULT '0 0 0 0', `playerPCPoints` int(11) DEFAULT '0', `playerRemovedTask1` int(1) DEFAULT '0', `playerRemovedTask2` int(1) DEFAULT '0', `playerRemovedTask3` int(1) DEFAULT '0', `playerRemovedTask4` int(1) DEFAULT '0', `playerPKPoints` int(11) DEFAULT '0', `playerFMPoints` int(11) DEFAULT '0', `playerRogueKills` int(11) DEFAULT '0', `playerBountyKills` int(11) DEFAULT '0', `playerSafeTimer` int(11) DEFAULT '0', `playerPenaltyTimer` int(1) DEFAULT '0', `playerKillsMultiplier` int(3) DEFAULT '1', `playerWave` int(11) DEFAULT '0', `playerGWKC` int(11) DEFAULT '0', `playerVoid` varchar(45) DEFAULT '0 0 0 0', `playerCompletedTutorial` int(1) DEFAULT '0', `playerTutorial` varchar(45) DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `id_UNIQUE` (`id`), KEY `id` (`id`), FULLTEXT KEY `name` (`name`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1;