SHARE
TWEET

blacklist_sendy

a guest Sep 16th, 2014 356 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. DELIMITER $$
  2. CREATE TRIGGER blacklist UPDATE ON subscribers
  3. FOR EACH ROW BEGIN
  4. IF (NEW.complaint = 1) THEN
  5. INSERT INTO `sendy`.`subscribers` (`userID`, `email`, `list`, `unsubscribed`, `bounced`, `complaint`, `confirmed`) VALUES ('1', OLD.email, '16', '1', '1', '1', '1');
  6. END IF;
  7. END$$
  8. DELIMITER ;
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!
 
Top