Method initializeDatabase

MCP/scripts/fetch-issues.js:156–230

()

  }

  initializeDatabase() {
    // 原有的 issues 表
    const createIssuesTableSQL = `
      CREATE TABLE IF NOT EXISTS issues (
        id INTEGER PRIMARY KEY,
        number INTEGER UNIQUE,
        title TEXT NOT NULL,
        body TEXT,
        html_url TEXT,
        labels TEXT,
        created_at TEXT,
        updated_at TEXT,
        search_content TEXT
      )
    `;

    // 标签分类表
    const createLabelCategoriesTableSQL = `
      CREATE TABLE IF NOT EXISTS label_categories (
        id INTEGER PRIMARY KEY,
        label TEXT UNIQUE,
        category TEXT,
        description TEXT,
        usage_count INTEGER DEFAULT 0,
        last_used TEXT
      )
    `;

    // 标签关系表（记录标签之间的关联）
    const createLabelRelationsTableSQL = `
      CREATE TABLE IF NOT EXISTS label_relations (
        id INTEGER PRIMARY KEY,
        label1 TEXT,
        label2 TEXT,
        cooccurrence_count INTEGER DEFAULT 0,
        correlation_score REAL,
        last_updated TEXT,
        UNIQUE(label1, label2)
      )
    `;

    // 文章标签映射表（用于快速查询）
    const createArticleLabelsTableSQL = `
      CREATE TABLE IF NOT EXISTS article_labels (
        id INTEGER PRIMARY KEY,
        issue_number INTEGER,
        label TEXT,
        category TEXT,
        weight REAL DEFAULT 1.0,
        FOREIGN KEY(issue_number) REFERENCES issues(number)
      )
    `;

    // 标签层级关系表
    const createLabelHierarchyTableSQL = `
      CREATE TABLE IF NOT EXISTS label_hierarchy (
        id INTEGER PRIMARY KEY,
        parent_label TEXT,