Index: openacs-4/packages/assessment/www/admin/item-delete.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/www/admin/Attic/item-delete.xql,v diff -u -N --- openacs-4/packages/assessment/www/admin/item-delete.xql 14 Nov 2004 16:42:31 -0000 1.1 +++ /dev/null 1 Jan 1970 00:00:00 -0000 @@ -1,57 +0,0 @@ - - - - - - - select title as item_title - from cr_revisions - where revision_id = :as_item_id - - - - - - - - update as_assessment_section_map - set section_id = :new_section_id - where assessment_id = :new_assessment_rev_id - and section_id = :section_id - - - - - - - - select sort_order - from as_item_section_map - where section_id = :new_section_id - and as_item_id = :as_item_id - - - - - - - - delete from as_item_section_map - where section_id = :new_section_id - and as_item_id = :as_item_id - - - - - - - - update as_item_section_map - set sort_order = sort_order-1 - where section_id = :new_section_id - and sort_order > :sort_order - - - - -