add imported db models

1 files changed, 61 insertions, 0 deletions

diff --git a/models/player_ext.js b/models/player_ext.js
new file mode 100644
index 0000000..f2ca5d4
--- /dev/null
+++ b/models/player_ext.js
@@ -0,0 +1,61 @@
+/* jshint indent: 2 */
+
+module.exports = function(sequelize, DataTypes) {
+  return sequelize.define('player_ext', {
+    id: {
+      type: DataTypes.INTEGER(11),
+      allowNull: false
+    },
+    api_id: {
+      type: DataTypes.STRING(191),
+      allowNull: false,
+      unique: true
+    },
+    patch_version: {
+      type: DataTypes.STRING(191),
+      allowNull: false
+    },
+    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'
+  });
+};