CREATE TABLE IF NOT EXISTS `server2146_character_stats` (
  `id` int(11) NOT NULL DEFAULT '0',
  `name` varchar(255) DEFAULT NULL,
  `oldid` int(11) NOT NULL DEFAULT '0',
  `attack_level` int(11) NOT NULL DEFAULT '1',
  `attack_xp` double NOT NULL DEFAULT '0',
  `defence_level` int(11) NOT NULL DEFAULT '1',
  `defence_xp` double NOT NULL DEFAULT '0',
  `strength_level` int(11) NOT NULL DEFAULT '1',
  `strength_xp` double NOT NULL DEFAULT '0',
  `hitpoints_level` int(11) NOT NULL DEFAULT '10',
  `hitpoints_xp` double NOT NULL DEFAULT '1300',
  `ranged_level` int(11) NOT NULL DEFAULT '1',
  `ranged_xp` double NOT NULL DEFAULT '0',
  `prayer_level` int(11) NOT NULL DEFAULT '1',
  `prayer_xp` double NOT NULL DEFAULT '0',
  `magic_level` int(11) NOT NULL DEFAULT '1',
  `magic_xp` double NOT NULL DEFAULT '0',
  `cooking_level` int(11) NOT NULL DEFAULT '1',
  `cooking_xp` double NOT NULL DEFAULT '0',
  `woodcutting_level` int(11) NOT NULL DEFAULT '1',
  `woodcutting_xp` double NOT NULL DEFAULT '0',
  `fletching_level` int(11) NOT NULL DEFAULT '1',
  `fletching_xp` double NOT NULL DEFAULT '0',
  `fishing_level` int(11) NOT NULL DEFAULT '1',
  `fishing_xp` double NOT NULL DEFAULT '0',
  `firemaking_level` int(11) NOT NULL DEFAULT '1',
  `firemaking_xp` double NOT NULL DEFAULT '0',
  `crafting_level` int(11) NOT NULL DEFAULT '1',
  `crafting_xp` double NOT NULL DEFAULT '0',
  `smithing_level` int(11) NOT NULL DEFAULT '1',
  `smithing_xp` double NOT NULL DEFAULT '0',
  `mining_level` int(11) NOT NULL DEFAULT '1',
  `mining_xp` double NOT NULL DEFAULT '0',
  `herblore_level` int(11) NOT NULL DEFAULT '1',
  `herblore_xp` double NOT NULL DEFAULT '0',
  `agility_level` int(11) NOT NULL DEFAULT '1',
  `agility_xp` double NOT NULL DEFAULT '0',
  `thieving_level` int(11) NOT NULL DEFAULT '1',
  `thieving_xp` double NOT NULL DEFAULT '0',
  `slayer_level` int(11) NOT NULL DEFAULT '1',
  `slayer_xp` double NOT NULL DEFAULT '0',
  `farming_level` int(11) NOT NULL DEFAULT '1',
  `farming_xp` double NOT NULL DEFAULT '0',
  `runecrafting_level` int(11) NOT NULL DEFAULT '1',
  `runecrafting_xp` double NOT NULL DEFAULT '0',
  `total_level` int(11) DEFAULT '30',
  `total_xp` double DEFAULT '1300',
  `combat` int(11) DEFAULT '3',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id_UNIQUE` (`id`),
  KEY `uid` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;