From be4e78d7b769b9798fa7938909e4ee9fbba3977e Mon Sep 17 00:00:00 2001
From: schneefux <schneefux+commit@schneefux.xyz>
Date: Fri, 31 Mar 2017 20:51:04 +0200
Subject: move ORM model into seperate repo

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

(limited to 'models/roster.js')

diff --git a/models/roster.js b/models/roster.js
new file mode 100644
index 0000000..3848c6a
--- /dev/null
+++ b/models/roster.js
@@ -0,0 +1,58 @@
+/* jshint indent: 2 */
+
+module.exports = function(sequelize, DataTypes) {
+  return sequelize.define('roster', {
+    id: {
+      type: DataTypes.INTEGER(10).UNSIGNED,
+      allowNull: false,
+      primaryKey: true,
+      autoIncrement: true
+    },
+    shard_id: {
+      type: DataTypes.STRING(191),
+      allowNull: false
+    },
+    api_id: {
+      type: DataTypes.STRING(191),
+      allowNull: false,
+      unique: true
+    },
+    match_api_id: {
+      type: DataTypes.STRING(191),
+      allowNull: false
+    },
+    aces_earned: {
+      type: DataTypes.INTEGER(11),
+      allowNull: false
+    },
+    gold: {
+      type: DataTypes.INTEGER(11),
+      allowNull: false
+    },
+    hero_kills: {
+      type: DataTypes.INTEGER(11),
+      allowNull: false
+    },
+    kraken_captures: {
+      type: DataTypes.INTEGER(11),
+      allowNull: false
+    },
+    side: {
+      type: DataTypes.STRING(191),
+      allowNull: false
+    },
+    turret_kills: {
+      type: DataTypes.INTEGER(11),
+      allowNull: false
+    },
+    turrets_remaining: {
+      type: DataTypes.INTEGER(11),
+      allowNull: false
+    }
+  }, {
+    tableName: 'roster',
+    timestamps: false,
+    underscored: true,
+    freezeTableName: true
+  });
+};
-- 
cgit v1.3.1