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);