From c5cd9e53d7413ce960a2170eedb466073175bf80 Mon Sep 17 00:00:00 2001
From: schneefux <schneefux+commit@schneefux.xyz>
Date: Thu, 8 Jun 2017 12:42:19 +0200
Subject: import 2.7.0 table changes

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

(limited to 'models/event.js')

diff --git a/models/event.js b/models/event.js
new file mode 100644
index 0000000..beed589
--- /dev/null
+++ b/models/event.js
@@ -0,0 +1,57 @@
+/* jshint indent: 2 */
+
+module.exports = function(sequelize, DataTypes) {
+  return sequelize.define('event', {
+    id: {
+      type: DataTypes.INTEGER(10).UNSIGNED,
+      allowNull: false,
+      primaryKey: true,
+      autoIncrement: true
+    },
+    api_id: {
+      type: DataTypes.STRING(191),
+      allowNull: true
+    },
+    group_id: {
+      type: DataTypes.INTEGER(11),
+      allowNull: false
+    },
+    name: {
+      type: DataTypes.STRING(191),
+      allowNull: false
+    },
+    team_1_id: {
+      type: DataTypes.INTEGER(11),
+      allowNull: false
+    },
+    team_1_score: {
+      type: DataTypes.INTEGER(11),
+      allowNull: true
+    },
+    team_2_id: {
+      type: DataTypes.INTEGER(11),
+      allowNull: false
+    },
+    team_2_score: {
+      type: DataTypes.INTEGER(11),
+      allowNull: true
+    },
+    date: {
+      type: DataTypes.TIME,
+      allowNull: true
+    },
+    bestOf: {
+      type: DataTypes.ENUM('1','3','5','7','9'),
+      allowNull: true
+    },
+    winner_id: {
+      type: DataTypes.INTEGER(11),
+      allowNull: true
+    }
+  }, {
+    tableName: 'event',
+    timestamps: false,
+    underscored: true,
+    freezeTableName: true
+  });
+};
-- 
cgit v1.3.1