DROP TRIGGER IF EXISTS `updateReportTime`;

DELIMITER ;;

CREATE TRIGGER `updateReportTime` BEFORE INSERT ON `charge_cache` FOR EACH ROW BEGIN

SET NEW.report_time=unix_timestamp(NOW());

END

;;

DELIMITER ;