Richard Lynch wrote: > I have this simple database and I'm going to have a handful > of people editing it... > > I'd like to track each and every edit with username, and, > ideally, provide myself an easy "Undo" if I decide [bleep] is > an idiot and shouldn't have done that. > > Now, I'm not real concerned about the relational foreign key > aspect here, and I'd like to keep this as simple as possible... > > I've considered doing a dump and putting the output into subversion, > even... > > I realize there may be some nifty MySQL tool that does this, > so I'll be researching that shortly, but I'm wondering if > there's a nifty change-management php package out there that > I should check out. > > The users are currently slated to be logging in via HTTP > Basic Authentication, but I could change that, I guess. > > K.I.S.S. is definitely the motto around here -- If it takes > more than a day or two to figure out, install, and implement; > then forget it, as I can just hack something together myself in that > time-frame. > > -- > Some people have a "gift" link here. > Know what I want? > I want you to buy a CD from some indie artist. > http://cdbaby.com/browse/from/lynch > Yeah, I get a buck. So? I'm not aware of any existing package that offers this, and if there isn't one I wouldn't be surprised. I think that there are just too many variables for it to be universal enough... But, I thought about it for a second and here's what I came up with... I realize this is not a very efficient way to store data, but it's just an idea... What about instead of running UPDATE queries, you INSERT a new record "on top of it", and if you need to "undo" someone's change, just DELETE that record. I'm not sure how the tables would relate, but it would be something like... initial insert generates customerID -> customerID and customer data go into a separate table -> subsequent changes get stacked up in this table and the most recent record gets displayed when you click to view the customer. Voila, you have a history table and a simple way to "undo" changes. Whaddya think? -B -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
