insert into events_organizer_roles (role_id, role, responsibilities, public_role_p) values (:role_id, :role, :responsibilities, :public_role_p) insert into events_org_role_event_map (role_id, event_id) values (:role_id, :event_id) insert into events_org_role_activity_map (role_id, activity_id) values (:role_id, :activity_id) delete from events_org_role_event_map where role_id = :role_id and event_id = :event_id delete from events_organizers_map where role_id = :role_id and event_id = :event_id delete from events_org_role_activity_map where role_id = :role_id and activity_id = :activity_id update events_organizer_roles set role = :role, responsibilities = :responsibilities, public_role_p = :public_role_p where role_id = :role_id delete from events_organizer_roles where role_id = :role_id insert into events_organizers_map (role_id, event_id, user_id) values (:role_id, :event_id, :party_id) update events_organizers_map set user_id = :party_id where role_id = :role_id and event_id = :event_id delete from events_organizers_map where role_id = :role_id and event_id = :event_id select distinct u.first_names || ' ' || u.last_name as name, u.user_id from cc_users u order by name select * from events_organizers_map where role_id = :role_id and event_id = :event_id