knex.js warning

[openstepmedia]

Recently I've been running migrations and received this warning.

package.json is:

"@adonisjs/lucid": "^5.0.2",

Knex:warning - Use async .hasTable to check if table exists and then use plain .createTable. Since .createTableIfNotExists actually just generates plain "CREATE TABLE IF NOT EXIST..." query it will not work correctly if there are any alter table queries generated for columns afterwards. To not break old migrations this function is left untouched for now, but it should not be used when writing new code and it is removed from documentation.

Just FYI

[iamraphson]

@thetutlage @RomainLanz Any update about this warning?

[RomainLanz]

When do you have this warning (which driver and what have you done)?

[iamraphson]

recently when I run a migration

[RomainLanz]

Does this is still an issue? @iamraphson @openstepmedia

[iamraphson]

@RomainLanz yes, I have updated all my NPM packages.

[thetutlage]

The warning is correct. All knex is asking is to use hasTable in combination with createTable.

So simply remove createTableIfExists and use what knex is suggesting.

[iamraphson]

thanks @thetutlage

[chelizichen]

The warning is correct. All knex is asking is to use hasTable in combination with createTable.

So simply remove createTableIfExists and use what knex is suggesting.

thanks