API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jul 21st, 2017
98
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 39.47 KB | None | 0 0
raw download clone embed print report
  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. # --------------------------------------------------------
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
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
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!