Index: lams_common/db/sql/create_lams_11_tables.sql
===================================================================
RCS file: /usr/local/cvsroot/lams_common/db/sql/create_lams_11_tables.sql,v
diff -u -r1.112 -r1.113
--- lams_common/db/sql/create_lams_11_tables.sql	18 Mar 2008 04:20:37 -0000	1.112
+++ lams_common/db/sql/create_lams_11_tables.sql	14 Apr 2008 23:33:37 -0000	1.113
@@ -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
===================================================================
RCS file: /usr/local/cvsroot/lams_common/db/sql/updatescripts/Attic/alter_21_groupings_fckeditor.sql,v
diff -u -r1.3 -r1.4
--- lams_common/db/sql/updatescripts/alter_21_groupings_fckeditor.sql	21 Jan 2008 00:08:33 -0000	1.3
+++ lams_common/db/sql/updatescripts/alter_21_groupings_fckeditor.sql	14 Apr 2008 23:33:10 -0000	1.4
@@ -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);
+