From d6e50e21163c90b7263c9ed1b09a5a39073f7006 Mon Sep 17 00:00:00 2001
From: schneefux <schneefux+commit@schneefux.xyz>
Date: Thu, 27 Jul 2017 13:30:46 +0200
Subject: reimport

---
 models/global_point.js            |  4 ++++
 models/player_point.js            |  6 +++++-
 models/tournament.js              | 16 ++++++++--------
 models/tournament_participants.js |  8 ++++----
 models/users.js                   | 16 +++++++++-------
 5 files changed, 30 insertions(+), 20 deletions(-)

diff --git a/models/global_point.js b/models/global_point.js
index 4287abf..38b1920 100644
--- a/models/global_point.js
+++ b/models/global_point.js
@@ -60,6 +60,10 @@ module.exports = function(sequelize, DataTypes) {
       type: DataTypes.BIGINT,
       allowNull: true
     },
+    trueskill_delta: {
+      type: "DOUBLE",
+      allowNull: true
+    },
     time_spent: {
       type: DataTypes.BIGINT,
       allowNull: true
diff --git a/models/player_point.js b/models/player_point.js
index ea1d9cc..229d00a 100644
--- a/models/player_point.js
+++ b/models/player_point.js
@@ -48,7 +48,11 @@ module.exports = function(sequelize, DataTypes) {
       type: DataTypes.BIGINT,
       allowNull: false
     },
-    trueskill: {
+    trueskill_max: {
+      type: "DOUBLE",
+      allowNull: true
+    },
+    trueskill_delta: {
       type: "DOUBLE",
       allowNull: true
     },
diff --git a/models/tournament.js b/models/tournament.js
index 27de855..56ca5cf 100644
--- a/models/tournament.js
+++ b/models/tournament.js
@@ -16,14 +16,6 @@ module.exports = function(sequelize, DataTypes) {
       type: DataTypes.STRING(191),
       allowNull: false
     },
-    tag_line_1: {
-      type: DataTypes.STRING(191),
-      allowNull: true
-    },
-    tag_line_2: {
-      type: DataTypes.STRING(191),
-      allowNull: true
-    },
     status: {
       type: DataTypes.ENUM('planned','active','finished'),
       allowNull: false
@@ -43,6 +35,14 @@ module.exports = function(sequelize, DataTypes) {
     region: {
       type: DataTypes.STRING(191),
       allowNull: true
+    },
+    tag_line_1: {
+      type: DataTypes.STRING(255),
+      allowNull: true
+    },
+    tag_line_2: {
+      type: DataTypes.STRING(255),
+      allowNull: true
     }
   }, {
     tableName: 'tournament',
diff --git a/models/tournament_participants.js b/models/tournament_participants.js
index 284ca42..092f8a8 100644
--- a/models/tournament_participants.js
+++ b/models/tournament_participants.js
@@ -16,13 +16,13 @@ module.exports = function(sequelize, DataTypes) {
       type: DataTypes.BIGINT,
       allowNull: false
     },
-    role_id: {
-      type: DataTypes.BIGINT,
-      allowNull: false
-    },
     player_api_id: {
       type: DataTypes.CHAR(36),
       allowNull: false
+    },
+    role_id: {
+      type: DataTypes.INTEGER(11),
+      allowNull: true
     }
   }, {
     tableName: 'tournament_participants',
diff --git a/models/users.js b/models/users.js
index b82ba74..853e441 100644
--- a/models/users.js
+++ b/models/users.js
@@ -14,22 +14,24 @@ module.exports = function(sequelize, DataTypes) {
     },
     user_token: {
       type: DataTypes.CHAR(36),
-      allowNull: true
+      allowNull: false,
+      defaultValue: '-1'
     },
     player_api_id: {
       type: DataTypes.CHAR(36),
-      allowNull: true
+      allowNull: true,
+      defaultValue: ''
     },
     email: {
-      type: DataTypes.STRING(191),
-      allowNull: false
+      type: DataTypes.STRING(100),
+      allowNull: true
     },
     password: {
-      type: DataTypes.STRING(191),
-      allowNull: false
+      type: DataTypes.STRING(100),
+      allowNull: true
     },
     remember_token: {
-      type: DataTypes.STRING(191),
+      type: DataTypes.STRING(255),
       allowNull: true
     },
     access_type: {
-- 
cgit v1.3.1