Modulo 02- Video 08 - Migrations dos Usuarios #rocketseat #bootcamp8 #modulo02

..anotacoes Modulo 02- Video 08 - Migrations dos Usuarios.md

gerar o arquivo de migracao para criar a tabela

yarn sequelize migration:create --name=create-users

up: (queryInterface, Sequelize) detalhes dos campos

down: (queryInterface)

executar a criacao da tabela

yarn sequelize db:migrate

se precisar desfazer a ultima

yarn sequelize db:migrate:undo

se precisar desfazer todas as migrations

yarn sequelize db:migrate:undo:all

migrations-create-users.js

'use strict';

module.exports = {
  up: (queryInterface, Sequelize) => {
      return queryInterface.createTable('users', {
        id: {
          type: Sequelize.INTEGER,
          allowNull: false,
          autoIncrement: true,
          primaryKey: true,
        },
        nome: {
          type: Sequelize.STRING,
          allowNull: false,
        },
        email: {
          type: Sequelize.STRING,
          allowNull: false,
          unique: true,
        },
        password_hash: {
          type: Sequelize.STRING,
          allowNull: false,
        },
        provider: {
          type: Sequelize.BOOLEAN,
          defaultValue: false,
          allowNull: false,
        },
        created_at: {
          type: Sequelize.DATE,
          allowNull: false,
        },
        updated_at: {
          type: Sequelize.DATE,
          allowNull: false,
        },
      });
  },

  down: (queryInterface) => {
      return queryInterface.dropTable('users');
  }
};