create-migration

name	create-migration
description	Create a new database migration file for the OWID MySQL database. Use when the user needs to create a database schema change or migration.
metadata	{"internal":true}

Create Database Migration

Create a new database migration file for the OWID MySQL 8 database.

Steps

1. Run yarn createDbMigration db/migration/<NewMigrationName> where <NewMigrationName> is a descriptive name for the migration
2. The generated filename will contain a timestamp prefix, so scan the db/migration/ directory to find the actual path of the new file
3. Report the new file path to the user

Naming Guidelines

Choose a descriptive name for the migration that clearly indicates what schema change is being made (e.g., AddUserEmailIndex, CreateAuditLogTable, RemoveDeprecatedColumns).