| http://www.w3.org/ns/prov#value | - The following is a script that generates an audit table for a provided table name.It will:- Add 5 audit columns to an existing table (DataVersion, CreatedDate, CreatedBy, ModifiedDate, ModifiedBy)- Create 2 triggers on the production table, one for updates and one for deletes (inserts do not need audit info)- Create an audit table with similar design as the production table- Create a primary key i
|
