-- Create the SQLite database and table for tracking warnings

-- Table: warnings
CREATE TABLE IF NOT EXISTS warnings (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    chat_id TEXT NOT NULL,
    user_id TEXT NOT NULL
);

-- Create an index on chat_id and user_id for faster lookups
CREATE INDEX IF NOT EXISTS idx_chat_user ON warnings (chat_id, user_id);