-- OPTIONAL but recommended: makes wallet_ledger append-only at the database level.
-- Requires the TRIGGER privilege (available on most cPanel MySQL users).
-- Import via phpMyAdmin with the delimiter set to $$ (or run with the mysql CLI).
DROP TRIGGER IF EXISTS wallet_ledger_no_update;
DROP TRIGGER IF EXISTS wallet_ledger_no_delete;

DELIMITER $$
CREATE TRIGGER wallet_ledger_no_update BEFORE UPDATE ON wallet_ledger
FOR EACH ROW BEGIN
  SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'wallet_ledger is append-only';
END$$
CREATE TRIGGER wallet_ledger_no_delete BEFORE DELETE ON wallet_ledger
FOR EACH ROW BEGIN
  SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'wallet_ledger is append-only';
END$$
DELIMITER ;
