SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; -- -- Database: `modx305pl` -- -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]access_actiondom` -- CREATE TABLE `[[dbprefix]]access_actiondom` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `target` varchar(100) NOT NULL DEFAULT '', `principal_class` varchar(100) NOT NULL DEFAULT 'MODX\\Revolution\\modPrincipal', `principal` int(10) unsigned NOT NULL DEFAULT '0', `authority` int(10) unsigned NOT NULL DEFAULT '9999', `policy` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `target` (`target`), KEY `principal_class` (`principal_class`), KEY `principal` (`principal`), KEY `authority` (`authority`), KEY `policy` (`policy`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]access_category` -- CREATE TABLE `[[dbprefix]]access_category` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `target` varchar(100) NOT NULL DEFAULT '', `principal_class` varchar(100) NOT NULL DEFAULT 'MODX\\Revolution\\modPrincipal', `principal` int(10) unsigned NOT NULL DEFAULT '0', `authority` int(10) unsigned NOT NULL DEFAULT '9999', `policy` int(10) unsigned NOT NULL DEFAULT '0', `context_key` varchar(100) NOT NULL DEFAULT '', PRIMARY KEY (`id`), KEY `target` (`target`), KEY `principal_class` (`principal_class`), KEY `principal` (`principal`), KEY `authority` (`authority`), KEY `policy` (`policy`), KEY `context_key` (`context_key`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]access_context` -- CREATE TABLE `[[dbprefix]]access_context` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `target` varchar(100) NOT NULL DEFAULT '', `principal_class` varchar(100) NOT NULL DEFAULT 'MODX\\Revolution\\modPrincipal', `principal` int(10) unsigned NOT NULL DEFAULT '0', `authority` int(10) unsigned NOT NULL DEFAULT '9999', `policy` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `target` (`target`), KEY `principal_class` (`principal_class`), KEY `principal` (`principal`), KEY `authority` (`authority`), KEY `policy` (`policy`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ; -- -- Dumping data for table `[[dbprefix]]access_context` -- INSERT INTO `[[dbprefix]]access_context` VALUES (1, 'web', 'MODX\\Revolution\\modUserGroup', 0, 9999, 3), (2, 'mgr', 'MODX\\Revolution\\modUserGroup', 1, 0, 2), (3, 'web', 'MODX\\Revolution\\modUserGroup', 1, 0, 2); -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]access_elements` -- CREATE TABLE `[[dbprefix]]access_elements` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `target` varchar(100) NOT NULL DEFAULT '', `principal_class` varchar(100) NOT NULL DEFAULT 'MODX\\Revolution\\modPrincipal', `principal` int(10) unsigned NOT NULL DEFAULT '0', `authority` int(10) unsigned NOT NULL DEFAULT '9999', `policy` int(10) unsigned NOT NULL DEFAULT '0', `context_key` varchar(100) NOT NULL DEFAULT '', PRIMARY KEY (`id`), KEY `target` (`target`), KEY `principal_class` (`principal_class`), KEY `principal` (`principal`), KEY `authority` (`authority`), KEY `policy` (`policy`), KEY `context_key` (`context_key`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]access_media_source` -- CREATE TABLE `[[dbprefix]]access_media_source` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `target` varchar(100) NOT NULL DEFAULT '', `principal_class` varchar(100) NOT NULL DEFAULT 'MODX\\Revolution\\modPrincipal', `principal` int(10) unsigned NOT NULL DEFAULT '0', `authority` int(10) unsigned NOT NULL DEFAULT '9999', `policy` int(10) unsigned NOT NULL DEFAULT '0', `context_key` varchar(100) NOT NULL DEFAULT '', PRIMARY KEY (`id`), KEY `target` (`target`), KEY `principal_class` (`principal_class`), KEY `principal` (`principal`), KEY `authority` (`authority`), KEY `policy` (`policy`), KEY `context_key` (`context_key`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]access_menus` -- CREATE TABLE `[[dbprefix]]access_menus` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `target` varchar(100) NOT NULL DEFAULT '', `principal_class` varchar(100) NOT NULL DEFAULT 'MODX\\Revolution\\modPrincipal', `principal` int(10) unsigned NOT NULL DEFAULT '0', `authority` int(10) unsigned NOT NULL DEFAULT '9999', `policy` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `target` (`target`), KEY `principal_class` (`principal_class`), KEY `principal` (`principal`), KEY `authority` (`authority`), KEY `policy` (`policy`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]access_namespace` -- CREATE TABLE `[[dbprefix]]access_namespace` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `target` varchar(100) NOT NULL DEFAULT '', `principal_class` varchar(100) NOT NULL DEFAULT 'MODX\\Revolution\\modPrincipal', `principal` int(10) unsigned NOT NULL DEFAULT '0', `authority` int(10) unsigned NOT NULL DEFAULT '9999', `policy` int(10) unsigned NOT NULL DEFAULT '0', `context_key` varchar(100) NOT NULL DEFAULT '', PRIMARY KEY (`id`), KEY `target` (`target`), KEY `principal_class` (`principal_class`), KEY `principal` (`principal`), KEY `authority` (`authority`), KEY `policy` (`policy`), KEY `context_key` (`context_key`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]access_permissions` -- CREATE TABLE `[[dbprefix]]access_permissions` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `template` int(10) unsigned NOT NULL DEFAULT '0', `name` varchar(191) NOT NULL DEFAULT '', `description` text NOT NULL, `value` tinyint(1) unsigned NOT NULL DEFAULT '1', PRIMARY KEY (`id`), KEY `template` (`template`), KEY `name` (`name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=229 ; -- -- Dumping data for table `[[dbprefix]]access_permissions` -- INSERT INTO `[[dbprefix]]access_permissions` VALUES (1, 1, 'about', 'perm.about_desc', 1), (2, 1, 'access_permissions', 'perm.access_permissions_desc', 1), (3, 1, 'actions', 'perm.actions_desc', 1), (4, 1, 'change_password', 'perm.change_password_desc', 1), (5, 1, 'change_profile', 'perm.change_profile_desc', 1), (6, 1, 'charsets', 'perm.charsets_desc', 1), (7, 1, 'class_map', 'perm.class_map_desc', 1), (8, 1, 'components', 'perm.components_desc', 1), (9, 1, 'content_types', 'perm.content_types_desc', 1), (10, 1, 'countries', 'perm.countries_desc', 1), (11, 1, 'create', 'perm.create_desc', 1), (12, 1, 'credits', 'perm.credits_desc', 1), (13, 1, 'customize_forms', 'perm.customize_forms_desc', 1), (14, 1, 'dashboards', 'perm.dashboards_desc', 1), (15, 1, 'database', 'perm.database_desc', 1), (16, 1, 'database_truncate', 'perm.database_truncate_desc', 1), (17, 1, 'delete_category', 'perm.delete_category_desc', 1), (18, 1, 'delete_chunk', 'perm.delete_chunk_desc', 1), (19, 1, 'delete_context', 'perm.delete_context_desc', 1), (20, 1, 'delete_document', 'perm.delete_document_desc', 1), (21, 1, 'delete_weblink', 'perm.delete_weblink_desc', 1), (22, 1, 'delete_symlink', 'perm.delete_symlink_desc', 1), (23, 1, 'delete_static_resource', 'perm.delete_static_resource_desc', 1), (24, 1, 'delete_eventlog', 'perm.delete_eventlog_desc', 1), (25, 1, 'delete_plugin', 'perm.delete_plugin_desc', 1), (26, 1, 'delete_propertyset', 'perm.delete_propertyset_desc', 1), (27, 1, 'delete_snippet', 'perm.delete_snippet_desc', 1), (28, 1, 'delete_template', 'perm.delete_template_desc', 1), (29, 1, 'delete_tv', 'perm.delete_tv_desc', 1), (30, 1, 'delete_role', 'perm.delete_role_desc', 1), (31, 1, 'delete_user', 'perm.delete_user_desc', 1), (32, 1, 'directory_chmod', 'perm.directory_chmod_desc', 1), (33, 1, 'directory_create', 'perm.directory_create_desc', 1), (34, 1, 'directory_list', 'perm.directory_list_desc', 1), (35, 1, 'directory_remove', 'perm.directory_remove_desc', 1), (36, 1, 'directory_update', 'perm.directory_update_desc', 1), (37, 1, 'edit_category', 'perm.edit_category_desc', 1), (38, 1, 'edit_chunk', 'perm.edit_chunk_desc', 1), (39, 1, 'edit_context', 'perm.edit_context_desc', 1), (40, 1, 'edit_document', 'perm.edit_document_desc', 1), (41, 1, 'edit_weblink', 'perm.edit_weblink_desc', 1), (42, 1, 'edit_symlink', 'perm.edit_symlink_desc', 1), (43, 1, 'edit_static_resource', 'perm.edit_static_resource_desc', 1), (44, 1, 'edit_locked', 'perm.edit_locked_desc', 1), (45, 1, 'edit_plugin', 'perm.edit_plugin_desc', 1), (46, 1, 'edit_propertyset', 'perm.edit_propertyset_desc', 1), (47, 1, 'edit_role', 'perm.edit_role_desc', 1), (48, 1, 'edit_snippet', 'perm.edit_snippet_desc', 1), (49, 1, 'edit_template', 'perm.edit_template_desc', 1), (50, 1, 'edit_tv', 'perm.edit_tv_desc', 1), (51, 1, 'edit_user', 'perm.edit_user_desc', 1), (52, 1, 'element_tree', 'perm.element_tree_desc', 1), (53, 1, 'empty_cache', 'perm.empty_cache_desc', 1), (54, 1, 'error_log_erase', 'perm.error_log_erase_desc', 1), (55, 1, 'error_log_view', 'perm.error_log_view_desc', 1), (56, 1, 'export_static', 'perm.export_static_desc', 1), (57, 1, 'file_create', 'perm.file_create_desc', 1), (58, 1, 'file_list', 'perm.file_list_desc', 1), (59, 1, 'file_manager', 'perm.file_manager_desc', 1), (60, 1, 'file_remove', 'perm.file_remove_desc', 1), (61, 1, 'file_tree', 'perm.file_tree_desc', 1), (62, 1, 'file_update', 'perm.file_update_desc', 1), (63, 1, 'file_upload', 'perm.file_upload_desc', 1), (64, 1, 'file_unpack', 'perm.file_unpack_desc', 1), (65, 1, 'file_view', 'perm.file_view_desc', 1), (66, 1, 'flush_sessions', 'perm.flush_sessions_desc', 1), (67, 1, 'frames', 'perm.frames_desc', 1), (68, 1, 'help', 'perm.help_desc', 1), (69, 1, 'home', 'perm.home_desc', 1), (70, 1, 'language', 'perm.language_desc', 1), (71, 1, 'languages', 'perm.languages_desc', 1), (72, 1, 'lexicons', 'perm.lexicons_desc', 1), (73, 1, 'list', 'perm.list_desc', 1), (74, 1, 'load', 'perm.load_desc', 1), (75, 1, 'logout', 'perm.logout_desc', 1), (76, 1, 'mgr_log_view', 'perm.mgr_log_view_desc', 1), (77, 1, 'mgr_log_erase', 'perm.mgr_log_erase_desc', 1), (78, 1, 'menu_reports', 'perm.menu_reports_desc', 1), (79, 1, 'menu_security', 'perm.menu_security_desc', 1), (80, 1, 'menu_site', 'perm.menu_site_desc', 1), (81, 1, 'menu_support', 'perm.menu_support_desc', 1), (82, 1, 'menu_system', 'perm.menu_system_desc', 1), (83, 1, 'menu_tools', 'perm.menu_tools_desc', 1), (84, 1, 'menu_trash', 'perm.menu_trash_desc', 1), (85, 1, 'menu_user', 'perm.menu_user_desc', 1), (86, 1, 'menus', 'perm.menus_desc', 1), (87, 1, 'messages', 'perm.messages_desc', 1), (88, 1, 'namespaces', 'perm.namespaces_desc', 1), (89, 1, 'new_category', 'perm.new_category_desc', 1), (90, 1, 'new_chunk', 'perm.new_chunk_desc', 1), (91, 1, 'new_context', 'perm.new_context_desc', 1), (92, 1, 'new_document', 'perm.new_document_desc', 1), (93, 1, 'new_static_resource', 'perm.new_static_resource_desc', 1), (94, 1, 'new_symlink', 'perm.new_symlink_desc', 1), (95, 1, 'new_weblink', 'perm.new_weblink_desc', 1), (96, 1, 'new_document_in_root', 'perm.new_document_in_root_desc', 1), (97, 1, 'new_plugin', 'perm.new_plugin_desc', 1), (98, 1, 'new_propertyset', 'perm.new_propertyset_desc', 1), (99, 1, 'new_role', 'perm.new_role_desc', 1), (100, 1, 'new_snippet', 'perm.new_snippet_desc', 1), (101, 1, 'new_template', 'perm.new_template_desc', 1), (102, 1, 'new_tv', 'perm.new_tv_desc', 1), (103, 1, 'new_user', 'perm.new_user_desc', 1), (104, 1, 'packages', 'perm.packages_desc', 1), (105, 1, 'policy_delete', 'perm.policy_delete_desc', 1), (106, 1, 'policy_edit', 'perm.policy_edit_desc', 1), (107, 1, 'policy_new', 'perm.policy_new_desc', 1), (108, 1, 'policy_save', 'perm.policy_save_desc', 1), (109, 1, 'policy_view', 'perm.policy_view_desc', 1), (110, 1, 'policy_template_delete', 'perm.policy_template_delete_desc', 1), (111, 1, 'policy_template_edit', 'perm.policy_template_edit_desc', 1), (112, 1, 'policy_template_new', 'perm.policy_template_new_desc', 1), (113, 1, 'policy_template_save', 'perm.policy_template_save_desc', 1), (114, 1, 'policy_template_view', 'perm.policy_template_view_desc', 1), (115, 1, 'property_sets', 'perm.property_sets_desc', 1), (116, 1, 'providers', 'perm.providers_desc', 1), (117, 1, 'publish_document', 'perm.publish_document_desc', 1), (118, 1, 'purge_deleted', 'perm.purge_deleted_desc', 1), (119, 1, 'remove', 'perm.remove_desc', 1), (120, 1, 'remove_locks', 'perm.remove_locks_desc', 1), (121, 1, 'resource_duplicate', 'perm.resource_duplicate_desc', 1), (122, 1, 'resourcegroup_delete', 'perm.resourcegroup_delete_desc', 1), (123, 1, 'resourcegroup_edit', 'perm.resourcegroup_edit_desc', 1), (124, 1, 'resourcegroup_new', 'perm.resourcegroup_new_desc', 1), (125, 1, 'resourcegroup_resource_edit', 'perm.resourcegroup_resource_edit_desc', 1), (126, 1, 'resourcegroup_resource_list', 'perm.resourcegroup_resource_list_desc', 1), (127, 1, 'resourcegroup_save', 'perm.resourcegroup_save_desc', 1), (128, 1, 'resourcegroup_view', 'perm.resourcegroup_view_desc', 1), (129, 1, 'resource_quick_create', 'perm.resource_quick_create_desc', 1), (130, 1, 'resource_quick_update', 'perm.resource_quick_update_desc', 1), (131, 1, 'resource_tree', 'perm.resource_tree_desc', 1), (132, 1, 'save', 'perm.save_desc', 1), (133, 1, 'save_category', 'perm.save_category_desc', 1), (134, 1, 'save_chunk', 'perm.save_chunk_desc', 1), (135, 1, 'save_context', 'perm.save_context_desc', 1), (136, 1, 'save_document', 'perm.save_document_desc', 1), (137, 1, 'save_plugin', 'perm.save_plugin_desc', 1), (138, 1, 'save_propertyset', 'perm.save_propertyset_desc', 1), (139, 1, 'save_role', 'perm.save_role_desc', 1), (140, 1, 'save_snippet', 'perm.save_snippet_desc', 1), (141, 1, 'save_template', 'perm.save_template_desc', 1), (142, 1, 'save_tv', 'perm.save_tv_desc', 1), (143, 1, 'save_user', 'perm.save_user_desc', 1), (144, 1, 'search', 'perm.search_desc', 1), (145, 1, 'set_sudo', 'perm.set_sudo_desc', 1), (146, 1, 'settings', 'perm.settings_desc', 1), (147, 1, 'events', 'perm.events_desc', 1), (148, 1, 'source_save', 'perm.source_save_desc', 1), (149, 1, 'source_delete', 'perm.source_delete_desc', 1), (150, 1, 'source_edit', 'perm.source_edit_desc', 1), (151, 1, 'source_view', 'perm.source_view_desc', 1), (152, 1, 'sources', 'perm.sources_desc', 1), (153, 1, 'steal_locks', 'perm.steal_locks_desc', 1), (154, 1, 'tree_show_element_ids', 'perm.tree_show_element_ids_desc', 1), (155, 1, 'tree_show_resource_ids', 'perm.tree_show_resource_ids_desc', 1), (156, 1, 'undelete_document', 'perm.undelete_document_desc', 1), (157, 1, 'unpublish_document', 'perm.unpublish_document_desc', 1), (158, 1, 'unlock_element_properties', 'perm.unlock_element_properties_desc', 1), (159, 1, 'usergroup_delete', 'perm.usergroup_delete_desc', 1), (160, 1, 'usergroup_edit', 'perm.usergroup_edit_desc', 1), (161, 1, 'usergroup_new', 'perm.usergroup_new_desc', 1), (162, 1, 'usergroup_save', 'perm.usergroup_save_desc', 1), (163, 1, 'usergroup_user_edit', 'perm.usergroup_user_edit_desc', 1), (164, 1, 'usergroup_user_list', 'perm.usergroup_user_list_desc', 1), (165, 1, 'usergroup_view', 'perm.usergroup_view_desc', 1), (166, 1, 'view', 'perm.view_desc', 1), (167, 1, 'view_category', 'perm.view_category_desc', 1), (168, 1, 'view_chunk', 'perm.view_chunk_desc', 1), (169, 1, 'view_context', 'perm.view_context_desc', 1), (170, 1, 'view_document', 'perm.view_document_desc', 1), (171, 1, 'view_element', 'perm.view_element_desc', 1), (172, 1, 'view_eventlog', 'perm.view_eventlog_desc', 1), (173, 1, 'view_offline', 'perm.view_offline_desc', 1), (174, 1, 'view_plugin', 'perm.view_plugin_desc', 1), (175, 1, 'view_propertyset', 'perm.view_propertyset_desc', 1), (176, 1, 'view_role', 'perm.view_role_desc', 1), (177, 1, 'view_snippet', 'perm.view_snippet_desc', 1), (178, 1, 'view_sysinfo', 'perm.view_sysinfo_desc', 1), (179, 1, 'view_template', 'perm.view_template_desc', 1), (180, 1, 'view_tv', 'perm.view_tv_desc', 1), (181, 1, 'view_user', 'perm.view_user_desc', 1), (182, 1, 'view_unpublished', 'perm.view_unpublished_desc', 1), (183, 1, 'workspaces', 'perm.workspaces_desc', 1), (184, 2, 'add_children', 'perm.add_children_desc', 1), (185, 2, 'copy', 'perm.copy_desc', 1), (186, 2, 'create', 'perm.create_desc', 1), (187, 2, 'delete', 'perm.delete_desc', 1), (188, 2, 'list', 'perm.list_desc', 1), (189, 2, 'load', 'perm.load_desc', 1), (190, 2, 'move', 'perm.move_desc', 1), (191, 2, 'publish', 'perm.publish_desc', 1), (192, 2, 'remove', 'perm.remove_desc', 1), (193, 2, 'save', 'perm.save_desc', 1), (194, 2, 'steal_lock', 'perm.steal_lock_desc', 1), (195, 2, 'undelete', 'perm.undelete_desc', 1), (196, 2, 'unpublish', 'perm.unpublish_desc', 1), (197, 2, 'view', 'perm.view_desc', 1), (198, 3, 'load', 'perm.load_desc', 1), (199, 3, 'list', 'perm.list_desc', 1), (200, 3, 'view', 'perm.view_desc', 1), (201, 3, 'save', 'perm.save_desc', 1), (202, 3, 'remove', 'perm.remove_desc', 1), (203, 4, 'add_children', 'perm.add_children_desc', 1), (204, 4, 'create', 'perm.create_desc', 1), (205, 4, 'copy', 'perm.copy_desc', 1), (206, 4, 'delete', 'perm.delete_desc', 1), (207, 4, 'list', 'perm.list_desc', 1), (208, 4, 'load', 'perm.load_desc', 1), (209, 4, 'remove', 'perm.remove_desc', 1), (210, 4, 'save', 'perm.save_desc', 1), (211, 4, 'view', 'perm.view_desc', 1), (212, 5, 'create', 'perm.create_desc', 1), (213, 5, 'copy', 'perm.copy_desc', 1), (214, 5, 'list', 'perm.list_desc', 1), (215, 5, 'load', 'perm.load_desc', 1), (216, 5, 'remove', 'perm.remove_desc', 1), (217, 5, 'save', 'perm.save_desc', 1), (218, 5, 'view', 'perm.view_desc', 1), (219, 6, 'load', 'perm.load_desc', 1), (220, 6, 'list', 'perm.list_desc', 1), (221, 6, 'view', 'perm.view_desc', 1), (222, 6, 'save', 'perm.save_desc', 1), (223, 6, 'remove', 'perm.remove_desc', 1), (224, 6, 'view_unpublished', 'perm.view_unpublished_desc', 1), (225, 6, 'copy', 'perm.copy_desc', 1), (226, 7, 'list', 'perm.list_desc', 1), (227, 7, 'load', 'perm.load_desc', 1), (228, 7, 'view', 'perm.view_desc', 1); -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]access_policies` -- CREATE TABLE `[[dbprefix]]access_policies` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(191) NOT NULL, `description` mediumtext, `parent` int(10) unsigned NOT NULL DEFAULT '0', `template` int(10) unsigned NOT NULL DEFAULT '0', `class` varchar(191) NOT NULL DEFAULT '', `data` text, `lexicon` varchar(255) NOT NULL DEFAULT 'permissions', PRIMARY KEY (`id`), UNIQUE KEY `name` (`name`), KEY `parent` (`parent`), KEY `class` (`class`), KEY `template` (`template`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=13 ; -- -- Dumping data for table `[[dbprefix]]access_policies` -- INSERT INTO `[[dbprefix]]access_policies` VALUES (1, 'Resource', 'policy_resource_desc', 0, 2, '', '{"add_children":true,"create":true,"copy":true,"delete":true,"list":true,"load":true,"move":true,"publish":true,"remove":true,"save":true,"steal_lock":true,"undelete":true,"unpublish":true,"view":true}', 'permissions'), (2, 'Administrator', 'policy_administrator_desc', 0, 1, '', '{"about":true,"access_permissions":true,"actions":true,"change_password":true,"change_profile":true,"charsets":true,"class_map":true,"components":true,"content_types":true,"countries":true,"create":true,"credits":true,"customize_forms":true,"dashboards":true,"database":true,"database_truncate":true,"delete_category":true,"delete_chunk":true,"delete_context":true,"delete_document":true,"delete_eventlog":true,"delete_plugin":true,"delete_propertyset":true,"delete_role":true,"delete_snippet":true,"delete_static_resource":true,"delete_symlink":true,"delete_template":true,"delete_tv":true,"delete_user":true,"delete_weblink":true,"directory_chmod":true,"directory_create":true,"directory_list":true,"directory_remove":true,"directory_update":true,"edit_category":true,"edit_chunk":true,"edit_context":true,"edit_document":true,"edit_locked":true,"edit_plugin":true,"edit_propertyset":true,"edit_role":true,"edit_snippet":true,"edit_static_resource":true,"edit_symlink":true,"edit_template":true,"edit_tv":true,"edit_user":true,"edit_weblink":true,"element_tree":true,"empty_cache":true,"error_log_erase":true,"error_log_view":true,"events":true,"export_static":true,"file_create":true,"file_list":true,"file_manager":true,"file_remove":true,"file_tree":true,"file_unpack":true,"file_update":true,"file_upload":true,"file_view":true,"flush_sessions":true,"frames":true,"help":true,"home":true,"language":true,"languages":true,"lexicons":true,"list":true,"load":true,"logout":true,"mgr_log_view":true,"mgr_log_erase":true,"menu_reports":true,"menu_security":true,"menu_site":true,"menu_support":true,"menu_system":true,"menu_tools":true,"menu_trash":true,"menu_user":true,"menus":true,"messages":true,"namespaces":true,"new_category":true,"new_chunk":true,"new_context":true,"new_document":true,"new_document_in_root":true,"new_plugin":true,"new_propertyset":true,"new_role":true,"new_snippet":true,"new_static_resource":true,"new_symlink":true,"new_template":true,"new_tv":true,"new_user":true,"new_weblink":true,"packages":true,"policy_delete":true,"policy_edit":true,"policy_new":true,"policy_save":true,"policy_template_delete":true,"policy_template_edit":true,"policy_template_new":true,"policy_template_save":true,"policy_template_view":true,"policy_view":true,"property_sets":true,"providers":true,"publish_document":true,"purge_deleted":true,"remove":true,"remove_locks":true,"resource_duplicate":true,"resource_quick_create":true,"resource_quick_update":true,"resource_tree":true,"resourcegroup_delete":true,"resourcegroup_edit":true,"resourcegroup_new":true,"resourcegroup_resource_edit":true,"resourcegroup_resource_list":true,"resourcegroup_save":true,"resourcegroup_view":true,"save":true,"save_category":true,"save_chunk":true,"save_context":true,"save_document":true,"save_plugin":true,"save_propertyset":true,"save_role":true,"save_snippet":true,"save_template":true,"save_tv":true,"save_user":true,"search":true,"set_sudo":true,"settings":true,"source_delete":true,"source_edit":true,"source_save":true,"source_view":true,"sources":true,"steal_locks":true,"tree_show_element_ids":true,"tree_show_resource_ids":true,"undelete_document":true,"unlock_element_properties":true,"unpublish_document":true,"usergroup_delete":true,"usergroup_edit":true,"usergroup_new":true,"usergroup_save":true,"usergroup_user_edit":true,"usergroup_user_list":true,"usergroup_view":true,"view":true,"view_category":true,"view_chunk":true,"view_context":true,"view_document":true,"view_element":true,"view_eventlog":true,"view_offline":true,"view_plugin":true,"view_propertyset":true,"view_role":true,"view_snippet":true,"view_sysinfo":true,"view_template":true,"view_tv":true,"view_unpublished":true,"view_user":true,"workspaces":true}', 'permissions'), (3, 'Load Only', 'policy_load_only_desc', 0, 3, '', '{"load":true}', 'permissions'), (4, 'Load, List and View', 'policy_load_list_and_view_desc', 0, 3, '', '{"load":true,"list":true,"view":true}', 'permissions'), (5, 'Object', 'policy_object_desc', 0, 3, '', '{"load":true,"list":true,"view":true,"save":true,"remove":true}', 'permissions'), (6, 'Element', 'policy_element_desc', 0, 4, '', '{"add_children":true,"create":true,"delete":true,"list":true,"load":true,"remove":true,"save":true,"view":true,"copy":true}', 'permissions'), (7, 'Content Editor', 'policy_content_editor_desc', 0, 1, '', '{"change_profile":true,"class_map":true,"countries":true,"delete_document":true,"delete_static_resource":true,"delete_symlink":true,"delete_weblink":true,"edit_document":true,"edit_static_resource":true,"edit_symlink":true,"edit_weblink":true,"frames":true,"help":true,"home":true,"language":true,"list":true,"load":true,"logout":true,"menu_reports":true,"menu_site":true,"menu_support":true,"menu_tools":true,"menu_user":true,"new_document":true,"new_static_resource":true,"new_symlink":true,"new_weblink":true,"resource_duplicate":true,"resource_tree":true,"save_document":true,"source_view":true,"tree_show_resource_ids":true,"view":true,"view_document":true,"view_template":true}', 'permissions'), (8, 'Media Source Admin', 'policy_media_source_admin_desc', 0, 5, '', '{"create":true,"copy":true,"load":true,"list":true,"save":true,"remove":true,"view":true}', 'permissions'), (9, 'Media Source User', 'policy_media_source_user_desc', 0, 5, '', '{"load":true,"list":true,"view":true}', 'permissions'), (10, 'Developer', 'policy_developer_desc', 0, 1, '', '{"about":true,"change_password":true,"change_profile":true,"charsets":true,"class_map":true,"components":true,"content_types":true,"countries":true,"create":true,"credits":true,"customize_forms":true,"dashboards":true,"database":true,"delete_category":true,"delete_chunk":true,"delete_context":true,"delete_document":true,"delete_eventlog":true,"delete_plugin":true,"delete_propertyset":true,"delete_role":true,"delete_snippet":true,"delete_template":true,"delete_tv":true,"delete_user":true,"directory_chmod":true,"directory_create":true,"directory_list":true,"directory_remove":true,"directory_update":true,"edit_category":true,"edit_chunk":true,"edit_context":true,"edit_document":true,"edit_locked":true,"edit_plugin":true,"edit_propertyset":true,"edit_role":true,"edit_snippet":true,"edit_static_resource":true,"edit_symlink":true,"edit_template":true,"edit_tv":true,"edit_user":true,"edit_weblink":true,"element_tree":true,"empty_cache":true,"error_log_erase":true,"error_log_view":true,"export_static":true,"file_create":true,"file_list":true,"file_manager":true,"file_remove":true,"file_tree":true,"file_unpack":true,"file_update":true,"file_upload":true,"file_view":true,"frames":true,"help":true,"home":true,"language":true,"languages":true,"lexicons":true,"list":true,"load":true,"logout":true,"mgr_log_view":true,"mgr_log_erase":true,"menu_reports":true,"menu_site":true,"menu_support":true,"menu_system":true,"menu_tools":true,"menu_user":true,"menus":true,"messages":true,"namespaces":true,"new_category":true,"new_chunk":true,"new_context":true,"new_document":true,"new_document_in_root":true,"new_plugin":true,"new_propertyset":true,"new_role":true,"new_snippet":true,"new_static_resource":true,"new_symlink":true,"new_template":true,"new_tv":true,"new_user":true,"new_weblink":true,"packages":true,"property_sets":true,"providers":true,"publish_document":true,"purge_deleted":true,"remove":true,"resource_duplicate":true,"resource_quick_create":true,"resource_quick_update":true,"resource_tree":true,"save":true,"save_category":true,"save_chunk":true,"save_context":true,"save_document":true,"save_plugin":true,"save_propertyset":true,"save_snippet":true,"save_template":true,"save_tv":true,"save_user":true,"search":true,"settings":true,"source_delete":true,"source_edit":true,"source_save":true,"source_view":true,"sources":true,"tree_show_element_ids":true,"tree_show_resource_ids":true,"undelete_document":true,"unlock_element_properties":true,"unpublish_document":true,"view":true,"view_category":true,"view_chunk":true,"view_context":true,"view_document":true,"view_element":true,"view_eventlog":true,"view_offline":true,"view_plugin":true,"view_propertyset":true,"view_role":true,"view_snippet":true,"view_sysinfo":true,"view_template":true,"view_tv":true,"view_unpublished":true,"view_user":true,"workspaces":true}', 'permissions'), (11, 'Context', 'policy_context_desc', 0, 6, '', '{"load":true,"list":true,"view":true,"save":true,"remove":true,"copy":true,"view_unpublished":true}', 'permissions'), (12, 'Hidden Namespace', 'policy_hidden_namespace_desc', 0, 7, '', '{"load":false,"list":false,"view":true}', 'permissions'); -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]access_policy_templates` -- CREATE TABLE `[[dbprefix]]access_policy_templates` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `template_group` int(10) unsigned NOT NULL DEFAULT '0', `name` varchar(191) NOT NULL DEFAULT '', `description` mediumtext, `lexicon` varchar(255) NOT NULL DEFAULT 'permissions', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ; -- -- Dumping data for table `[[dbprefix]]access_policy_templates` -- INSERT INTO `[[dbprefix]]access_policy_templates` VALUES (1, 1, 'AdministratorTemplate', 'policy_template_administrator_desc', 'permissions'), (2, 3, 'ResourceTemplate', 'policy_template_resource_desc', 'permissions'), (3, 2, 'ObjectTemplate', 'policy_template_object_desc', 'permissions'), (4, 4, 'ElementTemplate', 'policy_template_element_desc', 'permissions'), (5, 5, 'MediaSourceTemplate', 'policy_template_mediasource_desc', 'permissions'), (6, 7, 'ContextTemplate', 'policy_template_context_desc', 'permissions'), (7, 6, 'NamespaceTemplate', 'policy_template_namespace_desc', 'permissions'); -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]access_policy_template_groups` -- CREATE TABLE `[[dbprefix]]access_policy_template_groups` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(191) NOT NULL DEFAULT '', `description` mediumtext, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ; -- -- Dumping data for table `[[dbprefix]]access_policy_template_groups` -- INSERT INTO `[[dbprefix]]access_policy_template_groups` VALUES (1, 'Administrator', 'policy_template_group_administrator_desc'), (2, 'Object', 'policy_template_group_object_desc'), (3, 'Resource', 'policy_template_group_resource_desc'), (4, 'Element', 'policy_template_group_element_desc'), (5, 'MediaSource', 'policy_template_group_mediasource_desc'), (6, 'Namespace', 'policy_template_group_namespace_desc'), (7, 'Context', 'policy_template_group_context_desc'); -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]access_resources` -- CREATE TABLE `[[dbprefix]]access_resources` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `target` varchar(100) NOT NULL DEFAULT '', `principal_class` varchar(100) NOT NULL DEFAULT 'MODX\\Revolution\\modPrincipal', `principal` int(10) unsigned NOT NULL DEFAULT '0', `authority` int(10) unsigned NOT NULL DEFAULT '9999', `policy` int(10) unsigned NOT NULL DEFAULT '0', `context_key` varchar(100) NOT NULL DEFAULT '', PRIMARY KEY (`id`), KEY `target` (`target`), KEY `principal_class` (`principal_class`), KEY `principal` (`principal`), KEY `authority` (`authority`), KEY `policy` (`policy`), KEY `context_key` (`context_key`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]access_resource_groups` -- CREATE TABLE `[[dbprefix]]access_resource_groups` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `target` varchar(100) NOT NULL DEFAULT '', `principal_class` varchar(100) NOT NULL DEFAULT 'MODX\\Revolution\\modPrincipal', `principal` int(10) unsigned NOT NULL DEFAULT '0', `authority` int(10) unsigned NOT NULL DEFAULT '9999', `policy` int(10) unsigned NOT NULL DEFAULT '0', `context_key` varchar(100) NOT NULL DEFAULT '', PRIMARY KEY (`id`), KEY `target` (`target`), KEY `principal_class` (`principal_class`,`target`,`principal`,`authority`), KEY `principal` (`principal`), KEY `authority` (`authority`), KEY `policy` (`policy`), KEY `context_key` (`context_key`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]access_templatevars` -- CREATE TABLE `[[dbprefix]]access_templatevars` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `target` varchar(100) NOT NULL DEFAULT '', `principal_class` varchar(100) NOT NULL DEFAULT 'MODX\\Revolution\\modPrincipal', `principal` int(10) unsigned NOT NULL DEFAULT '0', `authority` int(10) unsigned NOT NULL DEFAULT '9999', `policy` int(10) unsigned NOT NULL DEFAULT '0', `context_key` varchar(100) NOT NULL DEFAULT '', PRIMARY KEY (`id`), KEY `target` (`target`), KEY `principal_class` (`principal_class`), KEY `principal` (`principal`), KEY `authority` (`authority`), KEY `policy` (`policy`), KEY `context_key` (`context_key`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]actiondom` -- CREATE TABLE `[[dbprefix]]actiondom` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `set` int(11) NOT NULL DEFAULT '0', `action` varchar(191) NOT NULL DEFAULT '', `name` varchar(191) NOT NULL DEFAULT '', `description` text, `xtype` varchar(100) NOT NULL DEFAULT '', `container` varchar(255) NOT NULL DEFAULT '', `rule` varchar(100) NOT NULL DEFAULT '', `value` text NOT NULL, `constraint` varchar(255) NOT NULL DEFAULT '', `constraint_field` varchar(100) NOT NULL DEFAULT '', `constraint_class` varchar(100) NOT NULL DEFAULT '', `active` tinyint(1) unsigned NOT NULL DEFAULT '1', `for_parent` tinyint(1) unsigned NOT NULL DEFAULT '0', `rank` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `set` (`set`), KEY `action` (`action`), KEY `name` (`name`), KEY `active` (`active`), KEY `for_parent` (`for_parent`), KEY `rank` (`rank`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]actions_fields` -- CREATE TABLE `[[dbprefix]]actions_fields` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `action` varchar(191) NOT NULL DEFAULT '', `name` varchar(255) NOT NULL DEFAULT '', `type` varchar(100) NOT NULL DEFAULT 'field', `tab` varchar(191) NOT NULL DEFAULT '', `form` varchar(255) NOT NULL DEFAULT '', `other` varchar(255) NOT NULL DEFAULT '', `rank` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `action` (`action`), KEY `type` (`type`), KEY `tab` (`tab`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=89 ; -- -- Dumping data for table `[[dbprefix]]actions_fields` -- INSERT INTO `[[dbprefix]]actions_fields` VALUES (1, 'resource/update', 'modx-resource-settings', 'tab', '', 'modx-panel-resource', '', 0), (2, 'resource/update', 'modx-resource-main-left', 'tab', '', 'modx-panel-resource', '', 1), (3, 'resource/update', 'id', 'field', 'modx-resource-main-left', 'modx-panel-resource', '', 0), (4, 'resource/update', 'pagetitle', 'field', 'modx-resource-main-left', 'modx-panel-resource', '', 1), (5, 'resource/update', 'alias', 'field', 'modx-resource-main-left', 'modx-panel-resource', '', 2), (6, 'resource/update', 'longtitle', 'field', 'modx-resource-main-left', 'modx-panel-resource', '', 3), (7, 'resource/update', 'description', 'field', 'modx-resource-main-left', 'modx-panel-resource', '', 4), (8, 'resource/update', 'introtext', 'field', 'modx-resource-main-left', 'modx-panel-resource', '', 5), (9, 'resource/update', 'modx-resource-content', 'field', 'modx-resource-content', 'modx-panel-resource', '', 0), (10, 'resource/update', 'modx-resource-main-right', 'tab', '', 'modx-panel-resource', '', 3), (11, 'resource/update', 'modx-resource-main-right-top', 'tab', '', 'modx-panel-resource', '', 4), (12, 'resource/update', 'published', 'field', 'modx-resource-main-right-top', 'modx-panel-resource', '', 0), (13, 'resource/update', 'deleted', 'field', 'modx-resource-main-right-top', 'modx-panel-resource', '', 1), (14, 'resource/update', 'publishedon', 'field', 'modx-resource-main-right-top', 'modx-panel-resource', '', 2), (15, 'resource/update', 'pub_date', 'field', 'modx-resource-main-right-top', 'modx-panel-resource', '', 3), (16, 'resource/update', 'unpub_date', 'field', 'modx-resource-main-right-top', 'modx-panel-resource', '', 4), (17, 'resource/update', 'modx-resource-main-right-middle', 'tab', '', 'modx-panel-resource', '', 5), (18, 'resource/update', 'template', 'field', 'modx-resource-main-right-middle', 'modx-panel-resource', '', 0), (19, 'resource/update', 'modx-resource-main-right-bottom', 'tab', '', 'modx-panel-resource', '', 6), (20, 'resource/update', 'hidemenu', 'field', 'modx-resource-main-right-bottom', 'modx-panel-resource', '', 0), (21, 'resource/update', 'menutitle', 'field', 'modx-resource-main-right-bottom', 'modx-panel-resource', '', 1), (22, 'resource/update', 'link_attributes', 'field', 'modx-resource-main-right-bottom', 'modx-panel-resource', '', 2), (23, 'resource/update', 'menuindex', 'field', 'modx-resource-main-right-bottom', 'modx-panel-resource', '', 3), (24, 'resource/update', 'modx-page-settings', 'tab', '', 'modx-panel-resource', '', 7), (25, 'resource/update', 'modx-page-settings-left', 'tab', '', 'modx-panel-resource', '', 8), (26, 'resource/update', 'class_key', 'field', 'modx-page-settings-left', 'modx-panel-resource', '', 0), (27, 'resource/update', 'content_type', 'field', 'modx-page-settings-left', 'modx-panel-resource', '', 1), (28, 'resource/update', 'modx-page-settings-right', 'tab', '', 'modx-panel-resource', '', 9), (29, 'resource/update', 'parent-cmb', 'field', 'modx-page-settings-right', 'modx-panel-resource', '', 0), (30, 'resource/update', 'content_dispo', 'field', 'modx-page-settings-right', 'modx-panel-resource', '', 1), (31, 'resource/update', 'modx-page-settings-box-left', 'tab', '', 'modx-panel-resource', '', 10), (32, 'resource/update', 'isfolder', 'field', 'modx-page-settings-box-left', 'modx-panel-resource', '', 0), (33, 'resource/update', 'show_in_tree', 'field', 'modx-page-settings-box-left', 'modx-panel-resource', '', 1), (34, 'resource/update', 'hide_children_in_tree', 'field', 'modx-page-settings-box-left', 'modx-panel-resource', '', 2), (35, 'resource/update', 'alias_visible', 'field', 'modx-page-settings-box-left', 'modx-panel-resource', '', 3), (36, 'resource/update', 'uri_override', 'field', 'modx-page-settings-box-left', 'modx-panel-resource', '', 4), (37, 'resource/update', 'uri', 'field', 'modx-page-settings-box-left', 'modx-panel-resource', '', 5), (38, 'resource/update', 'modx-page-settings-box-right', 'tab', '', 'modx-panel-resource', '', 11), (39, 'resource/update', 'richtext', 'field', 'modx-page-settings-box-right', 'modx-panel-resource', '', 0), (40, 'resource/update', 'cacheable', 'field', 'modx-page-settings-box-right', 'modx-panel-resource', '', 1), (41, 'resource/update', 'searchable', 'field', 'modx-page-settings-box-right', 'modx-panel-resource', '', 2), (42, 'resource/update', 'syncsite', 'field', 'modx-page-settings-box-right', 'modx-panel-resource', '', 3), (43, 'resource/update', 'modx-panel-resource-tv', 'tab', '', 'modx-panel-resource', 'tv', 12), (44, 'resource/update', 'modx-resource-access-permissions', 'tab', '', 'modx-panel-resource', '', 13), (45, 'resource/create', 'modx-resource-settings', 'tab', '', 'modx-panel-resource', '', 0), (46, 'resource/create', 'modx-resource-main-left', 'tab', '', 'modx-panel-resource', '', 1), (47, 'resource/create', 'id', 'field', 'modx-resource-main-left', 'modx-panel-resource', '', 0), (48, 'resource/create', 'pagetitle', 'field', 'modx-resource-main-left', 'modx-panel-resource', '', 1), (49, 'resource/create', 'alias', 'field', 'modx-resource-main-left', 'modx-panel-resource', '', 2), (50, 'resource/create', 'longtitle', 'field', 'modx-resource-main-left', 'modx-panel-resource', '', 3), (51, 'resource/create', 'description', 'field', 'modx-resource-main-left', 'modx-panel-resource', '', 4), (52, 'resource/create', 'introtext', 'field', 'modx-resource-main-left', 'modx-panel-resource', '', 5), (53, 'resource/create', 'modx-resource-content', 'field', 'modx-resource-content', 'modx-panel-resource', '', 0), (54, 'resource/create', 'modx-resource-main-right', 'tab', '', 'modx-panel-resource', '', 3), (55, 'resource/create', 'modx-resource-main-right-top', 'tab', '', 'modx-panel-resource', '', 4), (56, 'resource/create', 'published', 'field', 'modx-resource-main-right-top', 'modx-panel-resource', '', 0), (57, 'resource/create', 'deleted', 'field', 'modx-resource-main-right-top', 'modx-panel-resource', '', 1), (58, 'resource/create', 'publishedon', 'field', 'modx-resource-main-right-top', 'modx-panel-resource', '', 2), (59, 'resource/create', 'pub_date', 'field', 'modx-resource-main-right-top', 'modx-panel-resource', '', 3), (60, 'resource/create', 'unpub_date', 'field', 'modx-resource-main-right-top', 'modx-panel-resource', '', 4), (61, 'resource/create', 'modx-resource-main-right-middle', 'tab', '', 'modx-panel-resource', '', 5), (62, 'resource/create', 'template', 'field', 'modx-resource-main-right-middle', 'modx-panel-resource', '', 0), (63, 'resource/create', 'modx-resource-main-right-bottom', 'tab', '', 'modx-panel-resource', '', 6), (64, 'resource/create', 'hidemenu', 'field', 'modx-resource-main-right-bottom', 'modx-panel-resource', '', 0), (65, 'resource/create', 'menutitle', 'field', 'modx-resource-main-right-bottom', 'modx-panel-resource', '', 1), (66, 'resource/create', 'link_attributes', 'field', 'modx-resource-main-right-bottom', 'modx-panel-resource', '', 2), (67, 'resource/create', 'menuindex', 'field', 'modx-resource-main-right-bottom', 'modx-panel-resource', '', 3), (68, 'resource/create', 'modx-page-settings', 'tab', '', 'modx-panel-resource', '', 7), (69, 'resource/create', 'modx-page-settings-left', 'tab', '', 'modx-panel-resource', '', 8), (70, 'resource/create', 'class_key', 'field', 'modx-page-settings-left', 'modx-panel-resource', '', 0), (71, 'resource/create', 'content_type', 'field', 'modx-page-settings-left', 'modx-panel-resource', '', 1), (72, 'resource/create', 'modx-page-settings-right', 'tab', '', 'modx-panel-resource', '', 9), (73, 'resource/create', 'parent-cmb', 'field', 'modx-page-settings-right', 'modx-panel-resource', '', 0), (74, 'resource/create', 'content_dispo', 'field', 'modx-page-settings-right', 'modx-panel-resource', '', 1), (75, 'resource/create', 'modx-page-settings-box-left', 'tab', '', 'modx-panel-resource', '', 10), (76, 'resource/create', 'isfolder', 'field', 'modx-page-settings-box-left', 'modx-panel-resource', '', 0), (77, 'resource/create', 'show_in_tree', 'field', 'modx-page-settings-box-left', 'modx-panel-resource', '', 1), (78, 'resource/create', 'hide_children_in_tree', 'field', 'modx-page-settings-box-left', 'modx-panel-resource', '', 2), (79, 'resource/create', 'alias_visible', 'field', 'modx-page-settings-box-left', 'modx-panel-resource', '', 3), (80, 'resource/create', 'uri_override', 'field', 'modx-page-settings-box-left', 'modx-panel-resource', '', 4), (81, 'resource/create', 'uri', 'field', 'modx-page-settings-box-left', 'modx-panel-resource', '', 5), (82, 'resource/create', 'modx-page-settings-box-right', 'tab', '', 'modx-panel-resource', '', 11), (83, 'resource/create', 'richtext', 'field', 'modx-page-settings-box-right', 'modx-panel-resource', '', 0), (84, 'resource/create', 'cacheable', 'field', 'modx-page-settings-box-right', 'modx-panel-resource', '', 1), (85, 'resource/create', 'searchable', 'field', 'modx-page-settings-box-right', 'modx-panel-resource', '', 2), (86, 'resource/create', 'syncsite', 'field', 'modx-page-settings-box-right', 'modx-panel-resource', '', 3), (87, 'resource/create', 'modx-panel-resource-tv', 'tab', '', 'modx-panel-resource', 'tv', 12), (88, 'resource/create', 'modx-resource-access-permissions', 'tab', '', 'modx-panel-resource', '', 13); -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]active_users` -- CREATE TABLE `[[dbprefix]]active_users` ( `internalKey` int(9) unsigned NOT NULL DEFAULT '0', `username` varchar(50) NOT NULL DEFAULT '', `lasthit` int(20) NOT NULL DEFAULT '0', `id` int(10) DEFAULT NULL, `action` varchar(255) NOT NULL DEFAULT '', `ip` varchar(20) NOT NULL DEFAULT '', PRIMARY KEY (`internalKey`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]categories` -- CREATE TABLE `[[dbprefix]]categories` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `parent` int(10) unsigned DEFAULT '0', `category` varchar(45) NOT NULL DEFAULT '', `rank` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `category` (`parent`,`category`), KEY `parent` (`parent`), KEY `rank` (`rank`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]categories_closure` -- CREATE TABLE `[[dbprefix]]categories_closure` ( `ancestor` int(10) unsigned NOT NULL DEFAULT '0', `descendant` int(10) unsigned NOT NULL DEFAULT '0', `depth` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`ancestor`,`descendant`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]content_type` -- CREATE TABLE `[[dbprefix]]content_type` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(191) NOT NULL, `description` tinytext, `mime_type` tinytext, `file_extensions` tinytext, `icon` tinytext, `headers` mediumtext, `binary` tinyint(1) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `name` (`name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=9 ; -- -- Dumping data for table `[[dbprefix]]content_type` -- INSERT INTO `[[dbprefix]]content_type` VALUES (1, 'HTML', 'HTML content', 'text/html', '.html', '', NULL, 0), (2, 'XML', 'XML content', 'text/xml', '.xml', 'icon-xml', NULL, 0), (3, 'Text', 'Plain text content', 'text/plain', '.txt', 'icon-txt', NULL, 0), (4, 'CSS', 'CSS content', 'text/css', '.css', 'icon-css', NULL, 0), (5, 'JavaScript', 'JavaScript content', 'text/javascript', '.js', 'icon-js', NULL, 0), (6, 'RSS', 'For RSS feeds', 'application/rss+xml', '.rss', 'icon-rss', NULL, 0), (7, 'JSON', 'JSON', 'application/json', '.json', 'icon-json', NULL, 0), (8, 'PDF', 'PDF Files', 'application/pdf', '.pdf', 'icon-pdf', NULL, 1); -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]context` -- CREATE TABLE `[[dbprefix]]context` ( `key` varchar(100) NOT NULL, `name` varchar(191) DEFAULT NULL, `description` tinytext, `rank` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`key`), KEY `name` (`name`), KEY `rank` (`rank`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `[[dbprefix]]context` -- INSERT INTO `[[dbprefix]]context` VALUES ('mgr', 'Manager', 'The default manager or administration context for content management activity.', 0), ('web', 'Website', 'The default front-end context for your web site.', 0); -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]context_resource` -- CREATE TABLE `[[dbprefix]]context_resource` ( `context_key` varchar(191) NOT NULL, `resource` int(11) unsigned NOT NULL, PRIMARY KEY (`context_key`,`resource`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]context_setting` -- CREATE TABLE `[[dbprefix]]context_setting` ( `context_key` varchar(191) NOT NULL, `key` varchar(50) NOT NULL, `value` mediumtext, `xtype` varchar(75) NOT NULL DEFAULT 'textfield', `namespace` varchar(40) NOT NULL DEFAULT 'core', `area` varchar(255) NOT NULL DEFAULT '', `editedon` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`context_key`,`key`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `[[dbprefix]]context_setting` -- INSERT INTO `[[dbprefix]]context_setting` VALUES ('mgr', 'allow_tags_in_post', '1', 'combo-boolean', 'core', 'system', NULL), ('mgr', 'modRequest.class', 'MODX\\Revolution\\modManagerRequest', 'textfield', 'core', 'system', NULL); -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]dashboard` -- CREATE TABLE `[[dbprefix]]dashboard` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(191) NOT NULL DEFAULT '', `description` text, `hide_trees` tinyint(1) unsigned NOT NULL DEFAULT '0', `customizable` tinyint(1) unsigned NOT NULL DEFAULT '1', PRIMARY KEY (`id`), KEY `name` (`name`), KEY `hide_trees` (`hide_trees`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ; -- -- Dumping data for table `[[dbprefix]]dashboard` -- INSERT INTO `[[dbprefix]]dashboard` VALUES (1, 'Default', '', 0, 1); -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]dashboard_widget` -- CREATE TABLE `[[dbprefix]]dashboard_widget` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(191) NOT NULL DEFAULT '', `description` text, `type` varchar(100) NOT NULL, `content` mediumtext, `properties` text, `namespace` varchar(191) NOT NULL DEFAULT '', `lexicon` varchar(191) NOT NULL DEFAULT 'core:dashboards', `size` varchar(255) NOT NULL DEFAULT 'half', `permission` varchar(255) NOT NULL DEFAULT '', PRIMARY KEY (`id`), KEY `name` (`name`), KEY `type` (`type`), KEY `namespace` (`namespace`), KEY `lexicon` (`lexicon`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ; -- -- Dumping data for table `[[dbprefix]]dashboard_widget` -- INSERT INTO `[[dbprefix]]dashboard_widget` VALUES (1, 'w_newsfeed', 'w_newsfeed_desc', 'file', '[[++manager_path]]controllers/default/dashboard/widget.modx-news.php', NULL, 'core', 'core:dashboards', 'one-third', ''), (2, 'w_securityfeed', 'w_securityfeed_desc', 'file', '[[++manager_path]]controllers/default/dashboard/widget.modx-security.php', NULL, 'core', 'core:dashboards', 'one-third', ''), (3, 'w_whosonline', 'w_whosonline_desc', 'file', '[[++manager_path]]controllers/default/dashboard/widget.grid-online.php', NULL, 'core', 'core:dashboards', 'one-third', ''), (4, 'w_recentlyeditedresources', 'w_recentlyeditedresources_desc', 'file', '[[++manager_path]]controllers/default/dashboard/widget.grid-rer.php', NULL, 'core', 'core:dashboards', 'two-thirds', 'view_document'), (5, 'w_configcheck', 'w_configcheck_desc', 'file', '[[++manager_path]]controllers/default/dashboard/widget.configcheck.php', NULL, 'core', 'core:dashboards', 'full', ''), (6, 'w_buttons', 'w_buttons_desc', 'file', '[[++manager_path]]controllers/default/dashboard/widget.buttons.php', '{"create-resource":{"link":"[[++manager_url]]?a=resource\\/create","icon":"file-o","title":"[[%action_new_resource]]","description":"[[%action_new_resource_desc]]"},"view-site":{"link":"[[++site_url]]","icon":"eye","title":"[[%action_view_website]]","description":"[[%action_view_website_desc]]","target":"_blank"},"advanced-search":{"link":"[[++manager_url]]?a=search","icon":"search","title":"[[%action_advanced_search]]","description":"[[%action_advanced_search_desc]]"},"manage-users":{"link":"[[++manager_url]]?a=security\\/user","icon":"user","title":"[[%action_manage_users]]","description":"[[%action_manage_users_desc]]"}}', 'core', 'core:dashboards', 'full', ''), (7, 'w_updates', 'w_updates_desc', 'file', '[[++manager_path]]controllers/default/dashboard/widget.updates.php', NULL, 'core', 'core:dashboards', 'one-third', 'workspaces'); -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]dashboard_widget_placement` -- CREATE TABLE `[[dbprefix]]dashboard_widget_placement` ( `user` int(10) unsigned NOT NULL DEFAULT '0', `dashboard` int(10) unsigned NOT NULL DEFAULT '0', `widget` int(10) unsigned NOT NULL DEFAULT '0', `rank` int(10) unsigned NOT NULL DEFAULT '0', `size` varchar(255) NOT NULL DEFAULT 'half', PRIMARY KEY (`user`,`dashboard`,`widget`), KEY `rank` (`rank`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `[[dbprefix]]dashboard_widget_placement` -- INSERT INTO `[[dbprefix]]dashboard_widget_placement` VALUES (0, 1, 1, 2, 'one-third'), (0, 1, 2, 3, 'one-third'), (0, 1, 3, 5, 'one-third'), (0, 1, 4, 6, 'two-thirds'), (0, 1, 5, 1, 'full'), (0, 1, 6, 0, 'full'), (0, 1, 7, 4, 'one-third'); -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]deprecated_call` -- CREATE TABLE `[[dbprefix]]deprecated_call` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `method` int(11) unsigned NOT NULL DEFAULT '0', `call_count` int(11) unsigned NOT NULL DEFAULT '0', `caller` varchar(191) NOT NULL DEFAULT '', `caller_file` varchar(191) NOT NULL DEFAULT '', `caller_line` int(11) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `method` (`method`), KEY `call_count` (`call_count`), KEY `caller` (`caller`), KEY `caller_file` (`caller_file`), KEY `caller_line` (`caller_line`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]deprecated_method` -- CREATE TABLE `[[dbprefix]]deprecated_method` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `definition` varchar(191) NOT NULL DEFAULT '', `since` varchar(191) NOT NULL DEFAULT '', `recommendation` varchar(1024) NOT NULL DEFAULT '', PRIMARY KEY (`id`), KEY `definition` (`definition`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]documentgroup_names` -- CREATE TABLE `[[dbprefix]]documentgroup_names` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(191) NOT NULL DEFAULT '', `private_memgroup` tinyint(1) unsigned NOT NULL DEFAULT '0', `private_webgroup` tinyint(1) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `name` (`name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]document_groups` -- CREATE TABLE `[[dbprefix]]document_groups` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `document_group` int(10) NOT NULL DEFAULT '0', `document` int(10) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `document_group` (`document_group`), KEY `document` (`document`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]element_property_sets` -- CREATE TABLE `[[dbprefix]]element_property_sets` ( `element` int(10) unsigned NOT NULL DEFAULT '0', `element_class` varchar(100) NOT NULL DEFAULT '', `property_set` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`element`,`element_class`,`property_set`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]extension_packages` -- CREATE TABLE `[[dbprefix]]extension_packages` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `namespace` varchar(40) NOT NULL DEFAULT 'core', `name` varchar(100) NOT NULL DEFAULT 'core', `path` text, `table_prefix` varchar(255) NOT NULL DEFAULT '', `service_class` varchar(255) NOT NULL DEFAULT '', `service_name` varchar(255) NOT NULL DEFAULT '', `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (`id`), KEY `namespace` (`namespace`), KEY `name` (`name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]fc_profiles` -- CREATE TABLE `[[dbprefix]]fc_profiles` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(191) NOT NULL DEFAULT '', `description` text NOT NULL, `active` tinyint(1) NOT NULL DEFAULT '0', `rank` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `name` (`name`), KEY `rank` (`rank`), KEY `active` (`active`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]fc_profiles_usergroups` -- CREATE TABLE `[[dbprefix]]fc_profiles_usergroups` ( `usergroup` int(11) NOT NULL DEFAULT '0', `profile` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`usergroup`,`profile`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]fc_sets` -- CREATE TABLE `[[dbprefix]]fc_sets` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `profile` int(11) NOT NULL DEFAULT '0', `action` varchar(191) NOT NULL DEFAULT '', `description` text NOT NULL, `active` tinyint(1) NOT NULL DEFAULT '0', `template` int(11) NOT NULL DEFAULT '0', `constraint` varchar(255) NOT NULL DEFAULT '', `constraint_field` varchar(100) NOT NULL DEFAULT '', `constraint_class` varchar(100) NOT NULL DEFAULT '', PRIMARY KEY (`id`), KEY `profile` (`profile`), KEY `action` (`action`), KEY `active` (`active`), KEY `template` (`template`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]lexicon_entries` -- CREATE TABLE `[[dbprefix]]lexicon_entries` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(191) NOT NULL DEFAULT '', `value` text NOT NULL, `topic` varchar(191) NOT NULL DEFAULT 'default', `namespace` varchar(40) NOT NULL DEFAULT 'core', `language` varchar(20) NOT NULL DEFAULT 'en', `createdon` datetime DEFAULT NULL, `editedon` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`), KEY `name` (`name`), KEY `topic` (`topic`), KEY `namespace` (`namespace`), KEY `language` (`language`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]manager_log` -- CREATE TABLE `[[dbprefix]]manager_log` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `user` int(10) unsigned NOT NULL DEFAULT '0', `occurred` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `action` varchar(100) NOT NULL DEFAULT '', `classKey` varchar(100) NOT NULL DEFAULT '', `item` varchar(255) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `user_occurred` (`user`,`occurred`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]media_sources` -- CREATE TABLE `[[dbprefix]]media_sources` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(191) NOT NULL DEFAULT '', `description` text, `class_key` varchar(100) NOT NULL DEFAULT 'MODX\\Revolution\\Sources\\modFileMediaSource', `properties` mediumtext, `is_stream` tinyint(1) unsigned NOT NULL DEFAULT '1', PRIMARY KEY (`id`), KEY `name` (`name`), KEY `class_key` (`class_key`), KEY `is_stream` (`is_stream`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ; -- -- Dumping data for table `[[dbprefix]]media_sources` -- INSERT INTO `[[dbprefix]]media_sources` VALUES (1, 'Filesystem', '', 'MODX\\Revolution\\Sources\\modFileMediaSource', 'a:0:{}', 1); -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]media_sources_contexts` -- CREATE TABLE `[[dbprefix]]media_sources_contexts` ( `source` int(11) NOT NULL DEFAULT '0', `context_key` varchar(100) NOT NULL DEFAULT 'web', PRIMARY KEY (`source`,`context_key`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]media_sources_elements` -- CREATE TABLE `[[dbprefix]]media_sources_elements` ( `source` int(11) unsigned NOT NULL DEFAULT '0', `object_class` varchar(100) NOT NULL DEFAULT 'MODX\\Revolution\\modTemplateVar', `object` int(11) unsigned NOT NULL DEFAULT '0', `context_key` varchar(100) NOT NULL DEFAULT 'web', PRIMARY KEY (`source`,`object`,`object_class`,`context_key`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]membergroup_names` -- CREATE TABLE `[[dbprefix]]membergroup_names` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(191) NOT NULL DEFAULT '', `description` text, `parent` int(10) unsigned NOT NULL DEFAULT '0', `rank` int(10) unsigned NOT NULL DEFAULT '0', `dashboard` int(10) unsigned NOT NULL DEFAULT '1', PRIMARY KEY (`id`), UNIQUE KEY `name` (`name`), KEY `parent` (`parent`), KEY `rank` (`rank`), KEY `dashboard` (`dashboard`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ; -- -- Dumping data for table `[[dbprefix]]membergroup_names` -- INSERT INTO `[[dbprefix]]membergroup_names` VALUES (1, 'Administrator', NULL, 0, 0, 1); -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]member_groups` -- CREATE TABLE `[[dbprefix]]member_groups` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `user_group` int(10) unsigned NOT NULL DEFAULT '0', `member` int(10) unsigned NOT NULL DEFAULT '0', `role` int(10) unsigned NOT NULL DEFAULT '1', `rank` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `role` (`role`), KEY `rank` (`rank`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ; -- -- Dumping data for table `[[dbprefix]]member_groups` -- INSERT INTO `[[dbprefix]]member_groups` VALUES (1, 1, 1, 2, 0); -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]menus` -- CREATE TABLE `[[dbprefix]]menus` ( `text` varchar(191) NOT NULL DEFAULT '', `parent` varchar(191) NOT NULL DEFAULT '', `action` varchar(191) NOT NULL DEFAULT '', `description` varchar(255) NOT NULL DEFAULT '', `icon` varchar(255) NOT NULL DEFAULT '', `menuindex` int(11) unsigned NOT NULL DEFAULT '0', `params` text NOT NULL, `handler` text NOT NULL, `permissions` text NOT NULL, `namespace` varchar(100) NOT NULL DEFAULT 'core', PRIMARY KEY (`text`), KEY `parent` (`parent`), KEY `action` (`action`), KEY `namespace` (`namespace`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `[[dbprefix]]menus` -- INSERT INTO `[[dbprefix]]menus` VALUES ('about', 'usernav', 'help', '', '', 8, '', '', 'help', 'core'), ('acls', 'admin', 'security/permission', 'acls_desc', '', 5, '', '', 'access_permissions', 'core'), ('admin', 'usernav', '', '', '', 6, '', '', 'settings', 'core'), ('components', 'topnav', '', '', '', 2, '', '', 'components', 'core'), ('content_types', 'site', 'system/contenttype', 'content_types_desc', '', 3, '', '', 'content_types', 'core'), ('contexts', 'admin', 'context', 'contexts_desc', '', 3, '', '', 'view_context', 'core'), ('dashboards', 'admin', 'system/dashboards', 'dashboards_desc', '', 2, '', '', 'dashboards', 'core'), ('edit_menu', 'admin', 'system/action', 'edit_menu_desc', '', 4, '', '', 'actions', 'core'), ('eventlog_viewer', 'reports', 'system/event', 'eventlog_viewer_desc', '', 2, '', '', 'view_eventlog', 'core'), ('file_browser', 'media', 'media/browser', 'file_browser_desc', '', 0, '', '', 'file_manager', 'core'), ('flush_access', 'manage', '', 'flush_access_desc', '', 3, '', 'MODx.msg.confirm({\n title: _(''flush_access'')\n ,text: _(''flush_access_confirm'')\n ,url: MODx.config.connector_url\n ,params: {\n action: ''security/access/flush''\n }\n ,listeners: {\n ''success'': {fn:function() { location.href = ''./''; },scope:this},\n ''failure'': {fn:function(response) { Ext.MessageBox.alert(''failure'', response.responseText); },scope:this},\n }\n});', 'access_permissions', 'core'), ('flush_sessions', 'manage', '', 'flush_sessions_desc', '', 4, '', 'MODx.msg.confirm({\n title: _(''flush_sessions'')\n ,text: _(''flush_sessions_confirm'')\n ,url: MODx.config.connector_url\n ,params: {\n action: ''security/flush''\n }\n ,listeners: {\n ''success'': {fn:function() { location.href = ''./''; },scope:this}\n }\n});', 'flush_sessions', 'core'), ('form_customization', 'admin', 'security/forms', 'form_customization_desc', '', 1, '', '', 'customize_forms', 'core'), ('installer', 'components', 'workspaces', 'installer_desc', '', 0, '', '', 'packages', 'core'), ('language', 'user', '', 'language_desc', '', 2, '', '', 'language', 'core'), ('lexicon_management', 'admin', 'workspaces/lexicon', 'lexicon_management_desc', '', 7, '', '', 'lexicons', 'core'), ('logout', 'user', 'security/logout', 'logout_desc', '', 3, '', 'MODx.logout(); return false;', 'logout', 'core'), ('manage', 'topnav', '', '', '', 3, '', '', 'menu_tools', 'core'), ('media', 'topnav', '', '', '', 1, '', '', 'file_manager', 'core'), ('messages', 'user', 'security/message', 'messages_desc', '', 1, '', '', 'messages', 'core'), ('namespaces', 'admin', 'workspaces/namespace', 'namespaces_desc', '', 8, '', '', 'namespaces', 'core'), ('new_resource', 'site', 'resource/create', 'new_resource_desc', '', 0, '', '', 'new_document', 'core'), ('preview', 'site', '', 'preview_desc', '', 1, '', 'MODx.preview(); return false;', '', 'core'), ('propertysets', 'admin', 'element/propertyset', 'propertysets_desc', '', 6, '', '', 'property_sets', 'core'), ('refreshuris', 'refresh_site', '', 'refreshuris_desc', '', 0, '', 'MODx.refreshURIs(); return false;', 'empty_cache', 'core'), ('refresh_site', 'manage', '', 'refresh_site_desc', '', 1, '', 'MODx.clearCache(); return false;', 'empty_cache', 'core'), ('remove_locks', 'manage', '', 'remove_locks_desc', '', 2, '', 'MODx.removeLocks();return false;', 'remove_locks', 'core'), ('reports', 'manage', '', 'reports_desc', '', 5, '', '', 'menu_reports', 'core'), ('resource_groups', 'site', 'security/resourcegroup', 'resource_groups_desc', '', 2, '', '', 'access_permissions', 'core'), ('site', 'topnav', '', '', '', 0, '', '', 'menu_site', 'core'), ('site_schedule', 'reports', 'resource/site_schedule', 'site_schedule_desc', '', 0, '', '', 'view_document', 'core'), ('sources', 'media', 'source', 'sources_desc', '', 1, '', '', 'sources', 'core'), ('system_settings', 'admin', 'system/settings', 'system_settings_desc', '', 0, '', '', 'settings', 'core'), ('topnav', '', '', 'topnav_desc', '', 0, '', '', '', 'core'), ('user', 'usernav', '', '', '{$userImage} {$username}', 5, '', '', 'menu_user', 'core'), ('usernav', '', '', 'usernav_desc', '', 0, '', '', '', 'core'), ('users', 'manage', 'security/user', 'user_management_desc', '', 0, '', '', 'view_user', 'core'), ('view_logging', 'reports', 'system/logs', 'view_logging_desc', '', 1, '', '', 'mgr_log_view', 'core'), ('view_sysinfo', 'reports', 'system/info', 'view_sysinfo_desc', '', 3, '', '', 'view_sysinfo', 'core'), ('{$username}', 'user', 'security/profile', 'profile_desc', '', 0, '', '', 'change_profile', 'core'); -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]namespaces` -- CREATE TABLE `[[dbprefix]]namespaces` ( `name` varchar(40) NOT NULL DEFAULT '', `path` text, `assets_path` text, PRIMARY KEY (`name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `[[dbprefix]]namespaces` -- INSERT INTO `[[dbprefix]]namespaces` VALUES ('core', '{core_path}', '{assets_path}'); -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]property_set` -- CREATE TABLE `[[dbprefix]]property_set` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(50) NOT NULL DEFAULT '', `category` int(10) NOT NULL DEFAULT '0', `description` varchar(255) NOT NULL DEFAULT '', `properties` text, PRIMARY KEY (`id`), UNIQUE KEY `name` (`name`), KEY `category` (`category`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]register_messages` -- CREATE TABLE `[[dbprefix]]register_messages` ( `topic` int(10) unsigned NOT NULL, `id` varchar(191) NOT NULL, `created` datetime NOT NULL, `valid` datetime NOT NULL, `accessed` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP, `accesses` int(10) unsigned NOT NULL DEFAULT '0', `expires` int(20) NOT NULL DEFAULT '0', `payload` mediumtext NOT NULL, `kill` tinyint(1) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`topic`,`id`), KEY `created` (`created`), KEY `valid` (`valid`), KEY `accessed` (`accessed`), KEY `accesses` (`accesses`), KEY `expires` (`expires`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]register_queues` -- CREATE TABLE `[[dbprefix]]register_queues` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(191) NOT NULL, `options` mediumtext, PRIMARY KEY (`id`), UNIQUE KEY `name` (`name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]register_topics` -- CREATE TABLE `[[dbprefix]]register_topics` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `queue` int(10) unsigned NOT NULL, `name` varchar(191) NOT NULL, `created` datetime NOT NULL, `updated` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP, `options` mediumtext, PRIMARY KEY (`id`), KEY `queue` (`queue`), KEY `name` (`name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]session` -- CREATE TABLE `[[dbprefix]]session` ( `id` varchar(191) NOT NULL DEFAULT '', `access` int(20) unsigned NOT NULL, `data` mediumtext, PRIMARY KEY (`id`), KEY `access` (`access`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]site_content` -- CREATE TABLE `[[dbprefix]]site_content` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `type` varchar(20) NOT NULL DEFAULT 'document', `pagetitle` varchar(191) NOT NULL DEFAULT '', `longtitle` varchar(191) NOT NULL DEFAULT '', `description` text NOT NULL, `alias` varchar(191) DEFAULT '', `link_attributes` varchar(255) NOT NULL DEFAULT '', `published` tinyint(1) unsigned NOT NULL DEFAULT '0', `pub_date` int(20) NOT NULL DEFAULT '0', `unpub_date` int(20) NOT NULL DEFAULT '0', `parent` int(10) unsigned NOT NULL DEFAULT '0', `isfolder` tinyint(1) unsigned NOT NULL DEFAULT '0', `introtext` text, `content` mediumtext, `richtext` tinyint(1) unsigned NOT NULL DEFAULT '1', `template` int(10) NOT NULL DEFAULT '0', `menuindex` int(10) NOT NULL DEFAULT '0', `searchable` tinyint(1) unsigned NOT NULL DEFAULT '1', `cacheable` tinyint(1) unsigned NOT NULL DEFAULT '1', `createdby` int(10) NOT NULL DEFAULT '0', `createdon` int(20) NOT NULL DEFAULT '0', `editedby` int(10) NOT NULL DEFAULT '0', `editedon` int(20) NOT NULL DEFAULT '0', `deleted` tinyint(1) unsigned NOT NULL DEFAULT '0', `deletedon` int(20) NOT NULL DEFAULT '0', `deletedby` int(10) NOT NULL DEFAULT '0', `publishedon` int(20) NOT NULL DEFAULT '0', `publishedby` int(10) NOT NULL DEFAULT '0', `menutitle` varchar(255) NOT NULL DEFAULT '', `donthit` tinyint(1) unsigned NOT NULL DEFAULT '0', `privateweb` tinyint(1) unsigned NOT NULL DEFAULT '0', `privatemgr` tinyint(1) unsigned NOT NULL DEFAULT '0', `content_dispo` tinyint(1) NOT NULL DEFAULT '0', `hidemenu` tinyint(1) unsigned NOT NULL DEFAULT '0', `class_key` varchar(100) NOT NULL DEFAULT 'MODX\\Revolution\\modDocument', `context_key` varchar(100) NOT NULL DEFAULT 'web', `content_type` int(11) unsigned NOT NULL DEFAULT '1', `uri` text, `uri_override` tinyint(1) NOT NULL DEFAULT '0', `hide_children_in_tree` tinyint(1) NOT NULL DEFAULT '0', `show_in_tree` tinyint(1) NOT NULL DEFAULT '1', `properties` mediumtext, `alias_visible` tinyint(1) unsigned NOT NULL DEFAULT '1', PRIMARY KEY (`id`), KEY `alias` (`alias`), KEY `published` (`published`), KEY `pub_date` (`pub_date`), KEY `unpub_date` (`unpub_date`), KEY `parent` (`parent`), KEY `isfolder` (`isfolder`), KEY `template` (`template`), KEY `menuindex` (`menuindex`), KEY `searchable` (`searchable`), KEY `cacheable` (`cacheable`), KEY `hidemenu` (`hidemenu`), KEY `class_key` (`class_key`), KEY `context_key` (`context_key`), KEY `uri` (`uri`(191)), KEY `uri_override` (`uri_override`), KEY `hide_children_in_tree` (`hide_children_in_tree`), KEY `show_in_tree` (`show_in_tree`), KEY `cache_refresh_idx` (`parent`,`menuindex`,`id`), FULLTEXT KEY `content_ft_idx` (`pagetitle`,`longtitle`,`description`,`introtext`,`content`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ; -- -- Dumping data for table `[[dbprefix]]site_content` -- INSERT INTO `[[dbprefix]]site_content` VALUES (1, 'document', 'Home', 'Congratulations!', '', 'index', '', 1, 0, 0, 0, 0, NULL, '
You have successfully installed MODX Revolution [[++settings_version]]!
\nNow that MODX is installed you can login to the manager to create your templates, manage content and install third party extras to add functionality to your website.
\n\nPages on a MODX site are called Resources, and are visible on the left-hand side of the manager in the Resources tab. Resources can be nested under other resources, making it easy to create a tree of resources. There are different types of resources for different use cases.
\n\nBuilding your website is done through a combination of Templates, Template Variables, Chunks, Snippets and Plugins. Collectively these are known as Elements, and can also be found in the left-hand side of the manager, in the Elements tab.
\n\nTemplates contain the outer markup of any page. Each resource can only be assigned to a single template at a time. By adding Template Variables to a template, you can add custom fields for any resource using that particular template.
\n\nWith Chunks you can share parts of the markup, such as a header, across different templates. Snippets are pieces of PHP that return dynamic content, such as summaries of other resources or the current date. With snippets, you will often use Chunks to mark up the pieces of content it returns, instead of mixing the PHP and HTML.
\n\nFinally, Plugins enable more advanced features by hooking into the extensive events system provided by MODX.
\n\nTo learn more about MODX, be sure to check out the Getting Started section in the official documentation.
\n', 1, 1, 0, 1, 1, 1, [[timestamp]], 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 'MODX\\Revolution\\modDocument', 'web', 1, NULL, 0, 0, 1, NULL, 1); -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]site_htmlsnippets` -- CREATE TABLE `[[dbprefix]]site_htmlsnippets` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `source` int(10) unsigned NOT NULL DEFAULT '0', `property_preprocess` tinyint(1) unsigned NOT NULL DEFAULT '0', `name` varchar(50) NOT NULL DEFAULT '', `description` varchar(255) NOT NULL DEFAULT 'Chunk', `editor_type` int(11) NOT NULL DEFAULT '0', `category` int(11) NOT NULL DEFAULT '0', `cache_type` tinyint(1) NOT NULL DEFAULT '0', `snippet` mediumtext, `locked` tinyint(1) unsigned NOT NULL DEFAULT '0', `properties` text, `static` tinyint(1) unsigned NOT NULL DEFAULT '0', `static_file` varchar(255) NOT NULL DEFAULT '', PRIMARY KEY (`id`), UNIQUE KEY `name` (`name`), KEY `category` (`category`), KEY `locked` (`locked`), KEY `static` (`static`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]site_plugins` -- CREATE TABLE `[[dbprefix]]site_plugins` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `source` int(10) unsigned NOT NULL DEFAULT '0', `property_preprocess` tinyint(1) unsigned NOT NULL DEFAULT '0', `name` varchar(50) NOT NULL DEFAULT '', `description` varchar(255) NOT NULL DEFAULT '', `editor_type` int(11) NOT NULL DEFAULT '0', `category` int(11) NOT NULL DEFAULT '0', `cache_type` tinyint(1) NOT NULL DEFAULT '0', `plugincode` mediumtext NOT NULL, `locked` tinyint(1) unsigned NOT NULL DEFAULT '0', `properties` text, `disabled` tinyint(1) unsigned NOT NULL DEFAULT '0', `moduleguid` varchar(32) NOT NULL DEFAULT '', `static` tinyint(1) unsigned NOT NULL DEFAULT '0', `static_file` varchar(255) NOT NULL DEFAULT '', PRIMARY KEY (`id`), UNIQUE KEY `name` (`name`), KEY `category` (`category`), KEY `locked` (`locked`), KEY `disabled` (`disabled`), KEY `static` (`static`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]site_plugin_events` -- CREATE TABLE `[[dbprefix]]site_plugin_events` ( `pluginid` int(10) NOT NULL DEFAULT '0', `event` varchar(191) NOT NULL DEFAULT '', `priority` int(10) NOT NULL DEFAULT '0', `propertyset` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`pluginid`,`event`), KEY `priority` (`priority`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]site_snippets` -- CREATE TABLE `[[dbprefix]]site_snippets` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `source` int(10) unsigned NOT NULL DEFAULT '0', `property_preprocess` tinyint(1) unsigned NOT NULL DEFAULT '0', `name` varchar(50) NOT NULL DEFAULT '', `description` varchar(255) NOT NULL DEFAULT '', `editor_type` int(11) NOT NULL DEFAULT '0', `category` int(11) NOT NULL DEFAULT '0', `cache_type` tinyint(1) NOT NULL DEFAULT '0', `snippet` mediumtext, `locked` tinyint(1) unsigned NOT NULL DEFAULT '0', `properties` text, `moduleguid` varchar(32) NOT NULL DEFAULT '', `static` tinyint(1) unsigned NOT NULL DEFAULT '0', `static_file` varchar(255) NOT NULL DEFAULT '', PRIMARY KEY (`id`), UNIQUE KEY `name` (`name`), KEY `category` (`category`), KEY `locked` (`locked`), KEY `moduleguid` (`moduleguid`), KEY `static` (`static`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]site_templates` -- CREATE TABLE `[[dbprefix]]site_templates` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `source` int(10) unsigned NOT NULL DEFAULT '0', `property_preprocess` tinyint(1) unsigned NOT NULL DEFAULT '0', `templatename` varchar(50) NOT NULL DEFAULT '', `description` varchar(255) NOT NULL DEFAULT '', `editor_type` int(11) NOT NULL DEFAULT '0', `category` int(11) NOT NULL DEFAULT '0', `icon` varchar(255) NOT NULL DEFAULT '', `template_type` int(11) NOT NULL DEFAULT '0', `content` mediumtext NOT NULL, `locked` tinyint(1) unsigned NOT NULL DEFAULT '0', `properties` text, `static` tinyint(1) unsigned NOT NULL DEFAULT '0', `static_file` varchar(255) NOT NULL DEFAULT '', `preview_file` varchar(191) NOT NULL DEFAULT '', PRIMARY KEY (`id`), UNIQUE KEY `templatename` (`templatename`), KEY `category` (`category`), KEY `locked` (`locked`), KEY `static` (`static`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ; -- -- Dumping data for table `[[dbprefix]]site_templates` -- INSERT INTO `[[dbprefix]]site_templates` VALUES (1, 0, 0, 'BaseTemplate', '', 0, 0, '', 0, '\n\n\n