pa3nALJm

1CREATE TABLE IF NOT EXISTS `notification_emails` (
2    `id` INT PRIMARY KEY AUTO_INCREMENT,
3    `recipient` INT,
4    `subject` TEXT,
5    `body` TEXT
6);
7
8TRUNCATE TABLE `notification_emails`;
9
10DROP TRIGGER IF EXISTS `tr_logs_change_email`;
11
12DELIMITER $$
13
14CREATE TRIGGER `tr_logs_change_email`
15AFTER INSERT ON `logs`
16FOR EACH ROW
17BEGIN
18INSERT `notification_emails`( `recipient`,`subject`,`body`)
19 VALUES (`account_id`,CONCAT_WS(' ','Balance change for account:', `account_id`),
20 CONCAT_WS(' ','On',NOW(),'your balance was changed from',`old_sum`,'to',`new_sum`,'.'));
21END $$
22
23DELIMITER ;