CREATE TABLE `table_1` (<br>
  `ID` int(11) NOT NULL AUTO_INCREMENT,<br>
  `version` varchar(200) NOT NULL,<br>
  `filename` varchar(200) NOT NULL,<br>
  `size` int(11) DEFAULT NULL,<br>
  `MD5_checksum` varchar(200) DEFAULT NULL,<br>
  `release_notes` varchar(200) NOT NULL,<br>
  `remark` varchar(2000) DEFAULT NULL,<br>
  `rec_level` int(11) NOT NULL,<br>
  `date_rec_green` date DEFAULT NULL,<br>
  `date_rec_yellow` date DEFAULT NULL,<br>
  `date_rec_red` date DEFAULT NULL,<br>
  `date_compl_green` date DEFAULT NULL,<br>
  `date_comp_yellow` date DEFAULT NULL,<br>
  `date_compl_red` date DEFAULT NULL,<br>
  `os_type` int(11) DEFAULT NULL,<br>
  `feature_set` int(11) DEFAULT NULL,<br>
  PRIMARY KEY (`ID`),<br>
  UNIQUE KEY `ID_UNIQUE` (`ID`),<br>
  KEY `fk_firmware_rec_level` (`rec_level`),<br>
  KEY `fk_firmware_os_type` (`os_type`),<br>
  KEY `fk_firmware_feature_set` (`feature_set`),<br>
  CONSTRAINT `fk_firmware_feature_set` FOREIGN KEY (`feature_set`) REFERENCES <br>`nl_firmware_feature_set` (`ID`) ON DELETE NO ACTION ON UPDATE NO ACTION,<br>
  CONSTRAINT `fk_firmware_os_type` FOREIGN KEY (`os_type`) REFERENCES <br>`nl_firmware_os_type` (`ID`) ON DELETE NO ACTION ON UPDATE NO ACTION,<br>
  CONSTRAINT `fk_firmware_rec_level` FOREIGN KEY (`rec_level`) REFERENCES <br>`nl_firmware_rec_level` (`ID`) ON DELETE NO ACTION ON UPDATE NO ACTION<br>
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8$$<br>