text: "use strict";
  
  module.exports = {
    up: (queryInterface, Sequelize) => {
      return queryInterface.createTable("providers", {
        cnpj: {
          allowNull: false,
          primaryKey: true,
          type: Sequelize.STRING,
          allowNull: false
        },
        name: {
          type: Sequelize.STRING,
          allowNull: false
        },
        trade: {
          type: Sequelize.STRING,
          allowNull: false
        },
        createdAt: {
          allowNull: false,
          type: Sequelize.DATE
        },
        updatedAt: {
          allowNull: false,
          type: Sequelize.DATE
        }
      });
    },
  
    down: (queryInterface, Sequelize) => {
      return queryInterface.dropTable("providers");
    }
  };
  