summaryrefslogtreecommitdiff
path: root/models/player_point.js
diff options
context:
space:
mode:
authorschneefux <schneefux+commit@schneefux.xyz>2017-04-10 19:14:47 +0200
committerschneefux <schneefux+commit@schneefux.xyz>2017-04-10 19:14:47 +0200
commitb9383ef158929bdbb42a15bc48c43aef9bdb74aa (patch)
tree22cf9a0b0bef414bbee2352439fa1ff7ad73d3cb /models/player_point.js
parentc853a79a1eeeba7670cf1509225dc0e7959a7189 (diff)
downloadorm-b9383ef158929bdbb42a15bc48c43aef9bdb74aa.tar.gz
orm-b9383ef158929bdbb42a15bc48c43aef9bdb74aa.zip
import points
Diffstat (limited to 'models/player_point.js')
-rw-r--r--models/player_point.js84
1 files changed, 42 insertions, 42 deletions
diff --git a/models/player_point.js b/models/player_point.js
index 29054dc..8f6305e 100644
--- a/models/player_point.js
+++ b/models/player_point.js
@@ -9,7 +9,7 @@ module.exports = function(sequelize, DataTypes) {
autoIncrement: true
},
player_api_id: {
- type: DataTypes.CHAR(36),
+ type: DataTypes.BIGINT,
allowNull: false
},
played: {
@@ -48,144 +48,144 @@ module.exports = function(sequelize, DataTypes) {
type: DataTypes.DATE,
allowNull: false
},
- created_at: {
- type: DataTypes.TIME,
- allowNull: false
- },
kills: {
- type: DataTypes.INTEGER(5).UNSIGNED,
+ type: DataTypes.INTEGER(10).UNSIGNED,
allowNull: true
},
deaths: {
- type: DataTypes.INTEGER(5).UNSIGNED,
+ type: DataTypes.INTEGER(10).UNSIGNED,
allowNull: true
},
assists: {
- type: DataTypes.INTEGER(5).UNSIGNED,
+ type: DataTypes.INTEGER(10).UNSIGNED,
allowNull: true
},
minion_kills: {
- type: DataTypes.INTEGER(5).UNSIGNED,
+ type: DataTypes.INTEGER(10).UNSIGNED,
allowNull: true
},
jungle_kills: {
- type: DataTypes.INTEGER(5).UNSIGNED,
+ type: DataTypes.INTEGER(10).UNSIGNED,
allowNull: true
},
non_jungle_minion_kills: {
- type: DataTypes.INTEGER(5).UNSIGNED,
+ type: DataTypes.INTEGER(10).UNSIGNED,
allowNull: true
},
crystal_mine_captures: {
- type: DataTypes.INTEGER(5).UNSIGNED,
+ type: DataTypes.INTEGER(10).UNSIGNED,
allowNull: true
},
gold_mine_captures: {
- type: DataTypes.INTEGER(5).UNSIGNED,
+ type: DataTypes.INTEGER(10).UNSIGNED,
allowNull: true
},
kraken_captures: {
- type: DataTypes.INTEGER(5).UNSIGNED,
+ type: DataTypes.INTEGER(10).UNSIGNED,
allowNull: true
},
turret_captures: {
- type: DataTypes.INTEGER(5).UNSIGNED,
+ type: DataTypes.INTEGER(10).UNSIGNED,
allowNull: true
},
gold: {
- type: DataTypes.INTEGER(8).UNSIGNED,
+ type: DataTypes.INTEGER(10).UNSIGNED,
allowNull: true
},
hero_level: {
- type: DataTypes.INTEGER(3).UNSIGNED,
- allowNull: true
- },
- role: {
- type: DataTypes.ENUM('captain','carry','jungler'),
+ type: DataTypes.INTEGER(10).UNSIGNED,
allowNull: true
},
kda_ratio: {
- type: "DOUBLE(5,5)",
+ type: "DOUBLE(10,5)",
allowNull: true
},
kill_participation: {
- type: "DOUBLE(5,5)",
+ type: "DOUBLE(10,5)",
+ allowNull: true
+ },
+ cs_per_min: {
+ type: "DOUBLE(14,5)",
+ allowNull: true
+ },
+ kills_per_min: {
+ type: "DOUBLE(12,5)",
allowNull: true
},
impact_score: {
- type: DataTypes.INTEGER(3).UNSIGNED,
+ type: DataTypes.INTEGER(10).UNSIGNED,
allowNull: true
},
objective_score: {
- type: DataTypes.INTEGER(3).UNSIGNED,
+ type: DataTypes.INTEGER(10).UNSIGNED,
allowNull: true
},
damage_cp_score: {
- type: DataTypes.INTEGER(3).UNSIGNED,
+ type: DataTypes.INTEGER(10).UNSIGNED,
allowNull: true
},
damage_wp_score: {
- type: DataTypes.INTEGER(3).UNSIGNED,
+ type: DataTypes.INTEGER(10).UNSIGNED,
allowNull: true
},
sustain_score: {
- type: DataTypes.INTEGER(3).UNSIGNED,
+ type: DataTypes.INTEGER(10).UNSIGNED,
allowNull: true
},
farm_lane_score: {
- type: DataTypes.INTEGER(3).UNSIGNED,
+ type: DataTypes.INTEGER(10).UNSIGNED,
allowNull: true
},
kill_score: {
- type: DataTypes.INTEGER(3).UNSIGNED,
+ type: DataTypes.INTEGER(10).UNSIGNED,
allowNull: true
},
objective_lane_score: {
- type: DataTypes.INTEGER(3).UNSIGNED,
+ type: DataTypes.INTEGER(10).UNSIGNED,
allowNull: true
},
farm_jungle_score: {
- type: DataTypes.INTEGER(3).UNSIGNED,
+ type: DataTypes.INTEGER(10).UNSIGNED,
allowNull: true
},
peel_score: {
- type: DataTypes.INTEGER(3).UNSIGNED,
+ type: DataTypes.INTEGER(10).UNSIGNED,
allowNull: true
},
kill_assist_score: {
- type: DataTypes.INTEGER(3).UNSIGNED,
+ type: DataTypes.INTEGER(10).UNSIGNED,
allowNull: true
},
objective_jungle_score: {
- type: DataTypes.INTEGER(3).UNSIGNED,
+ type: DataTypes.INTEGER(10).UNSIGNED,
allowNull: true
},
vision_score: {
- type: DataTypes.INTEGER(3).UNSIGNED,
+ type: DataTypes.INTEGER(10).UNSIGNED,
allowNull: true
},
heal_score: {
- type: DataTypes.INTEGER(3).UNSIGNED,
+ type: DataTypes.INTEGER(10).UNSIGNED,
allowNull: true
},
assist_score: {
- type: DataTypes.INTEGER(3).UNSIGNED,
+ type: DataTypes.INTEGER(10).UNSIGNED,
allowNull: true
},
utility_score: {
- type: DataTypes.INTEGER(3).UNSIGNED,
+ type: DataTypes.INTEGER(10).UNSIGNED,
allowNull: true
},
synergy_score: {
- type: DataTypes.INTEGER(3).UNSIGNED,
+ type: DataTypes.INTEGER(10).UNSIGNED,
allowNull: true
},
build_score: {
- type: DataTypes.INTEGER(3).UNSIGNED,
+ type: DataTypes.INTEGER(10).UNSIGNED,
allowNull: true
},
offmeta_score: {
- type: DataTypes.INTEGER(3).UNSIGNED,
+ type: DataTypes.INTEGER(10).UNSIGNED,
allowNull: true
}
}, {