--
-- wp_slide__delete_preamble/1
--
create or replace function wp_slide__delete_preamble(
  integer
) returns int4 as $$

declare
    delete_preamble__preamble_item_id         alias for $1;
begin 
    delete from cr_wp_slides_preamble
    where exists (select 1 from cr_revisions 
                    where revision_id = cr_wp_slides_preamble.id
                    and item_id = delete_preamble__preamble_item_id);    
    
    delete from cr_item_publish_audit
    where item_id = delete_preamble__preamble_item_id;

    perform content_item__delete(delete_preamble__preamble_item_id);

    return 0;
end;$$ language plpgsql;