CREATE TABLE `Account` (
  `Id` varchar(255) NOT NULL,
  `AccountRepresentative` varchar(255) DEFAULT NULL,
  `AnnualRevenue` varchar(255) DEFAULT NULL,
  `BillingCity` varchar(255) DEFAULT NULL,
  `BillingCountry` varchar(255) DEFAULT NULL,
  `BillingPostalCode` varchar(255) DEFAULT NULL,
  `BillingState` varchar(255) DEFAULT NULL,
  `BillingStreet` varchar(255) DEFAULT NULL,
  `Description` varchar(255) DEFAULT NULL,
  `Fax` varchar(255) DEFAULT NULL,
  `Industry` varchar(255) DEFAULT NULL,
  `LastModifiedDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP() ON UPDATE CURRENT_TIMESTAMP(),
  `LastModifiedById` varchar(255),
  `Name` varchar(255) DEFAULT NULL,
  `NumberOfEmployees` int(11) DEFAULT NULL,
  `Phone` varchar(255) DEFAULT NULL,
  `ShippingCity` varchar(255) DEFAULT NULL,
  `ShippingCountry` varchar(255) DEFAULT NULL,
  `ShippingPostalCode` varchar(255) DEFAULT NULL,
  `ShippingState` varchar(255) DEFAULT NULL,
  `ShippingStreet` varchar(255) DEFAULT NULL,
  `Website` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
