DELIMITER //
CREATE TRIGGER on_records_update
AFTER UPDATE ON records
FOR EACH ROW
BEGIN
INSERT INTO races VALUES (NEW.race, 0, UNIX_TIMESTAMP(), 0)
ON DUPLICATE KEY UPDATE lastupdate = UNIX_TIMESTAMP();
END//
DELIMITER ;
Added to mysql, seems to work nicely