Log trigger is a a pattern to create a trigger to automatically store historical information of a table in a relational database.
It works on a parallel table, creating infomation in a scheme of tuple versioning.
More detailed information: Log trigger in Wikipedia.
The intention of this repository is to mantain the definition of the Log trigger in as many database providers as possible, given that they use very different syntax and semantics, specially for triggers.
Currently, we have the defintition for the following database providers:
- IBM DB2
- Microsoft SQL Server
- MySQL
- Oracle
Log trigger is licensed under the CC BY-SA 4.0 license, so you can use it freely, even for commercial purposes, provided you give appropriate credit to the author.
Shield:
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.
If you know how to implement the Log trigger in a database provider other than those maintained in this repository, feel free to request a pull.