2.7.0 phase changesrelease/2.7.0

10 files changed, 32 insertions, 17 deletions

diff --git a/models/asset.js b/models/asset.js
index ae939a0..1f51ef6 100644
--- a/models/asset.js
+++ b/models/asset.js
@@ -14,7 +14,7 @@ module.exports = function(sequelize, DataTypes) {
       unique: true
     },
     shard_id: {
-      type: DataTypes.STRING(5),
+      type: DataTypes.STRING(191),
       allowNull: false
     },
     match_api_id: {
diff --git a/models/event.js b/models/event.js
index beed589..daa9c58 100644
--- a/models/event.js
+++ b/models/event.js
@@ -12,7 +12,7 @@ module.exports = function(sequelize, DataTypes) {
       type: DataTypes.STRING(191),
       allowNull: true
     },
-    group_id: {
+    division_id: {
       type: DataTypes.INTEGER(11),
       allowNull: false
     },
@@ -22,7 +22,7 @@ module.exports = function(sequelize, DataTypes) {
     },
     team_1_id: {
       type: DataTypes.INTEGER(11),
-      allowNull: false
+      allowNull: true
     },
     team_1_score: {
       type: DataTypes.INTEGER(11),
@@ -30,7 +30,7 @@ module.exports = function(sequelize, DataTypes) {
     },
     team_2_id: {
       type: DataTypes.INTEGER(11),
-      allowNull: false
+      allowNull: true
     },
     team_2_score: {
       type: DataTypes.INTEGER(11),
diff --git a/models/game_mode.js b/models/game_mode.js
index 5eb1a91..06ec06d 100644
--- a/models/game_mode.js
+++ b/models/game_mode.js
@@ -9,7 +9,7 @@ module.exports = function(sequelize, DataTypes) {
       autoIncrement: true
     },
     name: {
-      type: DataTypes.STRING(16),
+      type: DataTypes.STRING(25),
       allowNull: false,
       unique: true
     }
diff --git a/models/match.js b/models/match.js
index f36aa7b..4faf015 100644
--- a/models/match.js
+++ b/models/match.js
@@ -9,7 +9,7 @@ module.exports = function(sequelize, DataTypes) {
       autoIncrement: true
     },
     shard_id: {
-      type: DataTypes.STRING(5),
+      type: DataTypes.STRING(191),
       allowNull: false
     },
     api_id: {
@@ -19,7 +19,7 @@ module.exports = function(sequelize, DataTypes) {
     },
     created_at: {
       type: DataTypes.TIME,
-      allowNull: true
+      allowNull: false
     },
     duration: {
       type: DataTypes.INTEGER(5).UNSIGNED,
diff --git a/models/participant.js b/models/participant.js
index 8faeaaf..d7fc638 100644
--- a/models/participant.js
+++ b/models/participant.js
@@ -9,7 +9,7 @@ module.exports = function(sequelize, DataTypes) {
       autoIncrement: true
     },
     shard_id: {
-      type: DataTypes.STRING(5),
+      type: DataTypes.STRING(191),
       allowNull: false
     },
     api_id: {
@@ -96,6 +96,10 @@ module.exports = function(sequelize, DataTypes) {
     trueskill_delta: {
       type: "DOUBLE",
       allowNull: true
+    },
+    nacl_score: {
+      type: "DOUBLE",
+      allowNull: true
     }
   }, {
     tableName: 'participant',
diff --git a/models/participant_phases.js b/models/participant_phases.js
index c380de3..4d45e02 100644
--- a/models/participant_phases.js
+++ b/models/participant_phases.js
@@ -271,6 +271,18 @@ module.exports = function(sequelize, DataTypes) {
     player_damage: {
       type: DataTypes.STRING(191),
       allowNull: true
+    },
+    draft_position: {
+      type: DataTypes.INTEGER(11),
+      allowNull: true
+    },
+    ban: {
+      type: DataTypes.INTEGER(11),
+      allowNull: true
+    },
+    pick: {
+      type: DataTypes.INTEGER(11),
+      allowNull: true
     }
   }, {
     tableName: 'participant_phases',
diff --git a/models/participant_stats.js b/models/participant_stats.js
index fcc0870..004deb1 100644
--- a/models/participant_stats.js
+++ b/models/participant_stats.js
@@ -183,6 +183,10 @@ module.exports = function(sequelize, DataTypes) {
     duration: {
       type: DataTypes.INTEGER(5).UNSIGNED,
       allowNull: false
+    },
+    nacl_score: {
+      type: "DOUBLE",
+      allowNull: true
     }
   }, {
     tableName: 'participant_stats',
diff --git a/models/player.js b/models/player.js
index ba20381..6e47161 100644
--- a/models/player.js
+++ b/models/player.js
@@ -9,7 +9,7 @@ module.exports = function(sequelize, DataTypes) {
       autoIncrement: true
     },
     shard_id: {
-      type: DataTypes.STRING(5),
+      type: DataTypes.STRING(191),
       allowNull: false
     },
     api_id: {
@@ -19,8 +19,7 @@ module.exports = function(sequelize, DataTypes) {
     },
     name: {
       type: DataTypes.STRING(191),
-      allowNull: false,
-      defaultValue: ""
+      allowNull: false
     },
     last_match_created_date: {
       type: DataTypes.TIME,
diff --git a/models/roster.js b/models/roster.js
index ef5747b..d4b34e0 100644
--- a/models/roster.js
+++ b/models/roster.js
@@ -9,7 +9,7 @@ module.exports = function(sequelize, DataTypes) {
       autoIncrement: true
     },
     shard_id: {
-      type: DataTypes.STRING(5),
+      type: DataTypes.STRING(191),
       allowNull: false
     },
     api_id: {
@@ -52,10 +52,6 @@ module.exports = function(sequelize, DataTypes) {
     winner: {
       type: DataTypes.INTEGER(1),
       allowNull: false
-    },
-    bans: {
-      type: DataTypes.STRING(191),
-      allowNull: true
     }
   }, {
     tableName: 'roster',
diff --git a/models/team.js b/models/team.js
index c9a7880..c0830b8 100644
--- a/models/team.js
+++ b/models/team.js
@@ -9,7 +9,7 @@ module.exports = function(sequelize, DataTypes) {
       autoIncrement: true
     },
     shard_id: {
-      type: DataTypes.STRING(5),
+      type: DataTypes.STRING(191),
       allowNull: true
     },
     api_id: {