olympiad_fights.sql 570 B

123456789101112
  1. CREATE TABLE IF NOT EXISTS `olympiad_fights` (
  2. `charOneId` int(10) unsigned NOT NULL,
  3. `charTwoId` int(10) unsigned NOT NULL,
  4. `charOneClass` tinyint(3) unsigned NOT NULL DEFAULT '0',
  5. `charTwoClass` tinyint(3) unsigned NOT NULL DEFAULT '0',
  6. `winner` tinyint(1) unsigned NOT NULL DEFAULT '0',
  7. `start` bigint(13) unsigned NOT NULL DEFAULT '0',
  8. `time` bigint(13) unsigned NOT NULL DEFAULT '0',
  9. `classed` tinyint(1) unsigned NOT NULL DEFAULT '0',
  10. KEY `charOneId` (`charOneId`),
  11. KEY `charTwoId` (`charTwoId`)
  12. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;