-- Migration: Add webhook_token to telegram_integrations
-- This allows identifying user by webhook URL token

-- Add webhook_token column to telegram_integrations
ALTER TABLE telegram_integrations 
ADD COLUMN IF NOT EXISTS webhook_token VARCHAR(255);

-- Create unique index on webhook_token for fast lookups
CREATE UNIQUE INDEX IF NOT EXISTS idx_telegram_integrations_webhook_token 
ON telegram_integrations(webhook_token) 
WHERE webhook_token IS NOT NULL;

-- Generate webhook tokens for existing integrations
-- This will be handled by application code, but we ensure the column exists

COMMENT ON COLUMN telegram_integrations.webhook_token IS 'Unique token for webhook URL identification (e.g., /webhook/telegram/{token})';