/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 votes207 views1 answer
Conda install sqlalchemy
SQL
17 votes200 views6 answers
Sql select distinct
SQL
0 vote207 views1 answer
Check if string is a number sql
SQL
0 vote202 views3 answers
Get free card roblox
SQL
0 vote189 views1 answer
How to concatenate text from multiple rows into a single text string in SQL Server
SQL
2 votes211 views1 answer
Get hour from date sql
SQL
6 votes216 views4 answers
Mysql update set
SQL
6 votes191 views2 answers
How to copy data in sql
SQL
0 vote202 views1 answer
ORA-13717
SQL
1 vote249 views1 answer
Does insert into overwrite sql
SQL