Index: openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-5.5.0d1-5.5.0d2.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-5.5.0d1-5.5.0d2.sql,v diff -u -N -r1.1 -r1.2 --- openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-5.5.0d1-5.5.0d2.sql 8 Sep 2008 20:00:10 -0000 1.1 +++ openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-5.5.0d1-5.5.0d2.sql 19 Sep 2008 01:13:25 -0000 1.2 @@ -4,4 +4,5 @@ alter table auth_authorities add constraint auth_authority_allow_user_i_ck check (allow_user_entered_info_p in ('t','f')) alter table auth_authorities alter allow_user_entered_info_p set default 'f'; -alter table auth_authorities add search_impl_id integer constraint auth_authorities_search_impl_id_fk references acs_objects(object_id); +alter table auth_authorities add search_impl_id integer; +alter table auth_authorities add constraint foreign key auth_authorities_search_impl_id_fk (auth_authorities_search_impl_id) references acs_objects(object_id);