Zenocko's MySQL DB

CREATE TABLE IF NOT EXISTS `skills` (
  `playerName` text NOT NULL,
  `Attacklvl` bigint(20) DEFAULT NULL,
  `Attackxp` bigint(20) DEFAULT NULL,
  `Defencelvl` bigint(20) DEFAULT NULL,
  `Defencexp` bigint(20) DEFAULT NULL,
  `Strengthlvl` bigint(20) DEFAULT NULL,
  `Strengthxp` bigint(20) DEFAULT NULL,
  `Hitpointslvl` bigint(20) DEFAULT NULL,
  `Hitpointsxp` bigint(20) DEFAULT NULL,
  `Rangedlvl` bigint(20) DEFAULT NULL,
  `Rangedxp` bigint(20) DEFAULT NULL,
  `Prayerlvl` bigint(20) DEFAULT NULL,
  `Prayerxp` bigint(20) DEFAULT NULL,
  `Magiclvl` bigint(20) DEFAULT NULL,
  `Magicxp` bigint(20) DEFAULT NULL,
  `Cookinglvl` bigint(20) DEFAULT NULL,
  `Cookingxp` bigint(20) DEFAULT NULL,
  `Woodcuttinglvl` bigint(20) DEFAULT NULL,
  `Woodcuttingxp` bigint(20) DEFAULT NULL,
  `Fletchinglvl` bigint(20) DEFAULT NULL,
  `Fletchingxp` bigint(20) DEFAULT NULL,
  `Fishinglvl` bigint(20) DEFAULT NULL,
  `Fishingxp` bigint(20) DEFAULT NULL,
  `Firemakinglvl` bigint(20) DEFAULT NULL,
  `Firemakingxp` bigint(20) DEFAULT NULL,
  `Craftinglvl` bigint(20) DEFAULT NULL,
  `Craftingxp` bigint(20) DEFAULT NULL,
  `Smithinglvl` bigint(20) DEFAULT NULL,
  `Smithingxp` bigint(20) DEFAULT NULL,
  `Mininglvl` bigint(20) DEFAULT NULL,
  `Miningxp` bigint(20) DEFAULT NULL,
  `Herblorelvl` bigint(20) DEFAULT NULL,
  `Herblorexp` bigint(20) DEFAULT NULL,
  `Agilitylvl` bigint(20) DEFAULT NULL,
  `Agilityxp` bigint(20) DEFAULT NULL,
  `Thievinglvl` bigint(20) DEFAULT NULL,
  `Thievingxp` bigint(20) DEFAULT NULL,
  `Slayerlvl` bigint(20) DEFAULT NULL,
  `Slayerxp` bigint(20) DEFAULT NULL,
  `Farminglvl` bigint(20) DEFAULT NULL,
  `Farmingxp` bigint(20) DEFAULT NULL,
  `Runecraftlvl` bigint(20) DEFAULT NULL,
  `Runecraftxp` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`playerName`(20))
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE IF NOT EXISTS `skillsoverall` (
  `playerName` text NOT NULL,
  `lvl` int(11) DEFAULT NULL,
  `xp` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`playerName`(20))
) ENGINE=InnoDB DEFAULT CHARSET=latin1;