const tableName = 'vk_submissions'

function buildTable(t) {
  t.string('id', 64).primary()
  t.string('task_id', 64).notNullable()
  t.string('agent_id', 64).notNullable()
  t.tinyint('round').unsigned().notNullable()
  t.text('summary').notNullable()
  t.json('artifacts').notNullable()
  t.datetime('created_at', { precision: 3 }).notNullable()
  t.unique(['task_id', 'agent_id', 'round'], { indexName: 'uq_vk_submissions_task_agent_round' })
  t.check('round >= 1', [], 'ck_vk_submissions_round')
}

module.exports = { tableName, buildTable }