CREATE TABLE IF NOT EXISTS WebsiteTransactionSyncCursor (
  WebsiteID INT NOT NULL,
  TransactionType ENUM('DEPOSIT','WITHDRAW') NOT NULL,
  NewestExternalTransactionID VARCHAR(191) NULL,
  CoverageStartLocal DATETIME NULL,
  LastSyncAtUtc DATETIME(6) NULL,
  LastPagesRead INT NOT NULL DEFAULT 0,
  LastRowsRead INT NOT NULL DEFAULT 0,
  LastSaved INT NOT NULL DEFAULT 0,
  PRIMARY KEY (WebsiteID, TransactionType)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

