Contents
The following table provides an overview what DML and DDL events are logged and which command is applied when reverting the event (see chapter on reverting transactions).
| OP_ID | EVENT | REVERSE EVENT | |:-----:|:-----------------------------|:-----------------------------------| | 1 | CREATE TABLE' | DROP TABLE | | 11 | REINIT TABLE | REINIT TABLE | | 12 | (ALTER TABLE) RENAME TABLE' | (ALTER TABLE) RENAME TABLE' | | 2 | (ALTER TABLE) ADD COLUMN' | (ALTER TABLE) DROP COLUMN' | | 21 | ADD AUDIT_ID | TRUNCATE + DROP AUDIT_ID | | 22 | (ALTER TABLE) RENAME COLUMN' | (ALTER TABLE) RENAME COLUMN' | | 3 | INSERT | DELETE | | 4 | UPDATE | UPDATE | | 5 | (ALTER TABLE) ALTER COLUMN' | (ALTER TABLE) ALTER COLUMN' | | 6 | (ALTER TABLE) DROP COLUMN' | (ALTER TABLE) ADD COLUMN' + UPDATE | | 7 | DELETE | INSERT | | 8 | TRUNCATE | INSERT | | 81 | DROP AUDIT_ID | ADD AUDIT_ID + INSERT | | 9 | DROP TABLE' | RECREATE TABLE' |
' Captured by event triggers '' Only if USING is found in the ALTER COLUMN command
The following tables provides an overview on what data is logged in the row_log table:
| OP_ID | EVENT | OLD LOG CONTENT | NEW LOG CONTENT | |:-----:|:-----------------------------|:---------------------------------|:-------------------------------| | 1 | CREATE TABLE' | - | - | | 11 | REININT TABLE | - | - | | 12 | (ALTER TABLE) RENAME TABLE' | - | - | | 2 | (ALTER TABLE) ADD COLUMN' | - (NULL when new data is logged) | all rows of added columns | | 21 | ADD AUDIT_ID | - | - | | 22 | (ALTER TABLE) RENAME COLUMN' | - | - | | 3 | INSERT | NULL | all fields of inserted row | | 4 | UPDATE | changed fields of changed rows | changed fields of changed rows | | 5 | (ALTER TABLE) ALTER COLUMN' | all rows of altered columns | all rows of altered columns | | 6 | (ALTER TABLE) DROP COLUMN' | all rows of dropped columns | NULL | | 7 | DELETE | all fields of deleted row | NULL | | 8 | TRUNCATE | all fields of table | NULL | | 81 | DROP AUDIT_ID | - | - | | 9 | DROP TABLE' | all fields of table (TRUNCATE) | NULL |