cdk/crates/cdk-sql-common/src/wallet/migrations/sqlite/20251021000000_pending_quotes_optimization.sql

-- Add created_time column to mint_quote table for ordering queries
ALTER TABLE mint_quote ADD COLUMN created_time INTEGER NOT NULL DEFAULT 0;

-- Composite index for optimized pending quotes query
-- Supports WHERE amount_issued = 0 OR payment_method = 'bolt12'
CREATE INDEX IF NOT EXISTS idx_mint_quote_pending
ON mint_quote(payment_method, amount_issued);