reimport

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