 CREATE TRIGGER results_approve_created_stamp BEFORE INSERT ON results_approve
 FOR EACH ROW EXECUTE PROCEDURE created_stamp();
 
-CREATE TRIGGER results_approve_modified_stamp BEFORE INSERT ON results_approve
-FOR EACH ROW EXECUTE PROCEDURE modified_stamp();
+CREATE TRIGGER results_approve_modified_stamp BEFORE UPDATE ON results_approve
+FOR EACH ROW EXECUTE PROCEDURE modified_stamp();

CREATE TRIGGER challenges_created_stamp BEFORE INSERT ON challenges
FOR EACH ROW EXECUTE PROCEDURE created_stamp();

CREATE TRIGGER challenges_modified_stamp BEFORE INSERT ON challenges
FOR EACH ROW EXECUTE PROCEDURE modified_stamp();

----------------------------------------

CREATE TRIGGER performances_created_stamp BEFORE INSERT ON performances
FOR EACH ROW EXECUTE PROCEDURE created_stamp();

CREATE TRIGGER performances_modified_stamp BEFORE UPDATE ON performances
FOR EACH ROW EXECUTE PROCEDURE modified_stamp();

----------------------------------------
