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]]!

\n

Now 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\n

New to MODX?

\n\n

Pages 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\n

Building 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\n

Templates 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\n

With 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\n

Finally, Plugins enable more advanced features by hooking into the extensive events system provided by MODX.

\n\n

To 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 [[*pagetitle]] - [[++site_name]]\n \n \n \n \n\n \n\n\n\n
\n
\n

[[*longtitle:default=`[[*pagetitle]]`]]

\n [[*content]]\n
\n \n
\n

Extend MODX with Extras

\n \n
\n
\n\n\n\n\n\n\n', 0, NULL, 0, '', ''); -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]site_tmplvars` -- CREATE TABLE `[[dbprefix]]site_tmplvars` ( `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', `type` varchar(20) NOT NULL DEFAULT '', `name` varchar(50) NOT NULL DEFAULT '', `caption` varchar(80) NOT NULL DEFAULT '', `description` varchar(255) NOT NULL DEFAULT '', `editor_type` int(11) NOT NULL DEFAULT '0', `category` int(11) NOT NULL DEFAULT '0', `locked` tinyint(1) unsigned NOT NULL DEFAULT '0', `elements` text, `rank` int(11) NOT NULL DEFAULT '0', `display` varchar(20) NOT NULL DEFAULT '', `default_text` mediumtext, `properties` text, `input_properties` text, `output_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 `rank` (`rank`), KEY `static` (`static`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]site_tmplvar_access` -- CREATE TABLE `[[dbprefix]]site_tmplvar_access` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `tmplvarid` int(10) unsigned NOT NULL DEFAULT '0', `documentgroup` int(10) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `tmplvar_template` (`tmplvarid`,`documentgroup`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]site_tmplvar_contentvalues` -- CREATE TABLE `[[dbprefix]]site_tmplvar_contentvalues` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `tmplvarid` int(10) unsigned NOT NULL DEFAULT '0', `contentid` int(10) unsigned NOT NULL DEFAULT '0', `value` mediumtext NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `tv_cnt` (`tmplvarid`,`contentid`), KEY `tmplvarid` (`tmplvarid`), KEY `contentid` (`contentid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]site_tmplvar_templates` -- CREATE TABLE `[[dbprefix]]site_tmplvar_templates` ( `tmplvarid` int(10) unsigned NOT NULL DEFAULT '0', `templateid` int(11) unsigned NOT NULL DEFAULT '0', `rank` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`tmplvarid`,`templateid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]system_eventnames` -- CREATE TABLE `[[dbprefix]]system_eventnames` ( `name` varchar(50) NOT NULL, `service` tinyint(4) unsigned NOT NULL DEFAULT '0', `groupname` varchar(20) NOT NULL DEFAULT '', PRIMARY KEY (`name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `[[dbprefix]]system_eventnames` -- INSERT INTO `[[dbprefix]]system_eventnames` VALUES ('OnBeforeCacheUpdate', 4, 'System'), ('OnBeforeChunkFormDelete', 1, 'Chunks'), ('OnBeforeChunkFormSave', 1, 'Chunks'), ('OnBeforeDocFormDelete', 1, 'Resources'), ('OnBeforeDocFormSave', 1, 'Resources'), ('OnBeforeEmptyTrash', 1, 'Resources'), ('OnBeforeManagerLogin', 2, 'Security'), ('OnBeforeManagerLogout', 2, 'Security'), ('OnBeforeManagerPageInit', 2, 'System'), ('OnBeforePluginFormDelete', 1, 'Plugins'), ('OnBeforePluginFormSave', 1, 'Plugins'), ('OnBeforeRegisterClientScripts', 5, 'System'), ('OnBeforeSaveWebPageCache', 4, 'System'), ('OnBeforeSnipFormDelete', 1, 'Snippets'), ('OnBeforeSnipFormSave', 1, 'Snippets'), ('OnBeforeTempFormDelete', 1, 'Templates'), ('OnBeforeTempFormSave', 1, 'Templates'), ('OnBeforeTVFormDelete', 1, 'Template Variables'), ('OnBeforeTVFormSave', 1, 'Template Variables'), ('OnBeforeUserActivate', 1, 'Users'), ('OnBeforeUserDeactivate', 1, 'Users'), ('OnBeforeUserDuplicate', 1, 'Users'), ('OnBeforeUserFormDelete', 1, 'Users'), ('OnBeforeUserFormSave', 1, 'Users'), ('OnBeforeUserGroupFormRemove', 1, 'User Groups'), ('OnBeforeUserGroupFormSave', 1, 'User Groups'), ('OnBeforeWebLogin', 3, 'Security'), ('OnBeforeWebLogout', 3, 'Security'), ('OnCacheUpdate', 4, 'System'), ('OnCategoryBeforeRemove', 1, 'Categories'), ('OnCategoryBeforeSave', 1, 'Categories'), ('OnCategoryRemove', 1, 'Categories'), ('OnCategorySave', 1, 'Categories'), ('OnChunkBeforeRemove', 1, 'Chunks'), ('OnChunkBeforeSave', 1, 'Chunks'), ('OnChunkFormDelete', 1, 'Chunks'), ('OnChunkFormPrerender', 1, 'Chunks'), ('OnChunkFormRender', 1, 'Chunks'), ('OnChunkFormSave', 1, 'Chunks'), ('OnChunkRemove', 1, 'Chunks'), ('OnChunkSave', 1, 'Chunks'), ('OnContextBeforeRemove', 1, 'Contexts'), ('OnContextBeforeSave', 1, 'Contexts'), ('OnContextFormPrerender', 2, 'Contexts'), ('OnContextFormRender', 2, 'Contexts'), ('OnContextRemove', 1, 'Contexts'), ('OnContextSave', 1, 'Contexts'), ('OnDocFormDelete', 1, 'Resources'), ('OnDocFormPrerender', 1, 'Resources'), ('OnDocFormRender', 1, 'Resources'), ('OnDocFormSave', 1, 'Resources'), ('OnDocPublished', 5, 'Resources'), ('OnDocUnPublished', 5, 'Resources'), ('OnElementNotFound', 1, 'System'), ('OnEmptyTrash', 1, 'Resources'), ('OnFileCreateFormPrerender', 1, 'System'), ('OnFileEditFormPrerender', 1, 'System'), ('OnFileManagerBeforeUpload', 1, 'System'), ('OnFileManagerDirCreate', 1, 'System'), ('OnFileManagerDirRemove', 1, 'System'), ('OnFileManagerDirRename', 1, 'System'), ('OnFileManagerFileCreate', 1, 'System'), ('OnFileManagerFileRemove', 1, 'System'), ('OnFileManagerFileRename', 1, 'System'), ('OnFileManagerFileUpdate', 1, 'System'), ('OnFileManagerMoveObject', 1, 'System'), ('OnFileManagerUpload', 1, 'System'), ('OnHandleRequest', 5, 'System'), ('OnInitCulture', 1, 'Internationalization'), ('OnLoadWebDocument', 5, 'System'), ('OnLoadWebPageCache', 4, 'System'), ('OnManagerAuthentication', 2, 'Security'), ('OnManagerLogin', 2, 'Security'), ('OnManagerLoginFormPrerender', 2, 'Security'), ('OnManagerLoginFormRender', 2, 'Security'), ('OnManagerLogout', 2, 'Security'), ('OnManagerPageAfterRender', 2, 'System'), ('OnManagerPageBeforeRender', 2, 'System'), ('OnManagerPageInit', 2, 'System'), ('OnMediaSourceBeforeFormDelete', 1, 'Media Sources'), ('OnMediaSourceBeforeFormSave', 1, 'Media Sources'), ('OnMediaSourceDuplicate', 1, 'Media Sources'), ('OnMediaSourceFormDelete', 1, 'Media Sources'), ('OnMediaSourceFormSave', 1, 'Media Sources'), ('OnMediaSourceGetProperties', 1, 'Media Sources'), ('OnMODXInit', 5, 'System'), ('OnPackageInstall', 2, 'Package Manager'), ('OnPackageRemove', 2, 'Package Manager'), ('OnPackageUninstall', 2, 'Package Manager'), ('OnPageNotFound', 1, 'System'), ('OnPageUnauthorized', 1, 'Security'), ('OnParseDocument', 5, 'System'), ('OnPluginBeforeRemove', 1, 'Plugins'), ('OnPluginBeforeSave', 1, 'Plugins'), ('OnPluginEventBeforeRemove', 1, 'Plugin Events'), ('OnPluginEventBeforeSave', 1, 'Plugin Events'), ('OnPluginEventRemove', 1, 'Plugin Events'), ('OnPluginEventSave', 1, 'Plugin Events'), ('OnPluginFormDelete', 1, 'Plugins'), ('OnPluginFormPrerender', 1, 'Plugins'), ('OnPluginFormRender', 1, 'Plugins'), ('OnPluginFormSave', 1, 'Plugins'), ('OnPluginRemove', 1, 'Plugins'), ('OnPluginSave', 1, 'Plugins'), ('OnPropertySetBeforeRemove', 1, 'Property Sets'), ('OnPropertySetBeforeSave', 1, 'Property Sets'), ('OnPropertySetRemove', 1, 'Property Sets'), ('OnPropertySetSave', 1, 'Property Sets'), ('OnResourceAddToResourceGroup', 1, 'Resources'), ('OnResourceAutoPublish', 1, 'Resources'), ('OnResourceBeforeSort', 1, 'Resources'), ('OnResourceCacheUpdate', 1, 'Resources'), ('OnResourceDelete', 1, 'Resources'), ('OnResourceDuplicate', 1, 'Resources'), ('OnResourceGroupBeforeRemove', 1, 'Security'), ('OnResourceGroupBeforeSave', 1, 'Security'), ('OnResourceGroupRemove', 1, 'Security'), ('OnResourceGroupSave', 1, 'Security'), ('OnResourceRemoveFromResourceGroup', 1, 'Resources'), ('OnResourceSort', 1, 'Resources'), ('OnResourceToolbarLoad', 1, 'Resources'), ('OnResourceTVFormPrerender', 1, 'Resources'), ('OnResourceTVFormRender', 1, 'Resources'), ('OnResourceUndelete', 1, 'Resources'), ('OnRichTextBrowserInit', 1, 'RichText Editor'), ('OnRichTextEditorInit', 1, 'RichText Editor'), ('OnRichTextEditorRegister', 1, 'RichText Editor'), ('OnSiteRefresh', 1, 'System'), ('OnSiteSettingsRender', 1, 'Settings'), ('OnSnipFormDelete', 1, 'Snippets'), ('OnSnipFormPrerender', 1, 'Snippets'), ('OnSnipFormRender', 1, 'Snippets'), ('OnSnipFormSave', 1, 'Snippets'), ('OnSnippetBeforeRemove', 1, 'Snippets'), ('OnSnippetBeforeSave', 1, 'Snippets'), ('OnSnippetRemove', 1, 'Snippets'), ('OnSnippetSave', 1, 'Snippets'), ('OnTempFormDelete', 1, 'Templates'), ('OnTempFormPrerender', 1, 'Templates'), ('OnTempFormRender', 1, 'Templates'), ('OnTempFormSave', 1, 'Templates'), ('OnTemplateBeforeRemove', 1, 'Templates'), ('OnTemplateBeforeSave', 1, 'Templates'), ('OnTemplateRemove', 1, 'Templates'), ('OnTemplateSave', 1, 'Templates'), ('OnTemplateVarBeforeRemove', 1, 'Template Variables'), ('OnTemplateVarBeforeSave', 1, 'Template Variables'), ('OnTemplateVarRemove', 1, 'Template Variables'), ('OnTemplateVarSave', 1, 'Template Variables'), ('OnTVFormDelete', 1, 'Template Variables'), ('OnTVFormPrerender', 1, 'Template Variables'), ('OnTVFormRender', 1, 'Template Variables'), ('OnTVFormSave', 1, 'Template Variables'), ('OnTVInputPropertiesList', 1, 'Template Variables'), ('OnTVInputRenderList', 1, 'Template Variables'), ('OnTVOutputRenderList', 1, 'Template Variables'), ('OnTVOutputRenderPropertiesList', 1, 'Template Variables'), ('OnUserActivate', 1, 'Users'), ('OnUserAddToGroup', 1, 'User Groups'), ('OnUserBeforeAddToGroup', 1, 'User Groups'), ('OnUserBeforeRemove', 1, 'Users'), ('OnUserBeforeRemoveFromGroup', 1, 'User Groups'), ('OnUserBeforeSave', 1, 'Users'), ('OnUserChangePassword', 1, 'Users'), ('OnUserDeactivate', 1, 'Users'), ('OnUserDuplicate', 1, 'Users'), ('OnUserFormDelete', 1, 'Users'), ('OnUserFormPrerender', 1, 'Users'), ('OnUserFormRender', 1, 'Users'), ('OnUserFormSave', 1, 'Users'), ('OnUserGroupBeforeRemove', 1, 'User Groups'), ('OnUserGroupBeforeSave', 1, 'User Groups'), ('OnUserGroupFormSave', 1, 'User Groups'), ('OnUserGroupRemove', 1, 'User Groups'), ('OnUserGroupSave', 1, 'User Groups'), ('OnUserNotFound', 1, 'Users'), ('OnUserProfileBeforeRemove', 1, 'User Profiles'), ('OnUserProfileBeforeSave', 1, 'User Profiles'), ('OnUserProfileRemove', 1, 'User Profiles'), ('OnUserProfileSave', 1, 'User Profiles'), ('OnUserRemove', 1, 'Users'), ('OnUserRemoveFromGroup', 1, 'User Groups'), ('OnUserSave', 1, 'Users'), ('OnWebAuthentication', 3, 'Security'), ('OnWebLogin', 3, 'Security'), ('OnWebLogout', 3, 'Security'), ('OnWebPageComplete', 5, 'System'), ('OnWebPageInit', 5, 'System'), ('OnWebPagePrerender', 5, 'System'); -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]system_settings` -- CREATE TABLE `[[dbprefix]]system_settings` ( `key` varchar(50) NOT NULL DEFAULT '', `value` text NOT NULL, `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 (`key`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `[[dbprefix]]system_settings` -- INSERT INTO `[[dbprefix]]system_settings` VALUES ('access_category_enabled', '1', 'combo-boolean', 'core', 'authentication', NULL), ('access_context_enabled', '1', 'combo-boolean', 'core', 'authentication', NULL), ('access_resource_group_enabled', '1', 'combo-boolean', 'core', 'authentication', NULL), ('allow_forward_across_contexts', '', 'combo-boolean', 'core', 'system', NULL), ('allow_manager_login_forgot_password', '1', 'combo-boolean', 'core', 'authentication', NULL), ('allow_multiple_emails', '1', 'combo-boolean', 'core', 'authentication', NULL), ('allow_tags_in_post', '', 'combo-boolean', 'core', 'system', NULL), ('anonymous_sessions', '1', 'combo-boolean', 'core', 'session', NULL), ('archive_with', '', 'combo-boolean', 'core', 'system', NULL), ('automatic_alias', '1', 'combo-boolean', 'core', 'furls', NULL), ('automatic_template_assignment', 'sibling', 'textfield', 'core', 'site', NULL), ('auto_check_pkg_updates', '1', 'combo-boolean', 'core', 'system', NULL), ('auto_check_pkg_updates_cache_expire', '15', 'numberfield', 'core', 'system', NULL), ('auto_isfolder', '1', 'combo-boolean', 'core', 'site', NULL), ('auto_menuindex', '1', 'combo-boolean', 'core', 'site', NULL), ('base_help_url', '//docs.modx.com/help/', 'textfield', 'core', 'manager', NULL), ('blocked_minutes', '60', 'numberfield', 'core', 'authentication', NULL), ('cache_alias_map', '1', 'combo-boolean', 'core', 'caching', NULL), ('cache_context_settings', '1', 'combo-boolean', 'core', 'caching', NULL), ('cache_db', '', 'combo-boolean', 'core', 'caching', NULL), ('cache_db_expires', '0', 'numberfield', 'core', 'caching', NULL), ('cache_db_session', '', 'combo-boolean', 'core', 'caching', NULL), ('cache_db_session_lifetime', '', 'numberfield', 'core', 'caching', NULL), ('cache_default', '1', 'combo-boolean', 'core', 'caching', NULL), ('cache_expires', '0', 'numberfield', 'core', 'caching', NULL), ('cache_format', '0', 'numberfield', 'core', 'caching', NULL), ('cache_handler', 'xPDO\\Cache\\xPDOFileCache', 'textfield', 'core', 'caching', NULL), ('cache_lang_js', '1', 'combo-boolean', 'core', 'caching', NULL), ('cache_lexicon_topics', '1', 'combo-boolean', 'core', 'caching', NULL), ('cache_noncore_lexicon_topics', '1', 'combo-boolean', 'core', 'caching', NULL), ('cache_resource', '1', 'combo-boolean', 'core', 'caching', NULL), ('cache_resource_clear_partial', '', 'combo-boolean', 'core', 'caching', NULL), ('cache_resource_expires', '0', 'numberfield', 'core', 'caching', NULL), ('cache_scripts', '1', 'combo-boolean', 'core', 'caching', NULL), ('clear_cache_refresh_trees', '', 'combo-boolean', 'core', 'caching', NULL), ('compress_css', '1', 'combo-boolean', 'core', 'manager', NULL), ('compress_js', '1', 'combo-boolean', 'core', 'manager', NULL), ('confirm_navigation', '1', 'combo-boolean', 'core', 'manager', NULL), ('container_suffix', '/', 'textfield', 'core', 'furls', NULL), ('context_tree_sort', '1', 'combo-boolean', 'core', 'manager', NULL), ('context_tree_sortby', 'rank', 'textfield', 'core', 'manager', NULL), ('context_tree_sortdir', 'ASC', 'textfield', 'core', 'manager', NULL), ('cultureKey', 'en', 'modx-combo-language', 'core', 'language', NULL), ('date_timezone', '', 'textfield', 'core', 'system', NULL), ('debug', '', 'numberfield', 'core', 'system', NULL), ('default_content_type', '1', 'modx-combo-content-type', 'core', 'site', NULL), ('default_context', 'web', 'modx-combo-context', 'core', 'site', NULL), ('default_duplicate_publish_option', 'preserve', 'textfield', 'core', 'manager', NULL), ('default_media_source', '1', 'modx-combo-source', 'core', 'manager', NULL), ('default_media_source_type', 'MODX\\Revolution\\Sources\\modFileMediaSource', 'modx-combo-source-type', 'core', 'manager', NULL), ('default_per_page', '20', 'textfield', 'core', 'manager', NULL), ('default_template', '1', 'modx-combo-template', 'core', 'site', NULL), ('default_username', '(anonymous)', 'textfield', 'core', 'session', NULL), ('emailsender', '[[admin_email]]', 'textfield', 'core', 'authentication', '[[regtime]]'), ('enable_dragdrop', '1', 'combo-boolean', 'core', 'manager', NULL), ('enable_gravatar', '', 'combo-boolean', 'core', 'manager', NULL), ('enable_template_picker_in_tree', '1', 'combo-boolean', 'core', 'manager', NULL), ('error_log_filename', 'error.log', 'textfield', 'core', 'system', NULL), ('error_log_filepath', '', 'textfield', 'core', 'system', NULL), ('error_page', '1', 'numberfield', 'core', 'site', NULL), ('failed_login_attempts', '5', 'numberfield', 'core', 'authentication', NULL), ('feed_modx_news', 'https://feeds.feedburner.com/modx-announce', 'textfield', 'core', 'system', NULL), ('feed_modx_news_enabled', '1', 'combo-boolean', 'core', 'system', NULL), ('feed_modx_security', 'https://forums.modx.com/board.xml?board=294', 'textfield', 'core', 'system', NULL), ('feed_modx_security_enabled', '1', 'combo-boolean', 'core', 'system', NULL), ('form_customization_use_all_groups', '', 'combo-boolean', 'core', 'manager', NULL), ('forward_merge_excludes', 'type,published,class_key', 'textfield', 'core', 'system', NULL), ('friendly_alias_lowercase_only', '1', 'combo-boolean', 'core', 'furls', NULL), ('friendly_alias_max_length', '0', 'numberfield', 'core', 'furls', NULL), ('friendly_alias_realtime', '', 'combo-boolean', 'core', 'furls', NULL), ('friendly_alias_restrict_chars', 'pattern', 'textfield', 'core', 'furls', NULL), ('friendly_alias_restrict_chars_pattern', '/[\\0\\x0B\\t\\n\\r\\f\\a&=+%#<>"~:`@\\?\\[\\]\\{\\}\\|\\^''\\\\]/', 'textfield', 'core', 'furls', NULL), ('friendly_alias_strip_element_tags', '1', 'combo-boolean', 'core', 'furls', NULL), ('friendly_alias_translit', 'none', 'textfield', 'core', 'furls', NULL), ('friendly_alias_translit_class', 'translit.modTransliterate', 'textfield', 'core', 'furls', NULL), ('friendly_alias_translit_class_path', '{core_path}components/', 'textfield', 'core', 'furls', NULL), ('friendly_alias_trim_chars', '/.-_', 'textfield', 'core', 'furls', NULL), ('friendly_alias_word_delimiter', '-', 'textfield', 'core', 'furls', NULL), ('friendly_alias_word_delimiters', '-_', 'textfield', 'core', 'furls', NULL), ('friendly_urls', '', 'combo-boolean', 'core', 'furls', NULL), ('friendly_urls_strict', '', 'combo-boolean', 'core', 'furls', NULL), ('global_duplicate_uri_check', '', 'combo-boolean', 'core', 'furls', NULL), ('hidemenu_default', '', 'combo-boolean', 'core', 'site', NULL), ('inline_help', '1', 'combo-boolean', 'core', 'manager', NULL), ('link_tag_scheme', '-1', 'textfield', 'core', 'site', NULL), ('locale', '', 'textfield', 'core', 'language', NULL), ('lock_ttl', '360', 'numberfield', 'core', 'system', NULL), ('login_background_image', '', 'textfield', 'core', 'authentication', NULL), ('login_help_button', '', 'combo-boolean', 'core', 'authentication', NULL), ('login_logo', '', 'textfield', 'core', 'authentication', NULL), ('log_deprecated', '1', 'combo-boolean', 'core', 'system', NULL), ('log_level', '1', 'numberfield', 'core', 'system', NULL), ('log_snippet_not_found', '1', 'combo-boolean', 'core', 'site', NULL), ('log_target', 'FILE', 'textfield', 'core', 'system', NULL), ('mail_charset', 'UTF-8', 'modx-combo-charset', 'core', 'mail', NULL), ('mail_encoding', '8bit', 'textfield', 'core', 'mail', NULL), ('mail_smtp_auth', '', 'combo-boolean', 'core', 'mail', NULL), ('mail_smtp_autotls', '1', 'combo-boolean', 'core', 'mail', NULL), ('mail_smtp_helo', '', 'textfield', 'core', 'mail', NULL), ('mail_smtp_hosts', 'localhost', 'textfield', 'core', 'mail', NULL), ('mail_smtp_keepalive', '', 'combo-boolean', 'core', 'mail', NULL), ('mail_smtp_pass', '', 'text-password', 'core', 'mail', NULL), ('mail_smtp_port', '587', 'numberfield', 'core', 'mail', NULL), ('mail_smtp_secure', '', 'textfield', 'core', 'mail', NULL), ('mail_smtp_single_to', '', 'combo-boolean', 'core', 'mail', NULL), ('mail_smtp_timeout', '10', 'numberfield', 'core', 'mail', NULL), ('mail_smtp_user', '', 'textfield', 'core', 'mail', NULL), ('mail_use_smtp', '', 'combo-boolean', 'core', 'mail', NULL), ('main_nav_parent', 'topnav', 'textfield', 'core', 'manager', NULL), ('manager_date_format', 'Y-m-d', 'textfield', 'core', 'manager', NULL), ('manager_direction', 'ltr', 'textfield', 'core', 'language', NULL), ('manager_favicon_url', 'favicon.ico', 'textfield', 'core', 'manager', NULL), ('manager_login_url_alternate', '', 'textfield', 'core', 'authentication', NULL), ('manager_logo', '', 'textfield', 'core', 'manager', NULL), ('manager_theme', 'default', 'modx-combo-manager-theme', 'core', 'manager', NULL), ('manager_time_format', 'H:i', 'textfield', 'core', 'manager', NULL), ('manager_tooltip_delay', '2300', 'numberfield', 'core', 'manager', NULL), ('manager_tooltip_enable', '1', 'combo-boolean', 'core', 'manager', NULL), ('manager_use_fullname', '', 'combo-boolean', 'core', 'manager', NULL), ('manager_week_start', '0', 'numberfield', 'core', 'manager', NULL), ('mgr_source_icon', 'icon-folder-open-o', 'textfield', 'core', 'manager', NULL), ('mgr_tree_icon_context', 'tree-context', 'textfield', 'core', 'manager', NULL), ('modx_browser_default_sort', 'name', 'textfield', 'core', 'manager', NULL), ('modx_browser_default_viewmode', 'grid', 'textfield', 'core', 'manager', NULL), ('modx_browser_tree_hide_files', '1', 'combo-boolean', 'core', 'manager', NULL), ('modx_browser_tree_hide_tooltips', '1', 'combo-boolean', 'core', 'manager', NULL), ('modx_charset', 'UTF-8', 'modx-combo-charset', 'core', 'language', NULL), ('parser_recurse_uncacheable', '1', 'combo-boolean', 'core', 'system', NULL), ('passwordless_activated', '', 'combo-boolean', 'core', 'authentication', NULL), ('passwordless_expiration', '3600', 'textfield', 'core', 'authentication', NULL), ('password_generated_length', '10', 'numberfield', 'core', 'authentication', NULL), ('password_min_length', '8', 'numberfield', 'core', 'authentication', NULL), ('photo_profile_source', '', 'modx-combo-source', 'core', 'manager', NULL), ('phpthumb_allow_src_above_docroot', '', 'combo-boolean', 'core', 'phpthumb', NULL), ('phpthumb_cache_maxage', '30', 'numberfield', 'core', 'phpthumb', NULL), ('phpthumb_cache_maxfiles', '10000', 'numberfield', 'core', 'phpthumb', NULL), ('phpthumb_cache_maxsize', '100', 'numberfield', 'core', 'phpthumb', NULL), ('phpthumb_cache_source_enabled', '', 'combo-boolean', 'core', 'phpthumb', NULL), ('phpthumb_document_root', '', 'textfield', 'core', 'phpthumb', NULL), ('phpthumb_error_bgcolor', 'CCCCFF', 'textfield', 'core', 'phpthumb', NULL), ('phpthumb_error_fontsize', '1', 'numberfield', 'core', 'phpthumb', NULL), ('phpthumb_error_textcolor', 'FF0000', 'textfield', 'core', 'phpthumb', NULL), ('phpthumb_far', 'C', 'textfield', 'core', 'phpthumb', NULL), ('phpthumb_imagemagick_path', '', 'textfield', 'core', 'phpthumb', NULL), ('phpthumb_nohotlink_enabled', '1', 'combo-boolean', 'core', 'phpthumb', NULL), ('phpthumb_nohotlink_erase_image', '1', 'combo-boolean', 'core', 'phpthumb', NULL), ('phpthumb_nohotlink_text_message', 'Off-server thumbnailing is not allowed', 'textfield', 'core', 'phpthumb', NULL), ('phpthumb_nohotlink_valid_domains', '{http_host}', 'textfield', 'core', 'phpthumb', NULL), ('phpthumb_nooffsitelink_enabled', '', 'combo-boolean', 'core', 'phpthumb', NULL), ('phpthumb_nooffsitelink_erase_image', '1', 'combo-boolean', 'core', 'phpthumb', NULL), ('phpthumb_nooffsitelink_require_refer', '', 'combo-boolean', 'core', 'phpthumb', NULL), ('phpthumb_nooffsitelink_text_message', 'Off-server linking is not allowed', 'textfield', 'core', 'phpthumb', NULL), ('phpthumb_nooffsitelink_valid_domains', '{http_host}', 'textfield', 'core', 'phpthumb', NULL), ('phpthumb_nooffsitelink_watermark_src', '', 'textfield', 'core', 'phpthumb', NULL), ('phpthumb_zoomcrop', '0', 'textfield', 'core', 'phpthumb', NULL), ('preserve_menuindex', '', 'combo-boolean', 'core', 'manager', NULL), ('principal_targets', 'MODX\\Revolution\\modAccessContext,MODX\\Revolution\\modAccessResourceGroup,MODX\\Revolution\\modAccessCategory,MODX\\Revolution\\Sources\\modAccessMediaSource,MODX\\Revolution\\modAccessNamespace', 'textfield', 'core', 'authentication', NULL), ('proxy_auth_type', 'BASIC', 'textfield', 'core', 'proxy', NULL), ('proxy_host', '', 'textfield', 'core', 'proxy', NULL), ('proxy_password', '', 'text-password', 'core', 'proxy', NULL), ('proxy_port', '', 'numberfield', 'core', 'proxy', NULL), ('proxy_username', '', 'textfield', 'core', 'proxy', NULL), ('publish_default', '', 'combo-boolean', 'core', 'site', NULL), ('quick_search_in_content', '1', 'combo-boolean', 'core', 'manager', NULL), ('quick_search_result_max', '10', 'numberfield', 'core', 'manager', NULL), ('request_controller', 'index.php', 'textfield', 'core', 'gateway', NULL), ('request_method_strict', '', 'combo-boolean', 'core', 'gateway', NULL), ('request_param_alias', 'q', 'textfield', 'core', 'gateway', NULL), ('request_param_id', 'id', 'textfield', 'core', 'gateway', NULL), ('resource_static_allow_absolute', '0', 'combo-boolean', 'core', 'static_resources', NULL), ('resource_static_path', '{assets_path}', 'textfield', 'core', 'static_resources', NULL), ('resource_tree_node_name', 'pagetitle', 'textfield', 'core', 'manager', NULL), ('resource_tree_node_name_fallback', 'alias', 'textfield', 'core', 'manager', NULL), ('resource_tree_node_tooltip', '', 'textfield', 'core', 'manager', NULL), ('richtext_default', '1', 'combo-boolean', 'core', 'manager', NULL), ('search_default', '1', 'combo-boolean', 'core', 'site', NULL), ('send_poweredby_header', '1', 'combo-boolean', 'core', 'system', '[[regtime]]'), ('server_offset_time', '0', 'numberfield', 'core', 'system', NULL), ('session_cookie_domain', '', 'textfield', 'core', 'session', NULL), ('session_cookie_httponly', '1', 'combo-boolean', 'core', 'session', NULL), ('session_cookie_lifetime', '604800', 'numberfield', 'core', 'session', NULL), ('session_cookie_path', '', 'textfield', 'core', 'session', NULL), ('session_cookie_samesite', '', 'textfield', 'core', 'session', NULL), ('session_cookie_secure', '', 'combo-boolean', 'core', 'session', NULL), ('session_gc_maxlifetime', '604800', 'textfield', 'core', 'session', NULL), ('session_handler_class', 'MODX\\Revolution\\modSessionHandler', 'textfield', 'core', 'session', NULL), ('session_name', '', 'textfield', 'core', 'session', NULL), ('settings_distro', 'traditional', 'textfield', 'core', 'system', NULL), ('settings_version', '3.0.5-pl', 'textfield', 'core', 'system', NULL), ('set_header', '1', 'combo-boolean', 'core', 'system', NULL), ('show_tv_categories_header', '1', 'combo-boolean', 'core', 'manager', NULL), ('site_name', 'MODX Revolution', 'textfield', 'core', 'site', NULL), ('site_start', '1', 'numberfield', 'core', 'site', NULL), ('site_status', '1', 'combo-boolean', 'core', 'site', NULL), ('site_unavailable_message', '[[%site_unavailable_message]]', 'textfield', 'core', 'site', NULL), ('site_unavailable_page', '0', 'numberfield', 'core', 'site', NULL), ('static_elements_automate_chunks', '', 'combo-boolean', 'core', 'static_elements', NULL), ('static_elements_automate_plugins', '', 'combo-boolean', 'core', 'static_elements', NULL), ('static_elements_automate_snippets', '', 'combo-boolean', 'core', 'static_elements', NULL), ('static_elements_automate_templates', '', 'combo-boolean', 'core', 'static_elements', NULL), ('static_elements_automate_tvs', '', 'combo-boolean', 'core', 'static_elements', NULL), ('static_elements_basepath', '', 'textfield', 'core', 'static_elements', NULL), ('static_elements_default_category', '0', 'modx-combo-category', 'core', 'static_elements', NULL), ('static_elements_default_mediasource', '0', 'modx-combo-source', 'core', 'static_elements', NULL), ('static_elements_html_extension', '.tpl', 'textfield', 'core', 'static_elements', NULL), ('symlink_merge_fields', '1', 'combo-boolean', 'core', 'site', NULL), ('syncsite_default', '1', 'combo-boolean', 'core', 'caching', NULL), ('topmenu_show_descriptions', '1', 'combo-boolean', 'core', 'manager', NULL), ('tree_default_sort', 'menuindex', 'textfield', 'core', 'manager', NULL), ('tree_root_id', '0', 'numberfield', 'core', 'manager', NULL), ('tvs_below_content', '', 'combo-boolean', 'core', 'manager', NULL), ('unauthorized_page', '1', 'numberfield', 'core', 'site', NULL), ('upload_files', 'txt,html,htm,xml,js,js.map,css,scss,less,css.map,zip,gz,rar,z,tgz,tar,mp3,mp4,aac,wav,au,wmv,avi,mpg,mpeg,pdf,doc,docx,xls,xlsx,ppt,pptx,jpg,jpeg,png,tiff,svg,svgz,gif,psd,ico,bmp,webp,odt,ods,odp,odb,odg,odf,md,ttf,woff,woff2,eot', 'textfield', 'core', 'file', NULL), ('upload_file_exists', '1', 'combo-boolean', 'core', 'file', NULL), ('upload_images', 'jpg,jpeg,png,gif,psd,ico,bmp,tiff,svg,svgz,webp', 'textfield', 'core', 'file', NULL), ('upload_maxsize', '104857600', 'numberfield', 'core', 'file', '[[regtime]]'), ('upload_media', 'mp3,wav,au,wmv,avi,mpg,mpeg', 'textfield', 'core', 'file', NULL), ('upload_translit', '1', 'combo-boolean', 'core', 'file', NULL), ('user_nav_parent', 'usernav', 'textfield', 'core', 'manager', NULL), ('use_alias_path', '', 'combo-boolean', 'core', 'furls', NULL), ('use_context_resource_table', '1', 'combo-boolean', 'core', 'caching', NULL), ('use_editor', '1', 'combo-boolean', 'core', 'editor', NULL), ('use_frozen_parent_uris', '', 'combo-boolean', 'core', 'furls', NULL), ('use_multibyte', '1', 'combo-boolean', 'core', 'language', '[[regtime]]'), ('use_weblink_target', '', 'combo-boolean', 'core', 'site', NULL), ('welcome_action', 'welcome', 'textfield', 'core', 'manager', NULL), ('welcome_namespace', 'core', 'textfield', 'core', 'manager', NULL), ('welcome_screen', '1', 'combo-boolean', 'core', 'manager', NULL), ('welcome_screen_url', '//misc.modx.com/revolution/welcome.30.html ', 'textfield', 'core', 'manager', NULL), ('which_editor', '', 'modx-combo-rte', 'core', 'editor', NULL), ('which_element_editor', '', 'modx-combo-rte', 'core', 'editor', NULL), ('xhtml_urls', '1', 'combo-boolean', 'core', 'site', NULL); -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]transport_packages` -- CREATE TABLE `[[dbprefix]]transport_packages` ( `signature` varchar(191) NOT NULL, `created` datetime NOT NULL, `updated` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP, `installed` datetime DEFAULT NULL, `state` tinyint(1) unsigned NOT NULL DEFAULT '1', `workspace` int(10) unsigned NOT NULL DEFAULT '0', `provider` int(10) unsigned NOT NULL DEFAULT '0', `disabled` tinyint(1) unsigned NOT NULL DEFAULT '0', `source` tinytext, `manifest` text, `attributes` mediumtext, `package_name` varchar(191) NOT NULL, `metadata` text, `version_major` smallint(5) unsigned NOT NULL DEFAULT '0', `version_minor` smallint(5) unsigned NOT NULL DEFAULT '0', `version_patch` smallint(5) unsigned NOT NULL DEFAULT '0', `release` varchar(100) NOT NULL DEFAULT '', `release_index` smallint(5) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`signature`), KEY `workspace` (`workspace`), KEY `provider` (`provider`), KEY `disabled` (`disabled`), KEY `package_name` (`package_name`), KEY `version_major` (`version_major`), KEY `version_minor` (`version_minor`), KEY `version_patch` (`version_patch`), KEY `release` (`release`), KEY `release_index` (`release_index`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]transport_providers` -- CREATE TABLE `[[dbprefix]]transport_providers` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(191) NOT NULL, `description` mediumtext, `service_url` tinytext, `username` varchar(191) NOT NULL DEFAULT '', `api_key` varchar(191) NOT NULL DEFAULT '', `created` datetime NOT NULL, `updated` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP, `active` tinyint(1) NOT NULL DEFAULT '1', `priority` tinyint(4) NOT NULL DEFAULT '10', `properties` mediumtext NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `name` (`name`), KEY `api_key` (`api_key`), KEY `username` (`username`), KEY `active` (`active`), KEY `priority` (`priority`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ; -- -- Dumping data for table `[[dbprefix]]transport_providers` -- INSERT INTO `[[dbprefix]]transport_providers` VALUES (1, 'modx.com', 'The official MODX transport provider for 3rd party components.', 'https://rest.modx.com/extras/', '', '', '2024-04-10 08:18:02', NULL, 1, 10, ''); -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]users` -- CREATE TABLE `[[dbprefix]]users` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `username` varchar(100) NOT NULL DEFAULT '', `password` varchar(255) NOT NULL DEFAULT '', `cachepwd` varchar(255) NOT NULL DEFAULT '', `class_key` varchar(100) NOT NULL DEFAULT 'MODX\\Revolution\\modUser', `active` tinyint(1) unsigned NOT NULL DEFAULT '1', `remote_key` varchar(191) DEFAULT NULL, `remote_data` text, `hash_class` varchar(100) NOT NULL DEFAULT 'MODX\\Revolution\\Hashing\\modNative', `salt` varchar(100) NOT NULL DEFAULT '', `primary_group` int(10) unsigned NOT NULL DEFAULT '0', `session_stale` text, `sudo` tinyint(1) unsigned NOT NULL DEFAULT '0', `createdon` int(20) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `username` (`username`), KEY `class_key` (`class_key`), KEY `remote_key` (`remote_key`), KEY `primary_group` (`primary_group`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ; -- -- Dumping data for table `[[dbprefix]]users` -- INSERT INTO `[[dbprefix]]users` VALUES (1, '[[admin_username]]', '[[admin_pass]]', '', 'MODX\\Revolution\\modUser', 1, NULL, NULL, 'MODX\\Revolution\\Hashing\\modNative', '[[salt]]', 1, NULL, 1, [[timestamp]]); -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]user_attributes` -- CREATE TABLE `[[dbprefix]]user_attributes` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `internalKey` int(10) unsigned NOT NULL, `fullname` varchar(100) NOT NULL DEFAULT '', `email` varchar(100) NOT NULL DEFAULT '', `phone` varchar(100) NOT NULL DEFAULT '', `mobilephone` varchar(100) NOT NULL DEFAULT '', `blocked` tinyint(1) unsigned NOT NULL DEFAULT '0', `blockeduntil` int(11) NOT NULL DEFAULT '0', `blockedafter` int(11) NOT NULL DEFAULT '0', `logincount` int(11) NOT NULL DEFAULT '0', `lastlogin` int(11) NOT NULL DEFAULT '0', `thislogin` int(11) NOT NULL DEFAULT '0', `failedlogincount` int(10) NOT NULL DEFAULT '0', `sessionid` varchar(100) NOT NULL DEFAULT '', `dob` int(10) NOT NULL DEFAULT '0', `gender` tinyint(1) NOT NULL DEFAULT '0', `address` text NOT NULL, `country` varchar(255) NOT NULL DEFAULT '', `city` varchar(255) NOT NULL DEFAULT '', `state` varchar(25) NOT NULL DEFAULT '', `zip` varchar(25) NOT NULL DEFAULT '', `fax` varchar(100) NOT NULL DEFAULT '', `photo` varchar(255) NOT NULL DEFAULT '', `comment` text NOT NULL, `website` varchar(255) NOT NULL DEFAULT '', `extended` text, PRIMARY KEY (`id`), UNIQUE KEY `internalKey` (`internalKey`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ; -- -- Dumping data for table `[[dbprefix]]user_attributes` -- INSERT INTO `[[dbprefix]]user_attributes` VALUES (1, 1, 'Default Admin User', '[[admin_email]]', '', '', 0, 0, 0, 0, 0, 0, 0, '', 0, 0, '', '', '', '', '', '', '', '', '', NULL); -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]user_group_roles` -- CREATE TABLE `[[dbprefix]]user_group_roles` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(191) NOT NULL, `description` mediumtext, `authority` int(10) unsigned NOT NULL DEFAULT '9999', PRIMARY KEY (`id`), UNIQUE KEY `name` (`name`), KEY `authority` (`authority`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ; -- -- Dumping data for table `[[dbprefix]]user_group_roles` -- INSERT INTO `[[dbprefix]]user_group_roles` VALUES (1, 'Member', NULL, 9999), (2, 'Super User', NULL, 0); -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]user_group_settings` -- CREATE TABLE `[[dbprefix]]user_group_settings` ( `group` int(10) unsigned NOT NULL DEFAULT '0', `key` varchar(50) NOT NULL, `value` text, `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 (`group`,`key`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]user_messages` -- CREATE TABLE `[[dbprefix]]user_messages` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `type` varchar(15) NOT NULL DEFAULT '', `subject` varchar(255) NOT NULL DEFAULT '', `message` text NOT NULL, `sender` int(10) unsigned NOT NULL DEFAULT '0', `recipient` int(10) unsigned NOT NULL DEFAULT '0', `private` tinyint(4) NOT NULL DEFAULT '0', `date_sent` datetime DEFAULT NULL, `read` tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]user_settings` -- CREATE TABLE `[[dbprefix]]user_settings` ( `user` int(11) unsigned NOT NULL DEFAULT '0', `key` varchar(50) NOT NULL DEFAULT '', `value` text, `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 (`user`,`key`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]workspaces` -- CREATE TABLE `[[dbprefix]]workspaces` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(191) NOT NULL DEFAULT '', `path` varchar(191) NOT NULL DEFAULT '', `created` datetime NOT NULL, `active` tinyint(1) unsigned NOT NULL DEFAULT '0', `attributes` mediumtext, PRIMARY KEY (`id`), UNIQUE KEY `path` (`path`), KEY `name` (`name`), KEY `active` (`active`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ; -- -- Dumping data for table `[[dbprefix]]workspaces` -- INSERT INTO `[[dbprefix]]workspaces` VALUES (1, 'Default MODX workspace', '{core_path}', '[[regtime]]', 1, NULL); /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;