How Focalboard migration scripts work
mainFocalboard executes migration scripts against the current database during server start-up. The migration engine tracks execution via the focalboard_schema_migrations table to ensure previously executed scripts are skipped.
Key Behaviors:
- Idempotency: Scripts are designed to be idempotent, especially for Postgres and MySQL.
- Troubleshooting: If you encounter schema or data migration errors, you can clear all records from the
focalboard_schema_migrationstable and restart the server to re-run migrations. - Naming Convention: When writing scripts, do not include the table prefix or schema name in the table name argument; use the provided template variables instead.