CREATE TABLE IF NOT EXISTS chat_media_uploads (
    id BIGSERIAL PRIMARY KEY,
    access_token CHAR(64) NOT NULL UNIQUE,
    chat_id VARCHAR(180) NOT NULL,
    sender_user_id BIGINT NOT NULL,
    sender_email VARCHAR(255) NULL,
    original_name VARCHAR(255) NOT NULL,
    stored_name VARCHAR(255) NOT NULL,
    relative_path TEXT NOT NULL,
    mime_type VARCHAR(160) NOT NULL,
    extension VARCHAR(20) NOT NULL,
    media_type VARCHAR(20) NOT NULL,
    size_bytes BIGINT NOT NULL,
    created_at TIMESTAMPTZ NOT NULL DEFAULT CURRENT_TIMESTAMP,
    deleted_at TIMESTAMPTZ NULL
);

CREATE INDEX IF NOT EXISTS idx_chat_media_chat_id ON chat_media_uploads (chat_id);
CREATE INDEX IF NOT EXISTS idx_chat_media_sender ON chat_media_uploads (sender_user_id);
CREATE INDEX IF NOT EXISTS idx_chat_media_created ON chat_media_uploads (created_at DESC);
