CREATE TRIGGER updateDailyPayment
AFTER INSERT ON payment
FOR EACH ROW
BEGIN
	IF DATE(NEW.payment_date) NOT IN (SELECT payment_date
							FROM dailypayment)
    THEN
		INSERT INTO dailypayment
		VALUES (DATE(NEW.payment_date), NEW.amount);
	ELSE
		UPDATE dailypayment
        SET totalamount = totalamount + NEW.amount
        WHERE dailypayment.payment_date = DATE(NEW.payment_date);
	END IF;
END