Index: openacs-4/packages/acs-kernel/sql/oracle/apm-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/oracle/apm-create.sql,v
diff -u -r1.33 -r1.34
--- openacs-4/packages/acs-kernel/sql/oracle/apm-create.sql	18 Jan 2005 16:22:09 -0000	1.33
+++ openacs-4/packages/acs-kernel/sql/oracle/apm-create.sql	23 Feb 2005 10:07:00 -0000	1.34
@@ -166,7 +166,7 @@
 create index apm_packages_package_key_idx on apm_packages (package_key);
 
 -- This cant be added at table create time since acs_objects is created before apm_packages;
-alter table acs_objects add constraint acs_objects_package_id_fk foreign key (package_id) references apm_packages(package_id);
+alter table acs_objects add constraint acs_objects_package_id_fk foreign key (package_id) references apm_packages(package_id) on delete set null;
 
 comment on table apm_packages is '
    This table maintains the list of all package instances in the sytem. 
