saperx/db/migrations/20230725203258_pesquisa.js

exports.up = function(knex, Promise) {
  return knex.schema.createTable('pesquisa', t => {
      t.increments('Id')
      t.string('Nome').notNullable()
      t.timestamp('DataCadastro').notNullable().defaultTo(knex.raw('CURRENT_TIMESTAMP'))
      t.string('Descricao').notNullable()
      t.string('Cabecalho')
      t.string('Imagem')
  })
};

exports.down = function(knex, Promise) {
  return knex.schema.dropTable('pesquisa')
};