Index: openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.0.0a1-5.0.0a2.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.0.0a1-5.0.0a2.sql,v diff -u -N --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.0.0a1-5.0.0a2.sql 16 Jan 2004 23:54:48 -0000 1.1.2.1 @@ -0,0 +1,15 @@ +-- +-- 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 Vinod Kurup (vinod@kurup.org) +-- +-- @creation-date 2004-01-15 +-- +-- @cvs-id $Id: upgrade-5.0.0a1-5.0.0a2.sql,v 1.1.2.1 2004/01/16 23:54:48 vinodk Exp $ +-- + +alter table auth_driver_params drop constraint auth_driver_params_authority_id_key; +alter table auth_driver_params add constraint auth_driver_params_pk primary key (authority_id,impl_id,key);