CREATE TABLE `showentries` (
  `IDLNK` int(11) NOT NULL AUTO_INCREMENT,
  `Name` varchar(100) NOT NULL,
  `Age` varchar(4) NOT NULL,
  `Address_1` varchar(255) DEFAULT NULL,
  `Address_2` varchar(255) DEFAULT NULL,
  `Address_City` varchar(255) DEFAULT NULL,
  `Address_Postcode` varchar(20) DEFAULT NULL,
  `Email` varchar(100) NOT NULL,
  `Phone` varchar(50) DEFAULT NULL,
  `Year_IDLNK` int(11) NOT NULL,
  `Entered_Date` datetime DEFAULT NULL,
  `Deleted` tinyint(1) NOT NULL,
  PRIMARY KEY (`IDLNK`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1