import model changes

6 files changed, 15 insertions, 8 deletions

diff --git a/model.js b/model.js
index 11a638f..94d351f 100644
--- a/model.js
+++ b/model.js
@@ -36,7 +36,6 @@ module.exports = (seq, Seq) => {
     Participant.belongsTo(Hero, { foreignKey: "hero_id" });
     Participant.belongsTo(Series, { foreignKey: "series_id" });
     Participant.belongsTo(Role, { foreignKey: "role_id" });
-    Participant.belongsTo(Filter, { foreignKey: "filter_id" });
     ParticipantStats.belongsTo(Participant, { foreignKey: "participant_api_id", "targetKey": "api_id" });
     ItemParticipant.belongsTo(Item, { foreignKey: "item_id", targetKey: "id" });
 
diff --git a/models/filter.js b/models/filter.js
index fc340d0..1ffcc8a 100644
--- a/models/filter.js
+++ b/models/filter.js
@@ -12,7 +12,7 @@ module.exports = function(sequelize, DataTypes) {
       type: DataTypes.STRING(191),
       allowNull: false
     },
-    filter_on: {
+    dimension_on: {
       type: DataTypes.STRING(191),
       allowNull: false
     },
diff --git a/models/participant.js b/models/participant.js
index f0f984d..22381fc 100644
--- a/models/participant.js
+++ b/models/participant.js
@@ -25,6 +25,10 @@ module.exports = function(sequelize, DataTypes) {
       type: DataTypes.CHAR(36),
       allowNull: false
     },
+    match_api_id: {
+      type: DataTypes.CHAR(36),
+      allowNull: false
+    },
     hero_id: {
       type: DataTypes.INTEGER(10).UNSIGNED,
       allowNull: false
@@ -41,6 +45,10 @@ module.exports = function(sequelize, DataTypes) {
       type: DataTypes.INTEGER(10).UNSIGNED,
       allowNull: false
     },
+    filter_id: {
+      type: DataTypes.INTEGER(10).UNSIGNED,
+      allowNull: false
+    },
     created_at: {
       type: DataTypes.TIME,
       allowNull: false
@@ -66,7 +74,7 @@ module.exports = function(sequelize, DataTypes) {
       allowNull: false
     },
     skill_tier: {
-      type: DataTypes.INTEGER(5).UNSIGNED,
+      type: DataTypes.INTEGER(6),
       allowNull: false
     },
     skin_key: {
diff --git a/models/player.js b/models/player.js
index 6a8dda2..3bdab2e 100644
--- a/models/player.js
+++ b/models/player.js
@@ -42,7 +42,7 @@ module.exports = function(sequelize, DataTypes) {
       allowNull: false
     },
     skill_tier: {
-      type: DataTypes.INTEGER(5).UNSIGNED,
+      type: DataTypes.INTEGER(6),
       allowNull: true
     }
   }, {
diff --git a/models/player_point.js b/models/player_point.js
index 84d9621..31cb085 100644
--- a/models/player_point.js
+++ b/models/player_point.js
@@ -8,10 +8,6 @@ module.exports = function(sequelize, DataTypes) {
       primaryKey: true,
       autoIncrement: true
     },
-    shard_id: {
-      type: DataTypes.STRING(5),
-      allowNull: true
-    },
     player_id: {
       type: DataTypes.BIGINT,
       allowNull: false
diff --git a/models/series.js b/models/series.js
index c5be4b9..73ea5c1 100644
--- a/models/series.js
+++ b/models/series.js
@@ -12,6 +12,10 @@ module.exports = function(sequelize, DataTypes) {
       type: DataTypes.STRING(191),
       allowNull: false
     },
+    dimension_on: {
+      type: DataTypes.STRING(191),
+      allowNull: false
+    },
     start: {
       type: DataTypes.TIME,
       allowNull: true