
CREATE TABLE IF NOT EXISTS trends_history (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    country TEXT,
    trend TEXT,
    date TEXT,
    sentiment_score REAL
);

INSERT INTO trends_history (country, trend, date, sentiment_score) VALUES
('India', 'AI Dominates News', '2025-03-20', 0.75),
('US', 'Election Updates', '2025-03-20', -0.2),
('UK', 'Royal Family News', '2025-03-20', 0.1);
