DROP TABLE IF EXISTS `agents`;
CREATE TABLE `agents` (
  `id` bigint(21) NOT NULL auto_increment,
  `first_name` varchar(255) default NULL,
  `last_name` varchar(255) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=782 DEFAULT CHARSET=latin1 AUTO_INCREMENT=782 ;

-- --------------------------------------------------------

-- 
-- Table structure for table `areas`
-- 

DROP TABLE IF EXISTS `areas`;
CREATE TABLE `areas` (
  `id` mediumint(8) unsigned NOT NULL auto_increment,
  `name` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=83 DEFAULT CHARSET=latin1 AUTO_INCREMENT=83 ;

-- --------------------------------------------------------

-- 
-- Table structure for table `listings`
-- 

DROP TABLE IF EXISTS `listings`;
CREATE TABLE `listings` (
  `id` bigint(21) NOT NULL auto_increment,
  `mls` varchar(50) default NULL,
  `created` datetime NOT NULL default '0000-00-00 00:00:00',
  `modified` datetime NOT NULL default '0000-00-00 00:00:00',
  `address` varchar(255) NOT NULL default '',
  `address2` varchar(255) NOT NULL default '',
  `city` varchar(255) NOT NULL default '',
  `state` char(2) NOT NULL default '',
  `zip` varchar(10) NOT NULL default '',
  `status` tinyint(1) NOT NULL default '0',
  `listing_price` float(11,2) NOT NULL default '0.00',
  `property_type_id` bigint(21) default NULL,
  `street_direction` varchar(255) NOT NULL default '',
  `street_post_direction` varchar(255) NOT NULL default '',
  `subdivision_id` bigint(21) default NULL,
  `area_id` mediumint(8) unsigned NOT NULL default '0',
  `type` smallint(1) default NULL,
  `school_1_id` bigint(21) default NULL,
  `school_2_id` bigint(21) default NULL,
  `school_3_id` bigint(21) default NULL,
  `sqft` int(6) default NULL,
  `acres` float(20,3) default NULL,
  `lot_sqft` int(7) default NULL,
  `year_built` int(4) default NULL,
  `resi_ltfr` int(5) NOT NULL default '0',
  `resi_ltlt` int(5) NOT NULL default '0',
  `resi_ltrt` int(5) NOT NULL default '0',
  `resi_ltrr` int(5) NOT NULL default '0',
  `bedrooms` smallint(2) NOT NULL default '0',
  `full_bathrooms` smallint(2) NOT NULL default '0',
  `half_bathrooms` smallint(2) NOT NULL default '0',
  `resi_appl` varchar(255) NOT NULL default '',
  `resi_dind` varchar(255) NOT NULL default '',
  `resi_flor` varchar(255) NOT NULL default '',
  `resi_fire` varchar(255) NOT NULL default '',
  `resi_intr` varchar(255) NOT NULL default '',
  `resi_extf` varchar(255) NOT NULL default '',
  `resi_wate` varchar(255) NOT NULL default '',
  `resi_wtrt` varchar(255) NOT NULL default '',
  `resi_wtrv` varchar(255) NOT NULL default '',
  `resi_wtrs` varchar(255) NOT NULL default '',
  `resi_wtvt` varchar(255) NOT NULL default '',
  `resi_annd` varchar(255) NOT NULL default '',
  `longitude` varchar(255) NOT NULL default '',
  `latitude` varchar(255) NOT NULL default '',
  `agent_id` bigint(21) NOT NULL default '0',
  `marketing_remarks` text NOT NULL,
  `photo_count` smallint(3) NOT NULL default '0',
  `office_id` bigint(21) NOT NULL default '0',
  `land_prop` varchar(255) NOT NULL default '',
  `land_wate` varchar(255) NOT NULL default '',
  `land_wtrt` varchar(255) NOT NULL default '',
  `land_wtrv` varchar(255) NOT NULL default '',
  `land_wtvt` varchar(255) NOT NULL default '',
  `land_ltfr` varchar(255) NOT NULL default '',
  `land_ltlt` varchar(255) NOT NULL default '',
  `land_ltrt` varchar(255) NOT NULL default '',
  `land_ltrr` varchar(255) NOT NULL default '',
  `land_irrl` varchar(255) NOT NULL default '',
  `land_topo` varchar(255) NOT NULL default '',
  `land_util` varchar(255) NOT NULL default '',
  `land_potu` varchar(255) NOT NULL default '',
  `land_sept` varchar(255) NOT NULL default '',
  `land_misc` varchar(255) NOT NULL default '',
  `land_utav` varchar(255) NOT NULL default '',
  `rets_status` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=7742 DEFAULT CHARSET=latin1 AUTO_INCREMENT=7742 ;

-- --------------------------------------------------------

-- 
-- Table structure for table `property_types`
-- 

DROP TABLE IF EXISTS `property_types`;
CREATE TABLE `property_types` (
  `id` bigint(21) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=206 DEFAULT CHARSET=latin1 AUTO_INCREMENT=206 ;

-- --------------------------------------------------------

-- 
-- Table structure for table `schools`
-- 

DROP TABLE IF EXISTS `schools`;
CREATE TABLE `schools` (
  `id` bigint(21) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=39 DEFAULT CHARSET=latin1 AUTO_INCREMENT=39 ;

-- --------------------------------------------------------

-- 
-- Table structure for table `subdivisions`
-- 

DROP TABLE IF EXISTS `subdivisions`;
CREATE TABLE `subdivisions` (
  `id` bigint(21) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=539 DEFAULT CHARSET=latin1 AUTO_INCREMENT=539 ;

-- --------------------------------------------------------

-- 
-- Table structure for table `updates`
-- 

DROP TABLE IF EXISTS `updates`;
CREATE TABLE `updates` (
  `id` bigint(21) NOT NULL auto_increment,
  `created` datetime NOT NULL default '0000-00-00 00:00:00',
  `unlocked` datetime default NULL,
  `rows` mediumint(5) NOT NULL default '0',
  `orphaned` tinyint(1) NOT NULL default '0',
  `resi_query` text NOT NULL,
  `land_query` text NOT NULL,
  `resi_response` text NOT NULL,
  `land_response` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1576 DEFAULT CHARSET=latin1 AUTO_INCREMENT=1576 ;