From be4e78d7b769b9798fa7938909e4ee9fbba3977e Mon Sep 17 00:00:00 2001 From: schneefux Date: Fri, 31 Mar 2017 20:51:04 +0200 Subject: move ORM model into seperate repo --- models/player_ext.js | 60 ++++++++++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 60 insertions(+) create mode 100644 models/player_ext.js (limited to 'models/player_ext.js') diff --git a/models/player_ext.js b/models/player_ext.js new file mode 100644 index 0000000..183faf9 --- /dev/null +++ b/models/player_ext.js @@ -0,0 +1,60 @@ +/* jshint indent: 2 */ + +module.exports = function(sequelize, DataTypes) { + return sequelize.define('player_ext', { + id: { + type: DataTypes.INTEGER(11), + allowNull: false + }, + player_api_id: { + type: DataTypes.STRING(191), + allowNull: false, + unique: true + }, + played: { + type: DataTypes.INTEGER(11), + allowNull: false + }, + played_ranked: { + type: DataTypes.INTEGER(11), + allowNull: false + }, + played_casual: { + type: DataTypes.INTEGER(11), + allowNull: false + }, + played_brawl: { + type: DataTypes.INTEGER(11), + allowNull: false + }, + wins: { + type: DataTypes.INTEGER(11), + allowNull: false + }, + wins_ranked: { + type: DataTypes.INTEGER(11), + allowNull: false + }, + wins_casual: { + type: DataTypes.INTEGER(11), + allowNull: false + }, + wins_brawl: { + type: DataTypes.INTEGER(11), + allowNull: false + }, + skill_tier: { + type: DataTypes.STRING(191), + allowNull: true + }, + streak: { + type: DataTypes.STRING(191), + allowNull: false + } + }, { + tableName: 'player_ext', + timestamps: false, + underscored: true, + freezeTableName: true + }); +}; -- cgit v1.3.1