-- Migration: Add research fields to ad_keywords
-- Created: 2026-07-30
-- Adds: search_volume, competition_level, cpc_suggestion, trend_data

ALTER TABLE ad_keywords ADD COLUMN search_volume BIGINT DEFAULT NULL;
ALTER TABLE ad_keywords ADD COLUMN competition_level VARCHAR(20) DEFAULT NULL;
ALTER TABLE ad_keywords ADD COLUMN cpc_suggestion FLOAT DEFAULT NULL;
ALTER TABLE ad_keywords ADD COLUMN trend_data JSON DEFAULT NULL;

-- Track migration
INSERT OR IGNORE INTO schema_migrations (version) VALUES ('008');
