delimiter $$

CREATE TABLE `sfaccount` (
  `ACCOUNTNUMBER` varchar(15) DEFAULT NULL,
  `ACTIVE__C` varchar(20) DEFAULT NULL,
  `ANNUALREVENUE` varchar(30) DEFAULT NULL,
  `BILLINGCITY` varchar(20) DEFAULT NULL,
  `BILLINGCOUNTRY` varchar(20) DEFAULT NULL,
  `BILLINGPOSTALCODE` varchar(20) DEFAULT NULL,
  `BILLINGSTATE` varchar(20) DEFAULT NULL,
  `BILLINGSTREET` varchar(120) DEFAULT NULL,
  `CREATEDBYID` varchar(30) DEFAULT NULL,
  `CREATEDDATE` varchar(30) DEFAULT NULL,
  `CUSTOMERPRIORITY__C` varchar(20) DEFAULT NULL,
  `DESCRIPTION` varchar(500) DEFAULT NULL,
  `FAX` varchar(20) DEFAULT NULL,
  `INDUSTRY` varchar(40) DEFAULT NULL,
  `LASTMODIFIEDBYID` varchar(30) DEFAULT NULL,
  `LASTMODIFIEDDATE` varchar(30) DEFAULT NULL,
  `NAME` varchar(50) DEFAULT NULL,
  `NUMBEROFEMPLOYEES` varchar(20) DEFAULT NULL,
  `NUMBEROFLOCATIONS__C` varchar(20) DEFAULT NULL,
  `OWNERID` varchar(30) DEFAULT NULL,
  `OWNERSHIP` varchar(30) DEFAULT NULL,
  `PARENTID` varchar(30) DEFAULT NULL,
  `PHONE` varchar(30) DEFAULT NULL,
  `RATING` varchar(20) DEFAULT NULL,
  `SLAEXPIRATIONDATE__C` varchar(30) DEFAULT NULL,
  `SLASERIALNUMBER__C` varchar(40) DEFAULT NULL,
  `SLA__C` varchar(40) DEFAULT NULL,
  `SHIPPINGCITY` varchar(20) DEFAULT NULL,
  `SHIPPINGCOUNTRY` varchar(20) DEFAULT NULL,
  `SHIPPINGPOSTALCODE` varchar(20) DEFAULT NULL,
  `SHIPPINGSTATE` varchar(20) DEFAULT NULL,
  `SHIPPINGSTREET` varchar(500) DEFAULT NULL,
  `SIC` varchar(30) DEFAULT NULL,
  `SITE` varchar(50) DEFAULT NULL,
  `SYSTEMMODSTAMP` varchar(30) DEFAULT NULL,
  `TICKERSYMBOL` varchar(30) DEFAULT NULL,
  `TYPE` varchar(20) DEFAULT NULL,
  `UPSELLOPPORTUNITY__C` varchar(30) DEFAULT NULL,
  `WEBSITE` varchar(50) DEFAULT NULL,
  `STATUS` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1$$

