Can't create a table with database migrations

Questions and Answers Database-SQL
1
System Information
  • Strapi Version: 4.6.0
  • Operating System: Mac OS 12.6.2
  • Database: Postgres
  • Node Version: 19.4.0
  • NPM Version: 9.2.0

Hi, I’m trying to create a table on bootstrap with the following migration:

'use strict';

const scriptName = __filename.split(/[\\/]/).pop();

module.exports = {
  async up(knex) {
    console.log(`[migration start]: ${scriptName}`)

    await knex.schema
      .withSchema('public')
      .createTable('test_table',
        (table) => {
          table.increments('id');
          table.string('name', 64).notNullable().unique();
        });

    console.log(`[migration end]: ${scriptName}`)
  },
};

During startup I see start/end messages in the log, no errors, there is a record in strapi_migrations table, but the test_table is missing. What am I doing wrong here?
Version │ 4.6.0 (node v19.4.0)

Any help appreciated.

2

did you get any solution?

3

yes, I decided to create and handle new tables in Java-backend and update schema via flyway, which is a java db migration tool which works as opposed to Strapi migrations.