postgresql7.1
select user_id, first_names, last_name, username
from acs_users_all
where user_id = :uid
select * from user_quota
where ref_user = :uid
update user_quota
set usercomm_actv = :value
where quota_id = :quota_id
update user_quota
set global_quota = :new_global_quota,
global_files = :new_global_files,
personal_quota = :new_personal_quota,
personal_files = :new_personal_files
where quota_id = :quota_id
insert into user_quota (ref_user, global_quota, global_files,
personal_quota, personal_files, usercomm_actv)
values (:uid, :new_global_quota, :new_global_files,
:new_personal_quota, :new_personal_files, true)
delete from user_quota
where quota_id = :quota_id and
ref_user = :uid