trigger to create a log file

[andrew thompson]

Hi guys, im a newbie to creating triggers and i have a requirement to do the following.

When a record in a table is edited i.e forename is changed from andrew to andy i need a trigger that will automatically log this change to another table called db_log. The set up of the log table will be as follows:

table edited
date
id of table
user that edited
type of edit (add, modify, delete)
field\row
value before
value after

for example in the above case

customer
07/02/06
1
andrewt
modify
forename
andrew
andy

i also need it to work for an add to a table and also a delete..if anyone could help me or point me in the right direction id really appreciate it

Andy