Quote:
Is the uuid derived from something or a true "random" uuid?
For the software table I was looking at product GUID, or something similar and add it to the auditing script, but I just realized that product guids are not unique per install but unique to the product. This will create duplicates GUIDs on the table which is not exactly what I was looking for so I might end up creating true random UUIDs, but still not sure how to approach this programatically. I was thinking via a db trigger but no UUID function on MySQL 5.7 so I've just been manually inserting GUIDs into the database.
Still thinking how to go about this...