Adding new fields to db (DB Manager) - when adding contents, DB update fails

======== TEMPLATE BUG FORM ========

Wappler Version : 3.5.2
Operating System : MAC, NODE. MySql8. Docker.

Expected behavior

I should be able to add a new field/update a field with comments.

Actual behavior

Screen Shot 2020-11-13 at 10.48.59 am

exports.up = function(knex) {
  return knex.schema
    .table('job_agg_jobs_data', function (table) {
      table.integer('status').comment('1 is active
2 is won
3 is lost
4 is archived');
    })
};

exports.down = function(knex) {
  return knex.schema
    .table('job_agg_jobs_data', function (table) {
      table.dropColumn('status');
    })
};
Community Page
Last updated: