daily pastebin goal
20%
SHARE
TWEET

Untitled

a guest Jul 21st, 2017 58 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. # $Id: joomla.sql 18130 2010-07-14 11:21:35Z louis $
  2.  
  3. # --------------------------------------------------------
  4.  
  5. #
  6. # Table structure for table `#__banner`
  7. #
  8.  
  9. CREATE TABLE `#__banner` (
  10.   `bid` int(11) NOT NULL auto_increment,
  11.   `cid` int(11) NOT NULL default '0',
  12.   `type` varchar(30) NOT NULL default 'banner',
  13.   `name` varchar(255) NOT NULL default '',
  14.   `alias` varchar(255) NOT NULL default '',
  15.   `imptotal` int(11) NOT NULL default '0',
  16.   `impmade` int(11) NOT NULL default '0',
  17.   `clicks` int(11) NOT NULL default '0',
  18.   `imageurl` varchar(100) NOT NULL default '',
  19.   `clickurl` varchar(200) NOT NULL default '',
  20.   `date` datetime default NULL,
  21.   `showBanner` tinyint(1) NOT NULL default '0',
  22.   `checked_out` tinyint(1) NOT NULL default '0',
  23.   `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
  24.   `editor` varchar(50) default NULL,
  25.   `custombannercode` text,
  26.   `catid` INTEGER UNSIGNED NOT NULL DEFAULT 0,
  27.   `description` TEXT NOT NULL '',
  28.   `sticky` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0,
  29.   `ordering` INTEGER NOT NULL DEFAULT 0,
  30.   `publish_up` datetime NOT NULL default '0000-00-00 00:00:00',
  31.   `publish_down` datetime NOT NULL default '0000-00-00 00:00:00',
  32.   `tags` TEXT NOT NULL '',
  33.   `params` TEXT NOT NULL '',
  34.   PRIMARY KEY  (`bid`),
  35.   KEY `viewbanner` (`showBanner`),
  36.   INDEX `idx_banner_catid`(`catid`)
  37. ) TYPE=MyISAM CHARACTER SET `utf8`;
  38.  
  39. # --------------------------------------------------------
  40.  
  41. #
  42. # Table structure for table `#__bannerclient`
  43. #
  44.  
  45. CREATE TABLE `#__bannerclient` (
  46.   `cid` int(11) NOT NULL auto_increment,
  47.   `name` varchar(255) NOT NULL default '',
  48.   `contact` varchar(255) NOT NULL default '',
  49.   `email` varchar(255) NOT NULL default '',
  50.   `extrainfo` text NOT NULL,
  51.   `checked_out` tinyint(1) NOT NULL default '0',
  52.   `checked_out_time` time default NULL,
  53.   `editor` varchar(50) default NULL,
  54.   PRIMARY KEY  (`cid`)
  55. ) TYPE=MyISAM CHARACTER SET `utf8`;
  56.  
  57. # --------------------------------------------------------
  58.  
  59. #
  60. # Table structure for table `#__bannertrack`
  61. #
  62.  
  63. CREATE TABLE  `#__bannertrack` (
  64.   `track_date` date NOT NULL,
  65.   `track_type` int(10) unsigned NOT NULL,
  66.   `banner_id` int(10) unsigned NOT NULL
  67. ) TYPE=MyISAM CHARACTER SET `utf8`;
  68.  
  69. # --------------------------------------------------------
  70.  
  71. #
  72. # Table structure for table `#__categories`
  73. #
  74.  
  75. CREATE TABLE `#__categories` (
  76.   `id` int(11) NOT NULL auto_increment,
  77.   `parent_id` int(11) NOT NULL default 0,
  78.   `title` varchar(255) NOT NULL default '',
  79.   `name` varchar(255) NOT NULL default '',
  80.   `alias` varchar(255) NOT NULL default '',
  81.   `image` varchar(255) NOT NULL default '',
  82.   `section` varchar(50) NOT NULL default '',
  83.   `image_position` varchar(30) NOT NULL default '',
  84.   `description` text NOT NULL,
  85.   `published` tinyint(1) NOT NULL default '0',
  86.   `checked_out` int(11) unsigned NOT NULL default '0',
  87.   `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
  88.   `editor` varchar(50) default NULL,
  89.   `ordering` int(11) NOT NULL default '0',
  90.   `access` tinyint(3) unsigned NOT NULL default '0',
  91.   `count` int(11) NOT NULL default '0',
  92.   `params` text NOT NULL,
  93.   PRIMARY KEY  (`id`),
  94.   KEY `cat_idx` (`section`,`published`,`access`),
  95.   KEY `idx_access` (`access`),
  96.   KEY `idx_checkout` (`checked_out`)
  97. ) TYPE=MyISAM CHARACTER SET `utf8`;
  98.  
  99. # --------------------------------------------------------
  100.  
  101. #
  102. # Table structure for table `#__components`
  103. #
  104.  
  105. CREATE TABLE `#__components` (
  106.   `id` int(11) NOT NULL auto_increment,
  107.   `name` varchar(50) NOT NULL default '',
  108.   `link` varchar(255) NOT NULL default '',
  109.   `menuid` int(11) unsigned NOT NULL default '0',
  110.   `parent` int(11) unsigned NOT NULL default '0',
  111.   `admin_menu_link` varchar(255) NOT NULL default '',
  112.   `admin_menu_alt` varchar(255) NOT NULL default '',
  113.   `option` varchar(50) NOT NULL default '',
  114.   `ordering` int(11) NOT NULL default '0',
  115.   `admin_menu_img` varchar(255) NOT NULL default '',
  116.   `iscore` tinyint(4) NOT NULL default '0',
  117.   `params` text NOT NULL,
  118.   `enabled` tinyint(4) NOT NULL default '1',
  119.   PRIMARY KEY  (`id`),
  120.   KEY `parent_option` (`parent`, `option`(32))
  121. ) TYPE=MyISAM CHARACTER SET `utf8`;
  122.  
  123. #
  124. # Dumping data for table `#__components`
  125. #
  126.  
  127. INSERT INTO `#__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);
  128. INSERT INTO `#__components` VALUES (2, 'Banners', '', 0, 1, 'option=com_banners', 'Active Banners', 'com_banners', 1, 'js/ThemeOffice/edit.png', 0, '', 1);
  129. INSERT INTO `#__components` VALUES (3, 'Clients', '', 0, 1, 'option=com_banners&c=client', 'Manage Clients', 'com_banners', 2, 'js/ThemeOffice/categories.png', 0, '', 1);
  130. INSERT INTO `#__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);
  131. INSERT INTO `#__components` VALUES (5, 'Links', '', 0, 4, 'option=com_weblinks', 'View existing weblinks', 'com_weblinks', 1, 'js/ThemeOffice/edit.png', 0, '', 1);
  132. INSERT INTO `#__components` VALUES (6, 'Categories', '', 0, 4, 'option=com_categories&section=com_weblinks', 'Manage weblink categories', '', 2, 'js/ThemeOffice/categories.png', 0, '', 1);
  133. INSERT INTO `#__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);
  134. INSERT INTO `#__components` VALUES (8, 'Contacts', '', 0, 7, 'option=com_contact', 'Edit contact details', 'com_contact', 0, 'js/ThemeOffice/edit.png', 1, '', 1);
  135. INSERT INTO `#__components` VALUES (9, 'Categories', '', 0, 7, 'option=com_categories&section=com_contact_details', 'Manage contact categories', '', 2, 'js/ThemeOffice/categories.png', 1, 'contact_icons=0\nicon_address=\nicon_email=\nicon_telephone=\nicon_fax=\nicon_misc=\nshow_headings=1\nshow_position=1\nshow_email=0\nshow_telephone=1\nshow_mobile=1\nshow_fax=1\nbannedEmail=\nbannedSubject=\nbannedText=\nsession=1\ncustomReply=0\n\n', 1);
  136. INSERT INTO `#__components` VALUES (10, 'Polls', 'option=com_poll', 0, 0, 'option=com_poll', 'Manage Polls', 'com_poll', 0, 'js/ThemeOffice/component.png', 0, '', 1);
  137. INSERT INTO `#__components` VALUES (11, 'News Feeds', 'option=com_newsfeeds', 0, 0, '', 'News Feeds Management', 'com_newsfeeds', 0, 'js/ThemeOffice/component.png', 0, '', 1);
  138. INSERT INTO `#__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);
  139. INSERT INTO `#__components` VALUES (13, 'Categories', '', 0, 11, 'option=com_categories&section=com_newsfeeds', 'Manage Categories', '', 2, 'js/ThemeOffice/categories.png', 0, '', 1);
  140. INSERT INTO `#__components` VALUES (14, 'User', 'option=com_user', 0, 0, '', '', 'com_user', 0, '', 1, '', 1);
  141. INSERT INTO `#__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);
  142. INSERT INTO `#__components` VALUES (16, 'Categories', '', 0, 1, 'option=com_categories&section=com_banner', 'Categories', '', 3, '', 1, '', 1);
  143. INSERT INTO `#__components` VALUES (17, 'Wrapper', 'option=com_wrapper', 0, 0, '', 'Wrapper', 'com_wrapper', 0, '', 1, '', 1);
  144. INSERT INTO `#__components` VALUES (18, 'Mail To', '', 0, 0, '', '', 'com_mailto', 0, '', 1, '', 1);
  145. INSERT INTO `#__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', 1);
  146. INSERT INTO `#__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=1\nshow_create_date=1\nshow_modify_date=1\nshow_item_navigation=0\nshow_readmore=1\nshow_vote=0\nshow_icons=1\nshow_pdf_icon=1\nshow_print_icon=1\nshow_email_icon=1\nshow_hits=1\nfeed_summary=0\n\n', 1);
  147. INSERT INTO `#__components` VALUES (21, 'Configuration Manager', '', 0, 0, '', 'Configuration', 'com_config', 0, '', 1, '', 1);
  148. INSERT INTO `#__components` VALUES (22, 'Installation Manager', '', 0, 0, '', 'Installer', 'com_installer', 0, '', 1, '', 1);
  149. INSERT INTO `#__components` VALUES (23, 'Language Manager', '', 0, 0, '', 'Languages', 'com_languages', 0, '', 1, '', 1);
  150. INSERT INTO `#__components` VALUES (24, 'Mass mail', '', 0, 0, '', 'Mass Mail', 'com_massmail', 0, '', 1, 'mailSubjectPrefix=\nmailBodySuffix=\n\n', 1);
  151. INSERT INTO `#__components` VALUES (25, 'Menu Editor', '', 0, 0, '', 'Menu Editor', 'com_menus', 0, '', 1, '', 1);
  152. INSERT INTO `#__components` VALUES (27, 'Messaging', '', 0, 0, '', 'Messages', 'com_messages', 0, '', 1, '', 1);
  153. INSERT INTO `#__components` VALUES (28, 'Modules Manager', '', 0, 0, '', 'Modules', 'com_modules', 0, '', 1, '', 1);
  154. INSERT INTO `#__components` VALUES (29, 'Plugin Manager', '', 0, 0, '', 'Plugins', 'com_plugins', 0, '', 1, '', 1);
  155. INSERT INTO `#__components` VALUES (30, 'Template Manager', '', 0, 0, '', 'Templates', 'com_templates', 0, '', 1, '', 1);
  156. INSERT INTO `#__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);
  157. INSERT INTO `#__components` VALUES (32, 'Cache Manager', '', 0, 0, '', 'Cache', 'com_cache', 0, '', 1, '', 1);
  158. INSERT INTO `#__components` VALUES (33, 'Control Panel', '', 0, 0, '', 'Control Panel', 'com_cpanel', 0, '', 1, '', 1);
  159.  
  160. # --------------------------------------------------------
  161.  
  162. #
  163. # Table structure for table `#__contact_details`
  164. #
  165.  
  166. CREATE TABLE `#__contact_details` (
  167.   `id` int(11) NOT NULL auto_increment,
  168.   `name` varchar(255) NOT NULL default '',
  169.   `alias` varchar(255) NOT NULL default '',
  170.   `con_position` varchar(255) default NULL,
  171.   `address` text,
  172.   `suburb` varchar(100) default NULL,
  173.   `state` varchar(100) default NULL,
  174.   `country` varchar(100) default NULL,
  175.   `postcode` varchar(100) default NULL,
  176.   `telephone` varchar(255) default NULL,
  177.   `fax` varchar(255) default NULL,
  178.   `misc` mediumtext,
  179.   `image` varchar(255) default NULL,
  180.   `imagepos` varchar(20) default NULL,
  181.   `email_to` varchar(255) default NULL,
  182.   `default_con` tinyint(1) unsigned NOT NULL default '0',
  183.   `published` tinyint(1) unsigned NOT NULL default '0',
  184.   `checked_out` int(11) unsigned NOT NULL default '0',
  185.   `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
  186.   `ordering` int(11) NOT NULL default '0',
  187.   `params` text NOT NULL,
  188.   `user_id` int(11) NOT NULL default '0',
  189.   `catid` int(11) NOT NULL default '0',
  190.   `access` tinyint(3) unsigned NOT NULL default '0',
  191.   `mobile` varchar(255) NOT NULL default '',
  192.   `webpage` varchar(255) NOT NULL default '',
  193.   PRIMARY KEY  (`id`),
  194.   KEY `catid` (`catid`)
  195. ) TYPE=MyISAM CHARACTER SET `utf8`;
  196.  
  197. # --------------------------------------------------------
  198.  
  199. #
  200. # Table structure for table `#__content`
  201. #
  202.  
  203. CREATE TABLE `#__content` (
  204.   `id` int(11) unsigned NOT NULL auto_increment,
  205.   `title` varchar(255) NOT NULL default '',
  206.   `alias` varchar(255) NOT NULL default '',
  207.   `title_alias` varchar(255) NOT NULL default '',
  208.   `introtext` mediumtext NOT NULL,
  209.   `fulltext` mediumtext NOT NULL,
  210.   `state` tinyint(3) NOT NULL default '0',
  211.   `sectionid` int(11) unsigned NOT NULL default '0',
  212.   `mask` int(11) unsigned NOT NULL default '0',
  213.   `catid` int(11) unsigned NOT NULL default '0',
  214.   `created` datetime NOT NULL default '0000-00-00 00:00:00',
  215.   `created_by` int(11) unsigned NOT NULL default '0',
  216.   `created_by_alias` varchar(255) NOT NULL default '',
  217.   `modified` datetime NOT NULL default '0000-00-00 00:00:00',
  218.   `modified_by` int(11) unsigned NOT NULL default '0',
  219.   `checked_out` int(11) unsigned NOT NULL default '0',
  220.   `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
  221.   `publish_up` datetime NOT NULL default '0000-00-00 00:00:00',
  222.   `publish_down` datetime NOT NULL default '0000-00-00 00:00:00',
  223.   `images` text NOT NULL,
  224.   `urls` text NOT NULL,
  225.   `attribs` text NOT NULL,
  226.   `version` int(11) unsigned NOT NULL default '1',
  227.   `parentid` int(11) unsigned NOT NULL default '0',
  228.   `ordering` int(11) NOT NULL default '0',
  229.   `metakey` text NOT NULL,
  230.   `metadesc` text NOT NULL,
  231.   `access` int(11) unsigned NOT NULL default '0',
  232.   `hits` int(11) unsigned NOT NULL default '0',
  233.   `metadata` TEXT NOT NULL '',
  234.   PRIMARY KEY  (`id`),
  235.   KEY `idx_section` (`sectionid`),
  236.   KEY `idx_access` (`access`),
  237.   KEY `idx_checkout` (`checked_out`),
  238.   KEY `idx_state` (`state`),
  239.   KEY `idx_catid` (`catid`),
  240.   KEY `idx_createdby` (`created_by`)
  241. ) TYPE=MyISAM CHARACTER SET `utf8`;
  242.  
  243. # --------------------------------------------------------
  244.  
  245. #
  246. # Table structure for table `#__content_frontpage`
  247. #
  248.  
  249. CREATE TABLE `#__content_frontpage` (
  250.   `content_id` int(11) NOT NULL default '0',
  251.   `ordering` int(11) NOT NULL default '0',
  252.   PRIMARY KEY  (`content_id`)
  253. ) TYPE=MyISAM CHARACTER SET `utf8`;
  254.  
  255. # --------------------------------------------------------
  256.  
  257. #
  258. # Table structure for table `#__content_rating`
  259. #
  260.  
  261. CREATE TABLE `#__content_rating` (
  262.   `content_id` int(11) NOT NULL default '0',
  263.   `rating_sum` int(11) unsigned NOT NULL default '0',
  264.   `rating_count` int(11) unsigned NOT NULL default '0',
  265.   `lastip` varchar(50) NOT NULL default '',
  266.   PRIMARY KEY  (`content_id`)
  267. ) TYPE=MyISAM CHARACTER SET `utf8`;
  268.  
  269. # --------------------------------------------------------
  270.  
  271. # Table structure for table `#__core_log_items`
  272.  
  273. CREATE TABLE `#__core_log_items` (
  274.   `time_stamp` date NOT NULL default '0000-00-00',
  275.   `item_table` varchar(50) NOT NULL default '',
  276.   `item_id` int(11) unsigned NOT NULL default '0',
  277.   `hits` int(11) unsigned NOT NULL default '0'
  278. ) TYPE=MyISAM CHARACTER SET `utf8`;
  279.  
  280. # --------------------------------------------------------
  281.  
  282. # Table structure for table `#__core_log_searches`
  283.  
  284. CREATE TABLE `#__core_log_searches` (
  285.   `search_term` varchar(128) NOT NULL default '',
  286.   `hits` int(11) unsigned NOT NULL default '0'
  287. ) TYPE=MyISAM CHARACTER SET `utf8`;
  288.  
  289. #
  290. # Table structure for table `#__groups`
  291. #
  292.  
  293. # --------------------------------------------------------
  294.  
  295. CREATE TABLE `#__groups` (
  296.   `id` tinyint(3) unsigned NOT NULL default '0',
  297.   `name` varchar(50) NOT NULL default '',
  298.   PRIMARY KEY  (`id`)
  299. ) TYPE=MyISAM CHARACTER SET `utf8`;
  300.  
  301. #
  302. # Dumping data for table `#__groups`
  303. #
  304.  
  305. INSERT INTO `#__groups` VALUES (0, 'Public');
  306. INSERT INTO `#__groups` VALUES (1, 'Registered');
  307. INSERT INTO `#__groups` VALUES (2, 'Special');
  308.  
  309. # --------------------------------------------------------
  310.  
  311. #
  312. # Table structure for table `#__plugins`
  313. #
  314.  
  315. CREATE TABLE `#__plugins` (
  316.   `id` int(11) NOT NULL auto_increment,
  317.   `name` varchar(100) NOT NULL default '',
  318.   `element` varchar(100) NOT NULL default '',
  319.   `folder` varchar(100) NOT NULL default '',
  320.   `access` tinyint(3) unsigned NOT NULL default '0',
  321.   `ordering` int(11) NOT NULL default '0',
  322.   `published` tinyint(3) NOT NULL default '0',
  323.   `iscore` tinyint(3) NOT NULL default '0',
  324.   `client_id` tinyint(3) NOT NULL default '0',
  325.   `checked_out` int(11) unsigned NOT NULL default '0',
  326.   `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
  327.   `params` text NOT NULL,
  328.   PRIMARY KEY  (`id`),
  329.   KEY `idx_folder` (`published`,`client_id`,`access`,`folder`)
  330. ) TYPE=MyISAM CHARACTER SET `utf8`;
  331.  
  332. INSERT INTO `#__plugins` VALUES (1, 'Authentication - Joomla', 'joomla', 'authentication', 0, 1, 1, 1, 0, 0, '0000-00-00 00:00:00', '');
  333. INSERT INTO `#__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');
  334. INSERT INTO `#__plugins` VALUES (3, 'Authentication - GMail', 'gmail', 'authentication', 0, 4, 0, 0, 0, 0, '0000-00-00 00:00:00', '');
  335. INSERT INTO `#__plugins` VALUES (4, 'Authentication - OpenID', 'openid', 'authentication', 0, 3, 0, 0, 0, 0, '0000-00-00 00:00:00', '');
  336. INSERT INTO `#__plugins` VALUES (5, 'User - Joomla!', 'joomla', 'user', 0, 0, 1, 0, 0, 0, '0000-00-00 00:00:00', 'autoregister=1\n\n');
  337. INSERT INTO `#__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');
  338. INSERT INTO `#__plugins` VALUES (7, 'Search - Contacts','contacts','search',0,3,1,1,0,0,'0000-00-00 00:00:00','search_limit=50\n\n');
  339. INSERT INTO `#__plugins` VALUES (8, 'Search - Categories', 'categories', 'search', 0, 4, 1, 0, 0, 0, '0000-00-00 00:00:00', 'search_limit=50\n\n');
  340. INSERT INTO `#__plugins` VALUES (9, 'Search - Sections', 'sections', 'search', 0, 5, 1, 0, 0, 0, '0000-00-00 00:00:00', 'search_limit=50\n\n');
  341. INSERT INTO `#__plugins` VALUES (10, 'Search - Newsfeeds', 'newsfeeds', 'search', 0, 6, 1, 0, 0, 0, '0000-00-00 00:00:00', 'search_limit=50\n\n');
  342. INSERT INTO `#__plugins` VALUES (11, 'Search - Weblinks','weblinks','search',0,2,1,1,0,0,'0000-00-00 00:00:00','search_limit=50\n\n');
  343. INSERT INTO `#__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');
  344. INSERT INTO `#__plugins` VALUES (13, 'Content - Rating','vote','content',0,4,1,1,0,0,'0000-00-00 00:00:00','');
  345. INSERT INTO `#__plugins` VALUES (14, 'Content - Email Cloaking', 'emailcloak', 'content', 0, 5, 1, 0, 0, 0, '0000-00-00 00:00:00', 'mode=1\n\n');
  346. INSERT INTO `#__plugins` VALUES (15, 'Content - Code Hightlighter (GeSHi)', 'geshi', 'content', 0, 5, 0, 0, 0, 0, '0000-00-00 00:00:00', '');
  347. INSERT INTO `#__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');
  348. INSERT INTO `#__plugins` VALUES (17, 'Content - Page Navigation','pagenavigation','content',0,2,1,1,0,0,'0000-00-00 00:00:00','position=1\n\n');
  349. INSERT INTO `#__plugins` VALUES (18, 'Editor - No Editor','none','editors',0,0,1,1,0,0,'0000-00-00 00:00:00','');
  350. INSERT INTO `#__plugins` VALUES (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\nentity_encoding=raw\nlang_mode=0\nlang_code=en\ntext_direction=ltr\ncontent_css=1\ncontent_css_custom=\nrelative_urls=1\nnewlines=0\ninvalid_elements=applet\nextended_elements=\ntoolbar=top\ntoolbar_align=left\nhtml_height=550\nhtml_width=750\nelement_path=1\nfonts=1\npaste=1\nsearchreplace=1\ninsertdate=1\nformat_date=%Y-%m-%d\ninserttime=1\nformat_time=%H:%M:%S\ncolors=1\ntable=1\nsmilies=1\nmedia=1\nhr=1\ndirectionality=1\nfullscreen=1\nstyle=1\nlayer=1\nxhtmlxtras=1\nvisualchars=1\nnonbreaking=1\ntemplate=0\nadvimage=1\nadvlink=1\nautosave=1\ncontextmenu=1\ninlinepopups=1\nsafari=1\ncustom_plugin=\ncustom_button=\n\n');
  351. INSERT INTO `#__plugins` VALUES (20, 'Editor - XStandard Lite 2.0', 'xstandard', 'editors', 0, 0, 0, 1, 0, 0, '0000-00-00 00:00:00', '');
  352. INSERT INTO `#__plugins` VALUES (21, 'Editor Button - Image','image','editors-xtd',0,0,1,0,0,0,'0000-00-00 00:00:00','');
  353. INSERT INTO `#__plugins` VALUES (22, 'Editor Button - Pagebreak','pagebreak','editors-xtd',0,0,1,0,0,0,'0000-00-00 00:00:00','');
  354. INSERT INTO `#__plugins` VALUES (23, 'Editor Button - Readmore','readmore','editors-xtd',0,0,1,0,0,0,'0000-00-00 00:00:00','');
  355. INSERT INTO `#__plugins` VALUES (24, 'XML-RPC - Joomla', 'joomla', 'xmlrpc', 0, 7, 0, 1, 0, 0, '0000-00-00 00:00:00', '');
  356. INSERT INTO `#__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');
  357. #INSERT INTO `#__plugins` VALUES (26, 'XML-RPC - MetaWeblog API', 'metaweblog', 'xmlrpc', 0, 7, 0, 1, 0, 0, '0000-00-00 00:00:00', '');
  358. INSERT INTO `#__plugins` VALUES (27, 'System - SEF','sef','system',0,1,1,0,0,0,'0000-00-00 00:00:00','');
  359. INSERT INTO `#__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');
  360. INSERT INTO `#__plugins` VALUES (29, 'System - Legacy', 'legacy', 'system', 0, 3, 0, 1, 0, 0, '0000-00-00 00:00:00', 'route=0\n\n');
  361. INSERT INTO `#__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');
  362. INSERT INTO `#__plugins` VALUES (31, 'System - Log', 'log', 'system', 0, 5, 0, 1, 0, 0, '0000-00-00 00:00:00', '');
  363. INSERT INTO `#__plugins` VALUES (32, 'System - Remember Me', 'remember', 'system', 0, 6, 1, 1, 0, 0, '0000-00-00 00:00:00', '');
  364. INSERT INTO `#__plugins` VALUES (33, 'System - Backlink', 'backlink', 'system', 0, 7, 0, 1, 0, 0, '0000-00-00 00:00:00', '');
  365. INSERT INTO `#__plugins` VALUES (34, 'System - Mootools Upgrade', 'mtupgrade', 'system', 0, 8, 0, 1, 0, 0, '0000-00-00 00:00:00', '');
  366.  
  367. # --------------------------------------------------------
  368.  
  369. #
  370. # Table structure for table `#__menu`
  371. #
  372.  
  373. CREATE TABLE `#__menu` (
  374.   `id` int(11) NOT NULL auto_increment,
  375.   `menutype` varchar(75) default NULL,
  376.   `name` varchar(255) default NULL,
  377.   `alias` varchar(255) NOT NULL default '',
  378.   `link` text,
  379.   `type` varchar(50) NOT NULL default '',
  380.   `published` tinyint(1) NOT NULL default 0,
  381.   `parent` int(11) unsigned NOT NULL default 0,
  382.   `componentid` int(11) unsigned NOT NULL default 0,
  383.   `sublevel` int(11) default 0,
  384.   `ordering` int(11) default 0,
  385.   `checked_out` int(11) unsigned NOT NULL default 0,
  386.   `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
  387.   `pollid` int(11) NOT NULL default 0,
  388.   `browserNav` tinyint(4) default 0,
  389.   `access` tinyint(3) unsigned NOT NULL default 0,
  390.   `utaccess` tinyint(3) unsigned NOT NULL default 0,
  391.   `params` text NOT NULL,
  392.   `lft` int(11) unsigned NOT NULL default 0,
  393.   `rgt` int(11) unsigned NOT NULL default 0,
  394.   `home` INTEGER(1) UNSIGNED NOT NULL DEFAULT 0,
  395.   PRIMARY KEY  (`id`),
  396.   KEY `componentid` (`componentid`,`menutype`,`published`,`access`),
  397.   KEY `menutype` (`menutype`)
  398. ) TYPE=MyISAM CHARACTER SET `utf8`;
  399.  
  400. INSERT INTO `#__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=4\nnum_columns=2\nnum_links=4\norderby_pri=\norderby_sec=front\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=\nshow_page_title=1\npageclass_sfx=\nmenu_image=-1\nsecure=0\n\n', 0, 0, 1);
  401.  
  402. # --------------------------------------------------------
  403.  
  404. #
  405. # Table structure for table `#__menu_types`
  406. #
  407.  
  408. CREATE TABLE `#__menu_types` (
  409.   `id` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
  410.   `menutype` VARCHAR(75) NOT NULL DEFAULT '',
  411.   `title` VARCHAR(255) NOT NULL DEFAULT '',
  412.   `description` VARCHAR(255) NOT NULL DEFAULT '',
  413.   PRIMARY KEY(`id`),
  414.   UNIQUE `menutype`(`menutype`)
  415. ) TYPE=MyISAM CHARACTER SET `utf8`;
  416.  
  417. INSERT INTO `#__menu_types` VALUES (1, 'mainmenu', 'Main Menu', 'The main menu for the site');
  418.  
  419. # --------------------------------------------------------
  420.  
  421. #
  422. # Table structure for table `#__messages`
  423. #
  424.  
  425. CREATE TABLE `#__messages` (
  426.   `message_id` int(10) unsigned NOT NULL auto_increment,
  427.   `user_id_from` int(10) unsigned NOT NULL default '0',
  428.   `user_id_to` int(10) unsigned NOT NULL default '0',
  429.   `folder_id` int(10) unsigned NOT NULL default '0',
  430.   `date_time` datetime NOT NULL default '0000-00-00 00:00:00',
  431.   `state` int(11) NOT NULL default '0',
  432.   `priority` int(1) unsigned NOT NULL default '0',
  433.   `subject` TEXT NOT NULL '',
  434.   `message` text NOT NULL,
  435.   PRIMARY KEY  (`message_id`),
  436.   KEY `useridto_state` (`user_id_to`, `state`)
  437. ) TYPE=MyISAM CHARACTER SET `utf8`;
  438. # --------------------------------------------------------
  439.  
  440. #
  441. # Table structure for table `#__messages_cfg`
  442. #
  443.  
  444. CREATE TABLE `#__messages_cfg` (
  445.   `user_id` int(10) unsigned NOT NULL default '0',
  446.   `cfg_name` varchar(100) NOT NULL default '',
  447.   `cfg_value` varchar(255) NOT NULL default '',
  448.   UNIQUE `idx_user_var_name` (`user_id`,`cfg_name`)
  449. ) TYPE=MyISAM CHARACTER SET `utf8`;
  450. # --------------------------------------------------------
  451.  
  452. #
  453. # Table structure for table `#__modules`
  454. #
  455.  
  456. CREATE TABLE `#__modules` (
  457.   `id` int(11) NOT NULL auto_increment,
  458.   `title` text NOT NULL,
  459.   `content` text NOT NULL,
  460.   `ordering` int(11) NOT NULL default '0',
  461.   `position` varchar(50) default NULL,
  462.   `checked_out` int(11) unsigned NOT NULL default '0',
  463.   `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
  464.   `published` tinyint(1) NOT NULL default '0',
  465.   `module` varchar(50) default NULL,
  466.   `numnews` int(11) NOT NULL default '0',
  467.   `access` tinyint(3) unsigned NOT NULL default '0',
  468.   `showtitle` tinyint(3) unsigned NOT NULL default '1',
  469.   `params` text NOT NULL,
  470.   `iscore` tinyint(4) NOT NULL default '0',
  471.   `client_id` tinyint(4) NOT NULL default '0',
  472.   `control` TEXT NOT NULL '',
  473.   PRIMARY KEY  (`id`),
  474.   KEY `published` (`published`,`access`),
  475.   KEY `newsfeeds` (`module`,`published`)
  476. ) TYPE=MyISAM CHARACTER SET `utf8`;
  477.  
  478. INSERT INTO `#__modules` VALUES (1, 'Main Menu', '', 1, 'left', 0, '0000-00-00 00:00:00', 1, 'mod_mainmenu', 0, 0, 1, 'menutype=mainmenu\nmoduleclass_sfx=_menu\n', 1, 0, '');
  479. INSERT INTO `#__modules` VALUES (2, 'Login', '', 1, 'login', 0, '0000-00-00 00:00:00', 1, 'mod_login', 0, 0, 1, '', 1, 1, '');
  480. INSERT INTO `#__modules` VALUES (3, 'Popular','',3,'cpanel',0,'0000-00-00 00:00:00',1,'mod_popular',0,2,1,'',0, 1, '');
  481. INSERT INTO `#__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, '');
  482. INSERT INTO `#__modules` VALUES (5, 'Menu Stats','',5,'cpanel',0,'0000-00-00 00:00:00',1,'mod_stats',0,2,1,'',0, 1, '');
  483. INSERT INTO `#__modules` VALUES (6, 'Unread Messages','',1,'header',0,'0000-00-00 00:00:00',1,'mod_unread',0,2,1,'',1, 1, '');
  484. INSERT INTO `#__modules` VALUES (7, 'Online Users','',2,'header',0,'0000-00-00 00:00:00',1,'mod_online',0,2,1,'',1, 1, '');
  485. INSERT INTO `#__modules` VALUES (8, 'Toolbar','',1,'toolbar',0,'0000-00-00 00:00:00',1,'mod_toolbar',0,2,1,'',1, 1, '');
  486. INSERT INTO `#__modules` VALUES (9, 'Quick Icons','',1,'icon',0,'0000-00-00 00:00:00',1,'mod_quickicon',0,2,1,'',1,1, '');
  487. INSERT INTO `#__modules` VALUES (10, 'Logged in Users','',2,'cpanel',0,'0000-00-00 00:00:00',1,'mod_logged',0,2,1,'',0,1, '');
  488. INSERT INTO `#__modules` VALUES (11, 'Footer', '', 0, 'footer', 0, '0000-00-00 00:00:00', 1, 'mod_footer', 0, 0, 1, '', 1, 1, '');
  489. INSERT INTO `#__modules` VALUES (12, 'Admin Menu','', 1,'menu', 0,'0000-00-00 00:00:00', 1,'mod_menu', 0, 2, 1, '', 0, 1, '');
  490. INSERT INTO `#__modules` VALUES (13, 'Admin SubMenu','', 1,'submenu', 0,'0000-00-00 00:00:00', 1,'mod_submenu', 0, 2, 1, '', 0, 1, '');
  491. INSERT INTO `#__modules` VALUES (14, 'User Status','', 1,'status', 0,'0000-00-00 00:00:00', 1,'mod_status', 0, 2, 1, '', 0, 1, '');
  492. INSERT INTO `#__modules` VALUES (15, 'Title','', 1,'title', 0,'0000-00-00 00:00:00', 1,'mod_title', 0, 2, 1, '', 0, 1, '');
  493.  
  494. # --------------------------------------------------------
  495.  
  496. #
  497. # Table structure for table `#__modules_menu`
  498. #
  499.  
  500. CREATE TABLE `#__modules_menu` (
  501.   `moduleid` int(11) NOT NULL default '0',
  502.   `menuid` int(11) NOT NULL default '0',
  503.   PRIMARY KEY  (`moduleid`,`menuid`)
  504. ) TYPE=MyISAM CHARACTER SET `utf8`;
  505.  
  506. #
  507. # Dumping data for table `#__modules_menu`
  508. #
  509.  
  510. INSERT INTO `#__modules_menu` VALUES (1,0);
  511.  
  512. # --------------------------------------------------------
  513.  
  514. #
  515. # Table structure for table `#__newsfeeds`
  516. #
  517.  
  518. CREATE TABLE `#__newsfeeds` (
  519.   `catid` int(11) NOT NULL default '0',
  520.   `id` int(11) NOT NULL auto_increment,
  521.   `name` text NOT NULL,
  522.   `alias` varchar(255) NOT NULL default '',
  523.   `link` text NOT NULL,
  524.   `filename` varchar(200) default NULL,
  525.   `published` tinyint(1) NOT NULL default '0',
  526.   `numarticles` int(11) unsigned NOT NULL default '1',
  527.   `cache_time` int(11) unsigned NOT NULL default '3600',
  528.   `checked_out` tinyint(3) unsigned NOT NULL default '0',
  529.   `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
  530.   `ordering` int(11) NOT NULL default '0',
  531.   `rtl` tinyint(4) NOT NULL default '0',
  532.   PRIMARY KEY  (`id`),
  533.   KEY `published` (`published`),
  534.   KEY `catid` (`catid`)
  535. ) TYPE=MyISAM CHARACTER SET `utf8`;
  536.  
  537. # --------------------------------------------------------
  538.  
  539. #
  540. # Table structure for table `#__poll_data`
  541. #
  542.  
  543. CREATE TABLE `#__poll_data` (
  544.   `id` int(11) NOT NULL auto_increment,
  545.   `pollid` int(11) NOT NULL default '0',
  546.   `text` TEXT NOT NULL '',
  547.   `hits` int(11) NOT NULL default '0',
  548.   PRIMARY KEY  (`id`),
  549.   KEY `pollid` (`pollid`,`text`(1))
  550. ) TYPE=MyISAM CHARACTER SET `utf8`;
  551.  
  552. # --------------------------------------------------------
  553.  
  554. #
  555. # Table structure for table `#__poll_date`
  556. #
  557.  
  558. CREATE TABLE `#__poll_date` (
  559.   `id` bigint(20) NOT NULL auto_increment,
  560.   `date` datetime NOT NULL default '0000-00-00 00:00:00',
  561.   `vote_id` int(11) NOT NULL default '0',
  562.   `poll_id` int(11) NOT NULL default '0',
  563.   PRIMARY KEY  (`id`),
  564.   KEY `poll_id` (`poll_id`)
  565. ) TYPE=MyISAM CHARACTER SET `utf8`;
  566.  
  567. # --------------------------------------------------------
  568.  
  569. #
  570. # Table structure for table `#__polls`
  571. #
  572.  
  573. CREATE TABLE `#__polls` (
  574.   `id` int(11) unsigned NOT NULL auto_increment,
  575.   `title` varchar(255) NOT NULL default '',
  576.   `alias` varchar(255) NOT NULL default '',
  577.   `voters` int(9) NOT NULL default '0',
  578.   `checked_out` int(11) NOT NULL default '0',
  579.   `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
  580.   `published` tinyint(1) NOT NULL default '0',
  581.   `access` int(11) NOT NULL default '0',
  582.   `lag` int(11) NOT NULL default '0',
  583.   PRIMARY KEY  (`id`)
  584. ) TYPE=MyISAM CHARACTER SET `utf8`;
  585.  
  586. # --------------------------------------------------------
  587.  
  588. #
  589. # Table structure for table `#__poll_menu`
  590. # !!!DEPRECATED!!!
  591. #
  592.  
  593. CREATE TABLE `#__poll_menu` (
  594.   `pollid` int(11) NOT NULL default '0',
  595.   `menuid` int(11) NOT NULL default '0',
  596.   PRIMARY KEY  (`pollid`,`menuid`)
  597. ) TYPE=MyISAM CHARACTER SET `utf8`;
  598.  
  599. # --------------------------------------------------------
  600.  
  601. #
  602. # Table structure for table `#__sections`
  603. #
  604.  
  605. CREATE TABLE `#__sections` (
  606.   `id` int(11) NOT NULL auto_increment,
  607.   `title` varchar(255) NOT NULL default '',
  608.   `name` varchar(255) NOT NULL default '',
  609.   `alias` varchar(255) NOT NULL default '',
  610.   `image` TEXT NOT NULL '',
  611.   `scope` varchar(50) NOT NULL default '',
  612.   `image_position` varchar(30) NOT NULL default '',
  613.   `description` text NOT NULL,
  614.   `published` tinyint(1) NOT NULL default '0',
  615.   `checked_out` int(11) unsigned NOT NULL default '0',
  616.   `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
  617.   `ordering` int(11) NOT NULL default '0',
  618.   `access` tinyint(3) unsigned NOT NULL default '0',
  619.   `count` int(11) NOT NULL default '0',
  620.   `params` text NOT NULL,
  621.   PRIMARY KEY  (`id`),
  622.   KEY `idx_scope` (`scope`)
  623. ) TYPE=MyISAM CHARACTER SET `utf8`;
  624.  
  625. # --------------------------------------------------------
  626.  
  627. #
  628. # Table structure for table `#__session`
  629. #
  630.  
  631. CREATE TABLE `#__session` (
  632.   `username` varchar(150) default '',
  633.   `time` varchar(14) default '',
  634.   `session_id` varchar(200) NOT NULL default '0',
  635.   `guest` tinyint(4) default '1',
  636.   `userid` int(11) default '0',
  637.   `usertype` varchar(50) default '',
  638.   `gid` tinyint(3) unsigned NOT NULL default '0',
  639.   `client_id` tinyint(3) unsigned NOT NULL default '0',
  640.   `data` longtext,
  641.   PRIMARY KEY  (`session_id`(64)),
  642.   KEY `whosonline` (`guest`,`usertype`),
  643.   KEY `userid` (`userid`),
  644.   KEY `time` (`time`)
  645. ) TYPE=MyISAM CHARACTER SET `utf8`;
  646.  
  647. # --------------------------------------------------------
  648.  
  649. #
  650. # Table structure for table `#__stats_agents`
  651. #
  652.  
  653. CREATE TABLE `#__stats_agents` (
  654.   `agent` varchar(255) NOT NULL default '',
  655.   `type` tinyint(1) unsigned NOT NULL default '0',
  656.   `hits` int(11) unsigned NOT NULL default '1'
  657. ) TYPE=MyISAM CHARACTER SET `utf8`;
  658.  
  659. # --------------------------------------------------------
  660.  
  661. #
  662. # Table structure for table `#__templates_menu`
  663. #
  664.  
  665. CREATE TABLE `#__templates_menu` (
  666.   `template` varchar(255) NOT NULL default '',
  667.   `menuid` int(11) NOT NULL default '0',
  668.   `client_id` tinyint(4) NOT NULL default '0',
  669.   PRIMARY KEY (`menuid`, `client_id`, `template`(255))
  670. ) TYPE=MyISAM CHARACTER SET `utf8`;
  671.  
  672. # Dumping data for table `#__templates_menu`
  673. INSERT INTO `#__templates_menu` VALUES ('rhuk_milkyway', '0', '0');
  674. INSERT INTO `#__templates_menu` VALUES ('khepri', '0', '1');
  675.  
  676. # --------------------------------------------------------
  677.  
  678. #
  679. # Table structure for table `#__users`
  680. #
  681.  
  682. CREATE TABLE `#__users` (
  683.   `id` int(11) NOT NULL auto_increment,
  684.   `name` varchar(255) NOT NULL default '',
  685.   `username` varchar(150) NOT NULL default '',
  686.   `email` varchar(100) NOT NULL default '',
  687.   `password` varchar(100) NOT NULL default '',
  688.   `usertype` varchar(25) NOT NULL default '',
  689.   `block` tinyint(4) NOT NULL default '0',
  690.   `sendEmail` tinyint(4) default '0',
  691.   `gid` tinyint(3) unsigned NOT NULL default '1',
  692.   `registerDate` datetime NOT NULL default '0000-00-00 00:00:00',
  693.   `lastvisitDate` datetime NOT NULL default '0000-00-00 00:00:00',
  694.   `activation` varchar(100) NOT NULL default '',
  695.   `params` text NOT NULL,
  696.   PRIMARY KEY  (`id`),
  697.   KEY `usertype` (`usertype`),
  698.   KEY `idx_name` (`name`),
  699.   KEY `gid_block` (`gid`, `block`),
  700.   KEY `username` (`username`),
  701.   KEY `email` (`email`)
  702. ) TYPE=MyISAM CHARACTER SET `utf8`;
  703.  
  704. # --------------------------------------------------------
  705.  
  706. #
  707. # Table structure for table `#__weblinks`
  708. #
  709.  
  710. CREATE TABLE `#__weblinks` (
  711.   `id` int(11) unsigned NOT NULL auto_increment,
  712.   `catid` int(11) NOT NULL default '0',
  713.   `sid` int(11) NOT NULL default '0',
  714.   `title` varchar(250) NOT NULL default '',
  715.   `alias` varchar(255) NOT NULL default '',
  716.   `url` varchar(250) NOT NULL default '',
  717.   `description` TEXT NOT NULL '',
  718.   `date` datetime NOT NULL default '0000-00-00 00:00:00',
  719.   `hits` int(11) NOT NULL default '0',
  720.   `published` tinyint(1) NOT NULL default '0',
  721.   `checked_out` int(11) NOT NULL default '0',
  722.   `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
  723.   `ordering` int(11) NOT NULL default '0',
  724.   `archived` tinyint(1) NOT NULL default '0',
  725.   `approved` tinyint(1) NOT NULL default '1',
  726.   `params` text NOT NULL,
  727.   PRIMARY KEY  (`id`),
  728.   KEY `catid` (`catid`,`published`,`archived`)
  729. ) TYPE=MyISAM CHARACTER SET `utf8`;
  730.  
  731. # --------------------------------------------------------
  732.  
  733. #
  734. # Table structure for table `#__core_acl_aro`
  735. #
  736.  
  737. CREATE TABLE `#__core_acl_aro` (
  738.   `id` int(11) NOT NULL auto_increment,
  739.   `section_value` varchar(240) NOT NULL default '0',
  740.   `value` varchar(240) NOT NULL default '',
  741.   `order_value` int(11) NOT NULL default '0',
  742.   `name` varchar(255) NOT NULL default '',
  743.   `hidden` int(11) NOT NULL default '0',
  744.   PRIMARY KEY  (`id`),
  745.   UNIQUE KEY `#__section_value_value_aro` (`section_value`(100),`value`(100)),
  746.   KEY `#__gacl_hidden_aro` (`hidden`)
  747. ) TYPE=MyISAM CHARACTER SET `utf8`;
  748.  
  749. # --------------------------------------------------------
  750.  
  751. #
  752. # Table structure for table `#__core_acl_aro_map`
  753. #
  754.  
  755. CREATE TABLE  `#__core_acl_aro_map` (
  756.   `acl_id` int(11) NOT NULL default '0',
  757.   `section_value` varchar(230) NOT NULL default '0',
  758.   `value` varchar(100) NOT NULL,
  759.   PRIMARY KEY  (`acl_id`,`section_value`,`value`)
  760. ) TYPE=MyISAM CHARACTER SET `utf8`;
  761.  
  762. # --------------------------------------------------------
  763.  
  764. #
  765. # Table structure for table `#__core_acl_aro_groups`
  766. #
  767. CREATE TABLE `#__core_acl_aro_groups` (
  768.   `id` int(11) NOT NULL auto_increment,
  769.   `parent_id` int(11) NOT NULL default '0',
  770.   `name` varchar(255) NOT NULL default '',
  771.   `lft` int(11) NOT NULL default '0',
  772.   `rgt` int(11) NOT NULL default '0',
  773.   `value` varchar(255) NOT NULL default '',
  774.   PRIMARY KEY  (`id`),
  775.   KEY `#__gacl_parent_id_aro_groups` (`parent_id`),
  776.   KEY `#__gacl_lft_rgt_aro_groups` (`lft`,`rgt`)
  777. ) TYPE=MyISAM CHARACTER SET `utf8`;
  778.  
  779. #
  780. # Dumping data for table `#__core_acl_aro_groups`
  781. #
  782.  
  783. INSERT INTO `#__core_acl_aro_groups` VALUES (17,0,'ROOT',1,22,'ROOT');
  784. INSERT INTO `#__core_acl_aro_groups` VALUES (28,17,'USERS',2,21,'USERS');
  785. INSERT INTO `#__core_acl_aro_groups` VALUES (29,28,'Public Frontend',3,12,'Public Frontend');
  786. INSERT INTO `#__core_acl_aro_groups` VALUES (18,29,'Registered',4,11,'Registered');
  787. INSERT INTO `#__core_acl_aro_groups` VALUES (19,18,'Author',5,10,'Author');
  788. INSERT INTO `#__core_acl_aro_groups` VALUES (20,19,'Editor',6,9,'Editor');
  789. INSERT INTO `#__core_acl_aro_groups` VALUES (21,20,'Publisher',7,8,'Publisher');
  790. INSERT INTO `#__core_acl_aro_groups` VALUES (30,28,'Public Backend',13,20,'Public Backend');
  791. INSERT INTO `#__core_acl_aro_groups` VALUES (23,30,'Manager',14,19,'Manager');
  792. INSERT INTO `#__core_acl_aro_groups` VALUES (24,23,'Administrator',15,18,'Administrator');
  793. INSERT INTO `#__core_acl_aro_groups` VALUES (25,24,'Super Administrator',16,17,'Super Administrator');
  794.  
  795. # --------------------------------------------------------
  796.  
  797. #
  798. # Table structure for table `#__core_acl_groups_aro_map`
  799. #
  800. CREATE TABLE `#__core_acl_groups_aro_map` (
  801.   `group_id` int(11) NOT NULL default '0',
  802.   `section_value` varchar(240) NOT NULL default '',
  803.   `aro_id` int(11) NOT NULL default '0',
  804.   UNIQUE KEY `group_id_aro_id_groups_aro_map` (`group_id`,`section_value`,`aro_id`)
  805. ) TYPE=MyISAM CHARACTER SET `utf8`;
  806.  
  807. # --------------------------------------------------------
  808.  
  809. #
  810. # Table structure for table `#__core_acl_aro_sections`
  811. #
  812. CREATE TABLE `#__core_acl_aro_sections` (
  813.   `id` int(11) NOT NULL auto_increment,
  814.   `value` varchar(230) NOT NULL default '',
  815.   `order_value` int(11) NOT NULL default '0',
  816.   `name` varchar(230) NOT NULL default '',
  817.   `hidden` int(11) NOT NULL default '0',
  818.   PRIMARY KEY  (`id`),
  819.   UNIQUE KEY `#__gacl_value_aro_sections` (`value`),
  820.   KEY `#__gacl_hidden_aro_sections` (`hidden`)
  821. ) TYPE=MyISAM CHARACTER SET `utf8`;
  822.  
  823. INSERT INTO `#__core_acl_aro_sections` VALUES (10,'users',1,'Users',0);
  824.  
  825. # --------------------------------------------------------
  826.  
  827. #
  828. # Table structure for table `#__migration_backlinks`
  829. #
  830. CREATE TABLE #__migration_backlinks (
  831.     `itemid` INT(11) NOT NULL,
  832.     `name` VARCHAR(100) NOT NULL,
  833.     `url` TEXT NOT NULL,
  834.     `sefurl` TEXT NOT NULL,
  835.     `newurl` TEXT NOT NULL,
  836.     PRIMARY KEY(`itemid`)
  837. ) TYPE=MyISAM CHARACTER SET `utf8`;
  838.  
  839. # --------------------------------------------------------
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top