Index: openacs-4/packages/acs-lang/acs-lang.info =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-lang/acs-lang.info,v diff -u -N -r1.62.2.7 -r1.62.2.8 --- openacs-4/packages/acs-lang/acs-lang.info 20 May 2016 18:42:49 -0000 1.62.2.7 +++ openacs-4/packages/acs-lang/acs-lang.info 25 Nov 2016 11:22:52 -0000 1.62.2.8 @@ -9,7 +9,7 @@ f t - + Peter Marklund OpenACS Internationalization Support. 2015-10-04 @@ -20,7 +20,7 @@ GPL 3 - + 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 -N -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 Index: openacs-4/packages/acs-lang/sql/postgresql/upgrade/upgrade-5.9.1d1-5.9.1d2.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-lang/sql/postgresql/upgrade/upgrade-5.9.1d1-5.9.1d2.sql,v diff -u -N --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/packages/acs-lang/sql/postgresql/upgrade/upgrade-5.9.1d1-5.9.1d2.sql 25 Nov 2016 11:22:52 -0000 1.1.2.1 @@ -0,0 +1,3 @@ + +-- index reference on users table +create index ad_locale_user_prefs_user_id_idx on ad_locale_user_prefs(user_id);