Class CreateTableAddIndexBuilder

Simply calls the provided function passing this as the only argument. $call returns what the provided function returns.

Specifies the index type.

Examples

await db.schema
  .createTable('person')
  .addColumn('email', 'varchar(255)')
  .addIndex('email_index', ['email'], (ib) => ib.using('hash'))
  .execute()
Copy

The generated SQL (MySQL):

create table `person` (`email` varchar(255), index `email_index` (`email`) using hash)
Copy

Specifies the index type.

Examples

await db.schema
  .createTable('person')
  .addColumn('email', 'varchar(255)')
  .addIndex('email_index', ['email'], (ib) => ib.using('hash'))
  .execute()
Copy

The generated SQL (MySQL):

create table `person` (`email` varchar(255), index `email_index` (`email`) using hash)
Copy