-- 
-- Upgrade script from 5.0d3 to 5.0d4
--
-- Adds table auth_driver_params
--
-- @author Simon Carstensen (simon@collaboraid.biz)
--
-- @cvs-id $Id: upgrade-5.0d3-5.0d4.sql,v 1.1 2003/08/28 07:55:17 peterm Exp $
--

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
                      references acs_sc_impls(impl_id)
                      constraint auth_driver_params_iid_nn
                      not null,
      key             clob,
      value           clob,
      unique (authority_id, impl_id)
);