summaryrefslogtreecommitdiff
path: root/models
diff options
context:
space:
mode:
Diffstat (limited to 'models')
-rw-r--r--models/player.js2
-rw-r--r--models/player_ext.js22
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',