trigger.sql

--
-- Disparador para borrar shtml
--
DROP TRIGGER IF EXISTS `beforeUpdatePostshtml`;
DELIMITER //
CREATE TRIGGER beforeUpdatePostshtml BEFORE UPDATE ON wp_posts FOR EACH ROW BEGIN
	IF OLD.post_name != NEW.post_name 
		AND OLD.post_name != '' 
		AND NEW.post_type = 'post' 
		AND NEW.post_status = 'publish'
	THEN
		INSERT INTO delete_shtml(post_id, post_shtml) VALUES(NEW.ID, CONCAT('/', DATE_FORMAT(OLD.post_date,'%Y/%m/%d/'),OLD.post_name,'.shtml'));
	END IF;
	
	END
//
DELIMITER ;