CREATE TABLE IF NOT EXISTS `olympiad_nobles` (
  `charId` INT UNSIGNED NOT NULL default 0,
  `class_id` decimal(3,0) NOT NULL default 0,
  `olympiad_points` decimal(10,0) NOT NULL default 0,
  `competitions_done` decimal(3,0) NOT NULL default 0,
  `competitions_won` decimal(3,0) NOT NULL default 0,
  `competitions_lost` decimal(3,0) NOT NULL default 0,
  `competitions_drawn` decimal(3,0) NOT NULL default 0,
  PRIMARY KEY (`charId`)
);