From d4380da66020f2a3d496715d14b637a868c81614 Mon Sep 17 00:00:00 2001
From: schneefux <schneefux+commit@schneefux.xyz>
Date: Fri, 7 Apr 2017 17:55:03 +0200
Subject: reimport after breaking changes

---
 models/player_point.js | 214 +++++++++++++++++++++++++++++++++++++++++++++++++
 1 file changed, 214 insertions(+)
 create mode 100644 models/player_point.js

(limited to 'models/player_point.js')

diff --git a/models/player_point.js b/models/player_point.js
new file mode 100644
index 0000000..4304c07
--- /dev/null
+++ b/models/player_point.js
@@ -0,0 +1,214 @@
+/* jshint indent: 2 */
+
+module.exports = function(sequelize, DataTypes) {
+  return sequelize.define('player_point', {
+    id: {
+      type: DataTypes.INTEGER(10).UNSIGNED,
+      allowNull: false,
+      primaryKey: true,
+      autoIncrement: true
+    },
+    shard_id: {
+      type: DataTypes.STRING(5),
+      allowNull: false
+    },
+    player_id: {
+      type: DataTypes.BIGINT,
+      allowNull: false
+    },
+    pick_rate: {
+      type: "DOUBLE(8,2)",
+      allowNull: false
+    },
+    played: {
+      type: DataTypes.INTEGER(11),
+      allowNull: false
+    },
+    wins: {
+      type: DataTypes.INTEGER(11),
+      allowNull: false
+    },
+    time_spent: {
+      type: DataTypes.INTEGER(11),
+      allowNull: false
+    },
+    win_rate: {
+      type: "DOUBLE(8,2)",
+      allowNull: false
+    },
+    series_id: {
+      type: DataTypes.BIGINT,
+      allowNull: false
+    },
+    filter_id: {
+      type: DataTypes.BIGINT,
+      allowNull: false
+    },
+    actor_id: {
+      type: DataTypes.BIGINT,
+      allowNull: false
+    },
+    game_mode_id: {
+      type: DataTypes.BIGINT,
+      allowNull: false
+    },
+    updated_at: {
+      type: DataTypes.DATE,
+      allowNull: false
+    },
+    created_at: {
+      type: DataTypes.TIME,
+      allowNull: false,
+      defaultValue: sequelize.fn('NOW')
+    },
+    kills: {
+      type: DataTypes.INTEGER(5).UNSIGNED,
+      allowNull: false
+    },
+    deaths: {
+      type: DataTypes.INTEGER(5).UNSIGNED,
+      allowNull: false
+    },
+    assists: {
+      type: DataTypes.INTEGER(5).UNSIGNED,
+      allowNull: false
+    },
+    minion_kills: {
+      type: DataTypes.INTEGER(5).UNSIGNED,
+      allowNull: false
+    },
+    jungle_kills: {
+      type: DataTypes.INTEGER(5).UNSIGNED,
+      allowNull: false
+    },
+    non_jungle_minion_kills: {
+      type: DataTypes.INTEGER(5).UNSIGNED,
+      allowNull: false
+    },
+    crystal_mine_captures: {
+      type: DataTypes.INTEGER(5).UNSIGNED,
+      allowNull: false
+    },
+    gold_mine_captures: {
+      type: DataTypes.INTEGER(5).UNSIGNED,
+      allowNull: false
+    },
+    kraken_captures: {
+      type: DataTypes.INTEGER(5).UNSIGNED,
+      allowNull: false
+    },
+    turret_captures: {
+      type: DataTypes.INTEGER(5).UNSIGNED,
+      allowNull: false
+    },
+    gold: {
+      type: DataTypes.INTEGER(8).UNSIGNED,
+      allowNull: true
+    },
+    hero_level: {
+      type: DataTypes.INTEGER(3).UNSIGNED,
+      allowNull: true
+    },
+    role: {
+      type: DataTypes.ENUM('captain','carry','jungler'),
+      allowNull: true
+    },
+    kda_ratio: {
+      type: "DOUBLE(5,5)",
+      allowNull: true
+    },
+    kill_participation: {
+      type: "DOUBLE(5,5)",
+      allowNull: true
+    },
+    cs_per_min: {
+      type: "DOUBLE(7,5)",
+      allowNull: true
+    },
+    kills_per_min: {
+      type: "DOUBLE(6,5)",
+      allowNull: true
+    },
+    impact_score: {
+      type: DataTypes.INTEGER(3).UNSIGNED,
+      allowNull: true
+    },
+    objective_score: {
+      type: DataTypes.INTEGER(3).UNSIGNED,
+      allowNull: true
+    },
+    damage_cp_score: {
+      type: DataTypes.INTEGER(3).UNSIGNED,
+      allowNull: true
+    },
+    damage_wp_score: {
+      type: DataTypes.INTEGER(3).UNSIGNED,
+      allowNull: true
+    },
+    sustain_score: {
+      type: DataTypes.INTEGER(3).UNSIGNED,
+      allowNull: true
+    },
+    farm_lane_score: {
+      type: DataTypes.INTEGER(3).UNSIGNED,
+      allowNull: true
+    },
+    kill_score: {
+      type: DataTypes.INTEGER(3).UNSIGNED,
+      allowNull: true
+    },
+    objective_lane_score: {
+      type: DataTypes.INTEGER(3).UNSIGNED,
+      allowNull: true
+    },
+    farm_jungle_score: {
+      type: DataTypes.INTEGER(3).UNSIGNED,
+      allowNull: true
+    },
+    peal_score: {
+      type: DataTypes.INTEGER(3).UNSIGNED,
+      allowNull: true
+    },
+    kill_assist_score: {
+      type: DataTypes.INTEGER(3).UNSIGNED,
+      allowNull: true
+    },
+    objective_jungle_score: {
+      type: DataTypes.INTEGER(3).UNSIGNED,
+      allowNull: true
+    },
+    vision_score: {
+      type: DataTypes.INTEGER(3).UNSIGNED,
+      allowNull: true
+    },
+    heal_score: {
+      type: DataTypes.INTEGER(3).UNSIGNED,
+      allowNull: true
+    },
+    assist_score: {
+      type: DataTypes.INTEGER(3).UNSIGNED,
+      allowNull: true
+    },
+    utility_score: {
+      type: DataTypes.INTEGER(3).UNSIGNED,
+      allowNull: true
+    },
+    synergy_score: {
+      type: DataTypes.INTEGER(3).UNSIGNED,
+      allowNull: true
+    },
+    build_score: {
+      type: DataTypes.INTEGER(3).UNSIGNED,
+      allowNull: true
+    },
+    offmeta_score: {
+      type: DataTypes.INTEGER(3).UNSIGNED,
+      allowNull: true
+    }
+  }, {
+    tableName: 'player_point',
+    timestamps: false,
+    underscored: true,
+    freezeTableName: true
+  });
+};
-- 
cgit v1.3.1