From b580deeb6d890e411fd26fc78bef55427e4755c5 Mon Sep 17 00:00:00 2001 From: schneefux Date: Mon, 21 Aug 2017 19:40:03 +0200 Subject: add more associations for phases --- model.js | 3 +++ models/participant_phases.js | 8 ++++++++ 2 files changed, 11 insertions(+) diff --git a/model.js b/model.js index b0bb70d..ee29d4c 100644 --- a/model.js +++ b/model.js @@ -50,8 +50,11 @@ module.exports = (seq, Seq) => { Participant.belongsTo(Match, { foreignKey: "match_api_id", targetKey: "api_id" }); Participant.belongsTo(Player, { foreignKey: "player_api_id", targetKey: "api_id" }); Participant.hasMany(ParticipantStats, { foreignKey: "participant_api_id", sourceKey: "api_id" }); + Participant.hasMany(ParticipantItems, { foreignKey: "participant_api_id", sourceKey: "api_id" }); Participant.hasMany(ParticipantPhases, { foreignKey: "participant_api_id", sourceKey: "api_id" }); ParticipantPhases.belongsTo(Participant, { foreignKey: "participant_api_id", targetKey: "api_id" }); + ParticipantPhases.hasMany(Hero, { foreignKey: "id", sourceKey: "ban", as: "HeroBan" }); + ParticipantPhases.hasMany(Hero, { foreignKey: "id", sourceKey: "pick", as: "HeroPick" }); Participant.belongsTo(GameMode, { foreignKey: "game_mode_id" }); Participant.belongsTo(Hero, { foreignKey: "hero_id" }); Participant.belongsTo(Series, { foreignKey: "series_id" }); diff --git a/models/participant_phases.js b/models/participant_phases.js index 3780b90..1fe2be2 100644 --- a/models/participant_phases.js +++ b/models/participant_phases.js @@ -300,6 +300,14 @@ module.exports = function(sequelize, DataTypes) { type: DataTypes.INTEGER(10).UNSIGNED, allowNull: false }, + ability_perk_damage_true: { + type: DataTypes.INTEGER(10).UNSIGNED, + allowNull: false + }, + ability_perk_damage_dealt: { + type: DataTypes.INTEGER(10).UNSIGNED, + allowNull: false + }, ability_aa_damage_true: { type: DataTypes.INTEGER(10).UNSIGNED, allowNull: false -- cgit v1.3.1