Re: [PHP] Change tracking

-- On Fri, 10/31/08, Mike Smith <mikeosmith@xxxxxxxxx> wrote:

[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:

Another way is to never change a record, but to add new ones. You also need to add an effectivity date field.

Stephen
.