From c9ca32cdecb2627605e68b07f1f386ef12a4d626 Mon Sep 17 00:00:00 2001
From: schneefux <schneefux+commit@schneefux.xyz>
Date: Thu, 30 Mar 2017 15:12:22 +0200
Subject: add imported db models

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

(limited to 'models/match.js')

diff --git a/models/match.js b/models/match.js
new file mode 100644
index 0000000..18f179a
--- /dev/null
+++ b/models/match.js
@@ -0,0 +1,48 @@
+/* jshint indent: 2 */
+
+module.exports = function(sequelize, DataTypes) {
+  return sequelize.define('match', {
+    id: {
+      type: DataTypes.INTEGER(10).UNSIGNED,
+      allowNull: false,
+      primaryKey: true,
+      autoIncrement: true
+    },
+    api_id: {
+      type: DataTypes.STRING(191),
+      allowNull: false,
+      unique: true
+    },
+    created_at: {
+      type: DataTypes.DATE,
+      allowNull: false,
+      defaultValue: sequelize.literal('CURRENT_TIMESTAMP')
+    },
+    duration: {
+      type: DataTypes.INTEGER(11),
+      allowNull: false
+    },
+    game_mode: {
+      type: DataTypes.STRING(191),
+      allowNull: false
+    },
+    patch_version: {
+      type: DataTypes.STRING(191),
+      allowNull: false
+    },
+    shard_id: {
+      type: DataTypes.STRING(191),
+      allowNull: false
+    },
+    end_game_reason: {
+      type: DataTypes.STRING(191),
+      allowNull: false
+    },
+    queue: {
+      type: DataTypes.STRING(191),
+      allowNull: false
+    }
+  }, {
+    tableName: 'match'
+  });
+};
-- 
cgit v1.3.1