Psst.. new poll here.
Psst.. new forums here.
Microsoft is blocking us again (TY IP Reputation!) so just use oauth login instead. :)
Paste
Pasted as SQL by evilbloodydemon ( 15 years ago )
delimiter $$
DROP TRIGGER IF EXISTS articles_dist_cleanup$$
CREATE TRIGGER articles_dist_cleanup AFTER DELETE
ON articles
FOR EACH ROW
BEGIN
UPDATE distributions d SET d.article_id = 0 WHERE d.article_id = OLD.id;
END$$
DROP TRIGGER IF EXISTS sites_dist_cleanup$$
CREATE TRIGGER sites_dist_cleanup AFTER DELETE
ON sites
FOR EACH ROW
BEGIN
UPDATE distributions d SET d.site_id = 0 WHERE d.site_id = OLD.id;
END$$
delimiter ;
Revise this Paste