triggers.sql

DROP TRIGGER IF EXISTS `t_demissao`;

DELIMITER $$

CREATE TRIGGER t_demissao BEFORE UPDATE 
ON user
FOR EACH ROW
BEGIN
	IF NEW.state = 'I' THEN
		SET NEW.resignation_date = NOW();
        
        UPDATE equipament_has_user ehu
        SET ehu.state = 'I' WHERE ehu.user_id = NEW.id;
    END IF;
END$$
DELIMITER ;