Index: openacs-4/packages/acs-content-repository/tcl/revision-procs.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/tcl/revision-procs.xql,v diff -u -r1.6 -r1.7 --- openacs-4/packages/acs-content-repository/tcl/revision-procs.xql 20 Apr 2004 21:12:37 -0000 1.6 +++ openacs-4/packages/acs-content-repository/tcl/revision-procs.xql 4 Jun 2006 00:45:23 -0000 1.7 @@ -4,7 +4,7 @@ select i.storage_type, i.storage_area_key, r.mime_type, i.item_id, - r.content_length + r.content_length from cr_items i, cr_revisions r where r.revision_id = :revision_id and i.item_id = r.item_id @@ -21,17 +21,17 @@ select content_type - from cr_items + from cr_items where item_id = :item_id insert into cr_mime_types (mime_type) - select :mime_type - from dual - where not exists (select 1 from cr_mime_types where mime_type = :mime_type) + select :mime_type + from dual + where not exists (select 1 from cr_mime_types where mime_type = :mime_type) @@ -43,4 +43,22 @@ + + + select 1 + from cr_content_mime_type_map + where mime_type = :mime_type + and content_type = 'content_revision' + + + + + + select 1 + from cr_content_mime_type_map + where mime_type = :mime_type + and content_type = 'image' + + +