16 Emails Trigger

CREATE TABLE `logs`(
    log_id INT(11) PRIMARY KEY AUTO_INCREMENT,
    account_id INT(11) NOT NULL,
    old_sum DECIMAL(19,4) NOT NULL,
    new_sum DECIMAL(19,4) NOT NULL,
    CONSTRAINT fk_logs_accounts
    FOREIGN KEY(account_id)
    REFERENCES accounts(id)
);

CREATE TABLE `notification_emails`(
    `id` INT(11) UNSIGNED PRIMARY KEY AUTO_INCREMENT,
    `recipient` INT(11) NOT NULL,
    `subject` VARCHAR(50) NOT NULL,
    `body` VARCHAR(255) NOT NULL
);

CREATE TRIGGER tr_notification_emails
AFTER INSERT
ON `logs`
FOR EACH ROW
BEGIN
    INSERT INTO `notification_emails`(`recipient`, `subject`, `body`)
    VALUES (NEW.account_id,
            CONCAT('Balance change for account: ', NEW.account_id),
            CONCAT('On ', DATE_FORMAT(NOW(), '%b %d %Y at %r'), ' your balance was changed from ',
                ROUND(NEW.old_sum, 2), ' to ', ROUND(NEW.new_sum, 2), '.'));
END