Method migrateOwnerFields

packages/memos-core/src/storage/sqlite.ts:227–240

()

  }

  private migrateOwnerFields(): void {
    const chunkCols = this.db.prepare("PRAGMA table_info(chunks)").all() as Array<{ name: string }>;
    if (!chunkCols.some((c) => c.name === "owner")) {
      this.db.exec("ALTER TABLE chunks ADD COLUMN owner TEXT NOT NULL DEFAULT 'agent:main'");
      this.db.exec("CREATE INDEX IF NOT EXISTS idx_chunks_owner ON chunks(owner)");
      this.log.info("Migrated: added owner column to chunks");
    }
    const taskCols = this.db.prepare("PRAGMA table_info(tasks)").all() as Array<{ name: string }>;
    if (!taskCols.some((c) => c.name === "owner")) {
      this.db.exec("ALTER TABLE tasks ADD COLUMN owner TEXT NOT NULL DEFAULT 'agent:main'");
      this.db.exec("CREATE INDEX IF NOT EXISTS idx_tasks_owner ON tasks(owner)");
      this.log.info("Migrated: added owner column to tasks");
    }
  }

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