mysql> show create table hit_counter;
+-------------+-----------------------------------------------------------------------+
| Table       | Create Table                                                          |
+-------------+-----------------------------------------------------------------------+
| hit_counter | CREATE TABLE `hit_counter` (
  `hid` int(10) unsigned NOT NULL auto_increment,
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP,
  `ip` text collate latin1_general_ci NOT NULL,
  `useragent` text collate latin1_general_ci NOT NULL,
  `refer` text collate latin1_general_ci NOT NULL,
  `url` text collate latin1_general_ci NOT NULL,
  `user` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`hid`)
) ENGINE=MyISAM AUTO_INCREMENT=12054 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci |
+-------------+-----------------------------------------------------------------------+
1 row in set (0.00 sec)

mysql> show create table grar_property_res;
+-------------------+----------------------------------------------------------------+
| Table             | Create Table                                                   |
+-------------------+----------------------------------------------------------------+
| grar_property_res |CREATE TABLE `grar_property_res` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `lat` double default NULL,
  `lng` double default NULL,
  `active` tinyint(1) unsigned NOT NULL default '1',
  `provider` text collate latin1_general_ci NOT NULL,
  `MLSNUM` text collate latin1_general_ci,
  `ACRES` double default NULL,
  `APPLIANCES` text collate latin1_general_ci,
  `AREA` text collate latin1_general_ci,
  `ASSESSEDVALUE` int(11) default NULL,
  `ATTIC` text collate latin1_general_ci,
  `BASEDESC` text collate latin1_general_ci,
  `BATHSFULL` int(2) default NULL,
  `BATHSHALF` int(2) default NULL,
  `BATHSTOTAL` int(2) default NULL,
  `BEDS` int(2) default NULL,
  `CLOSEDDATE` timestamp NULL default NULL,
  `CONSTRUCTION` text collate latin1_general_ci,
  `COUNTY` text collate latin1_general_ci,
  `DIRECTIONS` text collate latin1_general_ci,
  `DIRECTIONSTEXT` text collate latin1_general_ci,
  `DRIVEWAY` text collate latin1_general_ci,
  `EXTERIOR` text collate latin1_general_ci,
  `FLOORS` text collate latin1_general_ci,
  `GARAGECAP` double default NULL,
  `GARAGEDESC` text collate latin1_general_ci,
  `HEATSRC` text collate latin1_general_ci,
  `HEATSYSTEM` text collate latin1_general_ci,
  `INTERIOR` text collate latin1_general_ci,
  `LISTDATE` timestamp NULL default NULL,
  `LISTPRICE` int(11) default NULL,
  `LISTPRICEORIG` int(11) default NULL,
  `LISTSTATUS` text collate latin1_general_ci,
  `LOTDIM` text collate latin1_general_ci,
  `LOTINFO` text collate latin1_general_ci,
  `MODIFIED` text collate latin1_general_ci,
  `OFFICELIST` text collate latin1_general_ci,
  `OFFICELIST_OFFNAME` text collate latin1_general_ci,
  `OFFICESELL` text collate latin1_general_ci,
  `OWNERNAME` text collate latin1_general_ci,
  `PHOTOCOUNT` int(2) default NULL,
  `PROPSUBTYPE` text collate latin1_general_ci,
  `REMARKSPUBLIC` text collate latin1_general_ci,
  `ROOMBATHFULL2LEVEL` text collate latin1_general_ci,
  `ROOMKITCHENDESC` text collate latin1_general_ci,
  `ROOMOTHER` text collate latin1_general_ci,
  `ROOMS` int(2) default NULL,
  `SALESPRICE` int(11) default NULL,
  `SCHOOLDISTRICT` text collate latin1_general_ci,
  `SELLERPAID` int(11) default NULL,
  `SEWER` text collate latin1_general_ci,
  `SPECIALASSESSMENT` int(11) default NULL,
  `SQFTTOTAL` int(11) default NULL,
  `STORMSCREENS` text collate latin1_general_ci,
  `STREETNAME` text collate latin1_general_ci,
  `STREETNUMDISPLAY` text collate latin1_general_ci,
  `STYLE` text collate latin1_general_ci,
  `TAXAMOUNT` double default NULL,
  `WATER` text collate latin1_general_ci,
  `WATERFRONTDESC` text collate latin1_general_ci,
  `WATERFRONTFOOTAGE` int(11) default NULL,
  `WATERFRONTNAME` text collate latin1_general_ci,
  `WATERHEATER` text collate latin1_general_ci,
  `YEARBUILT` int(4) default NULL,
  `ZIPCODE` text collate latin1_general_ci,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1797 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci |
