CREATE TABLE `tt_45` ( `ID` int(11) NOT NULL auto_increment, `Title` varchar(225) default NULL, `Hits` int(11) default NULL, `PostDate` date default NULL, `Description` text, `CategoryID` int(11) default NULL, `Featured` varchar(5) default NULL, `MemberID` int(11) default NULL, `ExpireDate` date default NULL, `Latitude` varchar(60) default NULL, `Longitude` varchar(60) default NULL, `Address` varchar(100) default NULL, `City` varchar(60) default NULL, `State/Province` varchar(40) default NULL, `Zip/Postal` varchar(30) default NULL, `Country` varchar(60) default NULL, `Rent ($)` varchar(225) default NULL, `Property Type` varchar(225) default NULL, `Bed(s)` varchar(225) default NULL, `Bath(s)` varchar(225) default NULL, `Security Deposit` varchar(225) default NULL, `Date unit is available` varchar(225) default NULL, `Square Footage` varchar(225) default NULL, `Year Built` varchar(225) default NULL, `School District` varchar(225) default NULL, `Neighborhood` varchar(225) default NULL, `Features` varchar(225) default NULL, `Pets` varchar(225) default NULL, `Virtual Tour URL` varchar(225) default NULL, FULLTEXT (`Title`,`Description`), PRIMARY KEY (`ID`) ) TYPE = MYISAM AUTO_INCREMENT=2 ;