/SQL/Adding indexing on a db model in mysql using sequelize

Adding indexing on a db model in mysql using sequelize

module.exports = (sequelize, DataTypes) => {
    const Item = sequelize.define('Item', {
        itemId:  DataTypes.STRING,
        ownerId:  DataTypes.INTEGER,
        status: DataTypes.STRING,
        type: DataTypes.STRING,
        nature: DataTypes.STRING,
        content: DataTypes.STRING,
        moment: DataTypes.BIGINT
    },
    {
      indexes:[
       {
         unique: false,
         fields:['ownerId']
       }
      ]
    });

    return Item;
};

Similar codes

3 votes118 views1 answer
MySQL DELETE JOIN
SQL
1 vote143 views2 answers
Insert sqlite
SQL
0 vote135 views1 answer
Nvl2 syntax
SQL
0 vote148 views1 answer
Delete a record from a table sqlite3
SQL
10 votes147 views2 answers
What is database
SQL
6 votes140 views2 answers
Drop foreign key
SQL
0 vote149 views1 answer
Str_to_date sql server
SQL
2 votes150 views1 answer
Mysql select true or false
SQL
1 vote135 views1 answer
Postgres concat_ws
SQL
0 vote130 views2 answers
Pop sql insert value into
SQL