Index: openacs-4/packages/acs-subsite/www/user/portrait/erase.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/www/user/portrait/Attic/erase.xql,v diff -u -N --- openacs-4/packages/acs-subsite/www/user/portrait/erase.xql 27 Nov 2007 20:18:43 -0000 1.1 +++ /dev/null 1 Jan 1970 00:00:00 -0000 @@ -1,46 +0,0 @@ - - - - - - - - - - - select object_id_two - from acs_rels - where object_id_one = :user_id - and rel_type = 'user_portrait_rel' - - - - - - select object_id - from acs_objects - where object_type in ('cr_item_child_rel','image') - and context_id = :item_id - and object_id not in (select live_revision from cr_items where item_id = :item_id) - - - - - - select object_id - from acs_objects - where object_type = 'content_item' - and context_id = :item_id - - - - - - delete from acs_rels - where object_id_two = :item_id - and object_id_one = :user_id - and rel_type = 'user_portrait_rel' - - - - \ No newline at end of file