Index: openacs-4/packages/acs-content-repository/sql/common/upgrade/upgrade-5.9.0b2-5.9.0b3.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/sql/common/upgrade/upgrade-5.9.0b2-5.9.0b3.sql,v diff -u -r1.1.2.1 -r1.1.2.2 --- openacs-4/packages/acs-content-repository/sql/common/upgrade/upgrade-5.9.0b2-5.9.0b3.sql 23 Oct 2015 11:21:49 -0000 1.1.2.1 +++ openacs-4/packages/acs-content-repository/sql/common/upgrade/upgrade-5.9.0b2-5.9.0b3.sql 23 Oct 2015 11:44:00 -0000 1.1.2.2 @@ -1,7 +1,10 @@ +insert into cr_mime_types (label,mime_type,file_extension) + select 'Image SVG', 'image/svg+xml', 'svg' from dual + where not exists (select 1 from cr_mime_types where mime_type = 'image/svg+xml'); + +update cr_revisions set mime_type = 'image/svg+xml' where mime_type = 'imate/xml+svg'; +delete from cr_mime_types where mime_type = 'image/xml+svg'; -delete from cr_mime_types where file_extension = 'svg'; -insert into cr_mime_types (label,mime_type,file_extension) values ('Image SVG', 'image/svg+xml', 'svg'); - delete from cr_extension_mime_type_map where extension = 'svg'; insert into cr_extension_mime_type_map (extension, mime_type) select 'svg', 'image/svg+xml' from dual