/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

4 votes257 views1 answer
An error occurred while installing pg (1.2.3), and Bundler cannot continue. Make sure that `gem install pg -v '1.2.3' --source 'https://rubygems.org/'` succeeds before bundling.
SQL
3 votes236 views1 answer
Apex set debug level
SQL
0 vote250 views1 answer
Find how many tables in database sql query
SQL
-1 vote245 views4 answers
Restart mysql server ubuntu
SQL
0 vote241 views2 answers
Sql query for getting details by id
SQL
11 votes248 views4 answers
Update row in mysql
SQL
0 vote237 views1 answer
ORACLE PARSE STRING
SQL
0 vote252 views1 answer
Create table with primary key and foreign key in sql server
SQL
1 vote239 views1 answer
Sql query row number group by
SQL
0 vote233 views1 answer
Cast float mysql
SQL