Index: openacs-4/packages/acs-content-repository/sql/oracle/content-item.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/sql/oracle/content-item.sql,v diff -u -r1.30 -r1.31 --- openacs-4/packages/acs-content-repository/sql/oracle/content-item.sql 4 Jun 2006 00:45:22 -0000 1.30 +++ openacs-4/packages/acs-content-repository/sql/oracle/content-item.sql 11 Jun 2008 00:10:04 -0000 1.31 @@ -551,57 +551,47 @@ -- workflow_case.delete(v_wf_cases_val.case_id); -- end loop; - dbms_output.put_line('Deleting symlinks...'); -- 2) delete all symlinks to this item for v_symlink_val in c_symlink_cur loop content_symlink.del(v_symlink_val.symlink_id); end loop; - dbms_output.put_line('Unscheduling item...'); delete from cr_release_periods where item_id = content_item.del.item_id; - dbms_output.put_line('Deleting associated revisions...'); -- 3) delete all revisions of this item delete from cr_item_publish_audit where item_id = content_item.del.item_id; for v_revision_val in c_revision_cur loop content_revision.del(v_revision_val.revision_id); end loop; - dbms_output.put_line('Deleting associated item templates...'); -- 4) unregister all templates to this item delete from cr_item_template_map where item_id = content_item.del.item_id; - dbms_output.put_line('Deleting item relationships...'); -- Delete all relations on this item for v_rel_val in c_rel_cur loop acs_rel.del(v_rel_val.rel_id); end loop; - dbms_output.put_line('Deleting child relationships...'); for v_rel_val in c_child_cur loop acs_rel.del(v_rel_val.rel_id); end loop; - dbms_output.put_line('Deleting parent relationships...'); for v_rel_val in c_parent_cur loop acs_rel.del(v_rel_val.rel_id); content_item.del(v_rel_val.child_id); end loop; - dbms_output.put_line('Deleting associated permissions...'); -- 5) delete associated permissions delete from acs_permissions where object_id = content_item.del.item_id; - dbms_output.put_line('Deleting keyword associations...'); -- 6) delete keyword associations delete from cr_item_keyword_map where item_id = content_item.del.item_id; - dbms_output.put_line('Deleting associated comments...'); -- 7) delete associated comments journal_entry.delete_for_object( content_item.del.item_id ); @@ -611,7 +601,6 @@ -- || v_error_val.object_type); --end loop; - dbms_output.put_line('Deleting content item...'); acs_object.del(content_item.del.item_id); end del;