Your proposed solution is far too inflexible. Take a look at http://www.tonymarston.net/php-mysql/auditlog.html which describes a design with incorporates a fixed set of audit tables which can deal with logging changes to any number of application tables with any structure.
-- Tony Marston http://www.tonymarston.net http://www.radicore.org ""Mike Smith"" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > I'm about to try this, but I'd like some suggestions. I have a inventory > table that an employee can update specific fields if they are incorrect, > e.g. > > [INVENTORY_TABLE] > fields example data > part 1027P > serial 543221-K > qty 120 > location G-5 > > I'd like to record what changed. Let's say they change the serial. One way > would be a "static" changes table: > > [INVENTORY_CHANGES] > fields example data > old_part 1027P > new_part 1027P > old_serial 543221-K > new_serial 543221-4 > ... > > I'm thinking a better/more flexible solution would be > > [INVENTORY_CHANGES] > inventory_id (FK to inventory table) > field (in this case it would be serial, detected by comparing POST values > to > original values, but could be serial and qty/location) > original 543221-K > new_value 543221-4 > > Just curious as to other possible solutions or problems with these > (probably > the second one). > > Thanks, > Mike Smith > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
