project-nomad/admin/database/migrations/1776400000001_add_benchmark_harness_metadata.ts

import { BaseSchema } from '@adonisjs/lucid/schema'

export default class extends BaseSchema {
  protected tableName = 'benchmark_results'

  async up() {
    this.schema.alterTable(this.tableName, (table) => {
      // Forensic harness metadata (Score v2 Phase 1): which sysbench image digest produced the
      // system scores, and which Ollama version served the AI benchmark. Both nullable —
      // pre-existing rows and runs without AI simply leave them empty.
      table.string('sysbench_digest').nullable()
      table.string('ollama_version').nullable()
    })
  }

  async down() {
    this.schema.alterTable(this.tableName, (table) => {
      table.dropColumn('sysbench_digest')
      table.dropColumn('ollama_version')
    })
  }
}