Case sensitive emails about adapt_authoring HOT 4 OPEN

#2060

from adapt_authoring.

A quick fix, is to update the records in users collection. Here is a sample script which can be executed in mongo shell.

show dbs;
use adapt-tenant-master;
db.users.find({}).forEach(function(doc){ 
	var email = doc.email.toLowerCase();
	db.users.update({_id:doc._id},  {$set: {"email": email} });
});

Verifying after executing the above script.

db.users.find({}).pretty();

from adapt_authoring.

Add the above code to migration script

from adapt_authoring.

Removed from 0.11.2 milestone as it has been agreed that this is out of scope.

Anyone upgrading from older versions can use the information on this issue to upgrade using the Mongo script

from adapt_authoring.