saperx/db/migrations/20221119224043_cria_integracao.js

exports.up = function(knex, Promise) {
    return knex.schema.createTable('integracao', t => {
        t.increments('Id')
        t.string('Nome')
        t.integer('Tipo')
        t.string('Chave')
        t.string('Url')
        t.string('Token')
        t.timestamp('Atualizacao').notNullable().defaultTo(knex.raw('CURRENT_TIMESTAMP'))
        t.json("Outros")
    })
  };
  
  exports.down = function(knex, Promise) {
    return knex.schema.dropTable('integracao')
  };