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 -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);
Index: openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.5.0d1-5.5.0d2.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.5.0d1-5.5.0d2.sql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.5.0d1-5.5.0d2.sql	8 Sep 2008 20:00:10 -0000	1.1
+++ openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.5.0d1-5.5.0d2.sql	19 Sep 2008 01:13:25 -0000	1.2
@@ -1,5 +1,6 @@
 alter table auth_authorities add allow_user_entered_info_p boolean;
 update auth_authorities set allow_user_entered_info_p='f';
 alter table auth_authorities alter allow_user_entered_info_p set default 'f';
-alter table auth_authorities add constraint auth_authority_allow_user_i_p_nn (allow_user_entered_email_p) not null;
-alter table auth_authorities add search_impl_id integer constraint auth_authorities_search_impl_id_fk references acs_objects(object_id);
\ No newline at end of file
+alter table auth_authorities alter column  allow_user_entered_info_p set not null;
+alter table auth_authorities add search_impl_id integer;
+alter table auth_authorities add constraint auth_authorities_search_impl_id_fk foreign key (search_impl_id) references acs_objects(object_id);
\ No newline at end of file