Method migrateSkillId

packages/memos-core/src/storage/sqlite.ts:545–552

()

  }

  private migrateSkillId(): void {
    const cols = this.db.prepare("PRAGMA table_info(chunks)").all() as Array<{ name: string }>;
    if (!cols.some((c) => c.name === "skill_id")) {
      this.db.exec("ALTER TABLE chunks ADD COLUMN skill_id TEXT");
      this.db.exec("CREATE INDEX IF NOT EXISTS idx_chunks_skill ON chunks(skill_id)");
      this.log.info("Migrated: added skill_id column to chunks");
    }
  }

  private migrateSkillQualityScore(): void {
    const skillCols = this.db.prepare("PRAGMA table_info(skills)").all() as Array<{ name: string }>;