12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576
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;