How to set primary key type to UUID via Sequelize CLI

Question

I'm creating a DB model via Sequelize CLI with this command:

sequelize model:create --name User --attributes "firstname:string, lastname:string" 

This creates the corresponding migration script:

'use strict'; module.exports = {   up: function(queryInterface, Sequelize) {     return queryInterface.createTable('Users', {       id: {         allowNull: false,         autoIncrement: true,         primaryKey: true,         type: Sequelize.INTEGER       },       firstname: {         type: Sequelize.STRING       },       lastname: {         type: Sequelize.STRING       },       createdAt: {         allowNull: false,         type: Sequelize.DATE       },       updatedAt: {         allowNull: false,         type: Sequelize.DATE       }     });   },   down: function(queryInterface, Sequelize) {     return queryInterface.dropTable('Users');   } }; 

As shown, the primary key is set to integer.

Is there a way to default the CLI to use UUID instead?

Answer 1

You can simple use the type UUIDV4 that comes with Sequelize. Here is more details : UUIDV4

For example making this definition:

id: {   type: Sequelize.UUID,   defaultValue: Sequelize.UUIDV4,   allowNull: false,   primaryKey: true } 

This is not using the Sequelize CLI but you can use that native UUIDV4 by manually changing that.