-- --------------------------------------------------------
-- Server OS:                    Linux
-- HeidiSQL Version:             11.2.0.6213
-- --------------------------------------------------------


-- Dumping database structure for mutu
USE `mutu`;

-- Dumping structure for trigger mutu.verifikasi_after_insert
SET @OLDTMP_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_ENGINE_SUBSTITUTION';
DELIMITER //
CREATE TRIGGER `verifikasi_after_insert` AFTER INSERT ON `verifikasi` FOR EACH ROW BEGIN
	UPDATE data_indikator 
	SET STATUS = 2 
	WHERE YEAR(TANGGAL) = YEAR(NEW.PERIODE)
	AND MONTH(TANGGAL) = MONTH(NEW.PERIODE)
	AND RUANGAN = NEW.RUANGAN
	AND `INDIKATOR` = NEW.INDIKATOR;
END//
DELIMITER ;

