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 -r1.55 -r1.56 --- openacs-4/packages/acs-content-repository/acs-content-repository.info 26 Mar 2005 12:30:49 -0000 1.55 +++ openacs-4/packages/acs-content-repository/acs-content-repository.info 12 May 2005 21:35:00 -0000 1.56 @@ -7,7 +7,7 @@ t t - + OpenACS The canonical repository for OpenACS content. @@ -21,7 +21,7 @@ other CMS backing functionality. Utilized by Bug Tracker, File Storage, and other packages. - + 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 -r1.3 -r1.4 --- openacs-4/packages/acs-content-repository/sql/common/mime-type-data.sql 20 Apr 2004 21:12:34 -0000 1.3 +++ openacs-4/packages/acs-content-repository/sql/common/mime-type-data.sql 12 May 2005 21:35:00 -0000 1.4 @@ -169,8 +169,11 @@ insert into cr_mime_types (label,mime_type,file_extension) values ('OpenOffice Writer', 'application/vnd.sun.xml.writer', 'sxw'); insert into cr_mime_types (label,mime_type,file_extension) values ('OpenOffice Writer Global', 'application/vnd.sun.xml.writer.global', 'sxg'); insert into cr_mime_types (label,mime_type,file_extension) values ('OpenOffice Writer Template', 'application/vnd.sun.xml.writer.template', 'stw'); +insert into cr_mime_types (label,mime_type,file_extension) values ('Audio - WAV','audio/wav', 'wav'); +insert into cr_mime_types (label,mime_type,file_extension) values ('Audio - MPEG','audio/mpeg', 'mpeg'); +insert into cr_mime_types (label,mime_type,file_extension) values ('Audio - MP3','audio/mp3', 'mp3'); +insert into cr_mime_types (label,mime_type,file_extension) values ('Image - Progressive JPEG','image/pjpeg', 'pjpeg'); - -- Extension to mime type maps. -- text/plain for prog langs (maybe we should do application/x-LANG but then you can't look @@ -441,7 +444,6 @@ insert into cr_extension_mime_type_map (extension, mime_type) values ('sxg', 'application/vnd.sun.xml.writer.global'); insert into cr_extension_mime_type_map (extension, mime_type) values ('stw', 'application/vnd.sun.xml.writer.template'); - -- Here are some less common mime types and extensions not defined here. -- -- tsp | application/dsptype Index: openacs-4/packages/acs-content-repository/sql/oracle/upgrade/upgrade-5.2.0d15-5.2.0d16.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/sql/oracle/upgrade/upgrade-5.2.0d15-5.2.0d16.sql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/packages/acs-content-repository/sql/oracle/upgrade/upgrade-5.2.0d15-5.2.0d16.sql 12 May 2005 21:35:00 -0000 1.1 @@ -0,0 +1,5 @@ +-- Add a few common mime types +insert into cr_mime_types (label,mime_type,file_extension) select 'Audio - WAV','audio/wav', 'wav' from dual where not exists (select 1 from cr_mime_types where mime_type = 'audio/wav'); +insert into cr_mime_types (label,mime_type,file_extension) select 'Audio - MPEG','audio/mpeg', 'mpeg' from dual where not exists (select 1 from cr_mime_types where mime_type = 'audio/mpeg'); +insert into cr_mime_types (label, mime_type, file_extension) select 'Audio - MP3','audio/mp3', 'mp3' from dual where not exists (select 1 from cr_mime_types where mime_type = 'audio/mp3'); +insert into cr_mime_types (label,mime_type,file_extension) select 'Image - Progressive JPEG','image/pjpeg', 'pjpeg' from dual where not exists (select 1 from cr_mime_types where mime_type = 'image/pjpeg'); Index: openacs-4/packages/acs-content-repository/sql/postgresql/upgrade/upgrade-5.2.0d15-5.2.0d16.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/sql/postgresql/upgrade/upgrade-5.2.0d15-5.2.0d16.sql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/packages/acs-content-repository/sql/postgresql/upgrade/upgrade-5.2.0d15-5.2.0d16.sql 12 May 2005 21:35:00 -0000 1.1 @@ -0,0 +1,5 @@ +-- Add a few common mime types +insert into cr_mime_types (label,mime_type,file_extension) select 'Audio - WAV','audio/wav', 'wav' from dual where not exists (select 1 from cr_mime_types where mime_type = 'audio/wav'); +insert into cr_mime_types (label,mime_type,file_extension) select 'Audio - MPEG','audio/mpeg', 'mpeg' from dual where not exists (select 1 from cr_mime_types where mime_type = 'audio/mpeg'); +insert into cr_mime_types (label, mime_type, file_extension) select 'Audio - MP3','audio/mp3', 'mp3' from dual where not exists (select 1 from cr_mime_types where mime_type = 'audio/mp3'); +insert into cr_mime_types (label,mime_type,file_extension) select 'Image - Progressive JPEG','image/pjpeg', 'pjpeg' from dual where not exists (select 1 from cr_mime_types where mime_type = 'image/pjpeg');