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