+-------------------+----------------------------------------------------------------+
1 row in set (0.00 sec)

mysql> show create table listings;
+----------+-------------------------------------------------------------------------+
| Table    | Create Table                                                            |
+----------+-------------------------------------------------------------------------+
| listings |CREATE TABLE `listings` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `lat` double default NULL,
  `lng` double default NULL,
  `active` tinyint(1) unsigned NOT NULL default '1',
  `provider` text collate latin1_general_ci NOT NULL,
  `MLSNUM` text collate latin1_general_ci,
  `ACRES` double default NULL,
  `APPLIANCES` text collate latin1_general_ci,
  `AREA` text collate latin1_general_ci,
  `ASSESSEDVALUE` int(11) default NULL,
  `ATTIC` text collate latin1_general_ci,
  `BASEDESC` text collate latin1_general_ci,
  `BATHSFULL` int(2) default NULL,
  `BATHSHALF` int(2) default NULL,
  `BATHSTOTAL` int(2) default NULL,
  `BEDS` int(2) default NULL,
  `CLOSEDDATE` timestamp NULL default NULL,
  `CONSTRUCTION` text collate latin1_general_ci,
  `COUNTY` text collate latin1_general_ci,
  `DIRECTIONS` text collate latin1_general_ci,
  `DIRECTIONSTEXT` text collate latin1_general_ci,
  `DRIVEWAY` text collate latin1_general_ci,
  `EXTERIOR` text collate latin1_general_ci,
  `FLOORS` text collate latin1_general_ci,
  `GARAGECAP` double default NULL,
  `GARAGEDESC` text collate latin1_general_ci,
  `HEATSRC` text collate latin1_general_ci,
  `HEATSYSTEM` text collate latin1_general_ci,
  `INTERIOR` text collate latin1_general_ci,
  `LISTDATE` timestamp NULL default NULL,
  `LISTPRICE` int(11) default NULL,
  `LISTPRICEORIG` int(11) default NULL,
  `LISTSTATUS` text collate latin1_general_ci,
  `LOTDIM` text collate latin1_general_ci,
  `LOTINFO` text collate latin1_general_ci,
  `MODIFIED` text collate latin1_general_ci,
  `OFFICELIST` text collate latin1_general_ci,
  `OFFICELIST_OFFNAME` text collate latin1_general_ci,
  `OFFICESELL` text collate latin1_general_ci,
  `OWNERNAME` text collate latin1_general_ci,
  `PHOTOCOUNT` int(2) default NULL,
  `PROPSUBTYPE` text collate latin1_general_ci,
  `REMARKSPUBLIC` text collate latin1_general_ci,
  `ROOMBATHFULL2LEVEL` text collate latin1_general_ci,
  `ROOMKITCHENDESC` text collate latin1_general_ci,
  `ROOMOTHER` text collate latin1_general_ci,
  `ROOMS` int(2) default NULL,
  `SALESPRICE` int(11) default NULL,
  `SCHOOLDISTRICT` text collate latin1_general_ci,
  `SELLERPAID` int(11) default NULL,
  `SEWER` text collate latin1_general_ci,
  `SPECIALASSESSMENT` int(11) default NULL,
  `SQFTTOTAL` int(11) default NULL,
  `STORMSCREENS` text collate latin1_general_ci,
  `STREETNAME` text collate latin1_general_ci,
  `STREETNUMDISPLAY` text collate latin1_general_ci,
  `STYLE` text collate latin1_general_ci,
  `TAXAMOUNT` double default NULL,
  `WATER` text collate latin1_general_ci,
  `WATERFRONTDESC` text collate latin1_general_ci,
  `WATERFRONTFOOTAGE` int(11) default NULL,
  `WATERFRONTNAME` text collate latin1_general_ci,
  `WATERHEATER` text collate latin1_general_ci,
  `YEARBUILT` int(4) default NULL,
  `ZIPCODE` text collate latin1_general_ci,
  KEY `id` (`id`)
) ENGINE=MRG_MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci UNION=(`grar_property_res`,`grar_property_lnd`) |
+----------+---------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

mysql> exit;