CREATE TABLE `tt_46` ( `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(225) default NULL, `State/Province` varchar(225) default NULL, `Zip/Postal` varchar(30) default NULL, `Country` varchar(225) default NULL, `Required skills` varchar(225) default NULL, `Job length` varchar(225) default NULL, `Pay rate` varchar(225) default NULL, `Start date` varchar(225) default NULL, FULLTEXT (`Title`,`Description`), PRIMARY KEY (`ID`) ) TYPE = MYISAM AUTO_INCREMENT=2 ;