delimiter $$

CREATE TABLE `property_info` (
  `attachment_type` varchar(200) DEFAULT NULL,
  `addressline` varchar(200) DEFAULT NULL,
  `cityname` varchar(200) DEFAULT NULL,
  `postalcode` varchar(200) DEFAULT NULL,
  `statecode` varchar(200) DEFAULT NULL,
  `attachmenttype` varchar(200) DEFAULT NULL,
  `constructionmethodtype` varchar(200) DEFAULT NULL,
  `deedrestrictionindicator` varchar(45) DEFAULT NULL,
  `propertystructurebuiltyear` varchar(45) DEFAULT NULL,
  `propertyusagetype` varchar(200) DEFAULT NULL,
  `propertyvaluationmethodtype` varchar(500) DEFAULT NULL,
  `closingcostcontamount` int(11) DEFAULT NULL,
  `closingcostfundtype` varchar(45) DEFAULT NULL,
  `disbursementtype` varchar(45) DEFAULT NULL,
  `totalmonthlyproposedamount` int(11) DEFAULT NULL,
  `underwritingsystemtype` varchar(45) DEFAULT NULL,
  `interestrate` float DEFAULT NULL,
  `BorrowerName` varchar(100) DEFAULT NULL,
  `BorrowerSignature` varchar(100) DEFAULT NULL,
  `AccountNumber` varchar(45) DEFAULT NULL,
  `maritalstatus` varchar(45) DEFAULT NULL,
  `phone` varchar(45) DEFAULT NULL,
  `email` varchar(200) DEFAULT NULL,
  `dob` varchar(45) DEFAULT NULL,
  `ssn` varchar(45) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1$$