sql.md

+------------------+--------+--------------+------------------------------------------------------------------------------------------------------------------------------+--------+---------+----------+----------------+----------------------+----------------------+--------------------+
| Trigger          | Event  | Table        | Statement                                                                                                                    | Timing | Created | sql_mode | Definer        | character_set_client | collation_connection | Database Collation |
+------------------+--------+--------------+------------------------------------------------------------------------------------------------------------------------------+--------+---------+----------+----------------+----------------------+----------------------+--------------------+
| transactions__ai | INSERT | transactions | INSERT INTO jyai.transactions_history SELECT 'insert', NULL, NOW(), d.* FROM jyai.transactions AS d WHERE d.id = NEW.id      | AFTER  | NULL    |          | root@localhost | utf8                 | utf8_general_ci      | latin1_swedish_ci  |
| transactions__au | UPDATE | transactions | INSERT INTO jyai.transactions_history SELECT 'update', NULL, NOW(), d.* FROM jyai.transactions AS d WHERE d.id = NEW.id      | AFTER  | NULL    |          | root@localhost | utf8                 | utf8_general_ci      | latin1_swedish_ci  |
| transactions__bd | DELETE | transactions | INSERT INTO jyai.transactions_history SELECT 'delete', NULL, NOW(), d.* FROM jyai.transactions AS d WHERE d.id = OLD.id      | BEFORE | NULL    |          | root@localhost | utf8                 | utf8_general_ci      | latin1_swedish_ci  |
+------------------+--------+--------------+------------------------------------------------------------------------------------------------------------------------------+--------+---------+----------+----------------+----------------------+----------------------+--------------------+