From 0f1fef88ca050a3160069594fcff7e19e1899676 Mon Sep 17 00:00:00 2001
From: schneefux <schneefux+commit@schneefux.xyz>
Date: Thu, 4 May 2017 13:24:52 +0200
Subject: import teams

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

(limited to 'models/team_membership.js')

diff --git a/models/team_membership.js b/models/team_membership.js
new file mode 100644
index 0000000..502c2df
--- /dev/null
+++ b/models/team_membership.js
@@ -0,0 +1,42 @@
+/* jshint indent: 2 */
+
+module.exports = function(sequelize, DataTypes) {
+  return sequelize.define('team_membership', {
+    id: {
+      type: DataTypes.INTEGER(10).UNSIGNED,
+      allowNull: false,
+      primaryKey: true,
+      autoIncrement: true
+    },
+    player_api_id: {
+      type: DataTypes.CHAR(36),
+      allowNull: false
+    },
+    user_id: {
+      type: DataTypes.BIGINT,
+      allowNull: true
+    },
+    team_id: {
+      type: DataTypes.INTEGER(5).UNSIGNED,
+      allowNull: false
+    },
+    joined_on: {
+      type: DataTypes.TIME,
+      allowNull: false,
+      defaultValue: sequelize.literal('CURRENT_TIMESTAMP')
+    },
+    status: {
+      type: DataTypes.ENUM('pending','initiate','member','officer','leader','former'),
+      allowNull: false
+    },
+    fame: {
+      type: DataTypes.BIGINT,
+      allowNull: false
+    }
+  }, {
+    tableName: 'team_membership',
+    timestamps: false,
+    underscored: true,
+    freezeTableName: true
+  });
+};
-- 
cgit v1.3.1