[Resolvido] Criar uma trigger

Pessoal estou tentando criar uma trigger:

DELIMITER |

	CREATE TRIGGER leads_cstm_update_rel AFTER UPDATE ON res_reseller_leads
	FOR EACH ROW BEGIN
 IF NEW.deleted = '1' THEN
 update leads_cstm set login_reseller_c = '' where id_c = 'NEW.id'
 END IF;
	END;
|DELIMITER;

só que da erro:

Error

SQL query:

CREATE TRIGGER leads_cstm_update_rel AFTER UPDATE ON res_reseller_leads FOR EACH ROW BEGIN IF NEW.deleted = '1' THEN UPDATE leads_cstm SET login_reseller_c = '' WHERE id_c = 'NEW.id' END IF ;

 

END ;

 

| DELIMITER;

MySQL said: Documentation

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'END IF;

 END;

|DELIMITER' at line 5

se alguem ai souber uma solução!?.