-- Migration: 002_idempotency_table
-- Description: Add idempotency_keys table for handling idempotent requests

CREATE TABLE IF NOT EXISTS idempotency_keys (
  id BIGINT PRIMARY KEY AUTO_INCREMENT,
  key VARCHAR(255) NOT NULL UNIQUE,
  response_body TEXT NULL,
  created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);