Index: openacs-4/packages/acs-service-contract/acs-service-contract.info
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-service-contract/acs-service-contract.info,v
diff -u -r1.3 -r1.4
--- openacs-4/packages/acs-service-contract/acs-service-contract.info 21 Oct 2001 18:16:34 -0000 1.3
+++ openacs-4/packages/acs-service-contract/acs-service-contract.info 31 Jan 2002 03:04:32 -0000 1.4
@@ -19,7 +19,6 @@
-
@@ -52,12 +51,21 @@
+
+
+
+
+
+
+
+
+
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.4 -r1.5
--- openacs-4/packages/acs-service-contract/sql/oracle/acs-sc-packages-create.sql 9 Oct 2001 05:41:20 -0000 1.4
+++ openacs-4/packages/acs-service-contract/sql/oracle/acs-sc-packages-create.sql 31 Jan 2002 03:04:32 -0000 1.5
@@ -14,7 +14,7 @@
function get_name (
contract_id in acs_sc_contracts.contract_id%TYPE
- ) return acs_sc_contracts.contract_id%TYPE;
+ ) return acs_sc_contracts.contract_name%TYPE;
procedure delete (
contract_name in acs_sc_contracts.contract_name%TYPE default null,
@@ -165,7 +165,7 @@
function get_name (
contract_id in acs_sc_contracts.contract_id%TYPE
- ) return acs_sc_contracts.contract_id%TYPE
+ ) return acs_sc_contracts.contract_name%TYPE
is
v_contract_name acs_sc_contracts.contract_name%TYPE;
begin
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.2 -r1.3
--- openacs-4/packages/acs-service-contract/sql/oracle/acs-sc-tables-create.sql 9 Oct 2001 05:37:38 -0000 1.2
+++ openacs-4/packages/acs-service-contract/sql/oracle/acs-sc-tables-create.sql 31 Jan 2002 03:04:32 -0000 1.3
@@ -82,14 +82,3 @@
references acs_sc_impls(impl_id)
on delete cascade
);
-
-
-
-
-
-
-
-
-
-
-
Index: openacs-4/packages/acs-service-contract/www/binding-install-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-service-contract/www/binding-install-oracle.xql,v
diff -u
--- /dev/null 1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/acs-service-contract/www/binding-install-oracle.xql 31 Jan 2002 03:04:32 -0000 1.1
@@ -0,0 +1,15 @@
+
+
+
+ oracle8.1.6
+
+
+
+ begin
+ select acs_sc_binding.new(:contract_id,:impl_id)
+ end;
+
+
+
+
+
Index: openacs-4/packages/acs-service-contract/www/binding-install-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-service-contract/www/binding-install-postgresql.xql,v
diff -u
--- /dev/null 1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/acs-service-contract/www/binding-install-postgresql.xql 31 Jan 2002 03:04:32 -0000 1.1
@@ -0,0 +1,13 @@
+
+
+
+ postgresql7.1
+
+
+
+ select acs_sc_binding__new(:contract_id,:impl_id)
+
+
+
+
+
Index: openacs-4/packages/acs-service-contract/www/binding-uninstall-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-service-contract/www/Attic/binding-uninstall-oracle.xql,v
diff -u
--- /dev/null 1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/acs-service-contract/www/binding-uninstall-oracle.xql 31 Jan 2002 03:04:32 -0000 1.1
@@ -0,0 +1,15 @@
+
+
+
+ oracle8.1.6
+
+
+
+ begin
+ select acs_sc_binding.delete(:contract_id,:impl_id)
+ end;
+
+
+
+
+
Index: openacs-4/packages/acs-service-contract/www/binding-uninstall-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-service-contract/www/Attic/binding-uninstall-postgresql.xql,v
diff -u
--- /dev/null 1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/acs-service-contract/www/binding-uninstall-postgresql.xql 31 Jan 2002 03:04:32 -0000 1.1
@@ -0,0 +1,13 @@
+
+
+
+ postgresql7.1
+
+
+
+ select acs_sc_binding__delete(:contract_id,:impl_id)
+
+
+
+
+
Index: openacs-4/packages/acs-service-contract/www/index-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-service-contract/www/Attic/index-oracle.xql,v
diff -u
--- /dev/null 1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/acs-service-contract/www/index-oracle.xql 31 Jan 2002 03:04:32 -0000 1.1
@@ -0,0 +1,19 @@
+
+
+
+ oracle8.1.6
+
+
+
+ select
+ contract_id,
+ impl_id,
+ acs_sc_contract.get_name(contract_id) as contract_name,
+ acs_sc_impl.get_name(impl_id) as impl_name
+ from
+ acs_sc_bindings
+
+
+
+
+
Index: openacs-4/packages/acs-service-contract/www/index-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-service-contract/www/Attic/index-postgresql.xql,v
diff -u
--- /dev/null 1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/acs-service-contract/www/index-postgresql.xql 31 Jan 2002 03:04:32 -0000 1.1
@@ -0,0 +1,19 @@
+
+
+
+ postgresql7.1
+
+
+
+ select
+ contract_id,
+ impl_id,
+ acs_sc_contract__get_name(contract_id) as contract_name,
+ acs_sc_impl__get_name(impl_id) as impl_name
+ from
+ acs_sc_bindings
+
+
+
+
+
Index: openacs-4/packages/acs-service-contract/www/index.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-service-contract/www/index.xql,v
diff -u
--- /dev/null 1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/acs-service-contract/www/index.xql 31 Jan 2002 03:04:32 -0000 1.1
@@ -0,0 +1,27 @@
+
+
+
+
+
+
+ select contract_id, contract_name, impl_name,impl_id
+ from valid_uninstalled_bindings;
+
+
+
+
+
+ select contract_id, contract_name, impl_name,impl_id
+ from invalid_uninstalled_bindings;
+
+
+
+
+
+ select impl_id, impl_name, impl_contract_name
+ from orphan_implementations
+
+
+
+
+