delimiter
$$
CREATE
TABLE `contacts` (
`RowID` int(11) NOT NULL,
`SuperCoreID` varchar(45) DEFAULT NULL,
`SuperOrgName` varchar(100) DEFAULT NULL,
`CoreID` varchar(45) DEFAULT NULL,
`TranDept` varchar(45) DEFAULT NULL,
`TranSubPractice` varchar(45) DEFAULT NULL,
`OrgIssuer` varchar(100) DEFAULT NULL,
`LAM` varchar(45) DEFAULT NULL,
`ContactRole`
varchar(45) DEFAULT NULL,
`Contact Level` varchar(45) DEFAULT NULL,
`Salutation` varchar(45) DEFAULT NULL,
`FirstName` varchar(45) DEFAULT NULL,
`MiddleName` varchar(45) DEFAULT NULL,
`LastName` varchar(45) DEFAULT NULL,
`CompanyName`
varchar(45) DEFAULT NULL,
`Address1` varchar(45) DEFAULT NULL,
`Address2` varchar(45) DEFAULT NULL,
`Address3` varchar(45) DEFAULT NULL,
`City` varchar(45) DEFAULT NULL,
`Postcode` varchar(45) DEFAULT NULL,
`Country` varchar(45) DEFAULT NULL,
`Email` varchar(45) DEFAULT NULL,
`PhoneLand` varchar(45) DEFAULT NULL,
`PhoneMob` varchar(45) DEFAULT NULL,
`RoleInTran` varchar(45) DEFAULT NULL,
`ComReqdInsiders` varchar(45) DEFAULT NULL,
`ComReqdSov` varchar(45) DEFAULT NULL,
`ComeReqdResec` varchar(45) DEFAULT NULL,
PRIMARY KEY (`RowID`)
)
ENGINE=InnoDB DEFAULT CHARSET=utf8$$