| [ Index ] |
PHP Cross Reference of Joomla 4.2.2 documentation |
[Summary view] [Print] [Text view]
1 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; 2 SET time_zone = "+00:00"; 3 4 -- 5 -- Table structure for table `#__assets` 6 -- 7 8 CREATE TABLE IF NOT EXISTS `#__assets` ( 9 `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Primary Key', 10 `parent_id` int NOT NULL DEFAULT 0 COMMENT 'Nested set parent.', 11 `lft` int NOT NULL DEFAULT 0 COMMENT 'Nested set lft.', 12 `rgt` int NOT NULL DEFAULT 0 COMMENT 'Nested set rgt.', 13 `level` int unsigned NOT NULL COMMENT 'The cached level in the nested tree.', 14 `name` varchar(50) NOT NULL COMMENT 'The unique name for the asset.\n', 15 `title` varchar(100) NOT NULL COMMENT 'The descriptive title for the asset.', 16 `rules` varchar(5120) NOT NULL COMMENT 'JSON encoded access control.', 17 PRIMARY KEY (`id`), 18 UNIQUE KEY `idx_asset_name` (`name`), 19 KEY `idx_lft_rgt` (`lft`,`rgt`), 20 KEY `idx_parent_id` (`parent_id`) 21 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci; 22 23 -- 24 -- Dumping data for table `#__assets` 25 -- 26 27 INSERT INTO `#__assets` (`id`, `parent_id`, `lft`, `rgt`, `level`, `name`, `title`, `rules`) VALUES 28 (1, 0, 0, 165, 0, 'root.1', 'Root Asset', '{"core.login.site":{"6":1,"2":1},"core.login.admin":{"6":1},"core.login.api":{"8":1},"core.login.offline":{"6":1},"core.admin":{"8":1},"core.manage":{"7":1},"core.create":{"6":1,"3":1},"core.delete":{"6":1},"core.edit":{"6":1,"4":1},"core.edit.state":{"6":1,"5":1},"core.edit.own":{"6":1,"3":1}}'), 29 (2, 1, 1, 2, 1, 'com_admin', 'com_admin', '{}'), 30 (3, 1, 3, 6, 1, 'com_banners', 'com_banners', '{"core.admin":{"7":1},"core.manage":{"6":1}}'), 31 (4, 1, 7, 8, 1, 'com_cache', 'com_cache', '{"core.admin":{"7":1},"core.manage":{"7":1}}'), 32 (5, 1, 9, 10, 1, 'com_checkin', 'com_checkin', '{"core.admin":{"7":1},"core.manage":{"7":1}}'), 33 (6, 1, 11, 12, 1, 'com_config', 'com_config', '{}'), 34 (7, 1, 13, 16, 1, 'com_contact', 'com_contact', '{"core.admin":{"7":1},"core.manage":{"6":1}}'), 35 (8, 1, 17, 38, 1, 'com_content', 'com_content', '{"core.admin":{"7":1},"core.manage":{"6":1},"core.create":{"3":1},"core.edit":{"4":1},"core.edit.state":{"5":1},"core.execute.transition":{"6":1,"5":1}}'), 36 (9, 1, 39, 40, 1, 'com_cpanel', 'com_cpanel', '{}'), 37 (10, 1, 41, 42, 1, 'com_installer', 'com_installer', '{"core.manage":{"7":0},"core.delete":{"7":0},"core.edit.state":{"7":0}}'), 38 (11, 1, 43, 44, 1, 'com_languages', 'com_languages', '{"core.admin":{"7":1}}'), 39 (12, 1, 45, 46, 1, 'com_login', 'com_login', '{}'), 40 (14, 1, 47, 48, 1, 'com_massmail', 'com_massmail', '{}'), 41 (15, 1, 49, 50, 1, 'com_media', 'com_media', '{"core.admin":{"7":1},"core.manage":{"6":1},"core.create":{"3":1},"core.delete":{"5":1}}'), 42 (16, 1, 51, 54, 1, 'com_menus', 'com_menus', '{"core.admin":{"7":1}}'), 43 (17, 1, 55, 56, 1, 'com_messages', 'com_messages', '{"core.admin":{"7":1},"core.manage":{"7":1}}'), 44 (18, 1, 57, 130, 1, 'com_modules', 'com_modules', '{"core.admin":{"7":1}}'), 45 (19, 1, 131, 134, 1, 'com_newsfeeds', 'com_newsfeeds', '{"core.admin":{"7":1},"core.manage":{"6":1}}'), 46 (20, 1, 135, 136, 1, 'com_plugins', 'com_plugins', '{"core.admin":{"7":1}}'), 47 (21, 1, 137, 138, 1, 'com_redirect', 'com_redirect', '{"core.admin":{"7":1}}'), 48 (23, 1, 139, 140, 1, 'com_templates', 'com_templates', '{"core.admin":{"7":1}}'), 49 (24, 1, 145, 148, 1, 'com_users', 'com_users', '{"core.admin":{"7":1}}'), 50 (26, 1, 149, 150, 1, 'com_wrapper', 'com_wrapper', '{}'), 51 (27, 8, 18, 19, 2, 'com_content.category.2', 'Uncategorised', '{}'), 52 (28, 3, 4, 5, 2, 'com_banners.category.3', 'Uncategorised', '{}'), 53 (29, 7, 14, 15, 2, 'com_contact.category.4', 'Uncategorised', '{}'), 54 (30, 19, 132, 133, 2, 'com_newsfeeds.category.5', 'Uncategorised', '{}'), 55 (32, 24, 146, 147, 2, 'com_users.category.7', 'Uncategorised', '{}'), 56 (33, 1, 151, 152, 1, 'com_finder', 'com_finder', '{"core.admin":{"7":1},"core.manage":{"6":1}}'), 57 (34, 1, 153, 154, 1, 'com_joomlaupdate', 'com_joomlaupdate', '{}'), 58 (35, 1, 155, 156, 1, 'com_tags', 'com_tags', '{}'), 59 (36, 1, 157, 158, 1, 'com_contenthistory', 'com_contenthistory', '{}'), 60 (37, 1, 159, 160, 1, 'com_ajax', 'com_ajax', '{}'), 61 (38, 1, 161, 162, 1, 'com_postinstall', 'com_postinstall', '{}'), 62 (39, 18, 58, 59, 2, 'com_modules.module.1', 'Main Menu', '{}'), 63 (40, 18, 60, 61, 2, 'com_modules.module.2', 'Login', '{}'), 64 (41, 18, 62, 63, 2, 'com_modules.module.3', 'Popular Articles', '{}'), 65 (42, 18, 64, 65, 2, 'com_modules.module.4', 'Recently Added Articles', '{}'), 66 (43, 18, 66, 67, 2, 'com_modules.module.8', 'Toolbar', '{}'), 67 (44, 18, 68, 69, 2, 'com_modules.module.9', 'Notifications', '{}'), 68 (45, 18, 70, 71, 2, 'com_modules.module.10', 'Logged-in Users', '{}'), 69 (46, 18, 72, 73, 2, 'com_modules.module.12', 'Admin Menu', '{}'), 70 (48, 18, 78, 79, 2, 'com_modules.module.14', 'User Status', '{}'), 71 (49, 18, 80, 81, 2, 'com_modules.module.15', 'Title', '{}'), 72 (50, 18, 82, 83, 2, 'com_modules.module.16', 'Login Form', '{}'), 73 (51, 18, 84, 85, 2, 'com_modules.module.17', 'Breadcrumbs', '{}'), 74 (52, 18, 86, 87, 2, 'com_modules.module.79', 'Multilanguage status', '{}'), 75 (53, 18, 90, 91, 2, 'com_modules.module.86', 'Joomla Version', '{}'), 76 (54, 16, 52, 53, 2, 'com_menus.menu.1', 'Main Menu', '{}'), 77 (55, 18, 94, 95, 2, 'com_modules.module.87', 'Sample Data', '{}'), 78 (56, 8, 20, 37, 2, 'com_content.workflow.1', 'COM_WORKFLOW_BASIC_WORKFLOW', '{}'), 79 (57, 56, 21, 22, 3, 'com_content.stage.1', 'COM_WORKFLOW_BASIC_STAGE', '{}'), 80 (58, 56, 23, 24, 3, 'com_content.transition.1', 'Unpublish', '{}'), 81 (59, 56, 25, 26, 3, 'com_content.transition.2', 'Publish', '{}'), 82 (60, 56, 27, 28, 3, 'com_content.transition.3', 'Trash', '{}'), 83 (61, 56, 29, 30, 3, 'com_content.transition.4', 'Archive', '{}'), 84 (62, 56, 31, 32, 3, 'com_content.transition.5', 'Feature', '{}'), 85 (63, 56, 33, 34, 3, 'com_content.transition.6', 'Unfeature', '{}'), 86 (64, 56, 35, 36, 3, 'com_content.transition.7', 'Publish & Feature', '{}'), 87 (65, 1, 141, 142, 1, 'com_privacy', 'com_privacy', '{}'), 88 (66, 1, 143, 144, 1, 'com_actionlogs', 'com_actionlogs', '{}'), 89 (67, 18, 74, 75, 2, 'com_modules.module.88', 'Latest Actions', '{}'), 90 (68, 18, 76, 77, 2, 'com_modules.module.89', 'Privacy Dashboard', '{}'), 91 (70, 18, 88, 89, 2, 'com_modules.module.103', 'Site', '{}'), 92 (71, 18, 92, 93, 2, 'com_modules.module.104', 'System', '{}'), 93 (72, 18, 96, 97, 2, 'com_modules.module.91', 'System Dashboard', '{}'), 94 (73, 18, 98, 99, 2, 'com_modules.module.92', 'Content Dashboard', '{}'), 95 (74, 18, 100, 101, 2, 'com_modules.module.93', 'Menus Dashboard', '{}'), 96 (75, 18, 102, 103, 2, 'com_modules.module.94', 'Components Dashboard', '{}'), 97 (76, 18, 104, 105, 2, 'com_modules.module.95', 'Users Dashboard', '{}'), 98 (77, 18, 106, 107, 2, 'com_modules.module.99', 'Frontend Link', '{}'), 99 (78, 18, 108, 109, 2, 'com_modules.module.100', 'Messages', '{}'), 100 (79, 18, 110, 111, 2, 'com_modules.module.101', 'Post Install Messages', '{}'), 101 (80, 18, 112, 113, 2, 'com_modules.module.102', 'User Status', '{}'), 102 (82, 18, 114, 115, 2, 'com_modules.module.105', '3rd Party', '{}'), 103 (83, 18, 116, 117, 2, 'com_modules.module.106', 'Help Dashboard', '{}'), 104 (84, 18, 118, 119, 2, 'com_modules.module.107', 'Privacy Requests', '{}'), 105 (85, 18, 120, 121, 2, 'com_modules.module.108', 'Privacy Status', '{}'), 106 (86, 18, 122, 123, 2, 'com_modules.module.96', 'Popular Articles', '{}'), 107 (87, 18, 124, 125, 2, 'com_modules.module.97', 'Recently Added Articles', '{}'), 108 (88, 18, 126, 127, 2, 'com_modules.module.98', 'Logged-in Users', '{}'), 109 (89, 18, 128, 129, 2, 'com_modules.module.90', 'Login Support', '{}'), 110 (90, 1, 163, 164, 1, 'com_scheduler', 'com_scheduler', '{}'); 111 112 -- -------------------------------------------------------- 113 114 -- 115 -- Table structure for table `#__extensions` 116 -- 117 118 CREATE TABLE IF NOT EXISTS `#__extensions` ( 119 `extension_id` int NOT NULL AUTO_INCREMENT, 120 `package_id` int NOT NULL DEFAULT 0 COMMENT 'Parent package ID for extensions installed as a package.', 121 `name` varchar(100) NOT NULL, 122 `type` varchar(20) NOT NULL, 123 `element` varchar(100) NOT NULL, 124 `changelogurl` text, 125 `folder` varchar(100) NOT NULL, 126 `client_id` tinyint NOT NULL, 127 `enabled` tinyint NOT NULL DEFAULT 0, 128 `access` int unsigned NOT NULL DEFAULT 1, 129 `protected` tinyint NOT NULL DEFAULT 0 COMMENT 'Flag to indicate if the extension is protected. Protected extensions cannot be disabled.', 130 `locked` tinyint NOT NULL DEFAULT 0 COMMENT 'Flag to indicate if the extension is locked. Locked extensions cannot be uninstalled.', 131 `manifest_cache` text NOT NULL, 132 `params` text NOT NULL, 133 `custom_data` text NOT NULL, 134 `checked_out` int unsigned, 135 `checked_out_time` datetime, 136 `ordering` int DEFAULT 0, 137 `state` int DEFAULT 0, 138 `note` varchar(255), 139 PRIMARY KEY (`extension_id`), 140 KEY `element_clientid` (`element`,`client_id`), 141 KEY `element_folder_clientid` (`element`,`folder`,`client_id`), 142 KEY `extension` (`type`,`element`,`folder`,`client_id`) 143 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci; 144 145 -- 146 -- Dumping data for table `#__extensions` 147 -- 148 149 -- Components 150 INSERT INTO `#__extensions` (`package_id`, `name`, `type`, `element`, `folder`, `client_id`, `enabled`, `access`, `protected`, `locked`, `manifest_cache`, `params`, `custom_data`) VALUES 151 (0, 'com_wrapper', 'component', 'com_wrapper', '', 1, 1, 1, 0, 1, '', '', ''), 152 (0, 'com_admin', 'component', 'com_admin', '', 1, 1, 1, 1, 1, '', '', ''), 153 (0, 'com_banners', 'component', 'com_banners', '', 1, 1, 1, 0, 1, '', '{"purchase_type":"3","track_impressions":"0","track_clicks":"0","metakey_prefix":"","save_history":"1","history_limit":10}', ''), 154 (0, 'com_cache', 'component', 'com_cache', '', 1, 1, 1, 1, 1, '', '', ''), 155 (0, 'com_categories', 'component', 'com_categories', '', 1, 1, 1, 1, 1, '', '', ''), 156 (0, 'com_checkin', 'component', 'com_checkin', '', 1, 1, 1, 1, 1, '', '', ''), 157 (0, 'com_contact', 'component', 'com_contact', '', 1, 1, 1, 0, 1, '', '{"contact_layout":"_:default","show_contact_category":"hide","save_history":"1","history_limit":10,"show_contact_list":"0","presentation_style":"sliders","show_tags":"1","show_info":"1","show_name":"1","show_position":"1","show_email":"0","show_street_address":"1","show_suburb":"1","show_state":"1","show_postcode":"1","show_country":"1","show_telephone":"1","show_mobile":"1","show_fax":"1","show_webpage":"1","show_image":"1","show_misc":"1","image":"","allow_vcard":"0","show_articles":"0","articles_display_num":"10","show_profile":"0","show_user_custom_fields":["-1"],"show_links":"0","linka_name":"","linkb_name":"","linkc_name":"","linkd_name":"","linke_name":"","contact_icons":"0","icon_address":"","icon_email":"","icon_telephone":"","icon_mobile":"","icon_fax":"","icon_misc":"","category_layout":"_:default","show_category_title":"1","show_description":"1","show_description_image":"0","maxLevel":"-1","show_subcat_desc":"1","show_empty_categories":"0","show_cat_items":"1","show_cat_tags":"1","show_base_description":"1","maxLevelcat":"-1","show_subcat_desc_cat":"1","show_empty_categories_cat":"0","show_cat_items_cat":"1","filter_field":"0","show_pagination_limit":"0","show_headings":"1","show_image_heading":"0","show_position_headings":"1","show_email_headings":"0","show_telephone_headings":"1","show_mobile_headings":"0","show_fax_headings":"0","show_suburb_headings":"1","show_state_headings":"1","show_country_headings":"1","show_pagination":"2","show_pagination_results":"1","initial_sort":"ordering","captcha":"","show_email_form":"1","show_email_copy":"0","banned_email":"","banned_subject":"","banned_text":"","validate_session":"1","custom_reply":"0","redirect":"","show_feed_link":"1","sef_ids":1,"custom_fields_enable":"1"}', ''), 158 (0, 'com_cpanel', 'component', 'com_cpanel', '', 1, 1, 1, 1, 1, '', '', ''), 159 (0, 'com_installer', 'component', 'com_installer', '', 1, 1, 1, 1, 1, '', '{"cachetimeout":"6","minimum_stability":"4"}', ''), 160 (0, 'com_languages', 'component', 'com_languages', '', 1, 1, 1, 1, 1, '', '{"administrator":"en-GB","site":"en-GB"}', ''), 161 (0, 'com_login', 'component', 'com_login', '', 1, 1, 1, 1, 1, '', '', ''), 162 (0, 'com_media', 'component', 'com_media', '', 1, 1, 0, 1, 1, '', '{"upload_maxsize":"10","file_path":"images","image_path":"images","restrict_uploads":"1","allowed_media_usergroup":"3","restrict_uploads_extensions":"bmp,gif,jpg,jpeg,png,webp,ico,mp3,m4a,mp4a,ogg,mp4,mp4v,mpeg,mov,odg,odp,ods,odt,pdf,png,ppt,txt,xcf,xls,csv","check_mime":"1","image_extensions":"bmp,gif,jpg,png,jpeg,webp","audio_extensions":"mp3,m4a,mp4a,ogg","video_extensions":"mp4,mp4v,mpeg,mov,webm","doc_extensions":"odg,odp,ods,odt,pdf,ppt,txt,xcf,xls,csv","ignore_extensions":"","upload_mime":"image\\/jpeg,image\\/gif,image\\/png,image\\/bmp,image\\/webp,audio\\/ogg,audio\\/mpeg,audio\\/mp4,video\\/mp4,video\\/webm,video\\/mpeg,video\\/quicktime,application\\/msword,application\\/excel,application\\/pdf,application\\/powerpoint,text\\/plain,application\\/x-zip"}', ''), 163 (0, 'com_menus', 'component', 'com_menus', '', 1, 1, 1, 1, 1, '', '{"page_title":"","show_page_heading":0,"page_heading":"","pageclass_sfx":""}', ''), 164 (0, 'com_messages', 'component', 'com_messages', '', 1, 1, 1, 1, 1, '', '', ''), 165 (0, 'com_modules', 'component', 'com_modules', '', 1, 1, 1, 1, 1, '', '', ''), 166 (0, 'com_newsfeeds', 'component', 'com_newsfeeds', '', 1, 1, 1, 0, 1, '', '{"newsfeed_layout":"_:default","save_history":"1","history_limit":5,"show_feed_image":"1","show_feed_description":"1","show_item_description":"1","feed_character_count":"0","feed_display_order":"des","float_first":"right","float_second":"right","show_tags":"1","category_layout":"_:default","show_category_title":"1","show_description":"1","show_description_image":"1","maxLevel":"-1","show_empty_categories":"0","show_subcat_desc":"1","show_cat_items":"1","show_cat_tags":"1","show_base_description":"1","maxLevelcat":"-1","show_empty_categories_cat":"0","show_subcat_desc_cat":"1","show_cat_items_cat":"1","filter_field":"1","show_pagination_limit":"1","show_headings":"1","show_articles":"0","show_link":"1","show_pagination":"1","show_pagination_results":"1","sef_ids":1}', ''), 167 (0, 'com_plugins', 'component', 'com_plugins', '', 1, 1, 1, 1, 1, '', '', ''), 168 (0, 'com_templates', 'component', 'com_templates', '', 1, 1, 1, 1, 1, '', '{"template_positions_display":"0","upload_limit":"10","image_formats":"gif,bmp,jpg,jpeg,png,webp","source_formats":"txt,less,ini,xml,js,php,css,scss,sass,json","font_formats":"woff,ttf,otf","compressed_formats":"zip"}', ''), 169 (0, 'com_content', 'component', 'com_content', '', 1, 1, 0, 1, 1, '', '{"article_layout":"_:default","show_title":"1","link_titles":"1","show_intro":"1","info_block_position":"0","info_block_show_title":"1","show_category":"1","link_category":"1","show_parent_category":"0","link_parent_category":"0","show_associations":"0","flags":"1","show_author":"1","link_author":"0","show_create_date":"0","show_modify_date":"0","show_publish_date":"1","show_item_navigation":"1","show_readmore":"1","show_readmore_title":"1","readmore_limit":100,"show_tags":"1","record_hits":"1","show_hits":"1","show_noauth":"0","urls_position":0,"captcha":"","show_publishing_options":"1","show_article_options":"1","show_configure_edit_options":"1","show_permissions":"1","show_associations_edit":"1","save_history":"1","history_limit":10,"show_urls_images_frontend":"0","show_urls_images_backend":"1","targeta":0,"targetb":0,"targetc":0,"float_intro":"left","float_fulltext":"left","category_layout":"_:blog","show_category_title":"0","show_description":"0","show_description_image":"0","maxLevel":"1","show_empty_categories":"0","show_no_articles":"1","show_category_heading_title_text":"1","show_subcat_desc":"1","show_cat_num_articles":"0","show_cat_tags":"1","show_base_description":"1","maxLevelcat":"-1","show_empty_categories_cat":"0","show_subcat_desc_cat":"1","show_cat_num_articles_cat":"1","num_leading_articles":1,"blog_class_leading":"","num_intro_articles":4,"blog_class":"","num_columns":1,"multi_column_order":"0","num_links":4,"show_subcategory_content":"0","link_intro_image":"0","show_pagination_limit":"1","filter_field":"hide","show_headings":"1","list_show_date":"0","date_format":"","list_show_hits":"1","list_show_author":"1","display_num":"10","orderby_pri":"order","orderby_sec":"rdate","order_date":"published","show_pagination":"2","show_pagination_results":"1","show_featured":"show","show_feed_link":"1","feed_summary":"0","feed_show_readmore":"0","sef_ids":1,"custom_fields_enable":"1","workflow_enabled":"0"}', ''), 170 (0, 'com_config', 'component', 'com_config', '', 1, 1, 0, 1, 1, '', '{"filters":{"1":{"filter_type":"NH","filter_tags":"","filter_attributes":""},"9":{"filter_type":"NH","filter_tags":"","filter_attributes":""},"6":{"filter_type":"BL","filter_tags":"","filter_attributes":""},"7":{"filter_type":"BL","filter_tags":"","filter_attributes":""},"2":{"filter_type":"NH","filter_tags":"","filter_attributes":""},"3":{"filter_type":"BL","filter_tags":"","filter_attributes":""},"4":{"filter_type":"BL","filter_tags":"","filter_attributes":""},"5":{"filter_type":"BL","filter_tags":"","filter_attributes":""},"8":{"filter_type":"NONE","filter_tags":"","filter_attributes":""}}}', ''), 171 (0, 'com_redirect', 'component', 'com_redirect', '', 1, 1, 0, 0, 1, '', '', ''), 172 (0, 'com_users', 'component', 'com_users', '', 1, 1, 0, 1, 1, '', '{"allowUserRegistration":"0","new_usertype":"2","guest_usergroup":"9","sendpassword":"0","useractivation":"2","mail_to_admin":"1","captcha":"","frontend_userparams":"1","site_language":"0","change_login_name":"0","reset_count":"10","reset_time":"1","minimum_length":"12","minimum_integers":"0","minimum_symbols":"0","minimum_uppercase":"0","save_history":"1","history_limit":5,"mailSubjectPrefix":"","mailBodySuffix":""}', ''), 173 (0, 'com_finder', 'component', 'com_finder', '', 1, 1, 0, 0, 1, '', '{"enabled":"0","show_description":"1","description_length":255,"allow_empty_query":"0","show_url":"1","show_autosuggest":"1","show_suggested_query":"1","show_explained_query":"1","show_advanced":"1","show_advanced_tips":"1","expand_advanced":"0","show_date_filters":"0","sort_order":"relevance","sort_direction":"desc","highlight_terms":"1","opensearch_name":"","opensearch_description":"","batch_size":"50","title_multiplier":"1.7","text_multiplier":"0.7","meta_multiplier":"1.2","path_multiplier":"2.0","misc_multiplier":"0.3","stem":"1","stemmer":"snowball","enable_logging":"0"}', ''), 174 (0, 'com_joomlaupdate', 'component', 'com_joomlaupdate', '', 1, 1, 0, 1, 1, '', '{"updatesource":"default","customurl":""}', ''), 175 (0, 'com_tags', 'component', 'com_tags', '', 1, 1, 1, 0, 1, '', '{"tag_layout":"_:default","save_history":"1","history_limit":5,"show_tag_title":"0","tag_list_show_tag_image":"0","tag_list_show_tag_description":"0","tag_list_image":"","tag_list_orderby":"title","tag_list_orderby_direction":"ASC","show_headings":"0","tag_list_show_date":"0","tag_list_show_item_image":"0","tag_list_show_item_description":"0","tag_list_item_maximum_characters":0,"return_any_or_all":"1","include_children":"0","maximum":200,"tag_list_language_filter":"all","tags_layout":"_:default","all_tags_orderby":"title","all_tags_orderby_direction":"ASC","all_tags_show_tag_image":"0","all_tags_show_tag_description":"0","all_tags_tag_maximum_characters":20,"all_tags_show_tag_hits":"0","filter_field":"1","show_pagination_limit":"1","show_pagination":"2","show_pagination_results":"1","tag_field_ajax_mode":"1","show_feed_link":"1"}', ''), 176 (0, 'com_contenthistory', 'component', 'com_contenthistory', '', 1, 1, 1, 0, 1, '', '', ''), 177 (0, 'com_ajax', 'component', 'com_ajax', '', 1, 1, 1, 1, 1, '', '', ''), 178 (0, 'com_postinstall', 'component', 'com_postinstall', '', 1, 1, 1, 1, 1, '', '', ''), 179 (0, 'com_fields', 'component', 'com_fields', '', 1, 1, 1, 0, 1, '', '', ''), 180 (0, 'com_associations', 'component', 'com_associations', '', 1, 1, 1, 0, 1, '', '', ''), 181 (0, 'com_privacy', 'component', 'com_privacy', '', 1, 1, 1, 0, 1, '', '', ''), 182 (0, 'com_actionlogs', 'component', 'com_actionlogs', '', 1, 1, 1, 0, 1, '', '{"ip_logging":0,"csv_delimiter":",","loggable_extensions":["com_banners","com_cache","com_categories","com_checkin","com_config","com_contact","com_content","com_installer","com_media","com_menus","com_messages","com_modules","com_newsfeeds","com_plugins","com_redirect","com_scheduler","com_tags","com_templates","com_users"]}', ''), 183 (0, 'com_workflow', 'component', 'com_workflow', '', 1, 1, 0, 1, 1, '', '{}', ''), 184 (0, 'com_mails', 'component', 'com_mails', '', 1, 1, 1, 1, 1, '', '', ''), 185 (0, 'com_scheduler', 'component', 'com_scheduler', '', 1, 1, 1, 0, 1, '', '{}', ''); 186 187 -- Libraries 188 INSERT INTO `#__extensions` (`package_id`, `name`, `type`, `element`, `folder`, `client_id`, `enabled`, `access`, `protected`, `locked`, `manifest_cache`, `params`, `custom_data`) VALUES 189 (0, 'Joomla! Platform', 'library', 'joomla', '', 0, 1, 1, 1, 1, '', '', ''), 190 (0, 'PHPass', 'library', 'phpass', '', 0, 1, 1, 1, 1, '', '', ''); 191 192 -- Modules: Site 193 INSERT INTO `#__extensions` (`package_id`, `name`, `type`, `element`, `folder`, `client_id`, `enabled`, `access`, `protected`, `locked`, `manifest_cache`, `params`, `custom_data`) VALUES 194 (0, 'mod_articles_archive', 'module', 'mod_articles_archive', '', 0, 1, 1, 0, 1, '', '', ''), 195 (0, 'mod_articles_latest', 'module', 'mod_articles_latest', '', 0, 1, 1, 0, 1, '', '', ''), 196 (0, 'mod_articles_popular', 'module', 'mod_articles_popular', '', 0, 1, 1, 0, 1, '', '', ''), 197 (0, 'mod_banners', 'module', 'mod_banners', '', 0, 1, 1, 0, 1, '', '', ''), 198 (0, 'mod_breadcrumbs', 'module', 'mod_breadcrumbs', '', 0, 1, 1, 0, 1, '', '', ''), 199 (0, 'mod_custom', 'module', 'mod_custom', '', 0, 1, 1, 0, 1, '', '', ''), 200 (0, 'mod_feed', 'module', 'mod_feed', '', 0, 1, 1, 0, 1, '', '', ''), 201 (0, 'mod_footer', 'module', 'mod_footer', '', 0, 1, 1, 0, 1, '', '', ''), 202 (0, 'mod_login', 'module', 'mod_login', '', 0, 1, 1, 0, 1, '', '', ''), 203 (0, 'mod_menu', 'module', 'mod_menu', '', 0, 1, 1, 0, 1, '', '', ''), 204 (0, 'mod_articles_news', 'module', 'mod_articles_news', '', 0, 1, 1, 0, 1, '', '', ''), 205 (0, 'mod_random_image', 'module', 'mod_random_image', '', 0, 1, 1, 0, 1, '', '', ''), 206 (0, 'mod_related_items', 'module', 'mod_related_items', '', 0, 1, 1, 0, 1, '', '', ''), 207 (0, 'mod_stats', 'module', 'mod_stats', '', 0, 1, 1, 0, 1, '', '', ''), 208 (0, 'mod_syndicate', 'module', 'mod_syndicate', '', 0, 1, 1, 0, 1, '', '', ''), 209 (0, 'mod_users_latest', 'module', 'mod_users_latest', '', 0, 1, 1, 0, 1, '', '', ''), 210 (0, 'mod_whosonline', 'module', 'mod_whosonline', '', 0, 1, 1, 0, 1, '', '', ''), 211 (0, 'mod_wrapper', 'module', 'mod_wrapper', '', 0, 1, 1, 0, 1, '', '', ''), 212 (0, 'mod_articles_category', 'module', 'mod_articles_category', '', 0, 1, 1, 0, 1, '', '', ''), 213 (0, 'mod_articles_categories', 'module', 'mod_articles_categories', '', 0, 1, 1, 0, 1, '', '', ''), 214 (0, 'mod_languages', 'module', 'mod_languages', '', 0, 1, 1, 0, 1, '', '', ''), 215 (0, 'mod_finder', 'module', 'mod_finder', '', 0, 1, 0, 0, 1, '', '', ''); 216 217 -- Modules: Administrator 218 INSERT INTO `#__extensions` (`package_id`, `name`, `type`, `element`, `folder`, `client_id`, `enabled`, `access`, `protected`, `locked`, `manifest_cache`, `params`, `custom_data`) VALUES 219 (0, 'mod_custom', 'module', 'mod_custom', '', 1, 1, 1, 0, 1, '', '', ''), 220 (0, 'mod_feed', 'module', 'mod_feed', '', 1, 1, 1, 0, 1, '', '', ''), 221 (0, 'mod_latest', 'module', 'mod_latest', '', 1, 1, 1, 0, 1, '', '', ''), 222 (0, 'mod_logged', 'module', 'mod_logged', '', 1, 1, 1, 0, 1, '', '', ''), 223 (0, 'mod_login', 'module', 'mod_login', '', 1, 1, 1, 0, 1, '', '', ''), 224 (0, 'mod_loginsupport', 'module', 'mod_loginsupport', '', 1, 1, 1, 0, 1, '', '', ''), 225 (0, 'mod_menu', 'module', 'mod_menu', '', 1, 1, 1, 0, 1, '', '', ''), 226 (0, 'mod_popular', 'module', 'mod_popular', '', 1, 1, 1, 0, 1, '', '', ''), 227 (0, 'mod_quickicon', 'module', 'mod_quickicon', '', 1, 1, 1, 0, 1, '', '', ''), 228 (0, 'mod_frontend', 'module', 'mod_frontend', '', 1, 1, 1, 0, 1, '', '', ''), 229 (0, 'mod_messages', 'module', 'mod_messages', '', 1, 1, 1, 0, 1, '', '', ''), 230 (0, 'mod_post_installation_messages', 'module', 'mod_post_installation_messages', '', 1, 1, 1, 0, 1, '', '', ''), 231 (0, 'mod_user', 'module', 'mod_user', '', 1, 1, 1, 0, 1, '', '', ''), 232 (0, 'mod_title', 'module', 'mod_title', '', 1, 1, 1, 0, 1, '', '', ''), 233 (0, 'mod_toolbar', 'module', 'mod_toolbar', '', 1, 1, 1, 0, 1, '', '', ''), 234 (0, 'mod_multilangstatus', 'module', 'mod_multilangstatus', '', 1, 1, 1, 0, 1, '', '{"cache":"0"}', ''), 235 (0, 'mod_version', 'module', 'mod_version', '', 1, 1, 1, 0, 1, '', '{"cache":"0"}', ''), 236 (0, 'mod_stats_admin', 'module', 'mod_stats_admin', '', 1, 1, 1, 0, 1, '', '{"serverinfo":"0","siteinfo":"0","counter":"0","increase":"0","cache":"1","cache_time":"900","cachemode":"static"}', ''), 237 (0, 'mod_tags_popular', 'module', 'mod_tags_popular', '', 0, 1, 1, 0, 1, '', '{"maximum":"5","timeframe":"alltime","owncache":"1"}', ''), 238 (0, 'mod_tags_similar', 'module', 'mod_tags_similar', '', 0, 1, 1, 0, 1, '', '{"maximum":"5","matchtype":"any","owncache":"1"}', ''), 239 (0, 'mod_sampledata', 'module', 'mod_sampledata', '', 1, 1, 1, 0, 1, '', '{}', ''), 240 (0, 'mod_latestactions', 'module', 'mod_latestactions', '', 1, 1, 1, 0, 1, '', '{}', ''), 241 (0, 'mod_privacy_dashboard', 'module', 'mod_privacy_dashboard', '', 1, 1, 1, 0, 1, '', '{}', ''), 242 (0, 'mod_submenu', 'module', 'mod_submenu', '', 1, 1, 1, 0, 1, '', '{}', ''), 243 (0, 'mod_privacy_status', 'module', 'mod_privacy_status', '', 1, 1, 1, 0, 1, '', '{}', ''); 244 245 -- Plugins 246 INSERT INTO `#__extensions` (`package_id`, `name`, `type`, `element`, `folder`, `client_id`, `enabled`, `access`, `protected`, `locked`, `manifest_cache`, `params`, `custom_data`, `ordering`, `state`) VALUES 247 (0, 'plg_actionlog_joomla', 'plugin', 'joomla', 'actionlog', 0, 1, 1, 0, 1, '', '{}', '', 1, 0), 248 (0, 'plg_api-authentication_basic', 'plugin', 'basic', 'api-authentication', 0, 0, 1, 0, 1, '', '{}', '', 1, 0), 249 (0, 'plg_api-authentication_token', 'plugin', 'token', 'api-authentication', 0, 1, 1, 0, 1, '', '{}', '', 2, 0), 250 (0, 'plg_authentication_cookie', 'plugin', 'cookie', 'authentication', 0, 1, 1, 0, 1, '', '', '', 1, 0), 251 (0, 'plg_authentication_joomla', 'plugin', 'joomla', 'authentication', 0, 1, 1, 1, 1, '', '', '', 2, 0), 252 (0, 'plg_authentication_ldap', 'plugin', 'ldap', 'authentication', 0, 0, 1, 0, 1, '', '{"host":"","port":"389","use_ldapV3":"0","negotiate_tls":"0","no_referrals":"0","auth_method":"bind","base_dn":"","search_string":"","users_dn":"","username":"admin","password":"bobby7","ldap_fullname":"fullName","ldap_email":"mail","ldap_uid":"uid"}', '', 3, 0), 253 (0, 'plg_behaviour_taggable', 'plugin', 'taggable', 'behaviour', 0, 1, 1, 0, 1, '', '{}', '', 1, 0), 254 (0, 'plg_behaviour_versionable', 'plugin', 'versionable', 'behaviour', 0, 1, 1, 0, 1, '', '{}', '', 2, 0), 255 (0, 'plg_captcha_recaptcha', 'plugin', 'recaptcha', 'captcha', 0, 0, 1, 0, 1, '', '{"public_key":"","private_key":"","theme":"clean"}', '', 1, 0), 256 (0, 'plg_captcha_recaptcha_invisible', 'plugin', 'recaptcha_invisible', 'captcha', 0, 0, 1, 0, 1, '', '{"public_key":"","private_key":"","theme":"clean"}', '', 2, 0), 257 (0, 'plg_content_confirmconsent', 'plugin', 'confirmconsent', 'content', 0, 0, 1, 0, 1, '', '{}', '', 1, 0), 258 (0, 'plg_content_contact', 'plugin', 'contact', 'content', 0, 1, 1, 0, 1, '', '', '', 2, 0), 259 (0, 'plg_content_emailcloak', 'plugin', 'emailcloak', 'content', 0, 1, 1, 0, 1, '', '{"mode":"1"}', '', 3, 0), 260 (0, 'plg_content_fields', 'plugin', 'fields', 'content', 0, 1, 1, 0, 1, '', '', '', 4, 0), 261 (0, 'plg_content_finder', 'plugin', 'finder', 'content', 0, 1, 1, 0, 1, '', '', '', 5, 0), 262 (0, 'plg_content_joomla', 'plugin', 'joomla', 'content', 0, 1, 1, 0, 1, '', '', '', 6, 0), 263 (0, 'plg_content_loadmodule', 'plugin', 'loadmodule', 'content', 0, 1, 1, 0, 1, '', '{"style":"xhtml"}', '', 7, 0), 264 (0, 'plg_content_pagebreak', 'plugin', 'pagebreak', 'content', 0, 1, 1, 0, 1, '', '{"title":"1","multipage_toc":"1","showall":"1"}', '', 8, 0), 265 (0, 'plg_content_pagenavigation', 'plugin', 'pagenavigation', 'content', 0, 1, 1, 0, 1, '', '{"position":"1"}', '', 9, 0), 266 (0, 'plg_content_vote', 'plugin', 'vote', 'content', 0, 0, 1, 0, 1, '', '', '', 10, 0), 267 (0, 'plg_editors-xtd_article', 'plugin', 'article', 'editors-xtd', 0, 1, 1, 0, 1, '', '', '', 1, 0), 268 (0, 'plg_editors-xtd_contact', 'plugin', 'contact', 'editors-xtd', 0, 1, 1, 0, 1, '', '', '', 2, 0), 269 (0, 'plg_editors-xtd_fields', 'plugin', 'fields', 'editors-xtd', 0, 1, 1, 0, 1, '', '', '', 3, 0), 270 (0, 'plg_editors-xtd_image', 'plugin', 'image', 'editors-xtd', 0, 1, 1, 0, 1, '', '', '', 4, 0), 271 (0, 'plg_editors-xtd_menu', 'plugin', 'menu', 'editors-xtd', 0, 1, 1, 0, 1, '', '', '', 5, 0), 272 (0, 'plg_editors-xtd_module', 'plugin', 'module', 'editors-xtd', 0, 1, 1, 0, 1, '', '', '', 6, 0), 273 (0, 'plg_editors-xtd_pagebreak', 'plugin', 'pagebreak', 'editors-xtd', 0, 1, 1, 0, 1, '', '', '', 7, 0), 274 (0, 'plg_editors-xtd_readmore', 'plugin', 'readmore', 'editors-xtd', 0, 1, 1, 0, 1, '', '', '', 8, 0), 275 (0, 'plg_editors_codemirror', 'plugin', 'codemirror', 'editors', 0, 1, 1, 0, 1, '', '{"lineNumbers":"1","lineWrapping":"1","matchTags":"1","matchBrackets":"1","marker-gutter":"1","autoCloseTags":"1","autoCloseBrackets":"1","autoFocus":"1","theme":"default","tabmode":"indent"}', '', 1, 0), 276 (0, 'plg_editors_none', 'plugin', 'none', 'editors', 0, 1, 1, 1, 1, '', '', '', 2, 0), 277 (0, 'plg_editors_tinymce', 'plugin', 'tinymce', 'editors', 0, 1, 1, 0, 1, '', '{"configuration":{"toolbars":{"2":{"toolbar1":["bold","underline","strikethrough","|","undo","redo","|","bullist","numlist","|","pastetext"]},"1":{"menu":["edit","insert","view","format","table","tools"],"toolbar1":["bold","italic","underline","strikethrough","|","alignleft","aligncenter","alignright","alignjustify","|","formatselect","|","bullist","numlist","|","outdent","indent","|","undo","redo","|","link","unlink","anchor","code","|","hr","table","|","subscript","superscript","|","charmap","pastetext","preview"]},"0":{"menu":["edit","insert","view","format","table","tools"],"toolbar1":["bold","italic","underline","strikethrough","|","alignleft","aligncenter","alignright","alignjustify","|","styleselect","|","formatselect","fontselect","fontsizeselect","|","searchreplace","|","bullist","numlist","|","outdent","indent","|","undo","redo","|","link","unlink","anchor","image","|","code","|","forecolor","backcolor","|","fullscreen","|","table","|","subscript","superscript","|","charmap","emoticons","media","hr","ltr","rtl","|","cut","copy","paste","pastetext","|","visualchars","visualblocks","nonbreaking","blockquote","template","|","print","preview","codesample","insertdatetime","removeformat"]}},"setoptions":{"2":{"access":["1"],"skin":"0","skin_admin":"0","mobile":"0","drag_drop":"1","path":"","entity_encoding":"raw","lang_mode":"1","text_direction":"ltr","content_css":"1","content_css_custom":"","relative_urls":"1","newlines":"0","use_config_textfilters":"0","invalid_elements":"script,applet,iframe","valid_elements":"","extended_elements":"","resizing":"1","resize_horizontal":"1","element_path":"1","wordcount":"1","image_advtab":"0","advlist":"1","autosave":"1","contextmenu":"1","custom_plugin":"","custom_button":""},"1":{"access":["6","2"],"skin":"0","skin_admin":"0","mobile":"0","drag_drop":"1","path":"","entity_encoding":"raw","lang_mode":"1","text_direction":"ltr","content_css":"1","content_css_custom":"","relative_urls":"1","newlines":"0","use_config_textfilters":"0","invalid_elements":"script,applet,iframe","valid_elements":"","extended_elements":"","resizing":"1","resize_horizontal":"1","element_path":"1","wordcount":"1","image_advtab":"0","advlist":"1","autosave":"1","contextmenu":"1","custom_plugin":"","custom_button":""},"0":{"access":["7","4","8"],"skin":"0","skin_admin":"0","mobile":"0","drag_drop":"1","path":"","entity_encoding":"raw","lang_mode":"1","text_direction":"ltr","content_css":"1","content_css_custom":"","relative_urls":"1","newlines":"0","use_config_textfilters":"0","invalid_elements":"script,applet,iframe","valid_elements":"","extended_elements":"","resizing":"1","resize_horizontal":"1","element_path":"1","wordcount":"1","image_advtab":"1","advlist":"1","autosave":"1","contextmenu":"1","custom_plugin":"","custom_button":""}}},"sets_amount":3,"html_height":"550","html_width":"750"}', '', 3, 0), 278 (0, 'plg_extension_finder', 'plugin', 'finder', 'extension', 0, 1, 1, 0, 1, '', '', '', 1, 0), 279 (0, 'plg_extension_joomla', 'plugin', 'joomla', 'extension', 0, 1, 1, 0, 1, '', '', '', 2, 0), 280 (0, 'plg_extension_namespacemap', 'plugin', 'namespacemap', 'extension', 0, 1, 1, 1, 1, '', '{}', '', 3, 0), 281 (0, 'plg_fields_calendar', 'plugin', 'calendar', 'fields', 0, 1, 1, 0, 1, '', '', '', 1, 0), 282 (0, 'plg_fields_checkboxes', 'plugin', 'checkboxes', 'fields', 0, 1, 1, 0, 1, '', '', '', 2, 0), 283 (0, 'plg_fields_color', 'plugin', 'color', 'fields', 0, 1, 1, 0, 1, '', '', '', 3, 0), 284 (0, 'plg_fields_editor', 'plugin', 'editor', 'fields', 0, 1, 1, 0, 1, '', '', '', 4, 0), 285 (0, 'plg_fields_imagelist', 'plugin', 'imagelist', 'fields', 0, 1, 1, 0, 1, '', '', '', 5, 0), 286 (0, 'plg_fields_integer', 'plugin', 'integer', 'fields', 0, 1, 1, 0, 1, '', '{"multiple":"0","first":"1","last":"100","step":"1"}', '', 6, 0), 287 (0, 'plg_fields_list', 'plugin', 'list', 'fields', 0, 1, 1, 0, 1, '', '', '', 7, 0), 288 (0, 'plg_fields_media', 'plugin', 'media', 'fields', 0, 1, 1, 0, 1, '', '', '', 8, 0), 289 (0, 'plg_fields_radio', 'plugin', 'radio', 'fields', 0, 1, 1, 0, 1, '', '', '', 9, 0), 290 (0, 'plg_fields_sql', 'plugin', 'sql', 'fields', 0, 1, 1, 0, 1, '', '', '', 10, 0), 291 (0, 'plg_fields_subform', 'plugin', 'subform', 'fields', 0, 1, 1, 0, 1, '', '', '', 11, 0), 292 (0, 'plg_fields_text', 'plugin', 'text', 'fields', 0, 1, 1, 0, 1, '', '', '', 12, 0), 293 (0, 'plg_fields_textarea', 'plugin', 'textarea', 'fields', 0, 1, 1, 0, 1, '', '', '', 13, 0), 294 (0, 'plg_fields_url', 'plugin', 'url', 'fields', 0, 1, 1, 0, 1, '', '', '', 14, 0), 295 (0, 'plg_fields_user', 'plugin', 'user', 'fields', 0, 1, 1, 0, 1, '', '', '', 15, 0), 296 (0, 'plg_fields_usergrouplist', 'plugin', 'usergrouplist', 'fields', 0, 1, 1, 0, 1, '', '', '', 16, 0), 297 (0, 'plg_filesystem_local', 'plugin', 'local', 'filesystem', 0, 1, 1, 0, 1, '', '{}', '', 1, 0), 298 (0, 'plg_finder_categories', 'plugin', 'categories', 'finder', 0, 1, 1, 0, 1, '', '', '', 1, 0), 299 (0, 'plg_finder_contacts', 'plugin', 'contacts', 'finder', 0, 1, 1, 0, 1, '', '', '', 2, 0), 300 (0, 'plg_finder_content', 'plugin', 'content', 'finder', 0, 1, 1, 0, 1, '', '', '', 3, 0), 301 (0, 'plg_finder_newsfeeds', 'plugin', 'newsfeeds', 'finder', 0, 1, 1, 0, 1, '', '', '', 4, 0), 302 (0, 'plg_finder_tags', 'plugin', 'tags', 'finder', 0, 1, 1, 0, 1, '', '', '', 5, 0), 303 (0, 'plg_installer_folderinstaller', 'plugin', 'folderinstaller', 'installer', 0, 1, 1, 0, 1, '', '', '', 2, 0), 304 (0, 'plg_installer_override', 'plugin', 'override', 'installer', 0, 1, 1, 0, 1, '', '', '', 4, 0), 305 (0, 'plg_installer_packageinstaller', 'plugin', 'packageinstaller', 'installer', 0, 1, 1, 0, 1, '', '', '', 1, 0), 306 (0, 'plg_installer_urlinstaller', 'plugin', 'urlinstaller', 'installer', 0, 1, 1, 0, 1, '', '', '', 3, 0), 307 (0, 'plg_installer_webinstaller', 'plugin', 'webinstaller', 'installer', 0, 1, 1, 0, 1, '', '{"tab_position":"1"}', '', 5, 0), 308 (0, 'plg_media-action_crop', 'plugin', 'crop', 'media-action', 0, 1, 1, 0, 1, '', '{}', '', 1, 0), 309 (0, 'plg_media-action_resize', 'plugin', 'resize', 'media-action', 0, 1, 1, 0, 1, '', '{}', '', 2, 0), 310 (0, 'plg_media-action_rotate', 'plugin', 'rotate', 'media-action', 0, 1, 1, 0, 1, '', '{}', '', 3, 0), 311 (0, 'plg_privacy_actionlogs', 'plugin', 'actionlogs', 'privacy', 0, 1, 1, 0, 1, '', '{}', '', 1, 0), 312 (0, 'plg_privacy_consents', 'plugin', 'consents', 'privacy', 0, 1, 1, 0, 1, '', '{}', '', 2, 0), 313 (0, 'plg_privacy_contact', 'plugin', 'contact', 'privacy', 0, 1, 1, 0, 1, '', '{}', '', 3, 0), 314 (0, 'plg_privacy_content', 'plugin', 'content', 'privacy', 0, 1, 1, 0, 1, '', '{}', '', 4, 0), 315 (0, 'plg_privacy_message', 'plugin', 'message', 'privacy', 0, 1, 1, 0, 1, '', '{}', '', 5, 0), 316 (0, 'plg_privacy_user', 'plugin', 'user', 'privacy', 0, 1, 1, 0, 1, '', '{}', '', 6, 0), 317 (0, 'plg_quickicon_joomlaupdate', 'plugin', 'joomlaupdate', 'quickicon', 0, 1, 1, 0, 1, '', '', '', 1, 0), 318 (0, 'plg_quickicon_extensionupdate', 'plugin', 'extensionupdate', 'quickicon', 0, 1, 1, 0, 1, '', '', '', 2, 0), 319 (0, 'plg_quickicon_overridecheck', 'plugin', 'overridecheck', 'quickicon', 0, 1, 1, 0, 1, '', '', '', 3, 0), 320 (0, 'plg_quickicon_downloadkey', 'plugin', 'downloadkey', 'quickicon', 0, 1, 1, 0, 1, '', '', '', 4, 0), 321 (0, 'plg_quickicon_privacycheck', 'plugin', 'privacycheck', 'quickicon', 0, 1, 1, 0, 1, '', '{}', '', 5, 0), 322 (0, 'plg_quickicon_phpversioncheck', 'plugin', 'phpversioncheck', 'quickicon', 0, 1, 1, 0, 1, '', '', '', 6, 0), 323 (0, 'plg_sampledata_blog', 'plugin', 'blog', 'sampledata', 0, 1, 1, 0, 1, '', '', '', 1, 0), 324 (0, 'plg_sampledata_multilang', 'plugin', 'multilang', 'sampledata', 0, 1, 1, 0, 1, '', '', '', 2, 0), 325 (0, 'plg_system_accessibility', 'plugin', 'accessibility', 'system', 0, 0, 1, 0, 1, '', '{}', '', 1, 0), 326 (0, 'plg_system_actionlogs', 'plugin', 'actionlogs', 'system', 0, 1, 1, 0, 1, '', '{}', '', 2, 0), 327 (0, 'plg_system_cache', 'plugin', 'cache', 'system', 0, 0, 1, 0, 1, '', '{"browsercache":"0","cachetime":"15"}', '', 3, 0), 328 (0, 'plg_system_debug', 'plugin', 'debug', 'system', 0, 1, 1, 0, 1, '', '{"profile":"1","queries":"1","memory":"1","language_files":"1","language_strings":"1","strip-first":"1","strip-prefix":"","strip-suffix":""}', '', 4, 0), 329 (0, 'plg_system_fields', 'plugin', 'fields', 'system', 0, 1, 1, 0, 1, '', '', '', 5, 0), 330 (0, 'plg_system_highlight', 'plugin', 'highlight', 'system', 0, 1, 1, 0, 1, '', '', '', 6, 0), 331 (0, 'plg_system_httpheaders', 'plugin', 'httpheaders', 'system', 0, 1, 1, 0, 1, '', '{}', '', 7, 0), 332 (0, 'plg_system_jooa11y', 'plugin', 'jooa11y', 'system', 0, 1, 1, 0, 1, '', '', '', 8, 0), 333 (0, 'plg_system_languagecode', 'plugin', 'languagecode', 'system', 0, 0, 1, 0, 1, '', '', '', 9, 0), 334 (0, 'plg_system_languagefilter', 'plugin', 'languagefilter', 'system', 0, 0, 1, 0, 1, '', '', '', 10, 0), 335 (0, 'plg_system_log', 'plugin', 'log', 'system', 0, 1, 1, 0, 1, '', '', '', 11, 0), 336 (0, 'plg_system_logout', 'plugin', 'logout', 'system', 0, 1, 1, 0, 1, '', '', '', 12, 0), 337 (0, 'plg_system_logrotation', 'plugin', 'logrotation', 'system', 0, 1, 1, 0, 1, '', '{}', '', 13, 0), 338 (0, 'plg_system_privacyconsent', 'plugin', 'privacyconsent', 'system', 0, 0, 1, 0, 1, '', '{}', '', 14, 0), 339 (0, 'plg_system_redirect', 'plugin', 'redirect', 'system', 0, 0, 1, 0, 1, '', '', '', 15, 0), 340 (0, 'plg_system_remember', 'plugin', 'remember', 'system', 0, 1, 1, 0, 1, '', '', '', 16, 0), 341 (0, 'plg_system_schedulerunner', 'plugin', 'schedulerunner', 'system', 0, 1, 1, 0, 1, '', '{}', '', 17, 0), 342 (0, 'plg_system_sef', 'plugin', 'sef', 'system', 0, 1, 1, 0, 1, '', '', '', 18, 0), 343 (0, 'plg_system_sessiongc', 'plugin', 'sessiongc', 'system', 0, 1, 1, 0, 1, '', '', '', 19, 0), 344 (0, 'plg_system_shortcut', 'plugin', 'shortcut', 'system', 0, 1, 1, 0, 1, '', '{}', '', 0, 0), 345 (0, 'plg_system_skipto', 'plugin', 'skipto', 'system', 0, 1, 1, 0, 1, '', '{}', '', 20, 0), 346 (0, 'plg_system_stats', 'plugin', 'stats', 'system', 0, 1, 1, 0, 1, '', '', '', 21, 0), 347 (0, 'plg_system_tasknotification', 'plugin', 'tasknotification', 'system', 0, 1, 1, 0, 1, '', '', '', 22, 0), 348 (0, 'plg_system_updatenotification', 'plugin', 'updatenotification', 'system', 0, 1, 1, 0, 1, '', '', '', 23, 0), 349 (0, 'plg_system_webauthn', 'plugin', 'webauthn', 'system', 0, 1, 1, 0, 1, '', '{}', '', 23, 0), 350 (0, 'plg_task_checkfiles', 'plugin', 'checkfiles', 'task', 0, 1, 1, 0, 1, '', '{}', '', 1, 0), 351 (0, 'plg_task_demotasks', 'plugin', 'demotasks', 'task', 0, 1, 1, 0, 1, '', '{}', '', 2, 0), 352 (0, 'plg_task_requests', 'plugin', 'requests', 'task', 0, 1, 1, 0, 1, '', '{}', '', 3, 0), 353 (0, 'plg_task_sitestatus', 'plugin', 'sitestatus', 'task', 0, 1, 1, 0, 1, '', '{}', '', 4, 0), 354 (0, 'plg_multifactorauth_totp', 'plugin', 'totp', 'multifactorauth', 0, 1, 1, 0, 1, '', '', '', 1, 0), 355 (0, 'plg_multifactorauth_yubikey', 'plugin', 'yubikey', 'multifactorauth', 0, 1, 1, 0, 1, '', '', '', 2, 0), 356 (0, 'plg_multifactorauth_webauthn', 'plugin', 'webauthn', 'multifactorauth', 0, 1, 1, 0, 1, '', '', '', 3, 0), 357 (0, 'plg_multifactorauth_email', 'plugin', 'email', 'multifactorauth', 0, 1, 1, 0, 1, '', '', '', 4, 0), 358 (0, 'plg_multifactorauth_fixed', 'plugin', 'fixed', 'multifactorauth', 0, 0, 1, 0, 1, '', '', '', 5, 0), 359 (0, 'plg_user_contactcreator', 'plugin', 'contactcreator', 'user', 0, 0, 1, 0, 1, '', '{"autowebpage":"","category":"4","autopublish":"0"}', '', 1, 0), 360 (0, 'plg_user_joomla', 'plugin', 'joomla', 'user', 0, 1, 1, 0, 1, '', '{"autoregister":"1","mail_to_user":"1","forceLogout":"1"}', '', 2, 0), 361 (0, 'plg_user_profile', 'plugin', 'profile', 'user', 0, 0, 1, 0, 1, '', '{"register-require_address1":"1","register-require_address2":"1","register-require_city":"1","register-require_region":"1","register-require_country":"1","register-require_postal_code":"1","register-require_phone":"1","register-require_website":"1","register-require_favoritebook":"1","register-require_aboutme":"1","register-require_tos":"1","register-require_dob":"1","profile-require_address1":"1","profile-require_address2":"1","profile-require_city":"1","profile-require_region":"1","profile-require_country":"1","profile-require_postal_code":"1","profile-require_phone":"1","profile-require_website":"1","profile-require_favoritebook":"1","profile-require_aboutme":"1","profile-require_tos":"1","profile-require_dob":"1"}', '', 3, 0), 362 (0, 'plg_user_terms', 'plugin', 'terms', 'user', 0, 0, 1, 0, 1, '', '{}', '', 4, 0), 363 (0, 'plg_user_token', 'plugin', 'token', 'user', 0, 1, 1, 0, 1, '', '{}', '', 5, 0), 364 (0, 'plg_webservices_banners', 'plugin', 'banners', 'webservices', 0, 1, 1, 0, 1, '', '{}', '', 1, 0), 365 (0, 'plg_webservices_config', 'plugin', 'config', 'webservices', 0, 1, 1, 0, 1, '', '{}', '', 2, 0), 366 (0, 'plg_webservices_contact', 'plugin', 'contact', 'webservices', 0, 1, 1, 0, 1, '', '{}', '', 3, 0), 367 (0, 'plg_webservices_content', 'plugin', 'content', 'webservices', 0, 1, 1, 0, 1, '', '{}', '', 4, 0), 368 (0, 'plg_webservices_installer', 'plugin', 'installer', 'webservices', 0, 1, 1, 0, 1, '', '{}', '', 5, 0), 369 (0, 'plg_webservices_languages', 'plugin', 'languages', 'webservices', 0, 1, 1, 0, 1, '', '{}', '', 6, 0), 370 (0, 'plg_webservices_media', 'plugin', 'media', 'webservices', 0, 1, 1, 0, 1, '', '{}', '', 7, 0), 371 (0, 'plg_webservices_menus', 'plugin', 'menus', 'webservices', 0, 1, 1, 0, 1, '', '{}', '', 7, 0), 372 (0, 'plg_webservices_messages', 'plugin', 'messages', 'webservices', 0, 1, 1, 0, 1, '', '{}', '', 8, 0), 373 (0, 'plg_webservices_modules', 'plugin', 'modules', 'webservices', 0, 1, 1, 0, 1, '', '{}', '', 9, 0), 374 (0, 'plg_webservices_newsfeeds', 'plugin', 'newsfeeds', 'webservices', 0, 1, 1, 0, 1, '', '{}', '', 10, 0), 375 (0, 'plg_webservices_plugins', 'plugin', 'plugins', 'webservices', 0, 1, 1, 0, 1, '', '{}', '', 11, 0), 376 (0, 'plg_webservices_privacy', 'plugin', 'privacy', 'webservices', 0, 1, 1, 0, 1, '', '{}', '', 12, 0), 377 (0, 'plg_webservices_redirect', 'plugin', 'redirect', 'webservices', 0, 1, 1, 0, 1, '', '{}', '', 13, 0), 378 (0, 'plg_webservices_tags', 'plugin', 'tags', 'webservices', 0, 1, 1, 0, 1, '', '{}', '', 14, 0), 379 (0, 'plg_webservices_templates', 'plugin', 'templates', 'webservices', 0, 1, 1, 0, 1, '', '{}', '', 15, 0), 380 (0, 'plg_webservices_users', 'plugin', 'users', 'webservices', 0, 1, 1, 0, 1, '', '{}', '', 16, 0), 381 (0, 'plg_workflow_featuring', 'plugin', 'featuring', 'workflow', 0, 1, 1, 0, 1, '', '{}', '', 1, 0), 382 (0, 'plg_workflow_notification', 'plugin', 'notification', 'workflow', 0, 1, 1, 0, 1, '', '{}', '', 2, 0), 383 (0, 'plg_workflow_publishing', 'plugin', 'publishing', 'workflow', 0, 1, 1, 0, 1, '', '{}', '', 3, 0); 384 385 -- Templates 386 INSERT INTO `#__extensions` (`package_id`, `name`, `type`, `element`, `folder`, `client_id`, `enabled`, `access`, `protected`, `locked`, `manifest_cache`, `params`, `custom_data`, `ordering`, `state`) VALUES 387 (0, 'atum', 'template', 'atum', '', 1, 1, 1, 0, 1, '', '', '', 0, 0), 388 (0, 'cassiopeia', 'template', 'cassiopeia', '', 0, 1, 1, 0, 1, '', '{"logoFile":"","fluidContainer":"0","sidebarLeftWidth":"3","sidebarRightWidth":"3"}', '', 0, 0); 389 390 -- Files Extensions 391 INSERT INTO `#__extensions` (`package_id`, `name`, `type`, `element`, `folder`, `client_id`, `enabled`, `access`, `protected`, `locked`, `manifest_cache`, `params`, `custom_data`, `ordering`, `state`) VALUES 392 (0, 'files_joomla', 'file', 'joomla', '', 0, 1, 1, 1, 1, '', '', '', 0, 0); 393 394 -- Packages 395 INSERT INTO `#__extensions` (`package_id`, `name`, `type`, `element`, `folder`, `client_id`, `enabled`, `access`, `protected`, `locked`, `manifest_cache`, `params`, `custom_data`, `ordering`, `state`) VALUES 396 (0, 'English (en-GB) Language Pack', 'package', 'pkg_en-GB', '', 0, 1, 1, 1, 1, '', '', '', 0, 0); 397 398 INSERT INTO `#__extensions` (`package_id`, `name`, `type`, `element`, `folder`, `client_id`, `enabled`, `access`, `protected`, `locked`, `manifest_cache`, `params`, `custom_data`, `ordering`, `state`) 399 SELECT `extension_id`, 'English (en-GB)', 'language', 'en-GB', '', 0, 1, 1, 1, 1, '', '', '', 0, 0 FROM `#__extensions` WHERE `name` = 'English (en-GB) Language Pack'; 400 INSERT INTO `#__extensions` (`package_id`, `name`, `type`, `element`, `folder`, `client_id`, `enabled`, `access`, `protected`, `locked`, `manifest_cache`, `params`, `custom_data`, `ordering`, `state`) 401 SELECT `extension_id`, 'English (en-GB)', 'language', 'en-GB', '', 1, 1, 1, 1, 1, '', '', '', 0, 0 FROM `#__extensions` WHERE `name` = 'English (en-GB) Language Pack'; 402 INSERT INTO `#__extensions` (`package_id`, `name`, `type`, `element`, `folder`, `client_id`, `enabled`, `access`, `protected`, `locked`, `manifest_cache`, `params`, `custom_data`, `ordering`, `state`) 403 SELECT `extension_id`, 'English (en-GB)', 'language', 'en-GB', '', 3, 1, 1, 1, 1, '', '', '', 0, 0 FROM `#__extensions` WHERE `name` = 'English (en-GB) Language Pack'; 404 405 -- -------------------------------------------------------- 406 407 -- 408 -- Table structure for table `#__languages` 409 -- 410 411 CREATE TABLE IF NOT EXISTS `#__languages` ( 412 `lang_id` int unsigned NOT NULL AUTO_INCREMENT, 413 `asset_id` int unsigned NOT NULL DEFAULT 0, 414 `lang_code` char(7) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL, 415 `title` varchar(50) NOT NULL, 416 `title_native` varchar(50) NOT NULL, 417 `sef` varchar(50) NOT NULL, 418 `image` varchar(50) NOT NULL, 419 `description` varchar(512) NOT NULL, 420 `metakey` text, 421 `metadesc` text NOT NULL, 422 `sitename` varchar(1024) NOT NULL DEFAULT '', 423 `published` int NOT NULL DEFAULT 0, 424 `access` int unsigned NOT NULL DEFAULT 0, 425 `ordering` int NOT NULL DEFAULT 0, 426 PRIMARY KEY (`lang_id`), 427 UNIQUE KEY `idx_sef` (`sef`), 428 UNIQUE KEY `idx_langcode` (`lang_code`), 429 KEY `idx_access` (`access`), 430 KEY `idx_ordering` (`ordering`) 431 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci; 432 433 -- 434 -- Dumping data for table `#__languages` 435 -- 436 437 INSERT INTO `#__languages` (`lang_id`, `lang_code`, `title`, `title_native`, `sef`, `image`, `description`, `metakey`, `metadesc`, `sitename`, `published`, `access`, `ordering`) VALUES 438 (1, 'en-GB', 'English (en-GB)', 'English (United Kingdom)', 'en', 'en_gb', '', '', '', '', 1, 1, 1); 439 440 -- -------------------------------------------------------- 441 442 -- 443 -- Table structure for table `#__menu` 444 -- 445 446 CREATE TABLE IF NOT EXISTS `#__menu` ( 447 `id` int NOT NULL AUTO_INCREMENT, 448 `menutype` varchar(24) NOT NULL COMMENT 'The type of menu this item belongs to. FK to #__menu_types.menutype', 449 `title` varchar(255) NOT NULL COMMENT 'The display title of the menu item.', 450 `alias` varchar(400) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT 'The SEF alias of the menu item.', 451 `note` varchar(255) NOT NULL DEFAULT '', 452 `path` varchar(1024) NOT NULL COMMENT 'The computed path of the menu item based on the alias field.', 453 `link` varchar(1024) NOT NULL COMMENT 'The actually link the menu item refers to.', 454 `type` varchar(16) NOT NULL COMMENT 'The type of link: Component, URL, Alias, Separator', 455 `published` tinyint NOT NULL DEFAULT 0 COMMENT 'The published state of the menu link.', 456 `parent_id` int unsigned NOT NULL DEFAULT 1 COMMENT 'The parent menu item in the menu tree.', 457 `level` int unsigned NOT NULL DEFAULT 0 COMMENT 'The relative level in the tree.', 458 `component_id` int unsigned NOT NULL DEFAULT 0 COMMENT 'FK to #__extensions.id', 459 `checked_out` int unsigned COMMENT 'FK to #__users.id', 460 `checked_out_time` datetime COMMENT 'The time the menu item was checked out.', 461 `browserNav` tinyint NOT NULL DEFAULT 0 COMMENT 'The click behaviour of the link.', 462 `access` int unsigned NOT NULL DEFAULT 0 COMMENT 'The access level required to view the menu item.', 463 `img` varchar(255) NOT NULL COMMENT 'The image of the menu item.', 464 `template_style_id` int unsigned NOT NULL DEFAULT 0, 465 `params` text NOT NULL COMMENT 'JSON encoded data for the menu item.', 466 `lft` int NOT NULL DEFAULT 0 COMMENT 'Nested set lft.', 467 `rgt` int NOT NULL DEFAULT 0 COMMENT 'Nested set rgt.', 468 `home` tinyint unsigned NOT NULL DEFAULT 0 COMMENT 'Indicates if this menu item is the home or default page.', 469 `language` char(7) NOT NULL DEFAULT '', 470 `client_id` tinyint NOT NULL DEFAULT 0, 471 `publish_up` datetime, 472 `publish_down` datetime, 473 PRIMARY KEY (`id`), 474 UNIQUE KEY `idx_client_id_parent_id_alias_language` (`client_id`,`parent_id`,`alias`(100),`language`), 475 KEY `idx_componentid` (`component_id`,`menutype`,`published`,`access`), 476 KEY `idx_menutype` (`menutype`), 477 KEY `idx_left_right` (`lft`,`rgt`), 478 KEY `idx_alias` (`alias`(100)), 479 KEY `idx_path` (`path`(100)), 480 KEY `idx_language` (`language`) 481 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=102; 482 483 -- 484 -- Dumping data for table `#__menu` 485 -- 486 487 INSERT INTO `#__menu` (`id`, `menutype`, `title`, `alias`, `note`, `path`, `link`, `type`, `published`, `parent_id`, `level`, `component_id`, `browserNav`, `access`, `img`, `template_style_id`, `params`, `lft`, `rgt`, `home`, `language`, `client_id`, `publish_up`, `publish_down`) VALUES 488 (1, '', 'Menu_Item_Root', 'root', '', '', '', '', 1, 0, 0, 0, 0, 0, '', 0, '', 0, 43, 0, '*', 0, NULL, NULL); 489 INSERT INTO `#__menu` (`id`, `menutype`, `title`, `alias`, `note`, `path`, `link`, `type`, `published`, `parent_id`, `level`, `component_id`, `browserNav`, `access`, `img`, `template_style_id`, `params`, `lft`, `rgt`, `home`, `language`, `client_id`, `publish_up`, `publish_down`) 490 SELECT 2, 'main', 'com_banners', 'Banners', '', 'Banners', 'index.php?option=com_banners', 'component', 1, 1, 1, `extension_id`, 0, 0, 'class:bookmark', 0, '', 1, 10, 0, '*', 1, NULL, NULL FROM `#__extensions` WHERE `name` = 'com_banners'; 491 INSERT INTO `#__menu` (`id`, `menutype`, `title`, `alias`, `note`, `path`, `link`, `type`, `published`, `parent_id`, `level`, `component_id`, `browserNav`, `access`, `img`, `template_style_id`, `params`, `lft`, `rgt`, `home`, `language`, `client_id`, `publish_up`, `publish_down`) 492 SELECT 3, 'main', 'com_banners', 'Banners', '', 'Banners/Banners', 'index.php?option=com_banners&view=banners', 'component', 1, 2, 2, `extension_id`, 0, 0, 'class:banners', 0, '', 2, 3, 0, '*', 1, NULL, NULL FROM `#__extensions` WHERE `name` = 'com_banners'; 493 INSERT INTO `#__menu` (`id`, `menutype`, `title`, `alias`, `note`, `path`, `link`, `type`, `published`, `parent_id`, `level`, `component_id`, `browserNav`, `access`, `img`, `template_style_id`, `params`, `lft`, `rgt`, `home`, `language`, `client_id`, `publish_up`, `publish_down`) 494 SELECT 4, 'main', 'com_banners_categories', 'Categories', '', 'Banners/Categories', 'index.php?option=com_categories&view=categories&extension=com_banners', 'component', 1, 2, 2, `extension_id`, 0, 0, 'class:banners-cat', 0, '', 4, 5, 0, '*', 1, NULL, NULL FROM `#__extensions` WHERE `name` = 'com_categories'; 495 INSERT INTO `#__menu` (`id`, `menutype`, `title`, `alias`, `note`, `path`, `link`, `type`, `published`, `parent_id`, `level`, `component_id`, `browserNav`, `access`, `img`, `template_style_id`, `params`, `lft`, `rgt`, `home`, `language`, `client_id`, `publish_up`, `publish_down`) 496 SELECT 5, 'main', 'com_banners_clients', 'Clients', '', 'Banners/Clients', 'index.php?option=com_banners&view=clients', 'component', 1, 2, 2, `extension_id`, 0, 0, 'class:banners-clients', 0, '', 6, 7, 0, '*', 1, NULL, NULL FROM `#__extensions` WHERE `name` = 'com_banners'; 497 INSERT INTO `#__menu` (`id`, `menutype`, `title`, `alias`, `note`, `path`, `link`, `type`, `published`, `parent_id`, `level`, `component_id`, `browserNav`, `access`, `img`, `template_style_id`, `params`, `lft`, `rgt`, `home`, `language`, `client_id`, `publish_up`, `publish_down`) 498 SELECT 6, 'main', 'com_banners_tracks', 'Tracks', '', 'Banners/Tracks', 'index.php?option=com_banners&view=tracks', 'component', 1, 2, 2, `extension_id`, 0, 0, 'class:banners-tracks', 0, '', 8, 9, 0, '*', 1, NULL, NULL FROM `#__extensions` WHERE `name` = 'com_banners'; 499 INSERT INTO `#__menu` (`id`, `menutype`, `title`, `alias`, `note`, `path`, `link`, `type`, `published`, `parent_id`, `level`, `component_id`, `browserNav`, `access`, `img`, `template_style_id`, `params`, `lft`, `rgt`, `home`, `language`, `client_id`, `publish_up`, `publish_down`) 500 SELECT 7, 'main', 'com_contact', 'Contacts', '', 'Contacts', 'index.php?option=com_contact', 'component', 1, 1, 1, `extension_id`, 0, 0, 'class:address-book', 0, '', 11, 20, 0, '*', 1, NULL, NULL FROM `#__extensions` WHERE `name` = 'com_contact'; 501 INSERT INTO `#__menu` (`id`, `menutype`, `title`, `alias`, `note`, `path`, `link`, `type`, `published`, `parent_id`, `level`, `component_id`, `browserNav`, `access`, `img`, `template_style_id`, `params`, `lft`, `rgt`, `home`, `language`, `client_id`, `publish_up`, `publish_down`) 502 SELECT 8, 'main', 'com_contact_contacts', 'Contacts', '', 'Contacts/Contacts', 'index.php?option=com_contact&view=contacts', 'component', 1, 7, 2, `extension_id`, 0, 0, 'class:contact', 0, '', 12, 13, 0, '*', 1, NULL, NULL FROM `#__extensions` WHERE `name` = 'com_contact'; 503 INSERT INTO `#__menu` (`id`, `menutype`, `title`, `alias`, `note`, `path`, `link`, `type`, `published`, `parent_id`, `level`, `component_id`, `browserNav`, `access`, `img`, `template_style_id`, `params`, `lft`, `rgt`, `home`, `language`, `client_id`, `publish_up`, `publish_down`) 504 SELECT 9, 'main', 'com_contact_categories', 'Categories', '', 'Contacts/Categories', 'index.php?option=com_categories&view=categories&extension=com_contact', 'component', 1, 7, 2, `extension_id`, 0, 0, 'class:contact-cat', 0, '', 14, 15, 0, '*', 1, NULL, NULL FROM `#__extensions` WHERE `name` = 'com_categories'; 505 INSERT INTO `#__menu` (`id`, `menutype`, `title`, `alias`, `note`, `path`, `link`, `type`, `published`, `parent_id`, `level`, `component_id`, `browserNav`, `access`, `img`, `template_style_id`, `params`, `lft`, `rgt`, `home`, `language`, `client_id`, `publish_up`, `publish_down`) 506 SELECT 10, 'main', 'com_newsfeeds', 'News Feeds', '', 'News Feeds', 'index.php?option=com_newsfeeds', 'component', 1, 1, 1, `extension_id`, 0, 0, 'class:rss', 0, '', 23, 28, 0, '*', 1, NULL, NULL FROM `#__extensions` WHERE `name` = 'com_newsfeeds'; 507 INSERT INTO `#__menu` (`id`, `menutype`, `title`, `alias`, `note`, `path`, `link`, `type`, `published`, `parent_id`, `level`, `component_id`, `browserNav`, `access`, `img`, `template_style_id`, `params`, `lft`, `rgt`, `home`, `language`, `client_id`, `publish_up`, `publish_down`) 508 SELECT 11, 'main', 'com_newsfeeds_feeds', 'Feeds', '', 'News Feeds/Feeds', 'index.php?option=com_newsfeeds&view=newsfeeds', 'component', 1, 10, 2, `extension_id`, 0, 0, 'class:newsfeeds', 0, '', 24, 25, 0, '*', 1, NULL, NULL FROM `#__extensions` WHERE `name` = 'com_newsfeeds'; 509 INSERT INTO `#__menu` (`id`, `menutype`, `title`, `alias`, `note`, `path`, `link`, `type`, `published`, `parent_id`, `level`, `component_id`, `browserNav`, `access`, `img`, `template_style_id`, `params`, `lft`, `rgt`, `home`, `language`, `client_id`, `publish_up`, `publish_down`) 510 SELECT 12, 'main', 'com_newsfeeds_categories', 'Categories', '', 'News Feeds/Categories', 'index.php?option=com_categories&view=categories&extension=com_newsfeeds', 'component', 1, 10, 2, `extension_id`, 0, 0, 'class:newsfeeds-cat', 0, '', 26, 27, 0, '*', 1, NULL, NULL FROM `#__extensions` WHERE `name` = 'com_categories'; 511 INSERT INTO `#__menu` (`id`, `menutype`, `title`, `alias`, `note`, `path`, `link`, `type`, `published`, `parent_id`, `level`, `component_id`, `browserNav`, `access`, `img`, `template_style_id`, `params`, `lft`, `rgt`, `home`, `language`, `client_id`, `publish_up`, `publish_down`) 512 SELECT 13, 'main', 'com_finder', 'Smart Search', '', 'Smart Search', 'index.php?option=com_finder', 'component', 1, 1, 1, `extension_id`, 0, 0, 'class:search-plus', 0, '', 29, 38, 0, '*', 1, NULL, NULL FROM `#__extensions` WHERE `name` = 'com_finder'; 513 INSERT INTO `#__menu` (`id`, `menutype`, `title`, `alias`, `note`, `path`, `link`, `type`, `published`, `parent_id`, `level`, `component_id`, `browserNav`, `access`, `img`, `template_style_id`, `params`, `lft`, `rgt`, `home`, `language`, `client_id`, `publish_up`, `publish_down`) 514 SELECT 14, 'main', 'com_tags', 'Tags', '', 'Tags', 'index.php?option=com_tags&view=tags', 'component', 1, 1, 1, `extension_id`, 0, 1, 'class:tags', 0, '', 39, 40, 0, '', 1, NULL, NULL FROM `#__extensions` WHERE `name` = 'com_tags'; 515 INSERT INTO `#__menu` (`id`, `menutype`, `title`, `alias`, `note`, `path`, `link`, `type`, `published`, `parent_id`, `level`, `component_id`, `browserNav`, `access`, `img`, `template_style_id`, `params`, `lft`, `rgt`, `home`, `language`, `client_id`, `publish_up`, `publish_down`) 516 SELECT 15, 'main', 'com_associations', 'Multilingual Associations', '', 'Multilingual Associations', 'index.php?option=com_associations&view=associations', 'component', 1, 1, 1, `extension_id`, 0, 0, 'class:language', 0, '', 21, 22, 0, '*', 1, NULL, NULL FROM `#__extensions` WHERE `name` = 'com_associations'; 517 INSERT INTO `#__menu` (`id`, `menutype`, `title`, `alias`, `note`, `path`, `link`, `type`, `published`, `parent_id`, `level`, `component_id`, `browserNav`, `access`, `img`, `template_style_id`, `params`, `lft`, `rgt`, `home`, `language`, `client_id`, `publish_up`, `publish_down`) 518 SELECT 16, 'main', 'mod_menu_fields', 'Contact Custom Fields', '', 'contact/Custom Fields', 'index.php?option=com_fields&context=com_contact.contact', 'component', 1, 7, 2, `extension_id`, 0, 0, 'class:messages-add', 0, '', 16, 17, 0, '*', 1, NULL, NULL FROM `#__extensions` WHERE `name` = 'com_fields'; 519 INSERT INTO `#__menu` (`id`, `menutype`, `title`, `alias`, `note`, `path`, `link`, `type`, `published`, `parent_id`, `level`, `component_id`, `browserNav`, `access`, `img`, `template_style_id`, `params`, `lft`, `rgt`, `home`, `language`, `client_id`, `publish_up`, `publish_down`) 520 SELECT 17, 'main', 'mod_menu_fields_group', 'Contact Custom Fields Group', '', 'contact/Custom Fields Group', 'index.php?option=com_fields&view=groups&context=com_contact.contact', 'component', 1, 7, 2, `extension_id`, 0, 0, 'class:messages-add', 0, '', 18, 19, 0, '*', 1, NULL, NULL FROM `#__extensions` WHERE `name` = 'com_fields'; 521 INSERT INTO `#__menu` (`id`, `menutype`, `title`, `alias`, `note`, `path`, `link`, `type`, `published`, `parent_id`, `level`, `component_id`, `browserNav`, `access`, `img`, `template_style_id`, `params`, `lft`, `rgt`, `home`, `language`, `client_id`, `publish_up`, `publish_down`) 522 SELECT 18, 'main', 'com_finder_index', 'Smart-Search-Index', '', 'Smart Search/Index', 'index.php?option=com_finder&view=index', 'component', 1, 13, 2, `extension_id`, 0, 0, 'class:finder', 0, '', 30, 31, 0, '*', 1, NULL, NULL FROM `#__extensions` WHERE `name` = 'com_finder'; 523 INSERT INTO `#__menu` (`id`, `menutype`, `title`, `alias`, `note`, `path`, `link`, `type`, `published`, `parent_id`, `level`, `component_id`, `browserNav`, `access`, `img`, `template_style_id`, `params`, `lft`, `rgt`, `home`, `language`, `client_id`, `publish_up`, `publish_down`) 524 SELECT 19, 'main', 'com_finder_maps', 'Smart-Search-Maps', '', 'Smart Search/Maps', 'index.php?option=com_finder&view=maps', 'component', 1, 13, 2, `extension_id`, 0, 0, 'class:finder-maps', 0, '', 32, 33, 0, '*', 1, NULL, NULL FROM `#__extensions` WHERE `name` = 'com_finder'; 525 INSERT INTO `#__menu` (`id`, `menutype`, `title`, `alias`, `note`, `path`, `link`, `type`, `published`, `parent_id`, `level`, `component_id`, `browserNav`, `access`, `img`, `template_style_id`, `params`, `lft`, `rgt`, `home`, `language`, `client_id`, `publish_up`, `publish_down`) 526 SELECT 20, 'main', 'com_finder_filters', 'Smart-Search-Filters', '', 'Smart Search/Filters', 'index.php?option=com_finder&view=filters', 'component', 1, 13, 2, `extension_id`, 0, 0, 'class:finder-filters', 0, '', 34, 35, 0, '*', 1, NULL, NULL FROM `#__extensions` WHERE `name` = 'com_finder'; 527 INSERT INTO `#__menu` (`id`, `menutype`, `title`, `alias`, `note`, `path`, `link`, `type`, `published`, `parent_id`, `level`, `component_id`, `browserNav`, `access`, `img`, `template_style_id`, `params`, `lft`, `rgt`, `home`, `language`, `client_id`, `publish_up`, `publish_down`) 528 SELECT 21, 'main', 'com_finder_searches', 'Smart-Search-Searches', '', 'Smart Search/Searches', 'index.php?option=com_finder&view=searches', 'component', 1, 13, 2, `extension_id`, 0, 0, 'class:finder-searches', 0, '', 36, 37, 0, '*', 1, NULL, NULL FROM `#__extensions` WHERE `name` = 'com_finder'; 529 INSERT INTO `#__menu` (`id`, `menutype`, `title`, `alias`, `note`, `path`, `link`, `type`, `published`, `parent_id`, `level`, `component_id`, `browserNav`, `access`, `img`, `template_style_id`, `params`, `lft`, `rgt`, `home`, `language`, `client_id`, `publish_up`, `publish_down`) 530 SELECT 101, 'mainmenu', 'Home', 'home', '', 'home', 'index.php?option=com_content&view=featured', 'component', 1, 1, 1, `extension_id`, 0, 1, '', 0, '{"featured_categories":[""],"layout_type":"blog","blog_class_leading":"","blog_class":"","num_leading_articles":"1","num_intro_articles":"3","num_links":"0","link_intro_image":"","orderby_pri":"","orderby_sec":"front","order_date":"","show_pagination":"2","show_pagination_results":"1","show_title":"","link_titles":"","show_intro":"","info_block_position":"","info_block_show_title":"","show_category":"","link_category":"","show_parent_category":"","link_parent_category":"","show_associations":"","show_author":"","link_author":"","show_create_date":"","show_modify_date":"","show_publish_date":"","show_item_navigation":"","show_vote":"","show_readmore":"","show_readmore_title":"","show_hits":"","show_tags":"","show_noauth":"","show_feed_link":"1","feed_summary":"","menu-anchor_title":"","menu-anchor_css":"","menu_image":"","menu_image_css":"","menu_text":1,"menu_show":1,"page_title":"","show_page_heading":"1","page_heading":"","pageclass_sfx":"","menu-meta_description":"","robots":""}', 41, 42, 1, '*', 0, NULL, NULL FROM `#__extensions` WHERE `name` = 'com_content'; 531 532 -- -------------------------------------------------------- 533 534 -- 535 -- Table structure for table `#__menu_types` 536 -- 537 538 CREATE TABLE IF NOT EXISTS `#__menu_types` ( 539 `id` int unsigned NOT NULL AUTO_INCREMENT, 540 `asset_id` int unsigned NOT NULL DEFAULT 0, 541 `menutype` varchar(24) NOT NULL, 542 `title` varchar(48) NOT NULL, 543 `description` varchar(255) NOT NULL DEFAULT '', 544 `client_id` int NOT NULL DEFAULT 0, 545 PRIMARY KEY (`id`), 546 UNIQUE KEY `idx_menutype` (`menutype`) 547 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci; 548 549 -- 550 -- Dumping data for table `#__menu_types` 551 -- 552 553 INSERT IGNORE INTO `#__menu_types` (`id`, `asset_id`, `menutype`, `title`, `description`, `client_id`) VALUES 554 (1, 0, 'mainmenu', 'Main Menu', 'The main menu for the site', 0); 555 556 -- -------------------------------------------------------- 557 558 -- 559 -- Table structure for table `#__modules` 560 -- 561 562 CREATE TABLE IF NOT EXISTS `#__modules` ( 563 `id` int NOT NULL AUTO_INCREMENT, 564 `asset_id` int unsigned NOT NULL DEFAULT 0 COMMENT 'FK to the #__assets table.', 565 `title` varchar(100) NOT NULL DEFAULT '', 566 `note` varchar(255) NOT NULL DEFAULT '', 567 `content` text, 568 `ordering` int NOT NULL DEFAULT 0, 569 `position` varchar(50) NOT NULL DEFAULT '', 570 `checked_out` int unsigned, 571 `checked_out_time` datetime, 572 `publish_up` datetime, 573 `publish_down` datetime, 574 `published` tinyint NOT NULL DEFAULT 0, 575 `module` varchar(50) DEFAULT NULL, 576 `access` int unsigned NOT NULL DEFAULT 0, 577 `showtitle` tinyint unsigned NOT NULL DEFAULT 1, 578 `params` text NOT NULL, 579 `client_id` tinyint NOT NULL DEFAULT 0, 580 `language` char(7) NOT NULL, 581 PRIMARY KEY (`id`), 582 KEY `published` (`published`,`access`), 583 KEY `newsfeeds` (`module`,`published`), 584 KEY `idx_language` (`language`) 585 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=87; 586 587 -- 588 -- Dumping data for table `#__modules` 589 -- 590 591 INSERT INTO `#__modules` (`id`, `asset_id`, `title`, `note`, `content`, `ordering`, `position`, `publish_up`, `publish_down`, `published`, `module`, `access`, `showtitle`, `params`, `client_id`, `language`) VALUES 592 (1, 39, 'Main Menu', '', '', 1, 'sidebar-right', NULL, NULL, 1, 'mod_menu', 1, 1, '{"menutype":"mainmenu","startLevel":"0","endLevel":"0","showAllChildren":"1","tag_id":"","class_sfx":"","window_open":"","layout":"_:default","moduleclass_sfx":"","cache":"1","cache_time":"900","cachemode":"itemid"}', 0, '*'), 593 (2, 40, 'Login', '', '', 1, 'login', NULL, NULL, 1, 'mod_login', 1, 1, '', 1, '*'), 594 (3, 41, 'Popular Articles', '', '', 3, 'cpanel', NULL, NULL, 1, 'mod_popular', 3, 1, '{"count":"5","catid":"","user_id":"0","layout":"_:default","moduleclass_sfx":"","cache":"0", "bootstrap_size": "12","header_tag":"h2"}', 1, '*'), 595 (4, 42, 'Recently Added Articles', '', '', 4, 'cpanel', NULL, NULL, 1, 'mod_latest', 3, 1, '{"count":"5","ordering":"c_dsc","catid":"","user_id":"0","layout":"_:default","moduleclass_sfx":"","cache":"0", "bootstrap_size": "12","header_tag":"h2"}', 1, '*'), 596 (8, 43, 'Toolbar', '', '', 1, 'toolbar', NULL, NULL, 1, 'mod_toolbar', 3, 1, '', 1, '*'), 597 (9, 44, 'Notifications', '', '', 3, 'icon', NULL, NULL, 1, 'mod_quickicon', 3, 1, '{"context":"update_quickicon","header_icon":"icon-sync","show_jupdate":"1","show_eupdate":"1","show_oupdate":"1","show_privacy":"1","layout":"_:default","moduleclass_sfx":"","cache":1,"cache_time":900,"style":"0","module_tag":"div","bootstrap_size":"12","header_tag":"h2","header_class":""}', 1, '*'), 598 (10, 45, 'Logged-in Users', '', '', 2, 'cpanel', NULL, NULL, 1, 'mod_logged', 3, 1, '{"count":"5","name":"1","layout":"_:default","moduleclass_sfx":"","cache":"0", "bootstrap_size": "12","header_tag":"h2"}', 1, '*'), 599 (12, 46, 'Admin Menu', '', '', 1, 'menu', NULL, NULL, 1, 'mod_menu', 3, 1, '{"layout":"","moduleclass_sfx":"","shownew":"1","showhelp":"1","cache":"0"}', 1, '*'), 600 (15, 49, 'Title', '', '', 1, 'title', NULL, NULL, 1, 'mod_title', 3, 1, '', 1, '*'), 601 (16, 50, 'Login Form', '', '', 7, 'sidebar-right', NULL, NULL, 1, 'mod_login', 1, 1, '{"greeting":"1","name":"0"}', 0, '*'), 602 (17, 51, 'Breadcrumbs', '', '', 1, 'breadcrumbs', NULL, NULL, 1, 'mod_breadcrumbs', 1, 1, '{"moduleclass_sfx":"","showHome":"1","homeText":"","showComponent":"1","separator":"","cache":"0","cache_time":"0","cachemode":"itemid"}', 0, '*'), 603 (79, 52, 'Multilanguage status', '', '', 2, 'status', NULL, NULL, 1, 'mod_multilangstatus', 3, 1, '{"layout":"_:default","moduleclass_sfx":"","cache":"0"}', 1, '*'), 604 (86, 53, 'Joomla Version', '', '', 1, 'status', NULL, NULL, 1, 'mod_version', 3, 1, '{"layout":"_:default","moduleclass_sfx":"","cache":"0"}', 1, '*'), 605 (87, 55, 'Sample Data', '', '', 0, 'cpanel', NULL, NULL, 1, 'mod_sampledata', 6, 1, '{"bootstrap_size": "12","header_tag":"h2"}', 1, '*'), 606 (88, 67, 'Latest Actions', '', '', 0, 'cpanel', NULL, NULL, 1, 'mod_latestactions', 6, 1, '{"bootstrap_size": "12","header_tag":"h2"}', 1, '*'), 607 (89, 68, 'Privacy Dashboard', '', '', 0, 'cpanel', NULL, NULL, 1, 'mod_privacy_dashboard', 6, 1, '{"bootstrap_size": "12","header_tag":"h2"}', 1, '*'), 608 (90, 89, 'Login Support', '', '', 1, 'sidebar', NULL, NULL, 1, 'mod_loginsupport', 1, 1, '{"forum_url":"https://forum.joomla.org/","documentation_url":"https://docs.joomla.org/","news_url":"https://www.joomla.org/announcements.html","automatic_title":1,"prepare_content":1,"layout":"_:default","moduleclass_sfx":"","cache":1,"cache_time":900,"module_tag":"div","bootstrap_size":"0","header_tag":"h3","header_class":"","style":"0"}', 1, '*'), 609 (91, 72, 'System Dashboard', '', '', 1, 'cpanel-system', NULL, NULL, 1, 'mod_submenu', 1, 0, '{"menutype":"*","preset":"system","layout":"_:default","moduleclass_sfx":"","module_tag":"div","bootstrap_size":"12","header_tag":"h2","header_class":"","style":"System-none"}', 1, '*'), 610 (92, 73, 'Content Dashboard', '', '', 1, 'cpanel-content', NULL, NULL, 1, 'mod_submenu', 1, 0, '{"menutype":"*","preset":"content","layout":"_:default","moduleclass_sfx":"","module_tag":"div","bootstrap_size":"12","header_tag":"h2","header_class":"","style":"System-none"}', 1, '*'), 611 (93, 74, 'Menus Dashboard', '', '', 1, 'cpanel-menus', NULL, NULL, 1, 'mod_submenu', 1, 0, '{"menutype":"*","preset":"menus","layout":"_:default","moduleclass_sfx":"","module_tag":"div","bootstrap_size":"12","header_tag":"h2","header_class":"","style":"System-none"}', 1, '*'), 612 (94, 75, 'Components Dashboard', '', '', 1, 'cpanel-components', NULL, NULL, 1, 'mod_submenu', 1, 0, '{"menutype":"*","preset":"components","layout":"_:default","moduleclass_sfx":"","module_tag":"div","bootstrap_size":"12","header_tag":"h2","header_class":"","style":"System-none"}', 1, '*'), 613 (95, 76, 'Users Dashboard', '', '', 1, 'cpanel-users', NULL, NULL, 1, 'mod_submenu', 1, 0, '{"menutype":"*","preset":"users","layout":"_:default","moduleclass_sfx":"","module_tag":"div","bootstrap_size":"12","header_tag":"h2","header_class":"","style":"System-none"}', 1, '*'), 614 (96, 86, 'Popular Articles', '', '', 3, 'cpanel-content', NULL, NULL, 1, 'mod_popular', 3, 1, '{"count":"5","catid":"","user_id":"0","layout":"_:default","moduleclass_sfx":"","cache":"0", "bootstrap_size": "12","header_tag":"h2"}', 1, '*'), 615 (97, 87, 'Recently Added Articles', '', '', 4, 'cpanel-content', NULL, NULL, 1, 'mod_latest', 3, 1, '{"count":"5","ordering":"c_dsc","catid":"","user_id":"0","layout":"_:default","moduleclass_sfx":"","cache":"0", "bootstrap_size": "12","header_tag":"h2"}', 1, '*'), 616 (98, 88, 'Logged-in Users', '', '', 2, 'cpanel-users', NULL, NULL, 1, 'mod_logged', 3, 1, '{"count":"5","name":"1","layout":"_:default","moduleclass_sfx":"","cache":"0", "bootstrap_size": "12","header_tag":"h2"}', 1, '*'), 617 (99, 77, 'Frontend Link', '', '', 5, 'status', NULL, NULL, 1, 'mod_frontend', 1, 1, '', 1, '*'), 618 (100, 78, 'Messages', '', '', 4, 'status', NULL, NULL, 1, 'mod_messages', 3, 1, '', 1, '*'), 619 (101, 79, 'Post Install Messages', '', '', 3, 'status', NULL, NULL, 1, 'mod_post_installation_messages', 3, 1, '', 1, '*'), 620 (102, 80, 'User Status', '', '', 6, 'status', NULL, NULL, 1, 'mod_user', 3, 1, '', 1, '*'), 621 (103, 70, 'Site', '', '', 1, 'icon', NULL, NULL, 1, 'mod_quickicon', 1, 1, '{"context":"site_quickicon","header_icon":"icon-desktop","show_users":"1","show_articles":"1","show_categories":"1","show_media":"1","show_menuItems":"1","show_modules":"1","show_plugins":"1","show_templates":"1","layout":"_:default","moduleclass_sfx":"","cache":1,"cache_time":900,"style":"0","module_tag":"div","bootstrap_size":"12","header_tag":"h2","header_class":""}', 1, '*'), 622 (104, 71, 'System', '', '', 2, 'icon', NULL, NULL, 1, 'mod_quickicon', 1, 1, '{"context":"system_quickicon","header_icon":"icon-wrench","show_global":"1","show_checkin":"1","show_cache":"1","layout":"_:default","moduleclass_sfx":"","cache":1,"cache_time":900,"style":"0","module_tag":"div","bootstrap_size":"12","header_tag":"h2","header_class":""}', 1, '*'), 623 (105, 82, '3rd Party', '', '', 4, 'icon', NULL, NULL, 1, 'mod_quickicon', 1, 1, '{"context":"mod_quickicon","header_icon":"icon-boxes","load_plugins":"1","layout":"_:default","moduleclass_sfx":"","cache":1,"cache_time":900,"style":"0","module_tag":"div","bootstrap_size":"12","header_tag":"h2","header_class":""}', 1, '*'), 624 (106, 83, 'Help Dashboard', '', '', 1, 'cpanel-help', NULL, NULL, 1, 'mod_submenu', 1, 0, '{"menutype":"*","preset":"help","layout":"_:default","moduleclass_sfx":"","style":"System-none","module_tag":"div","bootstrap_size":"12","header_tag":"h2","header_class":""}', 1, '*'), 625 (107, 84, 'Privacy Requests', '', '', 1, 'cpanel-privacy', NULL, NULL, 1, 'mod_privacy_dashboard', 1, 1, '{"layout":"_:default","moduleclass_sfx":"","cache":1,"cache_time":900,"cachemode":"static","style":"0","module_tag":"div","bootstrap_size":"12","header_tag":"h2","header_class":""}', 1, '*'), 626 (108, 85, 'Privacy Status', '', '', 1, 'cpanel-privacy', NULL, NULL, 1, 'mod_privacy_status', 1, 1, '{"layout":"_:default","moduleclass_sfx":"","cache":1,"cache_time":900,"cachemode":"static","style":"0","module_tag":"div","bootstrap_size":"12","header_tag":"h2","header_class":""}', 1, '*'); 627 628 -- -------------------------------------------------------- 629 630 -- 631 -- Table structure for table `#__modules_menu` 632 -- 633 634 CREATE TABLE IF NOT EXISTS `#__modules_menu` ( 635 `moduleid` int NOT NULL DEFAULT 0, 636 `menuid` int NOT NULL DEFAULT 0, 637 PRIMARY KEY (`moduleid`,`menuid`) 638 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci; 639 640 -- 641 -- Dumping data for table `#__modules_menu` 642 -- 643 644 INSERT INTO `#__modules_menu` (`moduleid`, `menuid`) VALUES 645 (1, 0), 646 (2, 0), 647 (3, 0), 648 (4, 0), 649 (6, 0), 650 (7, 0), 651 (8, 0), 652 (9, 0), 653 (10, 0), 654 (12, 0), 655 (14, 0), 656 (15, 0), 657 (16, 0), 658 (17, 0), 659 (79, 0), 660 (86, 0), 661 (87, 0), 662 (88, 0), 663 (89, 0), 664 (90, 0), 665 (91, 0), 666 (92, 0), 667 (93, 0), 668 (94, 0), 669 (95, 0), 670 (96, 0), 671 (97, 0), 672 (98, 0), 673 (99, 0), 674 (100, 0), 675 (101, 0), 676 (102, 0), 677 (103, 0), 678 (104, 0), 679 (105, 0), 680 (106, 0), 681 (107, 0), 682 (108, 0); 683 684 -- -------------------------------------------------------- 685 686 -- 687 -- Table structure for table `#__schemas` 688 -- 689 690 CREATE TABLE IF NOT EXISTS `#__schemas` ( 691 `extension_id` int NOT NULL, 692 `version_id` varchar(20) NOT NULL, 693 PRIMARY KEY (`extension_id`,`version_id`) 694 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci; 695 696 -- -------------------------------------------------------- 697 698 -- 699 -- Table structure for table `#__session` 700 -- 701 702 CREATE TABLE IF NOT EXISTS `#__session` ( 703 `session_id` varbinary(192) NOT NULL, 704 `client_id` tinyint unsigned DEFAULT NULL, 705 `guest` tinyint unsigned DEFAULT 1, 706 `time` int NOT NULL DEFAULT 0, 707 `data` mediumtext, 708 `userid` int DEFAULT 0, 709 `username` varchar(150) DEFAULT '', 710 PRIMARY KEY (`session_id`), 711 KEY `userid` (`userid`), 712 KEY `time` (`time`), 713 KEY `client_id_guest` (`client_id`, `guest`) 714 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci; 715 716 -- -------------------------------------------------------- 717 718 -- 719 -- Table structure for table `#__tags` 720 -- 721 722 CREATE TABLE IF NOT EXISTS `#__tags` ( 723 `id` int unsigned NOT NULL AUTO_INCREMENT, 724 `parent_id` int unsigned NOT NULL DEFAULT 0, 725 `lft` int NOT NULL DEFAULT 0, 726 `rgt` int NOT NULL DEFAULT 0, 727 `level` int unsigned NOT NULL DEFAULT 0, 728 `path` varchar(400) NOT NULL DEFAULT '', 729 `title` varchar(255) NOT NULL, 730 `alias` varchar(400) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '', 731 `note` varchar(255) NOT NULL DEFAULT '', 732 `description` mediumtext NOT NULL, 733 `published` tinyint NOT NULL DEFAULT 0, 734 `checked_out` int unsigned, 735 `checked_out_time` datetime, 736 `access` int unsigned NOT NULL DEFAULT 0, 737 `params` text NOT NULL, 738 `metadesc` varchar(1024) NOT NULL COMMENT 'The meta description for the page.', 739 `metakey` varchar(1024) NOT NULL DEFAULT '' COMMENT 'The keywords for the page.', 740 `metadata` varchar(2048) NOT NULL COMMENT 'JSON encoded metadata properties.', 741 `created_user_id` int unsigned NOT NULL DEFAULT 0, 742 `created_time` datetime NOT NULL, 743 `created_by_alias` varchar(255) NOT NULL DEFAULT '', 744 `modified_user_id` int unsigned NOT NULL DEFAULT 0, 745 `modified_time` datetime NOT NULL, 746 `images` text NOT NULL, 747 `urls` text NOT NULL, 748 `hits` int unsigned NOT NULL DEFAULT 0, 749 `language` char(7) NOT NULL, 750 `version` int unsigned NOT NULL DEFAULT 1, 751 `publish_up` datetime, 752 `publish_down` datetime, 753 PRIMARY KEY (`id`), 754 KEY `tag_idx` (`published`,`access`), 755 KEY `idx_access` (`access`), 756 KEY `idx_checkout` (`checked_out`), 757 KEY `idx_path` (`path`(100)), 758 KEY `idx_left_right` (`lft`,`rgt`), 759 KEY `idx_alias` (`alias`(100)), 760 KEY `idx_language` (`language`) 761 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci; 762 763 -- 764 -- Dumping data for table `#__tags` 765 -- 766 767 INSERT INTO `#__tags` (`id`, `parent_id`, `lft`, `rgt`, `level`, `path`, `title`, `alias`, `note`, `description`, `published`, `access`, `params`, `metadesc`, `metakey`, `metadata`, `created_user_id`, `created_time`, `created_by_alias`, `modified_user_id`, `modified_time`, `images`, `urls`, `hits`, `language`, `version`) VALUES 768 (1, 0, 0, 1, 0, '', 'ROOT', 'root', '', '', 1, 1, '', '', '', '', 42, CURRENT_TIMESTAMP(), '', 42, CURRENT_TIMESTAMP(), '', '', 0, '*', 1); 769 770 -- -------------------------------------------------------- 771 772 -- 773 -- Table structure for table `#__template_overrides` 774 -- 775 776 CREATE TABLE IF NOT EXISTS `#__template_overrides` ( 777 `id` int unsigned NOT NULL AUTO_INCREMENT, 778 `template` varchar(50) NOT NULL DEFAULT '', 779 `hash_id` varchar(255) NOT NULL DEFAULT '', 780 `extension_id` int DEFAULT 0, 781 `state` tinyint NOT NULL DEFAULT 0, 782 `action` varchar(50) NOT NULL DEFAULT '', 783 `client_id` tinyint unsigned NOT NULL DEFAULT 0, 784 `created_date` datetime NOT NULL, 785 `modified_date` datetime, 786 PRIMARY KEY (`id`), 787 KEY `idx_template` (`template`), 788 KEY `idx_extension_id` (`extension_id`) 789 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci; 790 791 -- -------------------------------------------------------- 792 793 -- 794 -- Table structure for table `#__template_styles` 795 -- 796 797 CREATE TABLE IF NOT EXISTS `#__template_styles` ( 798 `id` int unsigned NOT NULL AUTO_INCREMENT, 799 `template` varchar(50) NOT NULL DEFAULT '', 800 `client_id` tinyint unsigned NOT NULL DEFAULT 0, 801 `home` char(7) NOT NULL DEFAULT '0', 802 `title` varchar(255) NOT NULL DEFAULT '', 803 `inheritable` tinyint NOT NULL DEFAULT 0, 804 `parent` varchar(50) DEFAULT '', 805 `params` text NOT NULL, 806 PRIMARY KEY (`id`), 807 KEY `idx_template` (`template`), 808 KEY `idx_client_id` (`client_id`), 809 KEY `idx_client_id_home` (`client_id`,`home`) 810 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=9; 811 812 -- 813 -- Dumping data for table `#__template_styles` 814 -- 815 816 INSERT INTO `#__template_styles` (`id`, `template`, `client_id`, `home`, `title`, `inheritable`, `parent`, `params`) VALUES 817 (10, 'atum', 1, '1', 'Atum - Default', 1, '', '{"hue":"hsl(214, 63%, 20%)","bg-light":"#f0f4fb","text-dark":"#495057","text-light":"#ffffff","link-color":"#2a69b8","special-color":"#001b4c","monochrome":"0","loginLogo":"","loginLogoAlt":"","logoBrandLarge":"","logoBrandLargeAlt":"","logoBrandSmall":"","logoBrandSmallAlt":""}'), 818 (11, 'cassiopeia', 0, '1', 'Cassiopeia - Default', 1, '', '{"brand":"1","logoFile":"","siteTitle":"","siteDescription":"","useFontScheme":"0","colorName":"colors_standard","fluidContainer":"0","stickyHeader":0,"backTop":0}'); 819 820 -- -------------------------------------------------------- 821 822 -- 823 -- Table structure for table `#__updates` 824 -- 825 826 CREATE TABLE IF NOT EXISTS `#__updates` ( 827 `update_id` int NOT NULL AUTO_INCREMENT, 828 `update_site_id` int DEFAULT 0, 829 `extension_id` int DEFAULT 0, 830 `name` varchar(100) DEFAULT '', 831 `description` text NOT NULL, 832 `element` varchar(100) DEFAULT '', 833 `type` varchar(20) DEFAULT '', 834 `folder` varchar(20) DEFAULT '', 835 `client_id` tinyint DEFAULT 0, 836 `version` varchar(32) DEFAULT '', 837 `data` text NOT NULL, 838 `detailsurl` text NOT NULL, 839 `infourl` text NOT NULL, 840 `changelogurl` text, 841 `extra_query` varchar(1000) DEFAULT '', 842 PRIMARY KEY (`update_id`) 843 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci COMMENT='Available Updates'; 844 845 -- -------------------------------------------------------- 846 847 -- 848 -- Table structure for table `#__update_sites` 849 -- 850 851 CREATE TABLE IF NOT EXISTS `#__update_sites` ( 852 `update_site_id` int NOT NULL AUTO_INCREMENT, 853 `name` varchar(100) DEFAULT '', 854 `type` varchar(20) DEFAULT '', 855 `location` text NOT NULL, 856 `enabled` int DEFAULT 0, 857 `last_check_timestamp` bigint DEFAULT 0, 858 `extra_query` varchar(1000) DEFAULT '', 859 `checked_out` int unsigned, 860 `checked_out_time` datetime NULL DEFAULT NULL, 861 PRIMARY KEY (`update_site_id`) 862 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci COMMENT='Update Sites'; 863 864 -- 865 -- Dumping data for table `#__update_sites` 866 -- 867 868 INSERT INTO `#__update_sites` (`update_site_id`, `name`, `type`, `location`, `enabled`, `last_check_timestamp`) VALUES 869 (1, 'Joomla! Core', 'collection', 'https://update.joomla.org/core/list.xml', 1, 0), 870 (2, 'Accredited Joomla! Translations', 'collection', 'https://update.joomla.org/language/translationlist_4.xml', 1, 0), 871 (3, 'Joomla! Update Component', 'extension', 'https://update.joomla.org/core/extensions/com_joomlaupdate.xml', 1, 0); 872 873 -- -------------------------------------------------------- 874 875 -- 876 -- Table structure for table `#__update_sites_extensions` 877 -- 878 879 CREATE TABLE IF NOT EXISTS `#__update_sites_extensions` ( 880 `update_site_id` int NOT NULL DEFAULT 0, 881 `extension_id` int NOT NULL DEFAULT 0, 882 PRIMARY KEY (`update_site_id`,`extension_id`) 883 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci COMMENT='Links extensions to update sites'; 884 885 -- 886 -- Dumping data for table `#__update_sites_extensions` 887 -- 888 889 INSERT INTO `#__update_sites_extensions` (`update_site_id`, `extension_id`) 890 SELECT 1, `extension_id` FROM `#__extensions` WHERE `name` = 'files_joomla'; 891 INSERT INTO `#__update_sites_extensions` (`update_site_id`, `extension_id`) 892 SELECT 2, `extension_id` FROM `#__extensions` WHERE `name` = 'English (en-GB) Language Pack'; 893 INSERT INTO `#__update_sites_extensions` (`update_site_id`, `extension_id`) 894 SELECT 3, `extension_id` FROM `#__extensions` WHERE `name` = 'com_joomlaupdate'; 895 896 -- -------------------------------------------------------- 897 898 -- 899 -- Table structure for table `#__usergroups` 900 -- 901 902 CREATE TABLE IF NOT EXISTS `#__usergroups` ( 903 `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Primary Key', 904 `parent_id` int unsigned NOT NULL DEFAULT 0 COMMENT 'Adjacency List Reference Id', 905 `lft` int NOT NULL DEFAULT 0 COMMENT 'Nested set lft.', 906 `rgt` int NOT NULL DEFAULT 0 COMMENT 'Nested set rgt.', 907 `title` varchar(100) NOT NULL DEFAULT '', 908 PRIMARY KEY (`id`), 909 UNIQUE KEY `idx_usergroup_parent_title_lookup` (`parent_id`,`title`), 910 KEY `idx_usergroup_title_lookup` (`title`), 911 KEY `idx_usergroup_adjacency_lookup` (`parent_id`), 912 KEY `idx_usergroup_nested_set_lookup` (`lft`,`rgt`) USING BTREE 913 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci; 914 915 -- 916 -- Dumping data for table `#__usergroups` 917 -- 918 919 INSERT INTO `#__usergroups` (`id`, `parent_id`, `lft`, `rgt`, `title`) VALUES 920 (1, 0, 1, 18, 'Public'), 921 (2, 1, 8, 15, 'Registered'), 922 (3, 2, 9, 14, 'Author'), 923 (4, 3, 10, 13, 'Editor'), 924 (5, 4, 11, 12, 'Publisher'), 925 (6, 1, 4, 7, 'Manager'), 926 (7, 6, 5, 6, 'Administrator'), 927 (8, 1, 16, 17, 'Super Users'), 928 (9, 1, 2, 3, 'Guest'); 929 930 -- -------------------------------------------------------- 931 932 -- 933 -- Table structure for table `#__users` 934 -- 935 936 CREATE TABLE IF NOT EXISTS `#__users` ( 937 `id` int NOT NULL AUTO_INCREMENT, 938 `name` varchar(400) NOT NULL DEFAULT '', 939 `username` varchar(150) NOT NULL DEFAULT '', 940 `email` varchar(100) NOT NULL DEFAULT '', 941 `password` varchar(100) NOT NULL DEFAULT '', 942 `block` tinyint NOT NULL DEFAULT 0, 943 `sendEmail` tinyint DEFAULT 0, 944 `registerDate` datetime NOT NULL, 945 `lastvisitDate` datetime, 946 `activation` varchar(100) NOT NULL DEFAULT '', 947 `params` text NOT NULL, 948 `lastResetTime` datetime COMMENT 'Date of last password reset', 949 `resetCount` int NOT NULL DEFAULT 0 COMMENT 'Count of password resets since lastResetTime', 950 `otpKey` varchar(1000) NOT NULL DEFAULT '' COMMENT 'Two factor authentication encrypted keys', 951 `otep` varchar(1000) NOT NULL DEFAULT '' COMMENT 'Backup Codes', 952 `requireReset` tinyint NOT NULL DEFAULT 0 COMMENT 'Require user to reset password on next login', 953 `authProvider` varchar(100) NOT NULL DEFAULT '' COMMENT 'Name of used authentication plugin', 954 PRIMARY KEY (`id`), 955 KEY `idx_name` (`name`(100)), 956 KEY `idx_block` (`block`), 957 UNIQUE KEY `idx_username` (`username`), 958 KEY `email` (`email`) 959 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci; 960 961 -- -------------------------------------------------------- 962 963 -- 964 -- Table structure for table `#__user_keys` 965 -- 966 967 CREATE TABLE IF NOT EXISTS `#__user_keys` ( 968 `id` int unsigned NOT NULL AUTO_INCREMENT, 969 `user_id` varchar(150) NOT NULL, 970 `token` varchar(255) NOT NULL, 971 `series` varchar(191) NOT NULL, 972 `time` varchar(200) NOT NULL, 973 `uastring` varchar(255) NOT NULL, 974 PRIMARY KEY (`id`), 975 UNIQUE KEY `series` (`series`), 976 KEY `user_id` (`user_id`) 977 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci; 978 979 -- -------------------------------------------------------- 980 981 -- 982 -- Table structure for table `#__user_notes` 983 -- 984 985 CREATE TABLE IF NOT EXISTS `#__user_notes` ( 986 `id` int unsigned NOT NULL AUTO_INCREMENT, 987 `user_id` int unsigned NOT NULL DEFAULT 0, 988 `catid` int unsigned NOT NULL DEFAULT 0, 989 `subject` varchar(100) NOT NULL DEFAULT '', 990 `body` text NOT NULL, 991 `state` tinyint NOT NULL DEFAULT 0, 992 `checked_out` int unsigned, 993 `checked_out_time` datetime, 994 `created_user_id` int unsigned NOT NULL DEFAULT 0, 995 `created_time` datetime NOT NULL, 996 `modified_user_id` int unsigned NOT NULL DEFAULT 0, 997 `modified_time` datetime NOT NULL, 998 `review_time` datetime, 999 `publish_up` datetime, 1000 `publish_down` datetime, 1001 PRIMARY KEY (`id`), 1002 KEY `idx_user_id` (`user_id`), 1003 KEY `idx_category_id` (`catid`) 1004 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci; 1005 1006 -- -------------------------------------------------------- 1007 1008 -- 1009 -- Table structure for table `#__user_profiles` 1010 -- 1011 1012 CREATE TABLE IF NOT EXISTS `#__user_profiles` ( 1013 `user_id` int NOT NULL, 1014 `profile_key` varchar(100) NOT NULL, 1015 `profile_value` text NOT NULL, 1016 `ordering` int NOT NULL DEFAULT 0, 1017 UNIQUE KEY `idx_user_id_profile_key` (`user_id`,`profile_key`) 1018 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci COMMENT='Simple user profile storage table'; 1019 1020 -- -------------------------------------------------------- 1021 1022 -- 1023 -- Table structure for table `#__user_mfa` 1024 -- 1025 1026 CREATE TABLE IF NOT EXISTS `#__user_mfa` ( 1027 `id` int NOT NULL AUTO_INCREMENT, 1028 `user_id` int unsigned NOT NULL, 1029 `title` varchar(255) NOT NULL DEFAULT '', 1030 `method` varchar(100) NOT NULL, 1031 `default` tinyint NOT NULL DEFAULT 0, 1032 `options` mediumtext NOT NULL, 1033 `created_on` datetime NOT NULL, 1034 `last_used` datetime, 1035 PRIMARY KEY (`id`), 1036 KEY `idx_user_id` (`user_id`) 1037 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci COMMENT='Multi-factor Authentication settings'; 1038 1039 -- -------------------------------------------------------- 1040 1041 -- 1042 -- Table structure for table `#__user_usergroup_map` 1043 -- 1044 1045 CREATE TABLE IF NOT EXISTS `#__user_usergroup_map` ( 1046 `user_id` int unsigned NOT NULL DEFAULT 0 COMMENT 'Foreign Key to #__users.id', 1047 `group_id` int unsigned NOT NULL DEFAULT 0 COMMENT 'Foreign Key to #__usergroups.id', 1048 PRIMARY KEY (`user_id`,`group_id`) 1049 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci; 1050 1051 -- -------------------------------------------------------- 1052 1053 -- 1054 -- Table structure for table `#__viewlevels` 1055 -- 1056 1057 CREATE TABLE IF NOT EXISTS `#__viewlevels` ( 1058 `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Primary Key', 1059 `title` varchar(100) NOT NULL DEFAULT '', 1060 `ordering` int NOT NULL DEFAULT 0, 1061 `rules` varchar(5120) NOT NULL COMMENT 'JSON encoded access control.', 1062 PRIMARY KEY (`id`), 1063 UNIQUE KEY `idx_assetgroup_title_lookup` (`title`) 1064 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=7; 1065 1066 -- 1067 -- Dumping data for table `#__viewlevels` 1068 -- 1069 1070 INSERT INTO `#__viewlevels` (`id`, `title`, `ordering`, `rules`) VALUES 1071 (1, 'Public', 0, '[1]'), 1072 (2, 'Registered', 2, '[6,2,8]'), 1073 (3, 'Special', 3, '[6,3,8]'), 1074 (5, 'Guest', 1, '[9]'), 1075 (6, 'Super Users', 4, '[8]'); 1076 1077 -- -------------------------------------------------------- 1078 1079 -- 1080 -- Table structure for table `#__workflows` 1081 -- 1082 1083 CREATE TABLE IF NOT EXISTS `#__workflows` ( 1084 `id` int NOT NULL AUTO_INCREMENT, 1085 `asset_id` int DEFAULT 0, 1086 `published` tinyint NOT NULL DEFAULT 0, 1087 `title` varchar(255) NOT NULL, 1088 `description` text NOT NULL, 1089 `extension` varchar(50) NOT NULL, 1090 `default` tinyint NOT NULL DEFAULT 0, 1091 `ordering` int NOT NULL DEFAULT 0, 1092 `created` datetime NOT NULL, 1093 `created_by` int NOT NULL DEFAULT 0, 1094 `modified` datetime NOT NULL, 1095 `modified_by` int NOT NULL DEFAULT 0, 1096 `checked_out_time` datetime, 1097 `checked_out` int unsigned, 1098 PRIMARY KEY (`id`), 1099 KEY `idx_asset_id` (`asset_id`), 1100 KEY `idx_title` (`title`(191)), 1101 KEY `idx_extension` (`extension`), 1102 KEY `idx_default` (`default`), 1103 KEY `idx_created` (`created`), 1104 KEY `idx_created_by` (`created_by`), 1105 KEY `idx_modified` (`modified`), 1106 KEY `idx_modified_by` (`modified_by`), 1107 KEY `idx_checked_out` (`checked_out`) 1108 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci; 1109 1110 -- 1111 -- Dumping data for table `#__workflows` 1112 -- 1113 1114 INSERT INTO `#__workflows` (`id`, `asset_id`, `published`, `title`, `description`, `extension`, `default`, `ordering`, `created`, `created_by`, `modified`, `modified_by`) VALUES 1115 (1, 56, 1, 'COM_WORKFLOW_BASIC_WORKFLOW', '', 'com_content.article', 1, 1, CURRENT_TIMESTAMP(), 42, CURRENT_TIMESTAMP(), 42); 1116 1117 -- -------------------------------------------------------- 1118 1119 -- 1120 -- Table structure for table `#__workflow_associations` 1121 -- 1122 1123 CREATE TABLE IF NOT EXISTS `#__workflow_associations` ( 1124 `item_id` int NOT NULL DEFAULT 0 COMMENT 'Extension table id value', 1125 `stage_id` int NOT NULL COMMENT 'Foreign Key to #__workflow_stages.id', 1126 `extension` varchar(50) NOT NULL, 1127 PRIMARY KEY (`item_id`, `extension`), 1128 KEY `idx_item_stage_extension` (`item_id`, `stage_id`, `extension`), 1129 KEY `idx_item_id` (`item_id`), 1130 KEY `idx_stage_id` (`stage_id`), 1131 KEY `idx_extension` (`extension`) 1132 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci; 1133 1134 -- -------------------------------------------------------- 1135 1136 -- 1137 -- Table structure for table `#__workflow_stages` 1138 -- 1139 1140 CREATE TABLE IF NOT EXISTS `#__workflow_stages` ( 1141 `id` int NOT NULL AUTO_INCREMENT, 1142 `asset_id` int DEFAULT 0, 1143 `ordering` int NOT NULL DEFAULT 0, 1144 `workflow_id` int NOT NULL, 1145 `published` tinyint NOT NULL DEFAULT 0, 1146 `title` varchar(255) NOT NULL, 1147 `description` text NOT NULL, 1148 `default` tinyint NOT NULL DEFAULT 0, 1149 `checked_out_time` datetime, 1150 `checked_out` int unsigned, 1151 PRIMARY KEY (`id`), 1152 KEY `idx_workflow_id` (`workflow_id`), 1153 KEY `idx_checked_out` (`checked_out`), 1154 KEY `idx_title` (`title`(191)), 1155 KEY `idx_asset_id` (`asset_id`), 1156 KEY `idx_default` (`default`) 1157 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci; 1158 1159 -- 1160 -- Dumping data for table `#__workflow_stages` 1161 -- 1162 1163 INSERT INTO `#__workflow_stages` (`id`, `asset_id`, `ordering`, `workflow_id`, `published`, `title`, `description`, `default`) VALUES 1164 (1, 57, 1, 1, 1, 'COM_WORKFLOW_BASIC_STAGE', '', 1); 1165 1166 -- -------------------------------------------------------- 1167 1168 -- 1169 -- Table structure for table `#__workflow_transitions` 1170 -- 1171 1172 CREATE TABLE IF NOT EXISTS `#__workflow_transitions` ( 1173 `id` int NOT NULL AUTO_INCREMENT, 1174 `asset_id` int DEFAULT 0, 1175 `ordering` int NOT NULL DEFAULT 0, 1176 `workflow_id` int NOT NULL, 1177 `published` tinyint NOT NULL DEFAULT 0, 1178 `title` varchar(255) NOT NULL, 1179 `description` text NOT NULL, 1180 `from_stage_id` int NOT NULL, 1181 `to_stage_id` int NOT NULL, 1182 `options` text NOT NULL, 1183 `checked_out_time` datetime, 1184 `checked_out` int unsigned, 1185 PRIMARY KEY (`id`), 1186 KEY `idx_title` (`title`(191)), 1187 KEY `idx_asset_id` (`asset_id`), 1188 KEY `idx_checked_out` (`checked_out`), 1189 KEY `idx_from_stage_id` (`from_stage_id`), 1190 KEY `idx_to_stage_id` (`to_stage_id`), 1191 KEY `idx_workflow_id` (`workflow_id`) 1192 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci; 1193 1194 -- 1195 -- Dumping data for table `#__workflow_transitions` 1196 -- 1197 1198 INSERT INTO `#__workflow_transitions` (`id`, `asset_id`, `published`, `ordering`, `workflow_id`, `title`, `description`, `from_stage_id`, `to_stage_id`, `options`) VALUES 1199 (1, 58, 1, 1, 1, 'UNPUBLISH', '', -1, 1, '{"publishing":"0"}'), 1200 (2, 59, 1, 2, 1, 'PUBLISH', '', -1, 1, '{"publishing":"1"}'), 1201 (3, 60, 1, 3, 1, 'TRASH', '', -1, 1, '{"publishing":"-2"}'), 1202 (4, 61, 1, 4, 1, 'ARCHIVE', '', -1, 1, '{"publishing":"2"}'), 1203 (5, 62, 1, 5, 1, 'FEATURE', '', -1, 1, '{"featuring":"1"}'), 1204 (6, 63, 1, 6, 1, 'UNFEATURE', '', -1, 1, '{"featuring":"0"}'), 1205 (7, 64, 1, 7, 1, 'PUBLISH_AND_FEATURE', '', -1, 1, '{"publishing":"1","featuring":"1"}');
title
Description
Body
title
Description
Body
title
Description
Body
title
Body
| Generated: Wed Sep 7 05:41:13 2022 | Chilli.vc Blog - For Webmaster,Blog-Writer,System Admin and Domainer |