Index: openacs-4/packages/acs-service-contract/sql/postgresql/acs-sc-views-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-service-contract/sql/postgresql/acs-sc-views-create.sql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/acs-service-contract/sql/postgresql/acs-sc-views-create.sql	1 Sep 2001 20:22:57 -0000	1.1
+++ openacs-4/packages/acs-service-contract/sql/postgresql/acs-sc-views-create.sql	6 Oct 2001 16:30:30 -0000	1.2
@@ -1,46 +1,46 @@
-create view valid_uninstalled_binding as
+create view valid_uninstalled_bindings as
     select c.contract_id, c.contract_name, i.impl_id, i.impl_name
-    from acs_sc_contract c, acs_sc_impl i
+    from acs_sc_contracts c, acs_sc_impls i
     where c.contract_name = i.impl_contract_name
     and not exists (select 1
-		    from acs_sc_binding b
+		    from acs_sc_bindings b
 		    where b.contract_id = c.contract_id
 		    and b.impl_id = i.impl_id)
     and not exists (select 1
-		    from acs_sc_operation o
+		    from acs_sc_operations o
 		    where o.contract_id = c.contract_id
 		    and not exists (select 1
-				    from acs_sc_impl_alias a
+				    from acs_sc_impl_aliases a
 				    where a.impl_contract_name = c.contract_name
 				    and a.impl_id = i.impl_id
 				    and a.impl_operation_name = o.operation_name));
 
 
 
-create view invalid_uninstalled_binding as
+create view invalid_uninstalled_bindings as
     select c.contract_id, c.contract_name, i.impl_id, i.impl_name
-    from acs_sc_contract c, acs_sc_impl i
+    from acs_sc_contracts c, acs_sc_impls i
     where c.contract_name = i.impl_contract_name
     and not exists (select 1
-		    from acs_sc_binding b
+		    from acs_sc_bindings b
 		    where b.contract_id = c.contract_id
 		    and b.impl_id = i.impl_id)
     and exists (select 1
-	        from acs_sc_operation o
+	        from acs_sc_operations o
 		where o.contract_id = c.contract_id
 		and not exists (select 1
-			        from acs_sc_impl_alias a
+			        from acs_sc_impl_aliases a
 				where a.impl_contract_name = c.contract_name
 				and a.impl_id = i.impl_id
 				and a.impl_operation_name = o.operation_name));
 
 
-create view orphan_implementation as
+create view orphan_implementations as
     select i.impl_id, i.impl_name, i.impl_contract_name
-    from acs_sc_impl i
+    from acs_sc_impls i
     where not exists (select 1
-		      from acs_sc_binding b
+		      from acs_sc_bindings b
 		      where b.impl_id = i.impl_id)
     and not exists (select 1
-		    from acs_sc_contract c
+		    from acs_sc_contracts c
 		    where c.contract_name = i.impl_contract_name);
\ No newline at end of file
