Index: openacs-4/packages/acs-events/acs-events.info =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-events/acs-events.info,v diff -u -N -r1.29 -r1.30 --- openacs-4/packages/acs-events/acs-events.info 4 Jul 2018 17:26:55 -0000 1.29 +++ openacs-4/packages/acs-events/acs-events.info 11 Jul 2018 16:21:58 -0000 1.30 @@ -7,14 +7,14 @@ f t - + OpenACS API support for relationships between intervals in time, activities, and parties. 2017-08-06 OpenACS The events service is primarily intended for use by writers of application packages and other service packages. The service allows developers to specify and manipulate relationships (possibly recurring) between an object and another object. 2 - + Index: openacs-4/packages/acs-events/sql/postgresql/acs-events-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-events/sql/postgresql/acs-events-create.sql,v diff -u -N -r1.24 -r1.25 --- openacs-4/packages/acs-events/sql/postgresql/acs-events-create.sql 4 Jul 2018 17:26:55 -0000 1.24 +++ openacs-4/packages/acs-events/sql/postgresql/acs-events-create.sql 11 Jul 2018 16:21:58 -0000 1.25 @@ -26,12 +26,12 @@ -- Event object PERFORM acs_object_type__create_type ( - 'acs_event', -- object_type + 'acs_event', -- object_type 'ACS Event', -- pretty_name 'ACS Events', -- pretty_plural - 'acs_object', -- supertype - 'ACS_EVENTS', -- table_name - 'EVENT_ID', -- id_column + 'acs_object', -- supertype + 'acs_events', -- table_name + 'event_id', -- id_column null, -- package_name (default) 'f', -- abstract_p (default) null, -- type_extension_table (default) Index: openacs-4/packages/acs-events/sql/postgresql/activity-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-events/sql/postgresql/activity-create.sql,v diff -u -N -r1.8 -r1.9 --- openacs-4/packages/acs-events/sql/postgresql/activity-create.sql 4 Jul 2018 17:26:55 -0000 1.8 +++ openacs-4/packages/acs-events/sql/postgresql/activity-create.sql 11 Jul 2018 16:21:58 -0000 1.9 @@ -25,8 +25,8 @@ 'Activity', -- pretty_name 'Activities', -- pretty_plural 'acs_object', -- supertype - 'ACS_ACTIVITIES', -- table_name - 'ACTIVITY_ID', -- id_column + 'acs_activities', -- table_name + 'activity_id', -- id_column 'null', -- package_name (default) 'f', -- abstract_p (default) null, -- type_extension_table (default) Index: openacs-4/packages/acs-events/sql/postgresql/upgrade/upgrade-0.6.2d3-0.6.2d4.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-events/sql/postgresql/upgrade/upgrade-0.6.2d3-0.6.2d4.sql,v diff -u -N --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/packages/acs-events/sql/postgresql/upgrade/upgrade-0.6.2d3-0.6.2d4.sql 11 Jul 2018 16:21:58 -0000 1.1 @@ -0,0 +1,8 @@ + +DO $$ +BEGIN + update acs_object_types set + table_name = lower(table_name), + id_column = lower(id_column) + where object_type in ('acs_activity', 'acs_event'); +END$$;