0% found this document useful (0 votes)
5 views24 pages

Justinin SQL

The document is a MySQL dump of the 'justinironworks' database, including the structure and data for multiple tables such as 'jos_banner', 'jos_bannerclient', 'jos_bannertrack', 'jos_categories', and 'jos_components'. It outlines the creation of these tables with their respective fields, types, and constraints. The dump also includes commands to lock tables, disable and enable keys, and set character sets for proper data handling.

Uploaded by

twoneightenine
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
5 views24 pages

Justinin SQL

The document is a MySQL dump of the 'justinironworks' database, including the structure and data for multiple tables such as 'jos_banner', 'jos_bannerclient', 'jos_bannertrack', 'jos_categories', and 'jos_components'. It outlines the creation of these tables with their respective fields, types, and constraints. The dump also includes commands to lock tables, disable and enable keys, and set character sets for proper data handling.

Uploaded by

twoneightenine
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

-- MySQL dump 10.

11
--
-- Host: localhost Database: justinironworks
-- ------------------------------------------------------
-- Server version 5.0.77

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;


/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

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

DROP TABLE IF EXISTS `jos_banner`;


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

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

LOCK TABLES `jos_banner` WRITE;


/*!40000 ALTER TABLE `jos_banner` DISABLE KEYS */;
/*!40000 ALTER TABLE `jos_banner` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `jos_bannerclient`
--
DROP TABLE IF EXISTS `jos_bannerclient`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `jos_bannerclient` (
`cid` int(11) NOT NULL auto_increment,
`name` varchar(255) NOT NULL default '',
`contact` varchar(255) NOT NULL default '',
`email` varchar(255) NOT NULL default '',
`extrainfo` text NOT NULL,
`checked_out` tinyint(1) NOT NULL default '0',
`checked_out_time` time default NULL,
`editor` varchar(50) default NULL,
PRIMARY KEY (`cid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

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

LOCK TABLES `jos_bannerclient` WRITE;


/*!40000 ALTER TABLE `jos_bannerclient` DISABLE KEYS */;
/*!40000 ALTER TABLE `jos_bannerclient` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `jos_bannertrack`;


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

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

LOCK TABLES `jos_bannertrack` WRITE;


/*!40000 ALTER TABLE `jos_bannertrack` DISABLE KEYS */;
/*!40000 ALTER TABLE `jos_bannertrack` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `jos_categories`;


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

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

LOCK TABLES `jos_categories` WRITE;


/*!40000 ALTER TABLE `jos_categories` DISABLE KEYS */;
INSERT INTO `jos_categories` VALUES (1,0,'Drive Gates','','drive-
gates','','1','left','',1,0,'0000-00-00 00:00:00',NULL,1,0,0,''),(2,0,'Walk
Gates','','walk-gates','','1','left','',1,0,'0000-00-00 00:00:00',NULL,2,0,0,''),
(3,0,'Interior Rails','','interior-rails','','1','left','',1,0,'0000-00-00
00:00:00',NULL,3,0,0,''),(4,0,'Fencing','','fencing','','1','left','',1,0,'0000-00-00
00:00:00',NULL,4,0,0,''),(5,0,'Misc','','misc','','1','left','',1,0,'0000-00-00
00:00:00',NULL,5,0,0,''),(6,0,'Balconies','','balconies','','1','left','',1,0,'0000-00-
00 00:00:00',NULL,6,0,0,''),(7,0,'Awnings','','awnings','','1','left','',1,0,'0000-00-
00 00:00:00',NULL,7,0,0,''),(8,0,'Iron
Doors','','irondoors','','1','left','',1,0,'0000-00-00 00:00:00',NULL,8,0,0,'');
/*!40000 ALTER TABLE `jos_categories` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `jos_components`;


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

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

LOCK TABLES `jos_components` WRITE;


/*!40000 ALTER TABLE `jos_components` DISABLE KEYS */;
INSERT INTO `jos_components` VALUES (1,'Banners','',0,0,'','Banner
Management','com_banners',0,'js/ThemeOffice/[Link]',0,'track_impressions=0\ntrac
k_clicks=0\ntag_prefix=\n\n',1),(2,'Banners','',0,1,'option=com_banners','Active
Banners','com_banners',1,'js/ThemeOffice/[Link]',0,'',1),
(3,'Clients','',0,1,'option=com_banners&c=client','Manage
Clients','com_banners',2,'js/ThemeOffice/[Link]',0,'',1),(4,'Web
Links','option=com_weblinks',0,0,'','Manage
Weblinks','com_weblinks',0,'js/ThemeOffice/[Link]',0,'show_comp_description=1\nc
omp_description=\nshow_link_hits=1\nshow_link_description=1\nshow_other_cats=1\nshow_he
adings=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/[Link]',0,'',1),
(6,'Categories','',0,4,'option=com_categories&section=com_weblinks','Manage weblink
categories','',2,'js/ThemeOffice/[Link]',0,'',1),
(7,'Contacts','option=com_contact',0,0,'','Edit contact
details','com_contact',0,'js/ThemeOffice/[Link]',1,'contact_icons=0\nicon_addres
s=\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=\nbannedSubj
ect=\nbannedText=\nsession=1\ncustomReply=0\n\n',1),
(8,'Contacts','',0,7,'option=com_contact','Edit contact
details','com_contact',0,'js/ThemeOffice/[Link]',1,'',1),
(9,'Categories','',0,7,'option=com_categories&section=com_contact_details','Manage
contact
categories','',2,'js/ThemeOffice/[Link]',1,'contact_icons=0\nicon_address=\nico
n_email=\nicon_telephone=\nicon_fax=\nicon_misc=\nshow_headings=1\nshow_position=1\nsho
w_email=0\nshow_telephone=1\nshow_mobile=1\nshow_fax=1\nbannedEmail=\nbannedSubject=\nb
annedText=\nsession=1\ncustomReply=0\n\n',1),
(10,'Polls','option=com_poll',0,0,'option=com_poll','Manage
Polls','com_poll',0,'js/ThemeOffice/[Link]',0,'',1),(11,'News
Feeds','option=com_newsfeeds',0,0,'','News Feeds
Management','com_newsfeeds',0,'js/ThemeOffice/[Link]',0,'',1),
(12,'Feeds','',0,11,'option=com_newsfeeds','Manage News
Feeds','com_newsfeeds',1,'js/ThemeOffice/[Link]',0,'show_headings=1\nshow_name=1\nsho
w_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/[Link]',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/[Link]',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,appli
cation/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=0\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_navi
gation=0\nshow_readmore=1\nshow_vote=0\nshow_icons=1\nshow_pdf_icon=1\nshow_print_icon=
1\nshow_email_icon=1\nshow_hits=1\nfeed_summary=0\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=Re
gistered\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);
/*!40000 ALTER TABLE `jos_components` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `jos_contact_details`;


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

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

LOCK TABLES `jos_contact_details` WRITE;


/*!40000 ALTER TABLE `jos_contact_details` DISABLE KEYS */;
/*!40000 ALTER TABLE `jos_contact_details` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `jos_content`;


SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
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=10 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

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

LOCK TABLES `jos_content` WRITE;


/*!40000 ALTER TABLE `jos_content` DISABLE KEYS */;
INSERT INTO `jos_content` VALUES (1,'Drive Gates','drive-gates','','<table
style=\"text-align: left; width: 100%;\" border=\"0\" cellspacing=\"2\"
cellpadding=\"2\">\r\n<tbody>\r\n<tr>\r\n<td colspan=\"2\">Justin Iron Works builds and
installs custom ornamental iron fencing and gates. Unlike most of our competitors who
use prefabricated materials which limit your choices, Justin Iron Works actually builds
according to your specifications.<br /> <br /> Justin Iron Works custom ornamental iron
fencing and gates adds beauty and value to your property while providing your family or
business with the piece of mind of wrought iron security.<br /> <br /> Justin Iron
Works also installs premium quality automatic openers on all of our ornamental iron
gates. We endeavor to design all of our systems with years of dependable service in
mind. We don\'t sacrifice quality for profit. <br /> <br /> Whether your needs are
for residential perimeter fence, pool fence, or commercial applications, Justin Iron
Works fencing and gates will provide the strength, beauty, and durability that you
expect from virtually maintenance free ornamental iron. Justin Iron Works has the right
fence for any property. <br /> <br /> Justin Iron Works also offers a quarterly
maintenance contract agreement ensuring that you automated gate opener will continue to
operate flawlessly everytime it is used.</td>\r\n</tr>\r\n<tr>\r\n<td style=\"width:
590px;\">{artsexylightbox color=\"white\" thumbnailPreviewCount=\"1\"
path=\"/images/galleries/drivegates/\"}{/artsexylightbox}</td>\r\n<td><strong>Details:
</strong><br /> 10\'- 22\' single swinging gate with opener<br /> 12\'- 25\' double
swinging gate with opener<br /> <br /> Keyless Entry System<br /> - up to 450 codes<br
/> - Phone<br /> - Wireless Transmitter<br /> - Exit Wand<br /> <br /> Intercom
System<br /> <br /> <strong>Maintainance Contract</strong><br /> grease<br /> check for
ants, water, dirt<br /> - every 3 months<br /> <br /> Justin Iron Works can add entry
systems or repair your existing gates.</td>\r\n</tr>\r\n<tr>\r\n<td
colspan=\"2\">\r\n<h3><strong>Rolling Gate VS. Swinging Gate:</strong></h3>\r\nA
rolling gate -- one that is say 10\' or 12\' wide and rolls along a parallel fence --
is totally supported by the hardware it rolls on. It is no load on the fence posts.<br
/> <br /> A swinging gate relies on the post to support it. The post has to be
substantial enough to bear the load. Part of that can be offset by putting a wheel
under the opposite corner of the gate (from the post) to support some of the load. That
usually works best if the gate is swung over a flat concrete slab, so that the wheel is
always in contact with the slab.<br /> <br /> The hardware for a rolling gate is going
to cost more, but the gate will usually last longer and require less maintenance.<br />
<br /> If you\'re planning on using a wheel for support/movement - my experience with a
wheel was that it continually:<br /> <br /> a) got stuck on/in something in its path;
and/or<br /> <br /> b) got a case of \"shopping cart-itis\" - that is, the wheel would
have its own ideas as to which way it was gonna turn.</td>\r\n</tr>\r\n<tr>\r\n<td
colspan=\"2\"><br />\r\n<h3><strong><strong><strong><strong><strong><strong><strong>
<strong>Drive Gates Gallery</strong></strong></strong></strong></strong></strong>
</strong></strong></h3>\r\n<p>{artsexylightbox previewWidth=\"50\" color=\"white\"
path=\"/images/galleries/drivegates/\"}{/artsexylightbox}
</p>\r\n</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n<p> </p>','',1,1,0,1,'2010-02-03
06:57:05',62,'','2010-11-04 00:29:14',62,0,'0000-00-00 00:00:00','2010-02-03
06:57:05','0000-00-00
00:00:00','','','show_title=1\nlink_titles=\nshow_intro=\nshow_section=\nlink_section=\
nshow_category=\nlink_category=\nshow_vote=\nshow_author=\nshow_create_date=\nshow_modi
fy_date=\nshow_pdf_icon=\nshow_print_icon=\nshow_email_icon=\nlanguage=\nkeyref=\nreadm
ore=',23,0,1,'','',0,251,'robots=\nauthor='),(2,'Walk Gates','walk-gates','','<table
style=\"text-align: center; height: 172px;\" border=\"0\" cellspacing=\"2\"
cellpadding=\"2\" width=\"986\">\r\n<tbody>\r\n<tr>\r\n<td style=\"text-align: left;
vertical-align: top;\">\r\n<p> </p>\r\n</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-
align: left;\">\r\n<p>{artsexylightbox color=\"white\" thumbnailPreviewCount=\"1\"
path=\"/images/galleries/walkgates/\"}{/artsexylightbox}
</p>\r\n</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align: left;\">
</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n<table style=\"text-align: center; height:
256px;\" border=\"0\" cellspacing=\"2\" cellpadding=\"2\"
width=\"984\">\r\n<tbody>\r\n<tr>\r\n<td style=\"text-align: left;\">\r\n<h3><strong>
<strong><strong><strong><strong><strong><strong><strong>Walk Gates Gallery</strong>
</strong></strong></strong></strong></strong></strong></strong></h3>\r\n<p>
{artsexylightbox previewWidth=\"50\" color=\"white\"
path=\"/images/galleries/walkgates/\"}{/artsexylightbox}
</p>\r\n</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align: left;\"><br /> <br />
</td>\r\n</tr>\r\n</tbody>\r\n</table>','',1,1,0,2,'2010-02-03 06:57:50',62,'','2010-
07-02 03:09:41',62,0,'0000-00-00 00:00:00','2010-02-03 06:57:50','0000-00-00
00:00:00','','','show_title=1\nlink_titles=\nshow_intro=\nshow_section=\nlink_section=\
nshow_category=\nlink_category=\nshow_vote=\nshow_author=\nshow_create_date=\nshow_modi
fy_date=\nshow_pdf_icon=\nshow_print_icon=\nshow_email_icon=\nlanguage=\nkeyref=\nreadm
ore=',4,0,1,'','',0,209,'robots=\nauthor='),(3,'Interior Rails','interior-
rails','','<table style=\"text-align: center; height: 136px;\" border=\"0\"
cellspacing=\"2\" cellpadding=\"2\" width=\"986\">\r\n<tbody>\r\n<tr>\r\n<td
style=\"text-align: left; vertical-align: top;\"></td>\r\n</tr>\r\n<tr>\r\n<td
style=\"text-align: left;\">\r\n<p>{artsexylightbox color=\"white\"
thumbnailPreviewCount=\"1\" path=\"/images/galleries/interiorrails/\"}
{/artsexylightbox}</p>\r\n</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align: left;\">
</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n<table style=\"text-align: center; height:
206px;\" border=\"0\" cellspacing=\"2\" cellpadding=\"2\"
width=\"984\">\r\n<tbody>\r\n<tr>\r\n<td style=\"text-align: left;\">\r\n<h3><strong>
<strong><strong><strong><strong><strong><strong><strong>Interior Rails Gallery</strong>
</strong></strong></strong></strong></strong></strong></strong></h3>\r\n<p>
{artsexylightbox previewWidth=\"50\" color=\"white\"
path=\"/images/galleries/interiorrails/\"}{/artsexylightbox}
</p>\r\n</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align: left;\"><br /> <br />
</td>\r\n</tr>\r\n</tbody>\r\n</table>','',1,1,0,3,'2010-02-03 06:58:15',62,'','2010-
07-02 03:11:59',62,0,'0000-00-00 00:00:00','2010-02-03 06:58:15','0000-00-00
00:00:00','','','show_title=1\nlink_titles=\nshow_intro=\nshow_section=\nlink_section=\
nshow_category=\nlink_category=\nshow_vote=\nshow_author=\nshow_create_date=\nshow_modi
fy_date=\nshow_pdf_icon=\nshow_print_icon=\nshow_email_icon=\nlanguage=\nkeyref=\nreadm
ore=',4,0,1,'','',0,209,'robots=\nauthor='),(4,'Fencing','fencing','','<table
style=\"text-align: center; height: 142px;\" border=\"0\" cellspacing=\"2\"
cellpadding=\"2\" width=\"986\">\r\n<tbody>\r\n<tr>\r\n<td style=\"text-align: left;
vertical-align: top;\">\r\n<p> </p>\r\n</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-
align: left;\">\r\n<p>{artsexylightbox color=\"white\" thumbnailPreviewCount=\"1\"
path=\"/images/galleries/fencing/\"}{/artsexylightbox}
</p>\r\n</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align: left;\">
</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n<table style=\"text-align: center; height:
206px;\" border=\"0\" cellspacing=\"2\" cellpadding=\"2\"
width=\"984\">\r\n<tbody>\r\n<tr>\r\n<td style=\"text-align: left;\">\r\n<h3><strong>
<strong><strong><strong><strong><strong><strong><strong>Fencing Gallery</strong>
</strong></strong></strong></strong></strong></strong></strong></h3>\r\n<p>
{artsexylightbox previewWidth=\"50\" color=\"white\"
path=\"/images/galleries/fencing/\"}{/artsexylightbox}
</p>\r\n</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align: left;\"><br /> <br />
</td>\r\n</tr>\r\n</tbody>\r\n</table>','',1,1,0,4,'2010-02-03 06:58:59',62,'','2010-
07-02 03:13:48',62,0,'0000-00-00 00:00:00','2010-02-03 06:58:59','0000-00-00
00:00:00','','','show_title=1\nlink_titles=\nshow_intro=\nshow_section=\nlink_section=\
nshow_category=\nlink_category=\nshow_vote=\nshow_author=\nshow_create_date=\nshow_modi
fy_date=\nshow_pdf_icon=\nshow_print_icon=\nshow_email_icon=\nlanguage=\nkeyref=\nreadm
ore=',3,0,1,'','',0,191,'robots=\nauthor='),(5,'Misc','misc','','<table style=\"text-
align: center; height: 164px;\" border=\"0\" cellspacing=\"2\" cellpadding=\"2\"
width=\"986\">\r\n<tbody>\r\n<tr>\r\n<td style=\"text-align: left; vertical-align:
top;\">\r\n<p> </p>\r\n</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align:
left;\">\r\n<p>{artsexylightbox color=\"white\" thumbnailPreviewCount=\"1\"
path=\"/images/galleries/misc/\"}{/artsexylightbox}
</p>\r\n</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align: left;\">
</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n<table style=\"text-align: center; height:
206px;\" border=\"0\" cellspacing=\"2\" cellpadding=\"2\"
width=\"984\">\r\n<tbody>\r\n<tr>\r\n<td style=\"text-align: left;\">\r\n<h3><strong>
<strong><strong><strong><strong><strong><strong><strong>Miscellaneous Gallery</strong>
</strong></strong></strong></strong></strong></strong></strong></h3>\r\n<p>
{artsexylightbox previewWidth=\"50\" color=\"white\" path=\"/images/galleries/misc/\"}
{/artsexylightbox}</p>\r\n</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align: left;\"><br
/> <br /></td>\r\n</tr>\r\n</tbody>\r\n</table>','',1,1,0,5,'2010-02-03
06:59:26',62,'','2010-07-02 03:20:26',62,0,'0000-00-00 00:00:00','2010-02-03
06:59:26','0000-00-00
00:00:00','','','show_title=1\nlink_titles=\nshow_intro=\nshow_section=\nlink_section=\
nshow_category=\nlink_category=\nshow_vote=\nshow_author=\nshow_create_date=\nshow_modi
fy_date=\nshow_pdf_icon=\nshow_print_icon=\nshow_email_icon=\nlanguage=\nkeyref=\nreadm
ore=',3,0,1,'','',0,197,'robots=\nauthor='),(6,'Balconies','balconies','','<table
style=\"text-align: center; height: 135px;\" border=\"0\" cellspacing=\"2\"
cellpadding=\"2\" width=\"986\">\r\n<tbody>\r\n<tr>\r\n<td style=\"text-align: left;
vertical-align: top;\">\r\n<p> </p>\r\n</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-
align: left;\">\r\n<p>{artsexylightbox color=\"white\" thumbnailPreviewCount=\"1\"
path=\"/images/galleries/balconies/\"}{/artsexylightbox}
</p>\r\n</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align: left;\">
</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n<table style=\"text-align: center; height:
206px;\" border=\"0\" cellspacing=\"2\" cellpadding=\"2\"
width=\"984\">\r\n<tbody>\r\n<tr>\r\n<td style=\"text-align: left;\">\r\n<h3><strong>
<strong><strong><strong><strong><strong><strong><strong>Balconies Gallery</strong>
</strong></strong></strong></strong></strong></strong></strong></h3>\r\n<p>
{artsexylightbox previewWidth=\"50\" color=\"white\"
path=\"/images/galleries/balconies/\"}{/artsexylightbox}
</p>\r\n</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align: left;\"><br /> <br />
</td>\r\n</tr>\r\n</tbody>\r\n</table>','',1,1,0,6,'2010-02-04 21:20:47',62,'','2010-
07-02 03:15:20',62,0,'0000-00-00 00:00:00','2010-02-04 21:20:47','0000-00-00
00:00:00','','','show_title=1\nlink_titles=\nshow_intro=\nshow_section=\nlink_section=\
nshow_category=\nlink_category=\nshow_vote=\nshow_author=\nshow_create_date=\nshow_modi
fy_date=\nshow_pdf_icon=\nshow_print_icon=\nshow_email_icon=\nlanguage=\nkeyref=\nreadm
ore=',2,0,1,'','',0,165,'robots=\nauthor='),(7,'Awnings','awnings','','<table
style=\"text-align: center; height: 139px;\" border=\"0\" cellspacing=\"2\"
cellpadding=\"2\" width=\"986\">\r\n<tbody>\r\n<tr>\r\n<td style=\"text-align: left;
vertical-align: top;\">\r\n<p> </p>\r\n</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-
align: left;\">\r\n<p>{artsexylightbox color=\"white\" thumbnailPreviewCount=\"1\"
path=\"/images/galleries/awnings/\"}{/artsexylightbox}
</p>\r\n</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align: left;\">
</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n<table style=\"text-align: center; height:
206px;\" border=\"0\" cellspacing=\"2\" cellpadding=\"2\"
width=\"984\">\r\n<tbody>\r\n<tr>\r\n<td style=\"text-align: left;\">\r\n<h3><strong>
<strong><strong><strong><strong><strong><strong><strong>Awnings Gallery</strong>
</strong></strong></strong></strong></strong></strong></strong></h3>\r\n<p>
{artsexylightbox previewWidth=\"50\" color=\"white\"
path=\"/images/galleries/awnings/\"}{/artsexylightbox}
</p>\r\n</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align: left;\"><br /> <br />
</td>\r\n</tr>\r\n</tbody>\r\n</table>','',1,1,0,7,'2010-02-04 21:23:44',62,'','2010-
07-02 03:16:44',62,0,'0000-00-00 00:00:00','2010-02-04 21:23:44','0000-00-00
00:00:00','','','show_title=1\nlink_titles=\nshow_intro=\nshow_section=\nlink_section=\
nshow_category=\nlink_category=\nshow_vote=\nshow_author=\nshow_create_date=\nshow_modi
fy_date=\nshow_pdf_icon=\nshow_print_icon=\nshow_email_icon=\nlanguage=\nkeyref=\nreadm
ore=',3,0,1,'','',0,144,'robots=\nauthor='),(8,'Iron Doors','irondoors','','<table
style=\"text-align: center; height: 152px;\" border=\"0\" cellspacing=\"2\"
cellpadding=\"2\" width=\"986\">\r\n<tbody>\r\n<tr>\r\n<td style=\"text-align: left;
vertical-align: top;\">\r\n<p> </p>\r\n</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-
align: left;\">\r\n<p>{artsexylightbox color=\"white\" thumbnailPreviewCount=\"1\"
path=\"/images/galleries/irondoors/\"}{/artsexylightbox}
</p>\r\n</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align: left;\">
</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n<table style=\"text-align: center; height:
206px;\" border=\"0\" cellspacing=\"2\" cellpadding=\"2\"
width=\"984\">\r\n<tbody>\r\n<tr>\r\n<td style=\"text-align: left;\">\r\n<h3><strong>
<strong><strong><strong><strong><strong><strong><strong>Iron Doors Gallery</strong>
</strong></strong></strong></strong></strong></strong></strong></h3>\r\n<p>
{artsexylightbox previewWidth=\"50\" color=\"white\"
path=\"/images/galleries/irondoors/\"}{/artsexylightbox}
</p>\r\n</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align: left;\"><br /> <br />
</td>\r\n</tr>\r\n</tbody>\r\n</table>','',1,1,0,8,'2010-02-04 22:24:31',62,'','2010-
07-02 03:18:52',62,0,'0000-00-00 00:00:00','2010-02-04 22:24:31','0000-00-00
00:00:00','','','show_title=1\nlink_titles=\nshow_intro=\nshow_section=\nlink_section=\
nshow_category=\nlink_category=\nshow_vote=\nshow_author=\nshow_create_date=\nshow_modi
fy_date=\nshow_pdf_icon=\nshow_print_icon=\nshow_email_icon=\nlanguage=\nkeyref=\nreadm
ore=',3,0,1,'','',0,152,'robots=\nauthor='),(9,'frontpage','frontpage','','<table
style=\"text-align: left; width: 100%;\" border=\"0\" cellspacing=\"4\"
cellpadding=\"4\">\r\n<tbody>\r\n<tr>\r\n<td>{besps}/demo{/besps}</td>\r\n<td>Justin
Iron Works is the name you turn to when you want the best custom iron work that can be
found. We got our start in 1984 and haven\'t looked back ever since then. Whether you
are interested in drive gates or walk gates, structural steel or a unique mailbox post,
interior rails or awnings, Justin Iron Works is the area\'s top iron working shop that
will provide you with the kind of workmanship that will speak for itself for years to
come. <br /> <br /> Owner/Operator, Jeff Hebert is a Licensed General Contractor, fully
bonded and insured. Mr. Hebert is this region\'s foremost iron artisan and will provide
you, or your business, with the kind of quality that is unparalleled. <br /> <br />
Justin Iron Works\' fabrication shop is located on Hwy 397 in Lake Charles, Louisiana
and will design, construct and install whatever job you have in mind from Austin to
Baton Rouge, from the Cameron Gulf Coast to Alexandria. Call us today to inquire.
</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n<p><br /> <br /></p>\r\n<p style=\"text-
align: center;\">Please pardon our mess <br /> Site Under
Construction</p>\r\n<p> </p>','',1,0,0,0,'2010-06-30 20:25:47',62,'','2010-11-05
06:43:24',62,0,'0000-00-00 00:00:00','2010-06-30 20:25:47','0000-00-00
00:00:00','','','show_title=0\nlink_titles=\nshow_intro=\nshow_section=\nlink_section=\
nshow_category=\nlink_category=\nshow_vote=\nshow_author=\nshow_create_date=0\nshow_mod
ify_date=0\nshow_pdf_icon=\nshow_print_icon=\nshow_email_icon=\nlanguage=\nkeyref=\nrea
dmore=',22,0,1,'','',0,1,'robots=\nauthor=');
/*!40000 ALTER TABLE `jos_content` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `jos_content_frontpage`;


SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
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;
SET character_set_client = @saved_cs_client;

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

LOCK TABLES `jos_content_frontpage` WRITE;


/*!40000 ALTER TABLE `jos_content_frontpage` DISABLE KEYS */;
INSERT INTO `jos_content_frontpage` VALUES (9,1);
/*!40000 ALTER TABLE `jos_content_frontpage` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `jos_content_rating`;


SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
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;
SET character_set_client = @saved_cs_client;

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

LOCK TABLES `jos_content_rating` WRITE;


/*!40000 ALTER TABLE `jos_content_rating` DISABLE KEYS */;
/*!40000 ALTER TABLE `jos_content_rating` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `jos_core_acl_aro`;


SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
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=11 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

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

LOCK TABLES `jos_core_acl_aro` WRITE;


/*!40000 ALTER TABLE `jos_core_acl_aro` DISABLE KEYS */;
INSERT INTO `jos_core_acl_aro` VALUES (10,'users','62',0,'Administrator',0);
/*!40000 ALTER TABLE `jos_core_acl_aro` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `jos_core_acl_aro_groups`;


SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
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;
SET character_set_client = @saved_cs_client;

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

LOCK TABLES `jos_core_acl_aro_groups` WRITE;


/*!40000 ALTER TABLE `jos_core_acl_aro_groups` DISABLE KEYS */;
INSERT INTO `jos_core_acl_aro_groups` 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');
/*!40000 ALTER TABLE `jos_core_acl_aro_groups` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `jos_core_acl_aro_map`;


SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
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;
SET character_set_client = @saved_cs_client;

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

LOCK TABLES `jos_core_acl_aro_map` WRITE;


/*!40000 ALTER TABLE `jos_core_acl_aro_map` DISABLE KEYS */;
/*!40000 ALTER TABLE `jos_core_acl_aro_map` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `jos_core_acl_aro_sections`;


SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
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;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `jos_core_acl_aro_sections`
--

LOCK TABLES `jos_core_acl_aro_sections` WRITE;


/*!40000 ALTER TABLE `jos_core_acl_aro_sections` DISABLE KEYS */;
INSERT INTO `jos_core_acl_aro_sections` VALUES (10,'users',1,'Users',0);
/*!40000 ALTER TABLE `jos_core_acl_aro_sections` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `jos_core_acl_groups_aro_map`;


SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
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;
SET character_set_client = @saved_cs_client;

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

LOCK TABLES `jos_core_acl_groups_aro_map` WRITE;


/*!40000 ALTER TABLE `jos_core_acl_groups_aro_map` DISABLE KEYS */;
INSERT INTO `jos_core_acl_groups_aro_map` VALUES (25,'',10);
/*!40000 ALTER TABLE `jos_core_acl_groups_aro_map` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `jos_core_log_items`;


SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
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;
SET character_set_client = @saved_cs_client;

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

LOCK TABLES `jos_core_log_items` WRITE;


/*!40000 ALTER TABLE `jos_core_log_items` DISABLE KEYS */;
/*!40000 ALTER TABLE `jos_core_log_items` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `jos_core_log_searches`;


SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
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;
SET character_set_client = @saved_cs_client;

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

LOCK TABLES `jos_core_log_searches` WRITE;


/*!40000 ALTER TABLE `jos_core_log_searches` DISABLE KEYS */;
/*!40000 ALTER TABLE `jos_core_log_searches` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `jos_groups`;


SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
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;
SET character_set_client = @saved_cs_client;

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

LOCK TABLES `jos_groups` WRITE;


/*!40000 ALTER TABLE `jos_groups` DISABLE KEYS */;
INSERT INTO `jos_groups` VALUES (0,'Public'),(1,'Registered'),(2,'Special');
/*!40000 ALTER TABLE `jos_groups` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `jos_menu`;


SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
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=10 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

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

LOCK TABLES `jos_menu` WRITE;


/*!40000 ALTER TABLE `jos_menu` DISABLE KEYS */;
INSERT INTO `jos_menu` VALUES (1,'mainmenu','Home','home','[Link]?
option=com_content&view=frontpage','component',1,0,20,0,1,62,'2009-11-08
09:00:25',0,0,0,3,'num_leading_articles=1\nnum_intro_articles=4\nnum_columns=2\nnum_lin
ks=4\norderby_pri=\norderby_sec=front\nshow_pagination=2\nshow_pagination_results=1\nsh
ow_feed_link=1\nshow_noauth=\nshow_title=\nlink_titles=\nshow_intro=\nshow_section=\nli
nk_section=\nshow_category=\nlink_category=\nshow_author=\nshow_create_date=\nshow_modi
fy_date=\nshow_item_navigation=\nshow_readmore=\nshow_vote=\nshow_icons=\nshow_pdf_icon
=\nshow_print_icon=\nshow_email_icon=\nshow_hits=\nfeed_summary=\npage_title=\nshow_pag
e_title=1\npageclass_sfx=\nmenu_image=-1\nsecure=0\n\n',0,0,1),(2,'mainmenu','Drive
Gates','drive-gates','[Link]?
option=com_content&view=article&id=1','component',1,0,20,0,2,0,'0000-00-00
00:00:00',0,0,0,0,'show_noauth=\nshow_title=\nlink_titles=\nshow_intro=\nshow_section=\
nlink_section=\nshow_category=\nlink_category=\nshow_author=\nshow_create_date=\nshow_m
odify_date=\nshow_item_navigation=\nshow_readmore=\nshow_vote=\nshow_icons=\nshow_pdf_i
con=\nshow_print_icon=\nshow_email_icon=\nshow_hits=\nfeed_summary=\npage_title=\nshow_
page_title=1\npageclass_sfx=\nmenu_image=-1\nsecure=0\n\n',0,0,0),(3,'mainmenu','Walk
Gates','walk-gates','[Link]?
option=com_content&view=article&id=2','component',1,0,20,0,3,0,'0000-00-00
00:00:00',0,0,0,0,'show_noauth=\nshow_title=\nlink_titles=\nshow_intro=\nshow_section=\
nlink_section=\nshow_category=\nlink_category=\nshow_author=\nshow_create_date=\nshow_m
odify_date=\nshow_item_navigation=\nshow_readmore=\nshow_vote=\nshow_icons=\nshow_pdf_i
con=\nshow_print_icon=\nshow_email_icon=\nshow_hits=\nfeed_summary=\npage_title=\nshow_
page_title=1\npageclass_sfx=\nmenu_image=-1\nsecure=0\n\n',0,0,0),
(4,'mainmenu','Interior Rails','interior-rails','[Link]?
option=com_content&view=article&id=3','component',1,0,20,0,4,0,'0000-00-00
00:00:00',0,0,0,0,'show_noauth=\nshow_title=\nlink_titles=\nshow_intro=\nshow_section=\
nlink_section=\nshow_category=\nlink_category=\nshow_author=\nshow_create_date=\nshow_m
odify_date=\nshow_item_navigation=\nshow_readmore=\nshow_vote=\nshow_icons=\nshow_pdf_i
con=\nshow_print_icon=\nshow_email_icon=\nshow_hits=\nfeed_summary=\npage_title=\nshow_
page_title=1\npageclass_sfx=\nmenu_image=-1\nsecure=0\n\n',0,0,0),
(5,'mainmenu','Fencing','fencing','[Link]?
option=com_content&view=article&id=4','component',1,0,20,0,5,0,'0000-00-00
00:00:00',0,0,0,0,'show_noauth=\nshow_title=\nlink_titles=\nshow_intro=\nshow_section=\
nlink_section=\nshow_category=\nlink_category=\nshow_author=\nshow_create_date=\nshow_m
odify_date=\nshow_item_navigation=\nshow_readmore=\nshow_vote=\nshow_icons=\nshow_pdf_i
con=\nshow_print_icon=\nshow_email_icon=\nshow_hits=\nfeed_summary=\npage_title=\nshow_
page_title=1\npageclass_sfx=\nmenu_image=-1\nsecure=0\n\n',0,0,0),
(6,'mainmenu','Misc','misc','[Link]?
option=com_content&view=article&id=5','component',1,0,20,0,9,0,'0000-00-00
00:00:00',0,0,0,0,'show_noauth=\nshow_title=\nlink_titles=\nshow_intro=\nshow_section=\
nlink_section=\nshow_category=\nlink_category=\nshow_author=\nshow_create_date=\nshow_m
odify_date=\nshow_item_navigation=\nshow_readmore=\nshow_vote=\nshow_icons=\nshow_pdf_i
con=\nshow_print_icon=\nshow_email_icon=\nshow_hits=\nfeed_summary=\npage_title=\nshow_
page_title=1\npageclass_sfx=\nmenu_image=-1\nsecure=0\n\n',0,0,0),
(7,'mainmenu','Balconies','balconies','[Link]?
option=com_content&view=article&id=6','component',1,0,20,0,6,0,'0000-00-00
00:00:00',0,0,0,0,'show_noauth=\nshow_title=\nlink_titles=\nshow_intro=\nshow_section=\
nlink_section=\nshow_category=\nlink_category=\nshow_author=\nshow_create_date=\nshow_m
odify_date=\nshow_item_navigation=\nshow_readmore=\nshow_vote=\nshow_icons=\nshow_pdf_i
con=\nshow_print_icon=\nshow_email_icon=\nshow_hits=\nfeed_summary=\npage_title=\nshow_
page_title=1\npageclass_sfx=\nmenu_image=-1\nsecure=0\n\n',0,0,0),
(8,'mainmenu','Awnings','awnings','[Link]?
option=com_content&view=article&id=7','component',1,0,20,0,7,0,'0000-00-00
00:00:00',0,0,0,0,'show_noauth=\nshow_title=\nlink_titles=\nshow_intro=\nshow_section=\
nlink_section=\nshow_category=\nlink_category=\nshow_author=\nshow_create_date=\nshow_m
odify_date=\nshow_item_navigation=\nshow_readmore=\nshow_vote=\nshow_icons=\nshow_pdf_i
con=\nshow_print_icon=\nshow_email_icon=\nshow_hits=\nfeed_summary=\npage_title=\nshow_
page_title=1\npageclass_sfx=\nmenu_image=-1\nsecure=0\n\n',0,0,0),(9,'mainmenu','Iron
Doors','iron','[Link]?
option=com_content&view=article&id=8','component',1,0,20,0,8,0,'0000-00-00
00:00:00',0,0,0,0,'show_noauth=\nshow_title=\nlink_titles=\nshow_intro=\nshow_section=\
nlink_section=\nshow_category=\nlink_category=\nshow_author=\nshow_create_date=\nshow_m
odify_date=\nshow_item_navigation=\nshow_readmore=\nshow_vote=\nshow_icons=\nshow_pdf_i
con=\nshow_print_icon=\nshow_email_icon=\nshow_hits=\nfeed_summary=\npage_title=\nshow_
page_title=1\npageclass_sfx=\nmenu_image=-1\nsecure=0\n\n',0,0,0);
/*!40000 ALTER TABLE `jos_menu` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `jos_menu_types`;


SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
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;
SET character_set_client = @saved_cs_client;

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

LOCK TABLES `jos_menu_types` WRITE;


/*!40000 ALTER TABLE `jos_menu_types` DISABLE KEYS */;
INSERT INTO `jos_menu_types` VALUES (1,'mainmenu','Main Menu','The main menu for the
site');
/*!40000 ALTER TABLE `jos_menu_types` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `jos_messages`;


SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
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;
SET character_set_client = @saved_cs_client;

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

LOCK TABLES `jos_messages` WRITE;


/*!40000 ALTER TABLE `jos_messages` DISABLE KEYS */;
/*!40000 ALTER TABLE `jos_messages` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `jos_messages_cfg`
--

DROP TABLE IF EXISTS `jos_messages_cfg`;


SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
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;
SET character_set_client = @saved_cs_client;

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

LOCK TABLES `jos_messages_cfg` WRITE;


/*!40000 ALTER TABLE `jos_messages_cfg` DISABLE KEYS */;
/*!40000 ALTER TABLE `jos_messages_cfg` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `jos_migration_backlinks`;


SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
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;
SET character_set_client = @saved_cs_client;

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

LOCK TABLES `jos_migration_backlinks` WRITE;


/*!40000 ALTER TABLE `jos_migration_backlinks` DISABLE KEYS */;
/*!40000 ALTER TABLE `jos_migration_backlinks` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `jos_modules`;


SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
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=18 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

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

LOCK TABLES `jos_modules` WRITE;


/*!40000 ALTER TABLE `jos_modules` DISABLE KEYS */;
INSERT INTO `jos_modules` VALUES (1,'Main Menu','',1,'user3',0,'0000-00-00
00:00:00',1,'mod_mainmenu',0,0,1,'menutype=mainmenu\nmenu_style=list\nstartLevel=0\nend
Level=0\nshowAllChildren=0\nwindow_open=\nshow_whitespace=0\ncache=1\ntag_id=\nclass_sf
x=\nmoduleclass_sfx=_menu\nmaxdepth=10\nmenu_images=0\nmenu_images_align=0\nmenu_images
_link=0\nexpand_menu=0\nactivate_parent=0\nfull_active_id=0\nindent_image=0\nindent_ima
ge1=\nindent_image2=\nindent_image3=\nindent_image4=\nindent_image5=\nindent_image6=\ns
pacer=\nend_spacer=\n\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,'cache=1\n\n',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,''),(17,'Art Sexy Lightbox','',0,'user1',0,'0000-
00-00 00:00:00',1,'mod_artsexylightbox',0,0,1,'text=\n\n',0,0,'');
/*!40000 ALTER TABLE `jos_modules` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `jos_modules_menu`;


SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
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;
SET character_set_client = @saved_cs_client;

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

LOCK TABLES `jos_modules_menu` WRITE;


/*!40000 ALTER TABLE `jos_modules_menu` DISABLE KEYS */;
INSERT INTO `jos_modules_menu` VALUES (1,0),(17,0);
/*!40000 ALTER TABLE `jos_modules_menu` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `jos_newsfeeds`;


SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
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;
SET character_set_client = @saved_cs_client;

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

LOCK TABLES `jos_newsfeeds` WRITE;


/*!40000 ALTER TABLE `jos_newsfeeds` DISABLE KEYS */;
/*!40000 ALTER TABLE `jos_newsfeeds` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `jos_plugins`;


SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
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=36 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `jos_plugins`
--
LOCK TABLES `jos_plugins` WRITE;
/*!40000 ALTER TABLE `jos_plugins` DISABLE KEYS */;
INSERT INTO `jos_plugins` 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=advanced\nskin=0\ncompressed=0\ncleanup_startup=0\ncleanup_save=2\nenti
ty_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=\n
toolbar=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\ndi
rectionality=1\nfullscreen=1\nstyle=1\nlayer=1\nxhtmlxtras=1\nvisualchars=1\nnonbreakin
g=1\ntemplate=0\nadvimage=1\nadvlink=1\nautosave=1\ncontextmenu=1\ninlinepopups=1\nsafa
ri=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,'Art Sexy
Lightbox','artsexylightbox','content',0,0,1,0,0,0,'0000-00-00
00:00:00','color=black\nshowDuration=200\ncloseDuration=400\nmoveDuration=800\nresizeDu
ration=800\n'),(35,'[Link] Simple Picture
Slideshow','besps','content',0,0,1,0,0,0,'0000-00-00
00:00:00','im_width=400\nim_height=300\nim_align=1\nsl_bgcol=FFFFFF\nbs_sort=0\nsl_sdur
=3\nsl_fdur=1\nsl_steps=20\nautostart=1\nctrl_show=0\nctrl_sort=1-
2345\nctrl_start=\nctrl_stop=\nctrl_back=\nctrl_fwd=\ncap_show=0\ncap_pos=1\nlink_use=0
\npreld=\nsetid=0\n\n');
/*!40000 ALTER TABLE `jos_plugins` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `jos_poll_data`;


SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
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;
SET character_set_client = @saved_cs_client;

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

LOCK TABLES `jos_poll_data` WRITE;


/*!40000 ALTER TABLE `jos_poll_data` DISABLE KEYS */;
/*!40000 ALTER TABLE `jos_poll_data` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `jos_poll_date`;


SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
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;
SET character_set_client = @saved_cs_client;

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

LOCK TABLES `jos_poll_date` WRITE;


/*!40000 ALTER TABLE `jos_poll_date` DISABLE KEYS */;
/*!40000 ALTER TABLE `jos_poll_date` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `jos_poll_menu`;


SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
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;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `jos_poll_menu`
--

LOCK TABLES `jos_poll_menu` WRITE;


/*!40000 ALTER TABLE `jos_poll_menu` DISABLE KEYS */;
/*!40000 ALTER TABLE `jos_poll_menu` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `jos_polls`;


SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
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;
SET character_set_client = @saved_cs_client;

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

LOCK TABLES `jos_polls` WRITE;


/*!40000 ALTER TABLE `jos_polls` DISABLE KEYS */;
/*!40000 ALTER TABLE `jos_polls` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `jos_sections`;


SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
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;
SET character_set_client = @saved_cs_client;

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

LOCK TABLES `jos_sections` WRITE;


/*!40000 ALTER TABLE `jos_sections` DISABLE KEYS */;
INSERT INTO `jos_sections` VALUES
(1,'Galleries','','galleries','','content','left','',1,0,'0000-00-00
00:00:00',1,0,9,'');
/*!40000 ALTER TABLE `jos_sections` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `jos_session`
--

DROP TABLE IF EXISTS `jos_session`;


SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `jos_session` (
`username` varchar(150) default '',
`time` varchar(14) default '',
`session_id` varchar(200) NOT NULL default '0',
`guest` tinyint(4) default '1',
`userid` int(11) default '0',
`usertype` varchar(50) default '',
`gid` tinyint(3) unsigned NOT NULL default '0',
`client_id` tinyint(3) unsigned NOT NULL default '0',
`data` longtext,
PRIMARY KEY (`session_id`(64)),
KEY `whosonline` (`guest`,`usertype`),
KEY `userid` (`userid`),
KEY `time` (`time`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `jos_session`
--

LOCK TABLES `jos_session` WRITE;


/*!40000 ALTER TABLE `jos_session` DISABLE KEYS */;
INSERT INTO `jos_session` VALUES
('','1295074897','m60m2snauaspfu9jc8njs4bli7',1,0,'',0,0,'__default|a:7:
{s:15:\"[Link]\";i:1;s:19:\"[Link]\";i:1295074897;s:18:\"session.
[Link]\";i:1295074897;s:17:\"[Link]\";i:1295074897;s:22:\"[Link]
.browser\";s:72:\"Mozilla/5.0 (compatible; Googlebot/2.1;
+[Link]
{s:17:\"_defaultNameSpace\";s:7:\"session\";s:9:\"_registry\";a:1:{s:7:\"session\";a:1:
{s:4:\"data\";O:8:\"stdClass\":0:{}}}s:7:\"_errors\";a:0:
{}}s:4:\"user\";O:5:\"JUser\":19:
{s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:
14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0
;s:3:\"gid\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N
;s:6:\"params\";N;s:3:\"aid\";i:0;s:5:\"guest\";i:1;s:7:\"_params\";O:10:\"JParameter\"
:7:{s:4:\"_raw\";s:0:\"\";s:4:\"_xml\";N;s:9:\"_elements\";a:0:
{}s:12:\"_elementPath\";a:1:
{i:0;s:73:\"/var/www/html/[Link]/libraries/joomla/html/parameter/element\"
;}s:17:\"_defaultNameSpace\";s:8:\"_default\";s:9:\"_registry\";a:1:
{s:8:\"_default\";a:1:{s:4:\"data\";O:8:\"stdClass\":0:{}}}s:7:\"_errors\";a:0:
{}}s:9:\"_errorMsg\";N;s:7:\"_errors\";a:0:{}}}');
/*!40000 ALTER TABLE `jos_session` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `jos_stats_agents`;


SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
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;
SET character_set_client = @saved_cs_client;

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

LOCK TABLES `jos_stats_agents` WRITE;


/*!40000 ALTER TABLE `jos_stats_agents` DISABLE KEYS */;
/*!40000 ALTER TABLE `jos_stats_agents` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `jos_templates_menu`;


SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
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;
SET character_set_client = @saved_cs_client;

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

LOCK TABLES `jos_templates_menu` WRITE;


/*!40000 ALTER TABLE `jos_templates_menu` DISABLE KEYS */;
INSERT INTO `jos_templates_menu` VALUES ('justinironworks2',0,0),('khepri',0,1);
/*!40000 ALTER TABLE `jos_templates_menu` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `jos_users`
--

DROP TABLE IF EXISTS `jos_users`;


SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `jos_users` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(255) NOT NULL default '',
`username` varchar(150) NOT NULL default '',
`email` varchar(100) NOT NULL default '',
`password` varchar(100) NOT NULL default '',
`usertype` varchar(25) NOT NULL default '',
`block` tinyint(4) NOT NULL default '0',
`sendEmail` tinyint(4) default '0',
`gid` tinyint(3) unsigned NOT NULL default '1',
`registerDate` datetime NOT NULL default '0000-00-00 00:00:00',
`lastvisitDate` datetime NOT NULL default '0000-00-00 00:00:00',
`activation` varchar(100) NOT NULL default '',
`params` text NOT NULL,
PRIMARY KEY (`id`),
KEY `usertype` (`usertype`),
KEY `idx_name` (`name`),
KEY `gid_block` (`gid`,`block`),
KEY `username` (`username`),
KEY `email` (`email`)
) ENGINE=MyISAM AUTO_INCREMENT=63 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `jos_users`
--

LOCK TABLES `jos_users` WRITE;


/*!40000 ALTER TABLE `jos_users` DISABLE KEYS */;
INSERT INTO `jos_users` VALUES
(62,'Administrator','admin','richard@[Link]','ad13a66c448668fe5648f9361a
5280cb:w1gU88zxd5YCDxDCZNNuwXRnGRQAOe94','Super Administrator',0,1,25,'2009-11-07
17:26:01','2010-12-23 04:15:46','','');
/*!40000 ALTER TABLE `jos_users` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `jos_weblinks`;


SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
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;
SET character_set_client = @saved_cs_client;

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

LOCK TABLES `jos_weblinks` WRITE;


/*!40000 ALTER TABLE `jos_weblinks` DISABLE KEYS */;
/*!40000 ALTER TABLE `jos_weblinks` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;


/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2011-01-15 8:32:15

You might also like