delimiter //

create procedure dialer_delete_campaign (
	id varchar
	)
begin
	delete from vicidial_campaigns where campaign_id = id;
	delete from vicidial_campaign_agents where campaign_id = id;
	delete from vicidial_campaign_stats where campaign_id = id;
	delete from vicidial_remote_agents where campaign_id = id;
	delete from vicidial_live_agents where campaign_id = id;
	delete from vicidial_campaign_statuses where campaign_id = id;
	delete from vicidial_campaign_hotkeys where campaign_id = id;
	delete from vicidial_callbacks where campaign_id = id;
	delete from vicidial_lead_recycle where campaign_id = id;
	delete from vicidial_campaign_server_stats where campaign_id = id;
	delete from vicidial_server_trunks where campaign_id = id;
	delete from vicidial_pause_codes where campaign_id = id;
	delete from vicidial_campaigns_list_mix where campaign_id = id;
	delete from vicidial_xfer_presets where campaign_id = id;
	delete from vicidial_xfer_stats where campaign_id = id;
	delete from vicidial_hopper where campaign_id = id;

	SELECT menu_id,did_pattern FROM vicidial_inbound_dids WHERE campaign_id

	delete from vicidial_call_menu where menu_id in (
		select menu_id
		from vicidial_inbound_dids
		where campaign_id = id
	);

	delete from vicidial_inbound_groups where group_id in (
		select did_pattern
		from vicidial_inbound_dids
	);

	delete from vicidial_inbound_dids where campaign_id = id;

end;
//

delimiter ;