From 55eacbdff9003723a747715e4c75f8f743c5d2bd Mon Sep 17 00:00:00 2001
From: schneefux <schneefux+commit@schneefux.xyz>
Date: Sat, 1 Apr 2017 12:06:49 +0200
Subject: patch _exts to allow nulls, add autoincrements where needed

---
 models/player.js     |  2 +-
 models/player_ext.js | 22 ++++++++++++----------
 2 files changed, 13 insertions(+), 11 deletions(-)

diff --git a/models/player.js b/models/player.js
index 827e9fc..a0583dc 100644
--- a/models/player.js
+++ b/models/player.js
@@ -10,7 +10,7 @@ module.exports = function(sequelize, DataTypes) {
     },
     shard_id: {
       type: DataTypes.STRING(191),
-      allowNull: true
+      allowNull: false
     },
     api_id: {
       type: DataTypes.STRING(191),
diff --git a/models/player_ext.js b/models/player_ext.js
index 183faf9..f31b790 100644
--- a/models/player_ext.js
+++ b/models/player_ext.js
@@ -4,7 +4,9 @@ module.exports = function(sequelize, DataTypes) {
   return sequelize.define('player_ext', {
     id: {
       type: DataTypes.INTEGER(11),
-      allowNull: false
+      allowNull: false,
+      primaryKey: true,
+      autoIncrement: true
     },
     player_api_id: {
       type: DataTypes.STRING(191),
@@ -13,35 +15,35 @@ module.exports = function(sequelize, DataTypes) {
     },
     played: {
       type: DataTypes.INTEGER(11),
-      allowNull: false
+       allowNull: true
     },
     played_ranked: {
       type: DataTypes.INTEGER(11),
-      allowNull: false
+       allowNull: true
     },
     played_casual: {
       type: DataTypes.INTEGER(11),
-      allowNull: false
+       allowNull: true
     },
     played_brawl: {
       type: DataTypes.INTEGER(11),
-      allowNull: false
+       allowNull: true
     },
     wins: {
       type: DataTypes.INTEGER(11),
-      allowNull: false
+       allowNull: true
     },
     wins_ranked: {
       type: DataTypes.INTEGER(11),
-      allowNull: false
+       allowNull: true
     },
     wins_casual: {
       type: DataTypes.INTEGER(11),
-      allowNull: false
+       allowNull: true
     },
     wins_brawl: {
       type: DataTypes.INTEGER(11),
-      allowNull: false
+       allowNull: true
     },
     skill_tier: {
       type: DataTypes.STRING(191),
@@ -49,7 +51,7 @@ module.exports = function(sequelize, DataTypes) {
     },
     streak: {
       type: DataTypes.STRING(191),
-      allowNull: false
+      allowNull: true
     }
   }, {
     tableName: 'player_ext',
-- 
cgit v1.3.1