Index: openacs-4/packages/calendar/calendar.info =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/calendar/calendar.info,v diff -u -r1.31.2.3 -r1.31.2.4 --- openacs-4/packages/calendar/calendar.info 26 Sep 2005 08:44:57 -0000 1.31.2.3 +++ openacs-4/packages/calendar/calendar.info 1 Dec 2005 22:37:33 -0000 1.31.2.4 @@ -7,14 +7,14 @@ f f - + Dirk Gomez Personal and shared event calendars. 2004-03-04 OpenACS Manage group and shared calendars with download. - + Index: openacs-4/packages/calendar/sql/oracle/cal-item-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/calendar/sql/oracle/cal-item-create.sql,v diff -u -r1.10 -r1.10.6.1 --- openacs-4/packages/calendar/sql/oracle/cal-item-create.sql 1 Feb 2004 16:51:07 -0000 1.10 +++ openacs-4/packages/calendar/sql/oracle/cal-item-create.sql 1 Dec 2005 22:37:33 -0000 1.10.6.1 @@ -74,6 +74,7 @@ by a calendar '; +create index cal_items_on_which_calendar_idx on cal_items (on_which_calendar); ------------------------------------------------------------- -- create package cal_item Index: openacs-4/packages/calendar/sql/oracle/cal-item-drop.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/calendar/sql/oracle/cal-item-drop.sql,v diff -u -r1.1 -r1.1.14.1 --- openacs-4/packages/calendar/sql/oracle/cal-item-drop.sql 17 Sep 2001 13:40:18 -0000 1.1 +++ openacs-4/packages/calendar/sql/oracle/cal-item-drop.sql 1 Dec 2005 22:37:33 -0000 1.1.14.1 @@ -24,6 +24,8 @@ drop package cal_item; +drop index cal_items_on_which_calendar_idx; + -- drop table drop table cal_items; Fisheye: Tag 1.1 refers to a dead (removed) revision in file `openacs-4/packages/calendar/sql/oracle/upgrade/upgrade-2.1.0b4-2.1.0b5.sql'. Fisheye: No comparison available. Pass `N' to diff? Index: openacs-4/packages/calendar/sql/postgresql/cal-item-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/calendar/sql/postgresql/cal-item-create.sql,v diff -u -r1.12 -r1.12.6.1 --- openacs-4/packages/calendar/sql/postgresql/cal-item-create.sql 1 Feb 2004 16:51:07 -0000 1.12 +++ openacs-4/packages/calendar/sql/postgresql/cal-item-create.sql 1 Dec 2005 22:37:34 -0000 1.12.6.1 @@ -96,6 +96,7 @@ by a calendar '; +create index cal_items_on_which_calendar_idx on cal_items (on_which_calendar); ------------------------------------------------------------- -- create package cal_item Index: openacs-4/packages/calendar/sql/postgresql/cal-item-drop.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/calendar/sql/postgresql/cal-item-drop.sql,v diff -u -r1.6 -r1.6.6.1 --- openacs-4/packages/calendar/sql/postgresql/cal-item-drop.sql 10 Jan 2004 18:57:24 -0000 1.6 +++ openacs-4/packages/calendar/sql/postgresql/cal-item-drop.sql 1 Dec 2005 22:37:34 -0000 1.6.6.1 @@ -32,6 +32,8 @@ drop function cal_item__delete (integer); +drop index cal_items_on_which_calendar_idx; + drop table cal_items; --drop objects delete from acs_objects where object_type='cal_item'; Fisheye: Tag 1.1 refers to a dead (removed) revision in file `openacs-4/packages/calendar/sql/postgresql/upgrade/upgrade-2.1.0b4-2.1.0b5.sql'. Fisheye: No comparison available. Pass `N' to diff?