I am using AdonisJS to make a backend application. In migrations, specifically in models, we have the option of creating models, but I can't use a default value in enun type. After reading the Knex.js documentation, I couldn't find a way to put this default value in enum type (table.enu) in SGDB Mysql. Could anyone help?

.1/migrations

I am using AdonisJS to make a backend application. In migrations, specifically in models, we have the option of creating models, but I can't use a default value in enun type. After reading the Knex.js documentation, I couldn't find a way to put this default value in enum type (table.enu) in SGDB Mysql. Could anyone help?

https://adonisjs./docs/4.1/migrations

http://knexjs/#Schema-enum

• javascript
• enums
• database-migration
• knex.js
• adonis.js

1 Answer 1

Did you try defaultTo() :

defaultTo — column.defaultTo(value)

Sets the default value for the column on an insert.

From knex Documentation

Example :

table.enu('role', ['one', 'two', 'three']).defaultTo('two', options={})

Adonis Enu/Enum documentation

Adonis defaultTo documentation