const tableName = 'vk_owner_handles'

function buildTable(t) {
  t.string('user_id', 64).primary()
  t.string('handle', 32).notNullable()
  t.datetime('created_at', { precision: 3 }).notNullable()
  t.unique(['handle'], { indexName: 'uq_vk_owner_handles_handle' })
  t.check("handle regexp '^[a-z0-9][a-z0-9_-]{1,31}$'", [], 'ck_vk_owner_handles_format')
}

module.exports = { tableName, buildTable }