From b9383ef158929bdbb42a15bc48c43aef9bdb74aa Mon Sep 17 00:00:00 2001
From: schneefux <schneefux+commit@schneefux.xyz>
Date: Mon, 10 Apr 2017 19:14:47 +0200
Subject: import points

---
 models/global_point.js | 168 ++++++++++++++++++++++++++++++++++++++++++++-----
 1 file changed, 154 insertions(+), 14 deletions(-)

(limited to 'models/global_point.js')

diff --git a/models/global_point.js b/models/global_point.js
index 3f44f96..52b6856 100644
--- a/models/global_point.js
+++ b/models/global_point.js
@@ -12,37 +12,177 @@ module.exports = function(sequelize, DataTypes) {
       type: DataTypes.DATE,
       allowNull: false
     },
-    pick_rate: {
-      type: "DOUBLE(8,2)",
-      allowNull: false
-    },
-    win_rate: {
-      type: "DOUBLE(8,2)",
-      allowNull: false
-    },
     series_id: {
-      type: DataTypes.INTEGER(11),
+      type: DataTypes.BIGINT,
       allowNull: false
     },
     filter_id: {
-      type: DataTypes.INTEGER(11),
+      type: DataTypes.BIGINT,
       allowNull: false
     },
     hero_id: {
-      type: DataTypes.INTEGER(11),
+      type: DataTypes.BIGINT,
       allowNull: false
     },
     game_mode_id: {
-      type: DataTypes.INTEGER(11),
+      type: DataTypes.BIGINT,
       allowNull: false
     },
     skill_tier_id: {
-      type: DataTypes.INTEGER(11),
+      type: DataTypes.BIGINT,
       allowNull: false
     },
     build_id: {
-      type: DataTypes.INTEGER(11),
+      type: DataTypes.BIGINT,
       allowNull: false
+    },
+    played: {
+      type: DataTypes.BIGINT,
+      allowNull: true
+    },
+    wins: {
+      type: DataTypes.BIGINT,
+      allowNull: true
+    },
+    time_spent: {
+      type: DataTypes.BIGINT,
+      allowNull: true
+    },
+    kills: {
+      type: DataTypes.BIGINT,
+      allowNull: true
+    },
+    deaths: {
+      type: DataTypes.BIGINT,
+      allowNull: true
+    },
+    assists: {
+      type: DataTypes.BIGINT,
+      allowNull: true
+    },
+    minion_kills: {
+      type: DataTypes.BIGINT,
+      allowNull: true
+    },
+    jungle_kills: {
+      type: DataTypes.BIGINT,
+      allowNull: true
+    },
+    non_jungle_minion_kills: {
+      type: DataTypes.BIGINT,
+      allowNull: true
+    },
+    crystal_mine_captures: {
+      type: DataTypes.BIGINT,
+      allowNull: true
+    },
+    gold_mine_captures: {
+      type: DataTypes.BIGINT,
+      allowNull: true
+    },
+    kraken_captures: {
+      type: DataTypes.BIGINT,
+      allowNull: true
+    },
+    turret_captures: {
+      type: DataTypes.BIGINT,
+      allowNull: true
+    },
+    gold: {
+      type: DataTypes.BIGINT,
+      allowNull: true
+    },
+    kda_ratio: {
+      type: "DOUBLE(20,5)",
+      allowNull: true
+    },
+    kill_participation: {
+      type: "DOUBLE(20,5)",
+      allowNull: true
+    },
+    cs_per_min: {
+      type: "DOUBLE(20,5)",
+      allowNull: true
+    },
+    kills_per_min: {
+      type: "DOUBLE(20,5)",
+      allowNull: true
+    },
+    impact_score: {
+      type: DataTypes.BIGINT,
+      allowNull: true
+    },
+    objective_score: {
+      type: DataTypes.BIGINT,
+      allowNull: true
+    },
+    damage_cp_score: {
+      type: DataTypes.BIGINT,
+      allowNull: true
+    },
+    damage_wp_score: {
+      type: DataTypes.BIGINT,
+      allowNull: true
+    },
+    sustain_score: {
+      type: DataTypes.BIGINT,
+      allowNull: true
+    },
+    farm_lane_score: {
+      type: DataTypes.BIGINT,
+      allowNull: true
+    },
+    kill_score: {
+      type: DataTypes.BIGINT,
+      allowNull: true
+    },
+    objective_lane_score: {
+      type: DataTypes.BIGINT,
+      allowNull: true
+    },
+    farm_jungle_score: {
+      type: DataTypes.BIGINT,
+      allowNull: true
+    },
+    peel_score: {
+      type: DataTypes.BIGINT,
+      allowNull: true
+    },
+    kill_assist_score: {
+      type: DataTypes.BIGINT,
+      allowNull: true
+    },
+    objective_jungle_score: {
+      type: DataTypes.BIGINT,
+      allowNull: true
+    },
+    vision_score: {
+      type: DataTypes.BIGINT,
+      allowNull: true
+    },
+    heal_score: {
+      type: DataTypes.BIGINT,
+      allowNull: true
+    },
+    assist_score: {
+      type: DataTypes.BIGINT,
+      allowNull: true
+    },
+    utility_score: {
+      type: DataTypes.BIGINT,
+      allowNull: true
+    },
+    synergy_score: {
+      type: DataTypes.BIGINT,
+      allowNull: true
+    },
+    build_score: {
+      type: DataTypes.BIGINT,
+      allowNull: true
+    },
+    offmeta_score: {
+      type: DataTypes.BIGINT,
+      allowNull: true
     }
   }, {
     tableName: 'global_point',
-- 
cgit v1.3.1