From 32021ca861beab43f8252de903e38a76799d86ad Mon Sep 17 00:00:00 2001
From: schneefux <schneefux+commit@schneefux.xyz>
Date: Tue, 15 Aug 2017 21:29:07 +0200
Subject: add new tables

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

(limited to 'models/global_point_bans.js')

diff --git a/models/global_point_bans.js b/models/global_point_bans.js
new file mode 100644
index 0000000..4cc4fc5
--- /dev/null
+++ b/models/global_point_bans.js
@@ -0,0 +1,53 @@
+/* jshint indent: 2 */
+
+module.exports = function(sequelize, DataTypes) {
+  return sequelize.define('global_point_bans', {
+    id: {
+      type: DataTypes.INTEGER(10).UNSIGNED,
+      allowNull: false,
+      primaryKey: true,
+      autoIncrement: true
+    },
+    updated_at: {
+      type: DataTypes.DATE,
+      allowNull: false
+    },
+    series_id: {
+      type: DataTypes.BIGINT,
+      allowNull: false
+    },
+    filter_id: {
+      type: DataTypes.BIGINT,
+      allowNull: false
+    },
+    hero_id: {
+      type: DataTypes.BIGINT,
+      allowNull: false
+    },
+    game_mode_id: {
+      type: DataTypes.BIGINT,
+      allowNull: false
+    },
+    skill_tier_id: {
+      type: DataTypes.BIGINT,
+      allowNull: false
+    },
+    region_id: {
+      type: DataTypes.BIGINT,
+      allowNull: true
+    },
+    played: {
+      type: DataTypes.BIGINT,
+      allowNull: true
+    },
+    bans: {
+      type: DataTypes.BIGINT,
+      allowNull: true
+    }
+  }, {
+    tableName: 'global_point_bans',
+    timestamps: false,
+    underscored: true,
+    freezeTableName: true
+  });
+};
-- 
cgit v1.3.1