Skip to content

Instantly share code, notes, and snippets.

@stephdl
Created February 7, 2017 13:24
Show Gist options
  • Select an option

  • Save stephdl/4c8cd626d0332fb95d5375e8cd770a16 to your computer and use it in GitHub Desktop.

Select an option

Save stephdl/4c8cd626d0332fb95d5375e8cd770a16 to your computer and use it in GitHub Desktop.
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