reimport

3 files changed, 59 insertions, 35 deletions

diff --git a/models/participant_items.js b/models/participant_items.js
index b90fc50..7ea4a9f 100644
--- a/models/participant_items.js
+++ b/models/participant_items.js
@@ -48,6 +48,30 @@ module.exports = function(sequelize, DataTypes) {
     any_afk: {
       type: DataTypes.INTEGER(3).UNSIGNED,
       allowNull: true
+    },
+    trueskill_casual_mu: {
+      type: "DOUBLE",
+      allowNull: true
+    },
+    trueskill_casual_sigma: {
+      type: "DOUBLE",
+      allowNull: true
+    },
+    trueskill_blitz_mu: {
+      type: "DOUBLE",
+      allowNull: true
+    },
+    trueskill_blitz_sigma: {
+      type: "DOUBLE",
+      allowNull: true
+    },
+    trueskill_br_mu: {
+      type: "DOUBLE",
+      allowNull: true
+    },
+    trueskill_br_sigma: {
+      type: "DOUBLE",
+      allowNull: true
     }
   }, {
     tableName: 'participant_items',
diff --git a/models/player.js b/models/player.js
index ebfba5b..4a33acb 100644
--- a/models/player.js
+++ b/models/player.js
@@ -61,6 +61,26 @@ module.exports = function(sequelize, DataTypes) {
       type: "DOUBLE",
       allowNull: true
     },
+    played_ranked: {
+      type: DataTypes.INTEGER(11),
+      allowNull: true
+    },
+    played_casual: {
+      type: DataTypes.INTEGER(11),
+      allowNull: true
+    },
+    played_blitz: {
+      type: DataTypes.INTEGER(11),
+      allowNull: true
+    },
+    played_aral: {
+      type: DataTypes.INTEGER(11),
+      allowNull: true
+    },
+    guild_tag: {
+      type: DataTypes.STRING(191),
+      allowNull: true
+    },
     rank_points_ranked: {
       type: "DOUBLE",
       allowNull: true
@@ -69,28 +89,32 @@ module.exports = function(sequelize, DataTypes) {
       type: "DOUBLE",
       allowNull: true
     },
-    played_ranked: {
+    played_blitz_rounds: {
       type: DataTypes.INTEGER(11),
       allowNull: true
     },
-    played_casual: {
-      type: DataTypes.INTEGER(11),
+    trueskill_casual_mu: {
+      type: "DOUBLE",
       allowNull: true
     },
-    played_blitz: {
-      type: DataTypes.INTEGER(11),
+    trueskill_casual_sigma: {
+      type: "DOUBLE",
       allowNull: true
     },
-    played_blitz_rounds: {
-      type: DataTypes.INTEGER(11),
+    trueskill_blitz_mu: {
+      type: "DOUBLE",
       allowNull: true
     },
-    played_aral: {
-      type: DataTypes.INTEGER(11),
+    trueskill_blitz_sigma: {
+      type: "DOUBLE",
       allowNull: true
     },
-    guild_tag: {
-      type: DataTypes.STRING(191),
+    trueskill_br_mu: {
+      type: "DOUBLE",
+      allowNull: true
+    },
+    trueskill_br_sigma: {
+      type: "DOUBLE",
       allowNull: true
     }
   }, {
diff --git a/models/player_point.js b/models/player_point.js
index 84b443b..3b7c363 100644
--- a/models/player_point.js
+++ b/models/player_point.js
@@ -48,30 +48,6 @@ module.exports = function(sequelize, DataTypes) {
       type: DataTypes.BIGINT,
       allowNull: false
     },
-    trueskill_max: {
-      type: "DOUBLE",
-      allowNull: true
-    },
-    trueskill_ranked_max: {
-      type: "DOUBLE",
-      allowNull: true
-    },
-    trueskill_delta: {
-      type: "DOUBLE",
-      allowNull: true
-    },
-    trueskill_mu: {
-      type: "DOUBLE",
-      allowNull: true
-    },
-    trueskill_sigma: {
-      type: "DOUBLE",
-      allowNull: true
-    },
-    elo: {
-      type: "DOUBLE",
-      allowNull: true
-    },
     kills: {
       type: DataTypes.INTEGER(10).UNSIGNED,
       allowNull: true