From 37c16ecf9fd64fc7644e82d8619584d0f64d694e Mon Sep 17 00:00:00 2001
From: Kapil Viren Ahuja <k.v.ahuja@gmail.com>
Date: Thu, 30 Mar 2017 21:34:58 +0530
Subject: Pushed shard_id to all the tables as shard + api_id is the unique
 combination

---
 models/participant.js | 4 ++++
 models/player.js      | 2 +-
 models/roster.js      | 4 ++++
 3 files changed, 9 insertions(+), 1 deletion(-)

(limited to 'models')

diff --git a/models/participant.js b/models/participant.js
index efcb7dd..d48874b 100644
--- a/models/participant.js
+++ b/models/participant.js
@@ -13,6 +13,10 @@ module.exports = function(sequelize, DataTypes) {
       allowNull: false,
       unique: true
     },
+    shard_id: {
+      type: DataTypes.STRING(191),
+      allowNull: false
+    },
     player_api_id: {
       type: DataTypes.STRING(191),
       allowNull: false
diff --git a/models/player.js b/models/player.js
index 4f24f56..af56432 100644
--- a/models/player.js
+++ b/models/player.js
@@ -23,7 +23,7 @@ module.exports = function(sequelize, DataTypes) {
     },
     shard_id: {
       type: DataTypes.STRING(191),
-      allowNull: true
+      allowNull: false
     },
     last_match_created_date: {
       type: DataTypes.TIME,
diff --git a/models/roster.js b/models/roster.js
index 5966e3a..f196f0f 100644
--- a/models/roster.js
+++ b/models/roster.js
@@ -17,6 +17,10 @@ module.exports = function(sequelize, DataTypes) {
       allowNull: false,
       unique: true
     },
+    shard_id: {
+      type: DataTypes.STRING(191),
+      allowNull: false
+    },
     aces_earned: {
       type: DataTypes.INTEGER(11),
       allowNull: false
-- 
cgit v1.3.1