-- MySQL dump 10.11
--
-- Host: localhost Database: ineed2ge_jo151
-- ------------------------------------------------------
-- Server version 5.0.90-community
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Table structure for table `jos_addons`
--
DROP TABLE IF EXISTS `jos_addons`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `jos_addons` (
`addons_version` varchar(15) NOT NULL,
`addons_name` varchar(150) NOT NULL,
PRIMARY KEY (`addons_name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `jos_addons`
--
LOCK TABLES `jos_addons` WRITE;
/*!40000 ALTER TABLE `jos_addons` DISABLE KEYS */;
INSERT INTO `jos_addons` (`addons_version`, `addons_name`) VALUES ('3.3','contactform'),('1.2','jac');
/*!40000 ALTER TABLE `jos_addons` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `jos_banner`
--
DROP TABLE IF EXISTS `jos_banner`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `jos_banner` (
`bid` int(11) NOT NULL auto_increment,
`cid` int(11) NOT NULL default '0',
`type` varchar(30) NOT NULL default 'banner',
`name` varchar(255) NOT NULL default '',
`alias` varchar(255) NOT NULL default '',
`imptotal` int(11) NOT NULL default '0',
`impmade` int(11) NOT NULL default '0',
`clicks` int(11) NOT NULL default '0',
`imageurl` varchar(100) NOT NULL default '',
`clickurl` varchar(200) NOT NULL default '',
`date` datetime default NULL,
`showBanner` tinyint(1) NOT NULL default '0',
`checked_out` tinyint(1) NOT NULL default '0',
`checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
`editor` varchar(50) default NULL,
`custombannercode` text,
`catid` int(10) unsigned NOT NULL default '0',
`description` text NOT NULL,
`sticky` tinyint(1) unsigned NOT NULL default '0',
`ordering` int(11) NOT NULL default '0',
`publish_up` datetime NOT NULL default '0000-00-00 00:00:00',
`publish_down` datetime NOT NULL default '0000-00-00 00:00:00',
`tags` text NOT NULL,
`params` text NOT NULL,
PRIMARY KEY (`bid`),
KEY `viewbanner` (`showBanner`),
KEY `idx_banner_catid` (`catid`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `jos_banner`
--
LOCK TABLES `jos_banner` WRITE;
/*!40000 ALTER TABLE `jos_banner` DISABLE KEYS */;
INSERT INTO `jos_banner` (`bid`, `cid`, `type`, `name`, `alias`, `imptotal`, `impmade`, `clicks`, `imageurl`, `clickurl`, `date`, `showBanner`, `checked_out`, `checked_out_time`, `editor`, `custombannercode`, `catid`, `description`, `sticky`, `ordering`, `publish_up`, `publish_down`, `tags`, `params`) VALUES (1,1,'banner','OSM 1','osm-1',0,43,0,'osmbanner1.png','http://www.opensourcematters.org','2004-07-07 15:31:29',0,0,'0000-00-00 00:00:00','','',13,'',0,1,'0000-00-00 00:00:00','0000-00-00 00:00:00','',''),(2,1,'banner','OSM 2','osm-2',0,49,0,'osmbanner2.png','http://www.opensourcematters.org','2004-07-07 15:31:29',0,0,'0000-00-00 00:00:00','','',13,'',0,2,'0000-00-00 00:00:00','0000-00-00 00:00:00','',''),(3,1,'','Joomla!','joomla',0,41,0,'','http://www.joomla.org','2006-05-29 14:21:28',0,0,'0000-00-00 00:00:00','','{NAME}\r\n
\r\nJoomla! The most popular and widely used Open Source CMS Project in the world.',14,'',0,1,'0000-00-00 00:00:00','0000-00-00 00:00:00','',''),(4,1,'','JoomlaCode','joomlacode',0,41,0,'','http://joomlacode.org','2006-05-29 14:19:26',0,0,'0000-00-00 00:00:00','','{NAME}\r\n
\r\nJoomlaCode, development and distribution made easy.',14,'',0,2,'0000-00-00 00:00:00','0000-00-00 00:00:00','',''),(5,1,'','Joomla! Extensions','joomla-extensions',0,36,0,'','http://extensions.joomla.org','2006-05-29 14:23:21',0,0,'0000-00-00 00:00:00','','{NAME}\r\n
\r\nJoomla! Components, Modules, Plugins and Languages by the bucket load.',14,'',0,3,'0000-00-00 00:00:00','0000-00-00 00:00:00','',''),(6,1,'','Joomla! Shop','joomla-shop',0,36,0,'','http://shop.joomla.org','2006-05-29 14:23:21',0,0,'0000-00-00 00:00:00','','{NAME}\r\n
\r\nFor all your Joomla! merchandise.',14,'',0,4,'0000-00-00 00:00:00','0000-00-00 00:00:00','',''),(7,1,'','Joomla! Promo Shop','joomla-promo-shop',0,27,2,'shop-ad.jpg','http://shop.joomla.org','2007-09-19 17:26:24',0,0,'0000-00-00 00:00:00','','',33,'',0,3,'0000-00-00 00:00:00','0000-00-00 00:00:00','',''),(8,1,'','Joomla! Promo Books','joomla-promo-books',0,29,0,'shop-ad-books.jpg','http://shop.joomla.org/amazoncom-bookstores.html','2007-09-19 17:28:01',0,0,'0000-00-00 00:00:00','','',33,'',0,4,'0000-00-00 00:00:00','0000-00-00 00:00:00','','');
/*!40000 ALTER TABLE `jos_banner` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `jos_bannerclient`
--
DROP TABLE IF EXISTS `jos_bannerclient`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `jos_bannerclient` (
`cid` int(11) NOT NULL auto_increment,
`name` varchar(255) NOT NULL default '',
`contact` varchar(255) NOT NULL default '',
`email` varchar(255) NOT NULL default '',
`extrainfo` text NOT NULL,
`checked_out` tinyint(1) NOT NULL default '0',
`checked_out_time` time default NULL,
`editor` varchar(50) default NULL,
PRIMARY KEY (`cid`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `jos_bannerclient`
--
LOCK TABLES `jos_bannerclient` WRITE;
/*!40000 ALTER TABLE `jos_bannerclient` DISABLE KEYS */;
INSERT INTO `jos_bannerclient` (`cid`, `name`, `contact`, `email`, `extrainfo`, `checked_out`, `checked_out_time`, `editor`) VALUES (1,'Open Source Matters','Administrator','admin@opensourcematters.org','',0,'00:00:00',NULL);
/*!40000 ALTER TABLE `jos_bannerclient` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `jos_bannertrack`
--
DROP TABLE IF EXISTS `jos_bannertrack`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `jos_bannertrack` (
`track_date` date NOT NULL,
`track_type` int(10) unsigned NOT NULL,
`banner_id` int(10) unsigned NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `jos_bannertrack`
--
LOCK TABLES `jos_bannertrack` WRITE;
/*!40000 ALTER TABLE `jos_bannertrack` DISABLE KEYS */;
/*!40000 ALTER TABLE `jos_bannertrack` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `jos_categories`
--
DROP TABLE IF EXISTS `jos_categories`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `jos_categories` (
`id` int(11) NOT NULL auto_increment,
`parent_id` int(11) NOT NULL default '0',
`title` varchar(255) NOT NULL default '',
`name` varchar(255) NOT NULL default '',
`alias` varchar(255) NOT NULL default '',
`image` varchar(255) NOT NULL default '',
`section` varchar(50) NOT NULL default '',
`image_position` varchar(30) NOT NULL default '',
`description` text NOT NULL,
`published` tinyint(1) NOT NULL default '0',
`checked_out` int(11) unsigned NOT NULL default '0',
`checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
`editor` varchar(50) default NULL,
`ordering` int(11) NOT NULL default '0',
`access` tinyint(3) unsigned NOT NULL default '0',
`count` int(11) NOT NULL default '0',
`params` text NOT NULL,
PRIMARY KEY (`id`),
KEY `cat_idx` (`section`,`published`,`access`),
KEY `idx_access` (`access`),
KEY `idx_checkout` (`checked_out`)
) ENGINE=MyISAM AUTO_INCREMENT=38 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `jos_categories`
--
LOCK TABLES `jos_categories` WRITE;
/*!40000 ALTER TABLE `jos_categories` DISABLE KEYS */;
INSERT INTO `jos_categories` (`id`, `parent_id`, `title`, `name`, `alias`, `image`, `section`, `image_position`, `description`, `published`, `checked_out`, `checked_out_time`, `editor`, `ordering`, `access`, `count`, `params`) VALUES (1,0,'Latest','','latest-news','taking_notes.jpg','1','left','The latest news from the Joomla! Team',1,0,'0000-00-00 00:00:00','',1,0,1,''),(2,0,'Joomla! Specific Links','','joomla-specific-links','clock.jpg','com_weblinks','left','A selection of links that are all related to the Joomla! Project.',1,0,'0000-00-00 00:00:00',NULL,1,0,0,''),(3,0,'Newsflash','','newsflash','','1','left','',1,0,'0000-00-00 00:00:00','',2,0,0,''),(4,0,'Joomla!','','joomla','','com_newsfeeds','left','',0,0,'0000-00-00 00:00:00',NULL,2,0,0,''),(5,0,'Free and Open Source Software','','free-and-open-source-software','','com_newsfeeds','left','Read the latest news about free and open source software from some of its leading advocates.',0,0,'0000-00-00 00:00:00',NULL,3,0,0,''),(6,0,'Related Projects','','related-projects','','com_newsfeeds','left','Joomla builds on and collaborates with many other free and open source projects. Keep up with the latest news from some of them.',0,0,'0000-00-00 00:00:00',NULL,4,0,0,''),(12,0,'Contacts','','contacts','','com_contact_details','left','Contact Details for this Web site',1,0,'0000-00-00 00:00:00',NULL,0,0,0,''),(13,0,'Joomla','','joomla','','com_banner','left','',1,0,'0000-00-00 00:00:00',NULL,0,0,0,''),(14,0,'Text Ads','','text-ads','','com_banner','left','',1,0,'0000-00-00 00:00:00',NULL,0,0,0,''),(15,0,'Features','','features','','com_content','left','',0,0,'0000-00-00 00:00:00',NULL,6,0,0,''),(17,0,'Benefits','','benefits','','com_content','left','',0,0,'0000-00-00 00:00:00',NULL,4,0,0,''),(18,0,'Platforms','','platforms','','com_content','left','',0,0,'0000-00-00 00:00:00',NULL,3,0,0,''),(19,0,'Other Resources','','other-resources','','com_weblinks','left','',1,0,'0000-00-00 00:00:00',NULL,2,0,0,''),(29,0,'The CMS','','the-cms','','4','left','Information about the software behind Joomla!
',1,0,'0000-00-00 00:00:00',NULL,2,0,0,''),(28,0,'Current Users','','current-users','','3','left','Questions that users migrating to Joomla! 1.5 are likely to raise
',1,0,'0000-00-00 00:00:00',NULL,2,0,0,''),(25,0,'The Project','','the-project','','4','left','General facts about Joomla!
',1,65,'2007-06-28 14:50:15',NULL,1,0,0,''),(27,0,'New to Joomla!','','new-to-joomla','','3','left','Questions for new users of Joomla!',1,0,'0000-00-00 00:00:00',NULL,3,0,0,''),(30,0,'The Community','','the-community','','4','left','About the millions of Joomla! users and Web sites
',1,0,'0000-00-00 00:00:00',NULL,3,0,0,''),(31,0,'General','','general','','3','left','General questions about the Joomla! CMS',1,0,'0000-00-00 00:00:00',NULL,1,0,0,''),(32,0,'Languages','','languages','','3','left','Questions related to localisation and languages',1,0,'0000-00-00 00:00:00',NULL,4,0,0,''),(33,0,'Joomla! Promo','','joomla-promo','','com_banner','left','',1,0,'0000-00-00 00:00:00',NULL,1,0,0,''),(34,0,'Villa Owners','','villa-owners','','5','left','Information for Florida Villa owners
',1,0,'0000-00-00 00:00:00',NULL,4,0,0,''),(35,0,'Florida Villa Information','','florida-villa-information','','6','left','Florida Villa Information
',1,0,'0000-00-00 00:00:00',NULL,1,0,0,''),(36,0,'Home','','home','','7','left','Homepage
',1,0,'0000-00-00 00:00:00',NULL,1,0,0,''),(37,0,'Villa Community','','florida-villa-community','','6','left','This section has information about each villa community in Florida. ',1,0,'0000-00-00 00:00:00',NULL,4,0,0,'');
/*!40000 ALTER TABLE `jos_categories` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `jos_classformelements`
--
DROP TABLE IF EXISTS `jos_classformelements`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `jos_classformelements` (
`classformelements_id` int(11) NOT NULL auto_increment,
`class_id` int(11) NOT NULL,
`listingsformelements_id` int(11) NOT NULL,
PRIMARY KEY (`classformelements_id`),
KEY `idx_classformelements_class_id` (`class_id`),
KEY `idx_classformelements_listingsformelements_id` (`listingsformelements_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2037 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `jos_classformelements`
--
LOCK TABLES `jos_classformelements` WRITE;
/*!40000 ALTER TABLE `jos_classformelements` DISABLE KEYS */;
INSERT INTO `jos_classformelements` (`classformelements_id`, `class_id`, `listingsformelements_id`) VALUES (1279,7,1),(1286,7,2),(1413,7,31),(1406,7,30),(1371,7,29),(1364,7,28),(1784,7,21),(1938,7,8),(1307,7,9),(1314,7,10),(1321,7,11),(1328,7,12),(1910,7,72),(1378,7,27),(1336,7,15),(1385,7,25),(1392,7,26),(2029,7,18),(2036,7,19),(1357,7,22),(1278,6,1),(1285,6,2),(1412,6,31),(1405,6,30),(1370,6,29),(1363,6,28),(1783,6,21),(1937,6,8),(1306,6,9),(1313,6,10),(1320,6,11),(1327,6,12),(1909,6,72),(1377,6,27),(1335,6,15),(1384,6,25),(1391,6,26),(2028,6,18),(2035,6,19),(1356,6,22),(1277,5,1),(1284,5,2),(1411,5,31),(1404,5,30),(1369,5,29),(1362,5,28),(1782,5,21),(1936,5,8),(1305,5,9),(1312,5,10),(1319,5,11),(1326,5,12),(1908,5,72),(1376,5,27),(1334,5,15),(1383,5,25),(1390,5,26),(2027,5,18),(2034,5,19),(1355,5,22),(1276,4,1),(1283,4,2),(1410,4,31),(1403,4,30),(1368,4,29),(1361,4,28),(1781,4,21),(1935,4,8),(1304,4,9),(1311,4,10),(1318,4,11),(1325,4,12),(1907,4,72),(1375,4,27),(1333,4,15),(1382,4,25),(1389,4,26),(2026,4,18),(2033,4,19),(1354,4,22),(1275,3,1),(1282,3,2),(1409,3,31),(1402,3,30),(1367,3,29),(1360,3,28),(1780,3,21),(1934,3,8),(1303,3,9),(1310,3,10),(1317,3,11),(1324,3,12),(1906,3,72),(1374,3,27),(1332,3,15),(1381,3,25),(1388,3,26),(2025,3,18),(2032,3,19),(1353,3,22),(1281,2,2),(1401,2,30),(1309,2,10),(1323,2,12),(1274,2,1),(2031,2,19),(1352,2,22),(1316,2,11),(1905,2,72),(1779,2,21),(2024,2,18),(1359,2,28),(1408,2,31),(1373,2,27),(1331,2,15),(1302,2,9),(1387,2,26),(1366,2,29),(1933,2,8),(1380,2,25),(1280,1,2),(1400,1,30),(1308,1,10),(1322,1,12),(1273,1,1),(2030,1,19),(1351,1,22),(1315,1,11),(1329,1,13),(1778,1,21),(2023,1,18),(1358,1,28),(1407,1,31),(1372,1,27),(1330,1,15),(1301,1,9),(1386,1,26),(1365,1,29),(1932,1,8),(1379,1,25),(1420,7,32),(1419,6,32),(1418,5,32),(1417,4,32),(1416,3,32),(1415,2,32),(1414,1,32),(1427,7,33),(1426,6,33),(1425,5,33),(1424,4,33),(1423,3,33),(1422,2,33),(1421,1,33),(1434,7,34),(1433,6,34),(1432,5,34),(1431,4,34),(1430,3,34),(1429,2,34),(1428,1,34),(1448,7,35),(1447,6,35),(1446,5,35),(1445,4,35),(1444,3,35),(1443,2,35),(1442,1,35),(1455,7,36),(1454,6,36),(1453,5,36),(1452,4,36),(1451,3,36),(1450,2,36),(1449,1,36),(1462,7,37),(1461,6,37),(1460,5,37),(1459,4,37),(1458,3,37),(1457,2,37),(1456,1,37),(1917,7,38),(1916,6,38),(1915,5,38),(1914,4,38),(1913,3,38),(1912,2,38),(1911,1,38),(1476,7,39),(1475,6,39),(1474,5,39),(1473,4,39),(1472,3,39),(1471,2,39),(1470,1,39),(1798,7,40),(1797,6,40),(1796,5,40),(1795,4,40),(1794,3,40),(1793,2,40),(1792,1,40),(1805,7,41),(1804,6,41),(1803,5,41),(1802,4,41),(1801,3,41),(1800,2,41),(1799,1,41),(1812,7,42),(1811,6,42),(1810,5,42),(1809,4,42),(1808,3,42),(1807,2,42),(1806,1,42),(1819,7,43),(1818,6,43),(1817,5,43),(1816,4,43),(1815,3,43),(1814,2,43),(1813,1,43),(1826,7,44),(1825,6,44),(1824,5,44),(1823,4,44),(1822,3,44),(1821,2,44),(1820,1,44),(1833,7,45),(1832,6,45),(1831,5,45),(1830,4,45),(1829,3,45),(1828,2,45),(1827,1,45),(1840,7,46),(1839,6,46),(1838,5,46),(1837,4,46),(1836,3,46),(1835,2,46),(1834,1,46),(1847,7,47),(1846,6,47),(1845,5,47),(1844,4,47),(1843,3,47),(1842,2,47),(1841,1,47),(1854,7,48),(1853,6,48),(1852,5,48),(1851,4,48),(1850,3,48),(1849,2,48),(1848,1,48),(1861,7,49),(1860,6,49),(1859,5,49),(1858,4,49),(1857,3,49),(1856,2,49),(1855,1,49),(1896,7,50),(1895,6,50),(1894,5,50),(1893,4,50),(1892,3,50),(1891,2,50),(1890,1,50),(1399,7,51),(1398,6,51),(1397,5,51),(1396,4,51),(1395,3,51),(1394,2,51),(1393,1,51),(1980,7,52),(1979,6,52),(1978,5,52),(1977,4,52),(1976,3,52),(1975,2,52),(1974,1,52),(1987,7,53),(1986,6,53),(1985,5,53),(1984,4,53),(1983,3,53),(1982,2,53),(1981,1,53),(1595,7,54),(1594,6,54),(1593,5,54),(1592,4,54),(1591,3,54),(1590,2,54),(1589,1,54),(1602,7,55),(1601,6,55),(1600,5,55),(1599,4,55),(1598,3,55),(1597,2,55),(1596,1,55),(1609,7,56),(1608,6,56),(1607,5,56),(1606,4,56),(1605,3,56),(1604,2,56),(1603,1,56),(1882,7,57),(1881,6,57),(1880,5,57),(1879,4,57),(1878,3,57),(1877,2,57),(1876,1,57),(1889,7,58),(1888,6,58),(1887,5,58),(1886,4,58),(1885,3,58),(1884,2,58),(1883,1,58),(1994,7,59),(1993,6,59),(1992,5,59),(1991,4,59),(1990,3,59),(1989,2,59),(1988,1,59),(2015,7,60),(2014,6,60),(2013,5,60),(2012,4,60),(2011,3,60),(2010,2,60),(2009,1,60),(1644,7,61),(1643,6,61),(1642,5,61),(1641,4,61),(1640,3,61),(1639,2,61),(1638,1,61),(2001,7,62),(2000,6,62),(1999,5,62),(1998,4,62),(1997,3,62),(1996,2,62),(1995,1,62),(2008,7,63),(2007,6,63),(2006,5,63),(2005,4,63),(2004,3,63),(2003,2,63),(2002,1,63),(2022,7,64),(2021,6,64),(2020,5,64),(2019,4,64),(2018,3,64),(2017,2,64),(2016,1,64),(1875,7,65),(1874,6,65),(1873,5,65),(1872,4,65),(1871,3,65),(1870,2,65),(1869,1,65),(1924,7,66),(1923,6,66),(1922,5,66),(1921,4,66),(1920,3,66),(1919,2,66),(1918,1,66),(1931,7,67),(1930,6,67),(1929,5,67),(1928,4,67),(1927,3,67),(1926,2,67),(1925,1,67),(1700,7,68),(1699,6,68),(1698,5,68),(1697,4,68),(1696,3,68),(1695,2,68),(1694,1,68),(1714,7,69),(1713,6,69),(1712,5,69),(1711,4,69),(1710,3,69),(1709,2,69),(1708,1,69),(1735,7,70),(1734,6,70),(1733,5,70),(1732,4,70),(1731,3,70),(1730,2,70),(1729,1,70),(1728,7,71),(1727,6,71),(1726,5,71),(1725,4,71),(1724,3,71),(1723,2,71),(1722,1,71),(1904,1,72),(1952,7,73),(1951,6,73),(1950,5,73),(1949,4,73),(1948,3,73),(1947,2,73),(1946,1,73);
/*!40000 ALTER TABLE `jos_classformelements` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `jos_classlistingsdb`
--
DROP TABLE IF EXISTS `jos_classlistingsdb`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `jos_classlistingsdb` (
`classlistingsdb_id` int(11) NOT NULL auto_increment,
`class_id` int(11) NOT NULL,
`listingsdb_id` int(11) NOT NULL,
PRIMARY KEY (`classlistingsdb_id`),
KEY `idx_classlistingsdb_class_id` (`class_id`),
KEY `idx_classlistingsdb_listingsdb_id` (`listingsdb_id`),
KEY `idx_classfieldmashup` (`listingsdb_id`,`class_id`)
) ENGINE=MyISAM AUTO_INCREMENT=45 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `jos_classlistingsdb`
--
LOCK TABLES `jos_classlistingsdb` WRITE;
/*!40000 ALTER TABLE `jos_classlistingsdb` DISABLE KEYS */;
INSERT INTO `jos_classlistingsdb` (`classlistingsdb_id`, `class_id`, `listingsdb_id`) VALUES (6,3,5),(7,3,6),(8,1,7),(9,6,8),(10,3,9),(11,3,10),(12,1,11),(13,2,12),(14,2,13),(15,2,14),(16,1,15),(17,2,16),(18,5,17),(19,2,18),(20,2,19),(21,2,20),(22,1,21),(23,3,22),(24,3,23),(25,2,24),(26,2,25),(27,2,26),(28,3,27),(29,3,28),(30,2,29),(31,3,30),(32,2,31),(33,2,32),(34,2,33),(35,3,34),(36,2,35),(37,2,36),(38,3,37),(41,2,40),(43,1,42),(44,1,43);
/*!40000 ALTER TABLE `jos_classlistingsdb` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `jos_cmsrealty`
--
DROP TABLE IF EXISTS `jos_cmsrealty`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `jos_cmsrealty` (
`field` varchar(128) NOT NULL default '',
`value` text,
PRIMARY KEY (`field`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `jos_cmsrealty`
--
LOCK TABLES `jos_cmsrealty` WRITE;
/*!40000 ALTER TABLE `jos_cmsrealty` DISABLE KEYS */;
INSERT INTO `jos_cmsrealty` (`field`, `value`) VALUES ('path','/home/ineed2ge/public_html/floridadreamsvillas.com/openrealty/'),('user_integration','on'),('version','2.0.0-alpha'),('URLFactory','JoomlaFrontendURLFactory'),('AdminURLFactory','JoomlaAdminURLFactory'),('ComponentName','com_cmsrealty'),('ProjectName','CMS Realty'),('insert_metadata','on'),('insert_style_css',''),('charset','0-9A-Za-z');
/*!40000 ALTER TABLE `jos_cmsrealty` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `jos_components`
--
DROP TABLE IF EXISTS `jos_components`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `jos_components` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(50) NOT NULL default '',
`link` varchar(255) NOT NULL default '',
`menuid` int(11) unsigned NOT NULL default '0',
`parent` int(11) unsigned NOT NULL default '0',
`admin_menu_link` varchar(255) NOT NULL default '',
`admin_menu_alt` varchar(255) NOT NULL default '',
`option` varchar(50) NOT NULL default '',
`ordering` int(11) NOT NULL default '0',
`admin_menu_img` varchar(255) NOT NULL default '',
`iscore` tinyint(4) NOT NULL default '0',
`params` text NOT NULL,
`enabled` tinyint(4) NOT NULL default '1',
PRIMARY KEY (`id`),
KEY `parent_option` (`parent`,`option`(32))
) ENGINE=MyISAM AUTO_INCREMENT=58 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `jos_components`
--
LOCK TABLES `jos_components` WRITE;
/*!40000 ALTER TABLE `jos_components` DISABLE KEYS */;
INSERT INTO `jos_components` (`id`, `name`, `link`, `menuid`, `parent`, `admin_menu_link`, `admin_menu_alt`, `option`, `ordering`, `admin_menu_img`, `iscore`, `params`, `enabled`) VALUES (1,'Banners','',0,0,'','Banner Management','com_banners',0,'js/ThemeOffice/component.png',0,'track_impressions=0\ntrack_clicks=0\ntag_prefix=\n\n',1),(2,'Banners','',0,1,'option=com_banners','Active Banners','com_banners',1,'js/ThemeOffice/edit.png',0,'',1),(3,'Clients','',0,1,'option=com_banners&c=client','Manage Clients','com_banners',2,'js/ThemeOffice/categories.png',0,'',1),(4,'Web Links','option=com_weblinks',0,0,'','Manage Weblinks','com_weblinks',0,'js/ThemeOffice/component.png',0,'show_comp_description=1\ncomp_description=\nshow_link_hits=1\nshow_link_description=1\nshow_other_cats=1\nshow_headings=1\nshow_page_title=1\nlink_target=0\nlink_icons=\n\n',1),(5,'Links','',0,4,'option=com_weblinks','View existing weblinks','com_weblinks',1,'js/ThemeOffice/edit.png',0,'',1),(6,'Categories','',0,4,'option=com_categories§ion=com_weblinks','Manage weblink categories','',2,'js/ThemeOffice/categories.png',0,'',1),(7,'Contacts','option=com_contact',0,0,'','Edit contact details','com_contact',0,'js/ThemeOffice/component.png',1,'contact_icons=0\nicon_address=\nicon_email=\nicon_telephone=\nicon_fax=\nicon_misc=\nshow_headings=1\nshow_position=1\nshow_email=0\nshow_telephone=1\nshow_mobile=1\nshow_fax=1\nbannedEmail=\nbannedSubject=\nbannedText=\nsession=1\ncustomReply=0\n\n',1),(8,'Contacts','',0,7,'option=com_contact','Edit contact details','com_contact',0,'js/ThemeOffice/edit.png',1,'',1),(9,'Categories','',0,7,'option=com_categories§ion=com_contact_details','Manage contact categories','',2,'js/ThemeOffice/categories.png',1,'contact_icons=0\nicon_address=\nicon_email=\nicon_telephone=\nicon_fax=\nicon_misc=\nshow_headings=1\nshow_position=1\nshow_email=0\nshow_telephone=1\nshow_mobile=1\nshow_fax=1\nbannedEmail=\nbannedSubject=\nbannedText=\nsession=1\ncustomReply=0\n\n',1),(10,'Polls','option=com_poll',0,0,'option=com_poll','Manage Polls','com_poll',0,'js/ThemeOffice/component.png',0,'',1),(11,'News Feeds','option=com_newsfeeds',0,0,'','News Feeds Management','com_newsfeeds',0,'js/ThemeOffice/component.png',0,'',1),(12,'Feeds','',0,11,'option=com_newsfeeds','Manage News Feeds','com_newsfeeds',1,'js/ThemeOffice/edit.png',0,'show_headings=1\nshow_name=1\nshow_articles=1\nshow_link=1\nshow_cat_description=1\nshow_cat_items=1\nshow_feed_image=1\nshow_feed_description=1\nshow_item_description=1\nfeed_word_count=0\n\n',1),(13,'Categories','',0,11,'option=com_categories§ion=com_newsfeeds','Manage Categories','',2,'js/ThemeOffice/categories.png',0,'',1),(14,'User','option=com_user',0,0,'','','com_user',0,'',1,'',1),(15,'Search','option=com_search',0,0,'option=com_search','Search Statistics','com_search',0,'js/ThemeOffice/component.png',1,'enabled=0\n\n',1),(16,'Categories','',0,1,'option=com_categories§ion=com_banner','Categories','',3,'',1,'',1),(17,'Wrapper','option=com_wrapper',0,0,'','Wrapper','com_wrapper',0,'',1,'',1),(18,'Mail To','',0,0,'','','com_mailto',0,'',1,'',1),(19,'Media Manager','',0,0,'option=com_media','Media Manager','com_media',0,'',1,'upload_extensions=bmp,csv,doc,epg,gif,ico,jpg,odg,odp,ods,odt,pdf,png,ppt,swf,txt,xcf,xls,BMP,CSV,DOC,EPG,GIF,ICO,JPG,ODG,ODP,ODS,ODT,PDF,PNG,PPT,SWF,TXT,XCF,XLS\nupload_maxsize=10000000\nfile_path=images\nimage_path=images/stories\nrestrict_uploads=1\nallowed_media_usergroup=3\ncheck_mime=1\nimage_extensions=bmp,gif,jpg,png\nignore_extensions=\nupload_mime=image/jpeg,image/gif,image/png,image/bmp,application/x-shockwave-flash,application/msword,application/excel,application/pdf,application/powerpoint,text/plain,application/x-zip\nupload_mime_illegal=text/html\nenable_flash=0\n\n',1),(20,'Articles','option=com_content',0,0,'','','com_content',0,'',1,'show_noauth=0\nshow_title=1\nlink_titles=0\nshow_intro=1\nshow_section=0\nlink_section=0\nshow_category=0\nlink_category=0\nshow_author=1\nshow_create_date=1\nshow_modify_date=1\nshow_item_navigation=0\nshow_readmore=1\nshow_vote=0\nshow_icons=1\nshow_pdf_icon=1\nshow_print_icon=1\nshow_email_icon=1\nshow_hits=1\nfeed_summary=0\n\n',1),(21,'Configuration Manager','',0,0,'','Configuration','com_config',0,'',1,'',1),(22,'Installation Manager','',0,0,'','Installer','com_installer',0,'',1,'',1),(23,'Language Manager','',0,0,'','Languages','com_languages',0,'',1,'',1),(24,'Mass mail','',0,0,'','Mass Mail','com_massmail',0,'',1,'mailSubjectPrefix=\nmailBodySuffix=\n\n',1),(25,'Menu Editor','',0,0,'','Menu Editor','com_menus',0,'',1,'',1),(27,'Messaging','',0,0,'','Messages','com_messages',0,'',1,'',1),(28,'Modules Manager','',0,0,'','Modules','com_modules',0,'',1,'',1),(29,'Plugin Manager','',0,0,'','Plugins','com_plugins',0,'',1,'',1),(30,'Template Manager','',0,0,'','Templates','com_templates',0,'',1,'',1),(31,'User Manager','',0,0,'','Users','com_users',0,'',1,'allowUserRegistration=1\nnew_usertype=Author\nuseractivation=0\nfrontend_userparams=1\n\n',1),(32,'Cache Manager','',0,0,'','Cache','com_cache',0,'',1,'',1),(33,'Control Panel','',0,0,'','Control Panel','com_cpanel',0,'',1,'',1),(34,'JCE Administration','option=com_jce',0,0,'option=com_jce','JCE Administration','com_jce',0,'components/com_jce/img/logo.png',0,'',1),(35,'Control Panel','',0,34,'option=com_jce','Control Panel','com_jce',0,'templates/khepri/images/menu/icon-16-cpanel.png',0,'',1),(36,'Configuration','',0,34,'option=com_jce&type=config','Configuration','com_jce',1,'templates/khepri/images/menu/icon-16-config.png',0,'',1),(37,'Groups','',0,34,'option=com_jce&type=group','Groups','com_jce',2,'templates/khepri/images/menu/icon-16-user.png',0,'',1),(38,'Plugins','',0,34,'option=com_jce&type=plugin','Plugins','com_jce',3,'templates/khepri/images/menu/icon-16-plugin.png',0,'',1),(39,'Install','',0,34,'option=com_jce&type=install','Install','com_jce',4,'templates/khepri/images/menu/icon-16-install.png',0,'',1),(40,'JForms','option=com_jforms',0,0,'option=com_jforms','JForms','com_jforms',0,'js/ThemeOffice/component.png',0,'',1),(41,'EasyTemplate','option=com_easytemplate',0,0,'option=com_easytemplate','EasyTemplate','com_easytemplate',0,'components/com_easytemplate/assets/images/easy-joomla-favicon.ico',0,'popup_width=700\npopup_height=500\neditarea_type=edit_area_compressor.php',1),(42,'Templates','',0,41,'option=com_easytemplate&task=templates','Templates','com_easytemplate',0,'article',0,'',1),(43,'Categories','',0,41,'option=com_easytemplate&task=cats','Categories','com_easytemplate',1,'category',0,'',1),(44,'Export','',0,41,'option=com_easytemplate&task=export','Export','com_easytemplate',2,'components/com_easytemplate/assets/images/fileexport.png',0,'',1),(45,'Import','',0,41,'option=com_easytemplate&task=import','Import','com_easytemplate',3,'components/com_easytemplate/assets/images/fileimport.png',0,'',1),(46,'Mass content','option=com_masscontent',0,0,'option=com_masscontent','Mass content','com_masscontent',0,'js/ThemeOffice/component.png',0,'nbMassContent=10\nnbMassCategories=10\nnbMassSections=10\ndisplayAlias=1\ndisplayIntroText=1\ndisplayFullText=1\n',1),(47,'Create mass content','',0,46,'option=com_masscontent&controller=content','Create mass content','com_masscontent',0,'js/ThemeOffice/component.png',0,'',1),(48,'Create mass sections','',0,46,'option=com_masscontent&controller=sections','Create mass sections','com_masscontent',1,'js/ThemeOffice/component.png',0,'',1),(49,'Create mass categories','',0,46,'option=com_masscontent&controller=categories','Create mass categories','com_masscontent',2,'js/ThemeOffice/component.png',0,'',1),(50,'Delete mass content','',0,46,'option=com_masscontent&controller=delete','Delete mass content','com_masscontent',3,'js/ThemeOffice/component.png',0,'',1),(55,'CMS Realty','option=com_cmsrealty',0,0,'option=com_cmsrealty','CMS Realty','com_cmsrealty',0,'js/ThemeOffice/component.png',0,'',1),(56,'Settings','',0,55,'option=com_cmsrealty&act=settings','Settings','com_cmsrealty',0,'js/ThemeOffice/component.png',0,'',1),(57,'Open-Realty Admin','',0,55,'option=com_cmsrealty&act=admin','Open-Realty Admin','com_cmsrealty',1,'js/ThemeOffice/component.png',0,'',1);
/*!40000 ALTER TABLE `jos_components` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `jos_contact_details`
--
DROP TABLE IF EXISTS `jos_contact_details`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `jos_contact_details` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(255) NOT NULL default '',
`alias` varchar(255) NOT NULL default '',
`con_position` varchar(255) default NULL,
`address` text,
`suburb` varchar(100) default NULL,
`state` varchar(100) default NULL,
`country` varchar(100) default NULL,
`postcode` varchar(100) default NULL,
`telephone` varchar(255) default NULL,
`fax` varchar(255) default NULL,
`misc` mediumtext,
`image` varchar(255) default NULL,
`imagepos` varchar(20) default NULL,
`email_to` varchar(255) default NULL,
`default_con` tinyint(1) unsigned NOT NULL default '0',
`published` tinyint(1) unsigned NOT NULL default '0',
`checked_out` int(11) unsigned NOT NULL default '0',
`checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
`ordering` int(11) NOT NULL default '0',
`params` text NOT NULL,
`user_id` int(11) NOT NULL default '0',
`catid` int(11) NOT NULL default '0',
`access` tinyint(3) unsigned NOT NULL default '0',
`mobile` varchar(255) NOT NULL default '',
`webpage` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`),
KEY `catid` (`catid`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `jos_contact_details`
--
LOCK TABLES `jos_contact_details` WRITE;
/*!40000 ALTER TABLE `jos_contact_details` DISABLE KEYS */;
INSERT INTO `jos_contact_details` (`id`, `name`, `alias`, `con_position`, `address`, `suburb`, `state`, `country`, `postcode`, `telephone`, `fax`, `misc`, `image`, `imagepos`, `email_to`, `default_con`, `published`, `checked_out`, `checked_out_time`, `ordering`, `params`, `user_id`, `catid`, `access`, `mobile`, `webpage`) VALUES (1,'Name','name','Position','Street','Suburb','State','Country','Zip Code','Telephone','Fax','Miscellanous info','powered_by.png','top','email@email.com',1,1,0,'0000-00-00 00:00:00',1,'show_name=1\r\nshow_position=1\r\nshow_email=0\r\nshow_street_address=1\r\nshow_suburb=1\r\nshow_state=1\r\nshow_postcode=1\r\nshow_country=1\r\nshow_telephone=1\r\nshow_mobile=1\r\nshow_fax=1\r\nshow_webpage=1\r\nshow_misc=1\r\nshow_image=1\r\nallow_vcard=0\r\ncontact_icons=0\r\nicon_address=\r\nicon_email=\r\nicon_telephone=\r\nicon_fax=\r\nicon_misc=\r\nshow_email_form=1\r\nemail_description=1\r\nshow_email_copy=1\r\nbanned_email=\r\nbanned_subject=\r\nbanned_text=',0,12,0,'','');
/*!40000 ALTER TABLE `jos_contact_details` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `jos_contactform`
--
DROP TABLE IF EXISTS `jos_contactform`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `jos_contactform` (
`id` int(6) NOT NULL auto_increment,
`field_name` varchar(50) NOT NULL default '',
`field_type` varchar(20) NOT NULL default '',
`field_elements` varchar(100) NOT NULL default '',
`agent_show` char(3) NOT NULL default '',
`friend_show` char(3) NOT NULL default '',
`contact_show` char(3) NOT NULL default '',
`required` char(3) NOT NULL default '',
`rank` int(5) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=17 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `jos_contactform`
--
LOCK TABLES `jos_contactform` WRITE;
/*!40000 ALTER TABLE `jos_contactform` DISABLE KEYS */;
INSERT INTO `jos_contactform` (`id`, `field_name`, `field_type`, `field_elements`, `agent_show`, `friend_show`, `contact_show`, `required`, `rank`) VALUES (1,'Currency','select','select||GBP £||USD $||Canadian Dollar$||Euro||Other','yes','no','no','Yes',1),(2,'Telephone Number','text','','yes','yes','yes','No',14),(3,'Number of Nights','select','select||1||2||3||4||5||6||7||8||9||10||11||12||13||14||15||16||17||18||19||20||21||22||23||24||25||2','yes','no','no','Yes',12),(4,'Arrival Date','text','','yes','no','no','Yes',6),(5,'Departure Date','text','','yes','no','no','Yes',7),(6,'Arrival Year','select','select||2009||2010||2011||2012||2013||2014||2015||2016||2017||2018||2019||2020','no','no','no','Yes',8),(7,'Departure Day','select','select||1||2||3||4||5||6||7||8||9||10||11||12||13||14||15||16||17||18||19||20||21||22||23||24||25||2','no','no','no','Yes',9),(8,'Departure Month','select','select||January||February||March||April||May||June||July||August||September||October||November||Dece','no','no','no','Yes',10),(9,'Departure Year','select','select||2009||2010||2011||2012||2013||2014||2015||2016||2017||2018||2019||2020','no','no','no','Yes',11),(10,'Are your Dates Flexible','select','select||No||Yes +-1 Day||Yes +- 2 days||Yes +- 3 days||Yes+- 4 days||Yes +- 5 days||Yes +- 6 days||','yes','no','no','Yes',13),(11,'Number of Adults','select','select||1||2||3||4||5||6||7||8||9||10||11||12||13||14||15||16||17||18||19||20','yes','no','no','Yes',3),(12,'Number of Children under 16','select','select||0||1||2||3||4||5||6||7||8||9||10||11||12||13||14||15||16||17||18||19||20','yes','no','no','Yes',4),(13,'Number of Babies','select','select||0||1||2||3||4||5||6||7||8||9||10||11||12||13||14||15||16||17||18||19||20','yes','no','no','Yes',5),(14,'Do you require Pool heat','select','select||Yes||No','yes','no','no','Yes',2),(16,'Best time to contact','text','','yes','yes','yes','No',15);
/*!40000 ALTER TABLE `jos_contactform` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `jos_contactformcontent`
--
DROP TABLE IF EXISTS `jos_contactformcontent`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `jos_contactformcontent` (
`id` int(6) NOT NULL auto_increment,
`generic_email` varchar(250) NOT NULL default '',
`generic_cc` varchar(250) NOT NULL default '',
`generic_subj` varchar(250) NOT NULL default '',
`generic_msg` varchar(250) NOT NULL default '',
`agent_email` varchar(250) NOT NULL default '',
`agent_cc` varchar(250) NOT NULL default '',
`agent_subj` varchar(250) NOT NULL default '',
`agent_msg` varchar(250) NOT NULL default '',
`friend_cc` varchar(250) NOT NULL default '',
`friend_subj` varchar(250) NOT NULL default '',
`friend_msg` varchar(250) NOT NULL default '',
`listing_fields` varchar(250) NOT NULL default '',
`use_captcha` varchar(3) NOT NULL default '',
`use_email_ver` varchar(3) NOT NULL default '',
`cms_realty` varchar(3) NOT NULL default '',
`cms_realty_path` varchar(50) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `jos_contactformcontent`
--
LOCK TABLES `jos_contactformcontent` WRITE;
/*!40000 ALTER TABLE `jos_contactformcontent` DISABLE KEYS */;
INSERT INTO `jos_contactformcontent` (`id`, `generic_email`, `generic_cc`, `generic_subj`, `generic_msg`, `agent_email`, `agent_cc`, `agent_subj`, `agent_msg`, `friend_cc`, `friend_subj`, `friend_msg`, `listing_fields`, `use_captcha`, `use_email_ver`, `cms_realty`, `cms_realty_path`) VALUES (1,'','','','','','','FDV_{ID} {Title}','','','','','','Yes','No','Yes','http://www.floridadreamsvillas.com');
/*!40000 ALTER TABLE `jos_contactformcontent` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `jos_contactformmessages`
--
DROP TABLE IF EXISTS `jos_contactformmessages`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `jos_contactformmessages` (
`id` int(10) NOT NULL auto_increment,
`form` varchar(20) NOT NULL,
`sender_name` varchar(50) NOT NULL,
`sender_email` varchar(50) NOT NULL,
`subject` varchar(200) NOT NULL,
`message` text NOT NULL,
`sent` varchar(20) NOT NULL,
`recipient` varchar(50) NOT NULL,
`listingsdb_id` varchar(50) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=149 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `jos_contactformmessages`
--
LOCK TABLES `jos_contactformmessages` WRITE;
/*!40000 ALTER TABLE `jos_contactformmessages` DISABLE KEYS */;
INSERT INTO `jos_contactformmessages` (`id`, `form`, `sender_name`, `sender_email`, `subject`, `message`, `sent`, `recipient`, `listingsdb_id`) VALUES (1,'Agent','nick','nickcollins@ntlworld.com','test','test','1236084862','GuyGissing@aol.com','2'),(2,'Agent','test','nickcollins@ntlworld.com','test','test','1236084901','nickcollins@disneyworldonline.co.uk','3'),(6,'Agent','nick','nick@yahoo.co.uk','FDV_38 test','','1236279819','webmaster@fifaforum.co.uk','38'),(4,'Agent','nick','nickcollins@ntlworld.com','testing','testing','1236269406','hazelkegs@hotmail.com','15'),(5,'Agent','nickcollins','nickcollins@ntlworld.com','FDV_5 Dreams of Disney','test','1236278563','wendyjoyp2@aol.com','5'),(7,'Agent','nick','nickcollins@ntlworld.com','FDV_5 Dreams of Disney','test','1236347717','webmaster@fifaforum.co.uk','5'),(8,'Agent','ely','dave.ely@virgin.net','FDV_16 Porquai Pas','','1236351261','webmaster@floridadreamsvillas.com','16'),(9,'Agent','Peter Rozario','rozario@gmail.com','FDV_18 Disney Dream Villa','Test Email from Owner ... please ignore','1236371579','calabayvilla@gmail.com','18'),(10,'Agent','Bill Bouris','aesltd@sympatico.ca','FDV_14 Seano Villa','Pls advise best offer. Thank you.','1236437126','info@disneysdoorstep.com','14'),(11,'Agent','Bill Bouris','aesltd@sympatico.ca','FDV_5 Dreams of Disney','','1236437386','wendyjoyp2@aol.com','5'),(12,'Agent','Bill Bouris','aesltd@sympatico.ca','FDV_18 Disney Dream Villa','Pls. advise best offer. thank you.','1236437561','calabayvilla@gmail.com','18'),(13,'Agent','test','sargant@cadnam.gotadsl.co.uk','FDV_30 Palace in Wonderland','TEST','1236445202','sargant@cadnam.goadsl.co.uk','30'),(14,'Agent','nick','nick@nick.com','FDV_6 Pines West Villa','','1236445922','test2@test.com','6'),(15,'Agent','test 2','sargant@cadnam.gotadsl.co.uk','FDV_30 Palace in Wonderland','test 2','1236537793','sargant@cadnam.goadsl.co.uk','30'),(16,'Agent','nick','nickcollins@ntlworld.com','FDV_6 Pines West Villa','','1236610913','test2@test.com','6'),(17,'Agent','CINDYHENSLEY','NENGLISH30@GMail.com','FDV_12 Disney World Villa','thereis a chance that two more adults may be coming.\r\nYour Name: CINDYHENSLEY\r\nYour Email: NENGLISH30@GMail.com\r\nCurrency: USD $\r\nDo you require Pool heat: No\r\nNumber of Adults: 6\r\nNumber of Children under 16: 3\r\nArrival Date: july102010\r\nDeparture Date: july172010\r\nNumber of Nights: 7\r\nAre your Dates Flexible: No\r\nTelephone Number: 3303193534\r\nMessage: thereis a chance that two more adults may be coming.\r\nLink to Listing\r\nThis is the footer for the agent contact form