Index: openacs-4/packages/acs-content-repository/sql/oracle/content-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/sql/oracle/content-create.sql,v diff -u -r1.15 -r1.16 --- openacs-4/packages/acs-content-repository/sql/oracle/content-create.sql 6 Jul 2002 13:55:56 -0000 1.15 +++ openacs-4/packages/acs-content-repository/sql/oracle/content-create.sql 23 Sep 2002 10:19:36 -0000 1.16 @@ -54,10 +54,31 @@ -- Common mime types (administered from admin pages) -insert into cr_mime_types values ('Plain text', 'text/plain', 'txt'); -insert into cr_mime_types values ('HTML text', 'text/html', 'html'); -insert into cr_mime_types values ('Rich Text Format (RTF)', 'text/richtext', 'rtf'); +insert into cr_mime_types(label, mime_type, file_extension) values ('Plain text', 'text/plain', 'txt'); +insert into cr_mime_types(label, mime_type, file_extension) values ('HTML text', 'text/html', 'html'); +insert into cr_mime_types(label, mime_type, file_extension) values ('Rich Text Format (RTF)', 'text/richtext', 'rtf'); +insert into cr_mime_types(label, mime_type, file_extension) values ('Binary', 'application/octet-stream', 'bin'); +insert into cr_mime_types(label, mime_type, file_extension) values ('Microsoft Word', 'application/msword', 'doc'); +insert into cr_mime_types(label, mime_type, file_extension) values ('Microsoft Excel', 'application/msexcel', 'xls'); +insert into cr_mime_types(label, mime_type, file_extension) values ('Microsoft PowerPoint', 'application/powerpoint', 'ppt'); +insert into cr_mime_types(label, mime_type, file_extension) values ('Microsoft Project', 'application/msproject', 'mpp'); +insert into cr_mime_types(label, mime_type, file_extension) values ('PostScript', 'application/postscript', 'ps'); +insert into cr_mime_types(label, mime_type, file_extension) values ('Adobe Illustrator', 'application/x-illustrator', 'ai'); +insert into cr_mime_types(label, mime_type, file_extension) values ('Adobe PageMaker', 'application/x-pagemaker', 'p65'); +insert into cr_mime_types(label, mime_type, file_extension) values ('Filemaker Pro', 'application/filemaker', 'fm'); +insert into cr_mime_types(label, mime_type, file_extension) values ('Image Pict', 'image/x-pict', 'pic'); +insert into cr_mime_types(label, mime_type, file_extension) values ('Photoshop', 'application/x-photoshop', 'psd'); +insert into cr_mime_types(label, mime_type, file_extension) values ('Acrobat', 'application/pdf', 'pdf'); +insert into cr_mime_types(label, mime_type, file_extension) values ('Video Quicktime', 'video/quicktime', 'mov'); +insert into cr_mime_types(label, mime_type, file_extension) values ('Video MPEG', 'video/mpeg', 'mpg'); +insert into cr_mime_types(label, mime_type, file_extension) values ('Audio AIFF', 'audio/aiff', 'aif'); +insert into cr_mime_types(label, mime_type, file_extension) values ('Audio Basic', 'audio/basic', 'au'); +insert into cr_mime_types(label, mime_type, file_extension) values ('Audio Voice', 'audio/voice', 'voc'); +insert into cr_mime_types(label, mime_type, file_extension) values ('Audio Wave', 'audio/wave', 'wav'); +insert into cr_mime_types(label, mime_type, file_extension) values ('Archive Zip', 'application/zip', 'zip'); +insert into cr_mime_types(label, mime_type, file_extension) values ('Archive Tar', 'application/z-tar', 'tar'); + create table cr_content_mime_type_map ( content_type varchar2(100) constraint cr_content_mime_map_ctyp_fk Index: openacs-4/packages/acs-content-repository/sql/postgresql/content-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/sql/postgresql/content-create.sql,v diff -u -r1.35 -r1.36 --- openacs-4/packages/acs-content-repository/sql/postgresql/content-create.sql 16 Jan 2002 20:07:23 -0000 1.35 +++ openacs-4/packages/acs-content-repository/sql/postgresql/content-create.sql 23 Sep 2002 10:19:33 -0000 1.36 @@ -62,10 +62,31 @@ -- Common mime types (administered from admin pages) -insert into cr_mime_types values ('Plain text', 'text/plain', 'txt'); -insert into cr_mime_types values ('HTML text', 'text/html', 'html'); -insert into cr_mime_types values ('Rich Text Format (RTF)', 'text/richtext', 'rtf'); +insert into cr_mime_types(label, mime_type, file_extension) values ('Plain text', 'text/plain', 'txt'); +insert into cr_mime_types(label, mime_type, file_extension) values ('HTML text', 'text/html', 'html'); +insert into cr_mime_types(label, mime_type, file_extension) values ('Rich Text Format (RTF)', 'text/richtext', 'rtf'); +insert into cr_mime_types(label, mime_type, file_extension) values ('Binary', 'application/octet-stream', 'bin'); +insert into cr_mime_types(label, mime_type, file_extension) values ('Microsoft Word', 'application/msword', 'doc'); +insert into cr_mime_types(label, mime_type, file_extension) values ('Microsoft Excel', 'application/msexcel', 'xls'); +insert into cr_mime_types(label, mime_type, file_extension) values ('Microsoft PowerPoint', 'application/powerpoint', 'ppt'); +insert into cr_mime_types(label, mime_type, file_extension) values ('Microsoft Project', 'application/msproject', 'mpp'); +insert into cr_mime_types(label, mime_type, file_extension) values ('PostScript', 'application/postscript', 'ps'); +insert into cr_mime_types(label, mime_type, file_extension) values ('Adobe Illustrator', 'application/x-illustrator', 'ai'); +insert into cr_mime_types(label, mime_type, file_extension) values ('Adobe PageMaker', 'application/x-pagemaker', 'p65'); +insert into cr_mime_types(label, mime_type, file_extension) values ('Filemaker Pro', 'application/filemaker', 'fm'); +insert into cr_mime_types(label, mime_type, file_extension) values ('Image Pict', 'image/x-pict', 'pic'); +insert into cr_mime_types(label, mime_type, file_extension) values ('Photoshop', 'application/x-photoshop', 'psd'); +insert into cr_mime_types(label, mime_type, file_extension) values ('Acrobat', 'application/pdf', 'pdf'); +insert into cr_mime_types(label, mime_type, file_extension) values ('Video Quicktime', 'video/quicktime', 'mov'); +insert into cr_mime_types(label, mime_type, file_extension) values ('Video MPEG', 'video/mpeg', 'mpg'); +insert into cr_mime_types(label, mime_type, file_extension) values ('Audio AIFF', 'audio/aiff', 'aif'); +insert into cr_mime_types(label, mime_type, file_extension) values ('Audio Basic', 'audio/basic', 'au'); +insert into cr_mime_types(label, mime_type, file_extension) values ('Audio Voice', 'audio/voice', 'voc'); +insert into cr_mime_types(label, mime_type, file_extension) values ('Audio Wave', 'audio/wave', 'wav'); +insert into cr_mime_types(label, mime_type, file_extension) values ('Archive Zip', 'application/zip', 'zip'); +insert into cr_mime_types(label, mime_type, file_extension) values ('Archive Tar', 'application/z-tar', 'tar'); + create table cr_content_mime_type_map ( content_type varchar(100) constraint cr_content_mime_map_ctyp_fk