Created
February 7, 2017 13:24
-
-
Save stephdl/4c8cd626d0332fb95d5375e8cd770a16 to your computer and use it in GitHub Desktop.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| USE moodle; | |
| CREATE TABLE IF NOT EXISTS `mdl_config` ( | |
| `id` bigint(10) NOT NULL AUTO_INCREMENT, | |
| `name` varchar(255) NOT NULL DEFAULT '', | |
| `value` longtext NOT NULL, | |
| PRIMARY KEY (`id`), | |
| UNIQUE KEY `mdl_conf_nam_uix` (`name`) | |
| ) ENGINE=InnoDB AUTO_INCREMENT=466 DEFAULT CHARSET=utf8 COMMENT='Moodle configuration variables'; | |
| LOCK TABLES `mdl_config` WRITE; | |
| REPLACE INTO `mdl_config` VALUES (NULL,'auth','email,ldap'); | |
| UNLOCK TABLES; | |
| CREATE TABLE IF NOT EXISTS `mdl_config_plugins` ( | |
| `id` bigint(10) NOT NULL AUTO_INCREMENT, | |
| `plugin` varchar(100) NOT NULL DEFAULT 'core', | |
| `name` varchar(100) NOT NULL DEFAULT '', | |
| `value` longtext NOT NULL, | |
| PRIMARY KEY (`id`), | |
| UNIQUE KEY `mdl_confplug_plunam_uix` (`plugin`,`name`) | |
| ) ENGINE=InnoDB AUTO_INCREMENT=1393 DEFAULT CHARSET=utf8 COMMENT='Moodle modules and plugins configuration variables'; | |
| LOCK TABLES `mdl_config_plugins` WRITE; | |
| REPLACE INTO `mdl_config_plugins` VALUES (NULL,'auth/ldap','host_url','ldaps://stephdl.dyndns.org/'); | |
| REPLACE INTO `mdl_config_plugins` VALUES (NULL,'auth/ldap','start_tls','0'); | |
| REPLACE INTO `mdl_config_plugins` VALUES (NULL,'auth/ldap','ldapencoding','utf-8'); | |
| REPLACE INTO `mdl_config_plugins` VALUES (NULL,'auth/ldap','pagesize','250'); | |
| REPLACE INTO `mdl_config_plugins` VALUES (NULL,'auth/ldap','contexts','cn=users,dc=stephdl,dc=dyndns,dc=org'); | |
| REPLACE INTO `mdl_config_plugins` VALUES (NULL,'auth/ldap','user_type','ad'); | |
| REPLACE INTO `mdl_config_plugins` VALUES (NULL,'auth/ldap','user_attribute',''); | |
| REPLACE INTO `mdl_config_plugins` VALUES (NULL,'auth/ldap','suspended_attribute','samaccountname'); | |
| REPLACE INTO `mdl_config_plugins` VALUES (NULL,'auth/ldap','sync_suspended','0'); | |
| REPLACE INTO `mdl_config_plugins` VALUES (NULL,'auth/ldap','search_sub','1'); | |
| REPLACE INTO `mdl_config_plugins` VALUES (NULL,'auth/ldap','opt_deref','0'); | |
| REPLACE INTO `mdl_config_plugins` VALUES (NULL,'auth/ldap','preventpassindb','1'); | |
| REPLACE INTO `mdl_config_plugins` VALUES (NULL,'auth/ldap','bind_dn','STEPHDL\\NS7DEV$'); | |
| REPLACE INTO `mdl_config_plugins` VALUES (NULL,'auth/ldap','bind_pw','#VyT7rRzCx:m8m'); | |
| REPLACE INTO `mdl_config_plugins` VALUES (NULL,'auth/ldap','ldap_version','3'); | |
| REPLACE INTO `mdl_config_plugins` VALUES (NULL,'auth/ldap','objectclass','user'); | |
| REPLACE INTO `mdl_config_plugins` VALUES (NULL,'auth/ldap','memberattribute',''); | |
| REPLACE INTO `mdl_config_plugins` VALUES (NULL,'auth/ldap','memberattribute_isdn',''); | |
| REPLACE INTO `mdl_config_plugins` VALUES (NULL,'auth/ldap','creators','cn=staff,ou=Users,dc=stephdl,dc=dyndns,dc=org'); | |
| REPLACE INTO `mdl_config_plugins` VALUES (NULL,'auth/ldap','create_context',''); | |
| REPLACE INTO `mdl_config_plugins` VALUES (NULL,'auth/ldap','expiration','0'); | |
| REPLACE INTO `mdl_config_plugins` VALUES (NULL,'auth/ldap','expiration_warning','10'); | |
| REPLACE INTO `mdl_config_plugins` VALUES (NULL,'auth/ldap','expireattr',''); | |
| REPLACE INTO `mdl_config_plugins` VALUES (NULL,'auth/ldap','gracelogins','0'); | |
| REPLACE INTO `mdl_config_plugins` VALUES (NULL,'auth/ldap','graceattr',''); | |
| REPLACE INTO `mdl_config_plugins` VALUES (NULL,'auth/ldap','auth_user_create','0'); | |
| REPLACE INTO `mdl_config_plugins` VALUES (NULL,'auth/ldap','forcechangepassword','0'); | |
| REPLACE INTO `mdl_config_plugins` VALUES (NULL,'auth/ldap','stdchangepassword','0'); | |
| REPLACE INTO `mdl_config_plugins` VALUES (NULL,'auth/ldap','passtype','plaintext'); | |
| REPLACE INTO `mdl_config_plugins` VALUES (NULL,'auth/ldap','changepasswordurl',''); | |
| REPLACE INTO `mdl_config_plugins` VALUES (NULL,'auth/ldap','removeuser','2'); | |
| REPLACE INTO `mdl_config_plugins` VALUES (NULL,'auth/ldap','ntlmsso_enabled','1'); | |
| REPLACE INTO `mdl_config_plugins` VALUES (NULL,'auth/ldap','ntlmsso_subnet','192.168.12.0/24'); | |
| REPLACE INTO `mdl_config_plugins` VALUES (NULL,'auth/ldap','ntlmsso_ie_fastpath','0'); | |
| REPLACE INTO `mdl_config_plugins` VALUES (NULL,'auth/ldap','ntlmsso_type','kerberos'); | |
| REPLACE INTO `mdl_config_plugins` VALUES (NULL,'auth/ldap','ntlmsso_remoteuserformat','%domain%\\%username%'); | |
| REPLACE INTO `mdl_config_plugins` VALUES (NULL,'auth/ldap','field_map_firstname','givenName'); | |
| REPLACE INTO `mdl_config_plugins` VALUES (NULL,'auth/ldap','field_updatelocal_firstname','oncreate'); | |
| REPLACE INTO `mdl_config_plugins` VALUES (NULL,'auth/ldap','field_updateremote_firstname','0'); | |
| REPLACE INTO `mdl_config_plugins` VALUES (NULL,'auth/ldap','field_lock_firstname','unlocked'); | |
| REPLACE INTO `mdl_config_plugins` VALUES (NULL,'auth/ldap','field_map_lastname','sn'); | |
| REPLACE INTO `mdl_config_plugins` VALUES (NULL,'auth/ldap','field_updatelocal_lastname','oncreate'); | |
| REPLACE INTO `mdl_config_plugins` VALUES (NULL,'auth/ldap','field_updateremote_lastname','0'); | |
| REPLACE INTO `mdl_config_plugins` VALUES (NULL,'auth/ldap','field_lock_lastname','unlocked'); | |
| REPLACE INTO `mdl_config_plugins` VALUES (NULL,'auth/ldap','field_map_email','userPrincipalName'); | |
| REPLACE INTO `mdl_config_plugins` VALUES (NULL,'auth/ldap','field_updatelocal_email','oncreate'); | |
| REPLACE INTO `mdl_config_plugins` VALUES (NULL,'auth/ldap','field_updateremote_email','0'); | |
| REPLACE INTO `mdl_config_plugins` VALUES (NULL,'auth/ldap','field_lock_email','unlocked'); | |
| REPLACE INTO `mdl_config_plugins` VALUES (NULL,'auth/ldap','field_map_city',''); | |
| REPLACE INTO `mdl_config_plugins` VALUES (NULL,'auth/ldap','field_updatelocal_city','oncreate'); | |
| REPLACE INTO `mdl_config_plugins` VALUES (NULL,'auth/ldap','field_updateremote_city','0'); | |
| REPLACE INTO `mdl_config_plugins` VALUES (NULL,'auth/ldap','field_lock_city','unlocked'); | |
| REPLACE INTO `mdl_config_plugins` VALUES (NULL,'auth/ldap','field_map_country',''); | |
| REPLACE INTO `mdl_config_plugins` VALUES (NULL,'auth/ldap','field_updatelocal_country','oncreate'); | |
| REPLACE INTO `mdl_config_plugins` VALUES (NULL,'auth/ldap','field_updateremote_country','0'); | |
| REPLACE INTO `mdl_config_plugins` VALUES (NULL,'auth/ldap','field_lock_country','unlocked'); | |
| REPLACE INTO `mdl_config_plugins` VALUES (NULL,'auth/ldap','field_map_lang',''); | |
| REPLACE INTO `mdl_config_plugins` VALUES (NULL,'auth/ldap','field_updatelocal_lang','oncreate'); | |
| REPLACE INTO `mdl_config_plugins` VALUES (NULL,'auth/ldap','field_updateremote_lang','0'); | |
| REPLACE INTO `mdl_config_plugins` VALUES (NULL,'auth/ldap','field_lock_lang','unlocked'); | |
| REPLACE INTO `mdl_config_plugins` VALUES (NULL,'auth/ldap','field_map_description',''); | |
| REPLACE INTO `mdl_config_plugins` VALUES (NULL,'auth/ldap','field_updatelocal_description','oncreate'); | |
| REPLACE INTO `mdl_config_plugins` VALUES (NULL,'auth/ldap','field_updateremote_description','0'); | |
| REPLACE INTO `mdl_config_plugins` VALUES (NULL,'auth/ldap','field_lock_description','unlocked'); | |
| REPLACE INTO `mdl_config_plugins` VALUES (NULL,'auth/ldap','field_map_url',''); | |
| REPLACE INTO `mdl_config_plugins` VALUES (NULL,'auth/ldap','field_updatelocal_url','oncreate'); | |
| REPLACE INTO `mdl_config_plugins` VALUES (NULL,'auth/ldap','field_updateremote_url','0'); | |
| REPLACE INTO `mdl_config_plugins` VALUES (NULL,'auth/ldap','field_lock_url','unlocked'); | |
| REPLACE INTO `mdl_config_plugins` VALUES (NULL,'auth/ldap','field_map_idnumber',''); | |
| REPLACE INTO `mdl_config_plugins` VALUES (NULL,'auth/ldap','field_updatelocal_idnumber','oncreate'); | |
| REPLACE INTO `mdl_config_plugins` VALUES (NULL,'auth/ldap','field_updateremote_idnumber','0'); | |
| REPLACE INTO `mdl_config_plugins` VALUES (NULL,'auth/ldap','field_lock_idnumber','unlocked'); | |
| REPLACE INTO `mdl_config_plugins` VALUES (NULL,'auth/ldap','field_map_institution',''); | |
| REPLACE INTO `mdl_config_plugins` VALUES (NULL,'auth/ldap','field_updatelocal_institution','oncreate'); | |
| REPLACE INTO `mdl_config_plugins` VALUES (NULL,'auth/ldap','field_updateremote_institution','0'); | |
| REPLACE INTO `mdl_config_plugins` VALUES (NULL,'auth/ldap','field_lock_institution','unlocked'); | |
| REPLACE INTO `mdl_config_plugins` VALUES (NULL,'auth/ldap','field_map_department',''); | |
| REPLACE INTO `mdl_config_plugins` VALUES (NULL,'auth/ldap','field_updatelocal_department','oncreate'); | |
| REPLACE INTO `mdl_config_plugins` VALUES (NULL,'auth/ldap','field_updateremote_department','0'); | |
| REPLACE INTO `mdl_config_plugins` VALUES (NULL,'auth/ldap','field_lock_department','unlocked'); | |
| REPLACE INTO `mdl_config_plugins` VALUES (NULL,'auth/ldap','field_map_phone1',''); | |
| REPLACE INTO `mdl_config_plugins` VALUES (NULL,'auth/ldap','field_updatelocal_phone1','oncreate'); | |
| REPLACE INTO `mdl_config_plugins` VALUES (NULL,'auth/ldap','field_updateremote_phone1','0'); | |
| REPLACE INTO `mdl_config_plugins` VALUES (NULL,'auth/ldap','field_lock_phone1','unlocked'); | |
| REPLACE INTO `mdl_config_plugins` VALUES (NULL,'auth/ldap','field_map_phone2',''); | |
| REPLACE INTO `mdl_config_plugins` VALUES (NULL,'auth/ldap','field_updatelocal_phone2','oncreate'); | |
| REPLACE INTO `mdl_config_plugins` VALUES (NULL,'auth/ldap','field_updateremote_phone2','0'); | |
| REPLACE INTO `mdl_config_plugins` VALUES (NULL,'auth/ldap','field_lock_phone2','unlocked'); | |
| REPLACE INTO `mdl_config_plugins` VALUES (NULL,'auth/ldap','field_map_address',''); | |
| REPLACE INTO `mdl_config_plugins` VALUES (NULL,'auth/ldap','field_updatelocal_address','oncreate'); | |
| REPLACE INTO `mdl_config_plugins` VALUES (NULL,'auth/ldap','field_updateremote_address','0'); | |
| REPLACE INTO `mdl_config_plugins` VALUES (NULL,'auth/ldap','field_lock_address','unlocked'); | |
| REPLACE INTO `mdl_config_plugins` VALUES (NULL,'auth/ldap','field_map_firstnamephonetic',''); | |
| REPLACE INTO `mdl_config_plugins` VALUES (NULL,'auth/ldap','field_updatelocal_firstnamephonetic','oncreate'); | |
| REPLACE INTO `mdl_config_plugins` VALUES (NULL,'auth/ldap','field_updateremote_firstnamephonetic','0'); | |
| REPLACE INTO `mdl_config_plugins` VALUES (NULL,'auth/ldap','field_lock_firstnamephonetic','unlocked'); | |
| REPLACE INTO `mdl_config_plugins` VALUES (NULL,'auth/ldap','field_map_lastnamephonetic',''); | |
| REPLACE INTO `mdl_config_plugins` VALUES (NULL,'auth/ldap','field_updatelocal_lastnamephonetic','oncreate'); | |
| REPLACE INTO `mdl_config_plugins` VALUES (NULL,'auth/ldap','field_updateremote_lastnamephonetic','0'); | |
| REPLACE INTO `mdl_config_plugins` VALUES (NULL,'auth/ldap','field_lock_lastnamephonetic','unlocked'); | |
| REPLACE INTO `mdl_config_plugins` VALUES (NULL,'auth/ldap','field_map_middlename',''); | |
| REPLACE INTO `mdl_config_plugins` VALUES (NULL,'auth/ldap','field_updatelocal_middlename','oncreate'); | |
| REPLACE INTO `mdl_config_plugins` VALUES (NULL,'auth/ldap','field_updateremote_middlename','0'); | |
| REPLACE INTO `mdl_config_plugins` VALUES (NULL,'auth/ldap','field_lock_middlename','unlocked'); | |
| REPLACE INTO `mdl_config_plugins` VALUES (NULL,'auth/ldap','field_map_alternatename',''); | |
| REPLACE INTO `mdl_config_plugins` VALUES (NULL,'auth/ldap','field_updatelocal_alternatename','oncreate'); | |
| REPLACE INTO `mdl_config_plugins` VALUES (NULL,'auth/ldap','field_updateremote_alternatename','0'); | |
| REPLACE INTO `mdl_config_plugins` VALUES (NULL,'auth/ldap','field_lock_alternatename','unlocked'); | |
| UNLOCK TABLES; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment