Index: openacs-4/packages/attachments/sql/oracle/attachments-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/attachments/sql/oracle/attachments-create.sql,v
diff -u -r1.4 -r1.5
--- openacs-4/packages/attachments/sql/oracle/attachments-create.sql	30 Aug 2002 14:44:06 -0000	1.4
+++ openacs-4/packages/attachments/sql/oracle/attachments-create.sql	17 May 2003 10:11:35 -0000	1.5
@@ -30,6 +30,9 @@
                                 primary key (package_id, folder_id)
 );
 
+--RI Indexes
+create index attachments_fsr_fm_folder_id_i ON attachments_fs_root_folder_map(folder_id);
+
 create table attachments (
     object_id                   constraint attachments_object_id_fk
                                 references acs_objects (object_id)
@@ -46,3 +49,7 @@
     constraint                  attachments_pk
                                 primary key (object_id, item_id)
 );
+
+--RI Indexes
+create index attachments_item_id_idx ON attachments(item_id);
+