Index: openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-4.7d-4.7.2d.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-4.7d-4.7.2d.sql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-4.7d-4.7.2d.sql	17 Feb 2003 23:56:35 -0000	1.1
+++ openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-4.7d-4.7.2d.sql	18 Feb 2003 08:54:03 -0000	1.2
@@ -1 +1,14 @@
-insert into apm_package_file_types(file_type_key, pretty_name) values('message_catalog', 'Message Catalog');
+declare
+  v_catalog_type_exists_p integer;
+begin
+	select count(*) into v_catalog_type_exists_p
+	from apm_package_file_types where file_type_key = 'message_catalog';
+
+
+	if v_catalog_type_exists_p = 0 then
+          insert into apm_package_file_types(file_type_key, pretty_name) 
+          values('message_catalog', 'Message Catalog');
+	end if;
+end;
+/
+show errors
