bugs/install/db_install/01_triggers/session_update.sql

DROP TRIGGER IF EXISTS `session_update`;
CREATE TRIGGER `session_update`
BEFORE UPDATE ON `sessions`
FOR EACH ROW BEGIN
	IF new.u_id NOT IN (
		SELECT id
		FROM users
		WHERE active = 1
	) THEN
		SIGNAL SQLSTATE '45000'
		SET MESSAGE_TEXT = 'Cannot create a session for this user';
	END IF;
END;