From 22afb45c9f9b13b13b5899fc5d66e98259260267 Mon Sep 17 00:00:00 2001
From: schneefux <schneefux+commit@schneefux.xyz>
Date: Mon, 10 Apr 2017 16:47:39 +0200
Subject: import schema

---
 models/player_point.js | 17 +++++++----------
 1 file changed, 7 insertions(+), 10 deletions(-)

(limited to 'models/player_point.js')

diff --git a/models/player_point.js b/models/player_point.js
index 31cb085..160be5a 100644
--- a/models/player_point.js
+++ b/models/player_point.js
@@ -12,10 +12,6 @@ module.exports = function(sequelize, DataTypes) {
       type: DataTypes.BIGINT,
       allowNull: false
     },
-    pick_rate: {
-      type: "DOUBLE(8,2)",
-      allowNull: true
-    },
     played: {
       type: DataTypes.INTEGER(11),
       allowNull: true
@@ -28,14 +24,14 @@ module.exports = function(sequelize, DataTypes) {
       type: DataTypes.INTEGER(11),
       allowNull: true
     },
-    win_rate: {
-      type: "DOUBLE(8,2)",
-      allowNull: true
-    },
     series_id: {
       type: DataTypes.BIGINT,
       allowNull: false
     },
+    role_id: {
+      type: DataTypes.BIGINT,
+      allowNull: false
+    },
     filter_id: {
       type: DataTypes.BIGINT,
       allowNull: false
@@ -50,11 +46,12 @@ module.exports = function(sequelize, DataTypes) {
     },
     updated_at: {
       type: DataTypes.DATE,
-      allowNull: true
+      allowNull: false
     },
     created_at: {
       type: DataTypes.TIME,
-      allowNull: true
+      allowNull: false,
+      defaultValue: sequelize.literal('CURRENT_TIMESTAMP')
     },
     kills: {
       type: DataTypes.INTEGER(5).UNSIGNED,
-- 
cgit v1.3.1