* **Query**

I'm working on a messages tracking discord bot using **typescript** with **discord.js**. I've provided my code below. The issue here, is that it doesn't save the data. When a user sends messages, it stores his message count, but when another user sends messages in the same channel, the database stores his messages, and makes the first user's count as `0`.

* **Code**

```
// user-Schema.ts
import type { SapphireClient } from '@sapphire/framework';
import type { ModelStatic, Model } from 'sequelize';
import Sequelize from 'sequelize';

interface UserAttributes {
    guild: string;
    user: string;
    msgs: number;
}

interface UserInstance extends Model<UserAttributes, UserAttributes>, UserAttributes {}

export class UserModel {
    client: SapphireClient;
    raw!: ModelStatic<UserInstance>;

    constructor(client: SapphireClient) {
        this.client = client;
    }

    async init() {
        const db = this.client.sql.define<UserInstance>('electra.users', {
            guild: {
                type: Sequelize.STRING,
                primaryKey: true,
                unique: true
            },
            user: {
                type: Sequelize.STRING,
                primaryKey: true
            },
            msgs: {
                type: Sequelize.INTEGER
            }
        });
        this.raw = db;
        await this.raw.sync();
        this.client.logger.info(`Synced UserModel`);
    }
}

```

```
// messageCreate.ts
const data = await this.container.client.userDB.raw.findOne({
            where: {
                guild: msg.guildId,
                user: msg.author.id
            }
        });

const msgs = data === null ? 0 : data.msgs;

await this.container.client.userDB.raw.upsert({
    guild: msg.guildId as string,
    user: msg.author.id,
    msgs: msgs + 1
});

```

```
// index.ts
import { UserModel } from './models/user-Schema';
const sequelize = new sql.Sequelize(process.env.DB_NAME!, process.env.DB_USER!, process.env.DB_PASS!, {
    logging: false,
    dialect: 'mysql'
});

client.sql = sequelize;
client.userDB = new UserModel(client);

```

```
// ready.ts
await this.container.client.userDB.init()

```

* **Info**

I'm using [@sapphire/framework](https://github.com/sapphiredev/framework) as my bot's framework. I'd be happy for any sort of help, and I'm ready to provide more information if asked.

Thanks.