-- Per-callback deduplication for Lucky Sports (multiple bets same round, same bet_amount)
-- Each callback has unique (game_round, bet, win, timestamp) - retries have same values

CREATE TABLE IF NOT EXISTS callback_events (
    id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
    game_round VARCHAR(128) NOT NULL,
    callback_key VARCHAR(255) NOT NULL,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    UNIQUE KEY uk_callback_key (callback_key),
    INDEX idx_game_round (game_round)
) ENGINE=InnoDB;