Index: openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.0d2-5.0d3.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.0d2-5.0d3.sql,v
diff -u -r1.9 -r1.10
--- openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.0d2-5.0d3.sql	1 Oct 2003 11:23:06 -0000	1.9
+++ openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.0d2-5.0d3.sql	17 Oct 2003 08:42:53 -0000	1.10
@@ -25,26 +25,30 @@
                              constraint auth_authority_enabled_p_nn
                              not null,
     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        varchar(4000),
     change_pwd_url           varchar(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             varchar(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     boolean default 'f'
                              constraint auth_authority_bs_enabled_p_nn
@@ -81,6 +85,24 @@
     null
 );
 
+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             varchar(200),
+      value           text,
+      unique (authority_id, impl_id)
+);
+
+
 -- Create PLSQL functions
 create or replace function authority__new (
     integer, -- authority_id
