update forums_messages
set last_poster = :to_user_id
where last_poster = :from_user_id
update forums_messages
set user_id = :to_user_id
where user_id = :from_user_id
select message_id, subject
from forums_messages
where user_id = :user_id
select message_id, subject
from forums_messages
where last_poster = :user_id
update forums_forums
set package_id = :new_package_id
where forum_id = :object_id
update forums_forums
set package_id = :trash_package_id
where forum_id = :object_id
update acs_objects
set package_id = :new_package_id,
context_id = :new_package_id
where object_id = :object_id
update acs_objects
set package_id = :trash_package_id,
context_id = :trash_package_id
where object_id = :object_id
SELECT name,charter,presentation_type,posting_policy
FROM forums_forums
WHERE forum_id=:object_id;
SELECT subject,content,user_id,format as formato,parent_id
FROM forums_messages
WHERE forum_id=:object_id and parent_id IS NULL;
SELECT subject,content,user_id,format as formato,parent_id
FROM forums_messages
WHERE forum_id=:object_id and parent_id IS NOT NULL;