Re: [GENERAL] log database changes - a design problem?

2006-11-23 Thread Andreas Kretschmer
Luca Ferrari <[EMAIL PROTECTED]> schrieb: > Here comes my question: how can I catch user changes to each record in the > database without be bored with user/date details? Anyone can suggest me a > smart solution and/or database design? Anyone has already found such kind of > problem? Perhaps

Re: [GENERAL] log database changes - a design problem?

2006-11-23 Thread Martijn van Oosterhout
On Thu, Nov 23, 2006 at 08:53:28AM +0100, Luca Ferrari wrote: > Hi all, > I've got my database on which I'm building a Java application. Since I'd like > to store information about who inserted and updated a specified record, I > placed in my main tables a few additional fields to store such info

[GENERAL] log database changes - a design problem?

2006-11-22 Thread Luca Ferrari
Hi all, I've got my database on which I'm building a Java application. Since I'd like to store information about who inserted and updated a specified record, I placed in my main tables a few additional fields to store such information: CREATE TABLE myTable( insertUser varchar(30), in