Index: openacs-4/packages/attachments/sql/postgresql/attachments-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/attachments/sql/postgresql/attachments-create.sql,v
diff -u -r1.3 -r1.4
--- openacs-4/packages/attachments/sql/postgresql/attachments-create.sql	30 Aug 2002 14:44:08 -0000	1.3
+++ openacs-4/packages/attachments/sql/postgresql/attachments-create.sql	17 May 2003 10:12:03 -0000	1.4
@@ -32,6 +32,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                   integer
 				constraint attachments_object_id_fk
@@ -50,3 +53,6 @@
     constraint                  attachments_pk
                                 primary key (object_id, item_id)
 );
+
+-- RI Indexes 
+create index attachments_item_id_idx ON attachments(item_id);