Create Table

CREATE TABLE `address` (
  `addressId` int(10) NOT NULL,
  `address1` varchar(100) DEFAULT NULL,
  `address2` varchar(100) DEFAULT NULL,
  `postcode` varchar(10) DEFAULT NULL,
  `startDate` datetime DEFAULT NULL,
  `endDate` datetime DEFAULT NULL,
  `address3` varchar(100) DEFAULT NULL,
  `address4` varchar(100) DEFAULT NULL,
  `address5` varchar(100) DEFAULT NULL,
  `upduser` varchar(50) DEFAULT NULL,
  `upddate` datetime DEFAULT NULL,
  `creuser` varchar(50) DEFAULT NULL,
  `credate` datetime DEFAULT NULL,
  `deluser` varchar(50) DEFAULT NULL,
  `deldate` datetime DEFAULT NULL,
  `noOfYearsAtAddress` int(10) DEFAULT NULL,
  `propertyOwnershipType` varchar(10) DEFAULT NULL,
  `propertyTypeOther` varchar(50) DEFAULT NULL,
  `noOfMonthsAtAddress` int(10) DEFAULT NULL,
  `versionNum` int(10) DEFAULT '0',
  `flatNumberName` varchar(100) DEFAULT NULL,
  `houseNumberName` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`addressId`),
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

insert into `address` (`addressId`, `address1`, `address2`, `postcode`, `startDate`, `endDate`, `address3`, `address4`, `address5`, `upduser`, `upddate`, `creuser`, `credate`, `deluser`, `deldate`, `noOfYearsAtAddress`, `propertyOwnershipType`, `propertyTypeOther`, `noOfMonthsAtAddress`, `versionNum`, `flatNumberName`, `houseNumberName`) values('1','address1','address1','SS9 3HG',NULL,NULL,'address3','address4','UK',NULL,NULL,'riderj','2005-08-29 05:21:31',NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL);