Migration file for Verification Token

create-verification-token.js

module.exports = {
  up: function(queryInterface, Sequelize) {
    return queryInterface.createTable('VerificationTokens', {
      id: {
        allowNull: false,
        autoIncrement: true,
        primaryKey: true,
        type: Sequelize.INTEGER
      },
      userId: {
        type: Sequelize.INTEGER,
        allowNull: false,
        onUpdate: "cascade",
        onDelete: "cascade",
        references: { model: "Users", key: "id" }
      },
      token: {
        type: Sequelize.STRING,
        allowNull: false
      },
      createdAt: {
        allowNull: false,
        type: Sequelize.DATE
      },
      updatedAt: {
        allowNull: false,
        type: Sequelize.DATE
      }
    }).then(() => {
      console.log('created VerificationToken table');
      return queryInterface.sequelize.query(`
        CREATE EVENT expireToken
        ON SCHEDULE AT CURRENT_TIMESTAMP + INTERVAL  1 DAY 
        DO
        DELETE FROM verification_tokens WHERE createdAt < DATE_SUB(NOW(), INTERVAL 1 DAY);
        `)
    }).then(() => { console.log('expireToken event created') });
  },
  down: function(queryInterface) {
    return queryInterface.dropTable('VerificationTokens')
	  .then(() => {
	    console.log(‘VericationTokens table dropped’)
	    return queryInterface.sequelize.query(`DROP EVENT IF EXISTS  expireToken`);
    }).then(() => { console.log(‘expireToken event dropped’) })
  }
};

Yes @ShejaEddy and you resend the email verification in the callback that validates the JWT token

Hey @aanchirinah this tutorials looks good, waiting for the updated version.