-- 
-- Database: `RETSbond_RI`
-- 

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

-- 
-- Table structure for table `mls_type`
-- 

CREATE TABLE `mls_type` (
  `Board` text NOT NULL,
  `Prop_Type` text NOT NULL,
  `Query` text NOT NULL,
  `Query_Data` text NOT NULL,
  `Map2` text NOT NULL
) TYPE=MyISAM;

-- 
-- Dumping data for table `mls_type`
-- 

INSERT INTO `mls_type` VALUES ('ML_Sample', 'RES', 'SearchType=PROPERTY&Class=RES&Select=<Query_Data>&Query=(ListStatus=act),(OfficeList=sample)&Limit=none&Format=COMPACT-DECODED', 'MLSNUM,SALESPRICE,PHOTOCOUNT,LISTSTATUS,ZIPCODE,STREETNAME,STREETNUM,BEDS,BATHSTOTAL,SQFTTOTAL,REMARKSPUBLICTEXT,AGENTSELL_FULLNAME,LOTDESC', 'Null,MLSNum,ListPrice,PhotoCount,ListStatus,Zip,StreetNum,StreetName,Beds,Baths,SqFt,Remarks,AgentFullName,LotDesc');

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

-- 
-- Table structure for table `real_estate`
-- 

CREATE TABLE `real_estate` (
  `MLSNum` text NOT NULL,
  `ListPrice` text NOT NULL,
  `PhotoCount` int(11) NOT NULL default '0',
  `ListStatus` text NOT NULL,
  `StreetNum` text NOT NULL,
  `StreetName` text NOT NULL,
  `Beds` float NOT NULL default '0',
  `Baths` float NOT NULL default '0',
  `SqFt` text NOT NULL,
  `LotSqFt` text NOT NULL,
  `Type` text NOT NULL,
  `Remarks` text NOT NULL,
  `AgentFullName` text NOT NULL,
  `AgentFirstName` text NOT NULL,
  `AgentLastName` text NOT NULL,
  `Office` text NOT NULL,
  `LotDesc` text NOT NULL,
  `Board` text NOT NULL
) TYPE=MyISAM;

-- 
-- Dumping data for table `real_estate`
-- 


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

-- 
-- Table structure for table `rets_lic`
-- 

CREATE TABLE `rets_lic` (
  `Board` text NOT NULL,
  `office` int(11) NOT NULL default '0',
  `host` text NOT NULL,
  `get_meta` text NOT NULL,
  `get_object` text NOT NULL,
  `login` text NOT NULL,
  `search` text NOT NULL,
  `RETS_username` text NOT NULL,
  `RETS_password` text NOT NULL,
  `RETS_relm` text NOT NULL,
  `RETS_get_relm` text NOT NULL,
  `lic_number` text NOT NULL,
  `photo_dir` text NOT NULL,
  `year` text NOT NULL,
  `month` text NOT NULL,
  `RETS_user_agent` text NOT NULL,
  `RETS_user_agent_sub` text NOT NULL,
  `id` int(11) NOT NULL auto_increment,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=3 ;

-- 
-- Dumping data for table `rets_lic`
-- 

INSERT INTO `rets_lic` VALUES ('', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', );