Replication - INFORMATION_SCHEMA views for transaction log
Implement a number of views in the INFORMATION_SCHEMA for querying the transaction log:
CREATE TABLE INFORMATION_
FILE_NAME VARCHAR NOT NULL
, FILE_LENGTH BIGINT NOT NULL
, NUM_LOG_ENTRIES BIGINT NOT NULL
, NUM_TRANSACTIONS BIGINT NOT NULL
, MIN_TRANSACTION_ID BIGINT NOT NULL
, MAX_TRANSACTION_ID BIGINT NOT NULL
, MIN_TIMESTAMP BIGINT NOT NULL
, MAX_TIMESTAMP BIGINT NOT NULL
);
CREATE TABLE INFORMATION_
ENTRY_OFFSET BIGINT NOT NULL
, ENTRY_TYPE VARCHAR NOT NULL
, ENTRY_LENGTH BIGINT NOT NULL
);
CREATE TABLE INFORMATION_
ENTRY_OFFSET BIGINT NOT NULL
, TRANSACTION_ID BIGINT NOT NULL
, SERVER_ID INT NOT NULL
, START_TIMESTAMP BIGINT NOT NULL
, END_TIMESTAMP BIGINT NOT NULL
, NUM_STATEMENTS INT NOT NULL
, CHECKSUM INT NOT NULL
);