Index: openacs-4/packages/acs-kernel/sql/oracle/community-core-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/oracle/community-core-create.sql,v
diff -u -r1.3 -r1.4
--- openacs-4/packages/acs-kernel/sql/oracle/community-core-create.sql	9 Mar 2002 02:00:02 -0000	1.3
+++ openacs-4/packages/acs-kernel/sql/oracle/community-core-create.sql	29 Mar 2002 17:10:44 -0000	1.4
@@ -533,6 +533,8 @@
 	password_answer		varchar2(1000)
 );
 
+create index users_email_verified_idx on users (email_verified_p);
+
 create table user_preferences (
 	user_id			constraint user_prefs_user_id_fk
 				references users (user_id)
