Index: openacs-4/packages/acs-kernel/acs-kernel.info =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/acs-kernel.info,v diff -u -r1.44 -r1.45 --- openacs-4/packages/acs-kernel/acs-kernel.info 8 Oct 2003 16:05:24 -0000 1.44 +++ openacs-4/packages/acs-kernel/acs-kernel.info 16 Oct 2003 10:57:42 -0000 1.45 @@ -7,13 +7,13 @@ t t - + Don Baccus Routines and data models providing the foundation for OpenACS-based Web services. 2003-09-25 OpenACS - + Index: openacs-4/packages/acs-kernel/sql/oracle/authentication-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/oracle/authentication-create.sql,v diff -u -r1.10 -r1.11 --- openacs-4/packages/acs-kernel/sql/oracle/authentication-create.sql 8 Oct 2003 09:58:41 -0000 1.10 +++ openacs-4/packages/acs-kernel/sql/oracle/authentication-create.sql 16 Oct 2003 10:57:42 -0000 1.11 @@ -108,7 +108,8 @@ not null, key varchar2(200), value clob, - unique (authority_id, impl_id) + constraint auth_driver_params_pk + primary key (authority_id, impl_id, key) ); -- Create PLSQL package Index: openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-5.0.0a1-5.0.0a2.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-5.0.0a1-5.0.0a2.sql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-5.0.0a1-5.0.0a2.sql 16 Oct 2003 10:57:42 -0000 1.1 @@ -0,0 +1,17 @@ +-- +-- Upgrade script for acs-kernel +-- +-- Changes wrong unique constraint on auth_driver_params table to a primary key on authority_id, impl_id, key. +-- +-- +-- @author Lars Pind (lars@collaboraid.biz) +-- +-- @creation-date 2003-10-16 +-- +-- @cvs-id $Id: upgrade-5.0.0a1-5.0.0a2.sql,v 1.1 2003/10/16 10:57:42 lars Exp $ +-- + +alter table auth_driver_params drop unique (authority_id, impl_id); + +alter table auth_driver_params add constraint auth_driver_params_pk + primary key (authority_id, impl_id, key);