MigrationHelper

Type
Class
Namespace
craft\helpers
Inherits
craft\helpers\MigrationHelper
Since
3.0.0
Deprecated in
in 4.0.0. Use [[Db]] instead.

Migration utility methods.

View source (opens new window)

# Public Methods

Method Description
doesForeignKeyExist() Returns whether a foreign key exists.
doesIndexExist() Returns whether an index exists.
dropAllForeignKeysOnTable() Drops all the foreign keys on a table.
dropAllForeignKeysToTable() Drops all the foreign keys that reference a table.
dropAllIndexesOnTable() Drops all the indexes on a table.
dropAllUniqueIndexesOnTable() Drops all the unique indexes on a table.
dropForeignKey() Drops a foreign key.
dropForeignKeyIfExists() Drops a foreign key if it exists.
dropIndex() Drops an index.
dropIndexIfExists() Drops an index if it exists.
dropTable() Drops a table, its own foreign keys, and any foreign keys referencing it.
findForeignKey() Returns whether a foreign key exists.
findForeignKeysTo() Returns a list of all the foreign keys that point to a given table/column.
renameColumn() Renames a column, while also updating any index and FK names that use the column.
renameTable() Renames a table, while also updating its sequence, index, and FK names, as well as any other FK names pointing to the table.
restoreForeignKey() Restores a foreign key.
restoreIndex() Restores an index.

# doesForeignKeyExist()

Returns whether a foreign key exists.

View source (opens new window)

Arguments

Returns

boolean (opens new window)

# doesIndexExist()

Returns whether an index exists.

View source (opens new window)

Arguments

Returns

boolean (opens new window)

# dropAllForeignKeysOnTable()

Drops all the foreign keys on a table.

View source (opens new window)

Arguments

Returns

array (opens new window) – An array of the foreign keys that were just dropped.

# dropAllForeignKeysToTable()

Drops all the foreign keys that reference a table.

View source (opens new window)

Arguments

# dropAllIndexesOnTable()

Drops all the indexes on a table.

View source (opens new window)

Arguments

# dropAllUniqueIndexesOnTable()

Drops all the unique indexes on a table.

View source (opens new window)

Arguments

# dropForeignKey()

Drops a foreign key.

View source (opens new window)

Arguments

# dropForeignKeyIfExists()

Drops a foreign key if it exists.

View source (opens new window)

Arguments

# dropIndex()

Drops an index.

View source (opens new window)

Arguments

# dropIndexIfExists()

Drops an index if it exists.

View source (opens new window)

Arguments

# dropTable()

Drops a table, its own foreign keys, and any foreign keys referencing it.

View source (opens new window)

Arguments

# findForeignKey()

Since
3.0.27

Returns whether a foreign key exists.

View source (opens new window)

Arguments

Returns

string (opens new window), null (opens new window) – The foreign key name, or null if it doesn't exist

# findForeignKeysTo()

Returns a list of all the foreign keys that point to a given table/column.

View source (opens new window)

Arguments

Returns

array (opens new window) – A list of the foreign keys pointing to that table/column.

# renameColumn()

Renames a column, while also updating any index and FK names that use the column.

View source (opens new window)

Arguments

# renameTable()

Renames a table, while also updating its sequence, index, and FK names, as well as any other FK names pointing to the table.

View source (opens new window)

Arguments

# restoreForeignKey()

Restores a foreign key.

View source (opens new window)

Arguments

# restoreIndex()

Restores an index.

View source (opens new window)

Arguments