/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 votes126 views2 answers
MySQL query to get column names
SQL
0 vote121 views1 answer
One table with another
SQL
0 vote134 views1 answer
Cartesian product sql
SQL
0 vote154 views1 answer
ALV GRID events
SQL
0 vote106 views1 answer
Mysql jdbc timezone
SQL
36 votes176 views6 answers
Change column data type sql
SQL
0 vote141 views1 answer
Sql date with year
SQL
0 vote132 views1 answer
Spring Flyway Teams Edition or MySQL upgrade required: MySQL 5.5 is no longer supported by Flyway Community Edition, but still supported by Flyway Teams Edition.
SQL
6 votes129 views4 answers
Mysql group by date
SQL
3 votes110 views1 answer
Oracle revoke
SQL