1 files changed, 34 insertions, 37 deletions
diff --git a/models/participant.js b/models/participant.js
index 5779585..050d1af 100644
--- a/models/participant.js
+++ b/models/participant.js
@@ -9,104 +9,101 @@ module.exports = function(sequelize, DataTypes) {
       autoIncrement: true
     },
     shard_id: {
-      type: DataTypes.STRING(191),
+      type: DataTypes.STRING(5),
       allowNull: false
     },
     api_id: {
-      type: DataTypes.STRING(191),
+      type: DataTypes.CHAR(36),
       allowNull: false,
       unique: true
     },
     player_api_id: {
-      type: DataTypes.STRING(191),
+      type: DataTypes.CHAR(36),
       allowNull: false
     },
     roster_api_id: {
-      type: DataTypes.STRING(191),
+      type: DataTypes.CHAR(36),
       allowNull: false
     },
     hero_id: {
-      type: DataTypes.STRING(191),
+      type: DataTypes.INTEGER(10).UNSIGNED,
       allowNull: false
     },
     created_at: {
       type: DataTypes.TIME,
-      allowNull: true
-    },
-    series: {
-      type: DataTypes.TIME,
-      allowNull: true
+      allowNull: false,
+      defaultValue: sequelize.fn('NOW')
     },
     actor: {
-      type: DataTypes.STRING(191),
+      type: DataTypes.STRING(16),
       allowNull: false
     },
-    assists: {
-      type: DataTypes.INTEGER(11),
-      allowNull: false
-    },
-    crystal_mine_captures: {
-      type: DataTypes.INTEGER(11),
+    kills: {
+      type: DataTypes.INTEGER(5).UNSIGNED,
       allowNull: false
     },
     deaths: {
-      type: DataTypes.INTEGER(11),
+      type: DataTypes.INTEGER(5).UNSIGNED,
       allowNull: false
     },
-    farm: {
-      type: "DOUBLE",
+    assists: {
+      type: DataTypes.INTEGER(5).UNSIGNED,
       allowNull: false
     },
-    first_afk_time: {
-      type: "DOUBLE",
+    farm: {
+      type: "DOUBLE(6,2)",
       allowNull: false
     },
     gold: {
-      type: DataTypes.INTEGER(11),
+      type: DataTypes.INTEGER(8).UNSIGNED,
       allowNull: true
     },
+    crystal_mine_captures: {
+      type: DataTypes.INTEGER(5).UNSIGNED,
+      allowNull: false
+    },
+    first_afk_time: {
+      type: "DOUBLE(12,4)",
+      allowNull: false
+    },
     gold_mine_captures: {
-      type: DataTypes.INTEGER(11),
+      type: DataTypes.INTEGER(5).UNSIGNED,
       allowNull: false
     },
     jungle_kills: {
-      type: DataTypes.INTEGER(11),
+      type: DataTypes.INTEGER(5).UNSIGNED,
       allowNull: false
     },
     karma_level: {
-      type: DataTypes.INTEGER(11),
-      allowNull: false
-    },
-    kills: {
-      type: DataTypes.INTEGER(11),
+      type: DataTypes.INTEGER(3).UNSIGNED,
       allowNull: false
     },
     kraken_captures: {
-      type: DataTypes.INTEGER(11),
+      type: DataTypes.INTEGER(5).UNSIGNED,
       allowNull: false
     },
     level: {
-      type: DataTypes.INTEGER(11),
+      type: DataTypes.INTEGER(3).UNSIGNED,
       allowNull: false
     },
     minion_kills: {
-      type: DataTypes.INTEGER(11),
+      type: DataTypes.INTEGER(5).UNSIGNED,
       allowNull: false
     },
     non_jungle_minion_kills: {
-      type: DataTypes.INTEGER(11),
+      type: DataTypes.INTEGER(5).UNSIGNED,
       allowNull: false
     },
     skill_tier: {
-      type: DataTypes.INTEGER(11),
+      type: DataTypes.INTEGER(5).UNSIGNED,
       allowNull: false
     },
     skin_key: {
-      type: DataTypes.STRING(191),
+      type: DataTypes.STRING(40),
       allowNull: false
     },
     turret_captures: {
-      type: DataTypes.INTEGER(11),
+      type: DataTypes.INTEGER(5).UNSIGNED,
       allowNull: false
     },
     went_afk: {