--
-- Host: localhost    Database: tsccoza_book
-- ------------------------------------------------------


--
-- Current Database: `tsccoza_book`
--


--
-- Table structure for table `q43qy_ak_acl`
--

CREATE TABLE `q43qy_ak_acl` (
  `user_id` bigint(20) unsigned NOT NULL,
  `permissions` mediumtext DEFAULT NULL,
  PRIMARY KEY (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `q43qy_ak_acl`
--


--
-- Table structure for table `q43qy_ak_profiles`
--

CREATE TABLE `q43qy_ak_profiles` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `description` varchar(255) NOT NULL,
  `configuration` longtext DEFAULT NULL,
  `filters` longtext DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `q43qy_ak_profiles`
--

INSERT INTO `q43qy_ak_profiles` (`id`, `description`, `configuration`, `filters`) VALUES (1,'Default Backup Profile','###AES128###[BLOB]','a:1:{s:5:\"files\";a:0:{}}');

--
-- Table structure for table `q43qy_ak_stats`
--

CREATE TABLE `q43qy_ak_stats` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `description` varchar(255) NOT NULL,
  `comment` longtext DEFAULT NULL,
  `backupstart` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `backupend` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `status` enum('run','fail','complete') NOT NULL DEFAULT 'run',
  `origin` varchar(30) NOT NULL DEFAULT 'backend',
  `type` varchar(30) NOT NULL DEFAULT 'full',
  `profile_id` bigint(20) NOT NULL DEFAULT 1,
  `archivename` longtext DEFAULT NULL,
  `absolute_path` longtext DEFAULT NULL,
  `multipart` int(11) NOT NULL DEFAULT 0,
  `tag` varchar(255) DEFAULT NULL,
  `backupid` varchar(255) DEFAULT NULL,
  `filesexist` tinyint(3) NOT NULL DEFAULT 1,
  `remote_filename` varchar(1000) DEFAULT NULL,
  `total_size` bigint(20) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `idx_fullstatus` (`filesexist`,`status`),
  KEY `idx_stale` (`status`,`origin`)
) ENGINE=MyISAM AUTO_INCREMENT=51 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `q43qy_ak_stats`
--

INSERT INTO `q43qy_ak_stats` (`id`, `description`, `comment`, `backupstart`, `backupend`, `status`, `origin`, `type`, `profile_id`, `archivename`, `absolute_path`, `multipart`, `tag`, `backupid`, `filesexist`, `remote_filename`, `total_size`) VALUES (45,'Backup taken on Tuesday, 30 September 2014 15:54','','2014-09-30 13:54:12','2014-09-30 13:57:49','complete','backend','full',1,'site-localhost-20140930-155412.jpa','C:/wamp/www/jomresquickstart/administrator/components/com_akeeba/backup/site-localhost-20140930-155412.jpa',1,'backend','id1',0,NULL,71696772),(46,'Backup taken on Wednesday, 01 October 2014 07:51','','2014-10-01 05:51:08','2014-10-01 05:54:56','complete','backend','full',1,'site-localhost-20141001-075108.jpa','C:/wamp/www/jomresquickstart/administrator/components/com_akeeba/backup/site-localhost-20141001-075108.jpa',1,'backend','id46',0,NULL,71696529),(47,'Backup taken on Wednesday, 01 October 2014 08:11','','2014-10-01 06:12:02','2014-10-01 06:15:01','complete','backend','full',1,'site-localhost-20141001-081202.jpa','C:/wamp/www/jomresquickstart/administrator/components/com_akeeba/backup/site-localhost-20141001-081202.jpa',1,'backend','id47',1,NULL,71697472),(48,'Backup taken on Friday, 03 October 2014 08:33','','2014-10-03 06:33:22','2014-10-03 06:37:28','complete','backend','full',1,'site-localhost-20141003-083322.jpa','C:/wamp/www/jomresquickstart/administrator/components/com_akeeba/backup/site-localhost-20141003-083322.jpa',1,'backend','id48',1,NULL,71697315),(49,'Backup taken on Friday, 03 October 2014 10:41','','2014-10-03 08:41:15','2014-10-03 08:44:13','complete','backend','full',1,'site-localhost-20141003-104115.jpa','C:/wamp/www/jomresquickstart/administrator/components/com_akeeba/backup/site-localhost-20141003-104115.jpa',1,'backend','id49',1,NULL,71697373),(50,'Backup taken on Friday, 10 October 2014 09:13','','2014-10-10 07:13:42','0000-00-00 00:00:00','complete','backend','full',1,'site-localhost-20141010-091342.jpa','C:/wamp/www/jomresquickstart/administrator/components/com_akeeba/backup/site-localhost-20141010-091342.jpa',0,'backend','id50',1,NULL,0);

--
-- Table structure for table `q43qy_ak_storage`
--

CREATE TABLE `q43qy_ak_storage` (
  `tag` varchar(255) NOT NULL,
  `lastupdate` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `data` longtext DEFAULT NULL,
  PRIMARY KEY (`tag`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `q43qy_ak_storage`
--


--
-- Table structure for table `q43qy_assets`
--

CREATE TABLE `q43qy_assets` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Primary Key',
  `parent_id` int(11) NOT NULL DEFAULT 0 COMMENT 'Nested set parent.',
  `lft` int(11) NOT NULL DEFAULT 0 COMMENT 'Nested set lft.',
  `rgt` int(11) NOT NULL DEFAULT 0 COMMENT 'Nested set rgt.',
  `level` int(10) unsigned NOT NULL COMMENT 'The cached level in the nested tree.',
  `name` varchar(50) NOT NULL,
  `title` varchar(100) NOT NULL,
  `rules` varchar(5120) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `idx_asset_name` (`name`),
  KEY `idx_lft_rgt` (`lft`,`rgt`),
  KEY `idx_parent_id` (`parent_id`)
) ENGINE=InnoDB AUTO_INCREMENT=117 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `q43qy_assets`
--

INSERT INTO `q43qy_assets` (`id`, `parent_id`, `lft`, `rgt`, `level`, `name`, `title`, `rules`) VALUES (1,0,1,550,0,'root.1','Root Asset','{\"core.login.site\":{\"6\":1,\"2\":1},\"core.login.admin\":{\"6\":1},\"core.login.offline\":{\"6\":1},\"core.admin\":{\"8\":1},\"core.manage\":{\"7\":1},\"core.create\":{\"6\":1,\"3\":1},\"core.delete\":{\"6\":1},\"core.edit\":{\"6\":1,\"4\":1},\"core.edit.state\":{\"6\":1,\"5\":1},\"core.edit.own\":{\"6\":1,\"3\":1}}'),(2,1,1,2,1,'com_admin','com_admin','{}'),(3,1,3,6,1,'com_banners','com_banners','{\"core.admin\":{\"7\":1},\"core.manage\":{\"6\":1},\"core.create\":[],\"core.delete\":[],\"core.edit\":[],\"core.edit.state\":[]}'),(4,1,7,8,1,'com_cache','com_cache','{\"core.admin\":{\"7\":1},\"core.manage\":{\"7\":1}}'),(5,1,9,10,1,'com_checkin','com_checkin','{\"core.admin\":{\"7\":1},\"core.manage\":{\"7\":1}}'),(6,1,11,12,1,'com_config','com_config','{}'),(7,1,13,16,1,'com_contact','com_contact','{\"core.admin\":{\"7\":1},\"core.manage\":{\"6\":1},\"core.create\":[],\"core.delete\":[],\"core.edit\":[],\"core.edit.state\":[],\"core.edit.own\":[]}'),(8,1,17,48,1,'com_content','com_content','{\"core.admin\":{\"7\":1},\"core.manage\":{\"6\":1},\"core.create\":{\"3\":1},\"core.delete\":[],\"core.edit\":{\"4\":1},\"core.edit.state\":{\"5\":1},\"core.edit.own\":[]}'),(9,1,49,50,1,'com_cpanel','com_cpanel','{}'),(10,1,51,52,1,'com_installer','com_installer','{\"core.admin\":{\"7\":1},\"core.manage\":{\"7\":1},\"core.delete\":[],\"core.edit.state\":[]}'),(11,1,53,54,1,'com_languages','com_languages','{\"core.admin\":{\"7\":1},\"core.manage\":[],\"core.create\":[],\"core.delete\":[],\"core.edit\":[],\"core.edit.state\":[]}'),(12,1,55,56,1,'com_login','com_login','{}'),(13,1,57,58,1,'com_mailto','com_mailto','{}'),(14,1,59,60,1,'com_massmail','com_massmail','{}'),(15,1,61,62,1,'com_media','com_media','{\"core.admin\":{\"7\":1},\"core.manage\":{\"6\":1},\"core.create\":{\"3\":1},\"core.delete\":{\"5\":1}}'),(16,1,63,64,1,'com_menus','com_menus','{\"core.admin\":{\"7\":1},\"core.manage\":[],\"core.create\":[],\"core.delete\":[],\"core.edit\":[],\"core.edit.state\":[]}'),(17,1,65,66,1,'com_messages','com_messages','{\"core.admin\":{\"7\":1},\"core.manage\":{\"7\":1}}'),(18,1,67,160,1,'com_modules','com_modules','{\"core.admin\":{\"7\":1},\"core.manage\":[],\"core.create\":[],\"core.delete\":[],\"core.edit\":[],\"core.edit.state\":[]}'),(19,1,161,164,1,'com_newsfeeds','com_newsfeeds','{\"core.admin\":{\"7\":1},\"core.manage\":{\"6\":1},\"core.create\":[],\"core.delete\":[],\"core.edit\":[],\"core.edit.state\":[],\"core.edit.own\":[]}'),(20,1,165,166,1,'com_plugins','com_plugins','{\"core.admin\":{\"7\":1},\"core.manage\":[],\"core.edit\":[],\"core.edit.state\":[]}'),(21,1,167,168,1,'com_redirect','com_redirect','{\"core.admin\":{\"7\":1},\"core.manage\":[]}'),(22,1,169,170,1,'com_search','com_search','{\"core.admin\":{\"7\":1},\"core.manage\":{\"6\":1}}'),(23,1,171,172,1,'com_templates','com_templates','{\"core.admin\":{\"7\":1},\"core.manage\":[],\"core.create\":[],\"core.delete\":[],\"core.edit\":[],\"core.edit.state\":[]}'),(24,1,173,174,1,'com_users','com_users','{\"core.admin\":{\"7\":1},\"core.manage\":[],\"core.create\":[],\"core.delete\":[],\"core.edit\":[],\"core.edit.state\":[],\"core.edit.own\":{\"6\":1}}'),(25,1,175,178,1,'com_weblinks','com_weblinks','{\"core.admin\":{\"7\":1},\"core.manage\":{\"6\":1},\"core.create\":{\"3\":1},\"core.delete\":[],\"core.edit\":{\"4\":1},\"core.edit.state\":{\"5\":1},\"core.edit.own\":[]}'),(26,1,179,180,1,'com_wrapper','com_wrapper','{}'),(27,8,18,31,2,'com_content.category.2','Uncategorised','{\"core.create\":[],\"core.delete\":[],\"core.edit\":[],\"core.edit.state\":[],\"core.edit.own\":[]}'),(28,3,4,5,2,'com_banners.category.3','Uncategorised','{\"core.create\":[],\"core.delete\":[],\"core.edit\":[],\"core.edit.state\":[]}'),(29,7,14,15,2,'com_contact.category.4','Uncategorised','{\"core.create\":[],\"core.delete\":[],\"core.edit\":[],\"core.edit.state\":[],\"core.edit.own\":[]}'),(30,19,162,163,2,'com_newsfeeds.category.5','Uncategorised','{\"core.create\":[],\"core.delete\":[],\"core.edit\":[],\"core.edit.state\":[],\"core.edit.own\":[]}'),(31,25,176,177,2,'com_weblinks.category.6','Uncategorised','{\"core.create\":[],\"core.delete\":[],\"core.edit\":[],\"core.edit.state\":[],\"core.edit.own\":[]}'),(32,27,19,20,3,'com_content.article.1','Car Rental','{\"core.delete\":[],\"core.edit\":[],\"core.edit.state\":[]}'),(33,27,21,22,3,'com_content.article.2','Yacht Rentals','{\"core.delete\":[],\"core.edit\":[],\"core.edit.state\":[]}'),(34,27,23,24,3,'com_content.article.3','Accommodation','{\"core.delete\":[],\"core.edit\":[],\"core.edit.state\":[]}'),(35,27,25,26,3,'com_content.article.4','Camp Sites','{\"core.delete\":[],\"core.edit\":[],\"core.edit.state\":[]}'),(36,27,27,28,3,'com_content.article.5','Tours','{\"core.delete\":[],\"core.edit\":[],\"core.edit.state\":[]}'),(37,27,29,30,3,'com_content.article.6','Real Estate','{\"core.delete\":[],\"core.edit\":[],\"core.edit.state\":[]}'),(38,1,534,535,1,'com_akeeba','akeeba','{\"core.admin\":[],\"core.manage\":[],\"akeeba.backup\":[],\"akeeba.configure\":[],\"akeeba.download\":[]}'),(40,1,538,539,1,'com_joomlaupdate','com_joomlaupdate','{\"core.admin\":{\"8\":1},\"core.manage\":{\"7\":1},\"core.delete\":{\"6\":1},\"core.edit.state\":{\"6\":1,\"5\":1}}'),(41,1,540,541,1,'com_finder','com_finder','{}'),(42,1,542,543,1,'com_tags','com_tags','{}'),(43,1,544,545,1,'com_contenthistory','com_contenthistory','{}'),(44,1,546,547,1,'com_ajax','com_ajax','{}'),(45,1,548,549,1,'com_postinstall','com_postinstall','{}'),(46,18,68,69,2,'com_modules.module.130','Random Accommodation Offers','{\"core.delete\":{\"6\":1},\"core.edit\":{\"6\":1,\"4\":1},\"core.edit.state\":{\"6\":1,\"5\":1}}'),(51,18,70,71,2,'com_modules.module.82','Random Listings Of All Types',''),(52,18,72,73,2,'com_modules.module.131','Most Popular Accommodation','{\"core.delete\":{\"6\":1},\"core.edit\":{\"6\":1,\"4\":1},\"core.edit.state\":{\"6\":1,\"5\":1}}'),(53,18,74,75,2,'com_modules.module.81','Most Viewed Listings Of All Types',''),(55,8,32,37,2,'com_content.category.7','Accommodation slider','{\"core.create\":{\"6\":1,\"3\":1},\"core.delete\":{\"6\":1},\"core.edit\":{\"6\":1,\"4\":1},\"core.edit.state\":{\"6\":1,\"5\":1},\"core.edit.own\":{\"6\":1,\"3\":1}}'),(56,8,38,39,2,'com_content.category.8','Car rental slider','{\"core.create\":{\"6\":1,\"3\":1},\"core.delete\":{\"6\":1},\"core.edit\":{\"6\":1,\"4\":1},\"core.edit.state\":{\"6\":1,\"5\":1},\"core.edit.own\":{\"6\":1,\"3\":1}}'),(57,8,40,41,2,'com_content.category.9','Yacht rental slider','{\"core.create\":{\"6\":1,\"3\":1},\"core.delete\":{\"6\":1},\"core.edit\":{\"6\":1,\"4\":1},\"core.edit.state\":{\"6\":1,\"5\":1},\"core.edit.own\":{\"6\":1,\"3\":1}}'),(58,8,42,43,2,'com_content.category.10','Camp sites slider','{\"core.create\":{\"6\":1,\"3\":1},\"core.delete\":{\"6\":1},\"core.edit\":{\"6\":1,\"4\":1},\"core.edit.state\":{\"6\":1,\"5\":1},\"core.edit.own\":{\"6\":1,\"3\":1}}'),(59,8,44,45,2,'com_content.category.11','Tours slider','{\"core.create\":{\"6\":1,\"3\":1},\"core.delete\":{\"6\":1},\"core.edit\":{\"6\":1,\"4\":1},\"core.edit.state\":{\"6\":1,\"5\":1},\"core.edit.own\":{\"6\":1,\"3\":1}}'),(60,8,46,47,2,'com_content.category.12','Real estate slider','{\"core.create\":{\"6\":1,\"3\":1},\"core.delete\":{\"6\":1},\"core.edit\":{\"6\":1,\"4\":1},\"core.edit.state\":{\"6\":1,\"5\":1},\"core.edit.own\":{\"6\":1,\"3\":1}}'),(61,55,33,34,3,'com_content.article.7','Accommodation test','{\"core.delete\":{\"6\":1},\"core.edit\":{\"6\":1,\"4\":1},\"core.edit.state\":{\"6\":1,\"5\":1}}'),(62,55,35,36,3,'com_content.article.8','Accommodation test2','{\"core.delete\":{\"6\":1},\"core.edit\":{\"6\":1,\"4\":1},\"core.edit.state\":{\"6\":1,\"5\":1}}'),(64,18,76,77,2,'com_modules.module.134','Language','{\"core.delete\":{\"6\":1},\"core.edit\":{\"6\":1,\"4\":1},\"core.edit.state\":{\"6\":1,\"5\":1}}'),(68,18,78,79,2,'com_modules.module.91','Currency','{\"core.delete\":{\"6\":1},\"core.edit\":{\"6\":1,\"4\":1},\"core.edit.state\":{\"6\":1,\"5\":1}}'),(69,18,80,81,2,'com_modules.module.16','Login Form','{\"core.delete\":{\"6\":1},\"core.edit\":{\"6\":1,\"4\":1},\"core.edit.state\":{\"6\":1,\"5\":1}}'),(70,18,82,83,2,'com_modules.module.128','Register your property','{\"core.delete\":{\"6\":1},\"core.edit\":{\"6\":1,\"4\":1},\"core.edit.state\":{\"6\":1,\"5\":1}}'),(71,18,84,85,2,'com_modules.module.80','Tag Cloud','{\"core.delete\":{\"6\":1},\"core.edit\":{\"6\":1,\"4\":1},\"core.edit.state\":{\"6\":1,\"5\":1}}'),(72,18,86,87,2,'com_modules.module.92','Featured Accommodation','{\"core.delete\":{\"6\":1},\"core.edit\":{\"6\":1,\"4\":1},\"core.edit.state\":{\"6\":1,\"5\":1}}'),(73,18,88,89,2,'com_modules.module.94','Fatured Cars','{\"core.delete\":{\"6\":1},\"core.edit\":{\"6\":1,\"4\":1},\"core.edit.state\":{\"6\":1,\"5\":1}}'),(74,18,90,91,2,'com_modules.module.101','Fatured Yachts','{\"core.delete\":{\"6\":1},\"core.edit\":{\"6\":1,\"4\":1},\"core.edit.state\":{\"6\":1,\"5\":1}}'),(75,18,92,93,2,'com_modules.module.102','Fatured Camp Sites','{\"core.delete\":{\"6\":1},\"core.edit\":{\"6\":1,\"4\":1},\"core.edit.state\":{\"6\":1,\"5\":1}}'),(76,18,94,95,2,'com_modules.module.105','Fatured Tours','{\"core.delete\":{\"6\":1},\"core.edit\":{\"6\":1,\"4\":1},\"core.edit.state\":{\"6\":1,\"5\":1}}'),(77,18,96,97,2,'com_modules.module.114','Fatured Real Estate Offers','{\"core.delete\":{\"6\":1},\"core.edit\":{\"6\":1,\"4\":1},\"core.edit.state\":{\"6\":1,\"5\":1}}'),(78,18,98,99,2,'com_modules.module.89','View Accommodation Offers on Map','{\"core.delete\":{\"6\":1},\"core.edit\":{\"6\":1,\"4\":1},\"core.edit.state\":{\"6\":1,\"5\":1}}'),(79,18,100,101,2,'com_modules.module.97','View Car Rental Offers on Map','{\"core.delete\":{\"6\":1},\"core.edit\":{\"6\":1,\"4\":1},\"core.edit.state\":{\"6\":1,\"5\":1}}'),(80,18,102,103,2,'com_modules.module.98','View Camp Sites Offers on Map','{\"core.delete\":{\"6\":1},\"core.edit\":{\"6\":1,\"4\":1},\"core.edit.state\":{\"6\":1,\"5\":1}}'),(81,18,104,105,2,'com_modules.module.100','View Yacht Rental Offers on Map','{\"core.delete\":{\"6\":1},\"core.edit\":{\"6\":1,\"4\":1},\"core.edit.state\":{\"6\":1,\"5\":1}}'),(82,18,106,107,2,'com_modules.module.103','View Tours on Map','{\"core.delete\":{\"6\":1},\"core.edit\":{\"6\":1,\"4\":1},\"core.edit.state\":{\"6\":1,\"5\":1}}'),(83,18,108,109,2,'com_modules.module.112','View Real Estate Offers on Map','{\"core.delete\":{\"6\":1},\"core.edit\":{\"6\":1,\"4\":1},\"core.edit.state\":{\"6\":1,\"5\":1}}'),(84,18,110,111,2,'com_modules.module.127','Search','{\"core.delete\":{\"6\":1},\"core.edit\":{\"6\":1,\"4\":1},\"core.edit.state\":{\"6\":1,\"5\":1}}'),(85,18,112,113,2,'com_modules.module.116','Your cart','{\"core.delete\":{\"6\":1},\"core.edit\":{\"6\":1,\"4\":1},\"core.edit.state\":{\"6\":1,\"5\":1}}'),(89,18,114,115,2,'com_modules.module.139','Breadcrumbs','{\"core.delete\":{\"6\":1},\"core.edit\":{\"6\":1,\"4\":1},\"core.edit.state\":{\"6\":1,\"5\":1}}'),(91,18,116,117,2,'com_modules.module.140','Frontpage Search','{\"core.delete\":{\"6\":1},\"core.edit\":{\"6\":1,\"4\":1},\"core.edit.state\":{\"6\":1,\"5\":1}}'),(92,18,118,119,2,'com_modules.module.141','Call to action - register your property','{\"core.delete\":{\"6\":1},\"core.edit\":{\"6\":1,\"4\":1},\"core.edit.state\":{\"6\":1,\"5\":1}}'),(93,18,120,121,2,'com_modules.module.142','Call to action - Purchase Jomres','{\"core.delete\":[],\"core.edit\":[],\"core.edit.state\":[]}'),(94,18,122,123,2,'com_modules.module.143','Footer','{\"core.delete\":{\"6\":1},\"core.edit\":{\"6\":1,\"4\":1},\"core.edit.state\":{\"6\":1,\"5\":1}}'),(96,18,124,125,2,'com_modules.module.145','Most Popular Cars','{\"core.delete\":[],\"core.edit\":[],\"core.edit.state\":[]}'),(97,18,126,127,2,'com_modules.module.146','Most Popular Yachts','{\"core.delete\":[],\"core.edit\":[],\"core.edit.state\":[]}'),(98,18,128,129,2,'com_modules.module.147','Most Popular Camp Sites','{\"core.delete\":[],\"core.edit\":[],\"core.edit.state\":[]}'),(99,18,130,131,2,'com_modules.module.148','Most Popular Tours','{\"core.delete\":[],\"core.edit\":[],\"core.edit.state\":[]}'),(100,18,132,133,2,'com_modules.module.149','Most Popular Real Estate','{\"core.delete\":[],\"core.edit\":[],\"core.edit.state\":[]}'),(101,18,134,135,2,'com_modules.module.150','Random Cars','{\"core.delete\":[],\"core.edit\":[],\"core.edit.state\":[]}'),(102,18,136,137,2,'com_modules.module.151','Random Yachts','{\"core.delete\":[],\"core.edit\":[],\"core.edit.state\":[]}'),(103,18,138,139,2,'com_modules.module.152','Random Camp Sites','{\"core.delete\":[],\"core.edit\":[],\"core.edit.state\":[]}'),(104,18,140,141,2,'com_modules.module.153','Random Tours','{\"core.delete\":[],\"core.edit\":[],\"core.edit.state\":[]}'),(105,18,142,143,2,'com_modules.module.154','Random Real Estate','{\"core.delete\":[],\"core.edit\":[],\"core.edit.state\":[]}'),(108,18,144,145,2,'com_modules.module.156','Image Slider - Cars','{\"core.delete\":[],\"core.edit\":[],\"core.edit.state\":[]}'),(109,18,146,147,2,'com_modules.module.157','Image Slider - Yachts','{\"core.delete\":[],\"core.edit\":[],\"core.edit.state\":[]}'),(110,18,148,149,2,'com_modules.module.158','Image Slider - Camp Sites','{\"core.delete\":[],\"core.edit\":[],\"core.edit.state\":[]}'),(112,18,150,151,2,'com_modules.module.160','Image Slider - Real Estate','{\"core.delete\":[],\"core.edit\":[],\"core.edit.state\":[]}'),(113,18,152,153,2,'com_modules.module.161','Image Slider - Accommodation','{\"core.delete\":[],\"core.edit\":[],\"core.edit.state\":[]}'),(114,18,154,155,2,'com_modules.module.162','Image Slider - Tours','{\"core.delete\":[],\"core.edit\":[],\"core.edit.state\":[]}'),(115,18,156,157,2,'com_modules.module.163','Share this page',''),(116,18,158,159,2,'com_modules.module.164','Resources','');

--
-- Table structure for table `q43qy_banner_clients`
--

CREATE TABLE `q43qy_banner_clients` (
  `id` 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,
  `state` tinyint(3) NOT NULL DEFAULT 0,
  `checked_out` int(10) unsigned NOT NULL DEFAULT 0,
  `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `metakey` text NOT NULL,
  `own_prefix` tinyint(4) NOT NULL DEFAULT 0,
  `metakey_prefix` varchar(255) NOT NULL DEFAULT '',
  `purchase_type` tinyint(4) NOT NULL DEFAULT -1,
  `track_clicks` tinyint(4) NOT NULL DEFAULT -1,
  `track_impressions` tinyint(4) NOT NULL DEFAULT -1,
  PRIMARY KEY (`id`),
  KEY `idx_own_prefix` (`own_prefix`),
  KEY `idx_metakey_prefix` (`metakey_prefix`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `q43qy_banner_clients`
--


--
-- Table structure for table `q43qy_banner_tracks`
--

CREATE TABLE `q43qy_banner_tracks` (
  `track_date` datetime NOT NULL,
  `track_type` int(10) unsigned NOT NULL,
  `banner_id` int(10) unsigned NOT NULL,
  `count` int(10) unsigned NOT NULL DEFAULT 0,
  PRIMARY KEY (`track_date`,`track_type`,`banner_id`),
  KEY `idx_track_date` (`track_date`),
  KEY `idx_track_type` (`track_type`),
  KEY `idx_banner_id` (`banner_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `q43qy_banner_tracks`
--


--
-- Table structure for table `q43qy_banners`
--

CREATE TABLE `q43qy_banners` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `cid` int(11) NOT NULL DEFAULT 0,
  `type` int(11) NOT NULL DEFAULT 0,
  `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,
  `clickurl` varchar(200) NOT NULL DEFAULT '',
  `state` tinyint(3) NOT NULL DEFAULT 0,
  `catid` int(10) unsigned NOT NULL DEFAULT 0,
  `description` text NOT NULL,
  `custombannercode` varchar(2048) NOT NULL,
  `sticky` tinyint(1) unsigned NOT NULL DEFAULT 0,
  `ordering` int(11) NOT NULL DEFAULT 0,
  `metakey` text NOT NULL,
  `params` text NOT NULL,
  `own_prefix` tinyint(1) NOT NULL DEFAULT 0,
  `metakey_prefix` varchar(255) NOT NULL DEFAULT '',
  `purchase_type` tinyint(4) NOT NULL DEFAULT -1,
  `track_clicks` tinyint(4) NOT NULL DEFAULT -1,
  `track_impressions` tinyint(4) NOT NULL DEFAULT -1,
  `checked_out` int(10) unsigned NOT NULL DEFAULT 0,
  `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `publish_up` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `publish_down` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `reset` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `language` char(7) NOT NULL DEFAULT '',
  `created_by` int(10) unsigned NOT NULL DEFAULT 0,
  `created_by_alias` varchar(255) NOT NULL DEFAULT '',
  `modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `modified_by` int(10) unsigned NOT NULL DEFAULT 0,
  `version` int(10) unsigned NOT NULL DEFAULT 1,
  PRIMARY KEY (`id`),
  KEY `idx_state` (`state`),
  KEY `idx_own_prefix` (`own_prefix`),
  KEY `idx_metakey_prefix` (`metakey_prefix`),
  KEY `idx_banner_catid` (`catid`),
  KEY `idx_language` (`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `q43qy_banners`
--


--
-- Table structure for table `q43qy_categories`
--

CREATE TABLE `q43qy_categories` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `asset_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'FK to the q43qy_assets table.',
  `parent_id` int(10) unsigned NOT NULL DEFAULT 0,
  `lft` int(11) NOT NULL DEFAULT 0,
  `rgt` int(11) NOT NULL DEFAULT 0,
  `level` int(10) unsigned NOT NULL DEFAULT 0,
  `path` varchar(255) NOT NULL DEFAULT '',
  `extension` varchar(50) NOT NULL DEFAULT '',
  `title` varchar(255) NOT NULL,
  `alias` varchar(255) NOT NULL DEFAULT '',
  `note` varchar(255) NOT NULL DEFAULT '',
  `description` mediumtext 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',
  `access` int(10) unsigned NOT NULL DEFAULT 0,
  `params` text NOT NULL,
  `metadesc` varchar(1024) NOT NULL,
  `metakey` varchar(1024) NOT NULL,
  `metadata` varchar(2048) NOT NULL,
  `created_user_id` int(10) unsigned NOT NULL DEFAULT 0,
  `created_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `modified_user_id` int(10) unsigned NOT NULL DEFAULT 0,
  `modified_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `hits` int(10) unsigned NOT NULL DEFAULT 0,
  `language` char(7) NOT NULL,
  `version` int(10) unsigned NOT NULL DEFAULT 1,
  PRIMARY KEY (`id`),
  KEY `cat_idx` (`extension`,`published`,`access`),
  KEY `idx_access` (`access`),
  KEY `idx_checkout` (`checked_out`),
  KEY `idx_path` (`path`),
  KEY `idx_left_right` (`lft`,`rgt`),
  KEY `idx_alias` (`alias`),
  KEY `idx_language` (`language`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `q43qy_categories`
--

INSERT INTO `q43qy_categories` (`id`, `asset_id`, `parent_id`, `lft`, `rgt`, `level`, `path`, `extension`, `title`, `alias`, `note`, `description`, `published`, `checked_out`, `checked_out_time`, `access`, `params`, `metadesc`, `metakey`, `metadata`, `created_user_id`, `created_time`, `modified_user_id`, `modified_time`, `hits`, `language`, `version`) VALUES (1,0,0,0,23,0,'','system','ROOT','root','','',1,0,'0000-00-00 00:00:00',1,'{}','','','',0,'2009-10-18 16:07:09',0,'0000-00-00 00:00:00',0,'*',1),(2,27,1,1,2,1,'uncategorised','com_content','Uncategorised','uncategorised','','',1,0,'0000-00-00 00:00:00',1,'{\"target\":\"\",\"image\":\"\"}','','','{\"page_title\":\"\",\"author\":\"\",\"robots\":\"\"}',42,'2010-06-28 13:26:37',0,'0000-00-00 00:00:00',0,'*',1),(3,28,1,3,4,1,'uncategorised','com_banners','Uncategorised','uncategorised','','',1,0,'0000-00-00 00:00:00',1,'{\"target\":\"\",\"image\":\"\",\"foobar\":\"\"}','','','{\"page_title\":\"\",\"author\":\"\",\"robots\":\"\"}',42,'2010-06-28 13:27:35',0,'0000-00-00 00:00:00',0,'*',1),(4,29,1,5,6,1,'uncategorised','com_contact','Uncategorised','uncategorised','','',1,0,'0000-00-00 00:00:00',1,'{\"target\":\"\",\"image\":\"\"}','','','{\"page_title\":\"\",\"author\":\"\",\"robots\":\"\"}',42,'2010-06-28 13:27:57',0,'0000-00-00 00:00:00',0,'*',1),(5,30,1,7,8,1,'uncategorised','com_newsfeeds','Uncategorised','uncategorised','','',1,0,'0000-00-00 00:00:00',1,'{\"target\":\"\",\"image\":\"\"}','','','{\"page_title\":\"\",\"author\":\"\",\"robots\":\"\"}',42,'2010-06-28 13:28:15',0,'0000-00-00 00:00:00',0,'*',1),(6,31,1,9,10,1,'uncategorised','com_weblinks','Uncategorised','uncategorised','','',1,0,'0000-00-00 00:00:00',1,'{\"target\":\"\",\"image\":\"\"}','','','{\"page_title\":\"\",\"author\":\"\",\"robots\":\"\"}',42,'2010-06-28 13:28:33',0,'0000-00-00 00:00:00',0,'*',1),(7,55,1,11,12,1,'accommodation-slider','com_content','Accommodation slider','accommodation-slider','','',1,0,'0000-00-00 00:00:00',1,'{\"category_layout\":\"\",\"image\":\"\"}','','','{\"author\":\"\",\"robots\":\"\"}',47,'2014-07-31 07:48:15',47,'2014-07-31 08:01:08',0,'*',1),(8,56,1,13,14,1,'car-rental-slider','com_content','Car rental slider','car-rental-slider','','',1,0,'0000-00-00 00:00:00',1,'{\"category_layout\":\"\",\"image\":\"\"}','','','{\"author\":\"\",\"robots\":\"\"}',47,'2014-07-31 07:48:30',47,'2014-07-31 08:01:00',0,'*',1),(9,57,1,15,16,1,'yacht-rental-slider','com_content','Yacht rental slider','yacht-rental-slider','','',1,0,'0000-00-00 00:00:00',1,'{\"category_layout\":\"\",\"image\":\"\"}','','','{\"author\":\"\",\"robots\":\"\"}',47,'2014-07-31 07:48:43',47,'2014-07-31 08:01:20',0,'*',1),(10,58,1,17,18,1,'camp-sites-slider','com_content','Camp sites slider','camp-sites-slider','','',1,0,'0000-00-00 00:00:00',1,'{\"category_layout\":\"\",\"image\":\"\"}','','','{\"author\":\"\",\"robots\":\"\"}',47,'2014-07-31 07:48:54',47,'2014-07-31 08:01:34',0,'*',1),(11,59,1,19,20,1,'tours-slider','com_content','Tours slider','tours-slider','','',1,0,'0000-00-00 00:00:00',1,'{\"category_layout\":\"\",\"image\":\"\"}','','','{\"author\":\"\",\"robots\":\"\"}',47,'2014-07-31 07:49:04',47,'2014-07-31 08:01:46',0,'*',1),(12,60,1,21,22,1,'real-estate-slider','com_content','Real estate slider','real-estate-slider','','',1,0,'0000-00-00 00:00:00',1,'{\"category_layout\":\"\",\"image\":\"\"}','','','{\"author\":\"\",\"robots\":\"\"}',47,'2014-07-31 07:49:17',47,'2014-07-31 08:01:58',0,'*',1);

--
-- Table structure for table `q43qy_contact_details`
--

CREATE TABLE `q43qy_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 DEFAULT NULL,
  `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 DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `email_to` varchar(255) DEFAULT NULL,
  `default_con` tinyint(1) unsigned NOT NULL DEFAULT 0,
  `published` tinyint(1) NOT NULL DEFAULT 0,
  `checked_out` int(10) 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` int(10) unsigned NOT NULL DEFAULT 0,
  `mobile` varchar(255) NOT NULL DEFAULT '',
  `webpage` varchar(255) NOT NULL DEFAULT '',
  `sortname1` varchar(255) NOT NULL,
  `sortname2` varchar(255) NOT NULL,
  `sortname3` varchar(255) NOT NULL,
  `language` char(7) NOT NULL,
  `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `created_by` int(10) unsigned NOT NULL DEFAULT 0,
  `created_by_alias` varchar(255) NOT NULL DEFAULT '',
  `modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `modified_by` int(10) unsigned NOT NULL DEFAULT 0,
  `metakey` text NOT NULL,
  `metadesc` text NOT NULL,
  `metadata` text NOT NULL,
  `featured` tinyint(3) unsigned NOT NULL DEFAULT 0 COMMENT 'Set if article is featured.',
  `xreference` varchar(50) NOT NULL,
  `publish_up` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `publish_down` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `version` int(10) unsigned NOT NULL DEFAULT 1,
  `hits` int(10) unsigned NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `idx_access` (`access`),
  KEY `idx_checkout` (`checked_out`),
  KEY `idx_state` (`published`),
  KEY `idx_catid` (`catid`),
  KEY `idx_createdby` (`created_by`),
  KEY `idx_featured_catid` (`featured`,`catid`),
  KEY `idx_language` (`language`),
  KEY `idx_xreference` (`xreference`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `q43qy_contact_details`
--


--
-- Table structure for table `q43qy_content`
--

CREATE TABLE `q43qy_content` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `asset_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'FK to the q43qy_assets table.',
  `title` varchar(255) NOT NULL DEFAULT '',
  `alias` varchar(255) NOT NULL DEFAULT '',
  `introtext` mediumtext NOT NULL,
  `fulltext` mediumtext NOT NULL,
  `state` tinyint(3) NOT NULL DEFAULT 0,
  `catid` int(10) unsigned NOT NULL DEFAULT 0,
  `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `created_by` int(10) unsigned NOT NULL DEFAULT 0,
  `created_by_alias` varchar(255) NOT NULL DEFAULT '',
  `modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `modified_by` int(10) unsigned NOT NULL DEFAULT 0,
  `checked_out` int(10) unsigned NOT NULL DEFAULT 0,
  `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `publish_up` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `publish_down` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `images` text NOT NULL,
  `urls` text NOT NULL,
  `attribs` varchar(5120) NOT NULL,
  `version` int(10) unsigned NOT NULL DEFAULT 1,
  `ordering` int(11) NOT NULL DEFAULT 0,
  `metakey` text NOT NULL,
  `metadesc` text NOT NULL,
  `access` int(10) unsigned NOT NULL DEFAULT 0,
  `hits` int(10) unsigned NOT NULL DEFAULT 0,
  `metadata` text NOT NULL,
  `featured` tinyint(3) unsigned NOT NULL DEFAULT 0 COMMENT 'Set if article is featured.',
  `language` char(7) NOT NULL,
  `xreference` varchar(50) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_access` (`access`),
  KEY `idx_checkout` (`checked_out`),
  KEY `idx_state` (`state`),
  KEY `idx_catid` (`catid`),
  KEY `idx_createdby` (`created_by`),
  KEY `idx_featured_catid` (`featured`,`catid`),
  KEY `idx_language` (`language`),
  KEY `idx_xreference` (`xreference`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `q43qy_content`
--

INSERT INTO `q43qy_content` (`id`, `asset_id`, `title`, `alias`, `introtext`, `fulltext`, `state`, `catid`, `created`, `created_by`, `created_by_alias`, `modified`, `modified_by`, `checked_out`, `checked_out_time`, `publish_up`, `publish_down`, `images`, `urls`, `attribs`, `version`, `ordering`, `metakey`, `metadesc`, `access`, `hits`, `metadata`, `featured`, `language`, `xreference`) VALUES (1,32,'Car Rental','car-rental','<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Proin posuere, nisl at porttitor dignissim, risus tortor aliquam augue, ut consectetur dui quam vitae purus. Vestibulum id tellus ligula, vel elementum est. Ut in ligula est, id lobortis justo. Mauris pretium posuere blandit. Sed suscipit orci sed ipsum interdum accumsan. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Integer eu felis sapien. Nulla ultrices dapibus dapibus. Etiam suscipit lorem et augue elementum congue. Mauris id euismod arcu. Nam commodo rhoncus urna sit amet faucibus. Phasellus sed dui mauris. Proin quis felis lectus. Sed nec nulla nulla, posuere consequat urna. Nunc porta turpis ut urna dictum gravida.</p>','',1,2,'2012-01-11 15:00:43',42,'','2012-01-13 07:47:32',42,0,'0000-00-00 00:00:00','2012-01-11 15:00:43','0000-00-00 00:00:00','','','{\"show_title\":\"\",\"link_titles\":\"\",\"show_intro\":\"\",\"show_category\":\"\",\"link_category\":\"\",\"show_parent_category\":\"\",\"link_parent_category\":\"\",\"show_author\":\"\",\"link_author\":\"\",\"show_create_date\":\"\",\"show_modify_date\":\"\",\"show_publish_date\":\"\",\"show_item_navigation\":\"\",\"show_icons\":\"\",\"show_print_icon\":\"\",\"show_email_icon\":\"\",\"show_vote\":\"\",\"show_hits\":\"\",\"show_noauth\":\"\",\"alternative_readmore\":\"\",\"article_layout\":\"\"}',3,5,'','',1,3754,'{\"robots\":\"\",\"author\":\"\",\"rights\":\"\",\"xreference\":\"\"}',0,'*',''),(2,33,'Yacht Rentals','yacht-rentals','<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Proin posuere, nisl at porttitor dignissim, risus tortor aliquam augue, ut consectetur dui quam vitae purus. Vestibulum id tellus ligula, vel elementum est. Ut in ligula est, id lobortis justo. Mauris pretium posuere blandit. Sed suscipit orci sed ipsum interdum accumsan. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Integer eu felis sapien. Nulla ultrices dapibus dapibus. Etiam suscipit lorem et augue elementum congue. Mauris id euismod arcu. Nam commodo rhoncus urna sit amet faucibus. Phasellus sed dui mauris. Proin quis felis lectus. Sed nec nulla nulla, posuere consequat urna. Nunc porta turpis ut urna dictum gravida.</p>','',1,2,'2012-01-11 15:55:29',42,'','2012-01-13 07:47:53',42,0,'0000-00-00 00:00:00','2012-01-11 15:55:29','0000-00-00 00:00:00','','','{\"show_title\":\"\",\"link_titles\":\"\",\"show_intro\":\"\",\"show_category\":\"\",\"link_category\":\"\",\"show_parent_category\":\"\",\"link_parent_category\":\"\",\"show_author\":\"\",\"link_author\":\"\",\"show_create_date\":\"\",\"show_modify_date\":\"\",\"show_publish_date\":\"\",\"show_item_navigation\":\"\",\"show_icons\":\"\",\"show_print_icon\":\"\",\"show_email_icon\":\"\",\"show_vote\":\"\",\"show_hits\":\"\",\"show_noauth\":\"\",\"alternative_readmore\":\"\",\"article_layout\":\"\"}',3,4,'','',1,1991,'{\"robots\":\"\",\"author\":\"\",\"rights\":\"\",\"xreference\":\"\"}',0,'*',''),(3,34,'Accommodation','accommodation','<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Proin posuere, nisl at porttitor dignissim, risus tortor aliquam augue, ut consectetur dui quam vitae purus. Vestibulum id tellus ligula, vel elementum est. Ut in ligula est, id lobortis justo. Mauris pretium posuere blandit. Sed suscipit orci sed ipsum interdum accumsan. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Integer eu felis sapien. Nulla ultrices dapibus dapibus. Etiam suscipit lorem et augue elementum congue. Mauris id euismod arcu. Nam commodo rhoncus urna sit amet faucibus. Phasellus sed dui mauris. Proin quis felis lectus. Sed nec nulla nulla, posuere consequat urna. Nunc porta turpis ut urna dictum gravida.</p>','',1,2,'2012-01-11 15:55:55',42,'','2012-01-13 07:47:10',42,0,'0000-00-00 00:00:00','2012-01-11 15:55:55','0000-00-00 00:00:00','','','{\"show_title\":\"\",\"link_titles\":\"\",\"show_intro\":\"\",\"show_category\":\"\",\"link_category\":\"\",\"show_parent_category\":\"\",\"link_parent_category\":\"\",\"show_author\":\"\",\"link_author\":\"\",\"show_create_date\":\"\",\"show_modify_date\":\"\",\"show_publish_date\":\"\",\"show_item_navigation\":\"\",\"show_icons\":\"\",\"show_print_icon\":\"\",\"show_email_icon\":\"\",\"show_vote\":\"\",\"show_hits\":\"\",\"show_noauth\":\"\",\"alternative_readmore\":\"\",\"article_layout\":\"\"}',2,3,'','',1,50745,'{\"robots\":\"\",\"author\":\"\",\"rights\":\"\",\"xreference\":\"\"}',0,'*',''),(4,35,'Camp Sites','camp-sites','<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Proin posuere, nisl at porttitor dignissim, risus tortor aliquam augue, ut consectetur dui quam vitae purus. Vestibulum id tellus ligula, vel elementum est. Ut in ligula est, id lobortis justo. Mauris pretium posuere blandit. Sed suscipit orci sed ipsum interdum accumsan. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Integer eu felis sapien. Nulla ultrices dapibus dapibus. Etiam suscipit lorem et augue elementum congue. Mauris id euismod arcu. Nam commodo rhoncus urna sit amet faucibus. Phasellus sed dui mauris. Proin quis felis lectus. Sed nec nulla nulla, posuere consequat urna. Nunc porta turpis ut urna dictum gravida.</p>','',1,2,'2012-01-11 15:56:59',42,'','2012-01-13 07:47:22',42,0,'0000-00-00 00:00:00','2012-01-11 15:56:59','0000-00-00 00:00:00','','','{\"show_title\":\"\",\"link_titles\":\"\",\"show_intro\":\"\",\"show_category\":\"\",\"link_category\":\"\",\"show_parent_category\":\"\",\"link_parent_category\":\"\",\"show_author\":\"\",\"link_author\":\"\",\"show_create_date\":\"\",\"show_modify_date\":\"\",\"show_publish_date\":\"\",\"show_item_navigation\":\"\",\"show_icons\":\"\",\"show_print_icon\":\"\",\"show_email_icon\":\"\",\"show_vote\":\"\",\"show_hits\":\"\",\"show_noauth\":\"\",\"alternative_readmore\":\"\",\"article_layout\":\"\"}',2,2,'','',1,2018,'{\"robots\":\"\",\"author\":\"\",\"rights\":\"\",\"xreference\":\"\"}',0,'*',''),(5,36,'Tours','tours','<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Proin posuere, nisl at porttitor dignissim, risus tortor aliquam augue, ut consectetur dui quam vitae purus. Vestibulum id tellus ligula, vel elementum est. Ut in ligula est, id lobortis justo. Mauris pretium posuere blandit. Sed suscipit orci sed ipsum interdum accumsan. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Integer eu felis sapien. Nulla ultrices dapibus dapibus. Etiam suscipit lorem et augue elementum congue. Mauris id euismod arcu. Nam commodo rhoncus urna sit amet faucibus. Phasellus sed dui mauris. Proin quis felis lectus. Sed nec nulla nulla, posuere consequat urna. Nunc porta turpis ut urna dictum gravida.</p>','',1,2,'2012-01-12 13:39:40',42,'','2012-01-13 07:47:43',42,0,'0000-00-00 00:00:00','2012-01-12 13:39:40','0000-00-00 00:00:00','','','{\"show_title\":\"\",\"link_titles\":\"\",\"show_intro\":\"\",\"show_category\":\"\",\"link_category\":\"\",\"show_parent_category\":\"\",\"link_parent_category\":\"\",\"show_author\":\"\",\"link_author\":\"\",\"show_create_date\":\"\",\"show_modify_date\":\"\",\"show_publish_date\":\"\",\"show_item_navigation\":\"\",\"show_icons\":\"\",\"show_print_icon\":\"\",\"show_email_icon\":\"\",\"show_vote\":\"\",\"show_hits\":\"\",\"show_noauth\":\"\",\"alternative_readmore\":\"\",\"article_layout\":\"\"}',2,1,'','',1,2478,'{\"robots\":\"\",\"author\":\"\",\"rights\":\"\",\"xreference\":\"\"}',0,'*',''),(6,37,'Real Estate','real-estate','<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Proin posuere, nisl at porttitor dignissim, risus tortor aliquam augue, ut consectetur dui quam vitae purus. Vestibulum id tellus ligula, vel elementum est. Ut in ligula est, id lobortis justo. Mauris pretium posuere blandit. Sed suscipit orci sed ipsum interdum accumsan. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Integer eu felis sapien. Nulla ultrices dapibus dapibus. Etiam suscipit lorem et augue elementum congue. Mauris id euismod arcu. Nam commodo rhoncus urna sit amet faucibus. Phasellus sed dui mauris. Proin quis felis lectus. Sed nec nulla nulla, posuere consequat urna. Nunc porta turpis ut urna dictum gravida.</p>','',1,2,'2012-01-13 08:23:17',42,'','0000-00-00 00:00:00',0,0,'0000-00-00 00:00:00','2012-01-13 08:23:16','0000-00-00 00:00:00','','','{\"show_title\":\"\",\"link_titles\":\"\",\"show_intro\":\"\",\"show_category\":\"\",\"link_category\":\"\",\"show_parent_category\":\"\",\"link_parent_category\":\"\",\"show_author\":\"\",\"link_author\":\"\",\"show_create_date\":\"\",\"show_modify_date\":\"\",\"show_publish_date\":\"\",\"show_item_navigation\":\"\",\"show_icons\":\"\",\"show_print_icon\":\"\",\"show_email_icon\":\"\",\"show_vote\":\"\",\"show_hits\":\"\",\"show_noauth\":\"\",\"alternative_readmore\":\"\",\"article_layout\":\"\"}',1,0,'','',1,2294,'{\"robots\":\"\",\"author\":\"\",\"rights\":\"\",\"xreference\":\"\"}',0,'*',''),(7,61,'Accommodation test','accommodation-test','<p>Test text</p>','',1,7,'2014-07-31 07:59:03',47,'','2014-08-05 11:39:22',47,0,'0000-00-00 00:00:00','2014-07-31 07:59:03','0000-00-00 00:00:00','{\"image_intro\":\"images\\/parallaxslider\\/accommodation1.jpg\",\"float_intro\":\"\",\"image_intro_alt\":\"\",\"image_intro_caption\":\"\",\"image_fulltext\":\"images\\/parallaxslider\\/accommodation1.jpg\",\"float_fulltext\":\"\",\"image_fulltext_alt\":\"\",\"image_fulltext_caption\":\"\"}','{\"urla\":false,\"urlatext\":\"\",\"targeta\":\"\",\"urlb\":false,\"urlbtext\":\"\",\"targetb\":\"\",\"urlc\":false,\"urlctext\":\"\",\"targetc\":\"\"}','{\"show_title\":\"\",\"link_titles\":\"\",\"show_tags\":\"\",\"show_intro\":\"\",\"info_block_position\":\"\",\"show_category\":\"\",\"link_category\":\"\",\"show_parent_category\":\"\",\"link_parent_category\":\"\",\"show_author\":\"\",\"link_author\":\"\",\"show_create_date\":\"\",\"show_modify_date\":\"\",\"show_publish_date\":\"\",\"show_item_navigation\":\"\",\"show_icons\":\"\",\"show_print_icon\":\"\",\"show_email_icon\":\"\",\"show_vote\":\"\",\"show_hits\":\"\",\"show_noauth\":\"\",\"urls_position\":\"\",\"alternative_readmore\":\"\",\"article_layout\":\"\",\"show_publishing_options\":\"\",\"show_article_options\":\"\",\"show_urls_images_backend\":\"\",\"show_urls_images_frontend\":\"\"}',4,1,'','',1,0,'{\"robots\":\"\",\"author\":\"\",\"rights\":\"\",\"xreference\":\"\"}',0,'*',''),(8,62,'Accommodation test2','accommodation-test2','<p> test text 2test text 2vvtest text 2test text 2vvtest text 2test text 2test text 2test text 2test text 2test text 2v</p>','',1,7,'2014-07-31 08:04:51',47,'','2014-08-05 11:39:40',47,0,'0000-00-00 00:00:00','2014-07-31 08:04:51','0000-00-00 00:00:00','{\"image_intro\":\"images\\/parallaxslider\\/accommodation2.jpg\",\"float_intro\":\"\",\"image_intro_alt\":\"\",\"image_intro_caption\":\"\",\"image_fulltext\":\"images\\/parallaxslider\\/accommodation2.jpg\",\"float_fulltext\":\"\",\"image_fulltext_alt\":\"\",\"image_fulltext_caption\":\"\"}','{\"urla\":false,\"urlatext\":\"\",\"targeta\":\"\",\"urlb\":false,\"urlbtext\":\"\",\"targetb\":\"\",\"urlc\":false,\"urlctext\":\"\",\"targetc\":\"\"}','{\"show_title\":\"\",\"link_titles\":\"\",\"show_tags\":\"\",\"show_intro\":\"\",\"info_block_position\":\"\",\"show_category\":\"\",\"link_category\":\"\",\"show_parent_category\":\"\",\"link_parent_category\":\"\",\"show_author\":\"\",\"link_author\":\"\",\"show_create_date\":\"\",\"show_modify_date\":\"\",\"show_publish_date\":\"\",\"show_item_navigation\":\"\",\"show_icons\":\"\",\"show_print_icon\":\"\",\"show_email_icon\":\"\",\"show_vote\":\"\",\"show_hits\":\"\",\"show_noauth\":\"\",\"urls_position\":\"\",\"alternative_readmore\":\"\",\"article_layout\":\"\",\"show_publishing_options\":\"\",\"show_article_options\":\"\",\"show_urls_images_backend\":\"\",\"show_urls_images_frontend\":\"\"}',3,0,'','',1,0,'{\"robots\":\"\",\"author\":\"\",\"rights\":\"\",\"xreference\":\"\"}',0,'*','');

--
-- Table structure for table `q43qy_content_frontpage`
--

CREATE TABLE `q43qy_content_frontpage` (
  `content_id` int(11) NOT NULL DEFAULT 0,
  `ordering` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`content_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `q43qy_content_frontpage`
--


--
-- Table structure for table `q43qy_content_rating`
--

CREATE TABLE `q43qy_content_rating` (
  `content_id` int(11) NOT NULL DEFAULT 0,
  `rating_sum` int(10) unsigned NOT NULL DEFAULT 0,
  `rating_count` int(10) unsigned NOT NULL DEFAULT 0,
  `lastip` varchar(50) NOT NULL DEFAULT '',
  PRIMARY KEY (`content_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `q43qy_content_rating`
--


--
-- Table structure for table `q43qy_content_types`
--

CREATE TABLE `q43qy_content_types` (
  `type_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `type_title` varchar(255) NOT NULL DEFAULT '',
  `type_alias` varchar(255) NOT NULL DEFAULT '',
  `table` varchar(255) NOT NULL DEFAULT '',
  `rules` text NOT NULL,
  `field_mappings` text NOT NULL,
  `router` varchar(255) NOT NULL DEFAULT '',
  `content_history_options` varchar(5120) NOT NULL COMMENT 'JSON string for com_contenthistory options',
  PRIMARY KEY (`type_id`),
  KEY `idx_alias` (`type_alias`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `q43qy_content_types`
--

INSERT INTO `q43qy_content_types` (`type_id`, `type_title`, `type_alias`, `table`, `rules`, `field_mappings`, `router`, `content_history_options`) VALUES (1,'Article','com_content.article','{\"special\":{\"dbtable\":\"#__content\",\"key\":\"id\",\"type\":\"Content\",\"prefix\":\"JTable\",\"config\":\"array()\"},\"common\":{\"dbtable\":\"#__ucm_content\",\"key\":\"ucm_id\",\"type\":\"Corecontent\",\"prefix\":\"JTable\",\"config\":\"array()\"}}','','{\"common\":{\"core_content_item_id\":\"id\",\"core_title\":\"title\",\"core_state\":\"state\",\"core_alias\":\"alias\",\"core_created_time\":\"created\",\"core_modified_time\":\"modified\",\"core_body\":\"introtext\", \"core_hits\":\"hits\",\"core_publish_up\":\"publish_up\",\"core_publish_down\":\"publish_down\",\"core_access\":\"access\", \"core_params\":\"attribs\", \"core_featured\":\"featured\", \"core_metadata\":\"metadata\", \"core_language\":\"language\", \"core_images\":\"images\", \"core_urls\":\"urls\", \"core_version\":\"version\", \"core_ordering\":\"ordering\", \"core_metakey\":\"metakey\", \"core_metadesc\":\"metadesc\", \"core_catid\":\"catid\", \"core_xreference\":\"xreference\", \"asset_id\":\"asset_id\"}, \"special\": {\"fulltext\":\"fulltext\"}}','ContentHelperRoute::getArticleRoute','{\"formFile\":\"administrator\\/components\\/com_content\\/models\\/forms\\/article.xml\", \"hideFields\":[\"asset_id\",\"checked_out\",\"checked_out_time\",\"version\"],\"ignoreChanges\":[\"modified_by\", \"modified\", \"checked_out\", \"checked_out_time\", \"version\", \"hits\"],\"convertToInt\":[\"publish_up\", \"publish_down\", \"featured\", \"ordering\"],\"displayLookup\":[{\"sourceColumn\":\"catid\",\"targetTable\":\"#__categories\",\"targetColumn\":\"id\",\"displayColumn\":\"title\"},{\"sourceColumn\":\"created_by\",\"targetTable\":\"#__users\",\"targetColumn\":\"id\",\"displayColumn\":\"name\"},{\"sourceColumn\":\"access\",\"targetTable\":\"#__viewlevels\",\"targetColumn\":\"id\",\"displayColumn\":\"title\"},{\"sourceColumn\":\"modified_by\",\"targetTable\":\"#__users\",\"targetColumn\":\"id\",\"displayColumn\":\"name\"} ]}'),(2,'Weblink','com_weblinks.weblink','{\"special\":{\"dbtable\":\"#__weblinks\",\"key\":\"id\",\"type\":\"Weblink\",\"prefix\":\"WeblinksTable\",\"config\":\"array()\"},\"common\":{\"dbtable\":\"#__ucm_content\",\"key\":\"ucm_id\",\"type\":\"Corecontent\",\"prefix\":\"JTable\",\"config\":\"array()\"}}','','{\"common\":{\"core_content_item_id\":\"id\",\"core_title\":\"title\",\"core_state\":\"state\",\"core_alias\":\"alias\",\"core_created_time\":\"created\",\"core_modified_time\":\"modified\",\"core_body\":\"description\", \"core_hits\":\"hits\",\"core_publish_up\":\"publish_up\",\"core_publish_down\":\"publish_down\",\"core_access\":\"access\", \"core_params\":\"params\", \"core_featured\":\"featured\", \"core_metadata\":\"metadata\", \"core_language\":\"language\", \"core_images\":\"images\", \"core_urls\":\"url\", \"core_version\":\"version\", \"core_ordering\":\"ordering\", \"core_metakey\":\"metakey\", \"core_metadesc\":\"metadesc\", \"core_catid\":\"catid\", \"core_xreference\":\"xreference\", \"asset_id\":\"null\"}, \"special\": {}}','WeblinksHelperRoute::getWeblinkRoute','{\"formFile\":\"administrator\\/components\\/com_weblinks\\/models\\/forms\\/weblink.xml\", \"hideFields\":[\"asset_id\",\"checked_out\",\"checked_out_time\",\"version\",\"featured\",\"images\"], \"ignoreChanges\":[\"modified_by\", \"modified\", \"checked_out\", \"checked_out_time\", \"version\", \"hits\"], \"convertToInt\":[\"publish_up\", \"publish_down\", \"featured\", \"ordering\"], \"displayLookup\":[{\"sourceColumn\":\"catid\",\"targetTable\":\"#__categories\",\"targetColumn\":\"id\",\"displayColumn\":\"title\"},{\"sourceColumn\":\"created_by\",\"targetTable\":\"#__users\",\"targetColumn\":\"id\",\"displayColumn\":\"name\"},{\"sourceColumn\":\"access\",\"targetTable\":\"#__viewlevels\",\"targetColumn\":\"id\",\"displayColumn\":\"title\"},{\"sourceColumn\":\"modified_by\",\"targetTable\":\"#__users\",\"targetColumn\":\"id\",\"displayColumn\":\"name\"} ]}'),(3,'Contact','com_contact.contact','{\"special\":{\"dbtable\":\"#__contact_details\",\"key\":\"id\",\"type\":\"Contact\",\"prefix\":\"ContactTable\",\"config\":\"array()\"},\"common\":{\"dbtable\":\"#__ucm_content\",\"key\":\"ucm_id\",\"type\":\"Corecontent\",\"prefix\":\"JTable\",\"config\":\"array()\"}}','','{\"common\":{\"core_content_item_id\":\"id\",\"core_title\":\"name\",\"core_state\":\"published\",\"core_alias\":\"alias\",\"core_created_time\":\"created\",\"core_modified_time\":\"modified\",\"core_body\":\"address\", \"core_hits\":\"hits\",\"core_publish_up\":\"publish_up\",\"core_publish_down\":\"publish_down\",\"core_access\":\"access\", \"core_params\":\"params\", \"core_featured\":\"featured\", \"core_metadata\":\"metadata\", \"core_language\":\"language\", \"core_images\":\"image\", \"core_urls\":\"webpage\", \"core_version\":\"version\", \"core_ordering\":\"ordering\", \"core_metakey\":\"metakey\", \"core_metadesc\":\"metadesc\", \"core_catid\":\"catid\", \"core_xreference\":\"xreference\", \"asset_id\":\"null\"}, \"special\": {\"con_position\":\"con_position\",\"suburb\":\"suburb\",\"state\":\"state\",\"country\":\"country\",\"postcode\":\"postcode\",\"telephone\":\"telephone\",\"fax\":\"fax\",\"misc\":\"misc\",\"email_to\":\"email_to\",\"default_con\":\"default_con\",\"user_id\":\"user_id\",\"mobile\":\"mobile\",\"sortname1\":\"sortname1\",\"sortname2\":\"sortname2\",\"sortname3\":\"sortname3\"}}','ContactHelperRoute::getContactRoute','{\"formFile\":\"administrator\\/components\\/com_contact\\/models\\/forms\\/contact.xml\",\"hideFields\":[\"default_con\",\"checked_out\",\"checked_out_time\",\"version\",\"xreference\"],\"ignoreChanges\":[\"modified_by\", \"modified\", \"checked_out\", \"checked_out_time\", \"version\", \"hits\"],\"convertToInt\":[\"publish_up\", \"publish_down\", \"featured\", \"ordering\"], \"displayLookup\":[ {\"sourceColumn\":\"created_by\",\"targetTable\":\"#__users\",\"targetColumn\":\"id\",\"displayColumn\":\"name\"},{\"sourceColumn\":\"catid\",\"targetTable\":\"#__categories\",\"targetColumn\":\"id\",\"displayColumn\":\"title\"},{\"sourceColumn\":\"modified_by\",\"targetTable\":\"#__users\",\"targetColumn\":\"id\",\"displayColumn\":\"name\"},{\"sourceColumn\":\"access\",\"targetTable\":\"#__viewlevels\",\"targetColumn\":\"id\",\"displayColumn\":\"title\"},{\"sourceColumn\":\"user_id\",\"targetTable\":\"#__users\",\"targetColumn\":\"id\",\"displayColumn\":\"name\"} ] }'),(4,'Newsfeed','com_newsfeeds.newsfeed','{\"special\":{\"dbtable\":\"#__newsfeeds\",\"key\":\"id\",\"type\":\"Newsfeed\",\"prefix\":\"NewsfeedsTable\",\"config\":\"array()\"},\"common\":{\"dbtable\":\"#__ucm_content\",\"key\":\"ucm_id\",\"type\":\"Corecontent\",\"prefix\":\"JTable\",\"config\":\"array()\"}}','','{\"common\":{\"core_content_item_id\":\"id\",\"core_title\":\"name\",\"core_state\":\"published\",\"core_alias\":\"alias\",\"core_created_time\":\"created\",\"core_modified_time\":\"modified\",\"core_body\":\"description\", \"core_hits\":\"hits\",\"core_publish_up\":\"publish_up\",\"core_publish_down\":\"publish_down\",\"core_access\":\"access\", \"core_params\":\"params\", \"core_featured\":\"featured\", \"core_metadata\":\"metadata\", \"core_language\":\"language\", \"core_images\":\"images\", \"core_urls\":\"link\", \"core_version\":\"version\", \"core_ordering\":\"ordering\", \"core_metakey\":\"metakey\", \"core_metadesc\":\"metadesc\", \"core_catid\":\"catid\", \"core_xreference\":\"xreference\", \"asset_id\":\"null\"}, \"special\": {\"numarticles\":\"numarticles\",\"cache_time\":\"cache_time\",\"rtl\":\"rtl\"}}','NewsfeedsHelperRoute::getNewsfeedRoute','{\"formFile\":\"administrator\\/components\\/com_newsfeeds\\/models\\/forms\\/newsfeed.xml\",\"hideFields\":[\"asset_id\",\"checked_out\",\"checked_out_time\",\"version\"],\"ignoreChanges\":[\"modified_by\", \"modified\", \"checked_out\", \"checked_out_time\", \"version\", \"hits\"],\"convertToInt\":[\"publish_up\", \"publish_down\", \"featured\", \"ordering\"],\"displayLookup\":[{\"sourceColumn\":\"catid\",\"targetTable\":\"#__categories\",\"targetColumn\":\"id\",\"displayColumn\":\"title\"},{\"sourceColumn\":\"created_by\",\"targetTable\":\"#__users\",\"targetColumn\":\"id\",\"displayColumn\":\"name\"},{\"sourceColumn\":\"access\",\"targetTable\":\"#__viewlevels\",\"targetColumn\":\"id\",\"displayColumn\":\"title\"},{\"sourceColumn\":\"modified_by\",\"targetTable\":\"#__users\",\"targetColumn\":\"id\",\"displayColumn\":\"name\"}]}'),(5,'User','com_users.user','{\"special\":{\"dbtable\":\"#__users\",\"key\":\"id\",\"type\":\"User\",\"prefix\":\"JTable\",\"config\":\"array()\"},\"common\":{\"dbtable\":\"#__ucm_content\",\"key\":\"ucm_id\",\"type\":\"Corecontent\",\"prefix\":\"JTable\",\"config\":\"array()\"}}','','{\"common\":{\"core_content_item_id\":\"id\",\"core_title\":\"name\",\"core_state\":\"null\",\"core_alias\":\"username\",\"core_created_time\":\"registerdate\",\"core_modified_time\":\"lastvisitDate\",\"core_body\":\"null\", \"core_hits\":\"null\",\"core_publish_up\":\"null\",\"core_publish_down\":\"null\",\"access\":\"null\", \"core_params\":\"params\", \"core_featured\":\"null\", \"core_metadata\":\"null\", \"core_language\":\"null\", \"core_images\":\"null\", \"core_urls\":\"null\", \"core_version\":\"null\", \"core_ordering\":\"null\", \"core_metakey\":\"null\", \"core_metadesc\":\"null\", \"core_catid\":\"null\", \"core_xreference\":\"null\", \"asset_id\":\"null\"}, \"special\": {}}','UsersHelperRoute::getUserRoute',''),(6,'Article Category','com_content.category','{\"special\":{\"dbtable\":\"#__categories\",\"key\":\"id\",\"type\":\"Category\",\"prefix\":\"JTable\",\"config\":\"array()\"},\"common\":{\"dbtable\":\"#__ucm_content\",\"key\":\"ucm_id\",\"type\":\"Corecontent\",\"prefix\":\"JTable\",\"config\":\"array()\"}}','','{\"common\":{\"core_content_item_id\":\"id\",\"core_title\":\"title\",\"core_state\":\"published\",\"core_alias\":\"alias\",\"core_created_time\":\"created_time\",\"core_modified_time\":\"modified_time\",\"core_body\":\"description\", \"core_hits\":\"hits\",\"core_publish_up\":\"null\",\"core_publish_down\":\"null\",\"core_access\":\"access\", \"core_params\":\"params\", \"core_featured\":\"null\", \"core_metadata\":\"metadata\", \"core_language\":\"language\", \"core_images\":\"null\", \"core_urls\":\"null\", \"core_version\":\"version\", \"core_ordering\":\"null\", \"core_metakey\":\"metakey\", \"core_metadesc\":\"metadesc\", \"core_catid\":\"parent_id\", \"core_xreference\":\"null\", \"asset_id\":\"asset_id\"}, \"special\": {\"parent_id\":\"parent_id\",\"lft\":\"lft\",\"rgt\":\"rgt\",\"level\":\"level\",\"path\":\"path\",\"extension\":\"extension\",\"note\":\"note\"}}','ContentHelperRoute::getCategoryRoute','{\"formFile\":\"administrator\\/components\\/com_categories\\/models\\/forms\\/category.xml\", \"hideFields\":[\"asset_id\",\"checked_out\",\"checked_out_time\",\"version\",\"lft\",\"rgt\",\"level\",\"path\",\"extension\"], \"ignoreChanges\":[\"modified_user_id\", \"modified_time\", \"checked_out\", \"checked_out_time\", \"version\", \"hits\", \"path\"],\"convertToInt\":[\"publish_up\", \"publish_down\"], \"displayLookup\":[{\"sourceColumn\":\"created_user_id\",\"targetTable\":\"#__users\",\"targetColumn\":\"id\",\"displayColumn\":\"name\"},{\"sourceColumn\":\"access\",\"targetTable\":\"#__viewlevels\",\"targetColumn\":\"id\",\"displayColumn\":\"title\"},{\"sourceColumn\":\"modified_user_id\",\"targetTable\":\"#__users\",\"targetColumn\":\"id\",\"displayColumn\":\"name\"},{\"sourceColumn\":\"parent_id\",\"targetTable\":\"#__categories\",\"targetColumn\":\"id\",\"displayColumn\":\"title\"}]}'),(7,'Contact Category','com_contact.category','{\"special\":{\"dbtable\":\"#__categories\",\"key\":\"id\",\"type\":\"Category\",\"prefix\":\"JTable\",\"config\":\"array()\"},\"common\":{\"dbtable\":\"#__ucm_content\",\"key\":\"ucm_id\",\"type\":\"Corecontent\",\"prefix\":\"JTable\",\"config\":\"array()\"}}','','{\"common\":{\"core_content_item_id\":\"id\",\"core_title\":\"title\",\"core_state\":\"published\",\"core_alias\":\"alias\",\"core_created_time\":\"created_time\",\"core_modified_time\":\"modified_time\",\"core_body\":\"description\", \"core_hits\":\"hits\",\"core_publish_up\":\"null\",\"core_publish_down\":\"null\",\"core_access\":\"access\", \"core_params\":\"params\", \"core_featured\":\"null\", \"core_metadata\":\"metadata\", \"core_language\":\"language\", \"core_images\":\"null\", \"core_urls\":\"null\", \"core_version\":\"version\", \"core_ordering\":\"null\", \"core_metakey\":\"metakey\", \"core_metadesc\":\"metadesc\", \"core_catid\":\"parent_id\", \"core_xreference\":\"null\", \"asset_id\":\"asset_id\"}, \"special\": {\"parent_id\":\"parent_id\",\"lft\":\"lft\",\"rgt\":\"rgt\",\"level\":\"level\",\"path\":\"path\",\"extension\":\"extension\",\"note\":\"note\"}}','ContactHelperRoute::getCategoryRoute','{\"formFile\":\"administrator\\/components\\/com_categories\\/models\\/forms\\/category.xml\", \"hideFields\":[\"asset_id\",\"checked_out\",\"checked_out_time\",\"version\",\"lft\",\"rgt\",\"level\",\"path\",\"extension\"], \"ignoreChanges\":[\"modified_user_id\", \"modified_time\", \"checked_out\", \"checked_out_time\", \"version\", \"hits\", \"path\"],\"convertToInt\":[\"publish_up\", \"publish_down\"], \"displayLookup\":[{\"sourceColumn\":\"created_user_id\",\"targetTable\":\"#__users\",\"targetColumn\":\"id\",\"displayColumn\":\"name\"},{\"sourceColumn\":\"access\",\"targetTable\":\"#__viewlevels\",\"targetColumn\":\"id\",\"displayColumn\":\"title\"},{\"sourceColumn\":\"modified_user_id\",\"targetTable\":\"#__users\",\"targetColumn\":\"id\",\"displayColumn\":\"name\"},{\"sourceColumn\":\"parent_id\",\"targetTable\":\"#__categories\",\"targetColumn\":\"id\",\"displayColumn\":\"title\"}]}'),(8,'Newsfeeds Category','com_newsfeeds.category','{\"special\":{\"dbtable\":\"#__categories\",\"key\":\"id\",\"type\":\"Category\",\"prefix\":\"JTable\",\"config\":\"array()\"},\"common\":{\"dbtable\":\"#__ucm_content\",\"key\":\"ucm_id\",\"type\":\"Corecontent\",\"prefix\":\"JTable\",\"config\":\"array()\"}}','','{\"common\":{\"core_content_item_id\":\"id\",\"core_title\":\"title\",\"core_state\":\"published\",\"core_alias\":\"alias\",\"core_created_time\":\"created_time\",\"core_modified_time\":\"modified_time\",\"core_body\":\"description\", \"core_hits\":\"hits\",\"core_publish_up\":\"null\",\"core_publish_down\":\"null\",\"core_access\":\"access\", \"core_params\":\"params\", \"core_featured\":\"null\", \"core_metadata\":\"metadata\", \"core_language\":\"language\", \"core_images\":\"null\", \"core_urls\":\"null\", \"core_version\":\"version\", \"core_ordering\":\"null\", \"core_metakey\":\"metakey\", \"core_metadesc\":\"metadesc\", \"core_catid\":\"parent_id\", \"core_xreference\":\"null\", \"asset_id\":\"asset_id\"}, \"special\": {\"parent_id\":\"parent_id\",\"lft\":\"lft\",\"rgt\":\"rgt\",\"level\":\"level\",\"path\":\"path\",\"extension\":\"extension\",\"note\":\"note\"}}','NewsfeedsHelperRoute::getCategoryRoute','{\"formFile\":\"administrator\\/components\\/com_categories\\/models\\/forms\\/category.xml\", \"hideFields\":[\"asset_id\",\"checked_out\",\"checked_out_time\",\"version\",\"lft\",\"rgt\",\"level\",\"path\",\"extension\"], \"ignoreChanges\":[\"modified_user_id\", \"modified_time\", \"checked_out\", \"checked_out_time\", \"version\", \"hits\", \"path\"],\"convertToInt\":[\"publish_up\", \"publish_down\"], \"displayLookup\":[{\"sourceColumn\":\"created_user_id\",\"targetTable\":\"#__users\",\"targetColumn\":\"id\",\"displayColumn\":\"name\"},{\"sourceColumn\":\"access\",\"targetTable\":\"#__viewlevels\",\"targetColumn\":\"id\",\"displayColumn\":\"title\"},{\"sourceColumn\":\"modified_user_id\",\"targetTable\":\"#__users\",\"targetColumn\":\"id\",\"displayColumn\":\"name\"},{\"sourceColumn\":\"parent_id\",\"targetTable\":\"#__categories\",\"targetColumn\":\"id\",\"displayColumn\":\"title\"}]}'),(9,'Weblinks Category','com_weblinks.category','{\"special\":{\"dbtable\":\"#__categories\",\"key\":\"id\",\"type\":\"Category\",\"prefix\":\"JTable\",\"config\":\"array()\"},\"common\":{\"dbtable\":\"#__ucm_content\",\"key\":\"ucm_id\",\"type\":\"Corecontent\",\"prefix\":\"JTable\",\"config\":\"array()\"}}','','{\"common\":{\"core_content_item_id\":\"id\",\"core_title\":\"title\",\"core_state\":\"published\",\"core_alias\":\"alias\",\"core_created_time\":\"created_time\",\"core_modified_time\":\"modified_time\",\"core_body\":\"description\", \"core_hits\":\"hits\",\"core_publish_up\":\"null\",\"core_publish_down\":\"null\",\"core_access\":\"access\", \"core_params\":\"params\", \"core_featured\":\"null\", \"core_metadata\":\"metadata\", \"core_language\":\"language\", \"core_images\":\"null\", \"core_urls\":\"null\", \"core_version\":\"version\", \"core_ordering\":\"null\", \"core_metakey\":\"metakey\", \"core_metadesc\":\"metadesc\", \"core_catid\":\"parent_id\", \"core_xreference\":\"null\", \"asset_id\":\"asset_id\"}, \"special\": {\"parent_id\":\"parent_id\",\"lft\":\"lft\",\"rgt\":\"rgt\",\"level\":\"level\",\"path\":\"path\",\"extension\":\"extension\",\"note\":\"note\"}}','WeblinksHelperRoute::getCategoryRoute','{\"formFile\":\"administrator\\/components\\/com_categories\\/models\\/forms\\/category.xml\", \"hideFields\":[\"asset_id\",\"checked_out\",\"checked_out_time\",\"version\",\"lft\",\"rgt\",\"level\",\"path\",\"extension\"], \"ignoreChanges\":[\"modified_user_id\", \"modified_time\", \"checked_out\", \"checked_out_time\", \"version\", \"hits\", \"path\"],\"convertToInt\":[\"publish_up\", \"publish_down\"], \"displayLookup\":[{\"sourceColumn\":\"created_user_id\",\"targetTable\":\"#__users\",\"targetColumn\":\"id\",\"displayColumn\":\"name\"},{\"sourceColumn\":\"access\",\"targetTable\":\"#__viewlevels\",\"targetColumn\":\"id\",\"displayColumn\":\"title\"},{\"sourceColumn\":\"modified_user_id\",\"targetTable\":\"#__users\",\"targetColumn\":\"id\",\"displayColumn\":\"name\"},{\"sourceColumn\":\"parent_id\",\"targetTable\":\"#__categories\",\"targetColumn\":\"id\",\"displayColumn\":\"title\"}]}'),(10,'Tag','com_tags.tag','{\"special\":{\"dbtable\":\"#__tags\",\"key\":\"tag_id\",\"type\":\"Tag\",\"prefix\":\"TagsTable\",\"config\":\"array()\"},\"common\":{\"dbtable\":\"#__ucm_content\",\"key\":\"ucm_id\",\"type\":\"Corecontent\",\"prefix\":\"JTable\",\"config\":\"array()\"}}','','{\"common\":{\"core_content_item_id\":\"id\",\"core_title\":\"title\",\"core_state\":\"published\",\"core_alias\":\"alias\",\"core_created_time\":\"created_time\",\"core_modified_time\":\"modified_time\",\"core_body\":\"description\", \"core_hits\":\"hits\",\"core_publish_up\":\"null\",\"core_publish_down\":\"null\",\"core_access\":\"access\", \"core_params\":\"params\", \"core_featured\":\"featured\", \"core_metadata\":\"metadata\", \"core_language\":\"language\", \"core_images\":\"images\", \"core_urls\":\"urls\", \"core_version\":\"version\", \"core_ordering\":\"null\", \"core_metakey\":\"metakey\", \"core_metadesc\":\"metadesc\", \"core_catid\":\"null\", \"core_xreference\":\"null\", \"asset_id\":\"null\"}, \"special\": {\"parent_id\":\"parent_id\",\"lft\":\"lft\",\"rgt\":\"rgt\",\"level\":\"level\",\"path\":\"path\"}}','TagsHelperRoute::getTagRoute','{\"formFile\":\"administrator\\/components\\/com_tags\\/models\\/forms\\/tag.xml\", \"hideFields\":[\"checked_out\",\"checked_out_time\",\"version\", \"lft\", \"rgt\", \"level\", \"path\", \"urls\", \"publish_up\", \"publish_down\"],\"ignoreChanges\":[\"modified_user_id\", \"modified_time\", \"checked_out\", \"checked_out_time\", \"version\", \"hits\", \"path\"],\"convertToInt\":[\"publish_up\", \"publish_down\"], \"displayLookup\":[{\"sourceColumn\":\"created_user_id\",\"targetTable\":\"#__users\",\"targetColumn\":\"id\",\"displayColumn\":\"name\"}, {\"sourceColumn\":\"access\",\"targetTable\":\"#__viewlevels\",\"targetColumn\":\"id\",\"displayColumn\":\"title\"}, {\"sourceColumn\":\"modified_user_id\",\"targetTable\":\"#__users\",\"targetColumn\":\"id\",\"displayColumn\":\"name\"}]}'),(11,'Banner','com_banners.banner','{\"special\":{\"dbtable\":\"#__banners\",\"key\":\"id\",\"type\":\"Banner\",\"prefix\":\"BannersTable\",\"config\":\"array()\"},\"common\":{\"dbtable\":\"#__ucm_content\",\"key\":\"ucm_id\",\"type\":\"Corecontent\",\"prefix\":\"JTable\",\"config\":\"array()\"}}','','{\"common\":{\"core_content_item_id\":\"id\",\"core_title\":\"name\",\"core_state\":\"published\",\"core_alias\":\"alias\",\"core_created_time\":\"created\",\"core_modified_time\":\"modified\",\"core_body\":\"description\", \"core_hits\":\"null\",\"core_publish_up\":\"publish_up\",\"core_publish_down\":\"publish_down\",\"core_access\":\"access\", \"core_params\":\"params\", \"core_featured\":\"null\", \"core_metadata\":\"metadata\", \"core_language\":\"language\", \"core_images\":\"images\", \"core_urls\":\"link\", \"core_version\":\"version\", \"core_ordering\":\"ordering\", \"core_metakey\":\"metakey\", \"core_metadesc\":\"metadesc\", \"core_catid\":\"catid\", \"core_xreference\":\"null\", \"asset_id\":\"null\"}, \"special\":{\"imptotal\":\"imptotal\", \"impmade\":\"impmade\", \"clicks\":\"clicks\", \"clickurl\":\"clickurl\", \"custombannercode\":\"custombannercode\", \"cid\":\"cid\", \"purchase_type\":\"purchase_type\", \"track_impressions\":\"track_impressions\", \"track_clicks\":\"track_clicks\"}}','','{\"formFile\":\"administrator\\/components\\/com_banners\\/models\\/forms\\/banner.xml\", \"hideFields\":[\"checked_out\",\"checked_out_time\",\"version\", \"reset\"],\"ignoreChanges\":[\"modified_by\", \"modified\", \"checked_out\", \"checked_out_time\", \"version\", \"imptotal\", \"impmade\", \"reset\"], \"convertToInt\":[\"publish_up\", \"publish_down\", \"ordering\"], \"displayLookup\":[{\"sourceColumn\":\"catid\",\"targetTable\":\"#__categories\",\"targetColumn\":\"id\",\"displayColumn\":\"title\"}, {\"sourceColumn\":\"cid\",\"targetTable\":\"#__banner_clients\",\"targetColumn\":\"id\",\"displayColumn\":\"name\"}, {\"sourceColumn\":\"created_by\",\"targetTable\":\"#__users\",\"targetColumn\":\"id\",\"displayColumn\":\"name\"},{\"sourceColumn\":\"modified_by\",\"targetTable\":\"#__users\",\"targetColumn\":\"id\",\"displayColumn\":\"name\"}]}'),(12,'Banners Category','com_banners.category','{\"special\":{\"dbtable\":\"#__categories\",\"key\":\"id\",\"type\":\"Category\",\"prefix\":\"JTable\",\"config\":\"array()\"},\"common\":{\"dbtable\":\"#__ucm_content\",\"key\":\"ucm_id\",\"type\":\"Corecontent\",\"prefix\":\"JTable\",\"config\":\"array()\"}}','','{\"common\":{\"core_content_item_id\":\"id\",\"core_title\":\"title\",\"core_state\":\"published\",\"core_alias\":\"alias\",\"core_created_time\":\"created_time\",\"core_modified_time\":\"modified_time\",\"core_body\":\"description\", \"core_hits\":\"hits\",\"core_publish_up\":\"null\",\"core_publish_down\":\"null\",\"core_access\":\"access\", \"core_params\":\"params\", \"core_featured\":\"null\", \"core_metadata\":\"metadata\", \"core_language\":\"language\", \"core_images\":\"null\", \"core_urls\":\"null\", \"core_version\":\"version\", \"core_ordering\":\"null\", \"core_metakey\":\"metakey\", \"core_metadesc\":\"metadesc\", \"core_catid\":\"parent_id\", \"core_xreference\":\"null\", \"asset_id\":\"asset_id\"}, \"special\": {\"parent_id\":\"parent_id\",\"lft\":\"lft\",\"rgt\":\"rgt\",\"level\":\"level\",\"path\":\"path\",\"extension\":\"extension\",\"note\":\"note\"}}','','{\"formFile\":\"administrator\\/components\\/com_categories\\/models\\/forms\\/category.xml\", \"hideFields\":[\"asset_id\",\"checked_out\",\"checked_out_time\",\"version\",\"lft\",\"rgt\",\"level\",\"path\",\"extension\"], \"ignoreChanges\":[\"modified_user_id\", \"modified_time\", \"checked_out\", \"checked_out_time\", \"version\", \"hits\", \"path\"], \"convertToInt\":[\"publish_up\", \"publish_down\"], \"displayLookup\":[{\"sourceColumn\":\"created_user_id\",\"targetTable\":\"#__users\",\"targetColumn\":\"id\",\"displayColumn\":\"name\"},{\"sourceColumn\":\"access\",\"targetTable\":\"#__viewlevels\",\"targetColumn\":\"id\",\"displayColumn\":\"title\"},{\"sourceColumn\":\"modified_user_id\",\"targetTable\":\"#__users\",\"targetColumn\":\"id\",\"displayColumn\":\"name\"},{\"sourceColumn\":\"parent_id\",\"targetTable\":\"#__categories\",\"targetColumn\":\"id\",\"displayColumn\":\"title\"}]}'),(13,'Banner Client','com_banners.client','{\"special\":{\"dbtable\":\"#__banner_clients\",\"key\":\"id\",\"type\":\"Client\",\"prefix\":\"BannersTable\"}}','','','','{\"formFile\":\"administrator\\/components\\/com_banners\\/models\\/forms\\/client.xml\", \"hideFields\":[\"checked_out\",\"checked_out_time\"], \"ignoreChanges\":[\"checked_out\", \"checked_out_time\"], \"convertToInt\":[], \"displayLookup\":[]}'),(14,'User Notes','com_users.note','{\"special\":{\"dbtable\":\"#__user_notes\",\"key\":\"id\",\"type\":\"Note\",\"prefix\":\"UsersTable\"}}','','','','{\"formFile\":\"administrator\\/components\\/com_users\\/models\\/forms\\/note.xml\", \"hideFields\":[\"checked_out\",\"checked_out_time\", \"publish_up\", \"publish_down\"],\"ignoreChanges\":[\"modified_user_id\", \"modified_time\", \"checked_out\", \"checked_out_time\"], \"convertToInt\":[\"publish_up\", \"publish_down\"],\"displayLookup\":[{\"sourceColumn\":\"catid\",\"targetTable\":\"#__categories\",\"targetColumn\":\"id\",\"displayColumn\":\"title\"}, {\"sourceColumn\":\"created_user_id\",\"targetTable\":\"#__users\",\"targetColumn\":\"id\",\"displayColumn\":\"name\"}, {\"sourceColumn\":\"user_id\",\"targetTable\":\"#__users\",\"targetColumn\":\"id\",\"displayColumn\":\"name\"}, {\"sourceColumn\":\"modified_user_id\",\"targetTable\":\"#__users\",\"targetColumn\":\"id\",\"displayColumn\":\"name\"}]}'),(15,'User Notes Category','com_users.category','{\"special\":{\"dbtable\":\"#__categories\",\"key\":\"id\",\"type\":\"Category\",\"prefix\":\"JTable\",\"config\":\"array()\"},\"common\":{\"dbtable\":\"#__ucm_content\",\"key\":\"ucm_id\",\"type\":\"Corecontent\",\"prefix\":\"JTable\",\"config\":\"array()\"}}','','{\"common\":{\"core_content_item_id\":\"id\",\"core_title\":\"title\",\"core_state\":\"published\",\"core_alias\":\"alias\",\"core_created_time\":\"created_time\",\"core_modified_time\":\"modified_time\",\"core_body\":\"description\", \"core_hits\":\"hits\",\"core_publish_up\":\"null\",\"core_publish_down\":\"null\",\"core_access\":\"access\", \"core_params\":\"params\", \"core_featured\":\"null\", \"core_metadata\":\"metadata\", \"core_language\":\"language\", \"core_images\":\"null\", \"core_urls\":\"null\", \"core_version\":\"version\", \"core_ordering\":\"null\", \"core_metakey\":\"metakey\", \"core_metadesc\":\"metadesc\", \"core_catid\":\"parent_id\", \"core_xreference\":\"null\", \"asset_id\":\"asset_id\"}, \"special\":{\"parent_id\":\"parent_id\",\"lft\":\"lft\",\"rgt\":\"rgt\",\"level\":\"level\",\"path\":\"path\",\"extension\":\"extension\",\"note\":\"note\"}}','','{\"formFile\":\"administrator\\/components\\/com_categories\\/models\\/forms\\/category.xml\", \"hideFields\":[\"checked_out\",\"checked_out_time\",\"version\",\"lft\",\"rgt\",\"level\",\"path\",\"extension\"], \"ignoreChanges\":[\"modified_user_id\", \"modified_time\", \"checked_out\", \"checked_out_time\", \"version\", \"hits\", \"path\"], \"convertToInt\":[\"publish_up\", \"publish_down\"], \"displayLookup\":[{\"sourceColumn\":\"created_user_id\",\"targetTable\":\"#__users\",\"targetColumn\":\"id\",\"displayColumn\":\"name\"}, {\"sourceColumn\":\"access\",\"targetTable\":\"#__viewlevels\",\"targetColumn\":\"id\",\"displayColumn\":\"title\"},{\"sourceColumn\":\"modified_user_id\",\"targetTable\":\"#__users\",\"targetColumn\":\"id\",\"displayColumn\":\"name\"},{\"sourceColumn\":\"parent_id\",\"targetTable\":\"#__categories\",\"targetColumn\":\"id\",\"displayColumn\":\"title\"}]}');

--
-- Table structure for table `q43qy_contentitem_tag_map`
--

CREATE TABLE `q43qy_contentitem_tag_map` (
  `type_alias` varchar(255) NOT NULL DEFAULT '',
  `core_content_id` int(10) unsigned NOT NULL COMMENT 'PK from the core content table',
  `content_item_id` int(11) NOT NULL COMMENT 'PK from the content type table',
  `tag_id` int(10) unsigned NOT NULL COMMENT 'PK from the tag table',
  `tag_date` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'Date of most recent save for this tag-item',
  `type_id` mediumint(8) NOT NULL COMMENT 'PK from the content_type table',
  UNIQUE KEY `uc_ItemnameTagid` (`type_id`,`content_item_id`,`tag_id`),
  KEY `idx_tag_type` (`tag_id`,`type_id`),
  KEY `idx_date_id` (`tag_date`,`tag_id`),
  KEY `idx_tag` (`tag_id`),
  KEY `idx_type` (`type_id`),
  KEY `idx_core_content_id` (`core_content_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Maps items from content tables to tags';

--
-- Dumping data for table `q43qy_contentitem_tag_map`
--


--
-- Table structure for table `q43qy_core_log_searches`
--

CREATE TABLE `q43qy_core_log_searches` (
  `search_term` varchar(128) NOT NULL DEFAULT '',
  `hits` int(10) unsigned NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `q43qy_core_log_searches`
--


--
-- Table structure for table `q43qy_extensions`
--

CREATE TABLE `q43qy_extensions` (
  `extension_id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `type` varchar(20) NOT NULL,
  `element` varchar(100) NOT NULL,
  `folder` varchar(100) NOT NULL,
  `client_id` tinyint(3) NOT NULL,
  `enabled` tinyint(3) NOT NULL DEFAULT 1,
  `access` int(10) unsigned NOT NULL DEFAULT 1,
  `protected` tinyint(3) NOT NULL DEFAULT 0,
  `manifest_cache` text NOT NULL,
  `params` text NOT NULL,
  `custom_data` text NOT NULL,
  `system_data` text NOT NULL,
  `checked_out` int(10) unsigned NOT NULL DEFAULT 0,
  `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `ordering` int(11) DEFAULT 0,
  `state` int(11) DEFAULT 0,
  PRIMARY KEY (`extension_id`),
  KEY `element_clientid` (`element`,`client_id`),
  KEY `element_folder_clientid` (`element`,`folder`,`client_id`),
  KEY `extension` (`type`,`element`,`folder`,`client_id`)
) ENGINE=InnoDB AUTO_INCREMENT=10058 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `q43qy_extensions`
--

INSERT INTO `q43qy_extensions` (`extension_id`, `name`, `type`, `element`, `folder`, `client_id`, `enabled`, `access`, `protected`, `manifest_cache`, `params`, `custom_data`, `system_data`, `checked_out`, `checked_out_time`, `ordering`, `state`) VALUES (1,'com_mailto','component','com_mailto','',0,1,1,1,'{\"name\":\"com_mailto\",\"type\":\"component\",\"creationDate\":\"April 2006\",\"author\":\"Joomla! Project\",\"copyright\":\"(C) 2005 - 2014 Open Source Matters. All rights reserved.\\t\",\"authorEmail\":\"admin@joomla.org\",\"authorUrl\":\"www.joomla.org\",\"version\":\"3.0.0\",\"description\":\"COM_MAILTO_XML_DESCRIPTION\",\"group\":\"\"}','','','',0,'0000-00-00 00:00:00',0,0),(2,'com_wrapper','component','com_wrapper','',0,1,1,1,'{\"name\":\"com_wrapper\",\"type\":\"component\",\"creationDate\":\"April 2006\",\"author\":\"Joomla! Project\",\"copyright\":\"(C) 2005 - 2014 Open Source Matters. All rights reserved.\\n\\t\",\"authorEmail\":\"admin@joomla.org\",\"authorUrl\":\"www.joomla.org\",\"version\":\"3.0.0\",\"description\":\"COM_WRAPPER_XML_DESCRIPTION\",\"group\":\"\"}','','','',0,'0000-00-00 00:00:00',0,0),(3,'com_admin','component','com_admin','',1,1,1,1,'{\"name\":\"com_admin\",\"type\":\"component\",\"creationDate\":\"April 2006\",\"author\":\"Joomla! Project\",\"copyright\":\"(C) 2005 - 2014 Open Source Matters. All rights reserved.\\n\\t\",\"authorEmail\":\"admin@joomla.org\",\"authorUrl\":\"www.joomla.org\",\"version\":\"3.0.0\",\"description\":\"COM_ADMIN_XML_DESCRIPTION\",\"group\":\"\"}','','','',0,'0000-00-00 00:00:00',0,0),(4,'com_banners','component','com_banners','',1,1,1,0,'{\"name\":\"com_banners\",\"type\":\"component\",\"creationDate\":\"April 2006\",\"author\":\"Joomla! Project\",\"copyright\":\"(C) 2005 - 2014 Open Source Matters. All rights reserved.\\n\\t\",\"authorEmail\":\"admin@joomla.org\",\"authorUrl\":\"www.joomla.org\",\"version\":\"3.0.0\",\"description\":\"COM_BANNERS_XML_DESCRIPTION\",\"group\":\"\"}','{\"purchase_type\":\"3\",\"track_impressions\":\"0\",\"track_clicks\":\"0\",\"metakey_prefix\":\"\"}','','',0,'0000-00-00 00:00:00',0,0),(5,'com_cache','component','com_cache','',1,1,1,1,'{\"name\":\"com_cache\",\"type\":\"component\",\"creationDate\":\"April 2006\",\"author\":\"Joomla! Project\",\"copyright\":\"(C) 2005 - 2014 Open Source Matters. All rights reserved.\",\"authorEmail\":\"admin@joomla.org\",\"authorUrl\":\"www.joomla.org\",\"version\":\"3.0.0\",\"description\":\"COM_CACHE_XML_DESCRIPTION\",\"group\":\"\"}','','','',0,'0000-00-00 00:00:00',0,0),(6,'com_categories','component','com_categories','',1,1,1,1,'{\"name\":\"com_categories\",\"type\":\"component\",\"creationDate\":\"December 2007\",\"author\":\"Joomla! Project\",\"copyright\":\"(C) 2005 - 2014 Open Source Matters. All rights reserved.\",\"authorEmail\":\"admin@joomla.org\",\"authorUrl\":\"www.joomla.org\",\"version\":\"3.0.0\",\"description\":\"COM_CATEGORIES_XML_DESCRIPTION\",\"group\":\"\"}','','','',0,'0000-00-00 00:00:00',0,0),(7,'com_checkin','component','com_checkin','',1,1,1,1,'{\"name\":\"com_checkin\",\"type\":\"component\",\"creationDate\":\"Unknown\",\"author\":\"Joomla! Project\",\"copyright\":\"(C) 2005 - 2008 Open Source Matters. All rights reserved.\\n\\t\",\"authorEmail\":\"admin@joomla.org\",\"authorUrl\":\"www.joomla.org\",\"version\":\"3.0.0\",\"description\":\"COM_CHECKIN_XML_DESCRIPTION\",\"group\":\"\"}','','','',0,'0000-00-00 00:00:00',0,0),(8,'com_contact','component','com_contact','',1,1,1,0,'{\"name\":\"com_contact\",\"type\":\"component\",\"creationDate\":\"April 2006\",\"author\":\"Joomla! Project\",\"copyright\":\"(C) 2005 - 2014 Open Source Matters. All rights reserved.\\n\\t\",\"authorEmail\":\"admin@joomla.org\",\"authorUrl\":\"www.joomla.org\",\"version\":\"3.0.0\",\"description\":\"COM_CONTACT_XML_DESCRIPTION\",\"group\":\"\"}','{\"show_contact_category\":\"hide\",\"show_contact_list\":\"0\",\"presentation_style\":\"sliders\",\"show_name\":\"1\",\"show_position\":\"1\",\"show_email\":\"0\",\"show_street_address\":\"1\",\"show_suburb\":\"1\",\"show_state\":\"1\",\"show_postcode\":\"1\",\"show_country\":\"1\",\"show_telephone\":\"1\",\"show_mobile\":\"1\",\"show_fax\":\"1\",\"show_webpage\":\"1\",\"show_misc\":\"1\",\"show_image\":\"1\",\"image\":\"\",\"allow_vcard\":\"0\",\"show_articles\":\"0\",\"show_profile\":\"0\",\"show_links\":\"0\",\"linka_name\":\"\",\"linkb_name\":\"\",\"linkc_name\":\"\",\"linkd_name\":\"\",\"linke_name\":\"\",\"contact_icons\":\"0\",\"icon_address\":\"\",\"icon_email\":\"\",\"icon_telephone\":\"\",\"icon_mobile\":\"\",\"icon_fax\":\"\",\"icon_misc\":\"\",\"show_headings\":\"1\",\"show_position_headings\":\"1\",\"show_email_headings\":\"0\",\"show_telephone_headings\":\"1\",\"show_mobile_headings\":\"0\",\"show_fax_headings\":\"0\",\"allow_vcard_headings\":\"0\",\"show_suburb_headings\":\"1\",\"show_state_headings\":\"1\",\"show_country_headings\":\"1\",\"show_email_form\":\"1\",\"show_email_copy\":\"1\",\"banned_email\":\"\",\"banned_subject\":\"\",\"banned_text\":\"\",\"validate_session\":\"1\",\"custom_reply\":\"0\",\"redirect\":\"\",\"show_category_crumb\":\"0\",\"metakey\":\"\",\"metadesc\":\"\",\"robots\":\"\",\"author\":\"\",\"rights\":\"\",\"xreference\":\"\"}','','',0,'0000-00-00 00:00:00',0,0),(9,'com_cpanel','component','com_cpanel','',1,1,1,1,'{\"name\":\"com_cpanel\",\"type\":\"component\",\"creationDate\":\"April 2006\",\"author\":\"Joomla! Project\",\"copyright\":\"(C) 2005 - 2014 Open Source Matters. All rights reserved.\",\"authorEmail\":\"admin@joomla.org\",\"authorUrl\":\"www.joomla.org\",\"version\":\"3.0.0\",\"description\":\"COM_CPANEL_XML_DESCRIPTION\",\"group\":\"\"}','','','',0,'0000-00-00 00:00:00',0,0),(10,'com_installer','component','com_installer','',1,1,1,1,'{\"name\":\"com_installer\",\"type\":\"component\",\"creationDate\":\"April 2006\",\"author\":\"Joomla! Project\",\"copyright\":\"(C) 2005 - 2014 Open Source Matters. All rights reserved.\\t\",\"authorEmail\":\"admin@joomla.org\",\"authorUrl\":\"www.joomla.org\",\"version\":\"3.0.0\",\"description\":\"COM_INSTALLER_XML_DESCRIPTION\",\"group\":\"\"}','{}','','',0,'0000-00-00 00:00:00',0,0),(11,'com_languages','component','com_languages','',1,1,1,1,'{\"name\":\"com_languages\",\"type\":\"component\",\"creationDate\":\"2006\",\"author\":\"Joomla! Project\",\"copyright\":\"(C) 2005 - 2014 Open Source Matters. All rights reserved.\\n\\t\",\"authorEmail\":\"admin@joomla.org\",\"authorUrl\":\"www.joomla.org\",\"version\":\"3.0.0\",\"description\":\"COM_LANGUAGES_XML_DESCRIPTION\",\"group\":\"\"}','{\"administrator\":\"en-GB\",\"site\":\"en-GB\"}','','',0,'0000-00-00 00:00:00',0,0),(12,'com_login','component','com_login','',1,1,1,1,'{\"name\":\"com_login\",\"type\":\"component\",\"creationDate\":\"April 2006\",\"author\":\"Joomla! Project\",\"copyright\":\"(C) 2005 - 2014 Open Source Matters. All rights reserved.\\t\",\"authorEmail\":\"admin@joomla.org\",\"authorUrl\":\"www.joomla.org\",\"version\":\"3.0.0\",\"description\":\"COM_LOGIN_XML_DESCRIPTION\",\"group\":\"\"}','','','',0,'0000-00-00 00:00:00',0,0),(13,'com_media','component','com_media','',1,1,0,1,'{\"name\":\"com_media\",\"type\":\"component\",\"creationDate\":\"April 2006\",\"author\":\"Joomla! Project\",\"copyright\":\"(C) 2005 - 2014 Open Source Matters. All rights reserved.\\t\",\"authorEmail\":\"admin@joomla.org\",\"authorUrl\":\"www.joomla.org\",\"version\":\"3.0.0\",\"description\":\"COM_MEDIA_XML_DESCRIPTION\",\"group\":\"\"}','{\"upload_extensions\":\"bmp,csv,doc,gif,ico,jpg,jpeg,odg,odp,ods,odt,pdf,png,ppt,swf,txt,xcf,xls,BMP,CSV,DOC,GIF,ICO,JPG,JPEG,ODG,ODP,ODS,ODT,PDF,PNG,PPT,SWF,TXT,XCF,XLS\",\"upload_maxsize\":\"10\",\"file_path\":\"images\",\"image_path\":\"images\",\"restrict_uploads\":\"1\",\"allowed_media_usergroup\":\"3\",\"check_mime\":\"1\",\"image_extensions\":\"bmp,gif,jpg,png\",\"ignore_extensions\":\"\",\"upload_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\",\"upload_mime_illegal\":\"text\\/html\",\"enable_flash\":\"0\"}','','',0,'0000-00-00 00:00:00',0,0),(14,'com_menus','component','com_menus','',1,1,1,1,'{\"name\":\"com_menus\",\"type\":\"component\",\"creationDate\":\"April 2006\",\"author\":\"Joomla! Project\",\"copyright\":\"(C) 2005 - 2014 Open Source Matters. All rights reserved.\\t\",\"authorEmail\":\"admin@joomla.org\",\"authorUrl\":\"www.joomla.org\",\"version\":\"3.0.0\",\"description\":\"COM_MENUS_XML_DESCRIPTION\",\"group\":\"\"}','{}','','',0,'0000-00-00 00:00:00',0,0),(15,'com_messages','component','com_messages','',1,1,1,1,'{\"name\":\"com_messages\",\"type\":\"component\",\"creationDate\":\"April 2006\",\"author\":\"Joomla! Project\",\"copyright\":\"(C) 2005 - 2014 Open Source Matters. All rights reserved.\\t\",\"authorEmail\":\"admin@joomla.org\",\"authorUrl\":\"www.joomla.org\",\"version\":\"3.0.0\",\"description\":\"COM_MESSAGES_XML_DESCRIPTION\",\"group\":\"\"}','','','',0,'0000-00-00 00:00:00',0,0),(16,'com_modules','component','com_modules','',1,1,1,1,'{\"name\":\"com_modules\",\"type\":\"component\",\"creationDate\":\"April 2006\",\"author\":\"Joomla! Project\",\"copyright\":\"(C) 2005 - 2014 Open Source Matters. All rights reserved.\\t\",\"authorEmail\":\"admin@joomla.org\",\"authorUrl\":\"www.joomla.org\",\"version\":\"3.0.0\",\"description\":\"COM_MODULES_XML_DESCRIPTION\",\"group\":\"\"}','{}','','',0,'0000-00-00 00:00:00',0,0),(17,'com_newsfeeds','component','com_newsfeeds','',1,1,1,0,'{\"name\":\"com_newsfeeds\",\"type\":\"component\",\"creationDate\":\"April 2006\",\"author\":\"Joomla! Project\",\"copyright\":\"(C) 2005 - 2014 Open Source Matters. All rights reserved.\\t\",\"authorEmail\":\"admin@joomla.org\",\"authorUrl\":\"www.joomla.org\",\"version\":\"3.0.0\",\"description\":\"COM_NEWSFEEDS_XML_DESCRIPTION\",\"group\":\"\"}','{\"show_feed_image\":\"1\",\"show_feed_description\":\"1\",\"show_item_description\":\"1\",\"feed_word_count\":\"0\",\"show_headings\":\"1\",\"show_name\":\"1\",\"show_articles\":\"0\",\"show_link\":\"1\",\"show_description\":\"1\",\"show_description_image\":\"1\",\"display_num\":\"\",\"show_pagination_limit\":\"1\",\"show_pagination\":\"1\",\"show_pagination_results\":\"1\",\"show_cat_items\":\"1\"}','','',0,'0000-00-00 00:00:00',0,0),(18,'com_plugins','component','com_plugins','',1,1,1,1,'{\"name\":\"com_plugins\",\"type\":\"component\",\"creationDate\":\"April 2006\",\"author\":\"Joomla! Project\",\"copyright\":\"(C) 2005 - 2014 Open Source Matters. All rights reserved.\\t\",\"authorEmail\":\"admin@joomla.org\",\"authorUrl\":\"www.joomla.org\",\"version\":\"3.0.0\",\"description\":\"COM_PLUGINS_XML_DESCRIPTION\",\"group\":\"\"}','{}','','',0,'0000-00-00 00:00:00',0,0),(19,'com_search','component','com_search','',1,1,1,0,'{\"name\":\"com_search\",\"type\":\"component\",\"creationDate\":\"April 2006\",\"author\":\"Joomla! Project\",\"copyright\":\"(C) 2005 - 2014 Open Source Matters. All rights reserved.\\n\\t\",\"authorEmail\":\"admin@joomla.org\",\"authorUrl\":\"www.joomla.org\",\"version\":\"3.0.0\",\"description\":\"COM_SEARCH_XML_DESCRIPTION\",\"group\":\"\"}','{\"enabled\":\"0\",\"show_date\":\"1\"}','','',0,'0000-00-00 00:00:00',0,0),(20,'com_templates','component','com_templates','',1,1,1,1,'{\"name\":\"com_templates\",\"type\":\"component\",\"creationDate\":\"April 2006\",\"author\":\"Joomla! Project\",\"copyright\":\"(C) 2005 - 2014 Open Source Matters. All rights reserved.\\t\",\"authorEmail\":\"admin@joomla.org\",\"authorUrl\":\"www.joomla.org\",\"version\":\"3.0.0\",\"description\":\"COM_TEMPLATES_XML_DESCRIPTION\",\"group\":\"\"}','{\"template_positions_display\":\"1\",\"upload_limit\":\"2\",\"image_formats\":\"gif,bmp,jpg,jpeg,png\",\"source_formats\":\"txt,less,ini,xml,js,php,css\",\"font_formats\":\"woff,ttf,otf\",\"compressed_formats\":\"zip\"}','','',0,'0000-00-00 00:00:00',0,0),(21,'com_weblinks','component','com_weblinks','',1,1,1,0,'{\"name\":\"com_weblinks\",\"type\":\"component\",\"creationDate\":\"April 2006\",\"author\":\"Joomla! Project\",\"copyright\":\"(C) 2005 - 2014 Open Source Matters. All rights reserved.\\n\\t\",\"authorEmail\":\"admin@joomla.org\",\"authorUrl\":\"www.joomla.org\",\"version\":\"3.0.0\",\"description\":\"COM_WEBLINKS_XML_DESCRIPTION\",\"group\":\"\"}','{\"show_comp_description\":\"1\",\"comp_description\":\"\",\"show_link_hits\":\"1\",\"show_link_description\":\"1\",\"show_other_cats\":\"0\",\"show_headings\":\"0\",\"show_numbers\":\"0\",\"show_report\":\"1\",\"count_clicks\":\"1\",\"target\":\"0\",\"link_icons\":\"\"}','','',0,'0000-00-00 00:00:00',0,0),(22,'com_content','component','com_content','',1,1,0,1,'{\"name\":\"com_content\",\"type\":\"component\",\"creationDate\":\"April 2006\",\"author\":\"Joomla! Project\",\"copyright\":\"(C) 2005 - 2014 Open Source Matters. All rights reserved.\\t\",\"authorEmail\":\"admin@joomla.org\",\"authorUrl\":\"www.joomla.org\",\"version\":\"3.0.0\",\"description\":\"COM_CONTENT_XML_DESCRIPTION\",\"group\":\"\"}','{\"article_layout\":\"_:default\",\"show_title\":\"1\",\"link_titles\":\"1\",\"show_intro\":\"1\",\"info_block_position\":\"0\",\"show_category\":\"0\",\"link_category\":\"0\",\"show_parent_category\":\"0\",\"link_parent_category\":\"0\",\"show_author\":\"0\",\"link_author\":\"0\",\"show_create_date\":\"0\",\"show_modify_date\":\"0\",\"show_publish_date\":\"0\",\"show_item_navigation\":\"0\",\"show_vote\":\"0\",\"show_readmore\":\"1\",\"show_readmore_title\":\"1\",\"readmore_limit\":\"100\",\"show_tags\":\"1\",\"show_icons\":\"0\",\"show_print_icon\":\"0\",\"show_email_icon\":\"0\",\"show_hits\":\"0\",\"show_noauth\":\"0\",\"urls_position\":\"0\",\"show_publishing_options\":\"1\",\"show_article_options\":\"1\",\"save_history\":\"0\",\"history_limit\":10,\"show_urls_images_frontend\":\"0\",\"show_urls_images_backend\":\"1\",\"targeta\":0,\"targetb\":0,\"targetc\":0,\"float_intro\":\"right\",\"float_fulltext\":\"right\",\"category_layout\":\"_:blog\",\"show_category_heading_title_text\":\"1\",\"show_category_title\":\"0\",\"show_description\":\"0\",\"show_description_image\":\"0\",\"maxLevel\":\"1\",\"show_empty_categories\":\"0\",\"show_no_articles\":\"1\",\"show_subcat_desc\":\"1\",\"show_cat_num_articles\":\"0\",\"show_cat_tags\":\"1\",\"show_base_description\":\"1\",\"maxLevelcat\":\"-1\",\"show_empty_categories_cat\":\"0\",\"show_subcat_desc_cat\":\"1\",\"show_cat_num_articles_cat\":\"1\",\"num_leading_articles\":\"1\",\"num_intro_articles\":\"4\",\"num_columns\":\"2\",\"num_links\":\"4\",\"multi_column_order\":\"0\",\"show_subcategory_content\":\"0\",\"show_pagination_limit\":\"1\",\"filter_field\":\"hide\",\"show_headings\":\"1\",\"list_show_date\":\"0\",\"date_format\":\"\",\"list_show_hits\":\"1\",\"list_show_author\":\"1\",\"orderby_pri\":\"order\",\"orderby_sec\":\"rdate\",\"order_date\":\"published\",\"show_pagination\":\"2\",\"show_pagination_results\":\"1\",\"show_feed_link\":\"1\",\"feed_summary\":\"0\",\"feed_show_readmore\":\"0\"}','','',0,'0000-00-00 00:00:00',0,0),(23,'com_config','component','com_config','',1,1,0,1,'{\"name\":\"com_config\",\"type\":\"component\",\"creationDate\":\"April 2006\",\"author\":\"Joomla! Project\",\"copyright\":\"(C) 2005 - 2014 Open Source Matters. All rights reserved.\",\"authorEmail\":\"admin@joomla.org\",\"authorUrl\":\"www.joomla.org\",\"version\":\"3.0.0\",\"description\":\"COM_CONFIG_XML_DESCRIPTION\",\"group\":\"\"}','{\"filters\":{\"1\":{\"filter_type\":\"NH\",\"filter_tags\":\"\",\"filter_attributes\":\"\"},\"6\":{\"filter_type\":\"BL\",\"filter_tags\":\"\",\"filter_attributes\":\"\"},\"7\":{\"filter_type\":\"BL\",\"filter_tags\":\"\",\"filter_attributes\":\"\"},\"2\":{\"filter_type\":\"NH\",\"filter_tags\":\"\",\"filter_attributes\":\"\"},\"3\":{\"filter_type\":\"BL\",\"filter_tags\":\"\",\"filter_attributes\":\"\"},\"4\":{\"filter_type\":\"BL\",\"filter_tags\":\"\",\"filter_attributes\":\"\"},\"5\":{\"filter_type\":\"BL\",\"filter_tags\":\"\",\"filter_attributes\":\"\"},\"8\":{\"filter_type\":\"NONE\",\"filter_tags\":\"\",\"filter_attributes\":\"\"}}}','','',0,'0000-00-00 00:00:00',0,0),(24,'com_redirect','component','com_redirect','',1,1,0,1,'{\"name\":\"com_redirect\",\"type\":\"component\",\"creationDate\":\"April 2006\",\"author\":\"Joomla! Project\",\"copyright\":\"(C) 2005 - 2014 Open Source Matters. All rights reserved.\\t\",\"authorEmail\":\"admin@joomla.org\",\"authorUrl\":\"www.joomla.org\",\"version\":\"3.0.0\",\"description\":\"COM_REDIRECT_XML_DESCRIPTION\",\"group\":\"\"}','{}','','',0,'0000-00-00 00:00:00',0,0),(25,'com_users','component','com_users','',1,1,0,1,'{\"name\":\"com_users\",\"type\":\"component\",\"creationDate\":\"April 2006\",\"author\":\"Joomla! Project\",\"copyright\":\"(C) 2005 - 2014 Open Source Matters. All rights reserved.\\t\",\"authorEmail\":\"admin@joomla.org\",\"authorUrl\":\"www.joomla.org\",\"version\":\"3.0.0\",\"description\":\"COM_USERS_XML_DESCRIPTION\",\"group\":\"\"}','{\"allowUserRegistration\":\"0\",\"new_usertype\":\"2\",\"guest_usergroup\":\"1\",\"useractivation\":\"1\",\"frontend_userparams\":\"1\",\"site_language\":\"0\",\"mailSubjectPrefix\":\"\",\"mailBodySuffix\":\"\"}','','',0,'0000-00-00 00:00:00',0,0),(27,'com_finder','component','com_finder','',1,1,0,0,'','{\"show_description\":\"1\",\"description_length\":255,\"allow_empty_query\":\"0\",\"show_url\":\"1\",\"show_advanced\":\"1\",\"expand_advanced\":\"0\",\"show_date_filters\":\"0\",\"highlight_terms\":\"1\",\"opensearch_name\":\"\",\"opensearch_description\":\"\",\"batch_size\":\"50\",\"memory_table_limit\":30000,\"title_multiplier\":\"1.7\",\"text_multiplier\":\"0.7\",\"meta_multiplier\":\"1.2\",\"path_multiplier\":\"2.0\",\"misc_multiplier\":\"0.3\",\"stemmer\":\"porter_en\"}','','',0,'0000-00-00 00:00:00',0,0),(28,'com_joomlaupdate','component','com_joomlaupdate','',1,1,0,1,'{\"legacy\":false,\"name\":\"com_joomlaupdate\",\"type\":\"component\",\"creationDate\":\"February 2012\",\"author\":\"Joomla! Project\",\"copyright\":\"(C) 2005 - 2012 Open Source Matters. All rights reserved.\",\"authorEmail\":\"admin@joomla.org\",\"authorUrl\":\"www.joomla.org\",\"version\":\"2.5.2\",\"description\":\"COM_JOOMLAUPDATE_XML_DESCRIPTION\",\"group\":\"\"}','{\"updatesource\":\"sts\",\"customurl\":\"\"}','','',0,'0000-00-00 00:00:00',0,0),(29,'com_tags','component','com_tags','',1,1,1,1,'{\"name\":\"com_tags\",\"type\":\"component\",\"creationDate\":\"December 2013\",\"author\":\"Joomla! Project\",\"copyright\":\"(C) 2005 - 2014 Open Source Matters. All rights reserved.\",\"authorEmail\":\"admin@joomla.org\",\"authorUrl\":\"www.joomla.org\",\"version\":\"3.1.0\",\"description\":\"COM_TAGS_XML_DESCRIPTION\",\"group\":\"\"}','{}','','',0,'0000-00-00 00:00:00',0,0),(30,'com_contenthistory','component','com_contenthistory','',1,1,1,0,'{\"name\":\"com_contenthistory\",\"type\":\"component\",\"creationDate\":\"May 2013\",\"author\":\"Joomla! Project\",\"copyright\":\"(C) 2005 - 2014 Open Source Matters. All rights reserved.\",\"authorEmail\":\"admin@joomla.org\",\"authorUrl\":\"www.joomla.org\",\"version\":\"3.2.0\",\"description\":\"COM_CONTENTHISTORY_XML_DESCRIPTION\",\"group\":\"\"}','{}','','',0,'0000-00-00 00:00:00',0,0),(31,'com_ajax','component','com_ajax','',1,1,1,0,'{\"name\":\"com_ajax\",\"type\":\"component\",\"creationDate\":\"August 2013\",\"author\":\"Joomla! Project\",\"copyright\":\"(C) 2005 - 2014 Open Source Matters. All rights reserved.\",\"authorEmail\":\"admin@joomla.org\",\"authorUrl\":\"www.joomla.org\",\"version\":\"3.2.0\",\"description\":\"COM_AJAX_XML_DESCRIPTION\",\"group\":\"\"}','{}','','',0,'0000-00-00 00:00:00',0,0),(32,'com_postinstall','component','com_postinstall','',1,1,1,1,'{\"name\":\"com_postinstall\",\"type\":\"component\",\"creationDate\":\"September 2013\",\"author\":\"Joomla! Project\",\"copyright\":\"(C) 2005 - 2014 Open Source Matters. All rights reserved.\",\"authorEmail\":\"admin@joomla.org\",\"authorUrl\":\"www.joomla.org\",\"version\":\"3.2.0\",\"description\":\"COM_POSTINSTALL_XML_DESCRIPTION\",\"group\":\"\"}','','','',0,'0000-00-00 00:00:00',0,0),(100,'PHPMailer','library','phpmailer','',0,1,1,1,'{\"name\":\"PHPMailer\",\"type\":\"library\",\"creationDate\":\"2001\",\"author\":\"PHPMailer\",\"copyright\":\"(c) 2001-2003, Brent R. Matzelle, (c) 2004-2009, Andy Prevost. All Rights Reserved., (c) 2010-2013, Jim Jagielski. All Rights Reserved.\",\"authorEmail\":\"jimjag@gmail.com\",\"authorUrl\":\"https:\\/\\/github.com\\/PHPMailer\\/PHPMailer\",\"version\":\"5.2.6\",\"description\":\"LIB_PHPMAILER_XML_DESCRIPTION\",\"group\":\"\"}','','','',0,'0000-00-00 00:00:00',0,0),(101,'SimplePie','library','simplepie','',0,1,1,1,'{\"name\":\"SimplePie\",\"type\":\"library\",\"creationDate\":\"2004\",\"author\":\"SimplePie\",\"copyright\":\"Copyright (c) 2004-2009, Ryan Parman and Geoffrey Sneddon\",\"authorEmail\":\"\",\"authorUrl\":\"http:\\/\\/simplepie.org\\/\",\"version\":\"1.2\",\"description\":\"LIB_SIMPLEPIE_XML_DESCRIPTION\",\"group\":\"\"}','','','',0,'0000-00-00 00:00:00',0,0),(102,'phputf8','library','phputf8','',0,1,1,1,'{\"name\":\"phputf8\",\"type\":\"library\",\"creationDate\":\"2006\",\"author\":\"Harry Fuecks\",\"copyright\":\"Copyright various authors\",\"authorEmail\":\"hfuecks@gmail.com\",\"authorUrl\":\"http:\\/\\/sourceforge.net\\/projects\\/phputf8\",\"version\":\"0.5\",\"description\":\"LIB_PHPUTF8_XML_DESCRIPTION\",\"group\":\"\"}','','','',0,'0000-00-00 00:00:00',0,0),(103,'Joomla! Platform','library','joomla','',0,1,1,1,'{\"name\":\"Joomla! Platform\",\"type\":\"library\",\"creationDate\":\"2008\",\"author\":\"Joomla! Project\",\"copyright\":\"Copyright (C) 2005 - 2014 Open Source Matters. All rights reserved.\",\"authorEmail\":\"admin@joomla.org\",\"authorUrl\":\"http:\\/\\/www.joomla.org\",\"version\":\"13.1\",\"description\":\"LIB_JOOMLA_XML_DESCRIPTION\",\"group\":\"\"}','{\"mediaversion\":\"b6bc10cd917ade3aa59cc07078a0e203\"}','','',0,'0000-00-00 00:00:00',0,0),(104,'IDNA Convert','library','idna_convert','',0,1,1,1,'{\"name\":\"IDNA Convert\",\"type\":\"library\",\"creationDate\":\"2004\",\"author\":\"phlyLabs\",\"copyright\":\"2004-2011 phlyLabs Berlin, http:\\/\\/phlylabs.de\",\"authorEmail\":\"phlymail@phlylabs.de\",\"authorUrl\":\"http:\\/\\/phlylabs.de\",\"version\":\"0.8.0\",\"description\":\"LIB_IDNA_XML_DESCRIPTION\",\"group\":\"\"}','','','',0,'0000-00-00 00:00:00',0,0),(105,'FOF','library','fof','',0,1,1,1,'{\"name\":\"FOF\",\"type\":\"library\",\"creationDate\":\"2014-03-09 12:54:48\",\"author\":\"Nicholas K. Dionysopoulos \\/ Akeeba Ltd\",\"copyright\":\"(C)2011-2014 Nicholas K. Dionysopoulos\",\"authorEmail\":\"nicholas@akeebabackup.com\",\"authorUrl\":\"https:\\/\\/www.akeebabackup.com\",\"version\":\"2.2.1\",\"description\":\"LIB_FOF_XML_DESCRIPTION\",\"group\":\"\"}','{}','','',0,'0000-00-00 00:00:00',0,0),(106,'PHPass','library','phpass','',0,1,1,1,'{\"name\":\"PHPass\",\"type\":\"library\",\"creationDate\":\"2004-2006\",\"author\":\"Solar Designer\",\"copyright\":\"\",\"authorEmail\":\"solar@openwall.com\",\"authorUrl\":\"http:\\/\\/www.openwall.com\\/phpass\\/\",\"version\":\"0.3\",\"description\":\"LIB_PHPASS_XML_DESCRIPTION\",\"group\":\"\"}','{}','','',0,'0000-00-00 00:00:00',0,0),(200,'mod_articles_archive','module','mod_articles_archive','',0,1,1,0,'{\"name\":\"mod_articles_archive\",\"type\":\"module\",\"creationDate\":\"July 2006\",\"author\":\"Joomla! Project\",\"copyright\":\"Copyright (C) 2005 - 2014 Open Source Matters. All rights reserved.\",\"authorEmail\":\"admin@joomla.org\",\"authorUrl\":\"www.joomla.org\",\"version\":\"3.0.0\",\"description\":\"MOD_ARTICLES_ARCHIVE_XML_DESCRIPTION\",\"group\":\"\"}','','','',0,'0000-00-00 00:00:00',0,0),(201,'mod_articles_latest','module','mod_articles_latest','',0,1,1,0,'{\"name\":\"mod_articles_latest\",\"type\":\"module\",\"creationDate\":\"July 2004\",\"author\":\"Joomla! Project\",\"copyright\":\"Copyright (C) 2005 - 2014 Open Source Matters. All rights reserved.\",\"authorEmail\":\"admin@joomla.org\",\"authorUrl\":\"www.joomla.org\",\"version\":\"3.0.0\",\"description\":\"MOD_LATEST_NEWS_XML_DESCRIPTION\",\"group\":\"\"}','','','',0,'0000-00-00 00:00:00',0,0),(202,'mod_articles_popular','module','mod_articles_popular','',0,1,1,0,'{\"name\":\"mod_articles_popular\",\"type\":\"module\",\"creationDate\":\"July 2006\",\"author\":\"Joomla! Project\",\"copyright\":\"Copyright (C) 2005 - 2014 Open Source Matters. All rights reserved.\",\"authorEmail\":\"admin@joomla.org\",\"authorUrl\":\"www.joomla.org\",\"version\":\"3.0.0\",\"description\":\"MOD_POPULAR_XML_DESCRIPTION\",\"group\":\"\"}','','','',0,'0000-00-00 00:00:00',0,0),(203,'mod_banners','module','mod_banners','',0,1,1,0,'{\"name\":\"mod_banners\",\"type\":\"module\",\"creationDate\":\"July 2006\",\"author\":\"Joomla! Project\",\"copyright\":\"Copyright (C) 2005 - 2014 Open Source Matters. All rights reserved.\",\"authorEmail\":\"admin@joomla.org\",\"authorUrl\":\"www.joomla.org\",\"version\":\"3.0.0\",\"description\":\"MOD_BANNERS_XML_DESCRIPTION\",\"group\":\"\"}','','','',0,'0000-00-00 00:00:00',0,0),(204,'mod_breadcrumbs','module','mod_breadcrumbs','',0,1,1,1,'{\"name\":\"mod_breadcrumbs\",\"type\":\"module\",\"creationDate\":\"July 2006\",\"author\":\"Joomla! Project\",\"copyright\":\"Copyright (C) 2005 - 2014 Open Source Matters. All rights reserved.\",\"authorEmail\":\"admin@joomla.org\",\"authorUrl\":\"www.joomla.org\",\"version\":\"3.0.0\",\"description\":\"MOD_BREADCRUMBS_XML_DESCRIPTION\",\"group\":\"\"}','','','',0,'0000-00-00 00:00:00',0,0),(205,'mod_custom','module','mod_custom','',0,1,1,1,'{\"name\":\"mod_custom\",\"type\":\"module\",\"creationDate\":\"July 2004\",\"author\":\"Joomla! Project\",\"copyright\":\"Copyright (C) 2005 - 2014 Open Source Matters. All rights reserved.\",\"authorEmail\":\"admin@joomla.org\",\"authorUrl\":\"www.joomla.org\",\"version\":\"3.0.0\",\"description\":\"MOD_CUSTOM_XML_DESCRIPTION\",\"group\":\"\"}','','','',0,'0000-00-00 00:00:00',0,0),(206,'mod_feed','module','mod_feed','',0,1,1,0,'{\"name\":\"mod_feed\",\"type\":\"module\",\"creationDate\":\"July 2005\",\"author\":\"Joomla! Project\",\"copyright\":\"Copyright (C) 2005 - 2014 Open Source Matters. All rights reserved.\",\"authorEmail\":\"admin@joomla.org\",\"authorUrl\":\"www.joomla.org\",\"version\":\"3.0.0\",\"description\":\"MOD_FEED_XML_DESCRIPTION\",\"group\":\"\"}','','','',0,'0000-00-00 00:00:00',0,0),(207,'mod_footer','module','mod_footer','',0,1,1,0,'{\"name\":\"mod_footer\",\"type\":\"module\",\"creationDate\":\"July 2006\",\"author\":\"Joomla! Project\",\"copyright\":\"Copyright (C) 2005 - 2014 Open Source Matters. All rights reserved.\",\"authorEmail\":\"admin@joomla.org\",\"authorUrl\":\"www.joomla.org\",\"version\":\"3.0.0\",\"description\":\"MOD_FOOTER_XML_DESCRIPTION\",\"group\":\"\"}','','','',0,'0000-00-00 00:00:00',0,0),(208,'mod_login','module','mod_login','',0,1,1,1,'{\"name\":\"mod_login\",\"type\":\"module\",\"creationDate\":\"July 2006\",\"author\":\"Joomla! Project\",\"copyright\":\"Copyright (C) 2005 - 2014 Open Source Matters. All rights reserved.\",\"authorEmail\":\"admin@joomla.org\",\"authorUrl\":\"www.joomla.org\",\"version\":\"3.0.0\",\"description\":\"MOD_LOGIN_XML_DESCRIPTION\",\"group\":\"\"}','','','',0,'0000-00-00 00:00:00',0,0),(209,'mod_menu','module','mod_menu','',0,1,1,1,'{\"name\":\"mod_menu\",\"type\":\"module\",\"creationDate\":\"July 2004\",\"author\":\"Joomla! Project\",\"copyright\":\"Copyright (C) 2005 - 2014 Open Source Matters. All rights reserved.\",\"authorEmail\":\"admin@joomla.org\",\"authorUrl\":\"www.joomla.org\",\"version\":\"3.0.0\",\"description\":\"MOD_MENU_XML_DESCRIPTION\",\"group\":\"\"}','','','',0,'0000-00-00 00:00:00',0,0),(210,'mod_articles_news','module','mod_articles_news','',0,1,1,0,'{\"name\":\"mod_articles_news\",\"type\":\"module\",\"creationDate\":\"July 2006\",\"author\":\"Joomla! Project\",\"copyright\":\"Copyright (C) 2005 - 2014 Open Source Matters. All rights reserved.\",\"authorEmail\":\"admin@joomla.org\",\"authorUrl\":\"www.joomla.org\",\"version\":\"3.0.0\",\"description\":\"MOD_ARTICLES_NEWS_XML_DESCRIPTION\",\"group\":\"\"}','','','',0,'0000-00-00 00:00:00',0,0),(211,'mod_random_image','module','mod_random_image','',0,1,1,0,'{\"name\":\"mod_random_image\",\"type\":\"module\",\"creationDate\":\"July 2006\",\"author\":\"Joomla! Project\",\"copyright\":\"Copyright (C) 2005 - 2014 Open Source Matters. All rights reserved.\",\"authorEmail\":\"admin@joomla.org\",\"authorUrl\":\"www.joomla.org\",\"version\":\"3.0.0\",\"description\":\"MOD_RANDOM_IMAGE_XML_DESCRIPTION\",\"group\":\"\"}','','','',0,'0000-00-00 00:00:00',0,0),(212,'mod_related_items','module','mod_related_items','',0,1,1,0,'{\"name\":\"mod_related_items\",\"type\":\"module\",\"creationDate\":\"July 2004\",\"author\":\"Joomla! Project\",\"copyright\":\"Copyright (C) 2005 - 2014 Open Source Matters. All rights reserved.\",\"authorEmail\":\"admin@joomla.org\",\"authorUrl\":\"www.joomla.org\",\"version\":\"3.0.0\",\"description\":\"MOD_RELATED_XML_DESCRIPTION\",\"group\":\"\"}','','','',0,'0000-00-00 00:00:00',0,0),(213,'mod_search','module','mod_search','',0,1,1,0,'{\"name\":\"mod_search\",\"type\":\"module\",\"creationDate\":\"July 2004\",\"author\":\"Joomla! Project\",\"copyright\":\"Copyright (C) 2005 - 2014 Open Source Matters. All rights reserved.\",\"authorEmail\":\"admin@joomla.org\",\"authorUrl\":\"www.joomla.org\",\"version\":\"3.0.0\",\"description\":\"MOD_SEARCH_XML_DESCRIPTION\",\"group\":\"\"}','','','',0,'0000-00-00 00:00:00',0,0),(214,'mod_stats','module','mod_stats','',0,1,1,0,'{\"name\":\"mod_stats\",\"type\":\"module\",\"creationDate\":\"July 2004\",\"author\":\"Joomla! Project\",\"copyright\":\"Copyright (C) 2005 - 2014 Open Source Matters. All rights reserved.\",\"authorEmail\":\"admin@joomla.org\",\"authorUrl\":\"www.joomla.org\",\"version\":\"3.0.0\",\"description\":\"MOD_STATS_XML_DESCRIPTION\",\"group\":\"\"}','','','',0,'0000-00-00 00:00:00',0,0),(215,'mod_syndicate','module','mod_syndicate','',0,1,1,1,'{\"name\":\"mod_syndicate\",\"type\":\"module\",\"creationDate\":\"May 2006\",\"author\":\"Joomla! Project\",\"copyright\":\"Copyright (C) 2005 - 2014 Open Source Matters. All rights reserved.\",\"authorEmail\":\"admin@joomla.org\",\"authorUrl\":\"www.joomla.org\",\"version\":\"3.0.0\",\"description\":\"MOD_SYNDICATE_XML_DESCRIPTION\",\"group\":\"\"}','','','',0,'0000-00-00 00:00:00',0,0),(216,'mod_users_latest','module','mod_users_latest','',0,1,1,0,'{\"name\":\"mod_users_latest\",\"type\":\"module\",\"creationDate\":\"December 2009\",\"author\":\"Joomla! Project\",\"copyright\":\"Copyright (C) 2005 - 2014 Open Source Matters. All rights reserved.\",\"authorEmail\":\"admin@joomla.org\",\"authorUrl\":\"www.joomla.org\",\"version\":\"3.0.0\",\"description\":\"MOD_USERS_LATEST_XML_DESCRIPTION\",\"group\":\"\"}','','','',0,'0000-00-00 00:00:00',0,0),(217,'mod_weblinks','module','mod_weblinks','',0,1,1,0,'{\"name\":\"mod_weblinks\",\"type\":\"module\",\"creationDate\":\"July 2009\",\"author\":\"Joomla! Project\",\"copyright\":\"Copyright (C) 2005 - 2014 Open Source Matters. All rights reserved.\",\"authorEmail\":\"admin@joomla.org\",\"authorUrl\":\"www.joomla.org\",\"version\":\"3.0.0\",\"description\":\"MOD_WEBLINKS_XML_DESCRIPTION\",\"group\":\"\"}','','','',0,'0000-00-00 00:00:00',0,0),(218,'mod_whosonline','module','mod_whosonline','',0,1,1,0,'{\"name\":\"mod_whosonline\",\"type\":\"module\",\"creationDate\":\"July 2004\",\"author\":\"Joomla! Project\",\"copyright\":\"Copyright (C) 2005 - 2014 Open Source Matters. All rights reserved.\",\"authorEmail\":\"admin@joomla.org\",\"authorUrl\":\"www.joomla.org\",\"version\":\"3.0.0\",\"description\":\"MOD_WHOSONLINE_XML_DESCRIPTION\",\"group\":\"\"}','','','',0,'0000-00-00 00:00:00',0,0),(219,'mod_wrapper','module','mod_wrapper','',0,1,1,0,'{\"name\":\"mod_wrapper\",\"type\":\"module\",\"creationDate\":\"October 2004\",\"author\":\"Joomla! Project\",\"copyright\":\"Copyright (C) 2005 - 2014 Open Source Matters. All rights reserved.\",\"authorEmail\":\"admin@joomla.org\",\"authorUrl\":\"www.joomla.org\",\"version\":\"3.0.0\",\"description\":\"MOD_WRAPPER_XML_DESCRIPTION\",\"group\":\"\"}','','','',0,'0000-00-00 00:00:00',0,0),(220,'mod_articles_category','module','mod_articles_category','',0,1,1,0,'{\"name\":\"mod_articles_category\",\"type\":\"module\",\"creationDate\":\"February 2010\",\"author\":\"Joomla! Project\",\"copyright\":\"Copyright (C) 2005 - 2014 Open Source Matters. All rights reserved.\",\"authorEmail\":\"admin@joomla.org\",\"authorUrl\":\"www.joomla.org\",\"version\":\"3.0.0\",\"description\":\"MOD_ARTICLES_CATEGORY_XML_DESCRIPTION\",\"group\":\"\"}','','','',0,'0000-00-00 00:00:00',0,0),(221,'mod_articles_categories','module','mod_articles_categories','',0,1,1,0,'{\"name\":\"mod_articles_categories\",\"type\":\"module\",\"creationDate\":\"February 2010\",\"author\":\"Joomla! Project\",\"copyright\":\"Copyright (C) 2005 - 2014 Open Source Matters. All rights reserved.\",\"authorEmail\":\"admin@joomla.org\",\"authorUrl\":\"www.joomla.org\",\"version\":\"3.0.0\",\"description\":\"MOD_ARTICLES_CATEGORIES_XML_DESCRIPTION\",\"group\":\"\"}','','','',0,'0000-00-00 00:00:00',0,0),(222,'mod_languages','module','mod_languages','',0,1,1,1,'{\"name\":\"mod_languages\",\"type\":\"module\",\"creationDate\":\"February 2010\",\"author\":\"Joomla! Project\",\"copyright\":\"Copyright (C) 2005 - 2014 Open Source Matters. All rights reserved.\",\"authorEmail\":\"admin@joomla.org\",\"authorUrl\":\"www.joomla.org\",\"version\":\"3.0.0\",\"description\":\"MOD_LANGUAGES_XML_DESCRIPTION\",\"group\":\"\"}','','','',0,'0000-00-00 00:00:00',0,0),(223,'mod_finder','module','mod_finder','',0,1,0,0,'','','','',0,'0000-00-00 00:00:00',0,0),(300,'mod_custom','module','mod_custom','',1,1,1,1,'{\"name\":\"mod_custom\",\"type\":\"module\",\"creationDate\":\"July 2004\",\"author\":\"Joomla! Project\",\"copyright\":\"Copyright (C) 2005 - 2014 Open Source Matters. All rights reserved.\",\"authorEmail\":\"admin@joomla.org\",\"authorUrl\":\"www.joomla.org\",\"version\":\"3.0.0\",\"description\":\"MOD_CUSTOM_XML_DESCRIPTION\",\"group\":\"\"}','','','',0,'0000-00-00 00:00:00',0,0),(301,'mod_feed','module','mod_feed','',1,1,1,0,'{\"name\":\"mod_feed\",\"type\":\"module\",\"creationDate\":\"July 2005\",\"author\":\"Joomla! Project\",\"copyright\":\"Copyright (C) 2005 - 2014 Open Source Matters. All rights reserved.\",\"authorEmail\":\"admin@joomla.org\",\"authorUrl\":\"www.joomla.org\",\"version\":\"3.0.0\",\"description\":\"MOD_FEED_XML_DESCRIPTION\",\"group\":\"\"}','','','',0,'0000-00-00 00:00:00',0,0),(302,'mod_latest','module','mod_latest','',1,1,1,0,'{\"name\":\"mod_latest\",\"type\":\"module\",\"creationDate\":\"July 2004\",\"author\":\"Joomla! Project\",\"copyright\":\"Copyright (C) 2005 - 2014 Open Source Matters. All rights reserved.\",\"authorEmail\":\"admin@joomla.org\",\"authorUrl\":\"www.joomla.org\",\"version\":\"3.0.0\",\"description\":\"MOD_LATEST_XML_DESCRIPTION\",\"group\":\"\"}','','','',0,'0000-00-00 00:00:00',0,0),(303,'mod_logged','module','mod_logged','',1,1,1,0,'{\"name\":\"mod_logged\",\"type\":\"module\",\"creationDate\":\"January 2005\",\"author\":\"Joomla! Project\",\"copyright\":\"Copyright (C) 2005 - 2014 Open Source Matters. All rights reserved.\",\"authorEmail\":\"admin@joomla.org\",\"authorUrl\":\"www.joomla.org\",\"version\":\"3.0.0\",\"description\":\"MOD_LOGGED_XML_DESCRIPTION\",\"group\":\"\"}','','','',0,'0000-00-00 00:00:00',0,0),(304,'mod_login','module','mod_login','',1,1,1,1,'{\"name\":\"mod_login\",\"type\":\"module\",\"creationDate\":\"March 2005\",\"author\":\"Joomla! Project\",\"copyright\":\"Copyright (C) 2005 - 2014 Open Source Matters. All rights reserved.\",\"authorEmail\":\"admin@joomla.org\",\"authorUrl\":\"www.joomla.org\",\"version\":\"3.0.0\",\"description\":\"MOD_LOGIN_XML_DESCRIPTION\",\"group\":\"\"}','','','',0,'0000-00-00 00:00:00',0,0),(305,'mod_menu','module','mod_menu','',1,1,1,0,'{\"name\":\"mod_menu\",\"type\":\"module\",\"creationDate\":\"March 2006\",\"author\":\"Joomla! Project\",\"copyright\":\"Copyright (C) 2005 - 2014 Open Source Matters. All rights reserved.\",\"authorEmail\":\"admin@joomla.org\",\"authorUrl\":\"www.joomla.org\",\"version\":\"3.0.0\",\"description\":\"MOD_MENU_XML_DESCRIPTION\",\"group\":\"\"}','','','',0,'0000-00-00 00:00:00',0,0),(307,'mod_popular','module','mod_popular','',1,1,1,0,'{\"name\":\"mod_popular\",\"type\":\"module\",\"creationDate\":\"July 2004\",\"author\":\"Joomla! Project\",\"copyright\":\"Copyright (C) 2005 - 2014 Open Source Matters. All rights reserved.\",\"authorEmail\":\"admin@joomla.org\",\"authorUrl\":\"www.joomla.org\",\"version\":\"3.0.0\",\"description\":\"MOD_POPULAR_XML_DESCRIPTION\",\"group\":\"\"}','','','',0,'0000-00-00 00:00:00',0,0),(308,'mod_quickicon','module','mod_quickicon','',1,1,1,1,'{\"name\":\"mod_quickicon\",\"type\":\"module\",\"creationDate\":\"Nov 2005\",\"author\":\"Joomla! Project\",\"copyright\":\"Copyright (C) 2005 - 2014 Open Source Matters. All rights reserved.\",\"authorEmail\":\"admin@joomla.org\",\"authorUrl\":\"www.joomla.org\",\"version\":\"3.0.0\",\"description\":\"MOD_QUICKICON_XML_DESCRIPTION\",\"group\":\"\"}','','','',0,'0000-00-00 00:00:00',0,0),(309,'mod_status','module','mod_status','',1,1,1,0,'{\"name\":\"mod_status\",\"type\":\"module\",\"creationDate\":\"Feb 2006\",\"author\":\"Joomla! Project\",\"copyright\":\"(C) 2005 - 2014 Open Source Matters. All rights reserved.\",\"authorEmail\":\"admin@joomla.org\",\"authorUrl\":\"www.joomla.org\",\"version\":\"3.0.0\",\"description\":\"MOD_STATUS_XML_DESCRIPTION\",\"group\":\"\"}','','','',0,'0000-00-00 00:00:00',0,0),(310,'mod_submenu','module','mod_submenu','',1,1,1,0,'{\"name\":\"mod_submenu\",\"type\":\"module\",\"creationDate\":\"Feb 2006\",\"author\":\"Joomla! Project\",\"copyright\":\"Copyright (C) 2005 - 2014 Open Source Matters. All rights reserved.\",\"authorEmail\":\"admin@joomla.org\",\"authorUrl\":\"www.joomla.org\",\"version\":\"3.0.0\",\"description\":\"MOD_SUBMENU_XML_DESCRIPTION\",\"group\":\"\"}','','','',0,'0000-00-00 00:00:00',0,0),(311,'mod_title','module','mod_title','',1,1,1,0,'{\"name\":\"mod_title\",\"type\":\"module\",\"creationDate\":\"Nov 2005\",\"author\":\"Joomla! Project\",\"copyright\":\"Copyright (C) 2005 - 2014 Open Source Matters. All rights reserved.\",\"authorEmail\":\"admin@joomla.org\",\"authorUrl\":\"www.joomla.org\",\"version\":\"3.0.0\",\"description\":\"MOD_TITLE_XML_DESCRIPTION\",\"group\":\"\"}','','','',0,'0000-00-00 00:00:00',0,0),(312,'mod_toolbar','module','mod_toolbar','',1,1,1,1,'{\"name\":\"mod_toolbar\",\"type\":\"module\",\"creationDate\":\"Nov 2005\",\"author\":\"Joomla! Project\",\"copyright\":\"Copyright (C) 2005 - 2014 Open Source Matters. All rights reserved.\",\"authorEmail\":\"admin@joomla.org\",\"authorUrl\":\"www.joomla.org\",\"version\":\"3.0.0\",\"description\":\"MOD_TOOLBAR_XML_DESCRIPTION\",\"group\":\"\"}','','','',0,'0000-00-00 00:00:00',0,0),(313,'mod_multilangstatus','module','mod_multilangstatus','',1,1,1,0,'{\"name\":\"mod_multilangstatus\",\"type\":\"module\",\"creationDate\":\"September 2011\",\"author\":\"Joomla! Project\",\"copyright\":\"Copyright (C) 2005 - 2014 Open Source Matters. All rights reserved.\",\"authorEmail\":\"admin@joomla.org\",\"authorUrl\":\"www.joomla.org\",\"version\":\"3.0.0\",\"description\":\"MOD_MULTILANGSTATUS_XML_DESCRIPTION\",\"group\":\"\"}','{\"cache\":\"0\"}','','',0,'0000-00-00 00:00:00',0,0),(314,'mod_version','module','mod_version','',1,1,1,0,'{\"legacy\":false,\"name\":\"mod_version\",\"type\":\"module\",\"creationDate\":\"January 2012\",\"author\":\"Joomla! Project\",\"copyright\":\"Copyright (C) 2005 - 2012 Open Source Matters. All rights reserved.\",\"authorEmail\":\"admin@joomla.org\",\"authorUrl\":\"www.joomla.org\",\"version\":\"2.5.0\",\"description\":\"MOD_VERSION_XML_DESCRIPTION\",\"group\":\"\"}','{\"format\":\"short\",\"product\":\"1\",\"cache\":\"0\"}','','',0,'0000-00-00 00:00:00',0,0),(315,'mod_stats_admin','module','mod_stats_admin','',1,1,1,0,'{\"name\":\"mod_stats_admin\",\"type\":\"module\",\"creationDate\":\"July 2004\",\"author\":\"Joomla! Project\",\"copyright\":\"Copyright (C) 2005 - 2014 Open Source Matters. All rights reserved.\",\"authorEmail\":\"admin@joomla.org\",\"authorUrl\":\"www.joomla.org\",\"version\":\"3.0.0\",\"description\":\"MOD_STATS_XML_DESCRIPTION\",\"group\":\"\"}','{\"serverinfo\":\"0\",\"siteinfo\":\"0\",\"counter\":\"0\",\"increase\":\"0\",\"cache\":\"1\",\"cache_time\":\"900\",\"cachemode\":\"static\"}','','',0,'0000-00-00 00:00:00',0,0),(316,'mod_tags_popular','module','mod_tags_popular','',0,1,1,0,'{\"name\":\"mod_tags_popular\",\"type\":\"module\",\"creationDate\":\"January 2013\",\"author\":\"Joomla! Project\",\"copyright\":\"Copyright (C) 2005 - 2014 Open Source Matters. All rights reserved.\",\"authorEmail\":\"admin@joomla.org\",\"authorUrl\":\"www.joomla.org\",\"version\":\"3.1.0\",\"description\":\"MOD_TAGS_POPULAR_XML_DESCRIPTION\",\"group\":\"\"}','{\"maximum\":\"5\",\"timeframe\":\"alltime\",\"owncache\":\"1\"}','','',0,'0000-00-00 00:00:00',0,0),(317,'mod_tags_similar','module','mod_tags_similar','',0,1,1,0,'{\"name\":\"mod_tags_similar\",\"type\":\"module\",\"creationDate\":\"January 2013\",\"author\":\"Joomla! Project\",\"copyright\":\"Copyright (C) 2005 - 2014 Open Source Matters. All rights reserved.\",\"authorEmail\":\"admin@joomla.org\",\"authorUrl\":\"www.joomla.org\",\"version\":\"3.1.0\",\"description\":\"MOD_TAGS_SIMILAR_XML_DESCRIPTION\",\"group\":\"\"}','{\"maximum\":\"5\",\"matchtype\":\"any\",\"owncache\":\"1\"}','','',0,'0000-00-00 00:00:00',0,0),(400,'plg_authentication_gmail','plugin','gmail','authentication',0,0,1,0,'{\"name\":\"plg_authentication_gmail\",\"type\":\"plugin\",\"creationDate\":\"February 2006\",\"author\":\"Joomla! Project\",\"copyright\":\"Copyright (C) 2005 - 2014 Open Source Matters. All rights reserved.\",\"authorEmail\":\"admin@joomla.org\",\"authorUrl\":\"www.joomla.org\",\"version\":\"3.0.0\",\"description\":\"PLG_GMAIL_XML_DESCRIPTION\",\"group\":\"\"}','{\"applysuffix\":\"0\",\"suffix\":\"\",\"verifypeer\":\"1\",\"user_blacklist\":\"\"}','','',0,'0000-00-00 00:00:00',1,0),(401,'plg_authentication_joomla','plugin','joomla','authentication',0,1,1,1,'{\"name\":\"plg_authentication_joomla\",\"type\":\"plugin\",\"creationDate\":\"November 2005\",\"author\":\"Joomla! Project\",\"copyright\":\"Copyright (C) 2005 - 2014 Open Source Matters. All rights reserved.\",\"authorEmail\":\"admin@joomla.org\",\"authorUrl\":\"www.joomla.org\",\"version\":\"3.0.0\",\"description\":\"PLG_AUTH_JOOMLA_XML_DESCRIPTION\",\"group\":\"\"}','{}','','',0,'0000-00-00 00:00:00',0,0),(402,'plg_authentication_ldap','plugin','ldap','authentication',0,0,1,0,'{\"name\":\"plg_authentication_ldap\",\"type\":\"plugin\",\"creationDate\":\"November 2005\",\"author\":\"Joomla! Project\",\"copyright\":\"Copyright (C) 2005 - 2014 Open Source Matters. All rights reserved.\",\"authorEmail\":\"admin@joomla.org\",\"authorUrl\":\"www.joomla.org\",\"version\":\"3.0.0\",\"description\":\"PLG_LDAP_XML_DESCRIPTION\",\"group\":\"\"}','{\"host\":\"\",\"port\":\"389\",\"use_ldapV3\":\"0\",\"negotiate_tls\":\"0\",\"no_referrals\":\"0\",\"auth_method\":\"bind\",\"base_dn\":\"\",\"search_string\":\"\",\"users_dn\":\"\",\"username\":\"admin\",\"password\":\"bobby7\",\"ldap_fullname\":\"fullName\",\"ldap_email\":\"mail\",\"ldap_uid\":\"uid\"}','','',0,'0000-00-00 00:00:00',3,0),(403,'plg_content_contact','plugin','contact','content',0,1,1,0,'{\"name\":\"plg_content_contact\",\"type\":\"plugin\",\"creationDate\":\"January 2014\",\"author\":\"Joomla! Project\",\"copyright\":\"Copyright (C) 2005 - 2014 Open Source Matters. All rights reserved.\",\"authorEmail\":\"admin@joomla.org\",\"authorUrl\":\"www.joomla.org\",\"version\":\"3.2.2\",\"description\":\"PLG_CONTENT_CONTACT_XML_DESCRIPTION\",\"group\":\"\"}','','','',0,'0000-00-00 00:00:00',1,0),(404,'plg_content_emailcloak','plugin','emailcloak','content',0,1,1,0,'{\"name\":\"plg_content_emailcloak\",\"type\":\"plugin\",\"creationDate\":\"November 2005\",\"author\":\"Joomla! Project\",\"copyright\":\"Copyright (C) 2005 - 2014 Open Source Matters. All rights reserved.\",\"authorEmail\":\"admin@joomla.org\",\"authorUrl\":\"www.joomla.org\",\"version\":\"3.0.0\",\"description\":\"PLG_CONTENT_EMAILCLOAK_XML_DESCRIPTION\",\"group\":\"\"}','{\"mode\":\"1\"}','','',0,'0000-00-00 00:00:00',1,0),(405,'plg_content_geshi','plugin','geshi','content',0,0,1,0,'{\"name\":\"plg_content_geshi\",\"type\":\"plugin\",\"creationDate\":\"November 2005\",\"author\":\"Joomla! Project\",\"copyright\":\"Copyright (C) 2005 - 2013 Open Source Matters. All rights reserved.\",\"authorEmail\":\"\",\"authorUrl\":\"qbnz.com\\/highlighter\",\"version\":\"3.0.0\",\"description\":\"PLG_CONTENT_GESHI_XML_DESCRIPTION\",\"group\":\"\"}','{}','','',0,'0000-00-00 00:00:00',2,0),(406,'plg_content_loadmodule','plugin','loadmodule','content',0,1,1,0,'{\"name\":\"plg_content_loadmodule\",\"type\":\"plugin\",\"creationDate\":\"November 2005\",\"author\":\"Joomla! Project\",\"copyright\":\"Copyright (C) 2005 - 2014 Open Source Matters. All rights reserved.\",\"authorEmail\":\"admin@joomla.org\",\"authorUrl\":\"www.joomla.org\",\"version\":\"3.0.0\",\"description\":\"PLG_LOADMODULE_XML_DESCRIPTION\",\"group\":\"\"}','{\"style\":\"xhtml\"}','','',0,'2011-09-18 15:22:50',0,0),(407,'plg_content_pagebreak','plugin','pagebreak','content',0,1,1,0,'{\"name\":\"plg_content_pagebreak\",\"type\":\"plugin\",\"creationDate\":\"November 2005\",\"author\":\"Joomla! Project\",\"copyright\":\"Copyright (C) 2005 - 2014 Open Source Matters. All rights reserved.\",\"authorEmail\":\"admin@joomla.org\",\"authorUrl\":\"www.joomla.org\",\"version\":\"3.0.0\",\"description\":\"PLG_CONTENT_PAGEBREAK_XML_DESCRIPTION\",\"group\":\"\"}','{\"title\":\"1\",\"multipage_toc\":\"1\",\"showall\":\"1\"}','','',0,'0000-00-00 00:00:00',4,0),(408,'plg_content_pagenavigation','plugin','pagenavigation','content',0,1,1,0,'{\"name\":\"plg_content_pagenavigation\",\"type\":\"plugin\",\"creationDate\":\"January 2006\",\"author\":\"Joomla! Project\",\"copyright\":\"Copyright (C) 2005 - 2014 Open Source Matters. All rights reserved.\",\"authorEmail\":\"admin@joomla.org\",\"authorUrl\":\"www.joomla.org\",\"version\":\"3.0.0\",\"description\":\"PLG_PAGENAVIGATION_XML_DESCRIPTION\",\"group\":\"\"}','{\"position\":\"1\"}','','',0,'0000-00-00 00:00:00',5,0),(409,'plg_content_vote','plugin','vote','content',0,1,1,0,'{\"name\":\"plg_content_vote\",\"type\":\"plugin\",\"creationDate\":\"November 2005\",\"author\":\"Joomla! Project\",\"copyright\":\"Copyright (C) 2005 - 2014 Open Source Matters. All rights reserved.\",\"authorEmail\":\"admin@joomla.org\",\"authorUrl\":\"www.joomla.org\",\"version\":\"3.0.0\",\"description\":\"PLG_VOTE_XML_DESCRIPTION\",\"group\":\"\"}','{}','','',0,'0000-00-00 00:00:00',6,0),(410,'plg_editors_codemirror','plugin','codemirror','editors',0,1,1,1,'{\"name\":\"plg_editors_codemirror\",\"type\":\"plugin\",\"creationDate\":\"28 March 2011\",\"author\":\"Marijn Haverbeke\",\"copyright\":\"\",\"authorEmail\":\"N\\/A\",\"authorUrl\":\"\",\"version\":\"3.15\",\"description\":\"PLG_CODEMIRROR_XML_DESCRIPTION\",\"group\":\"\"}','{\"lineNumbers\":\"1\",\"lineWrapping\":\"1\",\"matchTags\":\"1\",\"matchBrackets\":\"1\",\"marker-gutter\":\"1\",\"autoCloseTags\":\"1\",\"autoCloseBrackets\":\"1\",\"autoFocus\":\"1\",\"theme\":\"default\",\"tabmode\":\"indent\"}','','',0,'0000-00-00 00:00:00',1,0),(411,'plg_editors_none','plugin','none','editors',0,1,1,1,'{\"name\":\"plg_editors_none\",\"type\":\"plugin\",\"creationDate\":\"August 2004\",\"author\":\"Unknown\",\"copyright\":\"\",\"authorEmail\":\"N\\/A\",\"authorUrl\":\"\",\"version\":\"3.0.0\",\"description\":\"PLG_NONE_XML_DESCRIPTION\",\"group\":\"\"}','{}','','',0,'0000-00-00 00:00:00',2,0),(412,'plg_editors_tinymce','plugin','tinymce','editors',0,1,1,0,'{\"name\":\"plg_editors_tinymce\",\"type\":\"plugin\",\"creationDate\":\"2005-2014\",\"author\":\"Moxiecode Systems AB\",\"copyright\":\"Moxiecode Systems AB\",\"authorEmail\":\"N\\/A\",\"authorUrl\":\"tinymce.moxiecode.com\",\"version\":\"4.1.2\",\"description\":\"PLG_TINY_XML_DESCRIPTION\",\"group\":\"\"}','{\"mode\":\"1\",\"skin\":\"0\",\"compressed\":\"0\",\"cleanup_startup\":\"0\",\"cleanup_save\":\"2\",\"entity_encoding\":\"raw\",\"lang_mode\":\"0\",\"lang_code\":\"en\",\"text_direction\":\"ltr\",\"content_css\":\"1\",\"content_css_custom\":\"\",\"relative_urls\":\"1\",\"newlines\":\"0\",\"invalid_elements\":\"script,applet,iframe\",\"extended_elements\":\"\",\"toolbar\":\"top\",\"toolbar_align\":\"left\",\"html_height\":\"550\",\"html_width\":\"750\",\"element_path\":\"1\",\"fonts\":\"1\",\"paste\":\"1\",\"searchreplace\":\"1\",\"insertdate\":\"1\",\"format_date\":\"%Y-%m-%d\",\"inserttime\":\"1\",\"format_time\":\"%H:%M:%S\",\"colors\":\"1\",\"table\":\"1\",\"smilies\":\"1\",\"media\":\"1\",\"hr\":\"1\",\"directionality\":\"1\",\"fullscreen\":\"1\",\"style\":\"1\",\"layer\":\"1\",\"xhtmlxtras\":\"1\",\"visualchars\":\"1\",\"nonbreaking\":\"1\",\"template\":\"1\",\"blockquote\":\"1\",\"wordcount\":\"1\",\"advimage\":\"1\",\"advlink\":\"1\",\"autosave\":\"1\",\"contextmenu\":\"1\",\"inlinepopups\":\"1\",\"safari\":\"0\",\"custom_plugin\":\"\",\"custom_button\":\"\"}','','',0,'0000-00-00 00:00:00',3,0),(413,'plg_editors-xtd_article','plugin','article','editors-xtd',0,1,1,1,'{\"name\":\"plg_editors-xtd_article\",\"type\":\"plugin\",\"creationDate\":\"October 2009\",\"author\":\"Joomla! Project\",\"copyright\":\"Copyright (C) 2005 - 2014 Open Source Matters. All rights reserved.\",\"authorEmail\":\"admin@joomla.org\",\"authorUrl\":\"www.joomla.org\",\"version\":\"3.0.0\",\"description\":\"PLG_ARTICLE_XML_DESCRIPTION\",\"group\":\"\"}','{}','','',0,'0000-00-00 00:00:00',1,0),(414,'plg_editors-xtd_image','plugin','image','editors-xtd',0,1,1,0,'{\"name\":\"plg_editors-xtd_image\",\"type\":\"plugin\",\"creationDate\":\"August 2004\",\"author\":\"Joomla! Project\",\"copyright\":\"Copyright (C) 2005 - 2014 Open Source Matters. All rights reserved.\",\"authorEmail\":\"admin@joomla.org\",\"authorUrl\":\"www.joomla.org\",\"version\":\"3.0.0\",\"description\":\"PLG_IMAGE_XML_DESCRIPTION\",\"group\":\"\"}','{}','','',0,'0000-00-00 00:00:00',2,0),(415,'plg_editors-xtd_pagebreak','plugin','pagebreak','editors-xtd',0,1,1,0,'{\"name\":\"plg_editors-xtd_pagebreak\",\"type\":\"plugin\",\"creationDate\":\"August 2004\",\"author\":\"Joomla! Project\",\"copyright\":\"Copyright (C) 2005 - 2014 Open Source Matters. All rights reserved.\",\"authorEmail\":\"admin@joomla.org\",\"authorUrl\":\"www.joomla.org\",\"version\":\"3.0.0\",\"description\":\"PLG_EDITORSXTD_PAGEBREAK_XML_DESCRIPTION\",\"group\":\"\"}','{}','','',0,'0000-00-00 00:00:00',3,0),(416,'plg_editors-xtd_readmore','plugin','readmore','editors-xtd',0,1,1,0,'{\"name\":\"plg_editors-xtd_readmore\",\"type\":\"plugin\",\"creationDate\":\"March 2006\",\"author\":\"Joomla! Project\",\"copyright\":\"Copyright (C) 2005 - 2014 Open Source Matters. All rights reserved.\",\"authorEmail\":\"admin@joomla.org\",\"authorUrl\":\"www.joomla.org\",\"version\":\"3.0.0\",\"description\":\"PLG_READMORE_XML_DESCRIPTION\",\"group\":\"\"}','{}','','',0,'0000-00-00 00:00:00',4,0),(417,'plg_search_categories','plugin','categories','search',0,1,1,0,'{\"name\":\"plg_search_categories\",\"type\":\"plugin\",\"creationDate\":\"November 2005\",\"author\":\"Joomla! Project\",\"copyright\":\"Copyright (C) 2005 - 2014 Open Source Matters. All rights reserved.\",\"authorEmail\":\"admin@joomla.org\",\"authorUrl\":\"www.joomla.org\",\"version\":\"3.0.0\",\"description\":\"PLG_SEARCH_CATEGORIES_XML_DESCRIPTION\",\"group\":\"\"}','{\"search_limit\":\"50\",\"search_content\":\"1\",\"search_archived\":\"1\"}','','',0,'0000-00-00 00:00:00',0,0),(418,'plg_search_contacts','plugin','contacts','search',0,1,1,0,'{\"name\":\"plg_search_contacts\",\"type\":\"plugin\",\"creationDate\":\"November 2005\",\"author\":\"Joomla! Project\",\"copyright\":\"Copyright (C) 2005 - 2014 Open Source Matters. All rights reserved.\",\"authorEmail\":\"admin@joomla.org\",\"authorUrl\":\"www.joomla.org\",\"version\":\"3.0.0\",\"description\":\"PLG_SEARCH_CONTACTS_XML_DESCRIPTION\",\"group\":\"\"}','{\"search_limit\":\"50\",\"search_content\":\"1\",\"search_archived\":\"1\"}','','',0,'0000-00-00 00:00:00',0,0),(419,'plg_search_content','plugin','content','search',0,1,1,0,'{\"name\":\"plg_search_content\",\"type\":\"plugin\",\"creationDate\":\"November 2005\",\"author\":\"Joomla! Project\",\"copyright\":\"Copyright (C) 2005 - 2014 Open Source Matters. All rights reserved.\",\"authorEmail\":\"admin@joomla.org\",\"authorUrl\":\"www.joomla.org\",\"version\":\"3.0.0\",\"description\":\"PLG_SEARCH_CONTENT_XML_DESCRIPTION\",\"group\":\"\"}','{\"search_limit\":\"50\",\"search_content\":\"1\",\"search_archived\":\"1\"}','','',0,'0000-00-00 00:00:00',0,0),(420,'plg_search_newsfeeds','plugin','newsfeeds','search',0,1,1,0,'{\"name\":\"plg_search_newsfeeds\",\"type\":\"plugin\",\"creationDate\":\"November 2005\",\"author\":\"Joomla! Project\",\"copyright\":\"Copyright (C) 2005 - 2014 Open Source Matters. All rights reserved.\",\"authorEmail\":\"admin@joomla.org\",\"authorUrl\":\"www.joomla.org\",\"version\":\"3.0.0\",\"description\":\"PLG_SEARCH_NEWSFEEDS_XML_DESCRIPTION\",\"group\":\"\"}','{\"search_limit\":\"50\",\"search_content\":\"1\",\"search_archived\":\"1\"}','','',0,'0000-00-00 00:00:00',0,0),(421,'plg_search_weblinks','plugin','weblinks','search',0,1,1,0,'{\"name\":\"plg_search_weblinks\",\"type\":\"plugin\",\"creationDate\":\"November 2005\",\"author\":\"Joomla! Project\",\"copyright\":\"Copyright (C) 2005 - 2014 Open Source Matters. All rights reserved.\",\"authorEmail\":\"admin@joomla.org\",\"authorUrl\":\"www.joomla.org\",\"version\":\"3.0.0\",\"description\":\"PLG_SEARCH_WEBLINKS_XML_DESCRIPTION\",\"group\":\"\"}','{\"search_limit\":\"50\",\"search_content\":\"1\",\"search_archived\":\"1\"}','','',0,'0000-00-00 00:00:00',0,0),(422,'plg_system_languagefilter','plugin','languagefilter','system',0,1,1,1,'{\"name\":\"plg_system_languagefilter\",\"type\":\"plugin\",\"creationDate\":\"July 2010\",\"author\":\"Joomla! Project\",\"copyright\":\"Copyright (C) 2005 - 2014 Open Source Matters. All rights reserved.\",\"authorEmail\":\"admin@joomla.org\",\"authorUrl\":\"www.joomla.org\",\"version\":\"3.0.0\",\"description\":\"PLG_SYSTEM_LANGUAGEFILTER_XML_DESCRIPTION\",\"group\":\"\"}','{\"detect_browser\":\"0\",\"automatic_change\":\"0\",\"item_associations\":\"0\",\"remove_default_prefix\":\"0\",\"lang_cookie\":\"1\",\"alternate_meta\":\"0\"}','','',0,'0000-00-00 00:00:00',1,0),(423,'plg_system_p3p','plugin','p3p','system',0,1,1,0,'{\"name\":\"plg_system_p3p\",\"type\":\"plugin\",\"creationDate\":\"September 2010\",\"author\":\"Joomla! Project\",\"copyright\":\"Copyright (C) 2005 - 2014 Open Source Matters. All rights reserved.\",\"authorEmail\":\"admin@joomla.org\",\"authorUrl\":\"www.joomla.org\",\"version\":\"3.0.0\",\"description\":\"PLG_P3P_XML_DESCRIPTION\",\"group\":\"\"}','{\"headers\":\"NOI ADM DEV PSAi COM NAV OUR OTRo STP IND DEM\"}','','',0,'0000-00-00 00:00:00',2,0),(424,'plg_system_cache','plugin','cache','system',0,0,1,1,'{\"name\":\"plg_system_cache\",\"type\":\"plugin\",\"creationDate\":\"February 2007\",\"author\":\"Joomla! Project\",\"copyright\":\"Copyright (C) 2005 - 2014 Open Source Matters. All rights reserved.\",\"authorEmail\":\"admin@joomla.org\",\"authorUrl\":\"www.joomla.org\",\"version\":\"3.0.0\",\"description\":\"PLG_CACHE_XML_DESCRIPTION\",\"group\":\"\"}','{\"browsercache\":\"0\",\"cachetime\":\"15\"}','','',0,'0000-00-00 00:00:00',9,0),(425,'plg_system_debug','plugin','debug','system',0,0,1,0,'{\"name\":\"plg_system_debug\",\"type\":\"plugin\",\"creationDate\":\"December 2006\",\"author\":\"Joomla! Project\",\"copyright\":\"Copyright (C) 2005 - 2014 Open Source Matters. All rights reserved.\",\"authorEmail\":\"admin@joomla.org\",\"authorUrl\":\"www.joomla.org\",\"version\":\"3.0.0\",\"description\":\"PLG_DEBUG_XML_DESCRIPTION\",\"group\":\"\"}','{\"profile\":\"1\",\"queries\":\"1\",\"memory\":\"1\",\"language_files\":\"1\",\"language_strings\":\"1\",\"strip-first\":\"1\",\"strip-prefix\":\"\",\"strip-suffix\":\"\"}','','',0,'0000-00-00 00:00:00',4,0),(426,'plg_system_log','plugin','log','system',0,0,1,1,'{\"name\":\"plg_system_log\",\"type\":\"plugin\",\"creationDate\":\"April 2007\",\"author\":\"Joomla! Project\",\"copyright\":\"Copyright (C) 2005 - 2014 Open Source Matters. All rights reserved.\",\"authorEmail\":\"admin@joomla.org\",\"authorUrl\":\"www.joomla.org\",\"version\":\"3.0.0\",\"description\":\"PLG_LOG_XML_DESCRIPTION\",\"group\":\"\"}','{}','','',0,'0000-00-00 00:00:00',5,0),(427,'plg_system_redirect','plugin','redirect','system',0,1,1,1,'{\"name\":\"plg_system_redirect\",\"type\":\"plugin\",\"creationDate\":\"April 2009\",\"author\":\"Joomla! Project\",\"copyright\":\"Copyright (C) 2005 - 2014 Open Source Matters. All rights reserved.\",\"authorEmail\":\"admin@joomla.org\",\"authorUrl\":\"www.joomla.org\",\"version\":\"3.0.0\",\"description\":\"PLG_REDIRECT_XML_DESCRIPTION\",\"group\":\"\"}','{}','','',0,'0000-00-00 00:00:00',6,0),(428,'plg_system_remember','plugin','remember','system',0,1,1,1,'{\"name\":\"plg_system_remember\",\"type\":\"plugin\",\"creationDate\":\"April 2007\",\"author\":\"Joomla! Project\",\"copyright\":\"Copyright (C) 2005 - 2014 Open Source Matters. All rights reserved.\",\"authorEmail\":\"admin@joomla.org\",\"authorUrl\":\"www.joomla.org\",\"version\":\"3.0.0\",\"description\":\"PLG_REMEMBER_XML_DESCRIPTION\",\"group\":\"\"}','{}','','',0,'0000-00-00 00:00:00',7,0),(429,'plg_system_sef','plugin','sef','system',0,1,1,0,'{\"name\":\"plg_system_sef\",\"type\":\"plugin\",\"creationDate\":\"December 2007\",\"author\":\"Joomla! Project\",\"copyright\":\"Copyright (C) 2005 - 2014 Open Source Matters. All rights reserved.\",\"authorEmail\":\"admin@joomla.org\",\"authorUrl\":\"www.joomla.org\",\"version\":\"3.0.0\",\"description\":\"PLG_SEF_XML_DESCRIPTION\",\"group\":\"\"}','{}','','',0,'0000-00-00 00:00:00',8,0),(430,'plg_system_logout','plugin','logout','system',0,1,1,1,'{\"name\":\"plg_system_logout\",\"type\":\"plugin\",\"creationDate\":\"April 2009\",\"author\":\"Joomla! Project\",\"copyright\":\"Copyright (C) 2005 - 2014 Open Source Matters. All rights reserved.\",\"authorEmail\":\"admin@joomla.org\",\"authorUrl\":\"www.joomla.org\",\"version\":\"3.0.0\",\"description\":\"PLG_SYSTEM_LOGOUT_XML_DESCRIPTION\",\"group\":\"\"}','{}','','',0,'0000-00-00 00:00:00',3,0),(431,'plg_user_contactcreator','plugin','contactcreator','user',0,0,1,0,'{\"name\":\"plg_user_contactcreator\",\"type\":\"plugin\",\"creationDate\":\"August 2009\",\"author\":\"Joomla! Project\",\"copyright\":\"(C) 2005 - 2014 Open Source Matters. All rights reserved.\",\"authorEmail\":\"admin@joomla.org\",\"authorUrl\":\"www.joomla.org\",\"version\":\"3.0.0\",\"description\":\"PLG_CONTACTCREATOR_XML_DESCRIPTION\",\"group\":\"\"}','{\"autowebpage\":\"\",\"category\":\"34\",\"autopublish\":\"0\"}','','',0,'0000-00-00 00:00:00',1,0),(432,'plg_user_joomla','plugin','joomla','user',0,1,1,0,'{\"name\":\"plg_user_joomla\",\"type\":\"plugin\",\"creationDate\":\"December 2006\",\"author\":\"Joomla! Project\",\"copyright\":\"(C) 2005 - 2009 Open Source Matters. All rights reserved.\",\"authorEmail\":\"admin@joomla.org\",\"authorUrl\":\"www.joomla.org\",\"version\":\"3.0.0\",\"description\":\"PLG_USER_JOOMLA_XML_DESCRIPTION\",\"group\":\"\"}','{\"autoregister\":\"1\",\"strong_passwords\":1}','','',0,'0000-00-00 00:00:00',2,0),(433,'plg_user_profile','plugin','profile','user',0,0,1,0,'{\"name\":\"plg_user_profile\",\"type\":\"plugin\",\"creationDate\":\"January 2008\",\"author\":\"Joomla! Project\",\"copyright\":\"(C) 2005 - 2014 Open Source Matters. All rights reserved.\",\"authorEmail\":\"admin@joomla.org\",\"authorUrl\":\"www.joomla.org\",\"version\":\"3.0.0\",\"description\":\"PLG_USER_PROFILE_XML_DESCRIPTION\",\"group\":\"\"}','{\"register-require_address1\":\"1\",\"register-require_address2\":\"1\",\"register-require_city\":\"1\",\"register-require_region\":\"1\",\"register-require_country\":\"1\",\"register-require_postal_code\":\"1\",\"register-require_phone\":\"1\",\"register-require_website\":\"1\",\"register-require_favoritebook\":\"1\",\"register-require_aboutme\":\"1\",\"register-require_tos\":\"1\",\"register-require_dob\":\"1\",\"profile-require_address1\":\"1\",\"profile-require_address2\":\"1\",\"profile-require_city\":\"1\",\"profile-require_region\":\"1\",\"profile-require_country\":\"1\",\"profile-require_postal_code\":\"1\",\"profile-require_phone\":\"1\",\"profile-require_website\":\"1\",\"profile-require_favoritebook\":\"1\",\"profile-require_aboutme\":\"1\",\"profile-require_tos\":\"1\",\"profile-require_dob\":\"1\"}','','',0,'0000-00-00 00:00:00',0,0),(434,'plg_extension_joomla','plugin','joomla','extension',0,1,1,1,'{\"name\":\"plg_extension_joomla\",\"type\":\"plugin\",\"creationDate\":\"May 2010\",\"author\":\"Joomla! Project\",\"copyright\":\"Copyright (C) 2005 - 2014 Open Source Matters. All rights reserved.\",\"authorEmail\":\"admin@joomla.org\",\"authorUrl\":\"www.joomla.org\",\"version\":\"3.0.0\",\"description\":\"PLG_EXTENSION_JOOMLA_XML_DESCRIPTION\",\"group\":\"\"}','{}','','',0,'0000-00-00 00:00:00',1,0),(435,'plg_content_joomla','plugin','joomla','content',0,1,1,0,'{\"name\":\"plg_content_joomla\",\"type\":\"plugin\",\"creationDate\":\"November 2010\",\"author\":\"Joomla! Project\",\"copyright\":\"Copyright (C) 2005 - 2014 Open Source Matters. All rights reserved.\",\"authorEmail\":\"admin@joomla.org\",\"authorUrl\":\"www.joomla.org\",\"version\":\"3.0.0\",\"description\":\"PLG_CONTENT_JOOMLA_XML_DESCRIPTION\",\"group\":\"\"}','{}','','',0,'0000-00-00 00:00:00',0,0),(436,'plg_system_languagecode','plugin','languagecode','system',0,0,1,0,'{\"name\":\"plg_system_languagecode\",\"type\":\"plugin\",\"creationDate\":\"November 2011\",\"author\":\"Joomla! Project\",\"copyright\":\"Copyright (C) 2005 - 2014 Open Source Matters. All rights reserved.\",\"authorEmail\":\"admin@joomla.org\",\"authorUrl\":\"www.joomla.org\",\"version\":\"3.0.0\",\"description\":\"PLG_SYSTEM_LANGUAGECODE_XML_DESCRIPTION\",\"group\":\"\"}','{}','','',0,'0000-00-00 00:00:00',10,0),(437,'plg_quickicon_joomlaupdate','plugin','joomlaupdate','quickicon',0,1,1,1,'{\"name\":\"plg_quickicon_joomlaupdate\",\"type\":\"plugin\",\"creationDate\":\"August 2011\",\"author\":\"Joomla! Project\",\"copyright\":\"Copyright (C) 2005 - 2014 Open Source Matters. All rights reserved.\",\"authorEmail\":\"admin@joomla.org\",\"authorUrl\":\"www.joomla.org\",\"version\":\"3.0.0\",\"description\":\"PLG_QUICKICON_JOOMLAUPDATE_XML_DESCRIPTION\",\"group\":\"\"}','{}','','',0,'0000-00-00 00:00:00',0,0),(438,'plg_quickicon_extensionupdate','plugin','extensionupdate','quickicon',0,1,1,1,'{\"name\":\"plg_quickicon_extensionupdate\",\"type\":\"plugin\",\"creationDate\":\"August 2011\",\"author\":\"Joomla! Project\",\"copyright\":\"Copyright (C) 2005 - 2014 Open Source Matters. All rights reserved.\",\"authorEmail\":\"admin@joomla.org\",\"authorUrl\":\"www.joomla.org\",\"version\":\"3.0.0\",\"description\":\"PLG_QUICKICON_EXTENSIONUPDATE_XML_DESCRIPTION\",\"group\":\"\"}','{}','','',0,'0000-00-00 00:00:00',0,0),(439,'plg_captcha_recaptcha','plugin','recaptcha','captcha',0,1,1,0,'{\"name\":\"plg_captcha_recaptcha\",\"type\":\"plugin\",\"creationDate\":\"December 2011\",\"author\":\"Joomla! Project\",\"copyright\":\"Copyright (C) 2005 - 2014 Open Source Matters. All rights reserved.\",\"authorEmail\":\"admin@joomla.org\",\"authorUrl\":\"www.joomla.org\",\"version\":\"3.0.0\",\"description\":\"PLG_CAPTCHA_RECAPTCHA_XML_DESCRIPTION\",\"group\":\"\"}','{\"public_key\":\"\",\"private_key\":\"\",\"theme\":\"clean\"}','','',0,'0000-00-00 00:00:00',0,0),(440,'plg_system_highlight','plugin','highlight','system',0,0,1,0,'','{}','','',0,'0000-00-00 00:00:00',7,0),(441,'plg_content_finder','plugin','finder','content',0,0,1,0,'{\"legacy\":false,\"name\":\"plg_content_finder\",\"type\":\"plugin\",\"creationDate\":\"December 2011\",\"author\":\"Joomla! Project\",\"copyright\":\"Copyright (C) 2005 - 2012 Open Source Matters. All rights reserved.\",\"authorEmail\":\"admin@joomla.org\",\"authorUrl\":\"www.joomla.org\",\"version\":\"1.7.0\",\"description\":\"PLG_CONTENT_FINDER_XML_DESCRIPTION\",\"group\":\"\"}','{}','','',0,'0000-00-00 00:00:00',0,0),(442,'plg_finder_categories','plugin','categories','finder',0,1,1,0,'{\"name\":\"plg_finder_categories\",\"type\":\"plugin\",\"creationDate\":\"August 2011\",\"author\":\"Joomla! Project\",\"copyright\":\"(C) 2005 - 2014 Open Source Matters. All rights reserved.\",\"authorEmail\":\"admin@joomla.org\",\"authorUrl\":\"www.joomla.org\",\"version\":\"3.0.0\",\"description\":\"PLG_FINDER_CATEGORIES_XML_DESCRIPTION\",\"group\":\"\"}','{}','','',0,'0000-00-00 00:00:00',1,0),(443,'plg_finder_contacts','plugin','contacts','finder',0,1,1,0,'{\"name\":\"plg_finder_contacts\",\"type\":\"plugin\",\"creationDate\":\"August 2011\",\"author\":\"Joomla! Project\",\"copyright\":\"(C) 2005 - 2014 Open Source Matters. All rights reserved.\",\"authorEmail\":\"admin@joomla.org\",\"authorUrl\":\"www.joomla.org\",\"version\":\"3.0.0\",\"description\":\"PLG_FINDER_CONTACTS_XML_DESCRIPTION\",\"group\":\"\"}','{}','','',0,'0000-00-00 00:00:00',2,0),(444,'plg_finder_content','plugin','content','finder',0,1,1,0,'{\"name\":\"plg_finder_content\",\"type\":\"plugin\",\"creationDate\":\"August 2011\",\"author\":\"Joomla! Project\",\"copyright\":\"(C) 2005 - 2014 Open Source Matters. All rights reserved.\",\"authorEmail\":\"admin@joomla.org\",\"authorUrl\":\"www.joomla.org\",\"version\":\"3.0.0\",\"description\":\"PLG_FINDER_CONTENT_XML_DESCRIPTION\",\"group\":\"\"}','{}','','',0,'0000-00-00 00:00:00',3,0),(445,'plg_finder_newsfeeds','plugin','newsfeeds','finder',0,1,1,0,'{\"name\":\"plg_finder_newsfeeds\",\"type\":\"plugin\",\"creationDate\":\"August 2011\",\"author\":\"Joomla! Project\",\"copyright\":\"(C) 2005 - 2014 Open Source Matters. All rights reserved.\",\"authorEmail\":\"admin@joomla.org\",\"authorUrl\":\"www.joomla.org\",\"version\":\"3.0.0\",\"description\":\"PLG_FINDER_NEWSFEEDS_XML_DESCRIPTION\",\"group\":\"\"}','{}','','',0,'0000-00-00 00:00:00',4,0),(446,'plg_finder_weblinks','plugin','weblinks','finder',0,1,1,0,'{\"name\":\"plg_finder_weblinks\",\"type\":\"plugin\",\"creationDate\":\"August 2011\",\"author\":\"Joomla! Project\",\"copyright\":\"(C) 2005 - 2014 Open Source Matters. All rights reserved.\",\"authorEmail\":\"admin@joomla.org\",\"authorUrl\":\"www.joomla.org\",\"version\":\"3.0.0\",\"description\":\"PLG_FINDER_WEBLINKS_XML_DESCRIPTION\",\"group\":\"\"}','{}','','',0,'0000-00-00 00:00:00',5,0),(447,'plg_finder_tags','plugin','tags','finder',0,1,1,0,'{\"name\":\"plg_finder_tags\",\"type\":\"plugin\",\"creationDate\":\"February 2013\",\"author\":\"Joomla! Project\",\"copyright\":\"(C) 2005 - 2014 Open Source Matters. All rights reserved.\",\"authorEmail\":\"admin@joomla.org\",\"authorUrl\":\"www.joomla.org\",\"version\":\"3.0.0\",\"description\":\"PLG_FINDER_TAGS_XML_DESCRIPTION\",\"group\":\"\"}','{}','','',0,'0000-00-00 00:00:00',0,0),(448,'plg_twofactorauth_totp','plugin','totp','twofactorauth',0,0,1,0,'{\"name\":\"plg_twofactorauth_totp\",\"type\":\"plugin\",\"creationDate\":\"August 2013\",\"author\":\"Joomla! Project\",\"copyright\":\"Copyright (C) 2005 - 2014 Open Source Matters. All rights reserved.\",\"authorEmail\":\"admin@joomla.org\",\"authorUrl\":\"www.joomla.org\",\"version\":\"3.2.0\",\"description\":\"PLG_TWOFACTORAUTH_TOTP_XML_DESCRIPTION\",\"group\":\"\"}','{}','','',0,'0000-00-00 00:00:00',0,0),(449,'plg_authentication_cookie','plugin','cookie','authentication',0,1,1,0,'{\"name\":\"plg_authentication_cookie\",\"type\":\"plugin\",\"creationDate\":\"July 2013\",\"author\":\"Joomla! Project\",\"copyright\":\"Copyright (C) 2005 - 2013 Open Source Matters. All rights reserved.\",\"authorEmail\":\"admin@joomla.org\",\"authorUrl\":\"www.joomla.org\",\"version\":\"3.0.0\",\"description\":\"PLG_AUTH_COOKIE_XML_DESCRIPTION\",\"group\":\"\"}','{}','','',0,'0000-00-00 00:00:00',0,0),(450,'plg_twofactorauth_yubikey','plugin','yubikey','twofactorauth',0,0,1,0,'{\"name\":\"plg_twofactorauth_yubikey\",\"type\":\"plugin\",\"creationDate\":\"Se[ptember 2013\",\"author\":\"Joomla! Project\",\"copyright\":\"(C) 2005 - 2013 Open Source Matters. All rights reserved.\",\"authorEmail\":\"admin@joomla.org\",\"authorUrl\":\"www.joomla.org\",\"version\":\"3.2.0\",\"description\":\"PLG_TWOFACTORAUTH_YUBIKEY_XML_DESCRIPTION\",\"group\":\"\"}','{}','','',0,'0000-00-00 00:00:00',0,0),(451,'plg_search_tags','plugin','tags','search',0,0,1,0,'{\"name\":\"plg_search_tags\",\"type\":\"plugin\",\"creationDate\":\"March 2014\",\"author\":\"Joomla! Project\",\"copyright\":\"Copyright (C) 2005 - 2014 Open Source Matters. All rights reserved.\",\"authorEmail\":\"admin@joomla.org\",\"authorUrl\":\"www.joomla.org\",\"version\":\"3.0.0\",\"description\":\"PLG_SEARCH_TAGS_XML_DESCRIPTION\",\"group\":\"\"}','{\"search_limit\":\"50\",\"show_tagged_items\":\"1\"}','','',0,'0000-00-00 00:00:00',0,0),(500,'atomic','template','atomic','',0,1,1,0,'{\"legacy\":false,\"name\":\"atomic\",\"type\":\"template\",\"creationDate\":\"10\\/10\\/09\",\"author\":\"Ron Severdia\",\"copyright\":\"Copyright (C) 2005 - 2013 Open Source Matters, Inc. All rights reserved.\",\"authorEmail\":\"contact@kontentdesign.com\",\"authorUrl\":\"http:\\/\\/www.kontentdesign.com\",\"version\":\"2.5.0\",\"description\":\"TPL_ATOMIC_XML_DESCRIPTION\",\"group\":\"\"}','{}','','',0,'0000-00-00 00:00:00',0,0),(502,'bluestork','template','bluestork','',1,1,1,0,'{\"legacy\":false,\"name\":\"bluestork\",\"type\":\"template\",\"creationDate\":\"07\\/02\\/09\",\"author\":\"Joomla! Project\",\"copyright\":\"Copyright (C) 2005 - 2013 Open Source Matters, Inc. All rights reserved.\",\"authorEmail\":\"admin@joomla.org\",\"authorUrl\":\"www.joomla.org\",\"version\":\"2.5.0\",\"description\":\"TPL_BLUESTORK_XML_DESCRIPTION\",\"group\":\"\"}','{\"useRoundedCorners\":\"1\",\"showSiteName\":\"0\",\"textBig\":\"0\",\"highContrast\":\"0\"}','','',0,'0000-00-00 00:00:00',0,0),(503,'beez_20','template','beez_20','',0,1,1,0,'{\"legacy\":false,\"name\":\"beez_20\",\"type\":\"template\",\"creationDate\":\"25 November 2009\",\"author\":\"Angie Radtke\",\"copyright\":\"Copyright (C) 2005 - 2013 Open Source Matters, Inc. All rights reserved.\",\"authorEmail\":\"a.radtke@derauftritt.de\",\"authorUrl\":\"http:\\/\\/www.der-auftritt.de\",\"version\":\"2.5.0\",\"description\":\"TPL_BEEZ2_XML_DESCRIPTION\",\"group\":\"\"}','{\"wrapperSmall\":\"53\",\"wrapperLarge\":\"72\",\"sitetitle\":\"\",\"sitedescription\":\"\",\"navposition\":\"center\",\"templatecolor\":\"nature\"}','','',0,'0000-00-00 00:00:00',0,0),(504,'hathor','template','hathor','',1,1,1,0,'{\"name\":\"hathor\",\"type\":\"template\",\"creationDate\":\"May 2010\",\"author\":\"Andrea Tarr\",\"copyright\":\"Copyright (C) 2005 - 2014 Open Source Matters, Inc. All rights reserved.\",\"authorEmail\":\"hathor@tarrconsulting.com\",\"authorUrl\":\"http:\\/\\/www.tarrconsulting.com\",\"version\":\"3.0.0\",\"description\":\"TPL_HATHOR_XML_DESCRIPTION\",\"group\":\"\"}','{\"showSiteName\":\"0\",\"colourChoice\":\"0\",\"boldText\":\"0\"}','','',0,'0000-00-00 00:00:00',0,0),(505,'beez5','template','beez5','',0,1,1,0,'{\"legacy\":false,\"name\":\"beez5\",\"type\":\"template\",\"creationDate\":\"21 May 2010\",\"author\":\"Angie Radtke\",\"copyright\":\"Copyright (C) 2005 - 2013 Open Source Matters, Inc. All rights reserved.\",\"authorEmail\":\"a.radtke@derauftritt.de\",\"authorUrl\":\"http:\\/\\/www.der-auftritt.de\",\"version\":\"2.5.0\",\"description\":\"TPL_BEEZ5_XML_DESCRIPTION\",\"group\":\"\"}','{\"wrapperSmall\":\"53\",\"wrapperLarge\":\"72\",\"sitetitle\":\"\",\"sitedescription\":\"\",\"navposition\":\"center\",\"html5\":\"0\"}','','',0,'0000-00-00 00:00:00',0,0),(600,'English (United Kingdom)','language','en-GB','',0,1,1,1,'{\"name\":\"English (United Kingdom)\",\"type\":\"language\",\"creationDate\":\"2013-03-07\",\"author\":\"Joomla! Project\",\"copyright\":\"Copyright (C) 2005 - 2014 Open Source Matters. All rights reserved.\",\"authorEmail\":\"admin@joomla.org\",\"authorUrl\":\"www.joomla.org\",\"version\":\"3.3.1\",\"description\":\"en-GB site language\",\"group\":\"\"}','','','',0,'0000-00-00 00:00:00',0,0),(601,'English (United Kingdom)','language','en-GB','',1,1,1,1,'{\"name\":\"English (United Kingdom)\",\"type\":\"language\",\"creationDate\":\"2013-03-07\",\"author\":\"Joomla! Project\",\"copyright\":\"Copyright (C) 2005 - 2014 Open Source Matters. All rights reserved.\",\"authorEmail\":\"admin@joomla.org\",\"authorUrl\":\"www.joomla.org\",\"version\":\"3.3.1\",\"description\":\"en-GB administrator language\",\"group\":\"\"}','','','',0,'0000-00-00 00:00:00',0,0),(700,'files_joomla','file','joomla','',0,1,1,1,'{\"name\":\"files_joomla\",\"type\":\"file\",\"creationDate\":\"September 2014\",\"author\":\"Joomla! Project\",\"copyright\":\"(C) 2005 - 2014 Open Source Matters. All rights reserved\",\"authorEmail\":\"admin@joomla.org\",\"authorUrl\":\"www.joomla.org\",\"version\":\"3.3.6\",\"description\":\"FILES_JOOMLA_XML_DESCRIPTION\",\"group\":\"\"}','','','',0,'0000-00-00 00:00:00',0,0),(10000,'com_jomres','component','com_jomres','',1,1,1,0,'','','','',0,'0000-00-00 00:00:00',0,0),(10001,'Jomres AsAModule','module','mod_jomres_asamodule','',0,1,1,0,'{\"legacy\":false,\"name\":\"Jomres AsAModule\",\"type\":\"module\",\"creationDate\":\"February 2011\",\"author\":\"Vince Wooll\",\"copyright\":\"(C) 2011 Vince Wooll\",\"authorEmail\":\"support@jomres.net\",\"authorUrl\":\"http:\\/\\/www.jomres.net\",\"version\":\"4\",\"description\":\"Allows you to set a specific task as a module that can be included anywhere on the site. Minicomponents have a pattern jnnnnnxxxxx.class.php. Some of these have the pattern 06000, for example like j06000popular_properties.class.php (see the popular properties plugin). This functionality can be called via a url like http:\\/\\/www.domain.com\\/index.php?option=com_jomres&task=popular_properties, however it is more appropriate to include that popular properties page in a module, and this module allows you to do that. To put the popular properties plugin in a module, set the \'task\' parameter opposite to \'popular_properties\' and configure your position as you would any other module.\",\"group\":\"\"}','{\"jomres_task\":\"\",\"arguments\":\"\"}','','',0,'0000-00-00 00:00:00',0,0),(10011,'Akeeba Backup Notification Module','module','mod_akadmin','',1,1,2,0,'{\"legacy\":true,\"name\":\"Akeeba Backup Notification Module\",\"type\":\"module\",\"creationDate\":\"2012-03-07\",\"author\":\"Nicholas K. Dionysopoulos\",\"copyright\":\"Copyright (c)2009-2010 Nicholas K. Dionysopoulos\",\"authorEmail\":\"nicholas@dionysopoulos.me\",\"authorUrl\":\"http:\\/\\/www.akeebabackup.com\",\"version\":\"3.4.1\",\"description\":\"\\n\\t<h1>Akeeba Backup Notification Module<\\/h1>\\n\\t<p>This is a handy  module to display a Akeeba icon on your administrator\\n\\tback-end\'s Control Panel page. The icon displays a warning site if the last\\n\\tbackup is failed, or if you haven\'t backed up your site for a period of time\\n\\t(user-defined). Clicking it brings you to the Akeeba Backup &quot;Backup Now&quot;\\n\\tpage.<\\/p>\\n\\t\",\"group\":\"\"}','[]','','',0,'0000-00-00 00:00:00',0,0),(10012,'akeeba','component','com_akeeba','',1,1,0,0,'{\"name\":\"Akeeba\",\"type\":\"component\",\"creationDate\":\"2014-09-30\",\"author\":\"Nicholas K. Dionysopoulos\",\"copyright\":\"Copyright (c)2006-2014 Nicholas K. Dionysopoulos\",\"authorEmail\":\"nicholas@dionysopoulos.me\",\"authorUrl\":\"http:\\/\\/www.akeebabackup.com\",\"version\":\"4.0.5\",\"description\":\"Akeeba Backup Core - Full Joomla! site backup solution, Core Edition.\",\"group\":\"\"}','{\"frontend_enable\":\"0\",\"frontend_secret_word\":\"\",\"frontend_email_on_finish\":\"0\",\"frontend_email_address\":\"\",\"frontend_email_subject\":\"\",\"frontend_email_body\":\"\",\"siteurl\":\"http:\\/\\/localhost\\/jomresquickstart\\/\",\"jversion\":\"1.6\",\"jlibrariesdir\":\"C:\\/wamp\\/www\\/jomresquickstart\\/libraries\",\"lastversion\":\"3.11.4\",\"usesvnsource\":\"0\",\"update_dlid\":\"\",\"minstability\":\"stable\",\"lastupdatecheck\":\"2009-01-01\",\"updateini\":\"\",\"liveupdate\":\"lastcheck=1398767929\\nupdatedata=\\\"[BLOB]\\\"\\nstuck=0\",\"useencryption\":\"1\",\"acceptlicense\":true,\"acceptsupport\":true,\"acceptbackuptest\":true,\"angieupgrade\":1}','','',0,'0000-00-00 00:00:00',0,0),(10016,'Akeeba Backup Lazy Scheduling','plugin','aklazy','system',0,0,1,0,'{\"legacy\":true,\"name\":\"Akeeba Backup Lazy Scheduling\",\"type\":\"plugin\",\"creationDate\":\"2011-04-17\",\"author\":\"Nicholas K. Dionysopoulos\",\"copyright\":\"Copyright (c)2010-2012 Nicholas K. Dionysopoulos\",\"authorEmail\":\"nicholas@dionysopoulos.me\",\"authorUrl\":\"http:\\/\\/www.akeebabackup.com\",\"version\":\"3.3\",\"description\":\"\\n\\t\\tAutomate your Akeeba Backup installation without using CRON, taking\\n\\t\\tadvantage of your site\'s visitor activity. Important: Read the\\n\\t\\tdocumentation before proceeding. THIS PLUGIN IS NO LONGER SUPPORTED.\\n\\t\\tDO NOT REQUEST SUPPORT IF IT DOESN\'T WORK. READ THE DOCUMENTATION FOR\\n\\t\\tA LIST OF KNOWN ISSUES.\\n\\t\",\"group\":\"\"}','{\"daysfreq\":\"1\",\"backuptime\":\"00:00\",\"profile\":\"1\",\"@spacer\":\"\",\"test\":\"0\",\"resetpw\":\"\"}','','',0,'0000-00-00 00:00:00',0,0),(10017,'Search module 1','module','mod_jomsearch_m1','',0,1,1,0,'{\"legacy\":false,\"name\":\"Search module 1\",\"type\":\"module\",\"creationDate\":\"July 2011\",\"author\":\"Vince Wooll\",\"copyright\":\"(C) 2011 Vince Wooll\",\"authorEmail\":\"support@jomres.net\",\"authorUrl\":\"http:\\/\\/www.jomres.net\",\"version\":\"4\",\"description\":\"Search module.\",\"group\":\"\"}','{\"useCols\":\"0\",\"featurecols\":\"5\",\"selectcombo\":\"0\",\"propertyname\":\"0\",\"propertyname_dropdown\":\"0\",\"ptype\":\"0\",\"ptype_dropdown\":\"0\",\"room_type\":\"0\",\"room_type_dropdown\":\"0\",\"features\":\"0\",\"features_dropdown\":\"0\",\"description\":\"0\",\"availability\":\"0\",\"priceranges\":\"0\",\"pricerange_increments\":\"10\",\"guestnumber\":\"0\",\"stars\":\"0\"}','','',0,'0000-00-00 00:00:00',0,0),(10018,'Search module 2','module','mod_jomsearch_m2','',0,1,1,0,'{\"legacy\":false,\"name\":\"Search module 2\",\"type\":\"module\",\"creationDate\":\"May 2011\",\"author\":\"Vince Wooll\",\"copyright\":\"(C) 2011 Vince Wooll\",\"authorEmail\":\"support@jomres.net\",\"authorUrl\":\"http:\\/\\/www.jomres.net\",\"version\":\"4\",\"description\":\"Search module.\",\"group\":\"\"}','{\"useCols\":\"0\",\"geosearchtype\":\"0\",\"geosearch_dropdown\":\"0\",\"selectcombo\":\"0\",\"propertyname\":\"0\",\"propertyname_dropdown\":\"0\",\"ptype\":\"0\",\"ptype_dropdown\":\"0\",\"room_type\":\"0\",\"room_type_dropdown\":\"0\",\"features\":\"0\",\"features_dropdown\":\"0\",\"featurecols\":\"5\",\"description\":\"0\",\"availability\":\"0\",\"priceranges\":\"0\",\"pricerange_increments\":\"10\",\"guestnumber\":\"0\",\"stars\":\"0\"}','','',0,'0000-00-00 00:00:00',0,0),(10019,'Search module 3','module','mod_jomsearch_m3','',0,1,1,0,'{\"legacy\":false,\"name\":\"Search module 3\",\"type\":\"module\",\"creationDate\":\"May 2011\",\"author\":\"Vince Wooll\",\"copyright\":\"(C) 2011 Vince Wooll\",\"authorEmail\":\"support@jomres.net\",\"authorUrl\":\"http:\\/\\/www.jomres.net\",\"version\":\"4\",\"description\":\"Search module.\",\"group\":\"\"}','{\"useCols\":\"0\",\"geosearchtype\":\"0\",\"geosearch_dropdown\":\"0\",\"selectcombo\":\"0\",\"propertyname\":\"0\",\"propertyname_dropdown\":\"0\",\"ptype\":\"0\",\"ptype_dropdown\":\"0\",\"room_type\":\"0\",\"room_type_dropdown\":\"0\",\"features\":\"0\",\"features_dropdown\":\"0\",\"featurecols\":\"5\",\"description\":\"0\",\"availability\":\"0\",\"priceranges\":\"0\",\"pricerange_increments\":\"10\",\"guestnumber\":\"0\",\"stars\":\"0\"}','','',0,'0000-00-00 00:00:00',0,0),(10022,'System - Jomres Language Router','plugin','jomres_language_plugin_bot','system',0,0,1,0,'{\"legacy\":false,\"name\":\"System - Jomres Language Router\",\"type\":\"plugin\",\"creationDate\":\"January 2012\",\"author\":\"Aladar Barthi\",\"copyright\":\"Copyright (C) 2012 Woollyinwales IT All rights reserved.\",\"authorEmail\":\"support@jomres.net\",\"authorUrl\":\"www.jomres.net\",\"version\":\"1\",\"description\":\"Provides Jomres language routing, allows us to use the Jomres language switcher to switch languages in Joomla 2.5. In the Joomla plugin manager ensure that System - Language Filter and System - Language Code are enabled, and that the required language(s) is(are) installed. \",\"group\":\"\"}','{}','','',0,'0000-00-00 00:00:00',0,0),(10023,'PLG_JMONITORING_AKEEBABACKUP_TITLE','plugin','akeebabackup','jmonitoring',0,1,1,0,'{\"name\":\"PLG_JMONITORING_AKEEBABACKUP_TITLE\",\"type\":\"plugin\",\"creationDate\":\"May 2012\",\"author\":\"Nicholas K. Dionysopoulos \\/ AkeebaBackup.com\",\"copyright\":\"\",\"authorEmail\":\"nicholas@dionysopoulos.me\",\"authorUrl\":\"http:\\/\\/www.akeebabackup.com\",\"version\":\"1.0\",\"description\":\"PLG_JMONITORING_AKEEBABACKUP_DESCRIPTION\",\"group\":\"\"}','{\"maxbackupperiod\":\"24\"}','','',0,'0000-00-00 00:00:00',0,0),(10025,'AkeebaStrapper','file','files_strapper','',0,1,0,0,'{\"name\":\"AkeebaStrapper\",\"type\":\"file\",\"creationDate\":\"2014-09-11 16:58:22\",\"author\":\"Nicholas K. Dionysopoulos\",\"copyright\":\"(C) 2012-2013 Akeeba Ltd.\",\"authorEmail\":\"nicholas@dionysopoulos.me\",\"authorUrl\":\"https:\\/\\/www.akeebabackup.com\",\"version\":\"rev844F136-1410443902\",\"description\":\"Namespaced jQuery, jQuery UI and Bootstrap for Akeeba products.\",\"group\":\"\"}','','','',0,'0000-00-00 00:00:00',0,0),(10027,'isis','template','isis','',1,1,1,0,'{\"name\":\"isis\",\"type\":\"template\",\"creationDate\":\"3\\/30\\/2012\",\"author\":\"Kyle Ledbetter\",\"copyright\":\"Copyright (C) 2005 - 2014 Open Source Matters, Inc. All rights reserved.\",\"authorEmail\":\"admin@joomla.org\",\"authorUrl\":\"\",\"version\":\"1.0\",\"description\":\"TPL_ISIS_XML_DESCRIPTION\",\"group\":\"\"}','{\"templateColor\":\"\",\"logoFile\":\"\"}','','',0,'0000-00-00 00:00:00',0,0),(10028,'protostar','template','protostar','',0,1,1,0,'{\"name\":\"protostar\",\"type\":\"template\",\"creationDate\":\"4\\/30\\/2012\",\"author\":\"Kyle Ledbetter\",\"copyright\":\"Copyright (C) 2005 - 2014 Open Source Matters, Inc. All rights reserved.\",\"authorEmail\":\"admin@joomla.org\",\"authorUrl\":\"\",\"version\":\"1.0\",\"description\":\"TPL_PROTOSTAR_XML_DESCRIPTION\",\"group\":\"\"}','{\"templateColor\":\"\",\"logoFile\":\"\",\"googleFont\":\"1\",\"googleFontName\":\"Open+Sans\",\"fluidContainer\":\"0\"}','','',0,'0000-00-00 00:00:00',0,0),(10029,'beez3','template','beez3','',0,1,1,0,'{\"name\":\"beez3\",\"type\":\"template\",\"creationDate\":\"25 November 2009\",\"author\":\"Angie Radtke\",\"copyright\":\"Copyright (C) 2005 - 2014 Open Source Matters, Inc. All rights reserved.\",\"authorEmail\":\"a.radtke@derauftritt.de\",\"authorUrl\":\"http:\\/\\/www.der-auftritt.de\",\"version\":\"3.1.0\",\"description\":\"TPL_BEEZ3_XML_DESCRIPTION\",\"group\":\"\"}','{\"wrapperSmall\":\"53\",\"wrapperLarge\":\"72\",\"sitetitle\":\"\",\"sitedescription\":\"\",\"navposition\":\"center\",\"templatecolor\":\"nature\"}','','',0,'0000-00-00 00:00:00',0,0),(10033,'Search module 4','module','mod_jomsearch_m4','',0,1,1,0,'{\"name\":\"Search module 4\",\"type\":\"module\",\"creationDate\":\"May 2011\",\"author\":\"Vince Wooll\",\"copyright\":\"(C) 2011 Vince Wooll\",\"authorEmail\":\"support@jomres.net\",\"authorUrl\":\"http:\\/\\/www.jomres.net\",\"version\":\"4\",\"description\":\"Search module.\",\"group\":\"\"}','{\"useCols\":\"0\",\"geosearchtype\":\"0\",\"geosearch_dropdown\":\"0\",\"selectcombo\":\"0\",\"propertyname\":\"0\",\"propertyname_dropdown\":\"0\",\"ptype\":\"0\",\"ptype_dropdown\":\"0\",\"room_type\":\"0\",\"room_type_dropdown\":\"0\",\"features\":\"0\",\"features_dropdown\":\"0\",\"featurecols\":\"5\",\"description\":\"0\",\"availability\":\"1\",\"priceranges\":\"0\",\"pricerange_increments\":\"10\",\"guestnumber\":\"0\",\"stars\":\"0\"}','','',0,'0000-00-00 00:00:00',0,0),(10035,'FOF','library','lib_fof','',0,1,1,0,'{\"name\":\"FOF\",\"type\":\"library\",\"creationDate\":\"2013-09-06\",\"author\":\"Nicholas K. Dionysopoulos \\/ Akeeba Ltd\",\"copyright\":\"(C)2011-2013 Nicholas K. Dionysopoulos\",\"authorEmail\":\"nicholas@akeebabackup.com\",\"authorUrl\":\"https:\\/\\/www.akeebabackup.com\",\"version\":\"revC1A6D5A-1378494129\",\"description\":\"Framework-on-Framework (FOF) - A rapid component development framework for Joomla!\",\"group\":\"\"}','{}','','',0,'0000-00-00 00:00:00',0,0),(10036,'plg_content_jomres_asamodule_mambot','plugin','jomres_asamodule_mambot','content',0,0,1,0,'{\"name\":\"plg_content_jomres_asamodule_mambot\",\"type\":\"plugin\",\"creationDate\":\"January 2012\",\"author\":\"Vince Wooll\",\"copyright\":\"Copyright (C) 2012 Vince Wooll All rights reserved.\",\"authorEmail\":\"support@jomres.net\",\"authorUrl\":\"www.jomres.net\",\"version\":\"1\",\"description\":\"Jomres ASAmodule content mambot. Show Jomres pages in your Joomla content. Whatever you can do in Jomres ASAModule, you can replicate the output in this mambot. Create the tag like {asamambot task \\\"arguments\\\"} so for example {asamambot remoteavailability \\\"&id=1\\\"}\",\"group\":\"\"}','{}','','',0,'0000-00-00 00:00:00',0,0),(10037,'Booking form in content mambot','plugin','jomres_booking_form_in_content','content',0,0,1,0,'{\"name\":\"Booking form in content mambot\",\"type\":\"plugin\",\"creationDate\":\"January 2012\",\"author\":\"Vince Wooll\",\"copyright\":\"Copyright (C) 2012 Vince Wooll All rights reserved.\",\"authorEmail\":\"support@jomres.net\",\"authorUrl\":\"www.jomres.net\",\"version\":\"1\",\"description\":\"Booking form in article mambot. Use this bot to show the booking form of a specific property in the content of an article. In the article put {bot_jomres_bookingform N} where N is the property uid of the property.\",\"group\":\"\"}','{}','','',0,'0000-00-00 00:00:00',0,0),(10039,'T3 Framework','plugin','t3','system',0,1,1,0,'{\"name\":\"T3 Framework\",\"type\":\"plugin\",\"creationDate\":\"July 31, 2014\",\"author\":\"JoomlArt.com\",\"copyright\":\"Copyright (C) 2005 - 2013 Open Source Matters. All rights reserved.\",\"authorEmail\":\"info@joomlart.com\",\"authorUrl\":\"http:\\/\\/www.t3-framework.org\",\"version\":\"2.3.1\",\"description\":\"\\n\\t\\n\\t<div align=\\\"center\\\">\\n\\t\\t<div class=\\\"alert alert-success\\\" style=\\\"background-color:#DFF0D8;border-color:#D6E9C6;color: #468847;padding: 1px 0;\\\">\\n\\t\\t\\t\\t<a href=\\\"http:\\/\\/t3-framework.org\\/\\\"><img src=\\\"http:\\/\\/joomlart.s3.amazonaws.com\\/images\\/jat3v3-documents\\/message-installation\\/logo.png\\\" alt=\\\"some_text\\\" width=\\\"300\\\" height=\\\"99\\\"><\\/a>\\n\\t\\t\\t\\t<h4><a href=\\\"http:\\/\\/t3-framework.org\\/\\\" title=\\\"\\\">Home<\\/a> | <a href=\\\"http:\\/\\/demo.t3-framework.org\\/\\\" title=\\\"\\\">Demo<\\/a> | <a href=\\\"http:\\/\\/t3-framework.org\\/documentation\\\" title=\\\"\\\">Document<\\/a> | <a href=\\\"https:\\/\\/github.com\\/t3framework\\/t3\\/blob\\/master\\/CHANGELOG.md\\\" title=\\\"\\\">Changelog<\\/a><\\/h4>\\n\\t\\t<p> <\\/p>\\n\\t\\t<p>Copyright 2004 - 2014 <a href=\'http:\\/\\/www.joomlart.com\\/\' title=\'Visit Joomlart.com!\'>JoomlArt.com<\\/a>.<\\/p>\\n\\t\\t<\\/div>\\n     <style>table.adminform{width: 100%;}<\\/style>\\n\\t <\\/div>\\n\\t\\t\\n\\t\",\"group\":\"\"}','{}','','',0,'0000-00-00 00:00:00',0,0),(10041,'lib_xef','library','lib_xef','',0,1,1,0,'{\"name\":\"lib_xef\",\"type\":\"library\",\"creationDate\":\"03\\/16\\/2014\",\"author\":\"Parvez Akther\",\"copyright\":\"Copyright (C) 2011 - 2011 ThemeXpert\",\"authorEmail\":\"parvez@themexpert.com\",\"authorUrl\":\"http:\\/\\/themexpert.com\\/\",\"version\":\"1.4.1\",\"description\":\"\\n        ThemeXpert Extension Framework (XEF) \\u2013 A rapid extension development framework for all ThemeXpert extensions.\\n    \",\"group\":\"\"}','{}','','',0,'0000-00-00 00:00:00',0,0),(10045,'SpanishES','language','es-ES','',0,1,0,0,'{\"name\":\"Spanish (ES)\",\"type\":\"language\",\"creationDate\":\"2014-6-22\",\"author\":\"Spanish Translation Team: Comunidad Joomla\",\"copyright\":\"Copyright (C) 2005 - 2014 Open Source Matters and comunidadjoomla.org. All rights reserved.\",\"authorEmail\":\"info@comunidadjoomla.org\",\"authorUrl\":\"www.comunidadjoomla.org\",\"version\":\"3.3.1.3\",\"description\":\"Spanish language pack for Joomla! 3.3.1 - Site\",\"group\":\"\"}','{}','','',0,'0000-00-00 00:00:00',0,0),(10046,'SpanishES','language','es-ES','',1,1,0,0,'{\"name\":\"Spanish (ES)\",\"type\":\"language\",\"creationDate\":\"2014-6-22\",\"author\":\"Spanish Translation Team: Comunidad Joomla\",\"copyright\":\"Copyright (C) 2005 - 2014 Open Source Matters and comunidadjoomla.org. All rights reserved.\",\"authorEmail\":\"info@comunidadjoomla.org\",\"authorUrl\":\"www.comunidadjoomla.org\",\"version\":\"3.3.1.3\",\"description\":\"Spanish language pack for Joomla! 3.3.1 - Administrator\",\"group\":\"\"}','{}','','',0,'0000-00-00 00:00:00',0,0),(10047,'es-ES','package','pkg_es-ES','',0,1,1,0,'{\"name\":\"Spanish Language Pack\",\"type\":\"package\",\"creationDate\":\"22 de junio del 2014\",\"author\":\"Spanish Translation Team: comunidadjoomla.org\",\"copyright\":\"Copyright (C) 2005 - 2014 comunidadjoomla.org and Open Source Matters. All rights reserved.\",\"authorEmail\":\"info@comunidadjoomla.org\",\"authorUrl\":\"www.comunidadjoomla.org\",\"version\":\"3.3.1.3\",\"description\":\"\\n\\t\\t<div style=\\\"text-align:left;\\\">\\n\\t\\t<h2>Successfully installed the spanish language pack for Joomla! 3.3.1.<\\/h2>\\n\\t\\t<p><\\/p>\\n\\t\\t<p>Please report any bugs or issues at the Comunidad Joomla! <a href=\\\"http:\\/\\/foro.comunidadjoomla.org\\/traduccion-ext\\/\\\" target=\\\"_blank\\\">Translation forum<\\/a><\\/p>\\n\\t\\t<p><\\/p>\\n\\t\\t<p>Translated by: <a href=\\\"http:\\/\\/www.comunidadjoomla.org\\\" target=\\\"_blank\\\" title=\\\"\\\">The spanish translation team of Comunidad Joomla!<\\/a><\\/p>\\n\\t\\t<h2>El paquete en espa\\u00f1ol para Joomla! 3.3.1 se ha instalado correctamente.<\\/h2>\\n\\t\\t<p><\\/p>\\n\\t\\t<p>Por favor, reporte cualquier bug o asunto relacionado a nuestro <a href=\\\"http:\\/\\/foro.comunidadjoomla.org\\/traduccion-ext\\/\\\" target=\\\"_blank\\\">Foro de traducciones<\\/a><\\/p>\\n\\t\\t<p><\\/p>\\n\\t\\t<p>Traducci\\u00f3n: <a href=\\\"http:\\/\\/www.comunidadjoomla.org\\\" target=\\\"_blank\\\" title=\\\"\\\">El equipo de traducci\\u00f3n de Comunidad Joomla!<\\/a><\\/p>\\n\\t\\t<\\/div>\\n\\t\\t\",\"group\":\"\"}','{}','','',0,'0000-00-00 00:00:00',0,0),(10050,'Vina Camera Image Slider','module','mod_vina_camera_image_slider','',0,1,0,0,'{\"name\":\"Vina Camera Image Slider\",\"type\":\"module\",\"creationDate\":\"April 22, 2014\",\"author\":\"VinaGecko.com\",\"copyright\":\"Copyright (C) 2014 VinaGecko.com. All rights reserved.\",\"authorEmail\":\"support@vinagecko.com\",\"authorUrl\":\"http:\\/\\/VinaGecko.com\",\"version\":\"1.0.0\",\"description\":\"\\n\\t\\t<div style=\\\"border: 1px solid red; border-radius: 7px; padding: 10px;\\\">\\n\\t\\t<strong>Vina Camera Image Slider<\\/strong> is a free responsive slider for Joomla 3 with many features: 30 Transition Effects, 32 Skin Type to Set, Unlimited Image... It uses a light version of jQuery mobile, you can navigate the slides by swiping with your fingers. Being compatible with most of the browsers Vina Camera Image Slider is a perfect choice for your portfolio banner.<br>\\n\\t\\t<strong>VinaGecko.com<\\/strong> - Premium <a href=\\\"http:\\/\\/vinagecko.com\\/joomla-modules\\\" target=\\\"_blank\\\">Joomla Modules<\\/a>, <a href=\\\"http:\\/\\/vinagecko.com\\/joomla-plugins\\\" target=\\\"_blank\\\">Joomla Plugins<\\/a>, <a href=\\\"http:\\/\\/vinagecko.com\\/joomla-templates\\\" target=\\\"_blank\\\">Joomla Templates<\\/a>.\\n\\t\\t<\\/div>\\n\\t\",\"group\":\"\"}','{\"moduleWidth\":\"100%\",\"maxWidth\":\"100%\",\"moduleHeight\":\"50%\",\"moduleStyle\":\"camera_amber_skin\",\"displayCaptions\":\"1\",\"resizeImage\":\"1\",\"imageWidth\":\"600\",\"imageHeight\":\"300\",\"loaderStyle\":\"pie\",\"piePosition\":\"rightTop\",\"barPosition\":\"bottom\",\"barDirection\":\"leftToRight\",\"fx\":\"random\",\"pauseHover\":\"1\",\"pauseOnClick\":\"1\",\"navigation\":\"1\",\"navigationHover\":\"1\",\"playPause\":\"1\",\"pagination\":\"0\",\"thumbnails\":\"1\",\"thumbnailWidth\":\"100\",\"thumbnailHeight\":\"75\",\"duration\":\"7000\",\"transPeriod\":\"1500\",\"copyRightText\":\"0\",\"cache\":\"1\",\"cache_time\":\"900\",\"cachemode\":\"static\"}','','',0,'0000-00-00 00:00:00',0,0),(10052,'F0F (NEW) DO NOT REMOVE','library','lib_f0f','',0,1,1,0,'{\"name\":\"F0F (NEW) DO NOT REMOVE\",\"type\":\"library\",\"creationDate\":\"2014-09-11 16:58:22\",\"author\":\"Nicholas K. Dionysopoulos \\/ Akeeba Ltd\",\"copyright\":\"(C)2011-2014 Nicholas K. Dionysopoulos\",\"authorEmail\":\"nicholas@akeebabackup.com\",\"authorUrl\":\"https:\\/\\/www.akeebabackup.com\",\"version\":\"rev844F136-1410443902\",\"description\":\"Framework-on-Framework (FOF) newer version - DO NOT REMOVE - The rapid component development framework for Joomla!. This package is the newer version of FOF, not the one shipped with Joomla! as the official Joomla! RAD Layer. The Joomla! RAD Layer has ceased development in March 2014. DO NOT UNINSTALL THIS PACKAGE, IT IS *** N O T *** A DUPLICATE OF THE \'FOF\' PACKAGE. REMOVING EITHER FOF PACKAGE WILL BREAK YOUR SITE.\",\"group\":\"\"}','{}','','',0,'0000-00-00 00:00:00',0,0),(10056,'jr_leotian','template','jr_leotian','',0,1,1,0,'{\"name\":\"jr_leotian\",\"type\":\"template\",\"creationDate\":\"01 Oct 2014\",\"author\":\"Aladar Barthi\",\"copyright\":\"Copyright (C), jomres-extras.com. All Rights Reserved.\",\"authorEmail\":\"support@jomres-extras.com\",\"authorUrl\":\"http:\\/\\/www.jomres-extras.com\",\"version\":\"1.0\",\"description\":\"\\n\\t\\t\\n\\t\\t<div align=\\\"center\\\">\\n\\t\\t\\tJoomla template for Jomres\\n\\t\\t<\\/div>\\n\\t\\t\\n\\t\",\"group\":\"\"}','{}','','',0,'0000-00-00 00:00:00',0,0),(10057,'MOD_ITPSOCIALBUTTONS','module','mod_itpsocialbuttons','',0,1,0,0,'{\"name\":\"MOD_ITPSOCIALBUTTONS\",\"type\":\"module\",\"creationDate\":\"09 August, 2014\",\"author\":\"Todor Iliev\",\"copyright\":\"Copyright (C) 2014 Todor Iliev ( ITPrism.com )\",\"authorEmail\":\"todor@itprism.com\",\"authorUrl\":\"http:\\/\\/itprism.com\",\"version\":\"2.4\",\"description\":\"\\n    <p>It is <a href=\'http:\\/\\/itprism.com\\/free-joomla-extensions\\/social-buttons-plugin\' target=\'_blank\'>ITPSocialButtons module<\\/a> for Joomla! that displays social media sharing buttons on your site.<\\/p>\\n    <p><a href=\'http:\\/\\/itprism.com\\/help\\/35-social-buttons-documentation-faq\' target=\'_blank\'>Read documentation<\\/a> that will help you to setup the extensions.<\\/p>\\n    <p>Invest in the extension improvement and <a href=\'http:\\/\\/itprism.com\\/sponsorship\' title=\'Sponsoring\' target=\'_blank\'>sponsor it via SMS, PayPal or Bitcoin<\\/a>.<\\/p>\\n    <p><a href=\'http:\\/\\/itprism.com\\/\' target=\'_blank\'>Subscribe for the newsletter<\\/a> to receive information about updates and new ITPrism extensions.<\\/p>\\n    <p>Please, <a href=\'http:\\/\\/extensions.joomla.org\\/extensions\\/social-web\\/social-bookmarking\\/14094\' target=\'_blank\'>vote for this extension<\\/a> on Joomla! Extensions Directory!<\\/p>\\n    \",\"group\":\"\"}','{\"icons_package\":\"big\",\"showTitle\":\"1\",\"title\":\"Share this post\",\"displayLines\":\"itp-sbb-bothl\",\"displayIcons\":\"itp-sbb-left\",\"displayDelicious\":\"1\",\"displayDigg\":\"1\",\"displayFacebook\":\"1\",\"displayGoogle\":\"1\",\"displayLinkedIn\":\"1\",\"displaySumbleUpon\":\"1\",\"displayTechnorati\":\"1\",\"displayTwitter\":\"1\",\"login\":\"\",\"apiKey\":\"\",\"shortUrlService\":\"\",\"ebuttons1\":\"\",\"ebuttons2\":\"\",\"ebuttons3\":\"\",\"ebuttons4\":\"\",\"ebuttons5\":\"\",\"cache\":\"0\",\"loadCss\":\"1\"}','','',0,'0000-00-00 00:00:00',0,0);

--
-- Table structure for table `q43qy_finder_filters`
--

CREATE TABLE `q43qy_finder_filters` (
  `filter_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `alias` varchar(255) NOT NULL,
  `state` tinyint(1) NOT NULL DEFAULT 1,
  `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `created_by` int(10) unsigned NOT NULL,
  `created_by_alias` varchar(255) NOT NULL,
  `modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `modified_by` int(10) unsigned NOT NULL DEFAULT 0,
  `checked_out` int(10) unsigned NOT NULL DEFAULT 0,
  `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `map_count` int(10) unsigned NOT NULL DEFAULT 0,
  `data` text NOT NULL,
  `params` mediumtext DEFAULT NULL,
  PRIMARY KEY (`filter_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `q43qy_finder_filters`
--


--
-- Table structure for table `q43qy_finder_links`
--

CREATE TABLE `q43qy_finder_links` (
  `link_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `url` varchar(255) NOT NULL,
  `route` varchar(255) NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `indexdate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `md5sum` varchar(32) DEFAULT NULL,
  `published` tinyint(1) NOT NULL DEFAULT 1,
  `state` int(5) DEFAULT 1,
  `access` int(5) DEFAULT 0,
  `language` varchar(8) NOT NULL,
  `publish_start_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `publish_end_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `start_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `end_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `list_price` double unsigned NOT NULL DEFAULT 0,
  `sale_price` double unsigned NOT NULL DEFAULT 0,
  `type_id` int(11) NOT NULL,
  `object` mediumblob NOT NULL,
  PRIMARY KEY (`link_id`),
  KEY `idx_type` (`type_id`),
  KEY `idx_title` (`title`),
  KEY `idx_md5` (`md5sum`),
  KEY `idx_url` (`url`(75)),
  KEY `idx_published_list` (`published`,`state`,`access`,`publish_start_date`,`publish_end_date`,`list_price`),
  KEY `idx_published_sale` (`published`,`state`,`access`,`publish_start_date`,`publish_end_date`,`sale_price`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `q43qy_finder_links`
--


--
-- Table structure for table `q43qy_finder_links_terms0`
--

CREATE TABLE `q43qy_finder_links_terms0` (
  `link_id` int(10) unsigned NOT NULL,
  `term_id` int(10) unsigned NOT NULL,
  `weight` float unsigned NOT NULL,
  PRIMARY KEY (`link_id`,`term_id`),
  KEY `idx_term_weight` (`term_id`,`weight`),
  KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `q43qy_finder_links_terms0`
--


--
-- Table structure for table `q43qy_finder_links_terms1`
--

CREATE TABLE `q43qy_finder_links_terms1` (
  `link_id` int(10) unsigned NOT NULL,
  `term_id` int(10) unsigned NOT NULL,
  `weight` float unsigned NOT NULL,
  PRIMARY KEY (`link_id`,`term_id`),
  KEY `idx_term_weight` (`term_id`,`weight`),
  KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `q43qy_finder_links_terms1`
--


--
-- Table structure for table `q43qy_finder_links_terms2`
--

CREATE TABLE `q43qy_finder_links_terms2` (
  `link_id` int(10) unsigned NOT NULL,
  `term_id` int(10) unsigned NOT NULL,
  `weight` float unsigned NOT NULL,
  PRIMARY KEY (`link_id`,`term_id`),
  KEY `idx_term_weight` (`term_id`,`weight`),
  KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `q43qy_finder_links_terms2`
--


--
-- Table structure for table `q43qy_finder_links_terms3`
--

CREATE TABLE `q43qy_finder_links_terms3` (
  `link_id` int(10) unsigned NOT NULL,
  `term_id` int(10) unsigned NOT NULL,
  `weight` float unsigned NOT NULL,
  PRIMARY KEY (`link_id`,`term_id`),
  KEY `idx_term_weight` (`term_id`,`weight`),
  KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `q43qy_finder_links_terms3`
--


--
-- Table structure for table `q43qy_finder_links_terms4`
--

CREATE TABLE `q43qy_finder_links_terms4` (
  `link_id` int(10) unsigned NOT NULL,
  `term_id` int(10) unsigned NOT NULL,
  `weight` float unsigned NOT NULL,
  PRIMARY KEY (`link_id`,`term_id`),
  KEY `idx_term_weight` (`term_id`,`weight`),
  KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `q43qy_finder_links_terms4`
--


--
-- Table structure for table `q43qy_finder_links_terms5`
--

CREATE TABLE `q43qy_finder_links_terms5` (
  `link_id` int(10) unsigned NOT NULL,
  `term_id` int(10) unsigned NOT NULL,
  `weight` float unsigned NOT NULL,
  PRIMARY KEY (`link_id`,`term_id`),
  KEY `idx_term_weight` (`term_id`,`weight`),
  KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `q43qy_finder_links_terms5`
--


--
-- Table structure for table `q43qy_finder_links_terms6`
--

CREATE TABLE `q43qy_finder_links_terms6` (
  `link_id` int(10) unsigned NOT NULL,
  `term_id` int(10) unsigned NOT NULL,
  `weight` float unsigned NOT NULL,
  PRIMARY KEY (`link_id`,`term_id`),
  KEY `idx_term_weight` (`term_id`,`weight`),
  KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `q43qy_finder_links_terms6`
--


--
-- Table structure for table `q43qy_finder_links_terms7`
--

CREATE TABLE `q43qy_finder_links_terms7` (
  `link_id` int(10) unsigned NOT NULL,
  `term_id` int(10) unsigned NOT NULL,
  `weight` float unsigned NOT NULL,
  PRIMARY KEY (`link_id`,`term_id`),
  KEY `idx_term_weight` (`term_id`,`weight`),
  KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `q43qy_finder_links_terms7`
--


--
-- Table structure for table `q43qy_finder_links_terms8`
--

CREATE TABLE `q43qy_finder_links_terms8` (
  `link_id` int(10) unsigned NOT NULL,
  `term_id` int(10) unsigned NOT NULL,
  `weight` float unsigned NOT NULL,
  PRIMARY KEY (`link_id`,`term_id`),
  KEY `idx_term_weight` (`term_id`,`weight`),
  KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `q43qy_finder_links_terms8`
--


--
-- Table structure for table `q43qy_finder_links_terms9`
--

CREATE TABLE `q43qy_finder_links_terms9` (
  `link_id` int(10) unsigned NOT NULL,
  `term_id` int(10) unsigned NOT NULL,
  `weight` float unsigned NOT NULL,
  PRIMARY KEY (`link_id`,`term_id`),
  KEY `idx_term_weight` (`term_id`,`weight`),
  KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `q43qy_finder_links_terms9`
--


--
-- Table structure for table `q43qy_finder_links_termsa`
--

CREATE TABLE `q43qy_finder_links_termsa` (
  `link_id` int(10) unsigned NOT NULL,
  `term_id` int(10) unsigned NOT NULL,
  `weight` float unsigned NOT NULL,
  PRIMARY KEY (`link_id`,`term_id`),
  KEY `idx_term_weight` (`term_id`,`weight`),
  KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `q43qy_finder_links_termsa`
--


--
-- Table structure for table `q43qy_finder_links_termsb`
--

CREATE TABLE `q43qy_finder_links_termsb` (
  `link_id` int(10) unsigned NOT NULL,
  `term_id` int(10) unsigned NOT NULL,
  `weight` float unsigned NOT NULL,
  PRIMARY KEY (`link_id`,`term_id`),
  KEY `idx_term_weight` (`term_id`,`weight`),
  KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `q43qy_finder_links_termsb`
--


--
-- Table structure for table `q43qy_finder_links_termsc`
--

CREATE TABLE `q43qy_finder_links_termsc` (
  `link_id` int(10) unsigned NOT NULL,
  `term_id` int(10) unsigned NOT NULL,
  `weight` float unsigned NOT NULL,
  PRIMARY KEY (`link_id`,`term_id`),
  KEY `idx_term_weight` (`term_id`,`weight`),
  KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `q43qy_finder_links_termsc`
--


--
-- Table structure for table `q43qy_finder_links_termsd`
--

CREATE TABLE `q43qy_finder_links_termsd` (
  `link_id` int(10) unsigned NOT NULL,
  `term_id` int(10) unsigned NOT NULL,
  `weight` float unsigned NOT NULL,
  PRIMARY KEY (`link_id`,`term_id`),
  KEY `idx_term_weight` (`term_id`,`weight`),
  KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `q43qy_finder_links_termsd`
--


--
-- Table structure for table `q43qy_finder_links_termse`
--

CREATE TABLE `q43qy_finder_links_termse` (
  `link_id` int(10) unsigned NOT NULL,
  `term_id` int(10) unsigned NOT NULL,
  `weight` float unsigned NOT NULL,
  PRIMARY KEY (`link_id`,`term_id`),
  KEY `idx_term_weight` (`term_id`,`weight`),
  KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `q43qy_finder_links_termse`
--


--
-- Table structure for table `q43qy_finder_links_termsf`
--

CREATE TABLE `q43qy_finder_links_termsf` (
  `link_id` int(10) unsigned NOT NULL,
  `term_id` int(10) unsigned NOT NULL,
  `weight` float unsigned NOT NULL,
  PRIMARY KEY (`link_id`,`term_id`),
  KEY `idx_term_weight` (`term_id`,`weight`),
  KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `q43qy_finder_links_termsf`
--


--
-- Table structure for table `q43qy_finder_taxonomy`
--

CREATE TABLE `q43qy_finder_taxonomy` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `parent_id` int(10) unsigned NOT NULL DEFAULT 0,
  `title` varchar(255) NOT NULL,
  `state` tinyint(1) unsigned NOT NULL DEFAULT 1,
  `access` tinyint(1) unsigned NOT NULL DEFAULT 0,
  `ordering` tinyint(1) unsigned NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `parent_id` (`parent_id`),
  KEY `state` (`state`),
  KEY `ordering` (`ordering`),
  KEY `access` (`access`),
  KEY `idx_parent_published` (`parent_id`,`state`,`access`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `q43qy_finder_taxonomy`
--


--
-- Table structure for table `q43qy_finder_taxonomy_map`
--

CREATE TABLE `q43qy_finder_taxonomy_map` (
  `link_id` int(10) unsigned NOT NULL,
  `node_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`link_id`,`node_id`),
  KEY `link_id` (`link_id`),
  KEY `node_id` (`node_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `q43qy_finder_taxonomy_map`
--


--
-- Table structure for table `q43qy_finder_terms`
--

CREATE TABLE `q43qy_finder_terms` (
  `term_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `term` varchar(75) NOT NULL,
  `stem` varchar(75) NOT NULL,
  `common` tinyint(1) unsigned NOT NULL DEFAULT 0,
  `phrase` tinyint(1) unsigned NOT NULL DEFAULT 0,
  `weight` float unsigned NOT NULL DEFAULT 0,
  `soundex` varchar(75) NOT NULL,
  `links` int(10) NOT NULL DEFAULT 0,
  `language` char(3) NOT NULL DEFAULT '',
  PRIMARY KEY (`term_id`),
  UNIQUE KEY `idx_term` (`term`),
  KEY `idx_term_phrase` (`term`,`phrase`),
  KEY `idx_stem_phrase` (`stem`,`phrase`),
  KEY `idx_soundex_phrase` (`soundex`,`phrase`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `q43qy_finder_terms`
--


--
-- Table structure for table `q43qy_finder_terms_common`
--

CREATE TABLE `q43qy_finder_terms_common` (
  `term` varchar(75) NOT NULL,
  `language` varchar(3) NOT NULL,
  KEY `idx_word_lang` (`term`,`language`),
  KEY `idx_lang` (`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `q43qy_finder_terms_common`
--

INSERT INTO `q43qy_finder_terms_common` (`term`, `language`) VALUES ('a','en'),('about','en'),('after','en'),('ago','en'),('all','en'),('am','en'),('an','en'),('and','en'),('ani','en'),('any','en'),('are','en'),('aren\'t','en'),('as','en'),('at','en'),('be','en'),('but','en'),('by','en'),('for','en'),('from','en'),('get','en'),('go','en'),('how','en'),('if','en'),('in','en'),('into','en'),('is','en'),('isn\'t','en'),('it','en'),('its','en'),('me','en'),('more','en'),('most','en'),('must','en'),('my','en'),('new','en'),('no','en'),('none','en'),('not','en'),('noth','en'),('nothing','en'),('of','en'),('off','en'),('often','en'),('old','en'),('on','en'),('onc','en'),('once','en'),('onli','en'),('only','en'),('or','en'),('other','en'),('our','en'),('ours','en'),('out','en'),('over','en'),('page','en'),('she','en'),('should','en'),('small','en'),('so','en'),('some','en'),('than','en'),('thank','en'),('that','en'),('the','en'),('their','en'),('theirs','en'),('them','en'),('then','en'),('there','en'),('these','en'),('they','en'),('this','en'),('those','en'),('thus','en'),('time','en'),('times','en'),('to','en'),('too','en'),('true','en'),('under','en'),('until','en'),('up','en'),('upon','en'),('use','en'),('user','en'),('users','en'),('veri','en'),('version','en'),('very','en'),('via','en'),('want','en'),('was','en'),('way','en'),('were','en'),('what','en'),('when','en'),('where','en'),('whi','en'),('which','en'),('who','en'),('whom','en'),('whose','en'),('why','en'),('wide','en'),('will','en'),('with','en'),('within','en'),('without','en'),('would','en'),('yes','en'),('yet','en'),('you','en'),('your','en'),('yours','en');

--
-- Table structure for table `q43qy_finder_tokens`
--

CREATE TABLE `q43qy_finder_tokens` (
  `term` varchar(75) NOT NULL,
  `stem` varchar(75) NOT NULL,
  `common` tinyint(1) unsigned NOT NULL DEFAULT 0,
  `phrase` tinyint(1) unsigned NOT NULL DEFAULT 0,
  `weight` float unsigned NOT NULL DEFAULT 1,
  `context` tinyint(1) unsigned NOT NULL DEFAULT 2,
  `language` char(3) NOT NULL DEFAULT '',
  KEY `idx_word` (`term`),
  KEY `idx_context` (`context`)
) ENGINE=MEMORY DEFAULT CHARSET=utf8;

--
-- Dumping data for table `q43qy_finder_tokens`
--


--
-- Table structure for table `q43qy_finder_tokens_aggregate`
--

CREATE TABLE `q43qy_finder_tokens_aggregate` (
  `term_id` int(10) unsigned NOT NULL,
  `map_suffix` char(1) NOT NULL,
  `term` varchar(75) NOT NULL,
  `stem` varchar(75) NOT NULL,
  `common` tinyint(1) unsigned NOT NULL DEFAULT 0,
  `phrase` tinyint(1) unsigned NOT NULL DEFAULT 0,
  `term_weight` float unsigned NOT NULL,
  `context` tinyint(1) unsigned NOT NULL DEFAULT 2,
  `context_weight` float unsigned NOT NULL,
  `total_weight` float unsigned NOT NULL,
  `language` char(3) NOT NULL DEFAULT '',
  KEY `token` (`term`),
  KEY `keyword_id` (`term_id`)
) ENGINE=MEMORY DEFAULT CHARSET=utf8;

--
-- Dumping data for table `q43qy_finder_tokens_aggregate`
--


--
-- Table structure for table `q43qy_finder_types`
--

CREATE TABLE `q43qy_finder_types` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(100) NOT NULL,
  `mime` varchar(100) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `title` (`title`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `q43qy_finder_types`
--


--
-- Table structure for table `q43qy_jomcomp_cron`
--

CREATE TABLE `q43qy_jomcomp_cron` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `job` char(100) DEFAULT NULL,
  `schedule` char(2) NOT NULL,
  `last_ran` int(12) NOT NULL,
  `parameters` varchar(255) DEFAULT NULL,
  `locked` tinyint(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `q43qy_jomcomp_cron`
--

INSERT INTO `q43qy_jomcomp_cron` (`id`, `job`, `schedule`, `last_ran`, `parameters`, `locked`) VALUES (1,'optimise','D',1413725947,'',0),(2,'invoice','D',1413725947,'',0),(3,'exchangerates','D',1413725947,'',0),(4,'subscriptions','D',1413725947,'',0);

--
-- Table structure for table `q43qy_jomcomp_cronlog`
--

CREATE TABLE `q43qy_jomcomp_cronlog` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `log_details` text DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `q43qy_jomcomp_cronlog`
--


--
-- Table structure for table `q43qy_jomcomp_extrasmodels_models`
--

CREATE TABLE `q43qy_jomcomp_extrasmodels_models` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `extra_id` int(11) DEFAULT NULL,
  `model` int(11) DEFAULT NULL,
  `params` varchar(255) DEFAULT NULL,
  `force` tinyint(1) NOT NULL DEFAULT 0,
  `property_uid` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `q43qy_jomcomp_extrasmodels_models`
--

INSERT INTO `q43qy_jomcomp_extrasmodels_models` (`id`, `extra_id`, `model`, `params`, `force`, `property_uid`) VALUES (1,1,3,'1',1,1),(2,2,4,'1',0,1),(3,3,2,'1',0,2),(4,4,2,'1',0,3),(5,5,3,'1',0,4),(6,6,2,'1',0,5),(7,7,2,'1',0,6),(8,8,4,'1',0,7),(9,9,3,'1',0,8),(11,11,3,'1',1,14),(12,12,3,'1',1,15),(13,13,3,'1',0,16),(14,14,2,'1',0,17),(15,15,2,'1',0,18),(16,16,2,'1',0,20),(19,10,3,'1',0,13),(20,17,2,'1',0,21),(21,18,2,'1',0,22),(22,19,2,'1',0,23),(23,20,2,'1',0,24);

--
-- Table structure for table `q43qy_jomcomp_mufavourites`
--

CREATE TABLE `q43qy_jomcomp_mufavourites` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `my_id` int(11) DEFAULT NULL,
  `property_uid` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `q43qy_jomcomp_mufavourites`
--


--
-- Table structure for table `q43qy_jomcomp_notes`
--

CREATE TABLE `q43qy_jomcomp_notes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `contract_uid` int(11) DEFAULT NULL,
  `note` text DEFAULT NULL,
  `timestamp` datetime DEFAULT NULL,
  `property_uid` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `q43qy_jomcomp_notes`
--


--
-- Table structure for table `q43qy_jomcomp_tarifftype_rate_xref`
--

CREATE TABLE `q43qy_jomcomp_tarifftype_rate_xref` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `tarifftype_id` int(11) NOT NULL,
  `tariff_id` int(11) NOT NULL,
  `roomclass_uid` int(11) NOT NULL,
  `property_uid` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `q43qy_jomcomp_tarifftype_rate_xref`
--


--
-- Table structure for table `q43qy_jomcomp_tarifftypes`
--

CREATE TABLE `q43qy_jomcomp_tarifftypes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` char(255) DEFAULT NULL,
  `description` varchar(3000) DEFAULT NULL,
  `property_uid` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `q43qy_jomcomp_tarifftypes`
--


--
-- Table structure for table `q43qy_jomres_access_control`
--

CREATE TABLE `q43qy_jomres_access_control` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `scriptname` varchar(255) DEFAULT NULL,
  `access_level` char(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `q43qy_jomres_access_control`
--

INSERT INTO `q43qy_jomres_access_control` (`id`, `scriptname`, `access_level`) VALUES (1,'00009user_option_03_login','registered'),(2,'00009user_option_03_logout','registered'),(3,'00009user_option_03_je_featured_properties','registered'),(4,'00009user_option_03_featured_properties','default'),(5,'00009user_option_03_search','anybody'),(6,'00009user_option_03_tag_cloud','anybody'),(7,'00009user_option_03_exchange_rate_conversion_selector','anybody'),(8,'00009user_option_03_my_account','registered'),(9,'00009user_option_03_reglink','registered'),(10,'00009user_option_01_listbookings','registered'),(11,'00009user_option_01_manual','registered'),(12,'00009user_option_01_myfavourites','registered'),(13,'00009user_option_02_addfavourite','registered'),(14,'00009user_option_03_flipwall','anybody'),(15,'00009user_option_03_funky_search_country','registered'),(16,'00009user_option_03_funky_search_features','registered'),(17,'00009user_option_03_location_map','anybody'),(18,'00009user_option_03_location_map_regions','anybody'),(19,'00009user_option_03_popular_properties','anybody'),(20,'00009user_option_03_search_features','registered'),(21,'00009user_option_03_search_selectcombo_region','registered'),(22,'00009user_option_03_search_selectcombo_region_or_town','registered'),(23,'00009user_option_03_search_tags','registered'),(24,'00009user_option_03_search_town','registered'),(25,'00009user_option_05_add_your_property','registered'),(26,'00009user_option_05_myinvoices','registered'),(27,'00010reception_option_01_home','default'),(28,'00009user_option_03_featured_listings_asamodule_1','anybody'),(29,'00009user_option_03_featured_listings_asamodule_2','anybody'),(30,'00009user_option_03_location_map_sitemap','anybody');

--
-- Table structure for table `q43qy_jomres_ajax_search_tags_blacklist`
--

CREATE TABLE `q43qy_jomres_ajax_search_tags_blacklist` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `tag` text DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `q43qy_jomres_ajax_search_tags_blacklist`
--


--
-- Table structure for table `q43qy_jomres_ajax_search_tags_tags`
--

CREATE TABLE `q43qy_jomres_ajax_search_tags_tags` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `tag` text DEFAULT NULL,
  `property_uid` int(10) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `q43qy_jomres_ajax_search_tags_tags`
--


--
-- Table structure for table `q43qy_jomres_auctionhouse_auctions`
--

CREATE TABLE `q43qy_jomres_auctionhouse_auctions` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `value` float NOT NULL DEFAULT 0,
  `reserve` float NOT NULL DEFAULT 0,
  `end_value` float NOT NULL DEFAULT 0,
  `buy_now_value` float NOT NULL DEFAULT 0,
  `start_date` datetime DEFAULT NULL,
  `end_date` datetime DEFAULT NULL,
  `property_uid` int(10) DEFAULT NULL,
  `cms_user_id` int(10) DEFAULT NULL,
  `winner_cms_user_id` int(10) DEFAULT NULL,
  `lang` char(5) DEFAULT 'en-GB',
  `blackbooking_id` int(10) DEFAULT NULL,
  `finished` tinyint(4) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `q43qy_jomres_auctionhouse_auctions`
--


--
-- Table structure for table `q43qy_jomres_auctionhouse_bids`
--

CREATE TABLE `q43qy_jomres_auctionhouse_bids` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `cms_user_id` int(10) DEFAULT NULL,
  `auction_id` int(10) DEFAULT NULL,
  `bid_value` float NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `q43qy_jomres_auctionhouse_bids`
--


--
-- Table structure for table `q43qy_jomres_auctionhouse_lists`
--

CREATE TABLE `q43qy_jomres_auctionhouse_lists` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `cms_user_id` int(10) DEFAULT NULL,
  `listname` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `q43qy_jomres_auctionhouse_lists`
--


--
-- Table structure for table `q43qy_jomres_auctionhouse_lists_auction_xref`
--

CREATE TABLE `q43qy_jomres_auctionhouse_lists_auction_xref` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `auction_id` int(10) DEFAULT NULL,
  `list_id` int(10) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `q43qy_jomres_auctionhouse_lists_auction_xref`
--


--
-- Table structure for table `q43qy_jomres_audit`
--

CREATE TABLE `q43qy_jomres_audit` (
  `uid` int(11) NOT NULL AUTO_INCREMENT,
  `date` date DEFAULT NULL,
  `time` time DEFAULT NULL,
  `owner` int(11) DEFAULT NULL,
  `op` varchar(100) DEFAULT NULL,
  `args` text DEFAULT NULL,
  `property_uid` varchar(11) DEFAULT NULL,
  PRIMARY KEY (`uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `q43qy_jomres_audit`
--


--
-- Table structure for table `q43qy_jomres_audit_archive`
--

CREATE TABLE `q43qy_jomres_audit_archive` (
  `uid` int(11) NOT NULL AUTO_INCREMENT,
  `date` date DEFAULT NULL,
  `time` time DEFAULT NULL,
  `owner` int(11) DEFAULT NULL,
  `op` varchar(100) DEFAULT NULL,
  `args` text DEFAULT NULL,
  `property_uid` varchar(11) DEFAULT NULL,
  PRIMARY KEY (`uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `q43qy_jomres_audit_archive`
--


--
-- Table structure for table `q43qy_jomres_booking_data_archive`
--

CREATE TABLE `q43qy_jomres_booking_data_archive` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `data` text DEFAULT NULL,
  `date` datetime DEFAULT NULL,
  `contract_uid` int(11) NOT NULL DEFAULT 0,
  `tag` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `q43qy_jomres_booking_data_archive`
--


--
-- Table structure for table `q43qy_jomres_countries`
--

CREATE TABLE `q43qy_jomres_countries` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `countrycode` varchar(2) DEFAULT NULL,
  `countryname` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=244 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `q43qy_jomres_countries`
--

INSERT INTO `q43qy_jomres_countries` (`id`, `countrycode`, `countryname`) VALUES (1,'AF','Afghanistan'),(2,'AL','Albania'),(3,'DZ','Algeria'),(4,'AS','Am. Samoa'),(5,'AD','Andorra'),(6,'AO','Angola'),(7,'AI','Anguilla'),(8,'AQ','Antarctica'),(9,'AG','Antigua'),(10,'AR','Argentina'),(11,'AM','Armenia'),(12,'AW','Aruba'),(13,'AU','Australia'),(14,'AT','Austria'),(15,'AZ','Azerbaijan'),(16,'IO','B. Ind. Oc. Tr.'),(17,'BS','Bahamas'),(18,'BH','Bahrain'),(19,'BD','Bangladesh'),(20,'BB','Barbados'),(21,'BY','Belarus'),(22,'BE','Belgium'),(23,'BZ','Belize'),(24,'BJ','Benin'),(25,'BM','Bermuda'),(26,'BT','Bhutan'),(27,'BO','Bolivia'),(28,'BQ','Bonaire, Sint Eustatius and Saba'),(29,'BA','Bosnia Herz'),(30,'BW','Botswana'),(31,'BV','Bouvet Is.'),(32,'BR','Brazil'),(33,'BN','Brunei'),(34,'BG','Bulgaria'),(35,'BF','Burkina Faso'),(36,'BI','Burundi'),(37,'KH','Cambodia'),(38,'CM','Cameroon'),(39,'CA','Canada'),(40,'CV','Cape Verde'),(41,'KY','Cayman Is.'),(42,'CF','Central Af. R.'),(43,'TD','Chad'),(44,'CL','Chile'),(45,'CN','China'),(46,'CX','Christmas Is.'),(47,'CC','Cocos  Is.'),(48,'CO','Colombia'),(49,'KM','Comoros'),(50,'CG','Congo'),(51,'CD','Congo D. R.'),(52,'CK','Cook Is.'),(53,'CR','Costa Rica'),(54,'CI','Cote D&#39;Ivoire'),(55,'HR','Croatia'),(56,'CU','Cuba'),(57,'CW','Curaçao'),(58,'CY','Cyprus'),(59,'CZ','Czech R.ublic'),(60,'DK','Denmark'),(61,'DJ','Djibouti'),(62,'DM','Dominica'),(63,'DO','Dominican R.'),(64,'TP','East Timor'),(65,'EC','Ecuador'),(66,'EG','Egypt'),(67,'SV','El Salvador'),(68,'GQ','Eq. Guinea'),(69,'ER','Eritrea'),(70,'EE','Estonia'),(71,'ET','Ethiopia'),(72,'FK','Falkland Is.'),(73,'FO','Faroe Is.'),(74,'FJ','Fiji'),(75,'FI','Finland'),(76,'GF','Fr. Guiana'),(77,'PF','Fr. Polynesia'),(78,'TF','Fr. S. Tr.'),(79,'FR','France'),(80,'FX','France, Metro.'),(81,'GA','Gabon'),(82,'GM','Gambia'),(83,'GE','Georgia'),(84,'DE','Germany'),(85,'GH','Ghana'),(86,'GI','Gibraltar'),(87,'GR','Greece'),(88,'GL','Greenland'),(89,'GD','Grenada'),(90,'GP','Guadeloupe'),(91,'GU','Guam'),(92,'GT','Guatemala'),(93,'GN','Guinea'),(94,'GW','Guinea-Bissau'),(95,'GY','Guyana'),(96,'HT','Haiti'),(97,'HM','Heard Is.'),(98,'HN','Honduras'),(99,'HK','Hong Kong'),(100,'HU','Hungary'),(101,'IS','Iceland'),(102,'IN','India'),(103,'ID','Indonesia'),(104,'IR','Iran'),(105,'IQ','Iraq'),(106,'IE','Ireland'),(107,'IL','Israel'),(108,'IT','Italy'),(109,'JM','Jamaica'),(110,'JP','Japan'),(111,'JO','Jordan'),(112,'KZ','Kazakstan'),(113,'KE','Kenya'),(114,'KI','Kiribati'),(115,'KP','Korea, D. R.'),(116,'KR','Korea, R.'),(117,'KW','Kuwait'),(118,'KG','Kyrgyzstan'),(119,'LA','Lao P.D. R.'),(120,'LV','Latvia'),(121,'LB','Lebanon'),(122,'LS','Lesotho'),(123,'LR','Liberia'),(124,'LY','Libyan A. J.'),(125,'LI','Liechtenstein'),(126,'LT','Lithuania'),(127,'LU','Luxembourg'),(128,'MO','Macau'),(129,'MK','Macedonia'),(130,'MG','Madagascar'),(131,'MW','Malawi'),(132,'MY','Malaysia'),(133,'MV','Maldives'),(134,'ML','Mali'),(135,'MT','Malta'),(136,'MH','Marshall Is.'),(137,'MQ','Martinique'),(138,'MR','Mauritania'),(139,'MU','Mauritius'),(140,'YT','Mayotte'),(141,'MX','Mexico'),(142,'FM','Micronesia'),(143,'MD','Moldova'),(144,'MC','Monaco'),(145,'MN','Montenegro'),(146,'MS','Montserrat'),(147,'MA','Morocco'),(148,'MZ','Mozambique'),(149,'MM','Myanmar'),(150,'MP','N. Mariana Is.'),(151,'NA','Namibia'),(152,'NR','Nauru'),(153,'NP','Nepal'),(154,'AN','Neth. Ant.'),(155,'NL','Netherlands'),(156,'NC','New Caledonia'),(157,'NZ','New Zealand'),(158,'NI','Nicaragua'),(159,'NE','Niger'),(160,'NG','Nigeria'),(161,'NU','Niue'),(162,'NF','Norfolk Is.'),(163,'NO','Norway'),(164,'OM','Oman'),(165,'PK','Pakistan'),(166,'PW','Palau'),(167,'PS','Palestinian Tr.'),(168,'PA','Panama'),(169,'PG','Pap. N. Guinea'),(170,'PY','Paraguay'),(171,'PE','Peru'),(172,'PH','Philippines'),(173,'PN','Pitcairn'),(174,'PL','Poland'),(175,'PT','Portugal'),(176,'PR','Puerto Rico'),(177,'QA','Qatar'),(178,'RE','Reunion'),(179,'RO','Romania'),(180,'RU','Russian Fed.'),(181,'RW','Rwanda'),(182,'ZA','S. Africa'),(183,'GS','S. Georgia'),(184,'WS','Samoa'),(185,'SM','San Marino'),(186,'ST','Sao Tome'),(187,'SA','Saudi Arabia'),(188,'SN','Senegal'),(189,'RS','Serbia'),(190,'SC','Seychelles'),(191,'SL','Sierra Leone'),(192,'SG','Singapore'),(193,'SK','Slovakia'),(194,'SI','Slovenia'),(195,'SB','Solomon Is.'),(196,'SO','Somalia'),(197,'ES','Spain'),(198,'LK','Sri Lanka'),(199,'SH','St. Helena'),(200,'KN','St. Kitts and Nevis'),(201,'LC','St. Lucia'),(202,'PM','St. Pierre'),(203,'VC','St. Vincent'),(204,'SD','Sudan'),(205,'SR','Suriname'),(206,'SJ','Svalbard JM'),(207,'SZ','Swaziland'),(208,'SE','Sweden'),(209,'CH','Switzerland'),(210,'SY','Syria'),(211,'TW','Taiwan'),(212,'TJ','Tajikistan'),(213,'TZ','Tanzania'),(214,'TH','Thailand'),(215,'TG','Togo'),(216,'TK','Tokelau'),(217,'TO','Tonga'),(218,'TT','Trinidad Tob.'),(219,'TN','Tunisia'),(220,'TR','Turkey'),(221,'TM','Turkmenistan'),(222,'TC','Turks Caicos Is.'),(223,'TV','Tuvalu'),(224,'UM','U. States Out. Is.'),(225,'UG','Uganda'),(226,'UA','Ukraine'),(227,'AE','United A. Emir.'),(228,'GB','United Kingdom'),(229,'US','United States'),(230,'UY','Uruguay'),(231,'UZ','Uzbekistan'),(232,'VU','Vanuatu'),(233,'VA','Vatican City'),(234,'VE','Venezuela'),(235,'VN','Vietnam'),(236,'VG','Virgin Is., British'),(237,'VI','Virgin Is., U.S.'),(238,'EH','W. Sahara'),(239,'WF','Wallis'),(240,'YE','Yemen'),(241,'ZR','Zaire'),(242,'ZM','Zambia'),(243,'ZW','Zimbabwe');

--
-- Table structure for table `q43qy_jomres_coupons`
--

CREATE TABLE `q43qy_jomres_coupons` (
  `coupon_id` int(11) NOT NULL AUTO_INCREMENT,
  `property_uid` int(11) DEFAULT NULL,
  `coupon_code` varchar(255) DEFAULT NULL,
  `valid_from` date DEFAULT NULL,
  `valid_to` date DEFAULT NULL,
  `amount` float DEFAULT NULL,
  `is_percentage` tinyint(1) DEFAULT NULL,
  `rooms_only` tinyint(1) DEFAULT NULL,
  `booking_valid_from` date DEFAULT NULL,
  `booking_valid_to` date DEFAULT NULL,
  `guest_uid` int(11) DEFAULT 0,
  PRIMARY KEY (`coupon_id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `q43qy_jomres_coupons`
--

INSERT INTO `q43qy_jomres_coupons` (`coupon_id`, `property_uid`, `coupon_code`, `valid_from`, `valid_to`, `amount`, `is_percentage`, `rooms_only`, `booking_valid_from`, `booking_valid_to`, `guest_uid`) VALUES (1,1,'test','2012-01-09','2013-01-09',20,1,NULL,'2012-01-09','2013-01-09',0),(2,2,'test','2012-01-10','2013-01-10',25,1,NULL,'2012-01-10','2013-01-10',0),(3,3,'test','2012-01-10','2013-01-10',10,1,NULL,'2012-01-10','2013-01-10',0),(4,4,'test','2012-01-11','2013-01-11',10,1,NULL,'2012-01-11','2013-01-11',0),(5,5,'test','2012-01-12','2013-01-12',10,1,NULL,'2012-01-12','2013-01-12',0),(6,6,'test','2012-01-12','2013-01-12',10,1,NULL,'2012-01-12','2013-01-12',0),(7,7,'test','2012-01-12','2013-01-12',10,1,NULL,'2012-01-12','2013-01-12',0),(8,8,'test','2012-01-12','2013-01-12',10,1,NULL,'2012-01-12','2013-01-12',0),(9,14,'test','2012-01-19','2013-01-19',10,1,NULL,'2012-01-19','2013-01-19',0),(10,15,'test','2012-01-19','2013-01-19',25,1,NULL,'2012-01-19','2013-01-19',0),(11,16,'test','2012-01-19','2013-01-19',10,1,NULL,'2012-01-19','2013-01-19',0),(12,17,'test','2012-01-19','2013-01-19',10,1,NULL,'2012-01-19','2013-01-19',0),(13,19,'test','2012-01-19','2013-01-19',10,1,NULL,'2012-01-19','2013-01-19',0),(14,22,'test','2012-01-27','2013-01-27',10,1,NULL,'2012-01-27','2013-01-27',0);

--
-- Table structure for table `q43qy_jomres_custom_fields`
--

CREATE TABLE `q43qy_jomres_custom_fields` (
  `uid` int(11) NOT NULL AUTO_INCREMENT,
  `fieldname` varchar(255) DEFAULT NULL,
  `default_value` varchar(255) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `required` tinyint(1) NOT NULL DEFAULT 0,
  `ptype_xref` text DEFAULT NULL,
  PRIMARY KEY (`uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `q43qy_jomres_custom_fields`
--


--
-- Table structure for table `q43qy_jomres_custom_property_fields_data`
--

CREATE TABLE `q43qy_jomres_custom_property_fields_data` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `fieldname` varchar(255) DEFAULT NULL,
  `data` text DEFAULT NULL,
  `property_uid` int(11) DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=73 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `q43qy_jomres_custom_property_fields_data`
--

INSERT INTO `q43qy_jomres_custom_property_fields_data` (`id`, `fieldname`, `data`, `property_uid`) VALUES (1,'bathrooms','26',1),(2,'squaremeters','572',1),(3,'rooms','24',1),(4,'sleeps','48',1),(5,'bedrooms','3',15),(6,'bathrooms','3',15),(7,'squaremeters','125',15),(8,'sleeps','6',15),(9,'bedrooms','4',16),(10,'bathrooms','3',16),(11,'squaremeters','150',16),(12,'sleeps','8',16),(13,'bathrooms','2',21),(14,'squaremeters','28',21),(15,'sleeps','5',21),(16,'berths','3',21),(17,'bathrooms','1',24),(18,'squaremeters','45',24),(19,'sleeps','4',24),(20,'berths','2',24),(21,'bathrooms','10',2),(22,'squaremeters','760',2),(23,'rooms','8',2),(24,'sleeps','16',2),(25,'bodytype','Saloon',3),(26,'gearbox','Automatic',3),(27,'seats','4',3),(28,'fuel','Diesel',3),(29,'bodytype','Coupe',4),(30,'gearbox','Manual',4),(31,'seats','2',4),(32,'fuel','Petrol',4),(33,'bathrooms','1',5),(34,'squaremeters','20',5),(35,'sleeps','4',5),(36,'berths','4',5),(37,'bathrooms','1',6),(38,'squaremeters','45',6),(39,'sleeps','5',6),(40,'berths','4',6),(41,'bedrooms','2',13),(42,'bathrooms','1',13),(43,'squaremeters','29',13),(44,'sleeps','3',13),(45,'bedrooms','2',14),(46,'bathrooms','2',14),(47,'squaremeters','37',14),(48,'sleeps','4',14),(49,'bodytype','Saloon',17),(50,'gearbox','Automatic',17),(51,'seats','4',17),(52,'fuel','Petrol',17),(53,'bodytype','Saloon',18),(54,'gearbox','Automatic',18),(55,'seats','4',18),(56,'fuel','Petrol',18),(57,'bodytype','Saloon',19),(58,'gearbox','Automatic',19),(59,'seats','4',19),(60,'fuel','Petrol',19),(61,'bodytype','Saloon',20),(62,'gearbox','Automatic',20),(63,'seats','4',20),(64,'fuel','Diesel',20),(65,'bathrooms','4',22),(66,'squaremeters','120',22),(67,'sleeps','12',22),(68,'berths','6',22),(69,'bathrooms','2',23),(70,'squaremeters','46',23),(71,'sleeps','4',23),(72,'berths','4',23);

--
-- Table structure for table `q43qy_jomres_custom_property_fields_fields`
--

CREATE TABLE `q43qy_jomres_custom_property_fields_fields` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `fieldname` varchar(255) DEFAULT NULL,
  `default_value` varchar(255) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `required` tinyint(1) NOT NULL DEFAULT 0,
  `order` int(11) DEFAULT 0,
  `ptype_xref` text DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `q43qy_jomres_custom_property_fields_fields`
--

INSERT INTO `q43qy_jomres_custom_property_fields_fields` (`id`, `fieldname`, `default_value`, `description`, `required`, `order`, `ptype_xref`) VALUES (1,'bedrooms','','Bedrooms',0,0,'a:4:{i:0;s:1:\"6\";i:1;s:1:\"7\";i:2;s:1:\"8\";i:3;s:2:\"10\";}'),(2,'bathrooms','','Bathrooms',0,0,'a:8:{i:0;s:1:\"1\";i:1;s:1:\"2\";i:2;s:1:\"4\";i:3;s:1:\"5\";i:4;s:1:\"6\";i:5;s:1:\"7\";i:6;s:1:\"8\";i:7;s:2:\"10\";}'),(3,'squaremeters','','Square meters',0,0,'a:8:{i:0;s:1:\"1\";i:1;s:1:\"2\";i:2;s:1:\"4\";i:3;s:1:\"5\";i:4;s:1:\"6\";i:5;s:1:\"7\";i:6;s:1:\"8\";i:7;s:2:\"10\";}'),(4,'rooms','','Rooms',0,0,'a:2:{i:0;s:1:\"1\";i:1;s:1:\"5\";}'),(5,'sleeps','','Sleeps',0,0,'a:7:{i:0;s:1:\"1\";i:1;s:1:\"2\";i:2;s:1:\"4\";i:3;s:1:\"5\";i:4;s:1:\"6\";i:5;s:1:\"7\";i:6;s:1:\"8\";}'),(6,'bodytype','','Bodytype',0,0,'a:1:{i:0;s:1:\"3\";}'),(7,'gearbox','','Gearbox',0,0,'a:1:{i:0;s:1:\"3\";}'),(8,'seats','','Seats',0,0,'a:1:{i:0;s:1:\"3\";}'),(9,'berths','','Berths',0,0,'a:1:{i:0;s:1:\"2\";}'),(10,'fuel','','Fuel',0,0,'a:1:{i:0;s:1:\"3\";}');

--
-- Table structure for table `q43qy_jomres_custom_templates`
--

CREATE TABLE `q43qy_jomres_custom_templates` (
  `uid` int(11) NOT NULL AUTO_INCREMENT,
  `template_name` varchar(255) DEFAULT NULL,
  `value` text DEFAULT NULL,
  `ptype_id` int(11) NOT NULL DEFAULT 0,
  `last_edited` datetime DEFAULT NULL,
  PRIMARY KEY (`uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `q43qy_jomres_custom_templates`
--


--
-- Table structure for table `q43qy_jomres_custom_text`
--

CREATE TABLE `q43qy_jomres_custom_text` (
  `uid` int(11) NOT NULL AUTO_INCREMENT,
  `constant` varchar(255) DEFAULT NULL,
  `customtext` text DEFAULT NULL,
  `property_uid` int(11) DEFAULT NULL,
  `language` varchar(255) DEFAULT NULL,
  `reserved` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`uid`)
) ENGINE=InnoDB AUTO_INCREMENT=129 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `q43qy_jomres_custom_text`
--

INSERT INTO `q43qy_jomres_custom_text` (`uid`, `constant`, `customtext`, `property_uid`, `language`, `reserved`) VALUES (1,'_JOMRES_CUSTOMTEXT_PROPERTY_STREET','34 some street',15,'en-GB',NULL),(2,'_JOMRES_CUSTOMTEXT_PROPERTY_TOWN','Torquay',15,'en-GB',NULL),(3,'_JOMRES_CUSTOMTEXT_PROPERTY_POSTCODE','65T YY7',15,'en-GB',NULL),(4,'_JOMRES_CUSTOMTEXT_ROOMTYPE_DESCRIPTION','&#60;p&#62;Lorem ipsum dolor sit amet, consectetur adipiscing elit. Suspendisse id orci mi. Curabitur tincidunt enim consectetur justo porta non venenatis risus accumsan. Ut nec tristique lectus. Sed mauris tortor, lacinia vel malesuada tristique, tempor eu tortor. Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Praesent in ligula imperdiet arcu posuere rutrum. Donec eu blandit velit. Integer elementum tempor nunc et pretium. Morbi sed ipsum tellus, sed blandit elit. Duis ligula ligula, lacinia id pharetra ut, dignissim sit amet nisi. Suspendisse turpis velit, faucibus vel tincidunt nec, ultricies ultricies arcu. Mauris malesuada eleifend elit sed mattis. Praesent elementum nunc vehicula tellus condimentum tincidunt. Duis purus ipsum, dictum in consectetur sed, scelerisque ac tellus. Sed ornare venenatis erat volutpat mattis. Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas.&#60;/p&#62;',15,'en-GB',NULL),(5,'_JOMRES_CUSTOMTEXT_ROOMTYPE_CHECKINTIMES','&#60;p&#62;Lorem ipsum dolor sit amet, consectetur adipiscing elit. Suspendisse id orci mi. Curabitur tincidunt enim consectetur justo porta non venenatis risus accumsan. Ut nec tristique lectus. Sed mauris tortor, lacinia vel malesuada tristique, tempor eu tortor. Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Praesent in ligula imperdiet arcu posuere rutrum. Donec eu blandit velit. Integer elementum tempor nunc et pretium. Morbi sed ipsum tellus, sed blandit elit. Duis ligula ligula, lacinia id pharetra ut, dignissim sit amet nisi. Suspendisse turpis velit, faucibus vel tincidunt nec, ultricies ultricies arcu. Mauris malesuada eleifend elit sed mattis. Praesent elementum nunc vehicula tellus condimentum tincidunt. Duis purus ipsum, dictum in consectetur sed, scelerisque ac tellus. Sed ornare venenatis erat volutpat mattis. Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas.&#60;/p&#62;',15,'en-GB',NULL),(6,'_JOMRES_CUSTOMTEXT_ROOMTYPE_AREAACTIVITIES','&#60;p&#62;Lorem ipsum dolor sit amet, consectetur adipiscing elit. Suspendisse id orci mi. Curabitur tincidunt enim consectetur justo porta non venenatis risus accumsan. Ut nec tristique lectus. Sed mauris tortor, lacinia vel malesuada tristique, tempor eu tortor. Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Praesent in ligula imperdiet arcu posuere rutrum. Donec eu blandit velit. Integer elementum tempor nunc et pretium. Morbi sed ipsum tellus, sed blandit elit. Duis ligula ligula, lacinia id pharetra ut, dignissim sit amet nisi. Suspendisse turpis velit, faucibus vel tincidunt nec, ultricies ultricies arcu. Mauris malesuada eleifend elit sed mattis. Praesent elementum nunc vehicula tellus condimentum tincidunt. Duis purus ipsum, dictum in consectetur sed, scelerisque ac tellus. Sed ornare venenatis erat volutpat mattis. Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas.&#60;/p&#62;',15,'en-GB',NULL),(7,'_JOMRES_CUSTOMTEXT_ROOMTYPE_DIRECTIONS','&#60;p&#62;Lorem ipsum dolor sit amet, consectetur adipiscing elit. Suspendisse id orci mi. Curabitur tincidunt enim consectetur justo porta non venenatis risus accumsan. Ut nec tristique lectus. Sed mauris tortor, lacinia vel malesuada tristique, tempor eu tortor. Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Praesent in ligula imperdiet arcu posuere rutrum. Donec eu blandit velit. Integer elementum tempor nunc et pretium. Morbi sed ipsum tellus, sed blandit elit. Duis ligula ligula, lacinia id pharetra ut, dignissim sit amet nisi. Suspendisse turpis velit, faucibus vel tincidunt nec, ultricies ultricies arcu. Mauris malesuada eleifend elit sed mattis. Praesent elementum nunc vehicula tellus condimentum tincidunt. Duis purus ipsum, dictum in consectetur sed, scelerisque ac tellus. Sed ornare venenatis erat volutpat mattis. Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas.&#60;/p&#62;',15,'en-GB',NULL),(8,'_JOMRES_CUSTOMTEXT_ROOMTYPE_AIRPORTS','&#60;p&#62;Lorem ipsum dolor sit amet, consectetur adipiscing elit. Suspendisse id orci mi. Curabitur tincidunt enim consectetur justo porta non venenatis risus accumsan. Ut nec tristique lectus. Sed mauris tortor, lacinia vel malesuada tristique, tempor eu tortor. Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Praesent in ligula imperdiet arcu posuere rutrum. Donec eu blandit velit. Integer elementum tempor nunc et pretium. Morbi sed ipsum tellus, sed blandit elit. Duis ligula ligula, lacinia id pharetra ut, dignissim sit amet nisi. Suspendisse turpis velit, faucibus vel tincidunt nec, ultricies ultricies arcu. Mauris malesuada eleifend elit sed mattis. Praesent elementum nunc vehicula tellus condimentum tincidunt. Duis purus ipsum, dictum in consectetur sed, scelerisque ac tellus. Sed ornare venenatis erat volutpat mattis. Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas.&#60;/p&#62;',15,'en-GB',NULL),(9,'_JOMRES_CUSTOMTEXT_ROOMTYPE_OTHERTRANSPORT','&#60;p&#62;Lorem ipsum dolor sit amet, consectetur adipiscing elit. Suspendisse id orci mi. Curabitur tincidunt enim consectetur justo porta non venenatis risus accumsan. Ut nec tristique lectus. Sed mauris tortor, lacinia vel malesuada tristique, tempor eu tortor. Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Praesent in ligula imperdiet arcu posuere rutrum. Donec eu blandit velit. Integer elementum tempor nunc et pretium. Morbi sed ipsum tellus, sed blandit elit. Duis ligula ligula, lacinia id pharetra ut, dignissim sit amet nisi. Suspendisse turpis velit, faucibus vel tincidunt nec, ultricies ultricies arcu. Mauris malesuada eleifend elit sed mattis. Praesent elementum nunc vehicula tellus condimentum tincidunt. Duis purus ipsum, dictum in consectetur sed, scelerisque ac tellus. Sed ornare venenatis erat volutpat mattis. Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas.&#60;/p&#62;',15,'en-GB',NULL),(10,'_JOMRES_CUSTOMTEXT_ROOMTYPE_DISCLAIMERS','&#60;p&#62;Lorem ipsum dolor sit amet, consectetur adipiscing elit. Suspendisse id orci mi. Curabitur tincidunt enim consectetur justo porta non venenatis risus accumsan. Ut nec tristique lectus. Sed mauris tortor, lacinia vel malesuada tristique, tempor eu tortor. Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Praesent in ligula imperdiet arcu posuere rutrum. Donec eu blandit velit. Integer elementum tempor nunc et pretium. Morbi sed ipsum tellus, sed blandit elit. Duis ligula ligula, lacinia id pharetra ut, dignissim sit amet nisi. Suspendisse turpis velit, faucibus vel tincidunt nec, ultricies ultricies arcu. Mauris malesuada eleifend elit sed mattis. Praesent elementum nunc vehicula tellus condimentum tincidunt. Duis purus ipsum, dictum in consectetur sed, scelerisque ac tellus. Sed ornare venenatis erat volutpat mattis. Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas.&#60;/p&#62;',15,'en-GB',NULL),(11,'_JOMRES_CUSTOMTEXT_PROPERTY_NAME','Some Villa',15,'en-GB',NULL),(12,'_JOMRES_CUSTOMTEXT_PROPERTY_STREET','45 some other street',16,'en-GB',NULL),(13,'_JOMRES_CUSTOMTEXT_PROPERTY_TOWN','Derby',16,'en-GB',NULL),(14,'_JOMRES_CUSTOMTEXT_PROPERTY_POSTCODE','YY6 U77',16,'en-GB',NULL),(15,'_JOMRES_CUSTOMTEXT_ROOMTYPE_DESCRIPTION','&#60;p&#62;Lorem ipsum dolor sit amet, consectetur adipiscing elit. Suspendisse id orci mi. Curabitur tincidunt enim consectetur justo porta non venenatis risus accumsan. Ut nec tristique lectus. Sed mauris tortor, lacinia vel malesuada tristique, tempor eu tortor. Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Praesent in ligula imperdiet arcu posuere rutrum. Donec eu blandit velit. Integer elementum tempor nunc et pretium. Morbi sed ipsum tellus, sed blandit elit. Duis ligula ligula, lacinia id pharetra ut, dignissim sit amet nisi. Suspendisse turpis velit, faucibus vel tincidunt nec, ultricies ultricies arcu. Mauris malesuada eleifend elit sed mattis. Praesent elementum nunc vehicula tellus condimentum tincidunt. Duis purus ipsum, dictum in consectetur sed, scelerisque ac tellus. Sed ornare venenatis erat volutpat mattis. Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas.&#60;/p&#62;',16,'en-GB',NULL),(16,'_JOMRES_CUSTOMTEXT_ROOMTYPE_CHECKINTIMES','&#60;p&#62;Lorem ipsum dolor sit amet, consectetur adipiscing elit. Suspendisse id orci mi. Curabitur tincidunt enim consectetur justo porta non venenatis risus accumsan. Ut nec tristique lectus. Sed mauris tortor, lacinia vel malesuada tristique, tempor eu tortor. Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Praesent in ligula imperdiet arcu posuere rutrum. Donec eu blandit velit. Integer elementum tempor nunc et pretium. Morbi sed ipsum tellus, sed blandit elit. Duis ligula ligula, lacinia id pharetra ut, dignissim sit amet nisi. Suspendisse turpis velit, faucibus vel tincidunt nec, ultricies ultricies arcu. Mauris malesuada eleifend elit sed mattis. Praesent elementum nunc vehicula tellus condimentum tincidunt. Duis purus ipsum, dictum in consectetur sed, scelerisque ac tellus. Sed ornare venenatis erat volutpat mattis. Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas.&#60;/p&#62;',16,'en-GB',NULL),(17,'_JOMRES_CUSTOMTEXT_ROOMTYPE_AREAACTIVITIES','&#60;p&#62;Lorem ipsum dolor sit amet, consectetur adipiscing elit. Suspendisse id orci mi. Curabitur tincidunt enim consectetur justo porta non venenatis risus accumsan. Ut nec tristique lectus. Sed mauris tortor, lacinia vel malesuada tristique, tempor eu tortor. Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Praesent in ligula imperdiet arcu posuere rutrum. Donec eu blandit velit. Integer elementum tempor nunc et pretium. Morbi sed ipsum tellus, sed blandit elit. Duis ligula ligula, lacinia id pharetra ut, dignissim sit amet nisi. Suspendisse turpis velit, faucibus vel tincidunt nec, ultricies ultricies arcu. Mauris malesuada eleifend elit sed mattis. Praesent elementum nunc vehicula tellus condimentum tincidunt. Duis purus ipsum, dictum in consectetur sed, scelerisque ac tellus. Sed ornare venenatis erat volutpat mattis. Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas.&#60;/p&#62;',16,'en-GB',NULL),(18,'_JOMRES_CUSTOMTEXT_ROOMTYPE_DIRECTIONS','&#60;p&#62;Lorem ipsum dolor sit amet, consectetur adipiscing elit. Suspendisse id orci mi. Curabitur tincidunt enim consectetur justo porta non venenatis risus accumsan. Ut nec tristique lectus. Sed mauris tortor, lacinia vel malesuada tristique, tempor eu tortor. Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Praesent in ligula imperdiet arcu posuere rutrum. Donec eu blandit velit. Integer elementum tempor nunc et pretium. Morbi sed ipsum tellus, sed blandit elit. Duis ligula ligula, lacinia id pharetra ut, dignissim sit amet nisi. Suspendisse turpis velit, faucibus vel tincidunt nec, ultricies ultricies arcu. Mauris malesuada eleifend elit sed mattis. Praesent elementum nunc vehicula tellus condimentum tincidunt. Duis purus ipsum, dictum in consectetur sed, scelerisque ac tellus. Sed ornare venenatis erat volutpat mattis. Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas.&#60;/p&#62;',16,'en-GB',NULL),(19,'_JOMRES_CUSTOMTEXT_ROOMTYPE_AIRPORTS','&#60;p&#62;Lorem ipsum dolor sit amet, consectetur adipiscing elit. Suspendisse id orci mi. Curabitur tincidunt enim consectetur justo porta non venenatis risus accumsan. Ut nec tristique lectus. Sed mauris tortor, lacinia vel malesuada tristique, tempor eu tortor. Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Praesent in ligula imperdiet arcu posuere rutrum. Donec eu blandit velit. Integer elementum tempor nunc et pretium. Morbi sed ipsum tellus, sed blandit elit. Duis ligula ligula, lacinia id pharetra ut, dignissim sit amet nisi. Suspendisse turpis velit, faucibus vel tincidunt nec, ultricies ultricies arcu. Mauris malesuada eleifend elit sed mattis. Praesent elementum nunc vehicula tellus condimentum tincidunt. Duis purus ipsum, dictum in consectetur sed, scelerisque ac tellus. Sed ornare venenatis erat volutpat mattis. Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas.&#60;/p&#62;',16,'en-GB',NULL),(20,'_JOMRES_CUSTOMTEXT_ROOMTYPE_OTHERTRANSPORT','&#60;p&#62;Lorem ipsum dolor sit amet, consectetur adipiscing elit. Suspendisse id orci mi. Curabitur tincidunt enim consectetur justo porta non venenatis risus accumsan. Ut nec tristique lectus. Sed mauris tortor, lacinia vel malesuada tristique, tempor eu tortor. Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Praesent in ligula imperdiet arcu posuere rutrum. Donec eu blandit velit. Integer elementum tempor nunc et pretium. Morbi sed ipsum tellus, sed blandit elit. Duis ligula ligula, lacinia id pharetra ut, dignissim sit amet nisi. Suspendisse turpis velit, faucibus vel tincidunt nec, ultricies ultricies arcu. Mauris malesuada eleifend elit sed mattis. Praesent elementum nunc vehicula tellus condimentum tincidunt. Duis purus ipsum, dictum in consectetur sed, scelerisque ac tellus. Sed ornare venenatis erat volutpat mattis. Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas.&#60;/p&#62;',16,'en-GB',NULL),(21,'_JOMRES_CUSTOMTEXT_ROOMTYPE_DISCLAIMERS','&#60;p&#62;Lorem ipsum dolor sit amet, consectetur adipiscing elit. Suspendisse id orci mi. Curabitur tincidunt enim consectetur justo porta non venenatis risus accumsan. Ut nec tristique lectus. Sed mauris tortor, lacinia vel malesuada tristique, tempor eu tortor. Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Praesent in ligula imperdiet arcu posuere rutrum. Donec eu blandit velit. Integer elementum tempor nunc et pretium. Morbi sed ipsum tellus, sed blandit elit. Duis ligula ligula, lacinia id pharetra ut, dignissim sit amet nisi. Suspendisse turpis velit, faucibus vel tincidunt nec, ultricies ultricies arcu. Mauris malesuada eleifend elit sed mattis. Praesent elementum nunc vehicula tellus condimentum tincidunt. Duis purus ipsum, dictum in consectetur sed, scelerisque ac tellus. Sed ornare venenatis erat volutpat mattis. Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas.&#60;/p&#62;',16,'en-GB',NULL),(22,'_JOMRES_CUSTOMTEXT_PROPERTY_NAME','Some Other Villa',16,'en-GB',NULL),(23,'_JOMRES_CUSTOMTEXT_PROPERTY_STREET','some port',21,'en-GB',NULL),(24,'_JOMRES_CUSTOMTEXT_PROPERTY_TOWN','Constanta',21,'en-GB',NULL),(25,'_JOMRES_CUSTOMTEXT_PROPERTY_POSTCODE','726222',21,'en-GB',NULL),(26,'_JOMRES_CUSTOMTEXT_ROOMTYPE_DESCRIPTION','&#60;p&#62;Lorem ipsum dolor sit amet, consectetur adipiscing elit. Proin posuere, nisl at porttitor dignissim, risus tortor aliquam augue, ut consectetur dui quam vitae purus. Vestibulum id tellus ligula, vel elementum est. Ut in ligula est, id lobortis justo. Mauris pretium posuere blandit. Sed suscipit orci sed ipsum interdum accumsan. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Integer eu felis sapien. Nulla ultrices dapibus dapibus. Etiam suscipit lorem et augue elementum congue. Mauris id euismod arcu. Nam commodo rhoncus urna sit amet faucibus. Phasellus sed dui mauris. Proin quis felis lectus. Sed nec nulla nulla, posuere consequat urna. Nunc porta turpis ut urna dictum gravida.&#60;/p&#62;',21,'en-GB',NULL),(27,'_JOMRES_CUSTOMTEXT_ROOMTYPE_CHECKINTIMES','&#60;p&#62;Lorem ipsum dolor sit amet, consectetur adipiscing elit. Proin posuere, nisl at porttitor dignissim, risus tortor aliquam augue, ut consectetur dui quam vitae purus. Vestibulum id tellus ligula, vel elementum est. Ut in ligula est, id lobortis justo. Mauris pretium posuere blandit. Sed suscipit orci sed ipsum interdum accumsan. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Integer eu felis sapien. Nulla ultrices dapibus dapibus. Etiam suscipit lorem et augue elementum congue. Mauris id euismod arcu. Nam commodo rhoncus urna sit amet faucibus. Phasellus sed dui mauris. Proin quis felis lectus. Sed nec nulla nulla, posuere consequat urna. Nunc porta turpis ut urna dictum gravida.&#60;/p&#62;',21,'en-GB',NULL),(28,'_JOMRES_CUSTOMTEXT_ROOMTYPE_AREAACTIVITIES','&#60;p&#62;Lorem ipsum dolor sit amet, consectetur adipiscing elit. Proin posuere, nisl at porttitor dignissim, risus tortor aliquam augue, ut consectetur dui quam vitae purus. Vestibulum id tellus ligula, vel elementum est. Ut in ligula est, id lobortis justo. Mauris pretium posuere blandit. Sed suscipit orci sed ipsum interdum accumsan. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Integer eu felis sapien. Nulla ultrices dapibus dapibus. Etiam suscipit lorem et augue elementum congue. Mauris id euismod arcu. Nam commodo rhoncus urna sit amet faucibus. Phasellus sed dui mauris. Proin quis felis lectus. Sed nec nulla nulla, posuere consequat urna. Nunc porta turpis ut urna dictum gravida.&#60;/p&#62;',21,'en-GB',NULL),(29,'_JOMRES_CUSTOMTEXT_ROOMTYPE_DIRECTIONS','&#60;p&#62;Lorem ipsum dolor sit amet, consectetur adipiscing elit. Proin posuere, nisl at porttitor dignissim, risus tortor aliquam augue, ut consectetur dui quam vitae purus. Vestibulum id tellus ligula, vel elementum est. Ut in ligula est, id lobortis justo. Mauris pretium posuere blandit. Sed suscipit orci sed ipsum interdum accumsan. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Integer eu felis sapien. Nulla ultrices dapibus dapibus. Etiam suscipit lorem et augue elementum congue. Mauris id euismod arcu. Nam commodo rhoncus urna sit amet faucibus. Phasellus sed dui mauris. Proin quis felis lectus. Sed nec nulla nulla, posuere consequat urna. Nunc porta turpis ut urna dictum gravida.&#60;/p&#62;',21,'en-GB',NULL),(30,'_JOMRES_CUSTOMTEXT_ROOMTYPE_AIRPORTS','&#60;p&#62;Lorem ipsum dolor sit amet, consectetur adipiscing elit. Proin posuere, nisl at porttitor dignissim, risus tortor aliquam augue, ut consectetur dui quam vitae purus. Vestibulum id tellus ligula, vel elementum est. Ut in ligula est, id lobortis justo. Mauris pretium posuere blandit. Sed suscipit orci sed ipsum interdum accumsan. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Integer eu felis sapien. Nulla ultrices dapibus dapibus. Etiam suscipit lorem et augue elementum congue. Mauris id euismod arcu. Nam commodo rhoncus urna sit amet faucibus. Phasellus sed dui mauris. Proin quis felis lectus. Sed nec nulla nulla, posuere consequat urna. Nunc porta turpis ut urna dictum gravida.&#60;/p&#62;',21,'en-GB',NULL),(31,'_JOMRES_CUSTOMTEXT_ROOMTYPE_OTHERTRANSPORT','&#60;p&#62;Lorem ipsum dolor sit amet, consectetur adipiscing elit. Proin posuere, nisl at porttitor dignissim, risus tortor aliquam augue, ut consectetur dui quam vitae purus. Vestibulum id tellus ligula, vel elementum est. Ut in ligula est, id lobortis justo. Mauris pretium posuere blandit. Sed suscipit orci sed ipsum interdum accumsan. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Integer eu felis sapien. Nulla ultrices dapibus dapibus. Etiam suscipit lorem et augue elementum congue. Mauris id euismod arcu. Nam commodo rhoncus urna sit amet faucibus. Phasellus sed dui mauris. Proin quis felis lectus. Sed nec nulla nulla, posuere consequat urna. Nunc porta turpis ut urna dictum gravida.&#60;/p&#62;',21,'en-GB',NULL),(32,'_JOMRES_CUSTOMTEXT_ROOMTYPE_DISCLAIMERS','&#60;p&#62;Lorem ipsum dolor sit amet, consectetur adipiscing elit. Proin posuere, nisl at porttitor dignissim, risus tortor aliquam augue, ut consectetur dui quam vitae purus. Vestibulum id tellus ligula, vel elementum est. Ut in ligula est, id lobortis justo. Mauris pretium posuere blandit. Sed suscipit orci sed ipsum interdum accumsan. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Integer eu felis sapien. Nulla ultrices dapibus dapibus. Etiam suscipit lorem et augue elementum congue. Mauris id euismod arcu. Nam commodo rhoncus urna sit amet faucibus. Phasellus sed dui mauris. Proin quis felis lectus. Sed nec nulla nulla, posuere consequat urna. Nunc porta turpis ut urna dictum gravida.&#60;/p&#62;',21,'en-GB',NULL),(33,'_JOMRES_CUSTOMTEXT_PROPERTY_NAME','Ferretti 212',21,'en-GB',NULL),(34,'_JOMRES_CUSTOMTEXT_PROPERTY_STREET','some port',24,'en-GB',NULL),(35,'_JOMRES_CUSTOMTEXT_PROPERTY_TOWN','Amsterdam',24,'en-GB',NULL),(36,'_JOMRES_CUSTOMTEXT_PROPERTY_POSTCODE','343443',24,'en-GB',NULL),(37,'_JOMRES_CUSTOMTEXT_ROOMTYPE_DESCRIPTION','&#60;p&#62;Lorem ipsum dolor sit amet, consectetur adipiscing elit. Proin posuere, nisl at porttitor dignissim, risus tortor aliquam augue, ut consectetur dui quam vitae purus. Vestibulum id tellus ligula, vel elementum est. Ut in ligula est, id lobortis justo. Mauris pretium posuere blandit. Sed suscipit orci sed ipsum interdum accumsan. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Integer eu felis sapien. Nulla ultrices dapibus dapibus. Etiam suscipit lorem et augue elementum congue. Mauris id euismod arcu. Nam commodo rhoncus urna sit amet faucibus. Phasellus sed dui mauris. Proin quis felis lectus. Sed nec nulla nulla, posuere consequat urna. Nunc porta turpis ut urna dictum gravida.&#60;/p&#62;',24,'en-GB',NULL),(38,'_JOMRES_CUSTOMTEXT_ROOMTYPE_CHECKINTIMES','&#60;p&#62;Lorem ipsum dolor sit amet, consectetur adipiscing elit. Proin posuere, nisl at porttitor dignissim, risus tortor aliquam augue, ut consectetur dui quam vitae purus. Vestibulum id tellus ligula, vel elementum est. Ut in ligula est, id lobortis justo. Mauris pretium posuere blandit. Sed suscipit orci sed ipsum interdum accumsan. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Integer eu felis sapien. Nulla ultrices dapibus dapibus. Etiam suscipit lorem et augue elementum congue. Mauris id euismod arcu. Nam commodo rhoncus urna sit amet faucibus. Phasellus sed dui mauris. Proin quis felis lectus. Sed nec nulla nulla, posuere consequat urna. Nunc porta turpis ut urna dictum gravida.&#60;/p&#62;',24,'en-GB',NULL),(39,'_JOMRES_CUSTOMTEXT_ROOMTYPE_AREAACTIVITIES','&#60;p&#62;Lorem ipsum dolor sit amet, consectetur adipiscing elit. Proin posuere, nisl at porttitor dignissim, risus tortor aliquam augue, ut consectetur dui quam vitae purus. Vestibulum id tellus ligula, vel elementum est. Ut in ligula est, id lobortis justo. Mauris pretium posuere blandit. Sed suscipit orci sed ipsum interdum accumsan. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Integer eu felis sapien. Nulla ultrices dapibus dapibus. Etiam suscipit lorem et augue elementum congue. Mauris id euismod arcu. Nam commodo rhoncus urna sit amet faucibus. Phasellus sed dui mauris. Proin quis felis lectus. Sed nec nulla nulla, posuere consequat urna. Nunc porta turpis ut urna dictum gravida.&#60;/p&#62;',24,'en-GB',NULL),(40,'_JOMRES_CUSTOMTEXT_ROOMTYPE_DIRECTIONS','&#60;p&#62;Lorem ipsum dolor sit amet, consectetur adipiscing elit. Proin posuere, nisl at porttitor dignissim, risus tortor aliquam augue, ut consectetur dui quam vitae purus. Vestibulum id tellus ligula, vel elementum est. Ut in ligula est, id lobortis justo. Mauris pretium posuere blandit. Sed suscipit orci sed ipsum interdum accumsan. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Integer eu felis sapien. Nulla ultrices dapibus dapibus. Etiam suscipit lorem et augue elementum congue. Mauris id euismod arcu. Nam commodo rhoncus urna sit amet faucibus. Phasellus sed dui mauris. Proin quis felis lectus. Sed nec nulla nulla, posuere consequat urna. Nunc porta turpis ut urna dictum gravida.&#60;/p&#62;',24,'en-GB',NULL),(41,'_JOMRES_CUSTOMTEXT_ROOMTYPE_AIRPORTS','&#60;p&#62;Lorem ipsum dolor sit amet, consectetur adipiscing elit. Proin posuere, nisl at porttitor dignissim, risus tortor aliquam augue, ut consectetur dui quam vitae purus. Vestibulum id tellus ligula, vel elementum est. Ut in ligula est, id lobortis justo. Mauris pretium posuere blandit. Sed suscipit orci sed ipsum interdum accumsan. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Integer eu felis sapien. Nulla ultrices dapibus dapibus. Etiam suscipit lorem et augue elementum congue. Mauris id euismod arcu. Nam commodo rhoncus urna sit amet faucibus. Phasellus sed dui mauris. Proin quis felis lectus. Sed nec nulla nulla, posuere consequat urna. Nunc porta turpis ut urna dictum gravida.&#60;/p&#62;',24,'en-GB',NULL),(42,'_JOMRES_CUSTOMTEXT_ROOMTYPE_OTHERTRANSPORT','&#60;p&#62;Lorem ipsum dolor sit amet, consectetur adipiscing elit. Proin posuere, nisl at porttitor dignissim, risus tortor aliquam augue, ut consectetur dui quam vitae purus. Vestibulum id tellus ligula, vel elementum est. Ut in ligula est, id lobortis justo. Mauris pretium posuere blandit. Sed suscipit orci sed ipsum interdum accumsan. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Integer eu felis sapien. Nulla ultrices dapibus dapibus. Etiam suscipit lorem et augue elementum congue. Mauris id euismod arcu. Nam commodo rhoncus urna sit amet faucibus. Phasellus sed dui mauris. Proin quis felis lectus. Sed nec nulla nulla, posuere consequat urna. Nunc porta turpis ut urna dictum gravida.&#60;/p&#62;',24,'en-GB',NULL),(43,'_JOMRES_CUSTOMTEXT_ROOMTYPE_DISCLAIMERS','&#60;p&#62;Lorem ipsum dolor sit amet, consectetur adipiscing elit. Proin posuere, nisl at porttitor dignissim, risus tortor aliquam augue, ut consectetur dui quam vitae purus. Vestibulum id tellus ligula, vel elementum est. Ut in ligula est, id lobortis justo. Mauris pretium posuere blandit. Sed suscipit orci sed ipsum interdum accumsan. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Integer eu felis sapien. Nulla ultrices dapibus dapibus. Etiam suscipit lorem et augue elementum congue. Mauris id euismod arcu. Nam commodo rhoncus urna sit amet faucibus. Phasellus sed dui mauris. Proin quis felis lectus. Sed nec nulla nulla, posuere consequat urna. Nunc porta turpis ut urna dictum gravida.&#60;/p&#62;',24,'en-GB',NULL),(44,'_JOMRES_CUSTOMTEXT_PROPERTY_NAME','Commercial Boat',24,'en-GB',NULL),(45,'CUSTOM_PROPERTY_FIELD_DATA_bathrooms_1','26',1,'en-GB',NULL),(46,'CUSTOM_PROPERTY_FIELD_DATA_squaremeters_1','572',1,'en-GB',NULL),(47,'CUSTOM_PROPERTY_FIELD_DATA_rooms_1','24',1,'en-GB',NULL),(48,'CUSTOM_PROPERTY_FIELD_DATA_sleeps_1','48',1,'en-GB',NULL),(49,'CUSTOM_PROPERTY_FIELD_DATA_bedrooms_15','3',15,'en-GB',NULL),(50,'CUSTOM_PROPERTY_FIELD_DATA_bathrooms_15','3',15,'en-GB',NULL),(51,'CUSTOM_PROPERTY_FIELD_DATA_squaremeters_15','125',15,'en-GB',NULL),(52,'CUSTOM_PROPERTY_FIELD_DATA_sleeps_15','6',15,'en-GB',NULL),(53,'CUSTOM_PROPERTY_FIELD_DATA_bedrooms_16','4',16,'en-GB',NULL),(54,'CUSTOM_PROPERTY_FIELD_DATA_bathrooms_16','3',16,'en-GB',NULL),(55,'CUSTOM_PROPERTY_FIELD_DATA_squaremeters_16','150',16,'en-GB',NULL),(56,'CUSTOM_PROPERTY_FIELD_DATA_sleeps_16','8',16,'en-GB',NULL),(57,'CUSTOM_PROPERTY_FIELD_DATA_bathrooms_21','2',21,'en-GB',NULL),(58,'CUSTOM_PROPERTY_FIELD_DATA_squaremeters_21','28',21,'en-GB',NULL),(59,'CUSTOM_PROPERTY_FIELD_DATA_sleeps_21','5',21,'en-GB',NULL),(60,'CUSTOM_PROPERTY_FIELD_DATA_berths_21','3',21,'en-GB',NULL),(61,'CUSTOM_PROPERTY_FIELD_DATA_bathrooms_24','1',24,'en-GB',NULL),(62,'CUSTOM_PROPERTY_FIELD_DATA_squaremeters_24','45',24,'en-GB',NULL),(63,'CUSTOM_PROPERTY_FIELD_DATA_sleeps_24','4',24,'en-GB',NULL),(64,'CUSTOM_PROPERTY_FIELD_DATA_berths_24','2',24,'en-GB',NULL),(65,'CUSTOM_PROPERTY_FIELD_DATA_bathrooms_2','10',2,'en-GB',NULL),(66,'CUSTOM_PROPERTY_FIELD_DATA_squaremeters_2','760',2,'en-GB',NULL),(67,'CUSTOM_PROPERTY_FIELD_DATA_rooms_2','8',2,'en-GB',NULL),(68,'CUSTOM_PROPERTY_FIELD_DATA_sleeps_2','16',2,'en-GB',NULL),(69,'CUSTOM_PROPERTY_FIELD_DATA_bodytype_3','Saloon',3,'en-GB',NULL),(70,'CUSTOM_PROPERTY_FIELD_DATA_gearbox_3','Automatic',3,'en-GB',NULL),(71,'CUSTOM_PROPERTY_FIELD_DATA_seats_3','4',3,'en-GB',NULL),(72,'CUSTOM_PROPERTY_FIELD_DATA_fuel_3','Diesel',3,'en-GB',NULL),(73,'CUSTOM_PROPERTY_FIELD_DATA_bodytype_4','Coupe',4,'en-GB',NULL),(74,'CUSTOM_PROPERTY_FIELD_DATA_gearbox_4','Manual',4,'en-GB',NULL),(75,'CUSTOM_PROPERTY_FIELD_DATA_seats_4','2',4,'en-GB',NULL),(76,'CUSTOM_PROPERTY_FIELD_DATA_fuel_4','Petrol',4,'en-GB',NULL),(77,'CUSTOM_PROPERTY_FIELD_DATA_bathrooms_5','1',5,'en-GB',NULL),(78,'CUSTOM_PROPERTY_FIELD_DATA_squaremeters_5','20',5,'en-GB',NULL),(79,'CUSTOM_PROPERTY_FIELD_DATA_sleeps_5','4',5,'en-GB',NULL),(80,'CUSTOM_PROPERTY_FIELD_DATA_berths_5','4',5,'en-GB',NULL),(81,'CUSTOM_PROPERTY_FIELD_DATA_bathrooms_6','1',6,'en-GB',NULL),(82,'CUSTOM_PROPERTY_FIELD_DATA_squaremeters_6','45',6,'en-GB',NULL),(83,'CUSTOM_PROPERTY_FIELD_DATA_sleeps_6','5',6,'en-GB',NULL),(84,'CUSTOM_PROPERTY_FIELD_DATA_berths_6','4',6,'en-GB',NULL),(85,'CUSTOM_PROPERTY_FIELD_DATA_bedrooms_13','2',13,'en-GB',NULL),(86,'CUSTOM_PROPERTY_FIELD_DATA_bathrooms_13','1',13,'en-GB',NULL),(87,'CUSTOM_PROPERTY_FIELD_DATA_squaremeters_13','29',13,'en-GB',NULL),(88,'CUSTOM_PROPERTY_FIELD_DATA_sleeps_13','3',13,'en-GB',NULL),(89,'CUSTOM_PROPERTY_FIELD_DATA_bedrooms_14','2',14,'en-GB',NULL),(90,'CUSTOM_PROPERTY_FIELD_DATA_bathrooms_14','2',14,'en-GB',NULL),(91,'CUSTOM_PROPERTY_FIELD_DATA_squaremeters_14','37',14,'en-GB',NULL),(92,'CUSTOM_PROPERTY_FIELD_DATA_sleeps_14','4',14,'en-GB',NULL),(93,'CUSTOM_PROPERTY_FIELD_DATA_bodytype_17','Saloon',17,'en-GB',NULL),(94,'CUSTOM_PROPERTY_FIELD_DATA_gearbox_17','Automatic',17,'en-GB',NULL),(95,'CUSTOM_PROPERTY_FIELD_DATA_seats_17','4',17,'en-GB',NULL),(96,'CUSTOM_PROPERTY_FIELD_DATA_fuel_17','Petrol',17,'en-GB',NULL),(97,'CUSTOM_PROPERTY_FIELD_DATA_bodytype_18','Saloon',18,'en-GB',NULL),(98,'CUSTOM_PROPERTY_FIELD_DATA_gearbox_18','Automatic',18,'en-GB',NULL),(99,'CUSTOM_PROPERTY_FIELD_DATA_seats_18','4',18,'en-GB',NULL),(100,'CUSTOM_PROPERTY_FIELD_DATA_fuel_18','Petrol',18,'en-GB',NULL),(101,'CUSTOM_PROPERTY_FIELD_DATA_bodytype_19','Saloon',19,'en-GB',NULL),(102,'CUSTOM_PROPERTY_FIELD_DATA_gearbox_19','Automatic',19,'en-GB',NULL),(103,'CUSTOM_PROPERTY_FIELD_DATA_seats_19','4',19,'en-GB',NULL),(104,'CUSTOM_PROPERTY_FIELD_DATA_fuel_19','Petrol',19,'en-GB',NULL),(105,'CUSTOM_PROPERTY_FIELD_DATA_bodytype_20','Saloon',20,'en-GB',NULL),(106,'CUSTOM_PROPERTY_FIELD_DATA_gearbox_20','Automatic',20,'en-GB',NULL),(107,'CUSTOM_PROPERTY_FIELD_DATA_seats_20','4',20,'en-GB',NULL),(108,'CUSTOM_PROPERTY_FIELD_DATA_fuel_20','Diesel',20,'en-GB',NULL),(109,'CUSTOM_PROPERTY_FIELD_DATA_bathrooms_22','4',22,'en-GB',NULL),(110,'CUSTOM_PROPERTY_FIELD_DATA_squaremeters_22','120',22,'en-GB',NULL),(111,'CUSTOM_PROPERTY_FIELD_DATA_sleeps_22','12',22,'en-GB',NULL),(112,'CUSTOM_PROPERTY_FIELD_DATA_berths_22','6',22,'en-GB',NULL),(113,'CUSTOM_PROPERTY_FIELD_DATA_bathrooms_23','2',23,'en-GB',NULL),(114,'CUSTOM_PROPERTY_FIELD_DATA_squaremeters_23','46',23,'en-GB',NULL),(115,'CUSTOM_PROPERTY_FIELD_DATA_sleeps_23','4',23,'en-GB',NULL),(116,'CUSTOM_PROPERTY_FIELD_DATA_berths_23','4',23,'en-GB',NULL),(117,'_JOMRES_CUSTOMTEXT_PROPERTY_STREET','99 some nice street',11,'en-GB',NULL),(118,'_JOMRES_CUSTOMTEXT_PROPERTY_TOWN','Manchester',11,'en-GB',NULL),(119,'_JOMRES_CUSTOMTEXT_PROPERTY_POSTCODE','TG5 YY6',11,'en-GB',NULL),(120,'_JOMRES_CUSTOMTEXT_ROOMTYPE_DESCRIPTION','&#60;p&#62;Lorem ipsum dolor sit amet, consectetur adipiscing elit. Proin posuere, nisl at porttitor dignissim, risus tortor aliquam augue, ut consectetur dui quam vitae purus. Vestibulum id tellus ligula, vel elementum est. Ut in ligula est, id lobortis justo. Mauris pretium posuere blandit. Sed suscipit orci sed ipsum interdum accumsan. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Integer eu felis sapien. Nulla ultrices dapibus dapibus. Etiam suscipit lorem et augue elementum congue. Mauris id euismod arcu. Nam commodo rhoncus urna sit amet faucibus. Phasellus sed dui mauris. Proin quis felis lectus. Sed nec nulla nulla, posuere consequat urna. Nunc porta turpis ut urna dictum gravida.&#60;/p&#62;',11,'en-GB',NULL),(121,'_JOMRES_CUSTOMTEXT_ROOMTYPE_DISCLAIMERS','&#60;p&#62;Lorem ipsum dolor sit amet, consectetur adipiscing elit. Proin posuere, nisl at porttitor dignissim, risus tortor aliquam augue, ut consectetur dui quam vitae purus. Vestibulum id tellus ligula, vel elementum est. Ut in ligula est, id lobortis justo. Mauris pretium posuere blandit. Sed suscipit orci sed ipsum interdum accumsan. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Integer eu felis sapien. Nulla ultrices dapibus dapibus. Etiam suscipit lorem et augue elementum congue. Mauris id euismod arcu. Nam commodo rhoncus urna sit amet faucibus. Phasellus sed dui mauris. Proin quis felis lectus. Sed nec nulla nulla, posuere consequat urna. Nunc porta turpis ut urna dictum gravida.&#60;/p&#62;',11,'en-GB',NULL),(122,'_JOMRES_CUSTOMTEXT_PROPERTY_NAME','2 Bedrooms Flat',11,'en-GB',NULL),(123,'_JOMRES_CUSTOMTEXT_PROPERTY_STREET','55 some street',12,'en-GB',NULL),(124,'_JOMRES_CUSTOMTEXT_PROPERTY_TOWN','Southampton',12,'en-GB',NULL),(125,'_JOMRES_CUSTOMTEXT_PROPERTY_POSTCODE','YY7 HG6',12,'en-GB',NULL),(126,'_JOMRES_CUSTOMTEXT_ROOMTYPE_DESCRIPTION','&#60;p&#62;Lorem ipsum dolor sit amet, consectetur adipiscing elit. Proin posuere, nisl at porttitor dignissim, risus tortor aliquam augue, ut consectetur dui quam vitae purus. Vestibulum id tellus ligula, vel elementum est. Ut in ligula est, id lobortis justo. Mauris pretium posuere blandit. Sed suscipit orci sed ipsum interdum accumsan. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Integer eu felis sapien. Nulla ultrices dapibus dapibus. Etiam suscipit lorem et augue elementum congue. Mauris id euismod arcu. Nam commodo rhoncus urna sit amet faucibus. Phasellus sed dui mauris. Proin quis felis lectus. Sed nec nulla nulla, posuere consequat urna. Nunc porta turpis ut urna dictum gravida.&#60;/p&#62;',12,'en-GB',NULL),(127,'_JOMRES_CUSTOMTEXT_ROOMTYPE_DISCLAIMERS','&#60;p&#62;Lorem ipsum dolor sit amet, consectetur adipiscing elit. Proin posuere, nisl at porttitor dignissim, risus tortor aliquam augue, ut consectetur dui quam vitae purus. Vestibulum id tellus ligula, vel elementum est. Ut in ligula est, id lobortis justo. Mauris pretium posuere blandit. Sed suscipit orci sed ipsum interdum accumsan. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Integer eu felis sapien. Nulla ultrices dapibus dapibus. Etiam suscipit lorem et augue elementum congue. Mauris id euismod arcu. Nam commodo rhoncus urna sit amet faucibus. Phasellus sed dui mauris. Proin quis felis lectus. Sed nec nulla nulla, posuere consequat urna. Nunc porta turpis ut urna dictum gravida.&#60;/p&#62;',12,'en-GB',NULL),(128,'_JOMRES_CUSTOMTEXT_PROPERTY_NAME','9 Bedrooms House',12,'en-GB',NULL);

--
