From 55eacbdff9003723a747715e4c75f8f743c5d2bd Mon Sep 17 00:00:00 2001 From: schneefux Date: Sat, 1 Apr 2017 12:06:49 +0200 Subject: patch _exts to allow nulls, add autoincrements where needed --- models/player_ext.js | 22 ++++++++++++---------- 1 file changed, 12 insertions(+), 10 deletions(-) (limited to 'models/player_ext.js') 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