BEGIN
	UPDATE checkinInfo
	SET checkinCount = NEW.checkinCount
	WHERE bid = NEW.bid
		AND checkinDay = NEW.checkinDay
		AND checkinTime = NEW.checkinTime
        AND NEW.checkinCount IS NOT NULL
        AND NEW.checkinCount > 0;
	UPDATE business
	SET numCheckins = NEW.checkinCount
	WHERE bid = NEW.bid
    	AND NEW.checkinCount IS NOT NULL
        AND NEW.checkinCount > 0;
	RETURN NEW;