Index: openacs-4/packages/acs-kernel/acs-kernel.info =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/acs-kernel.info,v diff -u -N -r1.150.2.29 -r1.150.2.30 --- openacs-4/packages/acs-kernel/acs-kernel.info 24 Mar 2021 17:00:08 -0000 1.150.2.29 +++ openacs-4/packages/acs-kernel/acs-kernel.info 5 Jul 2021 11:30:23 -0000 1.150.2.30 @@ -9,15 +9,15 @@ f t - + OpenACS Core Team Routines and data models providing the foundation for OpenACS-based Web services. 2017-08-06 OpenACS The OpenACS kernel contains the core datamodel create and drop scripts for such things as objects, groups, parties and the supporting PL/SQL and PL/pgSQL procedures. 3 - + Index: openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-5.10.0d32-5.10.0d33.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/oracle/upgrade/Attic/upgrade-5.10.0d32-5.10.0d33.sql,v diff -u -N --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-5.10.0d32-5.10.0d33.sql 5 Jul 2021 11:30:24 -0000 1.1.2.1 @@ -0,0 +1,6 @@ + +-- Make sure all emails are stored as lowercase +-- Untested +update parties set + email = lower(email) + where email <> lower(email); Index: openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.10.0d32-5.10.0d33.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/postgresql/upgrade/Attic/upgrade-5.10.0d32-5.10.0d33.sql,v diff -u -N --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.10.0d32-5.10.0d33.sql 5 Jul 2021 11:30:24 -0000 1.1.2.1 @@ -0,0 +1,5 @@ + +-- Make sure all emails are stored as lowercase +update parties set + email = lower(email) + where email <> lower(email);