yiisoft/db-migration

Yii DB Migration

1.1.0 2023-12-24 09:10 UTC

This package is auto-updated.

Last update: 2024-02-07 03:30:09 UTC


README

68747470733a2f2f796969736f66742e6769746875622e696f2f646f63732f696d616765732f7969695f6c6f676f2e737667

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