title: SEQUELIZE not auto incrementing id with inserting a row?
body: <p><strong>issue:</strong> currently I can insert a row in the database table using SEQUELIZE and node api post method.</p>
  
  <p>However, if I try sending a new project object using postman, the program just updates the first row with id 1!</p>
  
  <p>API.js</p>
  
  <pre><code>router.post("/project", async (req, res, next) =&gt; {
  
    if (req.body) {
      // validate req.body then...
  
      const project = await ProjectService.saveProject(req.body);
  
      res.status(200).send(project);
    }
  });
  </code></pre>
  
  <p>ProjectService.js</p>
  
  <pre><code>const { Projects, sequelize } = require("../models/ProjectModel");
  
  class ProjectService {
  
    static async saveProject(project) {
      await sequelize.sync({ force: true }); // creates the Projects row (if doesn't exist in db)
      const projectBuilt = Projects.build({
        CompanyID: project.CompanyID,
        Name: project.Name,
        ContextID: project.ContextID,
        Latitude: project.Latitude,
        Longitude: project.Longitude,
        StateID: project.StateID,
        RegionID: project.RegionID,
        RadiusCovered: project.RadiusCovered,
        SubRegionID: project.SubRegionID,
        CommonWealth: project.CommonWealth
      });
  
      await projectBuilt.save();
      console.log("\n\n Project Saved to database!");
  
      return { project: projectBuilt };
    }
  }
  
  module.exports = ProjectService;
  </code></pre>
  
  <p>ProjectModel.js</p>
  
  <pre><code>// var database = require("./loaders/database"); /* Database depedency */
  
  const { Sequelize, Model, DataTypes } = require("sequelize");
  
  const sequelize = new Sequelize("new_rps", "root", "password", {
    dialect: "mysql",
    dialectOptions: {
      // Your mysql2 options here
    }
  });
  
  const Projects = sequelize.define(
    "Projects",
    {
      CompanyID: DataTypes.INTEGER,
      Name: DataTypes.TEXT,
      ContextID: DataTypes.TEXT,
      Latitude: DataTypes.INTEGER,
      Longitude: DataTypes.INTEGER,
      StateID: DataTypes.INTEGER,
      RegionID: DataTypes.INTEGER,
      RadiusCovered: DataTypes.INTEGER,
      SubRegionID: DataTypes.INTEGER,
      CommonWealth: DataTypes.INTEGER
    },
    {
      tableName: "Projects"
    }
  );
  
  module.exports = {
    Projects,
    sequelize
  };
  </code></pre>
  
  <p><strong>What I want: To add a new row instead of updating the first row with id 1. In the database, I have auto increment on the table too fyi! Any ideas?</strong></p>
  
  <p><strong>UPDATED MODEL</strong> STILL NOT WORKING</p>
  
  <pre><code>const Projects = sequelize.define(
    "Projects",
    {
      ID: {
        type: DataTypes.INTEGER,
        autoIncrement: true,
        primaryKey: true
      },
      CompanyID: DataTypes.INTEGER,
      Name: DataTypes.TEXT,
      ContextID: DataTypes.TEXT,
      Latitude: DataTypes.INTEGER,
      Longitude: DataTypes.INTEGER,
      StateID: DataTypes.INTEGER,
      RegionID: DataTypes.INTEGER,
      RadiusCovered: DataTypes.INTEGER,
      SubRegionID: DataTypes.INTEGER,
      CommonWealth: DataTypes.INTEGER
    },
    {
      tableName: "Projects"
    }
  );
  </code></pre>