Does not set primary key if column isn't `id`

[sequelize]

Does not set primary key if column isn't `id`

[durango]

@Sawtaytoes any way to copy & paste an sql file for me to replicate? Sorry for missing this issue as well, I didn't see it in my inbox at all.

[Sawtaytoes]

What would you like for a SQL file? The schema? Actual data?

[durango]

Just the schema please

[durango]

Was able to generate primary keys and foreign keys on column names without having the column name set to id:

/* jshint indent: 2 */

module.exports = function(sequelize, DataTypes) {
  return sequelize.define('disreports', {
    ORGANIZATION_ID: {
      type: DataTypes.INTEGER(11),
      allowNull: false,
      primaryKey: true,
      references: {
        model: 'cxm_company',
        key: 'ORGANIZATION_ID'
      }
    },
    COMPANY_ID: {
      type: DataTypes.INTEGER(11),
      allowNull: false,
      primaryKey: true,
      references: {
        model: 'cxm_company',
        key: 'COMPANY_ID'
      }
    },
    REPORT_UNAME: {
      type: DataTypes.STRING,
      allowNull: false,
      primaryKey: true
    },
    PHYSICAL_NAME: {
      type: DataTypes.STRING,
      allowNull: true
    },
    REPORT_MODULE_UNAME: {
      type: DataTypes.STRING,
      allowNull: true
    },
    MODULE_UNAME: {
      type: DataTypes.STRING,
      allowNull: true
    },
    DESCRIPTION: {
      type: DataTypes.STRING,
      allowNull: true
    },
    PATH: {
      type: DataTypes.STRING,
      allowNull: true
    },
    MENU_LOCATION: {
      type: DataTypes.STRING,
      allowNull: true
    },
    MENU_ORDER: {
      type: DataTypes.INTEGER(11),
      allowNull: true,
      defaultValue: '0'
    },
    DISPLAY_NAME: {
      type: DataTypes.STRING,
      allowNull: true
    },
    IS_ENABLED: {
      type: DataTypes.BOOLEAN,
      allowNull: true,
      defaultValue: '1'
    },
    DISPLAY_ICON: {
      type: DataTypes.STRING,
      allowNull: true
    },
    CREATE_USER: {
      type: DataTypes.STRING,
      allowNull: true
    },
    CREATE_DATE: {
      type: DataTypes.DATE,
      allowNull: true
    },
    UPDATE_USER: {
      type: DataTypes.STRING,
      allowNull: true
    },
    UPDATE_DATE: {
      type: DataTypes.DATE,
      allowNull: true
    }
  }, {
    tableName: 'disreports'
  });
};

Closing for now