Download the PHP package antonyz89/yii2-migrate without Composer
On this page you can find all versions of the php package antonyz89/yii2-migrate. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Informations about the package yii2-migrate
yii2-migrate
Installation
The preferred way to install this extension is through composer.
Either run
or add
to the require section of your composer.json
file.
USAGE
console/config/main.php
MIGRATE COMMANDS
yii migrate/create
yii migrate/fresh
yii migrate/full
( Fresh + Seeder ) ( requires antonyz89/yii2-seeder )
MIGRATION
It is no longer necessary to create index and foreign keys, columns that end with _id
will have a foreign key associated with the name that comes before _id
.
Example:
company_id
column is a foreign key to the company
table.
If this is not the case, add your column to the variable $ignoreColumns
and these columns will not have indexing or foreign key automatically associated with them.
To disable association of indexing and foreign keys for all columns, simply assign $autoGenerateIndexAndForeignKey = false
When a column is added individually (addColumn()
), an index and a foreign key are also generated if the column follows the pattern mentioned above.
The procedures for disabling automatic association are the same
When a column is dropped (dropColumn()
), if a foreign key exists, it is automatically removed.
If for some reason you don't want this to happen, just public $autoDropForeignKey = false;
or add the column in $ignoreColumns
to disable it for specific columns.
to create a index and foreign key use indexAndForeignKey($column, $options = [])
$options
example:
To set global default value of ON UPDATE
and ON DELETE
, replace Migration::$onDelete
and Migration::$onUpdate
in bootstrap.php