Method migrateTaskId

packages/memos-core/src/storage/sqlite.ts:475–482

()

  }

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

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