select grantee_id,
privilege
from acs_permissions
where object_id = :on_which_calendar
select recurrence_id from acs_events where event_id= :cal_item_id
update acs_activities
set name = :name,
description = :description
where activity_id
in (
select activity_id
from acs_events
where event_id = :cal_item_id
)
update acs_events
set name = :name,
description = :description
where event_id= :cal_item_id
select interval_id
from timespans
where timespan_id
in (
select timespan_id
from acs_events
where event_id = :cal_item_id
)
select recurrence_id from acs_events where event_id= :event_id
update acs_activities
set name = :name,
description = :description
where activity_id
in (
select activity_id
from acs_events
where recurrence_id = :recurrence_id
)
update acs_events set
name= :name, description= :description
where recurrence_id= :recurrence_id
update cal_items
set [join $colspecs ", "]
where cal_item_id in (select event_id from acs_events where recurrence_id = :recurrence_id)