CREATE TABLE `sites` (
  `IDLNK` int(11) NOT NULL AUTO_INCREMENT,
  `TrustIDLNK` int(11) NOT NULL,
  `Name` varchar(250) NOT NULL,
  `AddressLine1` varchar(250) NOT NULL,
  `AddressLine2` varchar(250) NOT NULL,
  `Town` varchar(250) NOT NULL,
  `Postcode` varchar(10) NOT NULL,
  `Telephone` varchar(20) NOT NULL,
  `Fax` varchar(20) NOT NULL,
  `Deleted` varchar(1) NOT NULL,
  PRIMARY KEY (`IDLNK`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1