mysql两列唯一索引吗,mysql – 如何在sequelize中定义多列上的唯一索引

如何在sequelize中的列组合上定义唯一索引.例如,我想在user_id,count和name上添加唯一索引.

var Tag = sequelize.define('Tag', {

id: {

type: DataTypes.INTEGER(11),

allowNull: false,

primaryKey: true,

autoIncrement: true

},

user_id: {

type: DataTypes.INTEGER(11),

allowNull: false,

},

count: {

type: DataTypes.INTEGER(11),

allowNull: true

},

name: {

type: DataTypes.STRING,

allowNull: true,

})

解决方法:

您将需要更改您的定义,如下所示并呼叫同步

var Tag = sequelize.define('Tag', {

id: {

type: DataTypes.INTEGER(11),

allowNull: false,

primaryKey: true,

autoIncrement: true

},

user_id: {

type: DataTypes.INTEGER(11),

allowNull: false,

},

count: {

type: DataTypes.INTEGER(11),

allowNull: true

},

name: {

type: DataTypes.STRING,

allowNull: true,

}

},

{

indexes: [

{

unique: true,

fields: ['user_id', 'count', 'name']

}

]

})

标签：sequelize-js,mysql

来源： https://codeday.me/bug/20190930/1836121.html