select type, item_type_id 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 update calendars set calendar_name = :name where calendar_id = :calendar_id