shorthand for trigger

[charles candy]

Hi,

I need to create trigger for all tables in the database
the trigger will write the following info to log file
-Date
-Time
-tablename
-user
-actiontype -> whether is insert,update,delete

currently this is the trigger i created . I need to repeat it for update and delete .

CREATE TRIGGER tg_logs_emp_dept_ins
AFTER INSERT ON emp_dept
FOR EACH ROW
BEGIN
INSERT INTO logs_table VALUES(
NULL,
CURDATE(),
CURTIME(),
'emp_dept',
USER(),
'INSERT');

END


any shorthand for this? I need to do for about 50 tables