Function init_wiki_schema

skills/wiki-store/scripts/wiki_db.py:135–253

Create wiki tables, indexes, and FTS mirrors if needed.

()

def init_wiki_schema() -> None:
    """Create wiki tables, indexes, and FTS mirrors if needed."""
    conn = db_ops.get_connection()
    cursor = conn.cursor()

    cursor.execute(
        """
        CREATE TABLE IF NOT EXISTS wiki_nodes (
            id INTEGER PRIMARY KEY AUTOINCREMENT,
            node_id TEXT NOT NULL,
            user_id TEXT NOT NULL,
            node_type TEXT NOT NULL
                CHECK (node_type IN ('paper','section','trajectory','topic')),
            title TEXT NOT NULL,
            body TEXT NOT NULL,
            metadata_json TEXT,
            embedding BLOB,
            embedding_model TEXT,
            keywords TEXT,
            file_path TEXT,
            source_type TEXT,
            source_ref TEXT,
            created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
            updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
            UNIQUE(user_id, node_id)
        )
        """
    )
    cursor.execute(
        """
        CREATE TABLE IF NOT EXISTS wiki_edges (
            id INTEGER PRIMARY KEY AUTOINCREMENT,
            user_id TEXT NOT NULL,
            src_id TEXT NOT NULL,
            dst_id TEXT NOT NULL,
            relation TEXT NOT NULL
                CHECK (relation IN (
                    'cites','same_topic','interested_in','skipped','read',
                    'pinned_must_read','drifted_from','drifted_to',
                    'derived_from','belongs_to','contains_section'
                )),
            weight REAL DEFAULT 1.0,
            metadata_json TEXT,
            created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
            UNIQUE(user_id, src_id, dst_id, relation)
        )
        """
    )
    cursor.execute(
        """
        CREATE TABLE IF NOT EXISTS wiki_citations (
            id INTEGER PRIMARY KEY AUTOINCREMENT,
            user_id TEXT NOT NULL,
            node_id TEXT NOT NULL,
            source TEXT NOT NULL
                CHECK (source IN ('reading_report','pdf','behavior_log','profile','external_url')),
            source_id TEXT NOT NULL,
            anchor TEXT,