Duplicate Foreign Key Constraint Name

[lrojas94]

So, I've created two tables which reference the same one (say, address and a user has an address and company too). This makes me run into this problem:

Constraint created by sequelize: addressId_foreign_idx

Results: Both tables will try to use the same constraint name, which, as you might expect, results in:

code: 'ER_DUP_KEY',
errno: 1022,
sqlState: '23000',

[felixfbecker]

Are you configuring foreignKey or alias? Need to see more code

[lrojas94]

This is what I'm doing:

return queryInterface.addColumn(
        "companies",
        "addressId",
        {
          type: Sequelize.INTEGER,
          references: {
            model: "addresses",
            key: "id"
          },
          onDelete: "SET NULL"
        })
      .then(() => {
        return queryInterface.addColumn(
          "residentialCustomers",
          "addressId",
          {
            type: Sequelize.INTEGER,
            references: {
              model: "addresses",
              key: "id"
            },
            onDelete: "SET NULL"
          })
      });

As you can see, both use addressId. but I get that the foreign key created is the same.

[zontafil]

same problem

[PaulBehrendtVentoro]

+1

[edu791]

Is there any solution?
I've wasted all the day trying to figure out this same problem

[sushantdhiman]

You can now use addConstraint like methods to properly name them http://docs.sequelizejs.com/class/lib/query-interface.js~QueryInterface.html#instance-method-addConstraint