sql/create_spaces.sql

-- Experimental table structure for MCP tracking
CREATE TABLE IF NOT EXISTS spaces (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    space_id TEXT UNIQUE,
    title TEXT NOT NULL,
    author TEXT,
    description TEXT,
    likes INTEGER DEFAULT 0,
    url TEXT UNIQUE,
    
    --model_card TEXT,

    tags TEXT,
    last_modified TIMESTAMP,
    private BOOLEAN DEFAULT 0
);

CREATE INDEX IF NOT EXISTS idx_space_id ON spaces(space_id);