CREATE TABLE `ie_ReportForceStatus` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `reportId` int(11) unsigned NOT NULL,
  `schoolId` int(11) NOT NULL,
  `status` enum('submitted-on-time', 'submitted-late', 'past-due') NOT NULL,
  `changed` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`),
  UNIQUE KEY `reportId_schoolId` (`reportId`, `schoolId`),
  KEY `reportId` (`reportId`),
  KEY `schoolId` (`schoolId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

ALTER TABLE `ie_ReportForceStatus`
    MODIFY `status` enum('not-submitted', 'submitted-on-time', 'submitted-late', 'past-due') NOT NULL;