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.49.2.5 -r1.49.2.6
--- openacs-4/packages/acs-service-contract/acs-service-contract.info	24 Jul 2023 14:07:05 -0000	1.49.2.5
+++ openacs-4/packages/acs-service-contract/acs-service-contract.info	2 Dec 2023 11:10:16 -0000	1.49.2.6
@@ -7,7 +7,7 @@
     <initial-install-p>t</initial-install-p>
     <singleton-p>t</singleton-p>
     
-    <version name="5.10.1b1" url="http://openacs.org/repository/download/apm/acs-service-contract-5.10.1b1.apm">
+    <version name="5.10.1b2" url="http://openacs.org/repository/download/apm/acs-service-contract-5.10.1b2.apm">
         <owner url="http://openacs.org">OpenACS</owner>
         <summary>API and UI for service contracts</summary>
         <release-date>2021-09-16</release-date>
@@ -17,7 +17,7 @@
         Examples are the contracts used for search which provide a means to get content on a given object and to translate an object_id to a URL or the contracts used by dotlrn and new-portals to allow packages to provide portalized panes.</description>
         <license>GPL version 2</license>
 
-        <provides url="acs-service-contract" version="5.10.1b1"/>
+        <provides url="acs-service-contract" version="5.10.1b2"/>
         <requires url="acs-kernel" version="5.10.1b1"/>
 
         <callbacks>
Index: openacs-4/packages/acs-service-contract/sql/oracle/acs-sc-msg-types-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-service-contract/sql/oracle/acs-sc-msg-types-create.sql,v
diff -u -r1.7 -r1.7.22.1
--- openacs-4/packages/acs-service-contract/sql/oracle/acs-sc-msg-types-create.sql	12 Mar 2004 18:48:53 -0000	1.7
+++ openacs-4/packages/acs-service-contract/sql/oracle/acs-sc-msg-types-create.sql	2 Dec 2023 11:10:16 -0000	1.7.22.1
@@ -29,19 +29,23 @@
 
 
 create table acs_sc_msg_type_elements (
-    msg_type_id		     integer
+    msg_type_id		     integer NOT NULL
 			     constraint acs_sc_msg_type_el_mtype_id_fk
 			     references acs_sc_msg_types(msg_type_id)
 			     on delete cascade,
-    element_name	     varchar2(100),
-    element_msg_type_id	     integer
+    element_name	     varchar2(100) NOT NULL,
+    element_msg_type_id	     integer NOT NULL
 			     constraint acs_sc_msg_type_el_emti_id_fk
 			     references acs_sc_msg_types(msg_type_id),
     element_msg_type_isset_p char(1) constraint acs_msg_type_el_set_p_ck
 			     check (element_msg_type_isset_p in ('t', 'f')),
     element_pos		     integer
 );
 
+ALTER TABLE acs_sc_msg_type_elements ADD CONSTRAINT acs_sc_msg_type_el_un
+      UNIQUE (msg_type_id, element_name, element_msg_type_id);
+
+
 create or replace package acs_sc_msg_type
 as
 
Fisheye: Tag 1.1 refers to a dead (removed) revision in file `openacs-4/packages/acs-service-contract/sql/oracle/upgrade/upgrade-5.10.1b1-5.10.1b2.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Index: openacs-4/packages/acs-service-contract/sql/postgresql/acs-sc-msg-types-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-service-contract/sql/postgresql/acs-sc-msg-types-create.sql,v
diff -u -r1.9 -r1.9.6.1
--- openacs-4/packages/acs-service-contract/sql/postgresql/acs-sc-msg-types-create.sql	30 Mar 2013 17:40:53 -0000	1.9
+++ openacs-4/packages/acs-service-contract/sql/postgresql/acs-sc-msg-types-create.sql	2 Dec 2023 11:10:16 -0000	1.9.6.1
@@ -27,26 +27,26 @@
 
 
 create table acs_sc_msg_type_elements (
-    msg_type_id		     integer
+    msg_type_id		     integer NOT NULL
 			     constraint acs_sc_msg_type_el_mtype_id_fk
 			     references acs_sc_msg_types(msg_type_id)
 			     on delete cascade,
-    element_name	     varchar(100),
-    element_msg_type_id	     integer
+    element_name	     varchar(100) NOT NULL,
+    element_msg_type_id	     integer NOT NULL
 			     constraint acs_sc_msg_type_el_emti_id_fk
 			     references acs_sc_msg_types(msg_type_id),
     element_msg_type_isset_p boolean,
     element_pos		     integer
 );
 
--- register function record
-select define_function_args('acs_sc_msg_type__new','msg_type_name,msg_type_spec');
--- declare function
+ALTER TABLE acs_sc_msg_type_elements ADD CONSTRAINT acs_sc_msg_type_el_un
+      UNIQUE (msg_type_id, element_name, element_msg_type_id);
 
-
 --
 -- procedure acs_sc_msg_type__new/2
 --
+select define_function_args('acs_sc_msg_type__new','msg_type_name,msg_type_spec');
+
 CREATE OR REPLACE FUNCTION acs_sc_msg_type__new(
    p_msg_type_name varchar,
    p_msg_type_spec varchar
Fisheye: Tag 1.1 refers to a dead (removed) revision in file `openacs-4/packages/acs-service-contract/sql/postgresql/upgrade/upgrade-5.10.1b1-5.10.1b2.sql'.
Fisheye: No comparison available.  Pass `N' to diff?