CREATE TABLE `stats` (
  `player_name` varchar(15) NOT NULL,
  `rights` double DEFAULT NULL,
  `title_id` varchar(10) NOT NULL,
  `game_mode` int(11) NOT NULL,
  `prestige` int(11) NOT NULL,
  `totallvl` double NOT NULL,
  `totalxp` double DEFAULT NULL,
  `combat_lvl` varchar(10) NOT NULL,
  `Attacklvl` double DEFAULT NULL,
  `Attackxp` double DEFAULT NULL,
  `Defencelvl` double DEFAULT NULL,
  `Defencexp` double DEFAULT NULL,
  `Strengthlvl` double DEFAULT NULL,
  `Strengthxp` double DEFAULT NULL,
  `Hitpointslvl` double DEFAULT NULL,
  `Hitpointsxp` double DEFAULT NULL,
  `Rangelvl` double DEFAULT NULL,
  `Rangexp` double DEFAULT NULL,
  `Prayerlvl` double DEFAULT NULL,
  `Prayerxp` double DEFAULT NULL,
  `Magiclvl` double DEFAULT NULL,
  `Magicxp` double DEFAULT NULL,
  `Cookinglvl` double DEFAULT NULL,
  `Cookingxp` double DEFAULT NULL,
  `Woodcuttinglvl` double DEFAULT NULL,
  `Woodcuttingxp` double DEFAULT NULL,
  `Fletchinglvl` double DEFAULT NULL,
  `Fletchingxp` double DEFAULT NULL,
  `Fishinglvl` double DEFAULT NULL,
  `Fishingxp` double DEFAULT NULL,
  `Firemakinglvl` double DEFAULT NULL,
  `Firemakingxp` double DEFAULT NULL,
  `Craftinglvl` double DEFAULT NULL,
  `Craftingxp` double DEFAULT NULL,
  `Smithinglvl` double DEFAULT NULL,
  `Smithingxp` double DEFAULT NULL,
  `Mininglvl` double DEFAULT NULL,
  `Miningxp` double DEFAULT NULL,
  `Herblorelvl` double DEFAULT NULL,
  `Herblorexp` double DEFAULT NULL,
  `Agilitylvl` double DEFAULT NULL,
  `Agilityxp` double DEFAULT NULL,
  `Thievinglvl` double DEFAULT NULL,
  `Thievingxp` double DEFAULT NULL,
  `Slayerlvl` double DEFAULT NULL,
  `Slayerxp` double DEFAULT NULL,
  `Farminglvl` double DEFAULT NULL,
  `Farmingxp` double DEFAULT NULL,
  `Runecraftlvl` double DEFAULT NULL,
  `Runecraftxp` double DEFAULT NULL,
  `Hunterlvl` double DEFAULT NULL,
  `Hunterxp` double DEFAULT NULL,
  `Constructionlvl` double DEFAULT NULL,
  `Constructionxp` double DEFAULT NULL,
  `Summoninglvl` double DEFAULT NULL,
  `Summoningxp` double DEFAULT NULL,
  `Dungeoneeringlvl` double DEFAULT NULL,
  `Dungeoneeringxp` double DEFAULT NULL,
  PRIMARY KEY (`player_name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;