Index: openacs-4/packages/acs-service-contract/sql/oracle/acs-sc-packages-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-service-contract/sql/oracle/acs-sc-packages-create.sql,v
diff -u -r1.3 -r1.4
--- openacs-4/packages/acs-service-contract/sql/oracle/acs-sc-packages-create.sql	9 Oct 2001 05:14:50 -0000	1.3
+++ openacs-4/packages/acs-service-contract/sql/oracle/acs-sc-packages-create.sql	9 Oct 2001 05:41:20 -0000	1.4
@@ -83,9 +83,9 @@
        impl_contract_name	acs_sc_contracts.contract_name%TYPE,
        impl_name		acs_sc_impls.impl_name%TYPE,
        impl_operation_name	acs_sc_operations.operation_name%TYPE,
-       impl_alias		acs_sc_impl_alias.impl_alias%TYPE,
-       impl_pl			acs_sc_impl_alias.impl_pl%TYPE
-   ) return acs_sc_impl_alias.impl_id%TYPE;
+       impl_alias		acs_sc_impl_aliases.impl_alias%TYPE,
+       impl_pl			acs_sc_impl_aliases.impl_pl%TYPE
+   ) return acs_sc_impl_aliases.impl_id%TYPE;
 
    -- fix by Ben from delete_aliases to delete_alias
    function delete_alias (
@@ -393,16 +393,16 @@
        impl_contract_name	acs_sc_contracts.contract_name%TYPE,
        impl_name		acs_sc_impls.impl_name%TYPE,
        impl_operation_name	acs_sc_operations.operation_name%TYPE,
-       impl_alias		acs_sc_impl_alias.impl_alias%TYPE,
-       impl_pl			acs_sc_impl_alias.impl_pl%TYPE
-   ) return acs_sc_impl_alias.impl_id%TYPE
+       impl_alias		acs_sc_impl_aliases.impl_alias%TYPE,
+       impl_pl			acs_sc_impl_aliases.impl_pl%TYPE
+   ) return acs_sc_impl_aliases.impl_id%TYPE
    is
        v_impl_id		acs_sc_impls.impl_id%TYPE;
    begin
 
        v_impl_id := acs_sc_impl.get_id(impl_contract_name,impl_name);
 
-       insert into acs_sc_impl_alias (
+       insert into acs_sc_impl_aliases (
         impl_id,
 	impl_name,
 	impl_contract_name,
@@ -432,7 +432,7 @@
    begin
        v_impl_id := acs_sc_impl.get_id(impl_contract_name,impl_name);
 
-       delete from acs_sc_impl_alias 
+       delete from acs_sc_impl_aliases 
        where impl_contract_name = delete_alias.impl_contract_name 
        and impl_name = delete_alias.impl_name
        and impl_operation_name = delete_alias.impl_operation_name;
@@ -488,7 +488,7 @@
          from acs_sc_operations
 	 where contract_id = new.contract_id
 	   and operation_name not in (select impl_operation_name
-				      from acs_sc_impl_alias
+				      from acs_sc_impl_aliases
 				      where impl_contract_name = v_contract_name
 				      and impl_id = v_impl_id);
 
Index: openacs-4/packages/acs-service-contract/sql/oracle/acs-sc-tables-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-service-contract/sql/oracle/acs-sc-tables-create.sql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/acs-service-contract/sql/oracle/acs-sc-tables-create.sql	19 Sep 2001 22:59:01 -0000	1.1
+++ openacs-4/packages/acs-service-contract/sql/oracle/acs-sc-tables-create.sql	9 Oct 2001 05:37:38 -0000	1.2
@@ -59,17 +59,17 @@
     impl_contract_name	      varchar2(1000)
 );
 
-create table acs_sc_impl_alias (
+create table acs_sc_impl_aliases (
     impl_id		      integer
-			      constraint acs_sc_impl_proc_impl_id_fk
+			      constraint acs_sc_impl_aliases_impl_id_fk
 			      references acs_sc_impls(impl_id)
 			      on delete cascade,
     impl_name		      varchar2(100),
     impl_contract_name	      varchar2(1000),
     impl_operation_name	      varchar2(100),
     impl_alias		      varchar2(100),
     impl_pl		      varchar2(100),
-constraint acs_sc_impl_alias_un unique(impl_name,impl_contract_name,impl_operation_name)
+constraint acs_sc_impl_aliases_un unique(impl_name,impl_contract_name,impl_operation_name)
 );
 
 create table acs_sc_bindings (