# ************************************************************
# Sequel Pro SQL dump
# Version 4541
#
# http://www.sequelpro.com/
# https://github.com/sequelpro/sequelpro
#
# Host: 127.0.0.1 (MySQL 5.7.16)
# Database: _dev_modx_central
# Generation Time: 2019-04-02 13:32:04 +0000
# ************************************************************




# Dump of table modx_access_actiondom
# ------------------------------------------------------------


CREATE TABLE `modx_access_actiondom` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `target` varchar(100) NOT NULL DEFAULT '',
  `principal_class` varchar(100) NOT NULL DEFAULT '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;



# Dump of table modx_access_actions
# ------------------------------------------------------------


CREATE TABLE `modx_access_actions` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `target` varchar(100) NOT NULL DEFAULT '',
  `principal_class` varchar(100) NOT NULL DEFAULT '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;



# Dump of table modx_access_category
# ------------------------------------------------------------


CREATE TABLE `modx_access_category` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `target` varchar(100) NOT NULL DEFAULT '',
  `principal_class` varchar(100) NOT NULL DEFAULT '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;



# Dump of table modx_access_context
# ------------------------------------------------------------


CREATE TABLE `modx_access_context` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `target` varchar(100) NOT NULL DEFAULT '',
  `principal_class` varchar(100) NOT NULL DEFAULT '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;


INSERT INTO `modx_access_context` (`id`, `target`, `principal_class`, `principal`, `authority`, `policy`)
VALUES
	(1,'web','modUserGroup',0,9999,3),
	(2,'mgr','modUserGroup',1,0,2),
	(3,'web','modUserGroup',1,0,2);



# Dump of table modx_access_elements
# ------------------------------------------------------------


CREATE TABLE `modx_access_elements` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `target` varchar(100) NOT NULL DEFAULT '',
  `principal_class` varchar(100) NOT NULL DEFAULT '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;



# Dump of table modx_access_media_source
# ------------------------------------------------------------


CREATE TABLE `modx_access_media_source` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `target` varchar(100) NOT NULL DEFAULT '',
  `principal_class` varchar(100) NOT NULL DEFAULT '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;



# Dump of table modx_access_menus
# ------------------------------------------------------------


CREATE TABLE `modx_access_menus` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `target` varchar(100) NOT NULL DEFAULT '',
  `principal_class` varchar(100) NOT NULL DEFAULT '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;



# Dump of table modx_access_namespace
# ------------------------------------------------------------


CREATE TABLE `modx_access_namespace` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `target` varchar(100) NOT NULL DEFAULT '',
  `principal_class` varchar(100) NOT NULL DEFAULT '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;



# Dump of table modx_access_permissions
# ------------------------------------------------------------


CREATE TABLE `modx_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;


INSERT INTO `modx_access_permissions` (`id`, `template`, `name`, `description`, `value`)
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_eventlog','perm.delete_eventlog_desc',1),
	(22,1,'delete_plugin','perm.delete_plugin_desc',1),
	(23,1,'delete_propertyset','perm.delete_propertyset_desc',1),
	(24,1,'delete_snippet','perm.delete_snippet_desc',1),
	(25,1,'delete_template','perm.delete_template_desc',1),
	(26,1,'delete_tv','perm.delete_tv_desc',1),
	(27,1,'delete_role','perm.delete_role_desc',1),
	(28,1,'delete_user','perm.delete_user_desc',1),
	(29,1,'directory_chmod','perm.directory_chmod_desc',1),
	(30,1,'directory_create','perm.directory_create_desc',1),
	(31,1,'directory_list','perm.directory_list_desc',1),
	(32,1,'directory_remove','perm.directory_remove_desc',1),
	(33,1,'directory_update','perm.directory_update_desc',1),
	(34,1,'edit_category','perm.edit_category_desc',1),
	(35,1,'edit_chunk','perm.edit_chunk_desc',1),
	(36,1,'edit_context','perm.edit_context_desc',1),
	(37,1,'edit_document','perm.edit_document_desc',1),
	(38,1,'edit_locked','perm.edit_locked_desc',1),
	(39,1,'edit_plugin','perm.edit_plugin_desc',1),
	(40,1,'edit_propertyset','perm.edit_propertyset_desc',1),
	(41,1,'edit_role','perm.edit_role_desc',1),
	(42,1,'edit_snippet','perm.edit_snippet_desc',1),
	(43,1,'edit_template','perm.edit_template_desc',1),
	(44,1,'edit_tv','perm.edit_tv_desc',1),
	(45,1,'edit_user','perm.edit_user_desc',1),
	(46,1,'element_tree','perm.element_tree_desc',1),
	(47,1,'empty_cache','perm.empty_cache_desc',1),
	(48,1,'error_log_erase','perm.error_log_erase_desc',1),
	(49,1,'error_log_view','perm.error_log_view_desc',1),
	(50,1,'export_static','perm.export_static_desc',1),
	(51,1,'file_create','perm.file_create_desc',1),
	(52,1,'file_list','perm.file_list_desc',1),
	(53,1,'file_manager','perm.file_manager_desc',1),
	(54,1,'file_remove','perm.file_remove_desc',1),
	(55,1,'file_tree','perm.file_tree_desc',1),
	(56,1,'file_update','perm.file_update_desc',1),
	(57,1,'file_upload','perm.file_upload_desc',1),
	(58,1,'file_unpack','perm.file_unpack_desc',1),
	(59,1,'file_view','perm.file_view_desc',1),
	(60,1,'flush_sessions','perm.flush_sessions_desc',1),
	(61,1,'frames','perm.frames_desc',1),
	(62,1,'help','perm.help_desc',1),
	(63,1,'home','perm.home_desc',1),
	(64,1,'import_static','perm.import_static_desc',1),
	(65,1,'languages','perm.languages_desc',1),
	(66,1,'lexicons','perm.lexicons_desc',1),
	(67,1,'list','perm.list_desc',1),
	(68,1,'load','perm.load_desc',1),
	(69,1,'logout','perm.logout_desc',1),
	(70,1,'logs','perm.logs_desc',1),
	(71,1,'menu_reports','perm.menu_reports_desc',1),
	(72,1,'menu_security','perm.menu_security_desc',1),
	(73,1,'menu_site','perm.menu_site_desc',1),
	(74,1,'menu_support','perm.menu_support_desc',1),
	(75,1,'menu_system','perm.menu_system_desc',1),
	(76,1,'menu_tools','perm.menu_tools_desc',1),
	(77,1,'menu_trash','perm.menu_trash_desc',1),
	(78,1,'menu_user','perm.menu_user_desc',1),
	(79,1,'menus','perm.menus_desc',1),
	(80,1,'messages','perm.messages_desc',1),
	(81,1,'namespaces','perm.namespaces_desc',1),
	(82,1,'new_category','perm.new_category_desc',1),
	(83,1,'new_chunk','perm.new_chunk_desc',1),
	(84,1,'new_context','perm.new_context_desc',1),
	(85,1,'new_document','perm.new_document_desc',1),
	(86,1,'new_static_resource','perm.new_static_resource_desc',1),
	(87,1,'new_symlink','perm.new_symlink_desc',1),
	(88,1,'new_weblink','perm.new_weblink_desc',1),
	(89,1,'new_document_in_root','perm.new_document_in_root_desc',1),
	(90,1,'new_plugin','perm.new_plugin_desc',1),
	(91,1,'new_propertyset','perm.new_propertyset_desc',1),
	(92,1,'new_role','perm.new_role_desc',1),
	(93,1,'new_snippet','perm.new_snippet_desc',1),
	(94,1,'new_template','perm.new_template_desc',1),
	(95,1,'new_tv','perm.new_tv_desc',1),
	(96,1,'new_user','perm.new_user_desc',1),
	(97,1,'packages','perm.packages_desc',1),
	(98,1,'policy_delete','perm.policy_delete_desc',1),
	(99,1,'policy_edit','perm.policy_edit_desc',1),
	(100,1,'policy_new','perm.policy_new_desc',1),
	(101,1,'policy_save','perm.policy_save_desc',1),
	(102,1,'policy_view','perm.policy_view_desc',1),
	(103,1,'policy_template_delete','perm.policy_template_delete_desc',1),
	(104,1,'policy_template_edit','perm.policy_template_edit_desc',1),
	(105,1,'policy_template_new','perm.policy_template_new_desc',1),
	(106,1,'policy_template_save','perm.policy_template_save_desc',1),
	(107,1,'policy_template_view','perm.policy_template_view_desc',1),
	(108,1,'property_sets','perm.property_sets_desc',1),
	(109,1,'providers','perm.providers_desc',1),
	(110,1,'publish_document','perm.publish_document_desc',1),
	(111,1,'purge_deleted','perm.purge_deleted_desc',1),
	(112,1,'remove','perm.remove_desc',1),
	(113,1,'remove_locks','perm.remove_locks_desc',1),
	(114,1,'resource_duplicate','perm.resource_duplicate_desc',1),
	(115,1,'resourcegroup_delete','perm.resourcegroup_delete_desc',1),
	(116,1,'resourcegroup_edit','perm.resourcegroup_edit_desc',1),
	(117,1,'resourcegroup_new','perm.resourcegroup_new_desc',1),
	(118,1,'resourcegroup_resource_edit','perm.resourcegroup_resource_edit_desc',1),
	(119,1,'resourcegroup_resource_list','perm.resourcegroup_resource_list_desc',1),
	(120,1,'resourcegroup_save','perm.resourcegroup_save_desc',1),
	(121,1,'resourcegroup_view','perm.resourcegroup_view_desc',1),
	(122,1,'resource_quick_create','perm.resource_quick_create_desc',1),
	(123,1,'resource_quick_update','perm.resource_quick_update_desc',1),
	(124,1,'resource_tree','perm.resource_tree_desc',1),
	(125,1,'save','perm.save_desc',1),
	(126,1,'save_category','perm.save_category_desc',1),
	(127,1,'save_chunk','perm.save_chunk_desc',1),
	(128,1,'save_context','perm.save_context_desc',1),
	(129,1,'save_document','perm.save_document_desc',1),
	(130,1,'save_plugin','perm.save_plugin_desc',1),
	(131,1,'save_propertyset','perm.save_propertyset_desc',1),
	(132,1,'save_role','perm.save_role_desc',1),
	(133,1,'save_snippet','perm.save_snippet_desc',1),
	(134,1,'save_template','perm.save_template_desc',1),
	(135,1,'save_tv','perm.save_tv_desc',1),
	(136,1,'save_user','perm.save_user_desc',1),
	(137,1,'search','perm.search_desc',1),
	(138,1,'set_sudo','perm.set_sudo_desc',1),
	(139,1,'settings','perm.settings_desc',1),
	(140,1,'events','perm.events_desc',1),
	(141,1,'source_save','perm.source_save_desc',1),
	(142,1,'source_delete','perm.source_delete_desc',1),
	(143,1,'source_edit','perm.source_edit_desc',1),
	(144,1,'source_view','perm.source_view_desc',1),
	(145,1,'sources','perm.sources_desc',1),
	(146,1,'steal_locks','perm.steal_locks_desc',1),
	(147,1,'tree_show_element_ids','perm.tree_show_element_ids_desc',1),
	(148,1,'tree_show_resource_ids','perm.tree_show_resource_ids_desc',1),
	(149,1,'undelete_document','perm.undelete_document_desc',1),
	(150,1,'unpublish_document','perm.unpublish_document_desc',1),
	(151,1,'unlock_element_properties','perm.unlock_element_properties_desc',1),
	(152,1,'usergroup_delete','perm.usergroup_delete_desc',1),
	(153,1,'usergroup_edit','perm.usergroup_edit_desc',1),
	(154,1,'usergroup_new','perm.usergroup_new_desc',1),
	(155,1,'usergroup_save','perm.usergroup_save_desc',1),
	(156,1,'usergroup_user_edit','perm.usergroup_user_edit_desc',1),
	(157,1,'usergroup_user_list','perm.usergroup_user_list_desc',1),
	(158,1,'usergroup_view','perm.usergroup_view_desc',1),
	(159,1,'view','perm.view_desc',1),
	(160,1,'view_category','perm.view_category_desc',1),
	(161,1,'view_chunk','perm.view_chunk_desc',1),
	(162,1,'view_context','perm.view_context_desc',1),
	(163,1,'view_document','perm.view_document_desc',1),
	(164,1,'view_element','perm.view_element_desc',1),
	(165,1,'view_eventlog','perm.view_eventlog_desc',1),
	(166,1,'view_offline','perm.view_offline_desc',1),
	(167,1,'view_plugin','perm.view_plugin_desc',1),
	(168,1,'view_propertyset','perm.view_propertyset_desc',1),
	(169,1,'view_role','perm.view_role_desc',1),
	(170,1,'view_snippet','perm.view_snippet_desc',1),
	(171,1,'view_sysinfo','perm.view_sysinfo_desc',1),
	(172,1,'view_template','perm.view_template_desc',1),
	(173,1,'view_tv','perm.view_tv_desc',1),
	(174,1,'view_user','perm.view_user_desc',1),
	(175,1,'view_unpublished','perm.view_unpublished_desc',1),
	(176,1,'workspaces','perm.workspaces_desc',1),
	(177,2,'add_children','perm.add_children_desc',1),
	(178,2,'copy','perm.copy_desc',1),
	(179,2,'create','perm.create_desc',1),
	(180,2,'delete','perm.delete_desc',1),
	(181,2,'list','perm.list_desc',1),
	(182,2,'load','perm.load_desc',1),
	(183,2,'move','perm.move_desc',1),
	(184,2,'publish','perm.publish_desc',1),
	(185,2,'remove','perm.remove_desc',1),
	(186,2,'save','perm.save_desc',1),
	(187,2,'steal_lock','perm.steal_lock_desc',1),
	(188,2,'undelete','perm.undelete_desc',1),
	(189,2,'unpublish','perm.unpublish_desc',1),
	(190,2,'view','perm.view_desc',1),
	(191,3,'load','perm.load_desc',1),
	(192,3,'list','perm.list_desc',1),
	(193,3,'view','perm.view_desc',1),
	(194,3,'save','perm.save_desc',1),
	(195,3,'remove','perm.remove_desc',1),
	(196,4,'add_children','perm.add_children_desc',1),
	(197,4,'create','perm.create_desc',1),
	(198,4,'copy','perm.copy_desc',1),
	(199,4,'delete','perm.delete_desc',1),
	(200,4,'list','perm.list_desc',1),
	(201,4,'load','perm.load_desc',1),
	(202,4,'remove','perm.remove_desc',1),
	(203,4,'save','perm.save_desc',1),
	(204,4,'view','perm.view_desc',1),
	(205,5,'create','perm.create_desc',1),
	(206,5,'copy','perm.copy_desc',1),
	(207,5,'list','perm.list_desc',1),
	(208,5,'load','perm.load_desc',1),
	(209,5,'remove','perm.remove_desc',1),
	(210,5,'save','perm.save_desc',1),
	(211,5,'view','perm.view_desc',1),
	(212,6,'load','perm.load_desc',1),
	(213,6,'list','perm.list_desc',1),
	(214,6,'view','perm.view_desc',1),
	(215,6,'save','perm.save_desc',1),
	(216,6,'remove','perm.remove_desc',1),
	(217,6,'view_unpublished','perm.view_unpublished_desc',1),
	(218,6,'copy','perm.copy_desc',1),
	(219,7,'list','perm.list_desc',1),
	(220,7,'load','perm.load_desc',1),
	(221,7,'view','perm.view_desc',1);



# Dump of table modx_access_policies
# ------------------------------------------------------------


CREATE TABLE `modx_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(191) 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;


