Self-reference FK's never created

[tanepiper]

When creating a model that has a parent/child relationshop, the FK is never created.

An example is my Role model:

exports.getRoleModel = function(Sequelize, sequelize) {
sequelize.define('Role', {
name : Sequelize.STRING,
priority : Sequelize.INTEGER
});

Role.hasMany('children', Role);
Role.belongsTo('parent', Role);

A FK for the parentId is never created.

[assertchris]

I think this is related to the relation key name ticket you already have open...

[tanepiper]

I thought it may have been, but as I wasn't sure I opened this one too. Hopefully something can be done about it, at the moment I'm having to use node-mysql to do custom stuff, but would like to use sequelize exclusively if I can

[assertchris]

My guess is that it created the PK roleId and then when the time comes to creating the FK (which according to your previous ticket would be roleId) it skips it assuming it is already present...

[sdepold]

please try the example again and let me know if it works with the latest repo version :)

[tanepiper]

The way for doing associations is vastly improved, they are working very well for me now - much prefer this new syntax