From be4e78d7b769b9798fa7938909e4ee9fbba3977e Mon Sep 17 00:00:00 2001 From: schneefux Date: Fri, 31 Mar 2017 20:51:04 +0200 Subject: move ORM model into seperate repo --- models/match.js | 50 ++++++++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 50 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..ec5bdab --- /dev/null +++ b/models/match.js @@ -0,0 +1,50 @@ +/* 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 + }, + shard_id: { + type: DataTypes.STRING(191), + allowNull: false + }, + series: { + type: DataTypes.STRING(191), + allowNull: true + }, + created_at: { + type: DataTypes.TIME, + allowNull: false + }, + duration: { + type: DataTypes.INTEGER(11), + allowNull: false + }, + game_mode: { + type: DataTypes.STRING(191), + allowNull: false + }, + end_game_reason: { + type: DataTypes.STRING(191), + allowNull: false + }, + queue: { + type: DataTypes.STRING(191), + allowNull: false + } + }, { + tableName: 'match', + timestamps: false, + underscored: true, + freezeTableName: true + }); +}; -- cgit v1.3.1