INSERT INTO `modx_access_policies` (`id`, `name`, `description`, `parent`, `template`, `class`, `data`, `lexicon`)
VALUES
	(1,'Resource','MODX Resource Policy with all attributes.',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','Context administration policy with all permissions.',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_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_template\":true,\"edit_tv\":true,\"edit_user\":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_update\":true,\"file_upload\":true,\"file_unpack\":true,\"file_view\":true,\"flush_sessions\":true,\"frames\":true,\"help\":true,\"home\":true,\"import_static\":true,\"languages\":true,\"lexicons\":true,\"list\":true,\"load\":true,\"logout\":true,\"logs\":true,\"menus\":true,\"menu_reports\":true,\"menu_security\":true,\"menu_site\":true,\"menu_support\":true,\"menu_system\":true,\"menu_tools\":true,\"menu_user\":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,\"resourcegroup_delete\":true,\"resourcegroup_edit\":true,\"resourcegroup_new\":true,\"resourcegroup_resource_edit\":true,\"resourcegroup_resource_list\":true,\"resourcegroup_save\":true,\"resourcegroup_view\":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_role\":true,\"save_snippet\":true,\"save_template\":true,\"save_tv\":true,\"save_user\":true,\"search\":true,\"set_sudo\":true,\"settings\":true,\"sources\":true,\"source_delete\":true,\"source_edit\":true,\"source_save\":true,\"source_view\":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','A minimal policy with permission to load an object.',0,3,'','{\"load\":true}','permissions'),
	(4,'Load, List and View','Provides load, list and view permissions only.',0,3,'','{\"load\":true,\"list\":true,\"view\":true}','permissions'),
	(5,'Object','An Object policy with all permissions.',0,3,'','{\"load\":true,\"list\":true,\"view\":true,\"save\":true,\"remove\":true}','permissions'),
	(6,'Element','MODX Element policy with all attributes.',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','Context administration policy with limited, content-editing related Permissions, but no publishing.',0,1,'','{\"change_profile\":true,\"class_map\":true,\"countries\":true,\"edit_document\":true,\"frames\":true,\"help\":true,\"home\":true,\"load\":true,\"list\":true,\"logout\":true,\"menu_reports\":true,\"menu_site\":true,\"menu_support\":true,\"menu_tools\":true,\"menu_user\":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,\"new_document\":true,\"delete_document\":true}','permissions'),
	(8,'Media Source Admin','Media Source administration policy.',0,5,'','{\"create\":true,\"copy\":true,\"load\":true,\"list\":true,\"save\":true,\"remove\":true,\"view\":true}','permissions'),
	(9,'Media Source User','Media Source user policy, with basic viewing and using - but no editing - of Media Sources.',0,5,'','{\"load\":true,\"list\":true,\"view\":true}','permissions'),
	(10,'Developer','Context administration policy with most Permissions except Administrator and Security functions.',0,0,'','{\"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_snippet\":true,\"delete_template\":true,\"delete_tv\":true,\"delete_role\":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_template\":true,\"edit_tv\":true,\"edit_user\":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_update\":true,\"file_upload\":true,\"file_unpack\":true,\"file_view\":true,\"frames\":true,\"help\":true,\"home\":true,\"import_static\":true,\"languages\":true,\"lexicons\":true,\"list\":true,\"load\":true,\"logout\":true,\"logs\":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_static_resource\":true,\"new_symlink\":true,\"new_weblink\":true,\"new_document_in_root\":true,\"new_plugin\":true,\"new_propertyset\":true,\"new_role\":true,\"new_snippet\":true,\"new_template\":true,\"new_tv\":true,\"new_user\":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,\"unpublish_document\":true,\"unlock_element_properties\":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_user\":true,\"view_unpublished\":true,\"workspaces\":true}','permissions'),
	(11,'Context','A standard Context policy that you can apply when creating Context ACLs for basic read/write and view_unpublished access within a Context.',0,6,'','{\"load\":true,\"list\":true,\"view\":true,\"save\":true,\"remove\":true,\"copy\":true,\"view_unpublished\":true}','permissions'),
	(12,'Hidden Namespace','Hidden Namespace policy, will not show Namespace in lists.',0,7,'','{\"load\":false,\"list\":false,\"view\":true}','permissions');



# Dump of table modx_access_policy_template_groups
# ------------------------------------------------------------


CREATE TABLE `modx_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;


INSERT INTO `modx_access_policy_template_groups` (`id`, `name`, `description`)
VALUES
	(1,'Admin','All admin policy templates.'),
	(2,'Object','All Object-based policy templates.'),
	(3,'Resource','All Resource-based policy templates.'),
	(4,'Element','All Element-based policy templates.'),
	(5,'MediaSource','All Media Source-based policy templates.'),
	(6,'Namespace','All Namespace based policy templates.');



# Dump of table modx_access_policy_templates
# ------------------------------------------------------------


CREATE TABLE `modx_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(191) NOT NULL DEFAULT 'permissions',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


INSERT INTO `modx_access_policy_templates` (`id`, `template_group`, `name`, `description`, `lexicon`)
VALUES
	(1,1,'AdministratorTemplate','Context administration policy template with all permissions.','permissions'),
	(2,3,'ResourceTemplate','Resource Policy Template with all attributes.','permissions'),
	(3,2,'ObjectTemplate','Object Policy Template with all attributes.','permissions'),
	(4,4,'ElementTemplate','Element Policy Template with all attributes.','permissions'),
	(5,5,'MediaSourceTemplate','Media Source Policy Template with all attributes.','permissions'),
	(6,2,'ContextTemplate','Context Policy Template with all attributes.','permissions'),
	(7,6,'NamespaceTemplate','Namespace Policy Template with all attributes.','permissions');



# Dump of table modx_access_resource_groups
# ------------------------------------------------------------


CREATE TABLE `modx_access_resource_groups` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `target` varchar(100) NOT NULL DEFAULT '',
  `principal_class` varchar(100) NOT NULL DEFAULT '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;



# Dump of table modx_access_resources
# ------------------------------------------------------------


CREATE TABLE `modx_access_resources` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `target` varchar(100) NOT NULL DEFAULT '',
  `principal_class` varchar(100) NOT NULL DEFAULT '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;



# Dump of table modx_access_templatevars
# ------------------------------------------------------------


CREATE TABLE `modx_access_templatevars` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `target` varchar(100) NOT NULL DEFAULT '',
  `principal_class` varchar(100) NOT NULL DEFAULT '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;



# Dump of table modx_actiondom
# ------------------------------------------------------------


CREATE TABLE `modx_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(191) NOT NULL DEFAULT '',
  `rule` varchar(100) NOT NULL DEFAULT '',
  `value` text NOT NULL,
  `constraint` varchar(191) 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;



# Dump of table modx_actions
# ------------------------------------------------------------


CREATE TABLE `modx_actions` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `namespace` varchar(100) NOT NULL DEFAULT 'core',
  `controller` varchar(191) NOT NULL,
  `haslayout` tinyint(1) unsigned NOT NULL DEFAULT '1',
  `lang_topics` text NOT NULL,
  `assets` text NOT NULL,
  `help_url` text NOT NULL,
  PRIMARY KEY (`id`),
  KEY `namespace` (`namespace`),
  KEY `controller` (`controller`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



# Dump of table modx_actions_fields
# ------------------------------------------------------------


CREATE TABLE `modx_actions_fields` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `action` varchar(191) NOT NULL DEFAULT '',
  `name` varchar(191) NOT NULL DEFAULT '',
  `type` varchar(100) NOT NULL DEFAULT 'field',
  `tab` varchar(191) NOT NULL DEFAULT '',
  `form` varchar(191) NOT NULL DEFAULT '',
  `other` varchar(191) 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;


INSERT INTO `modx_actions_fields` (`id`, `action`, `name`, `type`, `tab`, `form`, `other`, `rank`)
VALUES
	(235,'resource/update','modx-resource-settings','tab','','modx-panel-resource','',0),
	(236,'resource/update','modx-resource-main-left','tab','','modx-panel-resource','',1),
	(237,'resource/update','id','field','modx-resource-main-left','modx-panel-resource','',0),
	(238,'resource/update','pagetitle','field','modx-resource-main-left','modx-panel-resource','',1),
	(239,'resource/update','longtitle','field','modx-resource-main-left','modx-panel-resource','',2),
	(240,'resource/update','description','field','modx-resource-main-left','modx-panel-resource','',3),
	(241,'resource/update','introtext','field','modx-resource-main-left','modx-panel-resource','',4),
	(242,'resource/update','modx-resource-main-right','tab','','modx-panel-resource','',2),
	(243,'resource/update','template','field','modx-resource-main-right','modx-panel-resource','',0),
	(244,'resource/update','alias','field','modx-resource-main-right','modx-panel-resource','',1),
	(245,'resource/update','menutitle','field','modx-resource-main-right','modx-panel-resource','',2),
	(246,'resource/update','link_attributes','field','modx-resource-main-right','modx-panel-resource','',3),
	(247,'resource/update','hidemenu','field','modx-resource-main-right','modx-panel-resource','',4),
	(248,'resource/update','published','field','modx-resource-main-right','modx-panel-resource','',5),
	(249,'resource/update','modx-page-settings','tab','','modx-panel-resource','',3),
	(250,'resource/update','modx-page-settings-left','tab','','modx-panel-resource','',4),
	(251,'resource/update','parent-cmb','field','modx-page-settings-left','modx-panel-resource','',0),
	(252,'resource/update','class_key','field','modx-page-settings-left','modx-panel-resource','',1),
	(253,'resource/update','content_type','field','modx-page-settings-left','modx-panel-resource','',2),
	(254,'resource/update','content_dispo','field','modx-page-settings-left','modx-panel-resource','',3),
	(255,'resource/update','menuindex','field','modx-page-settings-left','modx-panel-resource','',4),
	(256,'resource/update','modx-page-settings-right','tab','','modx-panel-resource','',5),
	(257,'resource/update','publishedon','field','modx-page-settings-right','modx-panel-resource','',0),
	(258,'resource/update','pub_date','field','modx-page-settings-right','modx-panel-resource','',1),
	(259,'resource/update','unpub_date','field','modx-page-settings-right','modx-panel-resource','',2),
	(260,'resource/update','modx-page-settings-right-box-left','tab','','modx-panel-resource','',6),
	(261,'resource/update','isfolder','field','modx-page-settings-right-box-left','modx-panel-resource','',0),
	(262,'resource/update','searchable','field','modx-page-settings-right-box-left','modx-panel-resource','',1),
	(263,'resource/update','alias_visible','field','modx-page-settings-right-box-left','modx-panel-resource','',2),
	(264,'resource/update','richtext','field','modx-page-settings-right-box-left','modx-panel-resource','',3),
	(265,'resource/update','uri_override','field','modx-page-settings-right-box-left','modx-panel-resource','',4),
	(266,'resource/update','uri','field','modx-page-settings-right-box-left','modx-panel-resource','',5),
	(267,'resource/update','modx-page-settings-right-box-right','tab','','modx-panel-resource','',7),
	(268,'resource/update','cacheable','field','modx-page-settings-right-box-right','modx-panel-resource','',0),
	(269,'resource/update','syncsite','field','modx-page-settings-right-box-right','modx-panel-resource','',1),
	(270,'resource/update','deleted','field','modx-page-settings-right-box-right','modx-panel-resource','',2),
	(271,'resource/update','modx-panel-resource-tv','tab','','modx-panel-resource','tv',8),
	(272,'resource/update','modx-resource-access-permissions','tab','','modx-panel-resource','',9),
	(273,'resource/update','modx-resource-content','field','modx-resource-content','modx-panel-resource','',0),
	(274,'resource/create','modx-resource-settings','tab','','modx-panel-resource','',0),
	(275,'resource/create','modx-resource-main-left','tab','','modx-panel-resource','',1),
	(276,'resource/create','id','field','modx-resource-main-left','modx-panel-resource','',0),
	(277,'resource/create','pagetitle','field','modx-resource-main-left','modx-panel-resource','',1),
	(278,'resource/create','longtitle','field','modx-resource-main-left','modx-panel-resource','',2),
	(279,'resource/create','description','field','modx-resource-main-left','modx-panel-resource','',3),
	(280,'resource/create','introtext','field','modx-resource-main-left','modx-panel-resource','',4),
	(281,'resource/create','modx-resource-main-right','tab','','modx-panel-resource','',2),
	(282,'resource/create','template','field','modx-resource-main-right','modx-panel-resource','',0),
	(283,'resource/create','alias','field','modx-resource-main-right','modx-panel-resource','',1),
	(284,'resource/create','menutitle','field','modx-resource-main-right','modx-panel-resource','',2),
	(285,'resource/create','link_attributes','field','modx-resource-main-right','modx-panel-resource','',3),
	(286,'resource/create','hidemenu','field','modx-resource-main-right','modx-panel-resource','',4),
	(287,'resource/create','published','field','modx-resource-main-right','modx-panel-resource','',5),
	(288,'resource/create','modx-page-settings','tab','','modx-panel-resource','',3),
	(289,'resource/create','modx-page-settings-left','tab','','modx-panel-resource','',4),
	(290,'resource/create','parent-cmb','field','modx-page-settings-left','modx-panel-resource','',0),
	(291,'resource/create','class_key','field','modx-page-settings-left','modx-panel-resource','',1),
	(292,'resource/create','content_type','field','modx-page-settings-left','modx-panel-resource','',2),
	(293,'resource/create','content_dispo','field','modx-page-settings-left','modx-panel-resource','',3),
	(294,'resource/create','menuindex','field','modx-page-settings-left','modx-panel-resource','',4),
	(295,'resource/create','modx-page-settings-right','tab','','modx-panel-resource','',5),
	(296,'resource/create','publishedon','field','modx-page-settings-right','modx-panel-resource','',0),
	(297,'resource/create','pub_date','field','modx-page-settings-right','modx-panel-resource','',1),
	(298,'resource/create','unpub_date','field','modx-page-settings-right','modx-panel-resource','',2),
	(299,'resource/create','modx-page-settings-right-box-left','tab','','modx-panel-resource','',6),
	(300,'resource/create','isfolder','field','modx-page-settings-right-box-left','modx-panel-resource','',0),
	(301,'resource/create','searchable','field','modx-page-settings-right-box-left','modx-panel-resource','',1),
	(302,'resource/create','alias_visible','field','modx-page-settings-right-box-left','modx-panel-resource','',2),
	(303,'resource/create','richtext','field','modx-page-settings-right-box-left','modx-panel-resource','',3),
	(304,'resource/create','uri_override','field','modx-page-settings-right-box-left','modx-panel-resource','',4),
	(305,'resource/create','uri','field','modx-page-settings-right-box-left','modx-panel-resource','',5),
	(306,'resource/create','modx-page-settings-right-box-right','tab','','modx-panel-resource','',7),
	(307,'resource/create','cacheable','field','modx-page-settings-right-box-right','modx-panel-resource','',0),
	(308,'resource/create','syncsite','field','modx-page-settings-right-box-right','modx-panel-resource','',1),
	(309,'resource/create','deleted','field','modx-page-settings-right-box-right','modx-panel-resource','',2),
	(310,'resource/create','modx-panel-resource-tv','tab','','modx-panel-resource','tv',8),
	(311,'resource/create','modx-resource-access-permissions','tab','','modx-panel-resource','',9),
	(312,'resource/create','modx-resource-content','field','modx-resource-content','modx-panel-resource','',0);



# Dump of table modx_active_users
# ------------------------------------------------------------


CREATE TABLE `modx_active_users` (
  `internalKey` int(9) NOT NULL DEFAULT '0',
  `username` varchar(50) NOT NULL DEFAULT '',
  `lasthit` int(20) NOT NULL DEFAULT '0',
  `id` int(10) DEFAULT NULL,
  `action` varchar(191) NOT NULL DEFAULT '',
  `ip` varchar(20) NOT NULL DEFAULT '',
  PRIMARY KEY (`internalKey`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



# Dump of table modx_categories
# ------------------------------------------------------------


CREATE TABLE `modx_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;



# Dump of table modx_categories_closure
# ------------------------------------------------------------


CREATE TABLE `modx_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;



# Dump of table modx_class_map
# ------------------------------------------------------------


CREATE TABLE `modx_class_map` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `class` varchar(120) NOT NULL DEFAULT '',
  `parent_class` varchar(120) NOT NULL DEFAULT '',
  `name_field` varchar(191) NOT NULL DEFAULT 'name',
  `path` tinytext,
  `lexicon` varchar(191) NOT NULL DEFAULT 'core:resource',
  PRIMARY KEY (`id`),
  UNIQUE KEY `class` (`class`),
  KEY `parent_class` (`parent_class`),
  KEY `name_field` (`name_field`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


INSERT INTO `modx_class_map` (`id`, `class`, `parent_class`, `name_field`, `path`, `lexicon`)
VALUES
	(1,'modDocument','modResource','pagetitle','','core:resource'),
	(2,'modWebLink','modResource','pagetitle','','core:resource'),
	(3,'modSymLink','modResource','pagetitle','','core:resource'),
	(4,'modStaticResource','modResource','pagetitle','','core:resource'),
	(5,'modTemplate','modElement','templatename','','core:resource'),
	(6,'modTemplateVar','modElement','name','','core:resource'),
	(7,'modChunk','modElement','name','','core:resource'),
	(8,'modSnippet','modElement','name','','core:resource'),
	(9,'modPlugin','modElement','name','','core:resource');



# Dump of table modx_content_type
# ------------------------------------------------------------


CREATE TABLE `modx_content_type` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) NOT NULL,
  `description` tinytext,
  `mime_type` tinytext,
  `file_extensions` tinytext,
  `headers` mediumtext,
  `binary` tinyint(1) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


INSERT INTO `modx_content_type` (`id`, `name`, `description`, `mime_type`, `file_extensions`, `headers`, `binary`)
VALUES
	(1,'HTML','HTML content','text/html','.html',NULL,0),
	(2,'XML','XML content','text/xml','.xml',NULL,0),
	(3,'text','plain text content','text/plain','.txt',NULL,0),
	(4,'CSS','CSS content','text/css','.css',NULL,0),
	(5,'javascript','javascript content','text/javascript','.js',NULL,0),
	(6,'RSS','For RSS feeds','application/rss+xml','.rss',NULL,0),
	(7,'JSON','JSON','application/json','.json',NULL,0),
	(8,'PDF','PDF Files','application/pdf','.pdf',NULL,1);



# Dump of table modx_context
# ------------------------------------------------------------


CREATE TABLE `modx_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;


INSERT INTO `modx_context` (`key`, `name`, `description`, `rank`)
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);



# Dump of table modx_context_resource
# ------------------------------------------------------------


CREATE TABLE `modx_context_resource` (
  `context_key` varchar(191) NOT NULL,
  `resource` int(11) unsigned NOT NULL,
  PRIMARY KEY (`context_key`,`resource`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



# Dump of table modx_context_setting
# ------------------------------------------------------------


CREATE TABLE `modx_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(191) NOT NULL DEFAULT '',
  `editedon` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`context_key`,`key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


INSERT INTO `modx_context_setting` (`context_key`, `key`, `value`, `xtype`, `namespace`, `area`, `editedon`)
VALUES
	('mgr','allow_tags_in_post','1','combo-boolean','core','system',NULL),
	('mgr','modRequest.class','modManagerRequest','textfield','core','system',NULL);



# Dump of table modx_dashboard
# ------------------------------------------------------------


CREATE TABLE `modx_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',
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `hide_trees` (`hide_trees`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


INSERT INTO `modx_dashboard` (`id`, `name`, `description`, `hide_trees`)
VALUES
	(1,'Default','',0);



# Dump of table modx_dashboard_widget
# ------------------------------------------------------------


CREATE TABLE `modx_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,
  `namespace` varchar(191) NOT NULL DEFAULT '',
  `lexicon` varchar(191) NOT NULL DEFAULT 'core:dashboards',
  `size` varchar(191) NOT NULL DEFAULT 'half',
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `type` (`type`),
  KEY `namespace` (`namespace`),
  KEY `lexicon` (`lexicon`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


INSERT INTO `modx_dashboard_widget` (`id`, `name`, `description`, `type`, `content`, `namespace`, `lexicon`, `size`)
VALUES
	(1,'w_newsfeed','w_newsfeed_desc','file','[[++manager_path]]controllers/default/dashboard/widget.modx-news.php','core','core:dashboards','half'),
	(2,'w_securityfeed','w_securityfeed_desc','file','[[++manager_path]]controllers/default/dashboard/widget.modx-security.php','core','core:dashboards','half'),
	(3,'w_whosonline','w_whosonline_desc','file','[[++manager_path]]controllers/default/dashboard/widget.grid-online.php','core','core:dashboards','half'),
	(4,'w_recentlyeditedresources','w_recentlyeditedresources_desc','file','[[++manager_path]]controllers/default/dashboard/widget.grid-rer.php','core','core:dashboards','half'),
	(5,'w_configcheck','w_configcheck_desc','file','[[++manager_path]]controllers/default/dashboard/widget.configcheck.php','core','core:dashboards','full');



# Dump of table modx_dashboard_widget_placement
# ------------------------------------------------------------


CREATE TABLE `modx_dashboard_widget_placement` (
  `dashboard` int(10) unsigned NOT NULL DEFAULT '0',
  `widget` int(10) unsigned NOT NULL DEFAULT '0',
  `rank` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`dashboard`,`widget`),
  KEY `rank` (`rank`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


INSERT INTO `modx_dashboard_widget_placement` (`dashboard`, `widget`, `rank`)
VALUES
	(1,5,0),
	(1,1,1),
	(1,2,2),
	(1,3,3),
	(1,4,4);



# Dump of table modx_document_groups
# ------------------------------------------------------------


CREATE TABLE `modx_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;



# Dump of table modx_documentgroup_names
# ------------------------------------------------------------


CREATE TABLE `modx_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;



# Dump of table modx_element_property_sets
# ------------------------------------------------------------


CREATE TABLE `modx_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;



# Dump of table modx_extension_packages
# ------------------------------------------------------------


CREATE TABLE `modx_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(191) NOT NULL DEFAULT '',
  `service_class` varchar(191) NOT NULL DEFAULT '',
  `service_name` varchar(191) 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;



# Dump of table modx_fc_profiles
# ------------------------------------------------------------


CREATE TABLE `modx_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;



# Dump of table modx_fc_profiles_usergroups
# ------------------------------------------------------------


CREATE TABLE `modx_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;



# Dump of table modx_fc_sets
# ------------------------------------------------------------


CREATE TABLE `modx_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(191) 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;



# Dump of table modx_lexicon_entries
# ------------------------------------------------------------


CREATE TABLE `modx_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;



# Dump of table modx_manager_log
# ------------------------------------------------------------


CREATE TABLE `modx_manager_log` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user` int(10) unsigned NOT NULL DEFAULT '0',
  `occurred` datetime DEFAULT NULL,
  `action` varchar(100) NOT NULL DEFAULT '',
  `classKey` varchar(100) NOT NULL DEFAULT '',
  `item` varchar(191) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `user_occurred` (`user`,`occurred`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


INSERT INTO `modx_manager_log` (`id`, `user`, `occurred`, `action`, `classKey`, `item`)
VALUES
	(1,1,'2019-04-02 09:09:47','login','modContext','mgr'),
	(2,1,'2019-04-02 09:24:09','clear_cache','','mgr'),
	(3,1,'2019-04-02 09:26:25','login','modContext','mgr'),
	(4,1,'2019-04-02 09:34:06','login','modContext','mgr'),
	(5,1,'2019-04-02 10:03:53','clear_cache','','mgr'),
	(6,1,'2019-04-02 10:04:39','clear_cache','','mgr'),
	(7,1,'2019-04-02 10:29:26','login','modContext','mgr');



# Dump of table modx_media_sources
# ------------------------------------------------------------


CREATE TABLE `modx_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 '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;


INSERT INTO `modx_media_sources` (`id`, `name`, `description`, `class_key`, `properties`, `is_stream`)
VALUES
	(1,'Filesystem','','sources.modFileMediaSource','a:0:{}',1);



# Dump of table modx_media_sources_contexts
# ------------------------------------------------------------


CREATE TABLE `modx_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;



# Dump of table modx_media_sources_elements
# ------------------------------------------------------------


CREATE TABLE `modx_media_sources_elements` (
  `source` int(11) unsigned NOT NULL DEFAULT '0',
  `object_class` varchar(100) NOT NULL DEFAULT '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;



# Dump of table modx_member_groups
# ------------------------------------------------------------


CREATE TABLE `modx_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;


INSERT INTO `modx_member_groups` (`id`, `user_group`, `member`, `role`, `rank`)
VALUES
	(1,1,1,2,0);



# Dump of table modx_membergroup_names
# ------------------------------------------------------------


CREATE TABLE `modx_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;


INSERT INTO `modx_membergroup_names` (`id`, `name`, `description`, `parent`, `rank`, `dashboard`)
VALUES
	(1,'Administrator',NULL,0,0,1);



# Dump of table modx_menus
# ------------------------------------------------------------


CREATE TABLE `modx_menus` (
  `text` varchar(191) NOT NULL DEFAULT '',
  `parent` varchar(191) NOT NULL DEFAULT '',
  `action` varchar(191) NOT NULL DEFAULT '',
  `description` varchar(191) NOT NULL DEFAULT '',
  `icon` varchar(191) 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;


INSERT INTO `modx_menus` (`text`, `parent`, `action`, `description`, `icon`, `menuindex`, `params`, `handler`, `permissions`, `namespace`)
VALUES
	('about','usernav','help','','<i class=\"icon-question-circle icon icon-large\"></i>',7,'','','help','core'),
	('acls','admin','security/permission','acls_desc','',5,'','','access_permissions','core'),
	('admin','usernav','','','<i class=\"icon-gear icon icon-large\"></i>',6,'','','settings','core'),
	('bespoke_manager','admin','security/forms','bespoke_manager_desc','',1,'','','customize_forms','core'),
	('components','topnav','','','',2,'','','components','core'),
	('content_types','site','system/contenttype','content_types_desc','',8,'','','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'),
	('import_resources','site','system/import','import_resources_desc','',6,'','','import_static','core'),
	('import_site','site','system/import/html','import_site_desc','',5,'','','import_static','core'),
	('installer','components','workspaces','installer_desc','',0,'','','packages','core'),
	('lexicon_management','admin','workspaces/lexicon','lexicon_management_desc','',7,'','','lexicons','core'),
	('logout','user','security/logout','logout_desc','',2,'','MODx.logout(); return false;','logout','core'),
	('manage','topnav','','','',3,'','','menu_tools','core'),
	('media','topnav','','media_desc','',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','',4,'','MODx.preview(); return false;','','core'),
	('profile','user','security/profile','profile_desc','',0,'','','change_profile','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','',7,'','','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','','','<span id=\"user-avatar\">{$userImage}</span> <span id=\"user-username\">{$username}</span>',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,'','','logs','core'),
	('view_sysinfo','reports','system/info','view_sysinfo_desc','',3,'','','view_sysinfo','core');



# Dump of table modx_namespaces
# ------------------------------------------------------------


CREATE TABLE `modx_namespaces` (
  `name` varchar(40) NOT NULL DEFAULT '',
  `path` text,
  `assets_path` text,
  PRIMARY KEY (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


INSERT INTO `modx_namespaces` (`name`, `path`, `assets_path`)
VALUES
	('core','{core_path}','{assets_path}');



# Dump of table modx_property_set
# ------------------------------------------------------------


CREATE TABLE `modx_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(191) NOT NULL DEFAULT '',
  `properties` text,
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`),
  KEY `category` (`category`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



# Dump of table modx_register_messages
# ------------------------------------------------------------


CREATE TABLE `modx_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;



# Dump of table modx_register_queues
# ------------------------------------------------------------


CREATE TABLE `modx_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;


INSERT INTO `modx_register_queues` (`id`, `name`, `options`)
VALUES
	(1,'locks','a:1:{s:9:\"directory\";s:5:\"locks\";}');



# Dump of table modx_register_topics
# ------------------------------------------------------------


CREATE TABLE `modx_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;



# Dump of table modx_session
# ------------------------------------------------------------


CREATE TABLE `modx_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;


INSERT INTO `modx_session` (`id`, `access`, `data`)
VALUES
	('veg7175fhgn683m4huranba6s6',1554211774,'modx.user.contextTokens|a:0:{}');



# Dump of table modx_site_content
# ------------------------------------------------------------


CREATE TABLE `modx_site_content` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `type` varchar(20) NOT NULL DEFAULT 'document',
  `contentType` varchar(50) NOT NULL DEFAULT 'text/html',
  `pagetitle` varchar(191) NOT NULL DEFAULT '',
  `longtitle` varchar(191) NOT NULL DEFAULT '',
  `description` text NOT NULL,
  `alias` varchar(191) DEFAULT '',
  `alias_visible` tinyint(1) unsigned NOT NULL DEFAULT '1',
  `link_attributes` varchar(191) 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) 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(191) 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 '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,
  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;


INSERT INTO `modx_site_content` (`id`, `type`, `contentType`, `pagetitle`, `longtitle`, `description`, `alias`, `alias_visible`, `link_attributes`, `published`, `pub_date`, `unpub_date`, `parent`, `isfolder`, `introtext`, `content`, `richtext`, `template`, `menuindex`, `searchable`, `cacheable`, `createdby`, `createdon`, `editedby`, `editedon`, `deleted`, `deletedon`, `deletedby`, `publishedon`, `publishedby`, `menutitle`, `donthit`, `privateweb`, `privatemgr`, `content_dispo`, `hidemenu`, `class_key`, `context_key`, `content_type`, `uri`, `uri_override`, `hide_children_in_tree`, `show_in_tree`, `properties`)
VALUES
	(1,'document','text/html','Home','Congratulations!','','index',1,'',1,0,0,0,0,NULL,'<p>You have successfully installed MODX Revolution&nbsp;[[++settings_version]]!</p>\n<p>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&nbsp;website. </p>\n\n<h2>New to&nbsp;MODX?</h2>\n\n<p>Pages on a MODX site are called <a href=\"https://rtfm.modx.com/revolution/2.x/making-sites-with-modx/structuring-your-site/resources\">Resources</a>, 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&nbsp;cases.</p>\n\n<p>Building your website is done through a combination of <b>Templates</b>, <b>Template Variables</b>, <b>Chunks</b>, <b>Snippets</b> and <b>Plugins</b>. Collectively these are known as <b>Elements</b>, and can also be found in the left-hand side of the manager, in the Elements&nbsp;tab.</p>\n\n<p><a href=\"https://rtfm.modx.com/revolution/2.x/making-sites-with-modx/structuring-your-site/templates\">Templates</a> contain the outer markup of any page. Each resource can only be assigned to a single template at a time. By adding <a href=\"https://rtfm.modx.com/revolution/2.x/making-sites-with-modx/customizing-content/template-variables\">Template Variables</a> to a template, you can add custom fields for any resource using that particular&nbsp;template.</p>\n\n<p>With <a href=\"https://rtfm.modx.com/revolution/2.x/making-sites-with-modx/structuring-your-site/chunks\">Chunks</a> you can share parts of the markup, such as a header, across different templates. <a href=\"https://rtfm.modx.com/revolution/2.x/making-sites-with-modx/structuring-your-site/using-snippets\">Snippets</a> 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&nbsp;HTML.</p>\n\n<p>Finally, <a href=\"https://rtfm.modx.com/revolution/2.x/developing-in-modx/basic-development/plugins\">Plugins</a> enable more advanced features by hooking into the extensive events system provided by&nbsp;MODX.</p>\n\n<p>To learn more about MODX, be sure to check out the <a href=\"https://rtfm.modx.com/revolution/2.x/getting-started\">Getting Started</a> section in the official&nbsp;documentation.</p>\n',1,1,0,1,1,1,1554206929,0,0,0,0,0,0,0,'',0,0,0,0,0,'modDocument','web',1,NULL,0,0,1,NULL);



# Dump of table modx_site_htmlsnippets
# ------------------------------------------------------------


CREATE TABLE `modx_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(191) 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(191) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`),
  KEY `category` (`category`),
  KEY `locked` (`locked`),
  KEY `static` (`static`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



# Dump of table modx_site_plugin_events
# ------------------------------------------------------------


CREATE TABLE `modx_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;



# Dump of table modx_site_plugins
# ------------------------------------------------------------


CREATE TABLE `modx_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(191) 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(191) 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;



# Dump of table modx_site_snippets
# ------------------------------------------------------------


CREATE TABLE `modx_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(191) 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(191) 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;



# Dump of table modx_site_templates
# ------------------------------------------------------------


CREATE TABLE `modx_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(191) NOT NULL DEFAULT 'Template',
  `editor_type` int(11) NOT NULL DEFAULT '0',
  `category` int(11) NOT NULL DEFAULT '0',
  `icon` varchar(191) 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(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;


INSERT INTO `modx_site_templates` (`id`, `source`, `property_preprocess`, `templatename`, `description`, `editor_type`, `category`, `icon`, `template_type`, `content`, `locked`, `properties`, `static`, `static_file`)
VALUES
	(1,0,0,'BaseTemplate','Template',0,0,'',0,'<!doctype html>\n<html lang=\"en\">\n<head>\n    <title>[[*pagetitle]] - [[++site_name]]</title>\n    <base href=\"[[!++site_url]]\" />\n    <meta charset=\"[[++modx_charset]]\" />\n    <meta http-equiv=\"X-UA-Compatible\" content=\"IE=edge\">\n    <meta name=\"viewport\" content=\"width=device-width, initial-scale=1, maximum-scale=1\" />\n\n    <style type=\"text/css\">\n        body {\n            background-color: #eee;\n            font-family: sans-serif;\n            font-size: 20px;\n            line-height: 1.4em;\n            padding: 0;\n            margin: 0;\n        }\n        body.loaded {\n            font-family: \'Open Sans\', sans-serif;\n        }\n        .container {\n            display: block;\n            max-width: 960px;\n            margin: 2em auto 2em;\n            padding: 2em;\n            background: #fff;\n            border: 1px solid #ddd;\n            border-radius: 3px;\n        }\n        .container > section {\n            height: 100%;\n            width: 60%;\n            display: inline-block;\n            float: left;\n            margin-bottom: 2em;\n        }\n        .container > aside {\n            height: 100%;\n            display: inline-block;\n            width: 30%;\n            border-left: 2px dashed #eee;\n            float: right;\n            padding-left: 1.5em;\n        }\n        .logo {\n            background: url(\'[[++manager_url]]templates/default/images/modx-logo-color.svg\') no-repeat center transparent;\n            width: 220px;\n            height: 85px;\n            background-size: contain;\n            display: block;\n            position: relative;\n            text-indent: -9999px;\n            margin: 2em auto;\n        }\n        h1, h2, h3, h4, h5 {\n            color: #494949;\n            font-family: \'Open Sans\', sans-serif;\n            font-weight: 700;\n        }\n        h1 {\n            font-size: 36px;\n            color: #137899;\n        }\n        h2 {\n            font-size: 29px;\n        }\n        h3 {\n            font-size: 24px;\n        }\n\n        a {\n            color: #0f7096;\n        }\n\n        ul {\n            padding-left: 2em;\n        }\n\n        img {\n            max-width: 100%;\n        }\n\n        .cta-button {\n            display: block;\n            text-align: center;\n            vertical-align: middle;\n            -webkit-transform: translateZ(0);\n            transform: translateZ(0);\n            box-shadow: 0 0 1px rgba(0, 0, 0, 0);\n            -webkit-backface-visibility: hidden;\n            backface-visibility: hidden;\n            -moz-osx-font-smoothing: grayscale;\n            position: relative;\n            overflow: hidden;\n            margin: .2em 0;\n            padding: 1em;\n            cursor: pointer;\n            background: #67a749;\n            text-decoration: none;\n            border-radius: 3px;\n            color: #fff;\n            -webkit-tap-highlight-color: rgba(0,0,0,0);\n        }\n        .cta-button:before {\n            content: \"\";\n            position: absolute;\n            z-index: -1;\n            left: 50%;\n            right: 50%;\n            bottom: 0;\n            background: #137899;\n            height: 5px;\n            -webkit-transition-property: left, right;\n            transition-property: left, right;\n            -webkit-transition-duration: 0.3s;\n            transition-duration: 0.3s;\n            -webkit-transition-timing-function: ease-out;\n            transition-timing-function: ease-out;\n        }\n        .cta-button:hover:before, .cta-button:focus:before, .cta-button:active:before {\n            left: 0;\n            right: 0;\n        }\n\n        .companies {\n            clear: both;\n            display: block;\n            width: 100%;\n            padding: 1em 0 0;\n            border-top: 2px dashed #eee;\n        }\n\n        .companies h3 {\n            text-align: center;\n            margin: 0;\n        }\n\n        .companies ul {\n            margin: 0;\n            padding: 0;\n            list-style: none;\n            text-align: center;\n        }\n\n        .companies ul li {\n            display: inline-block;\n            padding: 0 1em;\n        }\n\n        .companies ul li:first-child {\n            padding-left: 0;\n        }\n\n        .companies ul li:last-child {\n            padding-right: 0;\n        }\n\n        .companies ul li a {\n            display: block;\n            position: relative;\n            text-indent: -99999px;\n            width: 200px;\n            height: 75px;\n            background-repeat: no-repeat;\n            background-size: 200px;\n            background-position: center;\n        }\n\n        .companies ul li.modmore a {\n            background-image: url(data:image/png;base64,[encoded data, 9468 characters]);\n        }\n\n        .companies ul li.extrasio a {\n            background-image: url(data:image/png;base64,[encoded data, 13948 characters]);\n        }\n        .companies ul li.modstore a {\n            background-image: url(data:image/jpeg;base64,[encoded data, 9752 characters]);\n        }\n\n        .companies ul li.modxextras a {\n            background-image: url(data:image/jpeg;base64,[encoded data, 10768 characters]);\n        }\n\n        .disclaimer {\n            max-width: 960px;\n            display: block;\n            margin: 0 auto;\n            text-align: center;\n            color: #333;\n            font-size: .6em;\n        }\n\n        @media (min-width: 768px) and (max-width: 991px)  {\n            .container {\n                padding: 1em;\n                border: 0;\n                border-radius: 0;\n            }\n        }\n\n        @media (max-width: 767px)  {\n            body {\n                font-size: 16px;\n            }\n            .container {\n                padding: 1em;\n                margin: 0 0 1em;\n                border: 0;\n                border-radius: 0;\n            }\n            .container > section, .container > aside {\n                float: none;\n                width: 100%;\n            }\n            .container aside {\n                border: 0;\n                padding: 0;\n            }\n            .logo {\n                width: 100%;\n                height: 48px;\n            }\n            h1 {\n                font-size: 24px;\n            }\n            h2 {\n                font-size: 19px;\n            }\n            h3 {\n                font-size: 16px;\n            }\n            .companys ul li {\n                display: block;\n            }\n        }\n\n    </style>\n</head>\n<body>\n\n<a href=\"http://www.modx.com\" title=\"Modx\" class=\"logo\" target=\"_blank\">MODX</a>\n\n<div class=\"container\">\n    <section>\n        <h1>[[*longtitle:default=`[[*pagetitle]]`]]</h1>\n        [[*content]]\n    </section>\n    <aside>\n        <a href=\"[[++manager_url]]\" title=\"Your MODX manager\" class=\"cta-button\">Go to the&nbsp;manager</a>\n        <h3>Learn more about&nbsp;MODX</h3>\n        <ul>\n            <li><a href=\"https://rtfm.modx.com/revolution/2.x/\">Official&nbsp;Documentation</a></li>\n            <li><a href=\"https://rtfm.modx.com/revolution/2.x/administering-your-site/using-friendly-urls\">Using Friendly&nbsp;URLs</a></li>\n            <li><a href=\"https://rtfm.modx.com/revolution/2.x/developing-in-modx/advanced-development/package-management/\">Package&nbsp;Management</a></li>\n            <li><a href=\"http://modx.com/blog/\">Official MODX&nbsp;Blog</a></li>\n            <li><a href=\"http://www.discovermodx.com/\">Discover&nbsp;MODX</a></li>\n            <li><a href=\"https://modx.today\">MODX.today</a></li>\n        </ul>\n\n        <h3>Get help!</h3>\n        <ul>\n            <li><a href=\"http://forums.modx.com/\">Official MODX&nbsp;Forums</a></li>\n            <li><a href=\"https://modx.org/\">MODX on&nbsp;Slack</a></li>\n            <li><a href=\"https://twitter.com/modx\">MODX on&nbsp;Twitter</a></li>\n            <li><a href=\"https://www.facebook.com/modxcms\">MODX on&nbsp;Facebook</a></li>\n            <li><a href=\"http://modx.com/professionals/\">Find a MODX&nbsp;Professional</a></li>\n        </ul>\n    </aside>\n    <div class=\"companies\">\n        <h3>Extend MODX with&nbsp;Extras</h3>\n        <ul>\n            <li class=\"modxextras\"><a href=\"http://modx.com/extras/\" title=\"MODX extras\" target=\"_blank\">MODX&nbsp;extras</a></li>\n            <li class=\"modmore\"><a href=\"https://www.modmore.com/extras/\" title=\"modmore.com\" target=\"_blank\">modmore.com</a></li>\n            <li class=\"modstore\"><a href=\"https://modstore.pro/\" title=\"modstore.pro\" target=\"_blank\">modstore.pro</a></li>\n            <li class=\"extrasio\"><a href=\"https://extras.io/extras/\" title=\"Extras.io\" target=\"_blank\">Extras.io</a></li>\n        </ul>\n    </div>\n</div>\n<footer class=\"disclaimer\">\n    <p>&copy; 2005-present the <a href=\"http://www.modx.com/\" target=\"_blank\">MODX</a> Content Management Framework (CMF) project. All rights reserved. MODX is licensed under the GNU&nbsp;GPL.</p>\n</footer>\n\n<script>\n    // Load the Open Sans font\n    try {\n        document.addEventListener(\"DOMContentLoaded\", function() { // prevent a Flash Of Unstyled Text (FOUT)\n            document.querySelector(\'head\').innerHTML += \"<link href=\'https://fonts.googleapis.com/css?family=Open+Sans:400,700\' rel=\'stylesheet\' type=\'text/css\'>\";\n            document.body.classList.add(\'loaded\');\n        });\n    } catch (e) { }\n\n    // Shuffle the vendors to prevent favoritism of one vendor over the other\n    // with thanks to http://james.padolsey.com/javascript/shuffling-the-dom/\n    function shuffle(elems) {\n        var allElems = (function(){\n            var ret = [], l = elems.length;\n            while (l--) {\n                if (elems[l].className !== \'modxextras\') {\n                    ret[ret.length] = elems[l];\n                }\n            }\n            return ret;\n        })();\n\n        var shuffled = (function(){\n            var l = allElems.length, ret = [];\n            while (l--) {\n                var random = Math.floor(Math.random() * allElems.length),\n                        randEl = allElems[random].cloneNode(true);\n                allElems.splice(random, 1);\n                ret[ret.length] = randEl;\n            }\n            return ret;\n        })(), l = elems.length;\n\n        // To make sure the MODX logo stays #1, we lower the count by one here (shuffling 3 instead of 4 items)\n        // and refer to elems[l+1] in the loop below. This matches because allElems was also filtered to not include\n        // the official MODX logo.\n        l--;\n        while (l--) {\n            elems[l+1].parentNode.insertBefore(shuffled[l], elems[l+1].nextSibling);\n            elems[l+1].parentNode.removeChild(elems[l+1]);\n        }\n    }\n    shuffle(document.querySelectorAll(\'.companies li\'));\n</script>\n\n</body>\n</html>\n',0,NULL,0,'');



# Dump of table modx_site_tmplvar_access
# ------------------------------------------------------------


CREATE TABLE `modx_site_tmplvar_access` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `tmplvarid` int(10) NOT NULL DEFAULT '0',
  `documentgroup` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `tmplvar_template` (`tmplvarid`,`documentgroup`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



# Dump of table modx_site_tmplvar_contentvalues
# ------------------------------------------------------------


CREATE TABLE `modx_site_tmplvar_contentvalues` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `tmplvarid` int(10) NOT NULL DEFAULT '0',
  `contentid` int(10) 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;



# Dump of table modx_site_tmplvar_templates
# ------------------------------------------------------------


CREATE TABLE `modx_site_tmplvar_templates` (
  `tmplvarid` int(10) NOT NULL DEFAULT '0',
  `templateid` int(11) NOT NULL DEFAULT '0',
  `rank` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`tmplvarid`,`templateid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



# Dump of table modx_site_tmplvars
# ------------------------------------------------------------


CREATE TABLE `modx_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(191) 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(191) 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;



# Dump of table modx_system_eventnames
# ------------------------------------------------------------


CREATE TABLE `modx_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;


INSERT INTO `modx_system_eventnames` (`name`, `service`, `groupname`)
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');



# Dump of table modx_system_settings
# ------------------------------------------------------------


CREATE TABLE `modx_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(191) NOT NULL DEFAULT '',
  `editedon` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


INSERT INTO `modx_system_settings` (`key`, `value`, `xtype`, `namespace`, `area`, `editedon`)
VALUES
	('access_category_enabled','1','combo-boolean','core','authentication',NULL),
	('access_context_enabled','1','combo-boolean','core','authentication',NULL),
	('access_policies_version','1.0','textfield','core','system',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),
	('allow_tv_eval','1','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','parent','textfield','core','site',NULL),
	('auto_check_pkg_updates','1','combo-boolean','core','system',NULL),
	('auto_check_pkg_updates_cache_expire','15','textfield','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/display/revolution20/','textfield','core','manager',NULL),
	('blocked_minutes','60','textfield','core','authentication',NULL),
	('cache_action_map','1','combo-boolean','core','caching',NULL),
	('cache_alias_map','1','combo-boolean','core','caching',NULL),
	('cache_context_settings','1','combo-boolean','core','caching',NULL),
	('cache_db','0','combo-boolean','core','caching',NULL),
	('cache_db_expires','0','textfield','core','caching',NULL),
	('cache_db_session','0','combo-boolean','core','caching',NULL),
	('cache_db_session_lifetime','','textfield','core','caching',NULL),
	('cache_default','1','combo-boolean','core','caching',NULL),
	('cache_expires','0','textfield','core','caching',NULL),
	('cache_format','0','textfield','core','caching',NULL),
	('cache_handler','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','0','combo-boolean','core','caching',NULL),
	('cache_resource_expires','0','textfield','core','caching',NULL),
	('cache_scripts','1','combo-boolean','core','caching',NULL),
	('clear_cache_refresh_trees','0','combo-boolean','core','caching',NULL),
	('compress_css','1','combo-boolean','core','manager',NULL),
	('compress_js','1','combo-boolean','core','manager',NULL),
	('compress_js_max_files','10','textfield','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','','textfield','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','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),
	('editor_css_path','','textfield','core','editor',NULL),
	('editor_css_selectors','','textfield','core','editor',NULL),
	('emailsender','swyern@halifax.ca','textfield','core','authentication','2019-04-02 09:08:49'),
	('emailsubject','Your login details','textfield','core','authentication',NULL),
	('enable_dragdrop','1','combo-boolean','core','manager',NULL),
	('enable_gravatar','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','textfield','core','site',NULL),
	('failed_login_attempts','5','textfield','core','authentication',NULL),
	('feed_modx_news','http://feeds.feedburner.com/modx-announce','textfield','core','system',NULL),
	('feed_modx_news_enabled','1','combo-boolean','core','system',NULL),
	('feed_modx_security','http://forums.modx.com/board.xml?board=294','textfield','core','system',NULL),
	('feed_modx_security_enabled','1','combo-boolean','core','system',NULL),
	('fe_editor_lang','en','modx-combo-language','core','language',NULL),
	('filemanager_path','','textfield','core','file',NULL),
	('filemanager_path_relative','1','combo-boolean','core','file',NULL),
	('filemanager_url','','textfield','core','file',NULL),
	('filemanager_url_relative','1','combo-boolean','core','file',NULL),
	('forgot_login_email','<p>Hello [[+username]],</p>\n<p>A request for a password reset has been issued for your MODX user. If you sent this, you may follow this link and use this password to login. If you did not send this request, please ignore this email.</p>\n\n<p>\n    <strong>Activation Link:</strong> [[+url_scheme]][[+http_host]][[+manager_url]]?modahsh=[[+hash]]<br />\n    <strong>Username:</strong> [[+username]]<br />\n    <strong>Password:</strong> [[+password]]<br />\n</p>\n\n<p>After you log into the MODX Manager, you can change your password again, if you wish.</p>\n\n<p>Regards,<br />Site Administrator</p>','textarea','core','authentication',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','textfield','core','furls',NULL),
	('friendly_alias_realtime','0','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','0','combo-boolean','core','furls',NULL),
	('friendly_urls_strict','0','combo-boolean','core','furls',NULL),
	('global_duplicate_uri_check','0','combo-boolean','core','furls',NULL),
	('hidemenu_default','0','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','textfield','core','system',NULL),
	('log_deprecated','1','combo-boolean','core','system',NULL),
	('log_level','1','textfield','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_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','textfield','core','mail',NULL),
	('mail_smtp_prefix','','textfield','core','mail',NULL),
	('mail_smtp_single_to','','combo-boolean','core','mail',NULL),
	('mail_smtp_timeout','10','textfield','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','','textfield','core','manager',NULL),
	('manager_js_cache_file_locking','1','combo-boolean','core','manager',NULL),
	('manager_js_cache_max_age','3600','textfield','core','manager',NULL),
	('manager_js_document_root','','textfield','core','manager',NULL),
	('manager_js_zlib_output_compression','0','combo-boolean','core','manager',NULL),
	('manager_language','en','modx-combo-language','core','language',NULL),
	('manager_lang_attribute','en','textfield','core','language',NULL),
	('manager_login_url_alternate','','textfield','core','authentication',NULL),
	('manager_theme','default','modx-combo-manager-theme','core','manager',NULL),
	('manager_time_format','g:i a','textfield','core','manager',NULL),
	('manager_use_fullname','','combo-boolean','core','manager',NULL),
	('manager_week_start','0','textfield','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),
	('password_generated_length','10','textfield','core','authentication',NULL),
	('password_min_length','8','textfield','core','authentication',NULL),
	('phpthumb_allow_src_above_docroot','','combo-boolean','core','phpthumb',NULL),
	('phpthumb_cache_maxage','30','textfield','core','phpthumb',NULL),
	('phpthumb_cache_maxfiles','10000','textfield','core','phpthumb',NULL),
	('phpthumb_cache_maxsize','100','textfield','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','textfield','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','1','combo-boolean','core','manager',NULL),
	('principal_targets','modAccessContext,modAccessResourceGroup,modAccessCategory,sources.modAccessMediaSource,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','','textfield','core','proxy',NULL),
	('proxy_username','','textfield','core','proxy',NULL),
	('publish_default','','combo-boolean','core','site',NULL),
	('rb_base_dir','','textfield','core','file',NULL),
	('rb_base_url','','textfield','core','file',NULL),
	('request_controller','index.php','textfield','core','gateway',NULL),
	('request_method_strict','0','combo-boolean','core','gateway',NULL),
	('request_param_alias','q','textfield','core','gateway',NULL),
	('request_param_id','id','textfield','core','gateway',NULL),
	('resolve_hostnames','0','combo-boolean','core','system',NULL),
	('resource_tree_node_name','pagetitle','textfield','core','manager',NULL),
	('resource_tree_node_name_fallback','pagetitle','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','0','combo-boolean','core','system',NULL),
	('server_offset_time','0','textfield','core','system',NULL),
	('server_protocol','http','textfield','core','system',NULL),
	('session_cookie_domain','','textfield','core','session',NULL),
	('session_cookie_httponly','1','combo-boolean','core','session',NULL),
	('session_cookie_lifetime','604800','textfield','core','session',NULL),
	('session_cookie_path','','textfield','core','session',NULL),
	('session_cookie_secure','','combo-boolean','core','session',NULL),
	('session_gc_maxlifetime','604800','textfield','core','session',NULL),
	('session_handler_class','modSessionHandler','textfield','core','session',NULL),
	('session_name','','textfield','core','session',NULL),
	('settings_distro','traditional','textfield','core','system',NULL),
	('settings_version','2.7.1-pl','textfield','core','system',NULL),
	('set_header','1','combo-boolean','core','system',NULL),
	('show_tv_categories_header','1','combo-boolean','core','manager',NULL),
	('signupemail_message','<p>Hello [[+uid]],</p>\n    <p>Here are your login details for the [[+sname]] MODX Manager:</p>\n\n    <p>\n        <strong>Username:</strong> [[+uid]]<br />\n        <strong>Password:</strong> [[+pwd]]<br />\n    </p>\n\n    <p>Once you log into the MODX Manager at [[+surl]], you can change your password.</p>\n\n    <p>Regards,<br />Site Administrator</p>','textarea','core','authentication',NULL),
	('site_name','MODX Revolution','textfield','core','site',NULL),
	('site_start','1','textfield','core','site',NULL),
	('site_status','1','combo-boolean','core','site',NULL),
	('site_unavailable_message','The site is currently unavailable','textfield','core','site',NULL),
	('site_unavailable_page','0','textfield','core','site',NULL),
	('static_elements_automate_chunks','0','combo-boolean','core','static_elements',NULL),
	('static_elements_automate_plugins','0','combo-boolean','core','static_elements',NULL),
	('static_elements_automate_snippets','0','combo-boolean','core','static_elements',NULL),
	('static_elements_automate_templates','0','combo-boolean','core','static_elements',NULL),
	('static_elements_automate_tvs','0','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),
	('strip_image_paths','1','combo-boolean','core','file',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','0','combo-boolean','core','manager',NULL),
	('udperms_allowroot','','combo-boolean','core','authentication',NULL),
	('unauthorized_page','1','textfield','core','site',NULL),
	('upload_files','txt,html,htm,xml,js,css,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,odt,ods,odp,odb,odg,odf,md,ttf,woff,eot,scss,less,css.map','textfield','core','file',NULL),
	('upload_flash','swf,fla','textfield','core','file',NULL),
	('upload_images','jpg,jpeg,png,gif,psd,ico,bmp,tiff,svg,svgz','textfield','core','file',NULL),
	('upload_maxsize','104857600','textfield','core','file','2019-04-02 09:08:49'),
	('upload_media','mp3,wav,au,wmv,avi,mpg,mpeg','textfield','core','file',NULL),
	('user_nav_parent','usernav','textfield','core','manager',NULL),
	('use_alias_path','0','combo-boolean','core','furls',NULL),
	('use_browser','1','combo-boolean','core','file',NULL),
	('use_context_resource_table','1','combo-boolean','core','caching',NULL),
	('use_editor','1','combo-boolean','core','editor',NULL),
	('use_frozen_parent_uris','0','combo-boolean','core','furls',NULL),
	('use_multibyte','1','combo-boolean','core','language','2019-04-02 09:08:49'),
	('use_weblink_target','','combo-boolean','core','site',NULL),
	('webpwdreminder_message','<p>Hello [[+uid]],</p>\n\n    <p>To activate your new password click the following link:</p>\n\n    <p>[[+surl]]</p>\n\n    <p>If successful you can use the following password to login:</p>\n\n    <p><strong>Password:</strong> [[+pwd]]</p>\n\n    <p>If you did not request this email then please ignore it.</p>\n\n    <p>Regards,<br />\n    Site Administrator</p>','textarea','core','authentication',NULL),
	('websignupemail_message','<p>Hello [[+uid]],</p>\n\n    <p>Here are your login details for [[+sname]]:</p>\n\n    <p><strong>Username:</strong> [[+uid]]<br />\n    <strong>Password:</strong> [[+pwd]]</p>\n\n    <p>Once you log into [[+sname]] at [[+surl]], you can change your password.</p>\n\n    <p>Regards,<br />\n    Site Administrator</p>','textarea','core','authentication',NULL),
	('welcome_action','welcome','textfield','core','manager',NULL),
	('welcome_namespace','core','textfield','core','manager',NULL),
	('welcome_screen','','combo-boolean','core','manager','2019-04-02 09:09:48'),
	('welcome_screen_url','//misc.modx.com/revolution/welcome.27.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);



# Dump of table modx_transport_packages
# ------------------------------------------------------------


CREATE TABLE `modx_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;



# Dump of table modx_transport_providers
# ------------------------------------------------------------


CREATE TABLE `modx_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;


INSERT INTO `modx_transport_providers` (`id`, `name`, `description`, `service_url`, `username`, `api_key`, `created`, `updated`, `active`, `priority`, `properties`)
VALUES
	(1,'modx.com','The official MODX transport provider for 3rd party components.','https://rest.modx.com/extras/','','','2019-02-14 17:13:52',NULL,1,10,'');



# Dump of table modx_user_attributes
# ------------------------------------------------------------


CREATE TABLE `modx_user_attributes` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `internalKey` int(10) 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` int(1) NOT NULL DEFAULT '0',
  `address` text NOT NULL,
  `country` varchar(191) NOT NULL DEFAULT '',
  `city` varchar(191) NOT NULL DEFAULT '',
  `state` varchar(25) NOT NULL DEFAULT '',
  `zip` varchar(25) NOT NULL DEFAULT '',
  `fax` varchar(100) NOT NULL DEFAULT '',
  `photo` varchar(191) NOT NULL DEFAULT '',
  `comment` text NOT NULL,
  `website` varchar(191) NOT NULL DEFAULT '',
  `extended` text,
  PRIMARY KEY (`id`),
  UNIQUE KEY `internalKey` (`internalKey`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


INSERT INTO `modx_user_attributes` (`id`, `internalKey`, `fullname`, `email`, `phone`, `mobilephone`, `blocked`, `blockeduntil`, `blockedafter`, `logincount`, `lastlogin`, `thislogin`, `failedlogincount`, `sessionid`, `dob`, `gender`, `address`, `country`, `city`, `state`, `zip`, `fax`, `photo`, `comment`, `website`, `extended`)
VALUES
	(1,1,'Default Admin User','swyern@halifax.ca','','',0,0,0,4,1554208446,1554211766,0,'9hf7cqffd6m5uo0d13ga1nbre1',0,0,'','','','','','','','','',NULL);



# Dump of table modx_user_group_roles
# ------------------------------------------------------------


CREATE TABLE `modx_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;


INSERT INTO `modx_user_group_roles` (`id`, `name`, `description`, `authority`)
VALUES
	(1,'Member',NULL,9999),
	(2,'Super User',NULL,0);



# Dump of table modx_user_group_settings
# ------------------------------------------------------------


CREATE TABLE `modx_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(191) NOT NULL DEFAULT '',
  `editedon` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`group`,`key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



# Dump of table modx_user_messages
# ------------------------------------------------------------


CREATE TABLE `modx_user_messages` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `type` varchar(15) NOT NULL DEFAULT '',
  `subject` varchar(191) NOT NULL DEFAULT '',
  `message` text NOT NULL,
  `sender` int(10) NOT NULL DEFAULT '0',
  `recipient` int(10) 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;



# Dump of table modx_user_settings
# ------------------------------------------------------------


CREATE TABLE `modx_user_settings` (
  `user` int(11) 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(191) NOT NULL DEFAULT '',
  `editedon` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`user`,`key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



# Dump of table modx_users
# ------------------------------------------------------------


CREATE TABLE `modx_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 '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 '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;


INSERT INTO `modx_users` (`id`, `username`, `password`, `cachepwd`, `class_key`, `active`, `remote_key`, `remote_data`, `hash_class`, `salt`, `primary_group`, `session_stale`, `sudo`, `createdon`)
VALUES
	(1,'admin','$2y$10$u2xxyKbCoPzicwWUNI1L8ucPruXQEDlxqILV1Muufr9zFaYKTnPNW','','modUser',1,NULL,NULL,'hashing.modNative','aa728ad3f7b9487e8c80b0494c9944fe',1,NULL,1,1554206929);



# Dump of table modx_workspaces
# ------------------------------------------------------------


CREATE TABLE `modx_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;


INSERT INTO `modx_workspaces` (`id`, `name`, `path`, `created`, `active`, `attributes`)
VALUES
	(1,'Default MODX workspace','{core_path}','2019-04-02 09:08:32',1,NULL);




