Yeah, you can do that via a migration! There is an index and dropIndex method for that. The KnexJS documentation has more info on the options these accept, which will vary depending on your database driver.

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

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

  async up() {
    this.schema.alterTable(this.tableName, (table) => {
      // single
      table.index('column_one')

      // multi-column
      table.index(['column_two', 'column_three'])

      // custom named
      table.index(['column_four'], 'custom_index_name', { /* additional opts */ })
    })
  }

  async down() {
    this.schema.alterTable(this.tableName, (table) => {
      // single
      table.dropIndex('column_one')

      // multi-column
      table.dropIndex(['column_two', 'column_three'])

      // custom named
      table.dropIndex(['column_four'], 'custom_index_name')
    })
  }
}

  

    

      Copied!