Best laravel framework open-source packages.

Db migration

The package implementing migration for yiisoft/db.
Updated 3 months ago

Yii DB Migration


Latest Stable Version Total Downloads Build status codecov Mutation testing badge static analysis type-coverage

Yii DB Migration allows you to manage database schema using migrations.

Supports the following databases out of the box:

  • MSSQL of versions 2017, 2019, 2022.
  • MySQL of versions 5.7–8.0.
  • MariaDB of versions 10.4–10.9.
  • Oracle of versions 12c–21c.
  • PostgreSQL of versions 9.6–15.
  • SQLite of version 3.3 and above.

Requirements

  • PHP 8.0 or higher.
  • Filter PHP extension.

Installation

The preferred way to install this extension is through composer.

Either run

composer require yiisoft/db-migration

or add

"yiisoft/db-migration": "^1.0"

to the require section of your composer.json.

Usage

Command list

migrate:create   Creates a new migration.
migrate:down     Reverts the specified number of latest migrations.
migrate:history  Displays the migration history.
migrate:new      Displays not yet applied migrations.
migrate:redo     Redoes the last few migrations.
migrate:up       Applies new migrations.

The create command allows defining fields for the table being created.

Support

If you need help or have a question, the Yii Forum is a good place for that. You may also check out other Yii Community Resources.

Testing

Check the testing instructions to learn about testing.

License

The Yii Db Migration is free software. It is released under the terms of the BSD License. Please see LICENSE for more information.

Maintained by Yii Software.

Support the project

Open Collective

Follow updates

Official website Twitter Telegram Facebook Slack