olympiad_nobles_eom.sql 528 B

12345678910
  1. CREATE TABLE IF NOT EXISTS `olympiad_nobles_eom` (
  2. `charId` INT UNSIGNED NOT NULL default 0,
  3. `class_id` tinyint(3) UNSIGNED NOT NULL default 0,
  4. `olympiad_points` int(10) UNSIGNED NOT NULL default 0,
  5. `competitions_done` smallint(3) UNSIGNED NOT NULL default 0,
  6. `competitions_won` smallint(3) UNSIGNED NOT NULL default 0,
  7. `competitions_lost` smallint(3) UNSIGNED NOT NULL default 0,
  8. `competitions_drawn` smallint(3) UNSIGNED NOT NULL default 0,
  9. PRIMARY KEY (`charId`)
  10. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;