-- SIMSURAT - trigger append-only (opsional).
-- Impor SETELAH simsurat_instalasi.sql. Bila hosting menolak (butuh hak TRIGGER/SUPER),
-- lewati saja: proteksi append-only tetap berlaku di level aplikasi.

DROP TRIGGER IF EXISTS `trg_tb_sys_log_aktivitas_tolak_update`;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` TRIGGER `trg_tb_sys_log_aktivitas_tolak_update` BEFORE UPDATE ON `tb_sys_log_aktivitas` FOR EACH ROW SIGNAL SQLSTATE '45000'
                        SET MESSAGE_TEXT = 'Data tb_sys_log_aktivitas bersifat append-only dan tidak dapat diubah atau dihapus.';;
DELIMITER ;

DROP TRIGGER IF EXISTS `trg_tb_sys_log_aktivitas_tolak_delete`;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` TRIGGER `trg_tb_sys_log_aktivitas_tolak_delete` BEFORE DELETE ON `tb_sys_log_aktivitas` FOR EACH ROW SIGNAL SQLSTATE '45000'
                        SET MESSAGE_TEXT = 'Data tb_sys_log_aktivitas bersifat append-only dan tidak dapat diubah atau dihapus.';;
DELIMITER ;

DROP TRIGGER IF EXISTS `trg_tb_trx_riwayat_surat_tolak_update`;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` TRIGGER `trg_tb_trx_riwayat_surat_tolak_update` BEFORE UPDATE ON `tb_trx_riwayat_surat` FOR EACH ROW SIGNAL SQLSTATE '45000'
                        SET MESSAGE_TEXT = 'Data tb_trx_riwayat_surat bersifat append-only dan tidak dapat diubah atau dihapus.';;
DELIMITER ;

DROP TRIGGER IF EXISTS `trg_tb_trx_riwayat_surat_tolak_delete`;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` TRIGGER `trg_tb_trx_riwayat_surat_tolak_delete` BEFORE DELETE ON `tb_trx_riwayat_surat` FOR EACH ROW SIGNAL SQLSTATE '45000'
                        SET MESSAGE_TEXT = 'Data tb_trx_riwayat_surat bersifat append-only dan tidak dapat diubah atau dihapus.';;
DELIMITER ;