Index: lams_common/db/sql/create_lams_11_tables.sql
===================================================================
diff -u -r1dbf40946efb1324c987cccf44c18ad5559cdc53 -rabdbcb3cf86ed9f5048624058123cb923d583f0c
--- lams_common/db/sql/create_lams_11_tables.sql	(.../create_lams_11_tables.sql)	(revision 1dbf40946efb1324c987cccf44c18ad5559cdc53)
+++ lams_common/db/sql/create_lams_11_tables.sql	(.../create_lams_11_tables.sql)	(revision abdbcb3cf86ed9f5048624058123cb923d583f0c)
@@ -338,6 +338,7 @@
       COMMENT 'ID used for Jabber';
 CREATE UNIQUE INDEX UQ_lams_user_login ON lams_user (login ASC);
 CREATE INDEX login ON lams_user (login ASC);
+CREATE INDEX email ON lams_user (email ASC);
 
 CREATE TABLE lams_learning_design (
        learning_design_id BIGINT(20) NOT NULL AUTO_INCREMENT
Index: lams_common/db/sql/updatescripts/alter_21_groupings_fckeditor.sql
===================================================================
diff -u -r84c9c8b927413215c8b22d2418be83f0a0931841 -rabdbcb3cf86ed9f5048624058123cb923d583f0c
--- lams_common/db/sql/updatescripts/alter_21_groupings_fckeditor.sql	(.../alter_21_groupings_fckeditor.sql)	(revision 84c9c8b927413215c8b22d2418be83f0a0931841)
+++ lams_common/db/sql/updatescripts/alter_21_groupings_fckeditor.sql	(.../alter_21_groupings_fckeditor.sql)	(revision abdbcb3cf86ed9f5048624058123cb923d583f0c)
@@ -44,3 +44,6 @@
      , PRIMARY KEY (request_id)
 )TYPE=InnoDB;
 CREATE UNIQUE INDEX IX_lams_psswd_rqst_key ON lams_password_request (request_key ASC);
+
+CREATE INDEX email ON lams_user (email ASC);
+