CREATE TABLE IF NOT EXISTS affiliate_callback_events (
  id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  network VARCHAR(40) NOT NULL,
  event_key VARCHAR(191) NOT NULL,
  payload_json LONGTEXT NOT NULL,
  received_at DATETIME NOT NULL,
  PRIMARY KEY (id),
  UNIQUE KEY affiliate_callback_events_network_event_key_uq (network, event_key),
  KEY affiliate_callback_events_received_at_idx (received_at)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;