Download the PHP package thathoff/kirby-migrations without Composer

Kirby Migrations

This plugin provides commands to Kirby CLI for simple migrations.

Use cases are database migrations for your SQL database, migrating content or creating pages when deploying your Kirby page. See the examples section for more details.

You can also create migrations for your own plugins. See the Migrations for Plugins section for more details.

Kirby CLI

This plugin uses the Kirby CLI to run migrations. Either use it via composer (this plugin will install it for you) or install it globally.

If you installed it globally, you can run the migrations via kirby migrations:apply otherwise use ./vendor/bin/kirby migrations:apply. In the following, we will assume you’re using it via composer.

Configuration

This plugin provides the following configuration options:

• thathoff.migrations.dir: The directory where the migrations are stored. Defaults to a migrations folder inside the Kirby site directory.
• thathoff.migrations.stateFile: The file where the state of the migrations is stored. Defaults to a .migrations file inside the migrations directory.

Usage

Create a New Migration

This will create a new migration file in the migrations directory.

Apply All Pending Migrations

This will apply all pending migrations. When using the -f or --force flag, it will apply the migrations without asking for confirmation (eg. for CI/CD pipelines).

Show Status

This will show the status of the migrations.

Rollback the Last Batch of Migrations

This will rollback the last batch of migrations. When using the -f or --force flag, it will rollback the migrations without asking for confirmation.

Migrations for Plugins

Plugins can also have their own migrations. To support migrations in your plugin, you need to create a migrations folder in your plugin's root directory and enable migrations in your plugin's index.php file by setting the migrations option to true.

To use a different path, you can set the migrations option to the path to the migrations directory:

After this, you can create migrations for your plugin by using the migrations:create command and specifying the plugin ID (in the example above it’s example/test) as the second argument.

It’s recommended to prefix your migration names with your plugins name to avoid conflicts with other plugins as all migrations are created in the same namespace.

All other commands will automatically detect the plugin migrations and apply them accordingly.

Examples

All database examples assume you have a database configured in your config.php file.

Create a Table in a Database

Add a New Column to a Table

Create a Page in the Content

This is pretty handy when you need to create pages that should not be created manually (eg. container pages) and only should exist once.

Authors

Maintained and developed by Markus Denhoff and Contributors.

Supported by reinorange GmbH.