#1
  1. Contributing User
    Devshed Novice (500 - 999 posts)

    Join Date
    May 2008
    Posts
    577
    Rep Power
    181

    Best Way to track user activity and changes?


    Hi all, just got a theory question about tracking users. I want to be able to keep track of every change a user makes to the database. I can easily keep track of users making inserts in to the database, but then when they update it, it becomes a little trickier. Im trying to come up with a solution that is basically a function and can work for any change to any table.

    What do you guys do for this? I was thinking maybe building an updates table like this

    acct_id---table---field---original_value---new_value---date

    But then the amount of updates going on this table can get fairly large. Any thoughts?
  2. #2
  3. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2011
    Posts
    1
    Rep Power
    0

    Lightbulb


    It is possible to use Checksum MySQL http:// adm-it. net/checksum-mysql

IMN logo majestic logo threadwatch logo seochat tools logo