Index: openacs-4/packages/dotlrn/sql/oracle/upgrade/upgrade-jun-07-2002.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/sql/oracle/upgrade/upgrade-jun-07-2002.sql,v diff -u -r1.1 -r1.2 --- openacs-4/packages/dotlrn/sql/oracle/upgrade/upgrade-jun-07-2002.sql 7 Jun 2002 04:45:07 -0000 1.1 +++ openacs-4/packages/dotlrn/sql/oracle/upgrade/upgrade-jun-07-2002.sql 7 Jun 2002 05:00:37 -0000 1.2 @@ -1,2 +1,2 @@ -create index dtlrn_com_all_com_parent_id_idx on dotlrn_communities_all (community_id, parent_community_id; +create index dtlrn_com_all_c_p_idx on dotlrn_communities_all (community_id, parent_community_id); create index dtlrn_com_all_archived_p_idx on dotlrn_communities_all (archived_p);