Index: openacs-4/packages/photo-album/sql/postgresql/photo-album-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/photo-album/sql/postgresql/photo-album-create.sql,v
diff -u -r1.3 -r1.4
--- openacs-4/packages/photo-album/sql/postgresql/photo-album-create.sql	20 Nov 2003 13:03:54 -0000	1.3
+++ openacs-4/packages/photo-album/sql/postgresql/photo-album-create.sql	29 Apr 2004 15:23:05 -0000	1.4
@@ -307,16 +307,18 @@
 		   constraint pa_pack_fldr_map_pk
 		   primary key
                    constraint pa_pack_fldr_map_pack_id_fk
-		   references apm_packages,
+		   references apm_packages on delete cascade,
   folder_id	   integer
 		   constraint pa_pack_fldr_map_fldr_id_fk
-		   references cr_folders
+        	   references cr_folders on delete cascade
 		   constraint pa_pack_fldr_map_fldr_id_unq
 		   unique
 );
 
-create index pa_package_folder_map_by_pack on pa_package_root_folder_map (package_id, folder_id);
+--There cannot be much if any benefit from this index.  
+--create index pa_package_folder_map_by_pack on pa_package_root_folder_map (package_id, folder_id);
 
+
 comment on table pa_package_root_folder_map is '
   Table to keep track of root folder for each instance of the photo-album
   Used for sub-site support.  Each instance of the photo album has a unique