Index: openacs-4/packages/acs-kernel/sql/postgresql/authentication-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/postgresql/authentication-create.sql,v
diff -u -r1.6 -r1.7
--- openacs-4/packages/acs-kernel/sql/postgresql/authentication-create.sql	29 Aug 2003 15:21:57 -0000	1.6
+++ openacs-4/packages/acs-kernel/sql/postgresql/authentication-create.sql	3 Sep 2003 19:52:38 -0000	1.7
@@ -75,22 +75,24 @@
 );
 
 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)
+    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,
+    constraint auth_driver_params_pk
+    primary key (authority_id, impl_id, key)
 );
 
+
 -- Create PLSQL package
 \i authentication-package-create.sql