Index: openacs-4/contrib/packages/events/www/admin/role-add-oracle.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/events/www/admin/Attic/role-add-oracle.xql,v diff -u -N --- openacs-4/contrib/packages/events/www/admin/role-add-oracle.xql 9 Mar 2003 12:08:23 -0000 1.1 +++ /dev/null 1 Jan 1970 00:00:00 -0000 @@ -1,30 +0,0 @@ - - - - - - select role || ' ' || - decode(public_role_p, 't', ' (public role)', '') as public_role_p, - role_id - from events_organizer_roles - where role_id not in - (select role_id - from events_org_role_activity_map - where activity_id = :activity_id) - - - - - - select role || ' ' || - decode(public_role_p, 't', ' (public role)', '') as public_role_p, - role_id - from events_organizer_roles - where role_id not in - (select role_id - from events_org_role_event_map - where event_id = :event_id) - - - -