Database Migration / Deployment Questions

Questions and Answers
50

Hello, not sure what the progress is on this issue, however by following the documentation PR I am unable to get migrations to properly save the changes in the database.

Here’s a sample migration I tested:

'use strict'

const tableName = 'artworks'

/** @param {import('knex').Knex} knex */
exports.up = async (knex) => {
  await knex.schema.table(tableName, async t => {
    t.string('test').nullable()
  })
}

/** @param {import('knex').Knex} knex */
exports.down = async () => { }

The migration runs without errors and is saved inside the strapi_migrations table, however the table schema is not changed (I think Strapi automatically removes all unknown columns and even indexes after the migration.)

1 Like