summaryrefslogtreecommitdiff
path: root/models
diff options
context:
space:
mode:
Diffstat (limited to 'models')
-rw-r--r--models/event.js4
-rw-r--r--models/global_point.js2
-rw-r--r--models/global_point_hero_vs_hero.js2
-rw-r--r--models/global_point_phase.js32
-rw-r--r--models/participant.js8
-rw-r--r--models/participant_items.js12
-rw-r--r--models/participant_phases.js32
-rw-r--r--models/player.js16
-rw-r--r--models/player_point.js4
-rw-r--r--models/team.js4
10 files changed, 112 insertions, 4 deletions
diff --git a/models/event.js b/models/event.js
index 7173acc..b651e97 100644
--- a/models/event.js
+++ b/models/event.js
@@ -48,11 +48,11 @@ module.exports = function(sequelize, DataTypes) {
type: DataTypes.INTEGER(11),
allowNull: true
},
- round: {
+ win_points: {
type: DataTypes.INTEGER(11),
allowNull: true
},
- position: {
+ bonus_points: {
type: DataTypes.INTEGER(11),
allowNull: true
}
diff --git a/models/global_point.js b/models/global_point.js
index 4bb5de5..c5eefe3 100644
--- a/models/global_point.js
+++ b/models/global_point.js
@@ -230,7 +230,7 @@ module.exports = function(sequelize, DataTypes) {
},
item_072_use: {
type: DataTypes.BIGINT,
- allowNull: true
+ allowNull: false
}
}, {
tableName: 'global_point',
diff --git a/models/global_point_hero_vs_hero.js b/models/global_point_hero_vs_hero.js
index 34ebbff..bb84307 100644
--- a/models/global_point_hero_vs_hero.js
+++ b/models/global_point_hero_vs_hero.js
@@ -230,7 +230,7 @@ module.exports = function(sequelize, DataTypes) {
},
item_072_use: {
type: DataTypes.BIGINT,
- allowNull: true
+ allowNull: false
}
}, {
tableName: 'global_point_hero_vs_hero',
diff --git a/models/global_point_phase.js b/models/global_point_phase.js
index 952a814..baa308d 100644
--- a/models/global_point_phase.js
+++ b/models/global_point_phase.js
@@ -244,6 +244,38 @@ module.exports = function(sequelize, DataTypes) {
type: DataTypes.BIGINT,
allowNull: false
},
+ heal_heal_hero: {
+ type: "DOUBLE",
+ allowNull: true
+ },
+ heal_healed_hero: {
+ type: "DOUBLE",
+ allowNull: true
+ },
+ heal_heal_other: {
+ type: "DOUBLE",
+ allowNull: true
+ },
+ heal_healed_other: {
+ type: "DOUBLE",
+ allowNull: true
+ },
+ heal_rcvd_heal_hero: {
+ type: "DOUBLE",
+ allowNull: true
+ },
+ heal_rcvd_healed_hero: {
+ type: "DOUBLE",
+ allowNull: true
+ },
+ heal_rcvd_heal_other: {
+ type: "DOUBLE",
+ allowNull: true
+ },
+ heal_rcvd_healed_other: {
+ type: "DOUBLE",
+ allowNull: true
+ },
item_001_use: {
type: DataTypes.BIGINT,
allowNull: false
diff --git a/models/participant.js b/models/participant.js
index 2f208df..1c46bf4 100644
--- a/models/participant.js
+++ b/models/participant.js
@@ -101,6 +101,14 @@ module.exports = function(sequelize, DataTypes) {
nacl_score: {
type: "DOUBLE",
allowNull: true
+ },
+ trueskill_casual_mu: {
+ type: "DOUBLE",
+ allowNull: true
+ },
+ trueskill_casual_sigma: {
+ type: "DOUBLE",
+ allowNull: true
}
}, {
tableName: 'participant',
diff --git a/models/participant_items.js b/models/participant_items.js
index 061bf5a..b90fc50 100644
--- a/models/participant_items.js
+++ b/models/participant_items.js
@@ -36,6 +36,18 @@ module.exports = function(sequelize, DataTypes) {
surrender: {
type: DataTypes.INTEGER(1),
allowNull: false
+ },
+ trueskill_ranked_mu: {
+ type: "DOUBLE",
+ allowNull: true
+ },
+ trueskill_ranked_sigma: {
+ type: "DOUBLE",
+ allowNull: true
+ },
+ any_afk: {
+ type: DataTypes.INTEGER(3).UNSIGNED,
+ allowNull: true
}
}, {
tableName: 'participant_items',
diff --git a/models/participant_phases.js b/models/participant_phases.js
index 1fe2be2..4ada1db 100644
--- a/models/participant_phases.js
+++ b/models/participant_phases.js
@@ -331,6 +331,38 @@ module.exports = function(sequelize, DataTypes) {
player_damage: {
type: "BLOB",
allowNull: false
+ },
+ heal_heal_hero: {
+ type: "DOUBLE",
+ allowNull: true
+ },
+ heal_healed_hero: {
+ type: "DOUBLE",
+ allowNull: true
+ },
+ heal_heal_other: {
+ type: "DOUBLE",
+ allowNull: true
+ },
+ heal_healed_other: {
+ type: "DOUBLE",
+ allowNull: true
+ },
+ heal_rcvd_heal_hero: {
+ type: "DOUBLE",
+ allowNull: true
+ },
+ heal_rcvd_healed_hero: {
+ type: "DOUBLE",
+ allowNull: true
+ },
+ heal_rcvd_heal_other: {
+ type: "DOUBLE",
+ allowNull: true
+ },
+ heal_rcvd_healed_other: {
+ type: "DOUBLE",
+ allowNull: true
}
}, {
tableName: 'participant_phases',
diff --git a/models/player.js b/models/player.js
index 6e47161..9441953 100644
--- a/models/player.js
+++ b/models/player.js
@@ -60,6 +60,22 @@ module.exports = function(sequelize, DataTypes) {
elo: {
type: "DOUBLE",
allowNull: true
+ },
+ trueskill_casual_mu: {
+ type: "DOUBLE",
+ allowNull: true
+ },
+ trueskill_casual_sigma: {
+ type: "DOUBLE",
+ allowNull: true
+ },
+ trueskill_ranked_mu: {
+ type: "DOUBLE",
+ allowNull: true
+ },
+ trueskill_ranked_sigma: {
+ type: "DOUBLE",
+ allowNull: true
}
}, {
tableName: 'player',
diff --git a/models/player_point.js b/models/player_point.js
index 229d00a..f7b474e 100644
--- a/models/player_point.js
+++ b/models/player_point.js
@@ -52,6 +52,10 @@ module.exports = function(sequelize, DataTypes) {
type: "DOUBLE",
allowNull: true
},
+ trueskill_ranked_max: {
+ type: "DOUBLE",
+ allowNull: true
+ },
trueskill_delta: {
type: "DOUBLE",
allowNull: true
diff --git a/models/team.js b/models/team.js
index eab927f..89eec80 100644
--- a/models/team.js
+++ b/models/team.js
@@ -21,6 +21,10 @@ module.exports = function(sequelize, DataTypes) {
allowNull: false,
defaultValue: sequelize.literal('CURRENT_TIMESTAMP')
},
+ league_id: {
+ type: DataTypes.BIGINT,
+ allowNull: true
+ },
name: {
type: DataTypes.STRING(20),
allowNull: false