initialAutoIncrement for ALTER TABLE queries

[hemanth-kumarv]

Issue Creation Checklist

• I understand that my issue will be automatically closed if I don't fill in the requested information
• I have read the contribution guidelines

Bug Description

initialAutoIncrement is not updated when table exists and SQL ALTER command is executed upon sync

Reproducible Example

module.exports = (sequelize, DataTypes) => {
  const User = sequelize.define(
    'User',
    {
      id: {
        type: DataTypes.BIGINT(20),
        primaryKey: true,
        autoIncrement: true,
      },
      name: {
        type: DataTypes.STRING(500),
        allowNull: false,
      },
    },
    {
      initialAutoIncrement: 1000,
    }
  );

  return User;
};

What do you expect to happen?

Upon executing sync(), AUTO_INCREMENT=1000 needs to be executed in ALTER TABLE command

What is actually happening?

AUTO_INCREMENT=1000 is not executed in ALTER TABLE command

Environment

• Sequelize version: 6.26.0
• Node.js version: 16.17.0
• If TypeScript related: TypeScript version:
• Database & Version: 8.0.26
• Connector library & Version: mysql2@2.3.3

Would you be willing to resolve this issue by submitting a Pull Request?

• Yes, I have the time and I know how to start.
• Yes, I have the time but I will need guidance.
• No, I don't have the time, but my company or I are supporting Sequelize through donations on OpenCollective.
• No, I don't have the time, and I understand that I will need to wait until someone from the community or maintainers is interested in resolving my issue.

---

Indicate your interest in the resolution of this issue by adding the 👍 reaction. Comments such as "+1" will be removed.

[WikiRik]

@ephys I think it might be good to include this after #14687, do you agree?

[ephys]

We need to check whether it's possible to know which value AUTO_INCREMENT was set to, or sync will eventually crash (app starts & updates AUTO_INCREMENT, app inserts a value, app restarts and sets AUTO_INCREMENT to a value lower than what one of the existing values in the table, which is not allowed and crashes)