select item_type_id, type from cal_item_types where calendar_id= :calendar_id insert into cal_item_types (item_type_id, calendar_id, type) values (:item_type_id, :calendar_id, :type) update cal_items set item_type_id= NULL where item_type_id = :item_type_id and on_which_calendar= :calendar_id delete from cal_item_types where item_type_id= :item_type_id and calendar_id= :calendar_id