blacklist_sendy

DELIMITER $$
CREATE TRIGGER blacklist UPDATE ON subscribers
FOR EACH ROW BEGIN
IF (NEW.complaint = 1) THEN
INSERT INTO `sendy`.`subscribers` (`userID`, `email`, `list`, `unsubscribed`, `bounced`, `complaint`, `confirmed`) VALUES ('1', OLD.email, '16', '1', '1', '1', '1');
END IF;
END$$
DELIMITER ;