<?xml version="1.0"?> <queryset> <rdbms><type>oracle</type><version>8.1.6</version></rdbms> <fullquery name="get_jids"> <querytext> select (sn.user_id) as user_id_cur, (sn.im_screen_name) as jabber_screen from jb_screens sn where (sn.user_id = :user_id or sn.user_id = :user_id_friend) and sn.service = 'jabber' </querytext> </fullquery> <fullquery name="get_screen_ids"> <querytext> select screen_id from jb_screens where user_id = :friend_id </querytext> </fullquery> <fullquery name="add_buddy"> <querytext> insert into jb_friends (user_id , friend_screen_id) values (:user_id , :screen_id) </querytext> </fullquery> <fullquery name="update_refcount"> <querytext> UPDATE jb_screens set refcount = (refcount +1) where screen_id = :screen_id </querytext> </fullquery> </queryset>