CREATE TABLE `showclassentries` (
  `IDLNK` int(11) NOT NULL AUTO_INCREMENT,
  `EntryIDLNK` int(11) NOT NULL,
  `ClassIDLNK` int(11) NOT NULL,
  `Result` int(11) DEFAULT NULL,
  `Entered_Date` datetime DEFAULT NULL,
  `Deleted` tinyint(1) NOT NULL,
  PRIMARY KEY (`IDLNK`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1