Proposal: Simplified alternate logging setup using MariaDB Temporal tables
We are experimenting with MariaDB temporal tables for time stamped data extraction jobs. They make detecting record level updates easy and pass that off to the DB engine.
I would like to propose an alternate method of CiviCRM logging that just enables the MariaDB standard temporal columns and SYSTEM VERSIONING. This logging option would be available if the DB is on MariaDB 10.3 or later. This would remove the need for the triggers.
This should start out as an extension.
Core changes needed to get feature parity with the current method: The "last updated by" column would move from the log_civicrm_xxx schema into the main table (currently is log_user_id).