CREATE DEFINER=`aerion`@`192.180.1.5` TRIGGER `prosp_consult_after_delete` AFTER DELETE ON `prosp_consult` FOR EACH ROW BEGIN





DELETE FROm  prosp_consult_merger where `prosp_consult_id`  =  OLD.`prosp_consult_id`;
insert into prosp_consult_merger select * from vw_consult_dyn3 where `prosp_consult_id`=  OLD.`prosp_consult_id`;


END