gistfile1.txt

module.exports = function(sequelize, DataTypes) {
	return sequelize.define('user_roles', {
		id: { type: DataTypes.INTEGER, autoIncrement: true, primaryKey: true },
		userId: { type: DataTypes.INTEGER },
		roleId: { type: DataTypes.INTEGER },
		schoolId: { type: DataTypes.INTEGER },
		councilId: { type: DataTypes.INTEGER },
		classId: { type: DataTypes.INTEGER },
		active: { type: DataTypes.BOOLEAN },
		created: { type: DataTypes.DATE, defaultValue: DataTypes.NOW },
	}, {
		timestamps: false,
		freezeTableName: true,
		classMethods: {
			getUserActiveRole : function(userId, callback) {
				this.find({where: {userId: userId, active: true}}).success(function(activeRole) {
					callback(activeRole);
				})
			}
		}
	})

}