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. 
 ';
Index: openacs-4/packages/acs-kernel/sql/oracle/authentication-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/oracle/authentication-create.sql,v
diff -u -N -r1.11 -r1.12
--- openacs-4/packages/acs-kernel/sql/oracle/authentication-create.sql	16 Oct 2003 10:57:42 -0000	1.11
+++ openacs-4/packages/acs-kernel/sql/oracle/authentication-create.sql	1 Jul 2004 11:29:54 -0000	1.12
@@ -51,9 +51,13 @@
                              references acs_objects(object_id),
     -- batch sync
     -- auth_sync_retrieve implementation
-    get_doc_impl_id          integer references acs_objects(object_id),
+    get_doc_impl_id          integer 
+                             constraint auth_authority_getdoc_impl_fk
+                             references acs_objects(object_id),
     -- auth_sync_process implementation
-    process_doc_impl_id      integer references acs_objects(object_id),
+    process_doc_impl_id      integer 
+                             constraint auth_authority_procdoc_impl_fk
+                             references acs_objects(object_id),
     batch_sync_enabled_p     char(1) default 'f' 
                              constraint auth_authority_bs_enabled_p_nn
                              not null