--
-- Host: localhost    Database: fencesau_database
-- ------------------------------------------------------


--
-- Current Database: `fencesau_database`
--


--
-- Table structure for table `jos_ak_acl`
--

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

--
-- Dumping data for table `jos_ak_acl`
--


--
-- Table structure for table `jos_ak_profiles`
--

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

--
-- Dumping data for table `jos_ak_profiles`
--

INSERT INTO `jos_ak_profiles` (`id`, `description`, `configuration`, `filters`) VALUES (1,'Default Backup Profile','###AES128###[BLOB]','');

--
-- Table structure for table `jos_ak_stats`
--

CREATE TABLE `jos_ak_stats` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `description` varchar(255) NOT NULL,
  `comment` longtext,
  `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,
  `absolute_path` longtext,
  `multipart` int(11) NOT NULL DEFAULT '0',
  `tag` 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=3 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `jos_ak_stats`
--

INSERT INTO `jos_ak_stats` (`id`, `description`, `comment`, `backupstart`, `backupend`, `status`, `origin`, `type`, `profile_id`, `archivename`, `absolute_path`, `multipart`, `tag`, `filesexist`, `remote_filename`, `total_size`) VALUES (1,'Backup taken on Wednesday, 25 July 2012 00:49','','2012-07-24 12:49:49','0000-00-00 00:00:00','complete','backend','full',1,'site-www.fencesauckland.co.nz-20120725-004949.zip','/home/fencesau/public_html/administrator/components/com_akeeba/backup/site-www.fencesauckland.co.nz-20120725-004949.zip',0,'backend',0,NULL,0),(2,'Backup taken on Monday, 03 June 2013 00:49','','2013-06-02 12:49:56','2013-06-02 12:50:47','complete','backend','full',1,'site-fencesauckland.co.nz-20130603-004956.zip','C:/HostingSpaces/psr029/fencesauckland.co.nz/wwwroot/administrator/components/com_akeeba/backup/site-fencesauckland.co.nz-20130603-004956.zip',1,'backend',1,NULL,9517199);

--
-- Table structure for table `jos_ak_storage`
--

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

--
-- Dumping data for table `jos_ak_storage`
--


--
-- Table structure for table `jos_banner`
--

CREATE TABLE `jos_banner` (
  `bid` int(11) NOT NULL AUTO_INCREMENT,
  `cid` int(11) NOT NULL DEFAULT '0',
  `type` varchar(30) NOT NULL DEFAULT 'banner',
  `name` varchar(255) NOT NULL DEFAULT '',
  `alias` varchar(255) NOT NULL DEFAULT '',
  `imptotal` int(11) NOT NULL DEFAULT '0',
  `impmade` int(11) NOT NULL DEFAULT '0',
  `clicks` int(11) NOT NULL DEFAULT '0',
  `imageurl` varchar(100) NOT NULL DEFAULT '',
  `clickurl` varchar(200) NOT NULL DEFAULT '',
  `date` datetime DEFAULT NULL,
  `showBanner` tinyint(1) NOT NULL DEFAULT '0',
  `checked_out` tinyint(1) NOT NULL DEFAULT '0',
  `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `editor` varchar(50) DEFAULT NULL,
  `custombannercode` text,
  `catid` int(10) unsigned NOT NULL DEFAULT '0',
  `description` text NOT NULL,
  `sticky` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `ordering` int(11) NOT NULL DEFAULT '0',
  `publish_up` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `publish_down` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `tags` text NOT NULL,
  `params` text NOT NULL,
  PRIMARY KEY (`bid`),
  KEY `viewbanner` (`showBanner`),
  KEY `idx_banner_catid` (`catid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `jos_banner`
--


--
-- Table structure for table `jos_bannerclient`
--

CREATE TABLE `jos_bannerclient` (
  `cid` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL DEFAULT '',
  `contact` varchar(255) NOT NULL DEFAULT '',
  `email` varchar(255) NOT NULL DEFAULT '',
  `extrainfo` text NOT NULL,
  `checked_out` tinyint(1) NOT NULL DEFAULT '0',
  `checked_out_time` time DEFAULT NULL,
  `editor` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`cid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `jos_bannerclient`
--


--
-- Table structure for table `jos_bannertrack`
--

CREATE TABLE `jos_bannertrack` (
  `track_date` date NOT NULL,
  `track_type` int(10) unsigned NOT NULL,
  `banner_id` int(10) unsigned NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `jos_bannertrack`
--


--
-- Table structure for table `jos_categories`
--

CREATE TABLE `jos_categories` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `parent_id` int(11) NOT NULL DEFAULT '0',
  `title` varchar(255) NOT NULL DEFAULT '',
  `name` varchar(255) NOT NULL DEFAULT '',
  `alias` varchar(255) NOT NULL DEFAULT '',
  `image` varchar(255) NOT NULL DEFAULT '',
  `section` varchar(50) NOT NULL DEFAULT '',
  `image_position` varchar(30) NOT NULL DEFAULT '',
  `description` text NOT NULL,
  `published` tinyint(1) NOT NULL DEFAULT '0',
  `checked_out` int(11) unsigned NOT NULL DEFAULT '0',
  `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `editor` varchar(50) DEFAULT NULL,
  `ordering` int(11) NOT NULL DEFAULT '0',
  `access` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `count` int(11) NOT NULL DEFAULT '0',
  `params` text NOT NULL,
  PRIMARY KEY (`id`),
  KEY `cat_idx` (`section`,`published`,`access`),
  KEY `idx_access` (`access`),
  KEY `idx_checkout` (`checked_out`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `jos_categories`
--

INSERT INTO `jos_categories` (`id`, `parent_id`, `title`, `name`, `alias`, `image`, `section`, `image_position`, `description`, `published`, `checked_out`, `checked_out_time`, `editor`, `ordering`, `access`, `count`, `params`) VALUES (1,0,'Articles','','articles','','1','left','',1,0,'0000-00-00 00:00:00',NULL,1,0,0,''),(2,0,'Articles','','articles','','1','left','',1,0,'0000-00-00 00:00:00',NULL,2,0,0,''),(3,0,'Carousel','','carousel','','1','left','',1,0,'0000-00-00 00:00:00',NULL,3,0,0,''),(4,0,'General','','general','','com_contact_details','left','',1,0,'0000-00-00 00:00:00',NULL,1,0,0,'');

--
-- Table structure for table `jos_components`
--

CREATE TABLE `jos_components` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL DEFAULT '',
  `link` varchar(255) NOT NULL DEFAULT '',
  `menuid` int(11) unsigned NOT NULL DEFAULT '0',
  `parent` int(11) unsigned NOT NULL DEFAULT '0',
  `admin_menu_link` varchar(255) NOT NULL DEFAULT '',
  `admin_menu_alt` varchar(255) NOT NULL DEFAULT '',
  `option` varchar(50) NOT NULL DEFAULT '',
  `ordering` int(11) NOT NULL DEFAULT '0',
  `admin_menu_img` varchar(255) NOT NULL DEFAULT '',
  `iscore` tinyint(4) NOT NULL DEFAULT '0',
  `params` text NOT NULL,
  `enabled` tinyint(4) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  KEY `parent_option` (`parent`,`option`(32))
) ENGINE=MyISAM AUTO_INCREMENT=39 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `jos_components`
--

INSERT INTO `jos_components` (`id`, `name`, `link`, `menuid`, `parent`, `admin_menu_link`, `admin_menu_alt`, `option`, `ordering`, `admin_menu_img`, `iscore`, `params`, `enabled`) VALUES (1,'Banners','',0,0,'','Banner Management','com_banners',0,'js/ThemeOffice/component.png',0,'track_impressions=0\ntrack_clicks=0\ntag_prefix=\n\n',1),(2,'Banners','',0,1,'option=com_banners','Active Banners','com_banners',1,'js/ThemeOffice/edit.png',0,'',1),(3,'Clients','',0,1,'option=com_banners&c=client','Manage Clients','com_banners',2,'js/ThemeOffice/categories.png',0,'',1),(4,'Web Links','option=com_weblinks',0,0,'','Manage Weblinks','com_weblinks',0,'js/ThemeOffice/component.png',0,'show_comp_description=1\ncomp_description=\nshow_link_hits=1\nshow_link_description=1\nshow_other_cats=1\nshow_headings=1\nshow_page_title=1\nlink_target=0\nlink_icons=\n\n',1),(5,'Links','',0,4,'option=com_weblinks','View existing weblinks','com_weblinks',1,'js/ThemeOffice/edit.png',0,'',1),(6,'Categories','',0,4,'option=com_categories&section=com_weblinks','Manage weblink categories','',2,'js/ThemeOffice/categories.png',0,'',1),(7,'Contacts','option=com_contact',0,0,'','Edit contact details','com_contact',0,'js/ThemeOffice/component.png',1,'contact_icons=0\nicon_address=\nicon_email=\nicon_telephone=\nicon_fax=\nicon_misc=\nshow_headings=1\nshow_position=1\nshow_email=0\nshow_telephone=1\nshow_mobile=1\nshow_fax=1\nbannedEmail=\nbannedSubject=\nbannedText=\nsession=1\ncustomReply=0\n\n',1),(8,'Contacts','',0,7,'option=com_contact','Edit contact details','com_contact',0,'js/ThemeOffice/edit.png',1,'',1),(9,'Categories','',0,7,'option=com_categories&section=com_contact_details','Manage contact categories','',2,'js/ThemeOffice/categories.png',1,'contact_icons=0\nicon_address=\nicon_email=\nicon_telephone=\nicon_fax=\nicon_misc=\nshow_headings=1\nshow_position=1\nshow_email=0\nshow_telephone=1\nshow_mobile=1\nshow_fax=1\nbannedEmail=\nbannedSubject=\nbannedText=\nsession=1\ncustomReply=0\n\n',1),(11,'News Feeds','option=com_newsfeeds',0,0,'','News Feeds Management','com_newsfeeds',0,'js/ThemeOffice/component.png',0,'',1),(12,'Feeds','',0,11,'option=com_newsfeeds','Manage News Feeds','com_newsfeeds',1,'js/ThemeOffice/edit.png',0,'show_headings=1\nshow_name=1\nshow_articles=1\nshow_link=1\nshow_cat_description=1\nshow_cat_items=1\nshow_feed_image=1\nshow_feed_description=1\nshow_item_description=1\nfeed_word_count=0\n\n',1),(13,'Categories','',0,11,'option=com_categories&section=com_newsfeeds','Manage Categories','',2,'js/ThemeOffice/categories.png',0,'',1),(14,'User','option=com_user',0,0,'','','com_user',0,'',1,'',1),(15,'Search','option=com_search',0,0,'option=com_search','Search Statistics','com_search',0,'js/ThemeOffice/component.png',1,'enabled=0\n\n',1),(16,'Categories','',0,1,'option=com_categories&section=com_banner','Categories','',3,'',1,'',1),(17,'Wrapper','option=com_wrapper',0,0,'','Wrapper','com_wrapper',0,'',1,'',1),(18,'Mail To','',0,0,'','','com_mailto',0,'',1,'',1),(19,'Media Manager','',0,0,'option=com_media','Media Manager','com_media',0,'',1,'upload_extensions=bmp,csv,doc,epg,gif,ico,jpg,odg,odp,ods,odt,pdf,png,ppt,swf,txt,xcf,xls,BMP,CSV,DOC,EPG,GIF,ICO,JPG,ODG,ODP,ODS,ODT,PDF,PNG,PPT,SWF,TXT,XCF,XLS\nupload_maxsize=10000000\nfile_path=images\nimage_path=images/stories\nrestrict_uploads=1\nallowed_media_usergroup=3\ncheck_mime=1\nimage_extensions=bmp,gif,jpg,png\nignore_extensions=\nupload_mime=image/jpeg,image/gif,image/png,image/bmp,application/x-shockwave-flash,application/msword,application/excel,application/pdf,application/powerpoint,text/plain,application/x-zip\nupload_mime_illegal=text/html\nenable_flash=0\n\n',1),(20,'Articles','option=com_content',0,0,'','','com_content',0,'',1,'show_noauth=0\nshow_title=1\nlink_titles=0\nshow_intro=1\nshow_section=0\nlink_section=0\nshow_category=0\nlink_category=0\nshow_author=0\nshow_create_date=0\nshow_modify_date=0\nshow_item_navigation=0\nshow_readmore=1\nshow_vote=0\nshow_icons=0\nshow_pdf_icon=0\nshow_print_icon=0\nshow_email_icon=0\nshow_hits=0\nfeed_summary=0\nfilter_tags=\nfilter_attritbutes=\n\n',1),(21,'Configuration Manager','',0,0,'','Configuration','com_config',0,'',1,'',1),(22,'Installation Manager','',0,0,'','Installer','com_installer',0,'',1,'',1),(23,'Language Manager','',0,0,'','Languages','com_languages',0,'',1,'',1),(24,'Mass mail','',0,0,'','Mass Mail','com_massmail',0,'',1,'mailSubjectPrefix=\nmailBodySuffix=\n\n',1),(25,'Menu Editor','',0,0,'','Menu Editor','com_menus',0,'',1,'',1),(27,'Messaging','',0,0,'','Messages','com_messages',0,'',1,'',1),(28,'Modules Manager','',0,0,'','Modules','com_modules',0,'',1,'',1),(29,'Plugin Manager','',0,0,'','Plugins','com_plugins',0,'',1,'',1),(30,'Template Manager','',0,0,'','Templates','com_templates',0,'',1,'',1),(31,'User Manager','',0,0,'','Users','com_users',0,'',1,'allowUserRegistration=1\nnew_usertype=Registered\nuseractivation=1\nfrontend_userparams=1\n\n',1),(32,'Cache Manager','',0,0,'','Cache','com_cache',0,'',1,'',1),(33,'Control Panel','',0,0,'','Control Panel','com_cpanel',0,'',1,'',1),(36,'RokModule','',0,0,'','RokModule','com_rokmodule',0,'',0,'',1),(37,'RokNavMenuBundle','',0,0,'','RokNavMenuBundle','com_roknavmenubundle',0,'',0,'',1),(35,'Gantry','',0,0,'','Gantry','com_gantry',0,'',0,'',0),(38,'COM_AKEEBA','option=com_akeeba',0,0,'option=com_akeeba','COM_AKEEBA','com_akeeba',0,'components/com_akeeba/assets/images/akeeba-16.png',0,'siteurl=http://fencesauckland.co.nz/\njlibrariesdir=C:/HostingSpaces/psr029/fencesauckland.co.nz/wwwroot/libraries\njversion=1.5\nlastversion=3.4.3\nliveupdate=lastcheck=1370220586\\nupdatedata=\"{\\\"supported\\\":true,\\\"stuck\\\":false,\\\"version\\\":\\\"3.7.7\\\",\\\"date\\\":\\\"2013-05-11\\\",\\\"stability\\\":\\\"stable\\\",\\\"downloadURL\\\":\\\"http:\\\\\\/\\\\\\/cdn.akeebabackup.com\\\\\\/downloads\\\\\\/akeebabackup\\\\\\/3.7.7\\\\\\/com_akeeba-3.7.7-core.zip\\\",\\\"infoURL\\\":\\\"https:\\\\\\/\\\\\\/www.akeebabackup.com\\\\\\/downloads\\\\\\/akeeba-backup\\\\\\/3-7-7.html\\\",\\\"releasenotes\\\":\\\"<h3>General information<\\\\\\/h3><p> This version addresses compatibility issues with Joomla! 3.0 and 3.1. Moreover, minor issues regarding the ANGIE restoration script have been addressed.<\\\\\\/p><p> If you have a problem after or before installing the component please read our <a href=\\\\\\\"https:\\\\\\/\\\\\\/www.akeebabackup.com\\\\\\/home\\\\\\/news\\\\\\/55-general\\\\\\/1502-troubleshooting-instructions-for-feb-2013-releases.html\\\\\\\"> troubleshooting page<\\\\\\/a>. These issues are more likely to occur if you try to upgrade this component while you have an older version of another component of ours still installed on your site.<\\\\\\/p><h3>PHP 5.3 is now required<\\\\\\/h3><p> This version requires PHP 5.3 or later. The rationale behind this is explained in our <a href=\\\\\\\"https:\\\\\\/\\\\\\/www.akeebabackup.com\\\\\\/home\\\\\\/news\\\\\\/55-general\\\\\\/1501-end-of-php52-support.html\\\\\\\"> statement of mid-February 2013<\\\\\\/a>. It won\'t install on hosts running PHP 5.2 or earlier. Moreover, due to the necessary Joomla! API changes found only in Joomla! 2.5.6 or later, this version will not install on Joomla! 2.5.5 or earlier versions. In any case, it will tell you exactly why it cannot be installed (minimum PHP or Joomla! version not satisfied).<\\\\\\/p><h3>Changelog<\\\\\\/h3><h4>New features<\\\\\\/h4><ul> <li>Added \\\\\\\"Robert button\\\\\\\" (accept the mandatory information in the post-setup page without ticking each box)<\\\\\\/li><\\\\\\/ul><h4>Miscellaneous changes<\\\\\\/h4><ul> <li>Making MySQLi the default database engine in ANGIE<\\\\\\/li><\\\\\\/ul><h4>Bug fixes<\\\\\\/h4><ul> <li>[LOW] ANGIE: Division by zero on dead slow servers<\\\\\\/li> <li>[LOW] ANGIE: The FTP layer\'s status sticks to the value of the backed up site<\\\\\\/li><\\\\\\/ul>\\\"}\"\\nstuck=0\\n\\n\n\n',1);

--
-- Table structure for table `jos_contact_details`
--

CREATE TABLE `jos_contact_details` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL DEFAULT '',
  `alias` varchar(255) NOT NULL DEFAULT '',
  `con_position` varchar(255) DEFAULT NULL,
  `address` text,
  `suburb` varchar(100) DEFAULT NULL,
  `state` varchar(100) DEFAULT NULL,
  `country` varchar(100) DEFAULT NULL,
  `postcode` varchar(100) DEFAULT NULL,
  `telephone` varchar(255) DEFAULT NULL,
  `fax` varchar(255) DEFAULT NULL,
  `misc` mediumtext,
  `image` varchar(255) DEFAULT NULL,
  `imagepos` varchar(20) DEFAULT NULL,
  `email_to` varchar(255) DEFAULT NULL,
  `default_con` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `published` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `checked_out` int(11) unsigned NOT NULL DEFAULT '0',
  `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `ordering` int(11) NOT NULL DEFAULT '0',
  `params` text NOT NULL,
  `user_id` int(11) NOT NULL DEFAULT '0',
  `catid` int(11) NOT NULL DEFAULT '0',
  `access` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `mobile` varchar(255) NOT NULL DEFAULT '',
  `webpage` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `catid` (`catid`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `jos_contact_details`
--

INSERT INTO `jos_contact_details` (`id`, `name`, `alias`, `con_position`, `address`, `suburb`, `state`, `country`, `postcode`, `telephone`, `fax`, `misc`, `image`, `imagepos`, `email_to`, `default_con`, `published`, `checked_out`, `checked_out_time`, `ordering`, `params`, `user_id`, `catid`, `access`, `mobile`, `webpage`) VALUES (1,'Contact Us','contact-us','','Serving GREATER AUCKLAND REGION','','','','9855','09 973 0711','','','',NULL,'info@mainsites.com.au',0,1,0,'0000-00-00 00:00:00',1,'show_name=1\nshow_position=0\nshow_email=0\nshow_street_address=1\nshow_suburb=0\nshow_state=1\nshow_postcode=0\nshow_country=0\nshow_telephone=1\nshow_mobile=1\nshow_fax=0\nshow_webpage=1\nshow_misc=0\nshow_image=0\nallow_vcard=0\ncontact_icons=1\nicon_address=\nicon_email=\nicon_telephone=\nicon_mobile=\nicon_fax=\nicon_misc=\nshow_email_form=1\nemail_description=\nshow_email_copy=1\nbanned_email=\nbanned_subject=\nbanned_text=',0,4,0,'09 973 0711','http://www.fencesauckland.co.nz');

--
-- Table structure for table `jos_content`
--

CREATE TABLE `jos_content` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL DEFAULT '',
  `alias` varchar(255) NOT NULL DEFAULT '',
  `title_alias` varchar(255) NOT NULL DEFAULT '',
  `introtext` mediumtext NOT NULL,
  `fulltext` mediumtext NOT NULL,
  `state` tinyint(3) NOT NULL DEFAULT '0',
  `sectionid` int(11) unsigned NOT NULL DEFAULT '0',
  `mask` int(11) unsigned NOT NULL DEFAULT '0',
  `catid` int(11) unsigned NOT NULL DEFAULT '0',
  `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `created_by` int(11) 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(11) unsigned NOT NULL DEFAULT '0',
  `checked_out` int(11) unsigned NOT NULL DEFAULT '0',
  `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `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` text NOT NULL,
  `version` int(11) unsigned NOT NULL DEFAULT '1',
  `parentid` int(11) unsigned NOT NULL DEFAULT '0',
  `ordering` int(11) NOT NULL DEFAULT '0',
  `metakey` text NOT NULL,
  `metadesc` text NOT NULL,
  `access` int(11) unsigned NOT NULL DEFAULT '0',
  `hits` int(11) unsigned NOT NULL DEFAULT '0',
  `metadata` text NOT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_section` (`sectionid`),
  KEY `idx_access` (`access`),
  KEY `idx_checkout` (`checked_out`),
  KEY `idx_state` (`state`),
  KEY `idx_catid` (`catid`),
  KEY `idx_createdby` (`created_by`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `jos_content`
--

INSERT INTO `jos_content` (`id`, `title`, `alias`, `title_alias`, `introtext`, `fulltext`, `state`, `sectionid`, `mask`, `catid`, `created`, `created_by`, `created_by_alias`, `modified`, `modified_by`, `checked_out`, `checked_out_time`, `publish_up`, `publish_down`, `images`, `urls`, `attribs`, `version`, `parentid`, `ordering`, `metakey`, `metadesc`, `access`, `hits`, `metadata`) VALUES (1,'Quick Points','quick-points','','<table style=\"width: 100%;\" border=\"0\" cellpadding=\"5\">\r\n<tbody>\r\n<tr valign=\"top\">\r\n<th style=\"text-align: center;\">GENERAL FENCING</th><th style=\"text-align: center;\">RETAINING WALLS</th><th style=\"text-align: center;\">GENERAL PROPERTY SERVICES</th>\r\n<td style=\"text-align: center; background-color: #ffffff; border: 1px solid #aeaeae;\" rowspan=\"2\">\r\n<p style=\"text-align: center;\"><img src=\"images/stories/googlelistingsnz-redlogo2-site.png\" border=\"0\" /></p>\r\n<p style=\"text-align: right;\"><span style=\"color: #4d0000;\"><strong><span style=\"font-size: x-large;\">Ph:</span></strong><span style=\"font-size: x-large; font-weight: bold; text-align: center; line-height: 1.3em;\"> 09 9730711</span></span></p>\r\n<p style=\"text-align: right;\"><span style=\"color: #ff0000; font-weight: bold; line-height: 1.3em;\"><span style=\"font-size: small;\">ATTN: Fencers - THIS SITE AVAILABLE</span></span></p>\r\n<p style=\"text-align: right;\"><span style=\"font-size: large;\"><strong>Email:</strong> <a href=\"contact-us.html\">Contact Us</a></span></p>\r\n</td>\r\n</tr>\r\n<tr valign=\"top\">\r\n<td style=\"width: 23%;\">\r\n<p style=\"text-align: center;\"><img src=\"images/stories/points_1.jpg\" border=\"0\" /></p>\r\n<ul>\r\n<li><strong>Wooden Slat Fences</strong></li>\r\n<li><strong>Single Panel Fencing</strong></li>\r\n<li><strong>Post and Rail Fencing</strong></li>\r\n<li><strong>Farm/Rural Fencing</strong></li>\r\n<li><strong>Commercial/Industrial Fencing</strong></li>\r\n</ul>\r\n</td>\r\n<td style=\"text-align: center; width: 23%;\">\r\n<p><img src=\"images/stories/points_2.png\" border=\"0\" /></p>\r\n<ul>\r\n<li style=\"text-align: left;\"><strong>Stone/Rock Walls</strong></li>\r\n<li style=\"text-align: left;\"><strong>Half Round Retainers</strong></li>\r\n<li style=\"text-align: left;\"><strong>Sleeper Retaining Walls</strong></li>\r\n<li style=\"text-align: left;\"><strong>High Concrete Walls</strong></li>\r\n<li style=\"text-align: left;\"><strong>Split Stone Garden Walls</strong></li>\r\n</ul>\r\n</td>\r\n<td style=\"text-align: center; width: 23%;\">\r\n<p><img src=\"images/stories/points_3.jpg\" border=\"0\" /></p>\r\n<ul>\r\n<li style=\"text-align: left; \"><strong>Guard Railings </strong></li>\r\n<li style=\"text-align: left; \"><strong>Bridges and Balustrades</strong></li>\r\n<li style=\"text-align: left; \"><strong>House, Shed &amp; Garage Slabs</strong></li>\r\n<li style=\"text-align: left; \"><strong>Concrete Construction/Repair</strong></li>\r\n<li style=\"text-align: left; \"><strong>All Maintenance Services</strong></li>\r\n</ul>\r\n</td>\r\n</tr>\r\n</tbody>\r\n</table>','',1,1,0,2,'2011-01-17 15:21:18',63,'','2014-12-18 03:07:23',63,0,'0000-00-00 00:00:00','2011-01-17 15:21:18','0000-00-00 00:00:00','','','show_title=\nlink_titles=\nshow_intro=\nshow_section=\nlink_section=\nshow_category=\nlink_category=\nshow_vote=\nshow_author=\nshow_create_date=\nshow_modify_date=\nshow_pdf_icon=\nshow_print_icon=\nshow_email_icon=\nlanguage=\nkeyref=\nreadmore=',115,0,1,'fence builders, fences auckland','Whether it is the fences Auckland residents are looking for or the fences Auckalnd commercial properties need, we are the fence building company to choose',0,2140,'robots=\nauthor='),(2,'About Us','about-us','','<p><img src=\"images/stories/fencesauckland-aboutus.png\" border=\"0\" style=\"border: 0px; float: right;\" /></p>\r\n<h1><span style=\"font-family: Arial;\"><span style=\"font-size: small;\"><span style=\"color: #000000;\"><span style=\"font-size: medium;\"><strong>For Fences Auckland</strong></span></span></span></span></h1>\r\n<p class=\"MsoNormal\" style=\"text-align: left; line-height: normal; margin: 0cm 0cm 0pt;\"><span style=\"font-size: medium; color: #000000; font-family: Arial;\"><strong>Come to Fences Auckland  - A company known by its reputation. </strong></span><span style=\"color: #000000; font-family: Arial; font-size: medium;\">A company that has been serving the people of Auckland for more than 30 years. </span><span style=\"font-size: medium; color: #000000; font-family: Arial;\">With such vast fencing experience to their credit, Fences Auckland Contracting has been applauded by their clients for the outstanding work they provide.</span></p>\r\n<p class=\"MsoNormal\" style=\"text-align: left; line-height: normal; margin: 0cm 0cm 0pt;\"> </p>\r\n<p class=\"MsoNormal\" style=\"text-align: left; line-height: normal; margin: 0cm 0cm 0pt;\"><span style=\"font-family: Arial;\"><span style=\"font-size: small;\"><span style=\"color: #000000;\"><span style=\"font-size: medium;\">The comprehensive list of services offered by Steve and his team ensures that you can contact them for any type of fencing needs for city, rural or farm properties. </span></span></span></span><span style=\"font-size: medium; color: #000000; font-family: Arial;\">With a well experienced in-house team of professionals these are the fences Auckland resident request. The entire team are well trained and competent enough to do any type of fence building job.</span></p>\r\n<p class=\"MsoNormal\" style=\"text-align: left; line-height: normal; margin: 0cm 0cm 0pt;\"> </p>\r\n<p class=\"MsoNormal\" style=\"text-align: left; line-height: normal; margin: 0cm 0cm 0pt;\"><span style=\"font-family: Arial;\"><span style=\"font-size: small;\"><span style=\"color: #000000;\"><span style=\"font-size: medium;\">The friendly and approachable nature on offer makes it a pleasure to engage the services of Steve and his team, irrespective of whether you are seeking fences for the middle of Auckland city or rural fencing on your farm.</span></span></span></span></p>\r\n<p class=\"MsoNormal\" style=\"text-align: left; line-height: normal; margin: 0cm 0cm 0pt;\"> </p>\r\n<p class=\"MsoNormal\" style=\"text-align: center; line-height: normal; margin: 0cm 0cm 0pt;\"><span style=\"font-family: Arial;\"><span style=\"font-size: small;\"><span style=\"color: #000000;\"><span style=\"font-size: medium;\"><em><strong>\'See us for the fence or fences Auckland people love\'</strong></em></span></span></span></span></p>','',1,1,0,2,'2011-01-17 15:26:53',63,'','2014-07-18 01:58:04',63,0,'0000-00-00 00:00:00','2011-01-17 15:26:53','0000-00-00 00:00:00','','','show_title=\nlink_titles=\nshow_intro=\nshow_section=\nlink_section=\nshow_category=\nlink_category=\nshow_vote=\nshow_author=\nshow_create_date=\nshow_modify_date=\nshow_pdf_icon=\nshow_print_icon=\nshow_email_icon=\nlanguage=\nkeyref=\nreadmore=',45,0,2,'','',0,2096,'robots=\nauthor='),(7,'Rural / Farm Fencing','carousel-3','','<p><img src=\"images/stories/fences-auckland-farm-fencing.jpg\" border=\"0\" /></p>\r\n<p>Over the years we have strung many kilometres of high tensile multiwire and meshed fencing.</p>','',1,1,0,3,'2011-01-25 22:48:38',63,'','2014-05-29 02:12:11',63,0,'0000-00-00 00:00:00','2011-01-25 22:48:38','0000-00-00 00:00:00','','','show_title=\nlink_titles=\nshow_intro=\nshow_section=\nlink_section=\nshow_category=\nlink_category=\nshow_vote=\nshow_author=\nshow_create_date=\nshow_modify_date=\nshow_pdf_icon=\nshow_print_icon=\nshow_email_icon=\nlanguage=\nkeyref=\nreadmore=',12,0,3,'','',0,0,'robots=\nauthor='),(3,'Wooden Fencing','carousel-1','','<p><img src=\"images/stories/fences_auckland_c1.jpg\" border=\"0\" />Large variety of fence styles and sizes. A few metres or a few hundred metres.</p>','',1,1,0,3,'2011-01-17 15:42:44',62,'','2011-02-16 21:05:26',63,0,'0000-00-00 00:00:00','2011-01-17 15:42:44','0000-00-00 00:00:00','','','show_title=\nlink_titles=\nshow_intro=\nshow_section=\nlink_section=\nshow_category=\nlink_category=\nshow_vote=\nshow_author=\nshow_create_date=\nshow_modify_date=\nshow_pdf_icon=\nshow_print_icon=\nshow_email_icon=\nlanguage=\nkeyref=\nreadmore=',10,0,1,'','',0,3,'robots=\nauthor='),(4,'Services Overview','services-overview','','<p><img src=\"images/stories/fencesauckland-ourservices.png\" border=\"0\" style=\"float: right;\" /></p>\r\n<p class=\"MsoNormal\" style=\"text-align: left; line-height: normal; margin: 0cm 0cm 0pt;\"><span style=\"font-family: Arial;\"><span style=\"font-size: small;\"><span style=\"color: #000000;\"><span style=\"font-size: medium;\">The list of services offered by the Auckland team is comprehensive and ensures every aspect of fencing is taken into consideration. Offering a wide range of services for commercial, rural and residential properties.  Fences Auckland Contractors build the type of fences Auckland people need and want. </span></span></span></span></p>\r\n<p class=\"MsoNormal\" style=\"text-align: left; line-height: normal; margin: 0cm 0cm 0pt;\"> </p>\r\n<p class=\"MsoNormal\" style=\"text-align: left; line-height: normal; margin: 0cm 0cm 0pt;\"><span style=\"font-family: Arial;\"><span style=\"font-size: small;\"><span style=\"color: #000000;\"><span style=\"font-size: medium;\">Plus, the services are not just restricted to fences, Steve and his team can provide guard railing, balustrades, retaining walls and general property maintenance. Also in the offering is general property services and construction of bridges and wire fencing for any type of property. </span></span></span></span></p>\r\n<p class=\"MsoNormal\" style=\"text-align: left; line-height: normal; margin: 0cm 0cm 0pt;\"> </p>\r\n<p class=\"MsoNormal\" style=\"text-align: left; line-height: normal; margin: 0cm 0cm 0pt;\"><span style=\"font-family: Arial;\"><span style=\"font-size: small;\"><span style=\"color: #000000;\"><span style=\"font-size: medium;\">Every employee in this company has extensive knowledge in the fields of construction, machinery safety, fence installation &amp; repair together with concrete construction experience. Call Steve to get the fences Auckland is raving about.</span></span></span></span></p>\r\n<p class=\"MsoNormal\" style=\"text-align: left; line-height: normal; margin: 0cm 0cm 0pt;\"> </p>\r\n<p class=\"MsoNormal\" style=\"text-align: center; line-height: normal; margin: 0cm 0cm 0pt;\"><span style=\"font-family: Arial;\"><span style=\"font-size: small;\"><span style=\"color: #000000;\"><span style=\"font-size: medium;\"><em><strong>\'See us for the fence or fences Auckland people love\'</strong></em></span></span></span></span></p>','',1,1,0,2,'2011-01-17 15:26:53',63,'','2014-07-18 01:59:17',63,0,'0000-00-00 00:00:00','2011-01-17 15:26:53','0000-00-00 00:00:00','','','show_title=\nlink_titles=\nshow_intro=\nshow_section=\nlink_section=\nshow_category=\nlink_category=\nshow_vote=\nshow_author=\nshow_create_date=\nshow_modify_date=\nshow_pdf_icon=\nshow_print_icon=\nshow_email_icon=\nlanguage=\nkeyref=\nreadmore=',32,0,3,'','',0,2327,'robots=\nauthor='),(6,'Bridges & Balustrades','carousel-2','','<p><span style=\"font-size: small;\"><img src=\"images/stories/fences_auckland_c2.jpg\" border=\"0\" />A bridge over a garden pond or an access over a stream or dam.</span></p>','',1,1,0,3,'2011-01-17 15:42:44',62,'','2011-02-16 21:07:50',63,0,'0000-00-00 00:00:00','2011-01-17 15:42:44','0000-00-00 00:00:00','','','show_title=\nlink_titles=\nshow_intro=\nshow_section=\nlink_section=\nshow_category=\nlink_category=\nshow_vote=\nshow_author=\nshow_create_date=\nshow_modify_date=\nshow_pdf_icon=\nshow_print_icon=\nshow_email_icon=\nlanguage=\nkeyref=\nreadmore=',10,0,2,'','',0,0,'robots=\nauthor='),(5,'TRY US First','front-article','','<p><span style=\"font-size: small;\">We are the people to call for if you are looking for someone to build the fences Auckland residents recommend. Call us for all your fencing needs, whether residential, rural, farm fencing or commercial fencing throughout the entire Auckland region. With over three decades of experience in all aspects of fencing, you can be certain of getting the best in quality and service. We build the fences Auckland properties need.  Give us the opportunity to serve you and see the difference we can bring about.  Use us, the people that build the fences Auckland people rave about. As with everything else, there are rules and regulations involved when it comes to fencing. <a href=\"http://www.aucklandcouncil.govt.nz/en/search/pages/search.aspx?k=fencing%20rules\" target=\"_blank\"><span style=\"text-decoration: underline;\"><strong>Click here</strong></span></a> to download a free pdf document explaining all you need to know.</span></p>\r\n<p style=\"text-align: center;\"><span style=\"font-size: small;\"><em><strong>\'See us for the retaining wall or fences Auckland people love\'</strong></em></span></p>','',1,0,0,0,'2011-01-24 08:34:12',63,'','2014-05-29 02:15:32',63,0,'0000-00-00 00:00:00','2011-01-24 08:34:12','0000-00-00 00:00:00','','','show_title=\nlink_titles=\nshow_intro=\nshow_section=\nlink_section=\nshow_category=\nlink_category=\nshow_vote=\nshow_author=\nshow_create_date=\nshow_modify_date=\nshow_pdf_icon=\nshow_print_icon=\nshow_email_icon=\nlanguage=\nkeyref=\nreadmore=',29,0,1,'fences auckland, auckland fences, fence builder auckland, auckland fence builder','For the design and build of any fences Auckland residents needs, call us to build the fences Auckland people recommend ',0,24439,'robots=\nauthor='),(8,'Solid Retaining Walls','carousel-4','','<p><img src=\"images/stories/fences_auckland_c4.jpg\" border=\"0\" /></p>\r\n<p>Stone or rock retaining walls will always withstand the test of time</p>','',1,1,0,3,'2011-01-25 22:49:02',62,'','2011-02-16 21:12:13',63,0,'0000-00-00 00:00:00','2011-01-25 22:49:02','0000-00-00 00:00:00','','','show_title=\nlink_titles=\nshow_intro=\nshow_section=\nlink_section=\nshow_category=\nlink_category=\nshow_vote=\nshow_author=\nshow_create_date=\nshow_modify_date=\nshow_pdf_icon=\nshow_print_icon=\nshow_email_icon=\nlanguage=\nkeyref=\nreadmore=',6,0,4,'','',0,0,'robots=\nauthor='),(9,'Boundary or Enclosure Fencing','carousel-5','','<p><img src=\"images/stories/fences_auckland_c5.jpg\" border=\"0\" /></p>\r\n<p>Simple fencing for boundaries, parks, enclosures, gardens, plus many other applications.</p>','',1,1,0,3,'2011-01-25 22:49:39',62,'','2011-02-16 21:14:30',63,0,'0000-00-00 00:00:00','2011-01-25 22:49:39','0000-00-00 00:00:00','','','show_title=\nlink_titles=\nshow_intro=\nshow_section=\nlink_section=\nshow_category=\nlink_category=\nshow_vote=\nshow_author=\nshow_create_date=\nshow_modify_date=\nshow_pdf_icon=\nshow_print_icon=\nshow_email_icon=\nlanguage=\nkeyref=\nreadmore=',6,0,5,'','',0,0,'robots=\nauthor=');

--
-- Table structure for table `jos_content_frontpage`
--

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

--
-- Dumping data for table `jos_content_frontpage`
--

INSERT INTO `jos_content_frontpage` (`content_id`, `ordering`) VALUES (5,1);

--
-- Table structure for table `jos_content_rating`
--

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

--
-- Dumping data for table `jos_content_rating`
--


--
-- Table structure for table `jos_core_acl_aro`
--

CREATE TABLE `jos_core_acl_aro` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `section_value` varchar(240) NOT NULL DEFAULT '0',
  `value` varchar(240) NOT NULL DEFAULT '',
  `order_value` int(11) NOT NULL DEFAULT '0',
  `name` varchar(255) NOT NULL DEFAULT '',
  `hidden` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `jos_section_value_value_aro` (`section_value`(100),`value`(100)),
  KEY `jos_gacl_hidden_aro` (`hidden`)
) ENGINE=MyISAM AUTO_INCREMENT=15 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `jos_core_acl_aro`
--

INSERT INTO `jos_core_acl_aro` (`id`, `section_value`, `value`, `order_value`, `name`, `hidden`) VALUES (11,'users','63',0,'Bryan',0),(13,'users','65',0,'Dianne',0),(14,'users','66',0,'Tech Support',0);

--
-- Table structure for table `jos_core_acl_aro_groups`
--

CREATE TABLE `jos_core_acl_aro_groups` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `parent_id` int(11) NOT NULL DEFAULT '0',
  `name` varchar(255) NOT NULL DEFAULT '',
  `lft` int(11) NOT NULL DEFAULT '0',
  `rgt` int(11) NOT NULL DEFAULT '0',
  `value` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `jos_gacl_parent_id_aro_groups` (`parent_id`),
  KEY `jos_gacl_lft_rgt_aro_groups` (`lft`,`rgt`)
) ENGINE=MyISAM AUTO_INCREMENT=31 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `jos_core_acl_aro_groups`
--

INSERT INTO `jos_core_acl_aro_groups` (`id`, `parent_id`, `name`, `lft`, `rgt`, `value`) VALUES (17,0,'ROOT',1,22,'ROOT'),(28,17,'USERS',2,21,'USERS'),(29,28,'Public Frontend',3,12,'Public Frontend'),(18,29,'Registered',4,11,'Registered'),(19,18,'Author',5,10,'Author'),(20,19,'Editor',6,9,'Editor'),(21,20,'Publisher',7,8,'Publisher'),(30,28,'Public Backend',13,20,'Public Backend'),(23,30,'Manager',14,19,'Manager'),(24,23,'Administrator',15,18,'Administrator'),(25,24,'Super Administrator',16,17,'Super Administrator');

--
-- Table structure for table `jos_core_acl_aro_map`
--

CREATE TABLE `jos_core_acl_aro_map` (
  `acl_id` int(11) NOT NULL DEFAULT '0',
  `section_value` varchar(230) NOT NULL DEFAULT '0',
  `value` varchar(100) NOT NULL,
  PRIMARY KEY (`acl_id`,`section_value`,`value`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `jos_core_acl_aro_map`
--


--
-- Table structure for table `jos_core_acl_aro_sections`
--

CREATE TABLE `jos_core_acl_aro_sections` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `value` varchar(230) NOT NULL DEFAULT '',
  `order_value` int(11) NOT NULL DEFAULT '0',
  `name` varchar(230) NOT NULL DEFAULT '',
  `hidden` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `jos_gacl_value_aro_sections` (`value`),
  KEY `jos_gacl_hidden_aro_sections` (`hidden`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `jos_core_acl_aro_sections`
--

INSERT INTO `jos_core_acl_aro_sections` (`id`, `value`, `order_value`, `name`, `hidden`) VALUES (10,'users',1,'Users',0);

--
-- Table structure for table `jos_core_acl_groups_aro_map`
--

CREATE TABLE `jos_core_acl_groups_aro_map` (
  `group_id` int(11) NOT NULL DEFAULT '0',
  `section_value` varchar(240) NOT NULL DEFAULT '',
  `aro_id` int(11) NOT NULL DEFAULT '0',
  UNIQUE KEY `group_id_aro_id_groups_aro_map` (`group_id`,`section_value`,`aro_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `jos_core_acl_groups_aro_map`
--

INSERT INTO `jos_core_acl_groups_aro_map` (`group_id`, `section_value`, `aro_id`) VALUES (25,'',11),(25,'',13),(25,'',14);

--
-- Table structure for table `jos_core_log_items`
--

CREATE TABLE `jos_core_log_items` (
  `time_stamp` date NOT NULL DEFAULT '0000-00-00',
  `item_table` varchar(50) NOT NULL DEFAULT '',
  `item_id` int(11) unsigned NOT NULL DEFAULT '0',
  `hits` int(11) unsigned NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `jos_core_log_items`
--


--
-- Table structure for table `jos_core_log_searches`
--

CREATE TABLE `jos_core_log_searches` (
  `search_term` varchar(128) NOT NULL DEFAULT '',
  `hits` int(11) unsigned NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `jos_core_log_searches`
--


--
-- Table structure for table `jos_groups`
--

CREATE TABLE `jos_groups` (
  `id` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `name` varchar(50) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `jos_groups`
--

INSERT INTO `jos_groups` (`id`, `name`) VALUES (0,'Public'),(1,'Registered'),(2,'Special');

--
-- Table structure for table `jos_menu`
--

CREATE TABLE `jos_menu` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `menutype` varchar(75) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `alias` varchar(255) NOT NULL DEFAULT '',
  `link` text,
  `type` varchar(50) NOT NULL DEFAULT '',
  `published` tinyint(1) NOT NULL DEFAULT '0',
  `parent` int(11) unsigned NOT NULL DEFAULT '0',
  `componentid` int(11) unsigned NOT NULL DEFAULT '0',
  `sublevel` int(11) DEFAULT '0',
  `ordering` int(11) DEFAULT '0',
  `checked_out` int(11) unsigned NOT NULL DEFAULT '0',
  `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `pollid` int(11) NOT NULL DEFAULT '0',
  `browserNav` tinyint(4) DEFAULT '0',
  `access` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `utaccess` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `params` text NOT NULL,
  `lft` int(11) unsigned NOT NULL DEFAULT '0',
  `rgt` int(11) unsigned NOT NULL DEFAULT '0',
  `home` int(1) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `componentid` (`componentid`,`menutype`,`published`,`access`),
  KEY `menutype` (`menutype`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `jos_menu`
--

INSERT INTO `jos_menu` (`id`, `menutype`, `name`, `alias`, `link`, `type`, `published`, `parent`, `componentid`, `sublevel`, `ordering`, `checked_out`, `checked_out_time`, `pollid`, `browserNav`, `access`, `utaccess`, `params`, `lft`, `rgt`, `home`) VALUES (1,'mainmenu','Home','home','index.php?option=com_content&view=article&id=5','component',1,0,20,0,1,0,'0000-00-00 00:00:00',0,0,0,3,'show_noauth=\nshow_title=\nlink_titles=\nshow_intro=\nshow_section=\nlink_section=\nshow_category=\nlink_category=\nshow_author=\nshow_create_date=\nshow_modify_date=\nshow_item_navigation=\nshow_readmore=\nshow_vote=\nshow_icons=\nshow_pdf_icon=\nshow_print_icon=\nshow_email_icon=\nshow_hits=\nfeed_summary=\nfusion_item_subtext=\nfusion_customimage=\nfusion_customclass=\nfusion_columns=1\nfusion_distribution=even\nfusion_dropdown_width=\nfusion_column_widths=\nfusion_children_group=0\nfusion_children_type=menuitems\nsplitmenu_item_subtext=\nsuckerfish_item_subtext=\npage_title=For the fences Auckland residents need and the fence builders for gates & rock walls\nshow_page_title=0\npageclass_sfx=\nmenu_image=-1\nsecure=0\n\n',0,0,1),(2,'mainmenu','Articles','articles','index.php?option=com_content&view=category&id=2','component',1,0,20,0,2,0,'0000-00-00 00:00:00',0,0,0,0,'display_num=10\nshow_headings=0\nshow_date=0\ndate_format=\nfilter=0\nfilter_type=title\norderby_sec=\nshow_pagination=1\nshow_pagination_limit=0\nshow_feed_link=1\nshow_noauth=\nshow_title=\nlink_titles=\nshow_intro=\nshow_section=\nlink_section=\nshow_category=\nlink_category=\nshow_author=\nshow_create_date=\nshow_modify_date=\nshow_item_navigation=\nshow_readmore=\nshow_vote=\nshow_icons=\nshow_pdf_icon=\nshow_print_icon=\nshow_email_icon=\nshow_hits=0\nfeed_summary=\nfusion_item_subtext=\nfusion_customimage=\nfusion_customclass=\nfusion_columns=1\nfusion_distribution=even\nfusion_dropdown_width=\nfusion_column_widths=\nfusion_children_group=0\nfusion_children_type=menuitems\nsplitmenu_item_subtext=\nsuckerfish_item_subtext=\npage_title=Fences Auckland City - fence builders and rock wall articles\nshow_page_title=1\npageclass_sfx=\nmenu_image=-1\nsecure=0\n\n',0,0,0),(3,'mainmenu','Contact Us','contact-us','index.php?option=com_contact&view=contact&id=1','component',1,0,7,0,3,0,'0000-00-00 00:00:00',0,0,0,0,'show_contact_list=0\nshow_category_crumb=0\ncontact_icons=\nicon_address=\nicon_email=\nicon_telephone=\nicon_mobile=\nicon_fax=\nicon_misc=\nshow_headings=\nshow_position=\nshow_email=\nshow_telephone=\nshow_mobile=\nshow_fax=\nallow_vcard=\nbanned_email=\nbanned_subject=\nbanned_text=\nvalidate_session=\ncustom_reply=\nfusion_item_subtext=\nfusion_customimage=\nfusion_customclass=\nfusion_columns=1\nfusion_distribution=even\nfusion_dropdown_width=\nfusion_column_widths=\nfusion_children_group=0\nfusion_children_type=menuitems\nsplitmenu_item_subtext=\nsuckerfish_item_subtext=\npage_title=Fences Auckland - Contact Us\nshow_page_title=0\npageclass_sfx=\nmenu_image=-1\nsecure=0\n\n',0,0,0);

--
-- Table structure for table `jos_menu_types`
--

CREATE TABLE `jos_menu_types` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `menutype` varchar(75) NOT NULL DEFAULT '',
  `title` varchar(255) NOT NULL DEFAULT '',
  `description` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  UNIQUE KEY `menutype` (`menutype`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `jos_menu_types`
--

INSERT INTO `jos_menu_types` (`id`, `menutype`, `title`, `description`) VALUES (1,'mainmenu','Main Menu','The main menu for the site');

--
-- Table structure for table `jos_messages`
--

CREATE TABLE `jos_messages` (
  `message_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id_from` int(10) unsigned NOT NULL DEFAULT '0',
  `user_id_to` int(10) unsigned NOT NULL DEFAULT '0',
  `folder_id` int(10) unsigned NOT NULL DEFAULT '0',
  `date_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `state` int(11) NOT NULL DEFAULT '0',
  `priority` int(1) unsigned NOT NULL DEFAULT '0',
  `subject` text NOT NULL,
  `message` text NOT NULL,
  PRIMARY KEY (`message_id`),
  KEY `useridto_state` (`user_id_to`,`state`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `jos_messages`
--


--
-- Table structure for table `jos_messages_cfg`
--

CREATE TABLE `jos_messages_cfg` (
  `user_id` int(10) unsigned NOT NULL DEFAULT '0',
  `cfg_name` varchar(100) NOT NULL DEFAULT '',
  `cfg_value` varchar(255) NOT NULL DEFAULT '',
  UNIQUE KEY `idx_user_var_name` (`user_id`,`cfg_name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `jos_messages_cfg`
--


--
-- Table structure for table `jos_migration_backlinks`
--

CREATE TABLE `jos_migration_backlinks` (
  `itemid` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `url` text NOT NULL,
  `sefurl` text NOT NULL,
  `newurl` text NOT NULL,
  PRIMARY KEY (`itemid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `jos_migration_backlinks`
--


--
-- Table structure for table `jos_modules`
--

CREATE TABLE `jos_modules` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` text NOT NULL,
  `content` text NOT NULL,
  `ordering` int(11) NOT NULL DEFAULT '0',
  `position` varchar(50) DEFAULT NULL,
  `checked_out` int(11) unsigned NOT NULL DEFAULT '0',
  `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `published` tinyint(1) NOT NULL DEFAULT '0',
  `module` varchar(50) DEFAULT NULL,
  `numnews` int(11) NOT NULL DEFAULT '0',
  `access` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `showtitle` tinyint(3) unsigned NOT NULL DEFAULT '1',
  `params` text NOT NULL,
  `iscore` tinyint(4) NOT NULL DEFAULT '0',
  `client_id` tinyint(4) NOT NULL DEFAULT '0',
  `control` text NOT NULL,
  PRIMARY KEY (`id`),
  KEY `published` (`published`,`access`),
  KEY `newsfeeds` (`module`,`published`)
) ENGINE=MyISAM AUTO_INCREMENT=22 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `jos_modules`
--

INSERT INTO `jos_modules` (`id`, `title`, `content`, `ordering`, `position`, `checked_out`, `checked_out_time`, `published`, `module`, `numnews`, `access`, `showtitle`, `params`, `iscore`, `client_id`, `control`) VALUES (1,'Main Menu','',1,'left',0,'0000-00-00 00:00:00',1,'mod_mainmenu',0,0,1,'menutype=mainmenu\nmoduleclass_sfx=_menu\n',1,0,''),(2,'Login','',1,'login',0,'0000-00-00 00:00:00',1,'mod_login',0,0,1,'',1,1,''),(3,'Popular','',3,'cpanel',0,'0000-00-00 00:00:00',1,'mod_popular',0,2,1,'',0,1,''),(4,'Recent added Articles','',4,'cpanel',0,'0000-00-00 00:00:00',1,'mod_latest',0,2,1,'ordering=c_dsc\nuser_id=0\ncache=0\n\n',0,1,''),(5,'Menu Stats','',5,'cpanel',0,'0000-00-00 00:00:00',1,'mod_stats',0,2,1,'',0,1,''),(6,'Unread Messages','',1,'header',0,'0000-00-00 00:00:00',1,'mod_unread',0,2,1,'',1,1,''),(7,'Online Users','',2,'header',0,'0000-00-00 00:00:00',1,'mod_online',0,2,1,'',1,1,''),(8,'Toolbar','',1,'toolbar',0,'0000-00-00 00:00:00',1,'mod_toolbar',0,2,1,'',1,1,''),(9,'Quick Icons','',1,'icon',0,'0000-00-00 00:00:00',1,'mod_quickicon',0,2,1,'',1,1,''),(10,'Logged in Users','',2,'cpanel',0,'0000-00-00 00:00:00',1,'mod_logged',0,2,1,'',0,1,''),(11,'Footer','',0,'footer',0,'0000-00-00 00:00:00',1,'mod_footer',0,0,1,'',1,1,''),(12,'Admin Menu','',1,'menu',0,'0000-00-00 00:00:00',1,'mod_menu',0,2,1,'',0,1,''),(13,'Admin SubMenu','',1,'submenu',0,'0000-00-00 00:00:00',1,'mod_submenu',0,2,1,'',0,1,''),(14,'User Status','',1,'status',0,'0000-00-00 00:00:00',1,'mod_status',0,2,1,'',0,1,''),(15,'Title','',1,'title',0,'0000-00-00 00:00:00',1,'mod_title',0,2,1,'',0,1,''),(16,'RokStories','',0,'showcase-a',0,'0000-00-00 00:00:00',1,'mod_rokstories',0,0,0,'moduleclass_sfx=\nload_css=1\nlayout_type=layout6\ncontent_type=joomla\nsecid=1\ncatid=3\nshow_front=1\narticle_count=10\nitemsOrdering=order\nstrip_tags=a,i,br\ncontent_position=left\nshow_article_title=1\nshow_created_date=0\nshow_article=1\nshow_article_link=0\nlegacy_readmore=0\nthumb_width=90\nstart_width=auto\nuser_id=0\nstart_element=0\nthumbs_opacity=0.3\nfixed_height=0\nmouse_type=click\nautoplay=1\nautoplay_delay=5000\nshow_label_article_title=0\nshow_arrows=1\nshow_circles=1\narrows_placement=inside\nshow_thumbs=0\nfixed_thumb=1\nlink_titles=0\nlink_labels=0\nlink_images=0\nshow_mask=0\nmask_desc_dir=topdown\nmask_imgs_dir=bottomup\nscrollerDuration=1000\nscrollerTransition=Expo.easeInOut\nshow_controls=1\nleft_offset_x=-40\nleft_offset_y=-100\nright_offset_x=-30\nright_offset_y=-100\nleft_f_offset_x=-40\nleft_f_offset_y=-100\nright_f_offset_x=-30\nright_f_offset_y=-100\ncache=0\nmodule_cache=1\ncache_time=900\n\n',0,0,''),(18,'RokNavMenu','',2,'left',63,'2011-01-24 20:05:30',0,'mod_roknavmenu',0,0,1,'theme=/modules/mod_roknavmenu/themes/basic\ncustom_layout=default.php\ncustom_formatter=default.php\n',1,0,''),(19,'Arlifax Google Map v3','',0,'sidebar-a',0,'0000-00-00 00:00:00',1,'mod_googlemap',0,0,0,'google_map_key=\naddress_source=contact\ncustom_address=\nlat=-26.352498\nlng=132.363281\nzoom=15\nmarker_lat=50\nmarker_lon=36.26\nmap_width=430\nmap_height=800\nmarker=1\nmarker_title=\nmarker_message=\nshow_controls=0\nshow_map_types=0\nmap_type=ROADMAP\n\n',0,0,''),(17,'RokTabs','',0,'feature-a',63,'2011-01-29 03:12:57',1,'mod_roktabs',0,0,0,'style=base\ncontent_type=joomla\nsecid=1\ncatid=2\nshow_front=1\nitemsOrdering=order\nshow_readmore=1\nreadmore=Read more...\nwidth=940\ntabs_count=0\nduration=600\ntransition_type=scrolling\ntransition_fx=Quad.easeInOut\nlinksMargins=0\nnavscrolling=0\ntabs_position=top\ntabs_event=click\ntabs_title=content\ntabs_incremental=Tab\ntabs_hideh6=1\ntabs_prefixed=1\ntabs_showicons=0\ntabs_iconside=right\ntabs_iconpath=__module__/images\ntabs_icon=icon_home.gif,icon_security.gif,icon_comment.gif,icon_world.gif,icon_note.gif\nautoplay=0\nautoplay_delay=2000\nmoduleclass_sfx=featuretabs flush\ncache=0\nmodule_cache=1\ncache_time=900\n\n',0,0,''),(20,'Articles','<p style=\"text-align: center;\"><img src=\"images/stories/articles.png\" border=\"0\" /></p>\r\n<p class=\"MsoNormal\" style=\"text-align: center; margin: 0cm 0cm 10pt;\" align=\"center\"><span style=\"line-height: 115%; font-family: Verdana; font-size: 10pt;\" lang=\"EN-GB\"><span style=\"color: #000000;\">High Quality Wooden Fences</span></span></p>\r\n<p class=\"MsoNormal\" style=\"text-align: justify; margin: 0cm 0cm 10pt;\"><span style=\"line-height: 115%; font-family: Verdana; font-size: 10pt;\" lang=\"EN-GB\"><span style=\"color: #000000;\">We pride ourselves as being known as <strong>Fences Auckland</strong>. They don\'t have the reputation for being the great fence builders in Auckland for nothing. Focused on all types of customisation and all types of materials including cedar, wood timber or metal, you will get the fences Auckland is talking about. Whether it is guard rails or wooden fences, retaining walls or balustrades, the best fencing contractors Auckland has are experts at gate fittings, security fences, installations, solid timber fencing, traditional fencing structures, etc. We have a reputation for providing high quality fencing installations at low costs ensuring that our clients get what they want in their fencing requirements, be it for residential or for commercial purposes.</span></span></p>',0,'mainbottom-a',0,'0000-00-00 00:00:00',1,'mod_custom',0,0,0,'moduleclass_sfx=\n\n',0,0,''),(21,'Akeeba Backup Notification Module','',3,'cpanel',0,'0000-00-00 00:00:00',1,'mod_akadmin',0,2,1,'',0,1,'');

--
-- Table structure for table `jos_modules_menu`
--

CREATE TABLE `jos_modules_menu` (
  `moduleid` int(11) NOT NULL DEFAULT '0',
  `menuid` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`moduleid`,`menuid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `jos_modules_menu`
--

INSERT INTO `jos_modules_menu` (`moduleid`, `menuid`) VALUES (1,0),(16,0),(17,1),(18,0),(19,3),(20,2),(21,0);

--
-- Table structure for table `jos_newsfeeds`
--

CREATE TABLE `jos_newsfeeds` (
  `catid` int(11) NOT NULL DEFAULT '0',
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` text NOT NULL,
  `alias` varchar(255) NOT NULL DEFAULT '',
  `link` text NOT NULL,
  `filename` varchar(200) DEFAULT NULL,
  `published` tinyint(1) NOT NULL DEFAULT '0',
  `numarticles` int(11) unsigned NOT NULL DEFAULT '1',
  `cache_time` int(11) unsigned NOT NULL DEFAULT '3600',
  `checked_out` tinyint(3) 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',
  `rtl` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `published` (`published`),
  KEY `catid` (`catid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `jos_newsfeeds`
--


--
-- Table structure for table `jos_plugins`
--

CREATE TABLE `jos_plugins` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL DEFAULT '',
  `element` varchar(100) NOT NULL DEFAULT '',
  `folder` varchar(100) NOT NULL DEFAULT '',
  `access` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `ordering` int(11) NOT NULL DEFAULT '0',
  `published` tinyint(3) NOT NULL DEFAULT '0',
  `iscore` tinyint(3) NOT NULL DEFAULT '0',
  `client_id` tinyint(3) 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',
  `params` text NOT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_folder` (`published`,`client_id`,`access`,`folder`)
) ENGINE=MyISAM AUTO_INCREMENT=42 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `jos_plugins`
--

INSERT INTO `jos_plugins` (`id`, `name`, `element`, `folder`, `access`, `ordering`, `published`, `iscore`, `client_id`, `checked_out`, `checked_out_time`, `params`) VALUES (1,'Authentication - Joomla','joomla','authentication',0,1,1,1,0,0,'0000-00-00 00:00:00',''),(2,'Authentication - LDAP','ldap','authentication',0,2,0,1,0,0,'0000-00-00 00:00:00','host=\nport=389\nuse_ldapV3=0\nnegotiate_tls=0\nno_referrals=0\nauth_method=bind\nbase_dn=\nsearch_string=\nusers_dn=\nusername=\npassword=\nldap_fullname=fullName\nldap_email=mail\nldap_uid=uid\n\n'),(3,'Authentication - GMail','gmail','authentication',0,4,0,0,0,0,'0000-00-00 00:00:00',''),(4,'Authentication - OpenID','openid','authentication',0,3,0,0,0,0,'0000-00-00 00:00:00',''),(5,'User - Joomla!','joomla','user',0,0,1,0,0,0,'0000-00-00 00:00:00','autoregister=1\n\n'),(6,'Search - Content','content','search',0,1,1,1,0,0,'0000-00-00 00:00:00','search_limit=50\nsearch_content=1\nsearch_uncategorised=1\nsearch_archived=1\n\n'),(7,'Search - Contacts','contacts','search',0,3,1,1,0,0,'0000-00-00 00:00:00','search_limit=50\n\n'),(8,'Search - Categories','categories','search',0,4,1,0,0,0,'0000-00-00 00:00:00','search_limit=50\n\n'),(9,'Search - Sections','sections','search',0,5,1,0,0,0,'0000-00-00 00:00:00','search_limit=50\n\n'),(10,'Search - Newsfeeds','newsfeeds','search',0,6,1,0,0,0,'0000-00-00 00:00:00','search_limit=50\n\n'),(11,'Search - Weblinks','weblinks','search',0,2,1,1,0,0,'0000-00-00 00:00:00','search_limit=50\n\n'),(12,'Content - Pagebreak','pagebreak','content',0,10000,1,1,0,0,'0000-00-00 00:00:00','enabled=1\ntitle=1\nmultipage_toc=1\nshowall=1\n\n'),(13,'Content - Rating','vote','content',0,4,1,1,0,0,'0000-00-00 00:00:00',''),(14,'Content - Email Cloaking','emailcloak','content',0,5,1,0,0,0,'0000-00-00 00:00:00','mode=1\n\n'),(15,'Content - Code Hightlighter (GeSHi)','geshi','content',0,5,0,0,0,0,'0000-00-00 00:00:00',''),(16,'Content - Load Module','loadmodule','content',0,6,1,0,0,0,'0000-00-00 00:00:00','enabled=1\nstyle=0\n\n'),(17,'Content - Page Navigation','pagenavigation','content',0,2,1,1,0,0,'0000-00-00 00:00:00','position=1\n\n'),(18,'Editor - No Editor','none','editors',0,0,1,1,0,0,'0000-00-00 00:00:00',''),(19,'Editor - TinyMCE','tinymce','editors',0,0,1,1,0,0,'0000-00-00 00:00:00','mode=extended\nskin=0\ncompressed=0\ncleanup_startup=0\ncleanup_save=2\nentity_encoding=raw\nlang_mode=0\nlang_code=en\ntext_direction=ltr\ncontent_css=1\ncontent_css_custom=\nrelative_urls=1\nnewlines=0\ninvalid_elements=applet\nextended_elements=\ntoolbar=top\ntoolbar_align=left\nhtml_height=550\nhtml_width=750\nelement_path=1\nfonts=1\npaste=1\nsearchreplace=1\ninsertdate=1\nformat_date=%Y-%m-%d\ninserttime=1\nformat_time=%H:%M:%S\ncolors=1\ntable=1\nsmilies=1\nmedia=1\nhr=1\ndirectionality=1\nfullscreen=1\nstyle=1\nlayer=1\nxhtmlxtras=1\nvisualchars=1\nnonbreaking=1\nblockquote=1\ntemplate=0\nadvimage=1\nadvlink=1\nautosave=1\ncontextmenu=1\ninlinepopups=1\nsafari=1\ncustom_plugin=\ncustom_button=\n\n'),(20,'Editor - XStandard Lite 2.0','xstandard','editors',0,0,0,1,0,0,'0000-00-00 00:00:00',''),(21,'Editor Button - Image','image','editors-xtd',0,0,1,0,0,0,'0000-00-00 00:00:00',''),(22,'Editor Button - Pagebreak','pagebreak','editors-xtd',0,0,1,0,0,0,'0000-00-00 00:00:00',''),(23,'Editor Button - Readmore','readmore','editors-xtd',0,0,1,0,0,0,'0000-00-00 00:00:00',''),(24,'XML-RPC - Joomla','joomla','xmlrpc',0,7,0,1,0,0,'0000-00-00 00:00:00',''),(25,'XML-RPC - Blogger API','blogger','xmlrpc',0,7,0,1,0,0,'0000-00-00 00:00:00','catid=1\nsectionid=0\n\n'),(27,'System - SEF','sef','system',0,1,1,0,0,0,'0000-00-00 00:00:00',''),(28,'System - Debug','debug','system',0,2,1,0,0,0,'0000-00-00 00:00:00','queries=1\nmemory=1\nlangauge=1\n\n'),(29,'System - Legacy','legacy','system',0,3,0,1,0,0,'0000-00-00 00:00:00','route=0\n\n'),(30,'System - Cache','cache','system',0,4,0,1,0,0,'0000-00-00 00:00:00','browsercache=0\ncachetime=15\n\n'),(31,'System - Log','log','system',0,5,0,1,0,0,'0000-00-00 00:00:00',''),(32,'System - Remember Me','remember','system',0,6,1,1,0,0,'0000-00-00 00:00:00',''),(33,'System - Backlink','backlink','system',0,7,0,1,0,0,'0000-00-00 00:00:00',''),(34,'System - Mootools Upgrade','mtupgrade','system',0,8,0,1,0,0,'0000-00-00 00:00:00',''),(35,'System - Gantry','gantry','system',0,0,1,0,0,0,'0000-00-00 00:00:00',''),(36,'RokNavMenu - Boost','boost','roknavmenu',0,0,1,1,0,0,'0000-00-00 00:00:00',''),(37,'RokNavMenu - Extended Link','extendedlink','roknavmenu',0,0,1,1,0,0,'0000-00-00 00:00:00',''),(38,'System - RokGantry Cache','rokgantrycache','system',0,0,0,0,0,0,'0000-00-00 00:00:00',''),(39,'System - Google Analytics Page Tracker','googleanalyticstracker','system',0,0,0,0,0,0,'0000-00-00 00:00:00','filetracking=1\nweb_property_id=UA-45316019-24\n\n'),(40,'Akeeba Backup Lazy Scheduling','aklazy','system',0,0,0,0,0,0,'0000-00-00 00:00:00','daysfreq=1\nbackuptime=00:00\nprofile=1\n'),(41,'Security - jHackGuard','jhackguard','system',0,0,0,0,0,0,'0000-00-00 00:00:00','log_file=jhackguard-log.php\nlogging=1\n@spacer1=Data Streams\ncheck_post=1\ncheck_get=1\ncheck_cookies=1\n@spacer2=Filtering parameters\ncheck_eval=1\ncheck_base64=1\ncheck_sql=1\n@spacer3=Advanced parameters\nlink_sg_back=1\n');

--
-- Table structure for table `jos_poll_data`
--

CREATE TABLE `jos_poll_data` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `pollid` int(11) NOT NULL DEFAULT '0',
  `text` text NOT NULL,
  `hits` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `pollid` (`pollid`,`text`(1))
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `jos_poll_data`
--


--
-- Table structure for table `jos_poll_date`
--

CREATE TABLE `jos_poll_date` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `vote_id` int(11) NOT NULL DEFAULT '0',
  `poll_id` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `poll_id` (`poll_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `jos_poll_date`
--


--
-- Table structure for table `jos_poll_menu`
--

CREATE TABLE `jos_poll_menu` (
  `pollid` int(11) NOT NULL DEFAULT '0',
  `menuid` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`pollid`,`menuid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `jos_poll_menu`
--


--
-- Table structure for table `jos_polls`
--

CREATE TABLE `jos_polls` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL DEFAULT '',
  `alias` varchar(255) NOT NULL DEFAULT '',
  `voters` int(9) NOT NULL DEFAULT '0',
  `checked_out` int(11) NOT NULL DEFAULT '0',
  `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `published` tinyint(1) NOT NULL DEFAULT '0',
  `access` int(11) NOT NULL DEFAULT '0',
  `lag` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `jos_polls`
--


--
-- Table structure for table `jos_sections`
--

CREATE TABLE `jos_sections` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL DEFAULT '',
  `name` varchar(255) NOT NULL DEFAULT '',
  `alias` varchar(255) NOT NULL DEFAULT '',
  `image` text NOT NULL,
  `scope` varchar(50) NOT NULL DEFAULT '',
  `image_position` varchar(30) NOT NULL DEFAULT '',
  `description` text NOT NULL,
  `published` tinyint(1) NOT NULL DEFAULT '0',
  `checked_out` int(11) unsigned NOT NULL DEFAULT '0',
  `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `ordering` int(11) NOT NULL DEFAULT '0',
  `access` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `count` int(11) NOT NULL DEFAULT '0',
  `params` text NOT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_scope` (`scope`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `jos_sections`
--

INSERT INTO `jos_sections` (`id`, `title`, `name`, `alias`, `image`, `scope`, `image_position`, `description`, `published`, `checked_out`, `checked_out_time`, `ordering`, `access`, `count`, `params`) VALUES (1,'General','','general','','content','left','',1,0,'0000-00-00 00:00:00',1,0,4,'');

--
-- Table structure for table `jos_stats_agents`
--

CREATE TABLE `jos_stats_agents` (
  `agent` varchar(255) NOT NULL DEFAULT '',
  `type` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `hits` int(11) unsigned NOT NULL DEFAULT '1'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `jos_stats_agents`
--


--
-- Table structure for table `jos_templates_menu`
--

CREATE TABLE `jos_templates_menu` (
  `template` varchar(255) NOT NULL DEFAULT '',
  `menuid` int(11) NOT NULL DEFAULT '0',
  `client_id` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`menuid`,`client_id`,`template`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `jos_templates_menu`
--

INSERT INTO `jos_templates_menu` (`template`, `menuid`, `client_id`) VALUES ('rt_omnicron_j15',0,0),('khepri',0,1);

--
-- Table structure for table `jos_weblinks`
--

CREATE TABLE `jos_weblinks` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `catid` int(11) NOT NULL DEFAULT '0',
  `sid` int(11) NOT NULL DEFAULT '0',
  `title` varchar(250) NOT NULL DEFAULT '',
  `alias` varchar(255) NOT NULL DEFAULT '',
  `url` varchar(250) NOT NULL DEFAULT '',
  `description` text NOT NULL,
  `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `hits` int(11) NOT NULL DEFAULT '0',
  `published` tinyint(1) NOT NULL DEFAULT '0',
  `checked_out` int(11) NOT NULL DEFAULT '0',
  `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `ordering` int(11) NOT NULL DEFAULT '0',
  `archived` tinyint(1) NOT NULL DEFAULT '0',
  `approved` tinyint(1) NOT NULL DEFAULT '1',
  `params` text NOT NULL,
  PRIMARY KEY (`id`),
  KEY `catid` (`catid`,`published`,`archived`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `jos_weblinks`
--


--
-- Dumping events for database 'fencesau_database'
--

--
-- Dumping routines for database 'fencesau_database'
--


