History functionality

[Quoted] [Quoted] i'm currently working on a little Database project for my diploma. Now i [Quoted] [Quoted] need to have a history funtionality for a few of my tables. This must include the old values, time and date of change and user who changed the value.

Has anyone an idea how to realize such a functionality in an "as intelligent as possible" way? Or maybe a good tip for literatur regarding this problem?

Thanks in advance.

-- 
Using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/