Method migrateTaskSkillMeta

packages/memos-core/src/storage/sqlite.ts:580–587

()

  }

  private migrateTaskSkillMeta(): void {
    const cols = this.db.prepare("PRAGMA table_info(tasks)").all() as Array<{ name: string }>;
    if (!cols.some((c) => c.name === "skill_status")) {
      this.db.exec("ALTER TABLE tasks ADD COLUMN skill_status TEXT DEFAULT NULL");
      this.db.exec("ALTER TABLE tasks ADD COLUMN skill_reason TEXT DEFAULT NULL");
      this.log.info("Migrated: added skill_status/skill_reason columns to tasks");
    }
  }

  setTaskSkillMeta(taskId: string, meta: { skillStatus: string; skillReason: string }): void {
    this.db.prepare("UPDATE tasks SET skill_status = ?, skill_reason = ?, updated_at = ? WHERE id = ?")