Index: openacs-4/packages/acs-content-repository/acs-content-repository.info
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/acs-content-repository.info,v
diff -u -N -r1.117.2.20 -r1.117.2.21
--- openacs-4/packages/acs-content-repository/acs-content-repository.info	25 Feb 2024 10:40:35 -0000	1.117.2.20
+++ openacs-4/packages/acs-content-repository/acs-content-repository.info	12 Mar 2024 09:21:26 -0000	1.117.2.21
@@ -7,7 +7,7 @@
     <initial-install-p>t</initial-install-p>
     <singleton-p>t</singleton-p>
 
-    <version name="5.10.1b3" url="http://openacs.org/repository/download/apm/acs-content-repository-5.10.1b3.apm">
+    <version name="5.10.1b4" url="http://openacs.org/repository/download/apm/acs-content-repository-5.10.1b4.apm">
     <implements-subsite-p>f</implements-subsite-p>
     <inherit-templates-p>t</inherit-templates-p>
         <owner url="http://openacs.org">OpenACS</owner>
@@ -24,7 +24,7 @@
         <license>GPL</license>
         <maturity>3</maturity>
 
-        <provides url="acs-content-repository" version="5.10.1b3"/>
+        <provides url="acs-content-repository" version="5.10.1b4"/>
         <requires url="acs-kernel" version="5.10.1b1"/>
         <requires url="acs-service-contract" version="5.10.1b1"/>
         <requires url="acs-tcl" version="5.10.1b1"/>
Index: openacs-4/packages/acs-content-repository/sql/common/mime-type-data.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/sql/common/mime-type-data.sql,v
diff -u -N -r1.12.2.3 -r1.12.2.4
--- openacs-4/packages/acs-content-repository/sql/common/mime-type-data.sql	3 Nov 2022 13:50:08 -0000	1.12.2.3
+++ openacs-4/packages/acs-content-repository/sql/common/mime-type-data.sql	12 Mar 2024 09:21:26 -0000	1.12.2.4
@@ -355,6 +355,7 @@
 insert into cr_extension_mime_type_map (extension, mime_type) values ( 'midi','audio/midi' );
 insert into cr_extension_mime_type_map (extension, mime_type) values ( 'mif','application/vnd.mif' );
 insert into cr_extension_mime_type_map (extension, mime_type) values ( 'mime','message/rfc822' );
+insert into cr_extension_mime_type_map (extension, mime_type) values ( 'mjs','application/javascript' );
 insert into cr_extension_mime_type_map (extension, mime_type) values ( 'movie','video/x-sgi-movie' );
 insert into cr_extension_mime_type_map (extension, mime_type) values ( 'mov','video/quicktime' );
 insert into cr_extension_mime_type_map (extension, mime_type) values ( 'mp2','audio/x-mpeg2' );
Index: openacs-4/packages/acs-content-repository/sql/oracle/upgrade/upgrade-5.10.1b3-5.10.1b4.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/sql/oracle/upgrade/Attic/upgrade-5.10.1b3-5.10.1b4.sql,v
diff -u -N
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/acs-content-repository/sql/oracle/upgrade/upgrade-5.10.1b3-5.10.1b4.sql	12 Mar 2024 09:21:26 -0000	1.1.2.1
@@ -0,0 +1,32 @@
+--
+-- Add extension to an existing mime type.
+-- The changes have to be performed in a transaction, therefore the inline function.
+--
+
+create or replace function inline_0 (
+    p_extension in varchar,
+    p_mime_type in varchar
+)
+return integer
+as
+begin
+  v_extension_exists integer default 0;
+
+  select 1 into v_extension_exists 
+    from cr_extension_mime_type_map 
+    where extension = p_extension;
+
+  if v_extension_exists = 1 then
+    update cr_extension_mime_type_map set mime_type = p_mime_type where extension = p_extension;
+  else
+    insert into cr_extension_mime_type_map (extension, mime_type)
+      select p_extension, p_mime_type from dual;
+  end if;
+
+  return 1;
+end;
+/
+
+select inline_0('mjs','application/javascript') from dual;
+
+drop function inline_0;
Index: openacs-4/packages/acs-content-repository/sql/postgresql/upgrade/upgrade-5.10.1b3-5.10.1b4.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/sql/postgresql/upgrade/Attic/upgrade-5.10.1b3-5.10.1b4.sql,v
diff -u -N
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/acs-content-repository/sql/postgresql/upgrade/upgrade-5.10.1b3-5.10.1b4.sql	12 Mar 2024 09:21:26 -0000	1.1.2.1
@@ -0,0 +1,26 @@
+--
+-- Add extension to an existing mime type.
+-- The changes have to be performed in a transaction, therefore the inline function.
+--
+create or replace function inline_0 (
+    p_extension varchar,
+    p_mime_type varchar
+)
+returns integer as $$
+begin
+    SET CONSTRAINTS ALL DEFERRED;
+
+    if exists (select 1 from cr_extension_mime_type_map where extension = p_extension) then
+        update cr_extension_mime_type_map set mime_type = p_mime_type where extension = p_extension;
+    else
+        insert into cr_extension_mime_type_map (extension, mime_type)
+            select p_extension, p_mime_type from dual;
+    end if;
+
+    return 0;
+end;
+$$ language 'plpgsql';
+
+select inline_0('mjs','application/javascript');
+
+drop function inline_0(varchar,varchar);