Migrator Migration Functions void migration
Add database index on a table column Only available in a migration CFC
Name | Type | Required | Default | Description |
---|---|---|---|---|
table | string | Yes | The table name to perform the index operation on | |
columnNames | string | No | One or more column names to index, comma separated | |
unique | boolean | No | false | If true will create a unique index constraint |
indexName | string | No | [runtime expression] | The name of the index to add: Defaults to table name + underscore + first column name |
addIndex(table='members', columnNames='username', unique=true);