postgresql7.1
select acs__add_user(
:user_id,
'user',
now(),
null,
:peeraddr,
:authority_id,
:username,
:email,
:url,
:first_names,
:last_name,
:hashed_password,
:salt,
:screen_name,
:email_verified_p,
:member_state
);
select acs_user__delete(:user_id);
select person__delete(:person_id);
select distinct u.first_names || ' ' || u.last_name || ' (' || u.email || ')' as name, u.user_id
from cc_users u
where upper(coalesce(u.first_names || ' ', '') ||
coalesce(u.last_name || ' ', '') ||
u.email || ' ' ||
coalesce(u.screen_name, '')) like upper('%'||:value||'%')
order by name
select user_id,
username,
authority_id,
first_names,
last_name,
first_names || ' ' || last_name as name,
email,
url,
screen_name,
priv_name,
priv_email,
email_verified_p,
email_bouncing_p,
no_alerts_until,
last_visit,
second_to_last_visit,
n_sessions,
password_question,
password_answer,
password_changed_date,
member_state,
rel_id,
trunc(date_part('epoch', age(password_changed_date))/(60*60*24)) as password_age_days
from cc_users
where user_id = :user_id
select user_id,
username,
authority_id,
first_names,
last_name,
first_names || ' ' || last_name as name,
email,
url,
screen_name,
priv_name,
priv_email,
email_verified_p,
email_bouncing_p,
no_alerts_until,
last_visit,
second_to_last_visit,
n_sessions,
password_question,
password_answer,
password_changed_date,
member_state,
rel_id,
trunc(date_part('epoch', age(password_changed_date))/(60*60*24)) as password_age_days
from cc_users
where authority_id = :authority_id
and username = :username