CODEWITHSUNDEEP
javascriptenumsdatabase-migrationknex.jsadonis.js
Taffarel Xavier
Taffarel Xavier

Reputation: 532

How do I set a default value using enum type in column Mysql using Knex.js?

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.com/docs/4.1/migrations

http://knexjs.org/#Schema-enum

Upvotes: 5

Views: 8080

Answers (1)

crbast
crbast

Reputation: 2292

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

Upvotes: 14

Related Questions