Index: openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-5.0d2-5.0d3.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-5.0d2-5.0d3.sql,v
diff -u -r1.7 -r1.8
--- openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-5.0d2-5.0d3.sql	1 Oct 2003 11:23:06 -0000	1.7
+++ openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-5.0d2-5.0d3.sql	17 Oct 2003 08:42:53 -0000	1.8
@@ -27,26 +27,30 @@
                              constraint auth_authority_enabled_p_ck
                              check (enabled_p in ('t','f')),
     sort_order               integer not null,
-    -- Id of the authentication service contract implementation
-    -- Cannot reference acs_sc_impls table as it doesn't exist yet
+    -- auth_authentication implementation
+    -- (Cannot reference acs_sc_impls table as it doesn't exist yet)
     auth_impl_id             integer
                              constraint auth_authority_auth_impl_fk
                              references acs_objects(object_id),
-    -- Id of the password management service contact implementation
+    -- auth_password implementation
     pwd_impl_id              integer
                              constraint auth_authority_pwd_impl_fk
                              references acs_objects(object_id),
     forgotten_pwd_url        varchar2(4000),
     change_pwd_url           varchar2(4000),
-    -- Id of the registration service contract implementation
+    -- auth_registration implementation
     register_impl_id         integer
                              constraint auth_authority_reg_impl_fk
                              references acs_objects(object_id),
     register_url             varchar2(4000),
+    -- auth_user_info implementation
+    user_info_impl_id        integer
+                             constraint auth_authority_userinf_impl_fk
+                             references acs_objects(object_id),
     -- batch sync
-    -- Id of service contract getting batch sync doc
+    -- auth_sync_retrieve implementation
     get_doc_impl_id          integer references acs_objects(object_id),
-    -- Id of service contract processing batch sync doc
+    -- auth_sync_process implementation
     process_doc_impl_id      integer references acs_objects(object_id),
     batch_sync_enabled_p     char(1) default 'f' 
                              constraint auth_authority_bs_enabled_p_nn
@@ -88,6 +92,24 @@
 /
 show errors
 
+create table auth_driver_params(
+      authority_id    integer
+                      constraint auth_driver_params_aid_fk 
+                      references auth_authorities(authority_id)
+                      constraint auth_driver_params_aid_nn
+                      not null,
+      impl_id         integer
+                      constraint auth_driver_params_iid_fk
+                      -- Cannot reference acs_sc_impls table as it doesn't exist yet
+                      references acs_objects(object_id)
+                      constraint auth_driver_params_iid_nn
+                      not null,
+      key             varchar2(200),
+      value           clob,
+      constraint auth_driver_params_pk
+      primary key (authority_id, impl_id, key)
+);
+
 -- Create PLSQL package
 create or replace package authority
 as 
@@ -179,7 +201,7 @@
     return integer
     is
     begin
-        acs_object.delete(delete_authority_id);
+        acs_object.del(delete_authority_id);
 
         return 0;
     end del;
@@ -188,6 +210,7 @@
 /
 show errors
 
+
 -- Create the local authority
 declare
   v_authority_id integer;
