Index: openacs-4/packages/acs-lang/sql/postgresql/ad-locales.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-lang/sql/postgresql/ad-locales.sql,v
diff -u -r1.33 -r1.33.6.1
--- openacs-4/packages/acs-lang/sql/postgresql/ad-locales.sql	17 Oct 2010 21:06:08 -0000	1.33
+++ openacs-4/packages/acs-lang/sql/postgresql/ad-locales.sql	25 Nov 2016 11:22:52 -0000	1.33.6.1
@@ -71,6 +71,9 @@
                         references ad_locales (locale) on delete cascade
 );
 
+-- index reference on users table
+create index ad_locale_user_prefs_user_id_idx on ad_locale_user_prefs(user_id);
+
 -- alter user_preferences to add the locale column
 
 alter table user_preferences add
