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.