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.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.
 ';
