-- Add api_key column to clients table
-- Run this SQL directly if Alembic migration doesn't work

ALTER TABLE clients 
ADD COLUMN api_key VARCHAR(64) NULL AFTER owner_id;

-- Create unique index on api_key
CREATE UNIQUE INDEX ix_clients_api_key ON clients(api_key);

-- Verify the column was added
DESCRIBE clients;
