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.3 -r1.1.2.4 --- openacs-4/packages/acs-content-repository/sql/common/upgrade/upgrade-5.9.0b2-5.9.0b3.sql 27 Oct 2015 10:42:32 -0000 1.1.2.3 +++ openacs-4/packages/acs-content-repository/sql/common/upgrade/upgrade-5.9.0b2-5.9.0b3.sql 27 Oct 2015 11:37:52 -0000 1.1.2.4 @@ -2,12 +2,12 @@ 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'; +update cr_revisions set mime_type = 'image/svg+xml' where mime_type = 'image/xml+svg'; update cr_content_mime_type_map set mime_type = 'image/svg+xml' where mime_type = 'image/xml+svg'; +delete from cr_extension_mime_type_map where extension = 'svg'; delete from cr_mime_types where mime_type = 'image/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 where not exists (select 1 from cr_extension_mime_type_map where mime_type = 'image/svg+xml');