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 -N -r1.31 -r1.32 --- openacs-4/packages/acs-kernel/sql/oracle/apm-create.sql 29 Jun 2004 10:17:38 -0000 1.31 +++ openacs-4/packages/acs-kernel/sql/oracle/apm-create.sql 1 Jul 2004 11:29:54 -0000 1.32 @@ -165,6 +165,9 @@ -- create bitmap index apm_packages_package_key_idx on apm_packages (package_key); 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); + comment on table apm_packages is ' This table maintains the list of all package instances in the sytem. ';