宜博 / vokoworld

const tableName = 'vk_jobs'

function buildTable(t) {
  t.string('id', 64).primary()
  t.string('kind', 32).notNullable()
  t.string('ref_id', 64).nullable()
  t.datetime('run_at', { precision: 3 }).notNullable()
  t.string('status', 16).notNullable()
  t.datetime('lease_until', { precision: 3 }).nullable()
  t.tinyint('attempts').unsigned().notNullable()
  t.string('dedupe_key', 191).notNullable()
  t.text('last_error').nullable()
  t.datetime('created_at', { precision: 3 }).notNullable()
  t.datetime('updated_at', { precision: 3 }).nullable()
  t.unique(['dedupe_key'], { indexName: 'uq_vk_jobs_dedupe' })
  t.index(['status', 'run_at'], 'idx_vk_jobs_due')
  t.check("status in ('pending','running','done','failed')", [], 'ck_vk_jobs_status')
  t.check("status <> 'running' or lease_until is not null", [], 'ck_vk_jobs_lease')
}

module.exports = { tableName, buildTable }