DROP TABLE IF EXISTS `jos_60144_banner`; CREATE TABLE `jos_60144_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`) ); DROP TABLE IF EXISTS `jos_60144_bannerclient`; CREATE TABLE `jos_60144_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`) ); DROP TABLE IF EXISTS `jos_60144_bannertrack`; CREATE TABLE `jos_60144_bannertrack` ( `track_date` date NOT NULL default '0000-00-00', `track_type` int(10) unsigned NOT NULL default '0', `banner_id` int(10) unsigned NOT NULL default '0' ); DROP TABLE IF EXISTS `jos_60144_categories`; CREATE TABLE `jos_60144_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`) ); DROP TABLE IF EXISTS `jos_60144_components`; CREATE TABLE `jos_60144_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)) ); INSERT INTO `jos_60144_components` 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); INSERT INTO `jos_60144_components` VALUES(2, 'Banners', '', 0, 1, 'option=com_banners', 'Active Banners', 'com_banners', 1, 'js/ThemeOffice/edit.png', 0, '', 1); INSERT INTO `jos_60144_components` VALUES(3, 'Clients', '', 0, 1, 'option=com_banners&c=client', 'Manage Clients', 'com_banners', 2, 'js/ThemeOffice/categories.png', 0, '', 1); INSERT INTO `jos_60144_components` VALUES(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); INSERT INTO `jos_60144_components` VALUES(5, 'Links', '', 0, 4, 'option=com_weblinks', 'View existing weblinks', 'com_weblinks', 1, 'js/ThemeOffice/edit.png', 0, '', 1); INSERT INTO `jos_60144_components` VALUES(6, 'Categories', '', 0, 4, 'option=com_categories§ion=com_weblinks', 'Manage weblink categories', '', 2, 'js/ThemeOffice/categories.png', 0, '', 1); INSERT INTO `jos_60144_components` VALUES(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); INSERT INTO `jos_60144_components` VALUES(8, 'Contacts', '', 0, 7, 'option=com_contact', 'Edit contact details', 'com_contact', 0, 'js/ThemeOffice/edit.png', 1, '', 1); INSERT INTO `jos_60144_components` VALUES(9, 'Categories', '', 0, 7, 'option=com_categories§ion=com_contact_details', 'Manage contact categories', '', 2, 'js/ThemeOffice/categories.png', 1, 'contact_icons=0\nicon_address=\nicon_email=\nicon_telephone=\nicon_fax=\nicon_misc=\nshow_headings=1\nshow_position=1\nshow_email=0\nshow_telephone=1\nshow_mobile=1\nshow_fax=1\nbannedEmail=\nbannedSubject=\nbannedText=\nsession=1\ncustomReply=0\n\n', 1); INSERT INTO `jos_60144_components` VALUES(10, 'Polls', 'option=com_poll', 0, 0, 'option=com_poll', 'Manage Polls', 'com_poll', 0, 'js/ThemeOffice/component.png', 0, '', 1); INSERT INTO `jos_60144_components` VALUES(11, 'News Feeds', 'option=com_newsfeeds', 0, 0, '', 'News Feeds Management', 'com_newsfeeds', 0, 'js/ThemeOffice/component.png', 0, '', 1); INSERT INTO `jos_60144_components` VALUES(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); INSERT INTO `jos_60144_components` VALUES(13, 'Categories', '', 0, 11, 'option=com_categories§ion=com_newsfeeds', 'Manage Categories', '', 2, 'js/ThemeOffice/categories.png', 0, '', 1); INSERT INTO `jos_60144_components` VALUES(14, 'User', 'option=com_user', 0, 0, '', '', 'com_user', 0, '', 1, '', 1); INSERT INTO `jos_60144_components` VALUES(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); INSERT INTO `jos_60144_components` VALUES(16, 'Categories', '', 0, 1, 'option=com_categories§ion=com_banner', 'Categories', '', 3, '', 1, '', 1); INSERT INTO `jos_60144_components` VALUES(17, 'Wrapper', 'option=com_wrapper', 0, 0, '', 'Wrapper', 'com_wrapper', 0, '', 1, '', 1); INSERT INTO `jos_60144_components` VALUES(18, 'Mail To', '', 0, 0, '', '', 'com_mailto', 0, '', 1, '', 1); INSERT INTO `jos_60144_components` VALUES(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\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=1\n\n', 1); INSERT INTO `jos_60144_components` VALUES(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=1\nshow_pdf_icon=0\nshow_print_icon=1\nshow_email_icon=1\nshow_hits=0\nfeed_summary=0\n\n', 1); INSERT INTO `jos_60144_components` VALUES(21, 'Configuration Manager', '', 0, 0, '', 'Configuration', 'com_config', 0, '', 1, '', 1); INSERT INTO `jos_60144_components` VALUES(22, 'Installation Manager', '', 0, 0, '', 'Installer', 'com_installer', 0, '', 1, '', 1); INSERT INTO `jos_60144_components` VALUES(23, 'Language Manager', '', 0, 0, '', 'Languages', 'com_languages', 0, '', 1, 'administrator=en-GB\nsite=en-GB', 1); INSERT INTO `jos_60144_components` VALUES(24, 'Mass mail', '', 0, 0, '', 'Mass Mail', 'com_massmail', 0, '', 1, 'mailSubjectPrefix=\nmailBodySuffix=\n\n', 1); INSERT INTO `jos_60144_components` VALUES(25, 'Menu Editor', '', 0, 0, '', 'Menu Editor', 'com_menus', 0, '', 1, '', 1); INSERT INTO `jos_60144_components` VALUES(27, 'Messaging', '', 0, 0, '', 'Messages', 'com_messages', 0, '', 1, '', 1); INSERT INTO `jos_60144_components` VALUES(28, 'Modules Manager', '', 0, 0, '', 'Modules', 'com_modules', 0, '', 1, '', 1); INSERT INTO `jos_60144_components` VALUES(29, 'Plugin Manager', '', 0, 0, '', 'Plugins', 'com_plugins', 0, '', 1, '', 1); INSERT INTO `jos_60144_components` VALUES(30, 'Template Manager', '', 0, 0, '', 'Templates', 'com_templates', 0, '', 1, '', 1); INSERT INTO `jos_60144_components` VALUES(31, 'User Manager', '', 0, 0, '', 'Users', 'com_users', 0, '', 1, 'allowUserRegistration=1\nnew_usertype=Registered\nuseractivation=1\nfrontend_userparams=1\n\n', 1); INSERT INTO `jos_60144_components` VALUES(32, 'Cache Manager', '', 0, 0, '', 'Cache', 'com_cache', 0, '', 1, '', 1); INSERT INTO `jos_60144_components` VALUES(33, 'Control Panel', '', 0, 0, '', 'Control Panel', 'com_cpanel', 0, '', 1, '', 1); INSERT INTO `jos_60144_components` VALUES(34, 'FireBoard Forum', 'option=com_fireboard', 0, 0, 'option=com_fireboard', 'FireBoard Forum', 'com_fireboard', 0, '../administrator/components/com_fireboard/images/fbmenu.png', 0, '', 1); INSERT INTO `jos_60144_components` VALUES(35, 'Community Builder', 'option=com_comprofiler', 0, 0, 'option=com_comprofiler', 'Community Builder', 'com_comprofiler', 0, 'js/ThemeOffice/component.png', 0, '', 1); INSERT INTO `jos_60144_components` VALUES(36, 'User Management', '', 0, 35, 'option=com_comprofiler&task=showusers', 'User Management', 'com_comprofiler', 0, 'js/ThemeOffice/users.png', 0, '', 1); INSERT INTO `jos_60144_components` VALUES(37, 'Tab Management', '', 0, 35, 'option=com_comprofiler&task=showTab', 'Tab Management', 'com_comprofiler', 1, 'js/ThemeOffice/content.png', 0, '', 1); INSERT INTO `jos_60144_components` VALUES(38, 'Field Management', '', 0, 35, 'option=com_comprofiler&task=showField', 'Field Management', 'com_comprofiler', 2, 'js/ThemeOffice/content.png', 0, '', 1); INSERT INTO `jos_60144_components` VALUES(39, 'List Management', '', 0, 35, 'option=com_comprofiler&task=showLists', 'List Management', 'com_comprofiler', 3, 'js/ThemeOffice/content.png', 0, '', 1); INSERT INTO `jos_60144_components` VALUES(40, 'Plugin Management', '', 0, 35, 'option=com_comprofiler&task=showPlugins', 'Plugin Management', 'com_comprofiler', 4, 'js/ThemeOffice/install.png', 0, '', 1); INSERT INTO `jos_60144_components` VALUES(41, 'Tools', '', 0, 35, 'option=com_comprofiler&task=tools', 'Tools', 'com_comprofiler', 5, 'js/ThemeOffice/component.png', 0, '', 1); INSERT INTO `jos_60144_components` VALUES(42, 'Configuration', '', 0, 35, 'option=com_comprofiler&task=showconfig', 'Configuration', 'com_comprofiler', 6, 'js/ThemeOffice/config.png', 0, '', 1); INSERT INTO `jos_60144_components` VALUES(43, 'LinX', 'option=com_linx', 0, 0, 'option=com_linx', 'LinX', 'com_linx', 0, 'js/ThemeOffice/globe4.png', 0, '', 1); INSERT INTO `jos_60144_components` VALUES(44, 'Manage Links', '', 0, 43, 'option=com_linx', 'Manage Links', 'com_linx', 0, 'js/ThemeOffice/globe4.png', 0, '', 1); INSERT INTO `jos_60144_components` VALUES(45, 'Categories', '', 0, 43, 'option=com_linx&task=list_categories', 'Categories', 'com_linx', 1, 'js/ThemeOffice/sections.png', 0, '', 1); INSERT INTO `jos_60144_components` VALUES(46, 'Settings', '', 0, 43, 'option=com_linx&task=edit_settings', 'Settings', 'com_linx', 2, 'js/ThemeOffice/controlpanel.png', 0, '', 1); DROP TABLE IF EXISTS `jos_60144_comprofiler`; CREATE TABLE `jos_60144_comprofiler` ( `id` int(11) NOT NULL default '0', `user_id` int(11) NOT NULL default '0', `firstname` varchar(100) default NULL, `middlename` varchar(100) default NULL, `lastname` varchar(100) default NULL, `hits` int(11) NOT NULL default '0', `message_last_sent` datetime NOT NULL default '0000-00-00 00:00:00', `message_number_sent` int(11) NOT NULL default '0', `avatar` varchar(255) default NULL, `avatarapproved` tinyint(4) default '1', `approved` tinyint(4) NOT NULL default '1', `confirmed` tinyint(4) NOT NULL default '1', `lastupdatedate` datetime NOT NULL default '0000-00-00 00:00:00', `registeripaddr` varchar(50) NOT NULL default '', `cbactivation` varchar(50) NOT NULL default '', `banned` tinyint(4) NOT NULL default '0', `banneddate` datetime default NULL, `unbanneddate` datetime default NULL, `bannedby` int(11) default NULL, `unbannedby` int(11) default NULL, `bannedreason` mediumtext, `acceptedterms` tinyint(1) NOT NULL default '0', `fbviewtype` varchar(255) NOT NULL default '', `fbordering` varchar(255) NOT NULL default '', `fbsignature` mediumtext, PRIMARY KEY (`id`), UNIQUE KEY `user_id` (`user_id`), KEY `apprconfbanid` (`approved`,`confirmed`,`banned`,`id`), KEY `avatappr_apr_conf_ban_avatar` (`avatarapproved`,`approved`,`confirmed`,`banned`,`avatar`), KEY `lastupdatedate` (`lastupdatedate`) ); INSERT INTO `jos_60144_comprofiler` VALUES(62, 62, NULL, NULL, NULL, 0, '0000-00-00 00:00:00', 0, NULL, 1, 1, 1, '0000-00-00 00:00:00', '', '', 0, NULL, NULL, NULL, NULL, NULL, 0,'_UE_FB_VIEWTYPE_FLAT','_UE_FB_ORDERING_LATEST',''); DROP TABLE IF EXISTS `jos_60144_comprofiler_fields`; CREATE TABLE `jos_60144_comprofiler_fields` ( `fieldid` int(11) NOT NULL auto_increment, `name` varchar(50) NOT NULL default '', `table` varchar(50) NOT NULL default '#__comprofiler', `title` varchar(255) NOT NULL default '', `description` mediumtext NOT NULL, `type` varchar(50) NOT NULL default '', `maxlength` int(11) default NULL, `size` int(11) default NULL, `required` tinyint(4) default '0', `tabid` int(11) default NULL, `ordering` int(11) default NULL, `cols` int(11) default NULL, `rows` int(11) default NULL, `value` varchar(50) default NULL, `default` mediumtext, `published` tinyint(1) NOT NULL default '1', `registration` tinyint(1) NOT NULL default '0', `profile` tinyint(1) NOT NULL default '1', `readonly` tinyint(1) NOT NULL default '0', `calculated` tinyint(1) NOT NULL default '0', `sys` tinyint(4) NOT NULL default '0', `pluginid` int(11) default NULL, `params` mediumtext, PRIMARY KEY (`fieldid`), KEY `tabid_pub_prof_order` (`tabid`,`published`,`profile`,`ordering`), KEY `readonly_published_tabid` (`readonly`,`published`,`tabid`), KEY `registration_published_order` (`registration`,`published`,`ordering`) ); INSERT INTO `jos_60144_comprofiler_fields` VALUES(41, 'name', '#__users', '_UE_NAME', '', 'predefined', NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 1, 0, 1, 1, NULL, NULL); INSERT INTO `jos_60144_comprofiler_fields` VALUES(26, 'NA', '#__comprofiler', '_UE_ONLINESTATUS', '', 'status', NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 1, 0, 1, 1, NULL, NULL); INSERT INTO `jos_60144_comprofiler_fields` VALUES(27, 'lastvisitDate', '#__users', '_UE_LASTONLINE', '', 'date', NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 1, 0, 1, 1, NULL, NULL); INSERT INTO `jos_60144_comprofiler_fields` VALUES(28, 'registerDate', '#__users', '_UE_MEMBERSINCE', '', 'date', NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 1, 0, 1, 1, NULL, NULL); INSERT INTO `jos_60144_comprofiler_fields` VALUES(29, 'avatar', '#__comprofiler', '_UE_IMAGE', '', 'image', NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 1, 0, 1, 1, NULL, NULL); INSERT INTO `jos_60144_comprofiler_fields` VALUES(42, 'username', '#__users', '_UE_UNAME', '', 'predefined', NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 1, 0, 1, 1, NULL, NULL); INSERT INTO `jos_60144_comprofiler_fields` VALUES(45, 'NA', '#__comprofiler', '_UE_FORMATNAME', '', 'formatname', NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 1, 0, 1, 1, NULL, NULL); INSERT INTO `jos_60144_comprofiler_fields` VALUES(46, 'firstname', '#__comprofiler', '_UE_YOUR_FNAME', '', 'predefined', NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 1, 0, 1, 1, NULL, NULL); INSERT INTO `jos_60144_comprofiler_fields` VALUES(47, 'middlename', '#__comprofiler', '_UE_YOUR_MNAME', '', 'predefined', NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 1, 0, 1, 1, NULL, NULL); INSERT INTO `jos_60144_comprofiler_fields` VALUES(48, 'lastname', '#__comprofiler', '_UE_YOUR_LNAME', '', 'predefined', NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 1, 0, 1, 1, NULL, NULL); INSERT INTO `jos_60144_comprofiler_fields` VALUES(49, 'lastupdatedate', '#__comprofiler', '_UE_LASTUPDATEDON', '', 'date', NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 1, 0, 1, 1, NULL, NULL); INSERT INTO `jos_60144_comprofiler_fields` VALUES(50, 'email', '#__users', '_UE_EMAIL', '', 'primaryemailaddress', NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 1, 0, 1, 1, NULL, NULL); INSERT INTO `jos_60144_comprofiler_fields` VALUES ('51', 'fbviewtype', '#__comprofiler', '_UE_FB_VIEWTYPE_TITLE', '', 'select', null, null, '0', '23', '1', null, null, null, null, '1', '0', '0', '0', '0', '0', null, null); INSERT INTO `jos_60144_comprofiler_fields` VALUES ('52', 'fbordering', '#__comprofiler', '_UE_FB_ORDERING_TITLE', '', 'select', null, null, '0', '23', '2', null, null, null, null, '1', '0', '0', '0', '0', '0', null, null); INSERT INTO `jos_60144_comprofiler_fields` VALUES ('53', 'fbsignature', '#__comprofiler', '_UE_FB_SIGNATURE', '', 'textarea', '300', null, '0', '23', '3', '60', '5', null, null, '1', '0', '0', '0', '0', '0', null, null); DROP TABLE IF EXISTS `jos_60144_comprofiler_field_values`; CREATE TABLE `jos_60144_comprofiler_field_values` ( `fieldvalueid` int(11) NOT NULL auto_increment, `fieldid` int(11) NOT NULL default '0', `fieldtitle` varchar(255) NOT NULL default '', `ordering` int(11) NOT NULL default '0', `sys` tinyint(4) NOT NULL default '0', PRIMARY KEY (`fieldvalueid`), KEY `fieldid_ordering` (`fieldid`,`ordering`) ); INSERT INTO `jos_60144_comprofiler_field_values` VALUES ('1', '51', '_UE_FB_VIEWTYPE_FLAT', '1', '0'); INSERT INTO `jos_60144_comprofiler_field_values` VALUES ('2', '51', '_UE_FB_VIEWTYPE_THREADED', '2', '0'); INSERT INTO `jos_60144_comprofiler_field_values` VALUES ('3', '52', '_UE_FB_ORDERING_OLDEST', '1', '0'); INSERT INTO `jos_60144_comprofiler_field_values` VALUES ('4', '52', '_UE_FB_ORDERING_LATEST', '2', '0'); DROP TABLE IF EXISTS `jos_60144_comprofiler_lists`; CREATE TABLE `jos_60144_comprofiler_lists` ( `listid` int(11) NOT NULL auto_increment, `title` varchar(255) NOT NULL default '', `description` mediumtext, `published` tinyint(1) NOT NULL default '0', `default` tinyint(1) NOT NULL default '0', `usergroupids` varchar(255) default NULL, `useraccessgroupid` int(9) NOT NULL default '18', `sortfields` varchar(255) default NULL, `filterfields` varchar(255) default NULL, `ordering` int(11) NOT NULL default '0', `col1title` varchar(255) default NULL, `col1enabled` tinyint(1) NOT NULL default '0', `col1fields` mediumtext, `col2title` varchar(255) default NULL, `col2enabled` tinyint(1) NOT NULL default '0', `col1captions` tinyint(1) NOT NULL default '0', `col2fields` mediumtext, `col2captions` tinyint(1) NOT NULL default '0', `col3title` varchar(255) default NULL, `col3enabled` tinyint(1) NOT NULL default '0', `col3fields` mediumtext, `col3captions` tinyint(1) NOT NULL default '0', `col4title` varchar(255) default NULL, `col4enabled` tinyint(1) NOT NULL default '0', `col4fields` mediumtext, `col4captions` tinyint(1) NOT NULL default '0', PRIMARY KEY (`listid`), KEY `pub_ordering` (`published`,`ordering`), KEY `default_published` (`default`,`published`) ); DROP TABLE IF EXISTS `jos_60144_comprofiler_members`; CREATE TABLE `jos_60144_comprofiler_members` ( `referenceid` int(11) NOT NULL default '0', `memberid` int(11) NOT NULL default '0', `accepted` tinyint(1) NOT NULL default '1', `pending` tinyint(1) NOT NULL default '0', `membersince` date NOT NULL default '0000-00-00', `reason` mediumtext, `description` varchar(255) default NULL, `type` mediumtext, PRIMARY KEY (`referenceid`,`memberid`), KEY `pamr` (`pending`,`accepted`,`memberid`,`referenceid`), KEY `aprm` (`accepted`,`pending`,`referenceid`,`memberid`), KEY `membrefid` (`memberid`,`referenceid`) ); DROP TABLE IF EXISTS `jos_60144_comprofiler_plugin`; CREATE TABLE `jos_60144_comprofiler_plugin` ( `id` int(11) NOT NULL auto_increment, `name` varchar(100) NOT NULL default '', `element` varchar(100) NOT NULL default '', `type` varchar(100) default '', `folder` varchar(100) default '', `backend_menu` varchar(255) 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`), KEY `type_pub_order` (`type`,`published`,`ordering`) ); INSERT INTO `jos_60144_comprofiler_plugin` VALUES(1, 'CB Core', 'cb.core', 'user', 'plug_cbcore', '', 0, 1, 1, 1, 0, 0, '0000-00-00 00:00:00', ''); INSERT INTO `jos_60144_comprofiler_plugin` VALUES(2, 'CB Connections', 'cb.connections', 'user', 'plug_cbconnections', '', 0, 3, 1, 1, 0, 0, '0000-00-00 00:00:00', ''); INSERT INTO `jos_60144_comprofiler_plugin` VALUES(3, 'Content Author', 'cb.authortab', 'user', 'plug_cbmamboauthortab', '', 0, 4, 1, 1, 0, 0, '0000-00-00 00:00:00', ''); INSERT INTO `jos_60144_comprofiler_plugin` VALUES(4, 'Simpleboard Forum', 'cb.simpleboardtab', 'user', 'plug_cbsimpleboardtab', '', 0, 5, 0, 1, 0, 0, '0000-00-00 00:00:00', ''); INSERT INTO `jos_60144_comprofiler_plugin` VALUES(5, 'Mamblog Blog', 'cb.mamblogtab', 'user', 'plug_cbmamblogtab', '', 0, 6, 1, 1, 0, 0, '0000-00-00 00:00:00', ''); INSERT INTO `jos_60144_comprofiler_plugin` VALUES(6, 'YaNC Newsletters', 'yanc', 'user', 'plug_yancintegration', '', 0, 7, 0, 1, 0, 0, '0000-00-00 00:00:00', ''); INSERT INTO `jos_60144_comprofiler_plugin` VALUES(7, 'Default', 'default', 'templates', 'default', '', 0, 1, 1, 1, 0, 0, '0000-00-00 00:00:00', ''); INSERT INTO `jos_60144_comprofiler_plugin` VALUES(8, 'WinClassic', 'winclassic', 'templates', 'winclassic', '', 0, 2, 1, 1, 0, 0, '0000-00-00 00:00:00', ''); INSERT INTO `jos_60144_comprofiler_plugin` VALUES(9, 'WebFX', 'webfx', 'templates', 'webfx', '', 0, 3, 1, 1, 0, 0, '0000-00-00 00:00:00', ''); INSERT INTO `jos_60144_comprofiler_plugin` VALUES(10, 'OSX', 'osx', 'templates', 'osx', '', 0, 4, 1, 1, 0, 0, '0000-00-00 00:00:00', ''); INSERT INTO `jos_60144_comprofiler_plugin` VALUES(11, 'Luna', 'luna', 'templates', 'luna', '', 0, 5, 1, 1, 0, 0, '0000-00-00 00:00:00', ''); INSERT INTO `jos_60144_comprofiler_plugin` VALUES(12, 'Dark', 'dark', 'templates', 'dark', '', 0, 6, 1, 1, 0, 0, '0000-00-00 00:00:00', ''); INSERT INTO `jos_60144_comprofiler_plugin` VALUES(13, 'Default language (English)', 'default_language', 'language', 'default_language', '', 0, -1, 1, 1, 0, 0, '0000-00-00 00:00:00', ''); INSERT INTO `jos_60144_comprofiler_plugin` VALUES(14, 'CB Menu', 'cb.menu', 'user', 'plug_cbmenu', '', 0, 2, 1, 1, 0, 0, '0000-00-00 00:00:00', ''); INSERT INTO `jos_60144_comprofiler_plugin` VALUES(15, 'PMS MyPMS and Pro', 'pms.mypmspro', 'user', 'plug_pms_mypmspro', '', 0, 8, 0, 1, 0, 0, '0000-00-00 00:00:00', ''); DROP TABLE IF EXISTS `jos_60144_comprofiler_tabs`; CREATE TABLE `jos_60144_comprofiler_tabs` ( `tabid` int(11) NOT NULL auto_increment, `title` varchar(50) NOT NULL default '', `description` text, `ordering` int(11) NOT NULL default '0', `ordering_register` int(11) NOT NULL default '10', `width` varchar(10) NOT NULL default '.5', `enabled` tinyint(1) NOT NULL default '1', `pluginclass` varchar(255) default NULL, `pluginid` int(11) default NULL, `fields` tinyint(1) NOT NULL default '1', `params` mediumtext, `sys` tinyint(4) NOT NULL default '0', `displaytype` varchar(255) NOT NULL default '', `position` varchar(255) NOT NULL default '', `useraccessgroupid` int(9) NOT NULL default '-2', PRIMARY KEY (`tabid`), KEY `enabled_position_ordering` (`enabled`,`position`,`ordering`), KEY `orderreg_enabled_pos_order` (`enabled`,`ordering_register`,`position`,`ordering`) ); INSERT INTO `jos_60144_comprofiler_tabs` VALUES(11, '_UE_CONTACT_INFO_HEADER', '', -4, 10, '1', 1, 'getContactTab', 1, 1, NULL, 2, 'tab', 'cb_tabmain', -2); INSERT INTO `jos_60144_comprofiler_tabs` VALUES(12, '_UE_AUTHORTAB', '', -3, 10, '1', 0, 'getAuthorTab', 3, 0, NULL, 1, 'tab', 'cb_tabmain', -2); INSERT INTO `jos_60144_comprofiler_tabs` VALUES(13, '_UE_FORUMTAB', '', -2, 10, '1', 0, 'getForumTab', 4, 0, NULL, 1, 'tab', 'cb_tabmain', -2); INSERT INTO `jos_60144_comprofiler_tabs` VALUES(14, '_UE_BLOGTAB', '', -1, 10, '1', 0, 'getBlogTab', 5, 0, NULL, 1, 'tab', 'cb_tabmain', -2); INSERT INTO `jos_60144_comprofiler_tabs` VALUES(15, '_UE_CONNECTION', '', 99, 10, '1', 0, 'getConnectionTab', 2, 0, NULL, 1, 'tab', 'cb_tabmain', -2); INSERT INTO `jos_60144_comprofiler_tabs` VALUES(16, '_UE_NEWSLETTER_HEADER', '_UE_NEWSLETTER_INTRODCUTION', 99, 10, '1', 0, 'getNewslettersTab', 6, 0, NULL, 1, 'tab', 'cb_tabmain', -2); INSERT INTO `jos_60144_comprofiler_tabs` VALUES(17, '_UE_MENU', '', -10, 10, '1', 1, 'getMenuTab', 14, 0, 'firstMenuName= firstSubMenuName= firstSubMenuHref= secondSubMenuName= secondSubMenuHref=', 1, 'html', 'cb_head', -2); INSERT INTO `jos_60144_comprofiler_tabs` VALUES(18, '_UE_CONNECTIONPATHS', '', -9, 10, '1', 1, 'getConnectionPathsTab', 2, 0, NULL, 1, 'html', 'cb_head', -2); INSERT INTO `jos_60144_comprofiler_tabs` VALUES(19, '_UE_PROFILE_PAGE_TITLE', '', -8, 10, '1', 1, 'getPageTitleTab', 1, 0, NULL, 1, 'html', 'cb_head', -2); INSERT INTO `jos_60144_comprofiler_tabs` VALUES(20, '_UE_PORTRAIT', '', -7, 10, '1', 1, 'getPortraitTab', 1, 0, NULL, 1, 'html', 'cb_middle', -2); INSERT INTO `jos_60144_comprofiler_tabs` VALUES(21, '_UE_USER_STATUS', '', -6, 10, '.5', 1, 'getStatusTab', 14, 0, NULL, 1, 'html', 'cb_right', -2); INSERT INTO `jos_60144_comprofiler_tabs` VALUES(22, '_UE_PMSTAB', '', -5, 10, '.5', 0, 'getmypmsproTab', 15, 0, NULL, 1, 'html', 'cb_right', -2); INSERT INTO `jos_60144_comprofiler_tabs` VALUES(23, '_UE_FB_TABTITLE', '_UE_FB_TABDESC', 0, 10, '.5', 1, '', NULL, 1, NULL, 0, '', '', -2); DROP TABLE IF EXISTS `jos_60144_comprofiler_userreports`; CREATE TABLE `jos_60144_comprofiler_userreports` ( `reportid` int(11) NOT NULL auto_increment, `reporteduser` int(11) NOT NULL default '0', `reportedbyuser` int(11) NOT NULL default '0', `reportedondate` date NOT NULL default '0000-00-00', `reportexplaination` text NOT NULL, `reportedstatus` tinyint(4) NOT NULL default '0', PRIMARY KEY (`reportid`), KEY `status_user_date` (`reportedstatus`,`reporteduser`,`reportedondate`), KEY `reportedbyuser_ondate` (`reportedbyuser`,`reportedondate`) ); DROP TABLE IF EXISTS `jos_60144_comprofiler_views`; CREATE TABLE `jos_60144_comprofiler_views` ( `viewer_id` int(11) NOT NULL default '0', `profile_id` int(11) NOT NULL default '0', `lastip` varchar(50) NOT NULL default '', `lastview` datetime NOT NULL default '0000-00-00 00:00:00', `viewscount` int(11) NOT NULL default '0', `vote` tinyint(3) default NULL, `lastvote` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`viewer_id`,`profile_id`,`lastip`), KEY `lastview` (`lastview`), KEY `profile_id_lastview` (`profile_id`,`lastview`) ); DROP TABLE IF EXISTS `jos_60144_contact_details`; CREATE TABLE `jos_60144_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`) ); INSERT INTO `jos_60144_contact_details` VALUES(1, 'Site Admin', 'Webmaster', '', '', '', '', '', '', '', '', '', 'powered_by.png', NULL, 'joomla@seonitro.com', 0, 1, 0, '0000-00-00 00:00:00', 1, 'show_name=1\nshow_position=1\nshow_email=0\nshow_street_address=1\nshow_suburb=1\nshow_state=1\nshow_postcode=1\nshow_country=1\nshow_telephone=1\nshow_mobile=1\nshow_fax=1\nshow_webpage=0\nshow_misc=1\nshow_image=0\nallow_vcard=0\ncontact_icons=0\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=', 62, 2, 0, '', 'http://www.reubenpace.com'); DROP TABLE IF EXISTS `jos_60144_content`; CREATE TABLE `jos_60144_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`) ); DROP TABLE IF EXISTS `jos_60144_content_frontpage`; CREATE TABLE `jos_60144_content_frontpage` ( `content_id` int(11) NOT NULL default '0', `ordering` int(11) NOT NULL default '0', PRIMARY KEY (`content_id`) ); DROP TABLE IF EXISTS `jos_60144_content_rating`; CREATE TABLE `jos_60144_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`) ); DROP TABLE IF EXISTS `jos_60144_core_acl_aro`; CREATE TABLE `jos_60144_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_60144_section_value_value_aro` (`section_value`(100),`value`(100)), KEY `jos_60144_gacl_hidden_aro` (`hidden`) ); INSERT INTO `jos_60144_core_acl_aro` VALUES(10, 'users', '62', 0, 'Administrator', 0); DROP TABLE IF EXISTS `jos_60144_core_acl_aro_groups`; CREATE TABLE `jos_60144_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_60144_gacl_parent_id_aro_groups` (`parent_id`), KEY `jos_60144_gacl_lft_rgt_aro_groups` (`lft`,`rgt`) ); INSERT INTO `jos_60144_core_acl_aro_groups` VALUES(17, 0, 'ROOT', 1, 22, 'ROOT'); INSERT INTO `jos_60144_core_acl_aro_groups` VALUES(28, 17, 'USERS', 2, 21, 'USERS'); INSERT INTO `jos_60144_core_acl_aro_groups` VALUES(29, 28, 'Public Frontend', 3, 12, 'Public Frontend'); INSERT INTO `jos_60144_core_acl_aro_groups` VALUES(18, 29, 'Registered', 4, 11, 'Registered'); INSERT INTO `jos_60144_core_acl_aro_groups` VALUES(19, 18, 'Author', 5, 10, 'Author'); INSERT INTO `jos_60144_core_acl_aro_groups` VALUES(20, 19, 'Editor', 6, 9, 'Editor'); INSERT INTO `jos_60144_core_acl_aro_groups` VALUES(21, 20, 'Publisher', 7, 8, 'Publisher'); INSERT INTO `jos_60144_core_acl_aro_groups` VALUES(30, 28, 'Public Backend', 13, 20, 'Public Backend'); INSERT INTO `jos_60144_core_acl_aro_groups` VALUES(23, 30, 'Manager', 14, 19, 'Manager'); INSERT INTO `jos_60144_core_acl_aro_groups` VALUES(24, 23, 'Administrator', 15, 18, 'Administrator'); INSERT INTO `jos_60144_core_acl_aro_groups` VALUES(25, 24, 'Super Administrator', 16, 17, 'Super Administrator'); DROP TABLE IF EXISTS `jos_60144_core_acl_aro_map`; CREATE TABLE `jos_60144_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 default '', PRIMARY KEY (`acl_id`,`section_value`,`value`) ); DROP TABLE IF EXISTS `jos_60144_core_acl_aro_sections`; CREATE TABLE `jos_60144_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_60144_gacl_value_aro_sections` (`value`), KEY `jos_60144_gacl_hidden_aro_sections` (`hidden`) ); INSERT INTO `jos_60144_core_acl_aro_sections` VALUES(10, 'users', 1, 'Users', 0); DROP TABLE IF EXISTS `jos_60144_core_acl_groups_aro_map`; CREATE TABLE `jos_60144_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`) ); INSERT INTO `jos_60144_core_acl_groups_aro_map` VALUES(25, '', 10); DROP TABLE IF EXISTS `jos_60144_core_log_items`; CREATE TABLE `jos_60144_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' ); DROP TABLE IF EXISTS `jos_60144_core_log_searches`; CREATE TABLE `jos_60144_core_log_searches` ( `search_term` varchar(128) NOT NULL default '', `hits` int(11) unsigned NOT NULL default '0' ); DROP TABLE IF EXISTS `jos_60144_fb_announcement`; CREATE TABLE IF NOT EXISTS `jos_60144_fb_announcement` ( `id` int(3) NOT NULL auto_increment, `title` tinytext, `sdescription` text NOT NULL, `description` text NOT NULL, `created` datetime NOT NULL default '0000-00-00 00:00:00', `published` tinyint(1) NOT NULL default '0', `ordering` tinyint(4) NOT NULL default '0', `showdate` tinyint(1) NOT NULL default '1', PRIMARY KEY (`id`) ); DROP TABLE IF EXISTS `jos_60144_fb_attachments`; CREATE TABLE IF NOT EXISTS `jos_60144_fb_attachments` ( `mesid` int(11) NOT NULL default '0', `filelocation` text NOT NULL, KEY `mesid` (`mesid`) ); DROP TABLE IF EXISTS `jos_60144_fb_categories`; CREATE TABLE IF NOT EXISTS `jos_60144_fb_categories` ( `id` int(11) NOT NULL auto_increment, `parent` int(11) default '0', `name` tinytext, `cat_emoticon` tinyint(4) NOT NULL default '0', `locked` tinyint(4) NOT NULL default '0', `alert_admin` tinyint(4) NOT NULL default '0', `moderated` tinyint(4) NOT NULL default '1', `moderators` varchar(15) default NULL, `pub_access` tinyint(4) default '1', `pub_recurse` tinyint(4) default '1', `admin_access` tinyint(4) default '0', `admin_recurse` tinyint(4) default '1', `ordering` tinyint(4) NOT NULL default '0', `future2` int(11) default '0', `published` tinyint(4) NOT NULL default '0', `checked_out` tinyint(4) NOT NULL default '0', `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00', `review` tinyint(4) NOT NULL default '0', `hits` int(11) NOT NULL default '0', `description` text NOT NULL, `headerdesc` text NOT NULL, `class_sfx` varchar(20) NOT NULL default '', `id_last_msg` int(10) NOT NULL default '0', `numTopics` mediumint(8) NOT NULL default '0', `numPosts` mediumint(8) NOT NULL default '0', `time_last_msg` int(11) default NULL, PRIMARY KEY (`id`), KEY `parent` (`parent`), KEY `published_pubaccess_id` (`published`,`pub_access`,`id`), KEY `msg_id` (`id_last_msg`) ); INSERT INTO `jos_60144_fb_categories` VALUES ('1', '0', 'Public Forums', '0', '0', '0', '0', null, '0', '0', '0', '0', '1', '0', '1', '0', '0000-00-00 00:00:00', '0', '0', '' , '', '', '0', '0', '0', '0'); INSERT INTO `jos_60144_fb_categories` VALUES ('2', '1', 'Your Opinion', '0', '0', '0', '0', null, '0', '0', '0', '0', '2', '0', '1', '0', '0000-00-00 00:00:00', '0', '0', 'What do you think?', '', '', '0', '0', '0', '0'); INSERT INTO `jos_60144_fb_categories` VALUES ('3', '1', 'Feedback', '0', '0', '0', '0', null, '0', '0', '0', '0', '3', '0', '1', '0', '0000-00-00 00:00:00', '0', '0', 'Share your feedback about the site here.', '', '', '0', '0', '0', '0'); INSERT INTO `jos_60144_fb_categories` VALUES ('4', '1', 'Articles', '0', '0', '0', '0', null, '0', '0', '0', '0', '4', '0', '1', '0', '0000-00-00 00:00:00', '0', '0', '', '', '', '0', '0', '0', '0'); INSERT INTO `jos_60144_fb_categories` VALUES ('5', '1', 'Text Stream', '0', '0', '0', '0', null, '0', '0', '0', '0', '5', '0', '1', '0', '0000-00-00 00:00:00', '0', '0', '', '', '', '0', '0', '0', '0'); DROP TABLE IF EXISTS `jos_60144_fb_discussbot`; CREATE TABLE `jos_60144_fb_discussbot` ( `content_id` int(11) NOT NULL default '0', `section_id` int(11) NOT NULL default '0', `catid` int(11) NOT NULL default '0', `thread_id` int(11) NOT NULL default '0', PRIMARY KEY (`content_id`,`section_id`,`catid`) ); DROP TABLE IF EXISTS `jos_60144_fb_favorites`; CREATE TABLE IF NOT EXISTS `jos_60144_fb_favorites` ( `thread` int(11) NOT NULL default '0', `userid` int(11) NOT NULL default '0', KEY `thread` (`thread`), KEY `userid` (`userid`) ); DROP TABLE IF EXISTS `jos_60144_fb_groups`; CREATE TABLE IF NOT EXISTS `jos_60144_fb_groups` ( `id` int(4) NOT NULL auto_increment, `title` varchar(255) default NULL, PRIMARY KEY (`id`) ) ; INSERT INTO `jos_60144_fb_groups` VALUES(1, 'Registered'); DROP TABLE IF EXISTS `jos_60144_fb_messages`; CREATE TABLE IF NOT EXISTS `jos_60144_fb_messages` ( `id` int(11) NOT NULL auto_increment, `parent` int(11) default '0', `thread` int(11) default '0', `catid` int(11) NOT NULL default '0', `name` tinytext, `userid` int(11) NOT NULL default '0', `email` tinytext, `subject` tinytext, `time` int(11) NOT NULL default '0', `ip` varchar(15) default NULL, `topic_emoticon` int(11) NOT NULL default '0', `locked` tinyint(4) NOT NULL default '0', `hold` tinyint(4) NOT NULL default '0', `ordering` int(11) default '0', `hits` int(11) default '0', `moved` tinyint(4) default '0', `modified_by` int(7) default NULL, `modified_time` int(11) default NULL, `modified_reason` tinytext, PRIMARY KEY (`id`), KEY `thread` (`thread`), KEY `parent` (`parent`), KEY `catid` (`catid`), KEY `ip` (`ip`), KEY `userid` (`userid`), KEY `time` (`time`), KEY `locked` (`locked`), KEY `hold_time` (`hold`,`time`) ); DROP TABLE IF EXISTS `jos_60144_fb_messages_text`; CREATE TABLE IF NOT EXISTS `jos_60144_fb_messages_text` ( `mesid` int(11) NOT NULL default '0', `message` text NOT NULL, PRIMARY KEY (`mesid`) ); DROP TABLE IF EXISTS `jos_60144_fb_moderation`; CREATE TABLE IF NOT EXISTS `jos_60144_fb_moderation` ( `catid` int(11) NOT NULL default '0', `userid` int(11) NOT NULL default '0', `future1` tinyint(4) default '0', `future2` int(11) default '0', PRIMARY KEY (`catid`,`userid`) ); DROP TABLE IF EXISTS `jos_60144_fb_ranks`; CREATE TABLE IF NOT EXISTS `jos_60144_fb_ranks` ( `rank_id` mediumint(8) unsigned NOT NULL auto_increment, `rank_title` varchar(255) NOT NULL default '', `rank_min` mediumint(8) unsigned NOT NULL default '0', `rank_special` tinyint(1) unsigned NOT NULL default '0', `rank_image` varchar(255) NOT NULL default '', PRIMARY KEY (`rank_id`) ) ; INSERT INTO `jos_60144_fb_ranks` VALUES(1, 'Fresh Boarder', 0, 0, 'rank1.gif'); INSERT INTO `jos_60144_fb_ranks` VALUES(2, 'Junior Boarder', 20, 0, 'rank2.gif'); INSERT INTO `jos_60144_fb_ranks` VALUES(3, 'Senior Boarder', 40, 0, 'rank3.gif'); INSERT INTO `jos_60144_fb_ranks` VALUES(4, 'Expert Boarder', 80, 0, 'rank4.gif'); INSERT INTO `jos_60144_fb_ranks` VALUES(5, 'Gold Boarder', 160, 0, 'rank5.gif'); INSERT INTO `jos_60144_fb_ranks` VALUES(6, 'Platinum Boarder', 320, 0, 'rank6.gif'); INSERT INTO `jos_60144_fb_ranks` VALUES(7, 'Administrator', 0, 1, 'rankadmin.gif'); INSERT INTO `jos_60144_fb_ranks` VALUES(8, 'Moderator', 0, 1, 'rankmod.gif'); INSERT INTO `jos_60144_fb_ranks` VALUES(9, 'Spammer', 0, 1, 'rankspammer.gif'); DROP TABLE IF EXISTS `jos_60144_fb_sessions`; CREATE TABLE IF NOT EXISTS `jos_60144_fb_sessions` ( `userid` int(11) NOT NULL default '0', `allowed` text, `lasttime` int(11) NOT NULL default '0', `readtopics` text, `currvisit` int(11) NOT NULL default '0', PRIMARY KEY (`userid`) ); DROP TABLE IF EXISTS `jos_60144_fb_smileys`; CREATE TABLE IF NOT EXISTS `jos_60144_fb_smileys` ( `id` int(4) NOT NULL auto_increment, `code` varchar(12) NOT NULL default '', `location` varchar(50) NOT NULL default '', `greylocation` varchar(60) NOT NULL default '', `emoticonbar` tinyint(4) NOT NULL default '0', PRIMARY KEY (`id`) ) ; INSERT INTO `jos_60144_fb_smileys` VALUES(1, 'B)', 'cool.png', 'cool-grey.png', 1); INSERT INTO `jos_60144_fb_smileys` VALUES(2, ':(', 'sad.png', 'sad-grey.png', 1); INSERT INTO `jos_60144_fb_smileys` VALUES(3, ':)', 'smile.png', 'smile-grey.png', 1); INSERT INTO `jos_60144_fb_smileys` VALUES(4, ':-)', 'smile.png', 'smile-grey.png', 0); INSERT INTO `jos_60144_fb_smileys` VALUES(5, ':-(', 'sad.png', 'sad-grey.png', 0); INSERT INTO `jos_60144_fb_smileys` VALUES(6, ':laugh:', 'laughing.png', 'laughing-grey.png', 1); INSERT INTO `jos_60144_fb_smileys` VALUES(7, ':cheer:', 'cheerful.png', 'cheerful-grey.png', 1); INSERT INTO `jos_60144_fb_smileys` VALUES(8, ';)', 'wink.png', 'wink-grey.png', 1); INSERT INTO `jos_60144_fb_smileys` VALUES(9, ';-)', 'wink.png', 'wink-grey.png', 0); INSERT INTO `jos_60144_fb_smileys` VALUES(10, ':P', 'tongue.png', 'tongue-grey.png', 1); INSERT INTO `jos_60144_fb_smileys` VALUES(12, ':X', 'sick.png', 'sick-grey.png', 0); INSERT INTO `jos_60144_fb_smileys` VALUES(13, ':x', 'sick.png', 'sick-grey.png', 0); INSERT INTO `jos_60144_fb_smileys` VALUES(14, ':angry:', 'angry.png', 'angry-grey.png', 1); INSERT INTO `jos_60144_fb_smileys` VALUES(15, ':mad:', 'angry.png', 'angry-grey.png', 0); INSERT INTO `jos_60144_fb_smileys` VALUES(16, ':unsure:', 'unsure.png', 'unsure-grey.png', 1); INSERT INTO `jos_60144_fb_smileys` VALUES(17, ':ohmy:', 'shocked.png', 'shocked-grey.png', 1); INSERT INTO `jos_60144_fb_smileys` VALUES(18, ':huh:', 'wassat.png', 'wassat-grey.png', 1); INSERT INTO `jos_60144_fb_smileys` VALUES(19, ':dry:', 'ermm.png', 'ermm-grey.png', 1); INSERT INTO `jos_60144_fb_smileys` VALUES(20, ':ermm:', 'ermm.png', 'ermm-grey.png', 0); INSERT INTO `jos_60144_fb_smileys` VALUES(21, ':lol:', 'grin.png', 'grin-grey.png', 1); INSERT INTO `jos_60144_fb_smileys` VALUES(22, ':sick:', 'sick.png', 'sick-grey.png', 1); INSERT INTO `jos_60144_fb_smileys` VALUES(23, ':silly:', 'silly.png', 'silly-grey.png', 1); INSERT INTO `jos_60144_fb_smileys` VALUES(24, ':y32b4:', 'silly.png', 'silly-grey.png', 0); INSERT INTO `jos_60144_fb_smileys` VALUES(25, ':blink:', 'blink.png', 'blink-grey.png', 1); INSERT INTO `jos_60144_fb_smileys` VALUES(26, ':blush:', 'blush.png', 'blush-grey.png', 1); INSERT INTO `jos_60144_fb_smileys` VALUES(27, ':kiss:', 'kissing.png', 'kissing-grey.png', 1); INSERT INTO `jos_60144_fb_smileys` VALUES(28, ':rolleyes:', 'blink.png', 'blink-grey.png', 0); INSERT INTO `jos_60144_fb_smileys` VALUES(29, ':woohoo:', 'w00t.png', 'w00t-grey.png', 1); INSERT INTO `jos_60144_fb_smileys` VALUES(30, ':side:', 'sideways.png', 'sideways-grey.png', 1); INSERT INTO `jos_60144_fb_smileys` VALUES(31, ':S', 'dizzy.png', 'dizzy-grey.png', 1); INSERT INTO `jos_60144_fb_smileys` VALUES(32, ':s', 'dizzy.png', 'dizzy-grey.png', 0); INSERT INTO `jos_60144_fb_smileys` VALUES(33, ':evil:', 'devil.png', 'devil-grey.png', 1); INSERT INTO `jos_60144_fb_smileys` VALUES(34, ':whistle:', 'whistling.png', 'whistling-grey.png', 1); INSERT INTO `jos_60144_fb_smileys` VALUES(35, ':pinch:', 'pinch.png', 'pinch-grey.png', 1); INSERT INTO `jos_60144_fb_smileys` VALUES(36, ':p', 'tongue.png', 'tongue-grey.png', 0); INSERT INTO `jos_60144_fb_smileys` VALUES(37, ':D', 'laughing.png', 'laughing-grey.png', 0); DROP TABLE IF EXISTS `jos_60144_fb_subscriptions`; CREATE TABLE IF NOT EXISTS `jos_60144_fb_subscriptions` ( `thread` int(11) NOT NULL default '0', `userid` int(11) NOT NULL default '0', `future1` int(11) default '0', KEY `thread` (`thread`), KEY `userid` (`userid`) ); DROP TABLE IF EXISTS `jos_60144_fb_users`; CREATE TABLE IF NOT EXISTS `jos_60144_fb_users` ( `userid` int(11) NOT NULL default '0', `view` varchar(8) NOT NULL default 'flat', `signature` text, `moderator` int(11) default '0', `ordering` int(11) default '0', `posts` int(11) default '0', `avatar` varchar(50) default NULL, `karma` int(11) default '0', `karma_time` int(11) default '0', `group_id` int(4) default '1', `uhits` int(11) default '0', `personalText` tinytext, `gender` tinyint(4) NOT NULL default '0', `birthdate` date NOT NULL default '0001-01-01', `location` varchar(50) default NULL, `ICQ` varchar(50) default NULL, `AIM` varchar(50) default NULL, `YIM` varchar(50) default NULL, `MSN` varchar(50) default NULL, `SKYPE` varchar(50) default NULL, `GTALK` varchar(50) default NULL, `websitename` varchar(50) default NULL, `websiteurl` varchar(50) default NULL, `rank` tinyint(4) NOT NULL default '0', `hideEmail` tinyint(1) NOT NULL default '1', `showOnline` tinyint(1) NOT NULL default '1', PRIMARY KEY (`userid`), KEY `group_id` (`group_id`) ); DROP TABLE IF EXISTS `jos_60144_fb_whoisonline`; CREATE TABLE IF NOT EXISTS `jos_60144_fb_whoisonline` ( `id` int(6) NOT NULL auto_increment, `userid` int(7) NOT NULL default '0', `time` varchar(14) NOT NULL default '0', `item` int(6) default '0', `what` varchar(255) default '0', `func` varchar(50) default NULL, `do` varchar(50) default NULL, `task` varchar(50) default NULL, `link` text, `userip` varchar(20) NOT NULL default '', `user` tinyint(2) NOT NULL default '0', PRIMARY KEY (`id`), KEY `userid` (`userid`) ); DROP TABLE IF EXISTS `jos_60144_groups`; CREATE TABLE `jos_60144_groups` ( `id` tinyint(3) unsigned NOT NULL default '0', `name` varchar(50) NOT NULL default '', PRIMARY KEY (`id`) ); INSERT INTO `jos_60144_groups` VALUES(0, 'Public'); INSERT INTO `jos_60144_groups` VALUES(1, 'Registered'); INSERT INTO `jos_60144_groups` VALUES(2, 'Special'); DROP TABLE IF EXISTS `jos_60144_linx`; CREATE TABLE IF NOT EXISTS `jos_60144_linx` ( `id` int(11) NOT NULL auto_increment, `url` text NOT NULL, `link_name` text NOT NULL, `link_description` text NOT NULL, `submitters_name` varchar(250) NOT NULL default '', `submitters_email` varchar(250) NOT NULL default '', `link_status` tinyint(4) NOT NULL default '0', `cat_id` int(11) NOT NULL default '0', `recip_url` varchar(250) NOT NULL default '', `date_added` varchar(20) NOT NULL default '0', `email_confirmation_code` varchar(10) NOT NULL default '', `show_in_admin` tinyint(4) NOT NULL default '1', `email_confirmed` tinyint(1) NOT NULL default '0', `recip_link_date_check` varchar(20) NOT NULL default '0', `recip_link_status` tinyint(1) NOT NULL default '1', `activation_code` varchar(10) NOT NULL default '', PRIMARY KEY (`id`) ) ; DROP TABLE IF EXISTS `jos_60144_linx_cats`; CREATE TABLE IF NOT EXISTS `jos_60144_linx_cats` ( `id` int(11) NOT NULL auto_increment, `cat_name` varchar(150) NOT NULL default '', `cat_published` tinyint(4) NOT NULL default '1', `ordering` int(11) NOT NULL default '0', `allow_submit` tinyint(4) NOT NULL default '1', PRIMARY KEY (`id`) ) ; INSERT INTO `jos_60144_linx_cats` VALUES ('1', 'Articles', '1', '1','1'); INSERT INTO `jos_60144_linx_cats` VALUES ('2', 'Text Stream', '1', '2','1'); DROP TABLE IF EXISTS `jos_60144_linx_settings`; CREATE TABLE IF NOT EXISTS `jos_60144_linx_settings` ( `id` int(11) NOT NULL auto_increment, `use_cats` tinyint(4) NOT NULL default '1', `cat_display_columns` tinyint(4) NOT NULL default '1', `require_recip_link` tinyint(4) NOT NULL default '1', `my_url` varchar(250) NOT NULL default '', `my_link_name` varchar(250) NOT NULL default '', `my_link_description` text NOT NULL, `use_description` tinyint(4) NOT NULL default '1', `description_maxlength` int(4) NOT NULL default '250', `recip_link_timeout_secconds` varchar(20) NOT NULL default '7776000', `links_per_page` tinyint(4) NOT NULL default '20', `use_curl` tinyint(4) NOT NULL default '0', `debug` tinyint(4) NOT NULL default '0', `enable_email_accept_links` tinyint(4) NOT NULL default '1', `recieve_link_emails` tinyint(4) NOT NULL default '1', `require_email_verification` tinyint(4) NOT NULL default '1', `send_link_accepted_emails` tinyint(4) NOT NULL default '1', `links_sort_order` varchar(6) NOT NULL default 'ASC', `links_sort_row` varchar(20) NOT NULL default 'date_added', PRIMARY KEY (`id`) ) ; INSERT INTO `jos_60144_linx_settings` VALUES(1, 1, 2, 1, 'http://www.reubenpace.com', 'Male enhancement', 'Male enhancement', 1, 400, '7776000', 10, 0, 0, 1, 1, 1, 1, 'ASC', 'date_added'); DROP TABLE IF EXISTS `jos_60144_menu`; CREATE TABLE `jos_60144_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`) ); INSERT INTO `jos_60144_menu` VALUES(1, 'mainmenu', 'Home', 'home', 'index.php?option=com_content&view=frontpage', 'component', 1, 0, 20, 0, 1, 0, '0000-00-00 00:00:00', 0, 0, 0, 3, 'num_leading_articles=1\nnum_intro_articles=0\nnum_columns=1\nnum_links=5\norderby_pri=order\norderby_sec=order\nshow_pagination=2\nshow_pagination_results=1\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=\nfeed_summary=\npage_title=Male enhancement\nshow_page_title=1\npageclass_sfx=\nmenu_image=-1\nsecure=0\n\n', 0, 0, 1); INSERT INTO `jos_60144_menu` VALUES(2, 'mainmenu', 'Contact Us', 'contactus', 'index.php?option=com_contact&view=contact&id=1', 'component', 1, 0, 7, 0, 2, 0, '2000-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=\npage_title=\nshow_page_title=1\npageclass_sfx=\nmenu_image=-1\nsecure=0\n\n', 0, 0, 0); INSERT INTO `jos_60144_menu` VALUES(3, 'usermenu', 'User Menu', 'usermenu', 'index.php?option=com_user&view=user', 'component', 1, 0, 14, 0, 1, 0, '0000-00-00 00:00:00', 0, 0, 1, 0, 'page_title=\nshow_page_title=1\npageclass_sfx=\nmenu_image=-1\nsecure=0\n\n', 0, 0, 0); INSERT INTO `jos_60144_menu` VALUES(4, 'mainmenu', 'Links', 'linx', 'index.php?option=com_linx', 'component', 1, 0, 43, 0, 3, 0, '0000-00-00 00:00:00', 0, 0, 0, 0, 'page_title=\nshow_page_title=1\npageclass_sfx=\nmenu_image=-1\nsecure=0\n\n', 0, 0, 0); INSERT INTO `jos_60144_menu` VALUES(5, 'usermenu', 'Profile', 'profile', 'index.php?option=com_comprofiler', 'component', 1, 0, 35, 0, 2, 0, '0000-00-00 00:00:00', 0, 0, 1, 0, 'page_title= show_page_title=1 pageclass_sfx= menu_image=-1 secure=0 ', 0, 0, 0); INSERT INTO `jos_60144_menu` VALUES(6, 'usermenu', 'Post Article', 'post', 'index.php?option=com_content&view=article&layout=form', 'component', 1, 0, 20, 0, 3, 0, '0000-00-00 00:00:00', 0, 0, 1, 0, 'show_noauth= show_title= link_titles= show_intro= show_section= link_section= show_category= link_category= show_author= show_create_date= show_modify_date= show_item_navigation= show_readmore= show_vote= show_icons= show_pdf_icon= show_print_icon= show_email_icon= show_hits= feed_summary= page_title= show_page_title=1 pageclass_sfx= menu_image=-1 secure=0 ', 0, 0, 0); INSERT INTO `jos_60144_menu` VALUES(7, 'mainmenu', 'Forums', 'forums', 'index.php?option=com_fireboard', 'component', 0, 0, 34, 0, 4, 0, '0000-00-00 00:00:00', 0, 0, 0, 0, 'page_title= show_page_title=1 pageclass_sfx= menu_image=-1 secure=0 ', 0, 0, 0); DROP TABLE IF EXISTS `jos_60144_menu_types`; CREATE TABLE `jos_60144_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`) ); INSERT INTO `jos_60144_menu_types` VALUES(1, 'mainmenu', 'Main Menu', 'The main menu for the site'); INSERT INTO `jos_60144_menu_types` VALUES(2, 'usermenu', 'User Menu', 'for users'); DROP TABLE IF EXISTS `jos_60144_messages`; CREATE TABLE `jos_60144_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`) ); DROP TABLE IF EXISTS `jos_60144_messages_cfg`; CREATE TABLE `jos_60144_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`) ); DROP TABLE IF EXISTS `jos_60144_migration_backlinks`; CREATE TABLE `jos_60144_migration_backlinks` ( `itemid` int(11) NOT NULL default '0', `name` varchar(100) NOT NULL default '', `url` text NOT NULL, `sefurl` text NOT NULL, `newurl` text NOT NULL, PRIMARY KEY (`itemid`) ); DROP TABLE IF EXISTS `jos_60144_modules`; CREATE TABLE `jos_60144_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`) ); INSERT INTO `jos_60144_modules` VALUES(1, 'Main Menu', '', 0, 'left', 0, '0000-00-00 00:00:00', 1, 'mod_mainmenu', 0, 0, 0, 'menutype=mainmenu\nmenu_style=vert_indent\nstartLevel=0\nendLevel=0\nshowAllChildren=0\nwindow_open=\nshow_whitespace=0\ncache=1\ntag_id=\nclass_sfx=\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_image1=\nindent_image2=\nindent_image3=\nindent_image4=\nindent_image5=\nindent_image6=\nspacer=\nend_spacer=\n\n', 1, 0, ''); INSERT INTO `jos_60144_modules` VALUES(2, 'Admin Login', '', 1, 'login', 0, '0000-00-00 00:00:00', 0, 'mod_login', 0, 0, 1, '', 1, 1, ''); INSERT INTO `jos_60144_modules` VALUES(3, 'Popular', '', 3, 'cpanel', 0, '0000-00-00 00:00:00', 1, 'mod_popular', 0, 2, 1, '', 0, 1, ''); INSERT INTO `jos_60144_modules` VALUES(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, ''); INSERT INTO `jos_60144_modules` VALUES(5, 'Menu Stats', '', 5, 'cpanel', 0, '0000-00-00 00:00:00', 1, 'mod_stats', 0, 2, 1, '', 0, 1, ''); INSERT INTO `jos_60144_modules` VALUES(6, 'Unread Messages', '', 1, 'header', 0, '0000-00-00 00:00:00', 1, 'mod_unread', 0, 2, 1, '', 1, 1, ''); INSERT INTO `jos_60144_modules` VALUES(7, 'Online Users', '', 2, 'header', 0, '0000-00-00 00:00:00', 1, 'mod_online', 0, 2, 1, '', 1, 1, ''); INSERT INTO `jos_60144_modules` VALUES(8, 'Toolbar', '', 1, 'toolbar', 0, '0000-00-00 00:00:00', 1, 'mod_toolbar', 0, 2, 1, '', 1, 1, ''); INSERT INTO `jos_60144_modules` VALUES(9, 'Quick Icons', '', 1, 'icon', 0, '0000-00-00 00:00:00', 1, 'mod_quickicon', 0, 2, 1, '', 1, 1, ''); INSERT INTO `jos_60144_modules` VALUES(10, 'Logged in Users', '', 2, 'cpanel', 0, '0000-00-00 00:00:00', 1, 'mod_logged', 0, 2, 1, '', 0, 1, ''); INSERT INTO `jos_60144_modules` VALUES(11, 'Footer', '', 0, 'footer', 0, '0000-00-00 00:00:00', 1, 'mod_footer', 0, 0, 1, '', 1, 1, ''); INSERT INTO `jos_60144_modules` VALUES(12, 'Admin Menu', '', 1, 'menu', 0, '0000-00-00 00:00:00', 1, 'mod_menu', 0, 2, 1, '', 0, 1, ''); INSERT INTO `jos_60144_modules` VALUES(13, 'Admin SubMenu', '', 1, 'submenu', 0, '0000-00-00 00:00:00', 1, 'mod_submenu', 0, 2, 1, '', 0, 1, ''); INSERT INTO `jos_60144_modules` VALUES(14, 'User Status', '', 1, 'status', 0, '0000-00-00 00:00:00', 1, 'mod_status', 0, 2, 1, '', 0, 1, ''); INSERT INTO `jos_60144_modules` VALUES(15, 'Title', '', 1, 'title', 0, '0000-00-00 00:00:00', 1, 'mod_title', 0, 2, 1, '', 0, 1, ''); INSERT INTO `jos_60144_modules` VALUES(17, 'User Login', '', 4, 'left', 0, '0000-00-00 00:00:00', 1, 'mod_cblogin', 0, 0, 1, 'moduleclass_sfx= horizontal=0 compact=0 pretext= posttext= login= logout=index.php show_lostpass=1 show_newaccount=1 name_lenght=10 pass_lenght=10 login_message=0 logout_message=0 remember_enabled=2 greeting=1 name=0 show_avatar=2 avatar_position=default pms_type=0 show_pms=0 show_connection_notifications=0 https_post=0', 0, 0, ''); INSERT INTO `jos_60144_modules` VALUES(18, 'CB Workflows', '', 5, 'left', 0, '0000-00-00 00:00:00', 0, 'mod_comprofilermoderator', 0, 0, 1, '', 0, 0, ''); INSERT INTO `jos_60144_modules` VALUES(19, 'CB Online', '', 6, 'left', 0, '0000-00-00 00:00:00', 0, 'mod_comprofileronline', 0, 0, 1, '', 0, 0, ''); INSERT INTO `jos_60144_modules` VALUES(42, 'crumbs', '', 1, 'breadcrumb', 0, '0000-00-00 00:00:00', 1, 'mod_breadcrumbs', 0, 0, 0, 'showHome=1\nhomeText=Home\nseparator=\\|\nmoduleclass_sfx=\ncache=0\ncache_time=900\n\n', 0, 0, ''); INSERT INTO `jos_60144_modules` VALUES(39, 'NewsFlash', '', 1, 'newsflash', 0, '0000-00-00 00:00:00', 0, 'mod_newsflash', 0, 0, 0, 'catid=0\nlayout=default\nimage=0\nlink_titles=\nshowLastSeparator=1\nreadmore=0\nitem_title=0\nitems=\nmoduleclass_sfx=\ncache=0\ncache_time=900\n\n', 0, 0, ''); INSERT INTO `jos_60144_modules` VALUES(38, 'Latest News', '', 1, 'right', 0, '0000-00-00 00:00:00', 1, 'mod_latestnews', 0, 0, 1, 'count=10 ordering=c_dsc user_id=0 show_front=1 secid= catid= moduleclass_sfx= cache=1 cache_time=900 ', 0, 0, ''); INSERT INTO `jos_60144_modules` VALUES(37, 'Banner', '', 1, 'banner', 0, '0000-00-00 00:00:00', 0, 'mod_banners', 0, 0, 0, 'target=1\ncount=1\ncid=0\ncatid=0\ntag_search=0\nordering=0\nheader_text=\nfooter_text=\nmoduleclass_sfx=\ncache=1\ncache_time=900\n\n', 0, 0, ''); INSERT INTO `jos_60144_modules` VALUES(36, 'Footer', '', 0, 'footer', 0, '0000-00-00 00:00:00', 0, 'mod_footer', 0, 0, 0, 'cache=1\n\n', 0, 0, ''); INSERT INTO `jos_60144_modules` VALUES(35, 'Search', '', 0, 'right', 0, '0000-00-00 00:00:00', 0, 'mod_search', 0, 0, 0, 'moduleclass_sfx=search\nwidth=20\ntext=Search\nbutton=\nbutton_pos=left\nimagebutton=\nbutton_text=Search\ncache=1\ncache_time=900\n\n', 0, 0, ''); INSERT INTO `jos_60144_modules` VALUES(34, 'Login', '', 3, 'left', 0, '0000-00-00 00:00:00', 0, 'mod_login', 0, 0, 1, 'cache=0\nmoduleclass_sfx=\npretext=\nposttext=\nlogin=\nlogout=\ngreeting=1\nname=0\nusesecure=0\n\n', 0, 0, ''); INSERT INTO `jos_60144_modules` VALUES(41, 'Top Menu', '', 0, 'user3', 0, '0000-00-00 00:00:00', 0, 'mod_mainmenu', 0, 0, 0, 'menutype=mainmenu\nmenu_style=list\nstartLevel=1\nendLevel=1\nshowAllChildren=0\nwindow_open=\nshow_whitespace=1\ncache=1\ntag_id=\nclass_sfx=\nmoduleclass_sfx=\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=3\nindent_image1=\nindent_image2=\nindent_image3=\nindent_image4=\nindent_image5=\nindent_image6=\nspacer=\nend_spacer=\n\n', 0, 0, ''); INSERT INTO `jos_60144_modules` VALUES(40, 'User Menu', '', 7, 'left', 0, '0000-00-00 00:00:00', 1, 'mod_mainmenu', 0, 1, 1, 'menutype=usermenu\nmenu_style=list\nstartLevel=0\nendLevel=0\nshowAllChildren=0\nwindow_open=\nshow_whitespace=0\ncache=1\ntag_id=\nclass_sfx=\nmoduleclass_sfx=\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_image1=\nindent_image2=\nindent_image3=\nindent_image4=\nindent_image5=\nindent_image6=\nspacer=\nend_spacer=\n\n', 0, 0, ''); INSERT INTO `jos_60144_modules` VALUES(29, 'LinX in a category', '', 17, 'left', 0, '0000-00-00 00:00:00', 0, 'mod_linx_cat', 0, 0, 1, '', 0, 0, ''); INSERT INTO `jos_60144_modules` VALUES(20, 'RSS', '', 18, 'left', 0, '0000-00-00 00:00:00', 1, 'mod_syndicate', 0, 0, 0, 'cache=0 text=Feed Entries format=rss moduleclass_sfx= ', 0, 0, ''); DROP TABLE IF EXISTS `jos_60144_modules_menu`; CREATE TABLE `jos_60144_modules_menu` ( `moduleid` int(11) NOT NULL default '0', `menuid` int(11) NOT NULL default '0', PRIMARY KEY (`moduleid`,`menuid`) ); INSERT INTO `jos_60144_modules_menu` VALUES(1, 0); INSERT INTO `jos_60144_modules_menu` VALUES(17, 0); INSERT INTO `jos_60144_modules_menu` VALUES(18, 0); INSERT INTO `jos_60144_modules_menu` VALUES(19, 0); INSERT INTO `jos_60144_modules_menu` VALUES(20, 0); INSERT INTO `jos_60144_modules_menu` VALUES(34, 1); INSERT INTO `jos_60144_modules_menu` VALUES(34, 2); INSERT INTO `jos_60144_modules_menu` VALUES(35, 0); INSERT INTO `jos_60144_modules_menu` VALUES(36, 0); INSERT INTO `jos_60144_modules_menu` VALUES(37, 0); INSERT INTO `jos_60144_modules_menu` VALUES(38, 0); INSERT INTO `jos_60144_modules_menu` VALUES(39, 0); INSERT INTO `jos_60144_modules_menu` VALUES(40, 0); INSERT INTO `jos_60144_modules_menu` VALUES(41, 0); INSERT INTO `jos_60144_modules_menu` VALUES(42, 0); INSERT INTO `jos_60144_modules_menu` VALUES(29, 0); DROP TABLE IF EXISTS `jos_60144_newsfeeds`; CREATE TABLE `jos_60144_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`) ); DROP TABLE IF EXISTS `jos_60144_plugins`; CREATE TABLE `jos_60144_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`) ); INSERT INTO `jos_60144_plugins` VALUES(1, 'Authentication - Joomla', 'joomla', 'authentication', 0, 1, 1, 1, 0, 0, '0000-00-00 00:00:00', ''); INSERT INTO `jos_60144_plugins` VALUES(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'); INSERT INTO `jos_60144_plugins` VALUES(3, 'Authentication - GMail', 'gmail', 'authentication', 0, 4, 0, 0, 0, 0, '0000-00-00 00:00:00', ''); INSERT INTO `jos_60144_plugins` VALUES(4, 'Authentication - OpenID', 'openid', 'authentication', 0, 3, 0, 0, 0, 0, '0000-00-00 00:00:00', ''); INSERT INTO `jos_60144_plugins` VALUES(5, 'User - Joomla!', 'joomla', 'user', 0, 0, 1, 0, 0, 0, '0000-00-00 00:00:00', 'autoregister=1\n\n'); INSERT INTO `jos_60144_plugins` VALUES(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'); INSERT INTO `jos_60144_plugins` VALUES(7, 'Search - Contacts', 'contacts', 'search', 0, 3, 1, 1, 0, 0, '0000-00-00 00:00:00', 'search_limit=50\n\n'); INSERT INTO `jos_60144_plugins` VALUES(8, 'Search - Categories', 'categories', 'search', 0, 4, 1, 0, 0, 0, '0000-00-00 00:00:00', 'search_limit=50\n\n'); INSERT INTO `jos_60144_plugins` VALUES(9, 'Search - Sections', 'sections', 'search', 0, 5, 1, 0, 0, 0, '0000-00-00 00:00:00', 'search_limit=50\n\n'); INSERT INTO `jos_60144_plugins` VALUES(10, 'Search - Newsfeeds', 'newsfeeds', 'search', 0, 6, 1, 0, 0, 0, '0000-00-00 00:00:00', 'search_limit=50\n\n'); INSERT INTO `jos_60144_plugins` VALUES(11, 'Search - Weblinks', 'weblinks', 'search', 0, 2, 1, 1, 0, 0, '0000-00-00 00:00:00', 'search_limit=50\n\n'); INSERT INTO `jos_60144_plugins` VALUES(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'); INSERT INTO `jos_60144_plugins` VALUES(13, 'Content - Rating', 'vote', 'content', 0, 4, 1, 1, 0, 0, '0000-00-00 00:00:00', ''); INSERT INTO `jos_60144_plugins` VALUES(14, 'Content - Email Cloaking', 'emailcloak', 'content', 0, 5, 1, 0, 0, 0, '0000-00-00 00:00:00', 'mode=1\n\n'); INSERT INTO `jos_60144_plugins` VALUES(15, 'Content - Code Hightlighter (GeSHi)', 'geshi', 'content', 0, 5, 0, 0, 0, 0, '0000-00-00 00:00:00', ''); INSERT INTO `jos_60144_plugins` VALUES(16, 'Content - Load Module', 'loadmodule', 'content', 0, 6, 1, 0, 0, 0, '0000-00-00 00:00:00', 'enabled=1\nstyle=0\n\n'); INSERT INTO `jos_60144_plugins` VALUES(17, 'Content - Page Navigation', 'pagenavigation', 'content', 0, 2, 1, 1, 0, 0, '0000-00-00 00:00:00', 'position=1\n\n'); INSERT INTO `jos_60144_plugins` VALUES(18, 'Editor - No Editor', 'none', 'editors', 0, 0, 1, 1, 0, 0, '0000-00-00 00:00:00', ''); INSERT INTO `jos_60144_plugins` VALUES(19, 'Editor - TinyMCE 2.0', 'tinymce', 'editors', 0, 0, 1, 1, 0, 0, '0000-00-00 00:00:00', 'theme=advanced\ncleanup=1\ncleanup_startup=0\nautosave=0\ncompressed=0\nrelative_urls=1\ntext_direction=ltr\nlang_mode=0\nlang_code=en\ninvalid_elements=applet\ncontent_css=1\ncontent_css_custom=\nnewlines=0\ntoolbar=top\nhr=1\nsmilies=1\ntable=1\nstyle=1\nlayer=1\nxhtmlxtras=0\ntemplate=0\ndirectionality=1\nfullscreen=1\nhtml_height=550\nhtml_width=750\npreview=1\ninsertdate=1\nformat_date=%Y-%m-%d\ninserttime=1\nformat_time=%H:%M:%S\n\n'); INSERT INTO `jos_60144_plugins` VALUES(20, 'Editor - XStandard Lite 2.0', 'xstandard', 'editors', 0, 0, 0, 1, 0, 0, '0000-00-00 00:00:00', ''); INSERT INTO `jos_60144_plugins` VALUES(21, 'Editor Button - Image', 'image', 'editors-xtd', 0, 0, 1, 0, 0, 0, '0000-00-00 00:00:00', ''); INSERT INTO `jos_60144_plugins` VALUES(22, 'Editor Button - Pagebreak', 'pagebreak', 'editors-xtd', 0, 0, 1, 0, 0, 0, '0000-00-00 00:00:00', ''); INSERT INTO `jos_60144_plugins` VALUES(23, 'Editor Button - Readmore', 'readmore', 'editors-xtd', 0, 0, 1, 0, 0, 0, '0000-00-00 00:00:00', ''); INSERT INTO `jos_60144_plugins` VALUES(24, 'XML-RPC - Joomla', 'joomla', 'xmlrpc', 0, 7, 0, 1, 0, 0, '0000-00-00 00:00:00', ''); INSERT INTO `jos_60144_plugins` VALUES(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'); INSERT INTO `jos_60144_plugins` VALUES(27, 'System - SEF', 'sef', 'system', 0, 1, 1, 0, 0, 0, '0000-00-00 00:00:00', ''); INSERT INTO `jos_60144_plugins` VALUES(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'); INSERT INTO `jos_60144_plugins` VALUES(29, 'System - Legacy', 'legacy', 'system', 0, 3, 1, 1, 0, 0, '0000-00-00 00:00:00', 'route=0\n\n'); INSERT INTO `jos_60144_plugins` VALUES(30, 'System - Cache', 'cache', 'system', 0, 4, 0, 1, 0, 0, '0000-00-00 00:00:00', 'browsercache=0\ncachetime=15\n\n'); INSERT INTO `jos_60144_plugins` VALUES(31, 'System - Log', 'log', 'system', 0, 5, 0, 1, 0, 0, '0000-00-00 00:00:00', ''); INSERT INTO `jos_60144_plugins` VALUES(32, 'System - Remember Me', 'remember', 'system', 0, 6, 1, 1, 0, 0, '0000-00-00 00:00:00', ''); INSERT INTO `jos_60144_plugins` VALUES(33, 'System - Backlink', 'backlink', 'system', 0, 7, 0, 1, 0, 0, '0000-00-00 00:00:00', ''); INSERT INTO `jos_60144_plugins` VALUES(34, 'ObjectClarity Fireboard Discussbot', 'fbdiscussbot', 'content', '0', '0', '1', '0', '0', '0', '0000-00-00 00:00:00', 'fb_post_limit=25\nfirst_posts=0\nlast_post_top=0\nuse_button=0\ncopy_content=0\nform=0\nshow_smilies=0\nallow_public=0\nquickpost_open=0\nquickpost_on_top=0\nshow_front_page=1\nenable_auto_post=0\nallow_manual_override=0\nfallback_subject=1\nauto_catg_pairs=\nauto_catg_id=0\nonly_sections=\nignore_sections=\nonly_catgs=\nignore_catgs=\nfirst_post_owner=\nshow_debug=0\nshow_debug_userids=\n\n'); INSERT INTO `jos_60144_plugins` VALUES(35, 'System - Bad Behaviour', 'badbehaviour', 'system', 0, 0, 1, 0, 0, 0, "0000-00-00 00:00:00", 'strict =0\nemail=\njsecure=1\n\n'); DROP TABLE IF EXISTS `jos_60144_polls`; CREATE TABLE `jos_60144_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`) ); DROP TABLE IF EXISTS `jos_60144_poll_data`; CREATE TABLE `jos_60144_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)) ); DROP TABLE IF EXISTS `jos_60144_poll_date`; CREATE TABLE `jos_60144_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`) ); DROP TABLE IF EXISTS `jos_60144_poll_menu`; CREATE TABLE `jos_60144_poll_menu` ( `pollid` int(11) NOT NULL default '0', `menuid` int(11) NOT NULL default '0', PRIMARY KEY (`pollid`,`menuid`) ); DROP TABLE IF EXISTS `jos_60144_sections`; CREATE TABLE `jos_60144_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`) ); DROP TABLE IF EXISTS `jos_60144_session`; CREATE TABLE `jos_60144_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`) ); INSERT INTO `jos_60144_session` VALUES('', '1210287482', '813b224490ae1e95858dea8b7da870d5', 1, 0, '', 0, 0, '__default|a:8:{s:15:"session.counter";i:2;s:19:"session.timer.start";i:1210287474;s:18:"session.timer.last";i:1210287474;s:17:"session.timer.now";i:1210287482;s:22:"session.client.browser";s:92:"Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.14) Gecko/20080404 Firefox/2.0.0.14";s:8:"registry";O:9:"jregistry":3:{s:7:"_errors";a:0:{}s:17:"_defaultNameSpace";s:7:"session";s:9:"_registry";a:1:{s:7:"session";a:1:{s:4:"data";O:8:"stdClass":0:{}}}}s:4:"user";O:5:"juser":19:{s:7:"_errors";a:0:{}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:66:"/home/autoreso/public_html/libraries/joomla/html/parameter/element";}s:7:"_errors";a:0:{}s:17:"_defaultNameSpace";s:8:"_default";s:9:"_registry";a:1:{s:8:"_default";a:1:{s:4:"data";O:8:"stdClass":0:{}}}}s:9:"_errorMsg";N;}s:13:"session.token";s:32:"cf96440064649d783d3a16ce2b90d406";}'); DROP TABLE IF EXISTS `jos_60144_stats_agents`; CREATE TABLE `jos_60144_stats_agents` ( `agent` varchar(255) NOT NULL default '', `type` tinyint(1) unsigned NOT NULL default '0', `hits` int(11) unsigned NOT NULL default '1' ); DROP TABLE IF EXISTS `jos_60144_templates_menu`; CREATE TABLE `jos_60144_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`) ); INSERT INTO `jos_60144_templates_menu` VALUES('rt_elemental_j15', 0, 0); INSERT INTO `jos_60144_templates_menu` VALUES('khepri', 0, 1); DROP TABLE IF EXISTS `jos_60144_users`; CREATE TABLE `jos_60144_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`) ); INSERT INTO `jos_60144_users` VALUES(62, 'Webmaster', 'admin', 'joomla@seonitro.com', md5('seonitro'), 'Super Administrator', 0, 1, 25, '2008-05-03 13:13:40', '2008-05-08 22:49:57', '', 'admin_language= language= editor=tinymce helpsite= timezone=-5 '); DROP TABLE IF EXISTS `jos_60144_weblinks`; CREATE TABLE `jos_60144_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`) );