Differences

moodle:installation_and_configuration_issues [2016/05/30 09:25] onno [Anonymize All User Data in Moodle]		moodle:installation_and_configuration_issues [2016/05/30 09:28] (current) onno [Anonymize All User Data in Moodle]
Line 86:		Line 86:
	<code>		<code>
-	UPDATE mdl_user AS u SET u.firstname = 'Test', u.lastname = CONCAT('User', u.id), u.email = CONCAT(CONCAT('Test.User', u.id), '@solin.nl'), u.description = '', u.imagealt = '', u.lastip = '';	+	UPDATE mdl_user AS u SET u.firstname = 'Test', u.lastname = CONCAT('User', u.id), u.email = CONCAT(CONCAT('Test.User', u.id), '@solin.nl'), u.description = '', u.imagealt = '', u.lastip = '', u.address = '', u.department = '', u.lastnamephonetic = '', u.firstnamephonetic = '', u.alternatename = '', u.middlename = '';
	</code>		</code>
-	Please note: there could be other columns in your mdl_user table which could be used to identify users, such as country, city, department, address, lastnamephonetic, firstnamephonetic, alternatename and middlename.	+	Please note: there could be other columns in your mdl_user table which might be used to identify users, such as country and city.
	Use ''/admin/tool/replace/'' to search for a company name that is widely used and replace it with Anonymous Corp.		Use ''/admin/tool/replace/'' to search for a company name that is widely used and replace it with Anonymous Corp.