olympiad_nobles_eom.sql 532 B

12345678910
  1. CREATE TABLE IF NOT EXISTS `olympiad_nobles_eom` (
  2. `charId` int(10) 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;