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.12 -r1.13
--- openacs-4/packages/acs-kernel/sql/oracle/authentication-create.sql	1 Jul 2004 11:29:54 -0000	1.12
+++ openacs-4/packages/acs-kernel/sql/oracle/authentication-create.sql	26 Sep 2006 14:48:02 -0000	1.13
@@ -12,13 +12,13 @@
 
 create table auth_authorities (
     authority_id             integer
-                             constraint auth_authorities_pk
+                             constraint auth_authorities_auth_id_pk
                              primary key
                              constraint auth_authorities_aid_fk
                              references acs_objects(object_id)
                              on delete cascade,
     short_name               varchar2(255)
-                             constraint auth_authority_short_name_un
+                             constraint auth_authorities_short_name_un
                              unique,
     pretty_name              varchar2(4000),
     help_contact_text        varchar2(4000),
@@ -105,10 +105,10 @@
                       constraint auth_driver_params_aid_nn
                       not null,
       impl_id         integer
-                      constraint auth_driver_params_iid_fk
+                      constraint auth_driver_params_impl_id_fk
                       -- Cannot reference acs_sc_impls table as it doesn't exist yet
                       references acs_objects(object_id)
-                      constraint auth_driver_params_iid_nn
+                      constraint auth_driver_params_impl_id_nn
                       not null,
       key             varchar2(200),
       value           clob,