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 -r1.24 -r1.25 --- openacs-4/packages/acs-events/acs-events.info 7 Aug 2017 23:47:56 -0000 1.24 +++ openacs-4/packages/acs-events/acs-events.info 9 Feb 2018 14:11:43 -0000 1.25 @@ -7,17 +7,16 @@ 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 -r1.20 -r1.21 --- openacs-4/packages/acs-events/sql/postgresql/acs-events-create.sql 27 Oct 2014 16:39:34 -0000 1.20 +++ openacs-4/packages/acs-events/sql/postgresql/acs-events-create.sql 9 Feb 2018 14:11:43 -0000 1.21 @@ -261,11 +261,13 @@ -- This is important to prevent locking on update of master table. -- See http://www.arsdigita.com/bboard/q-and-a-fetch-msg.tcl?msg_id=000KOh -create index acs_events_activity_id_ids on acs_events(activity_id); +create index acs_events_activity_id_idx on acs_events(activity_id); -- This is useful for looking up instances of an event create index acs_events_recurrence_id_idx on acs_events(recurrence_id); +create index acs_events_timespan_id_idx on acs_events(timespan_id); + comment on table acs_events is ' A relationship between a time span and an activity. '; Index: openacs-4/packages/acs-events/sql/postgresql/upgrade/upgrade-0.6-0.6.1.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-events/sql/postgresql/upgrade/upgrade-0.6-0.6.1.sql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/packages/acs-events/sql/postgresql/upgrade/upgrade-0.6-0.6.1.sql 9 Feb 2018 14:11:43 -0000 1.1 @@ -0,0 +1,5 @@ +-- Upgrade acs-events from 0.6 to 0.6.1 +-- Fixes typo in index name "acs_events_activity_id_ids" + +DROP INDEX IF EXISTS acs_events_activity_id_ids; +CREATE INDEX IF NOT EXISTS acs_events_activity_id_idx ON acs_events(activity_id);