Anonymous

DELIMITER //

CREATE TRIGGER ins_date
BEFORE INSERT ON filestat
FOR EACH ROW
BEGIN
SET NEW.created = NOW();
SET NEW.modified = NOW();
END;//

CREATE TRIGGER mod_date
BEFORE UPDATE ON filestat
FOR EACH ROW
BEGIN
SET NEW.modified = NOW();
END;//

DELIMITER ;