Index

Adds an index to a table.

Command

$ eucalypt migration add index
# Alias/shortened
$ eucalypt m add index
$ eucalypt m add i
$ eucalypt m a i

Arguments

  • [TABLE] - The name of the table.

  • *[COLUMNS] - The columns to index.

Options/flags

  • --name alias -n

    The name of the index (if argument is left empty, ActiveRecord will generate a name for the index).

  • --options alias -o (Possible values: [unique, length, where, using, type])

    Additional options for the index.

Examples

  • $ eucalypt m add index games opening

    Adds an index on the opening column in the games table (with default options).

  • $ eucalypt m add index games white_elo black_elo

    Adds a joint index on the white_elo and black_elo in the games table (with default options).

  • $ eucalypt m add index games opening -n index_games_on_opening

    Adds a named index on the opening column in the games table.

  • $ eucalypt m add index games opening -o using:gist unique:false

    Adds a non-unique GIST index on the opening column in the games table.