From c9ca32cdecb2627605e68b07f1f386ef12a4d626 Mon Sep 17 00:00:00 2001 From: schneefux Date: Thu, 30 Mar 2017 15:12:22 +0200 Subject: add imported db models --- models/heros.js | 82 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 82 insertions(+) create mode 100644 models/heros.js (limited to 'models/heros.js') diff --git a/models/heros.js b/models/heros.js new file mode 100644 index 0000000..9848656 --- /dev/null +++ b/models/heros.js @@ -0,0 +1,82 @@ +/* jshint indent: 2 */ + +module.exports = function(sequelize, DataTypes) { + return sequelize.define('heros', { + id: { + type: DataTypes.INTEGER(10).UNSIGNED, + allowNull: false, + primaryKey: true, + autoIncrement: true + }, + created_at: { + type: DataTypes.TIME, + allowNull: true + }, + updated_at: { + type: DataTypes.TIME, + allowNull: true + }, + added_in_patch: { + type: DataTypes.STRING(191), + allowNull: false + }, + name: { + type: DataTypes.STRING(191), + allowNull: false + }, + api_name: { + type: DataTypes.STRING(191), + allowNull: false + }, + is_assassin: { + type: DataTypes.INTEGER(1), + allowNull: false + }, + is_mage: { + type: DataTypes.INTEGER(1), + allowNull: false + }, + is_protector: { + type: DataTypes.INTEGER(1), + allowNull: false + }, + is_sniper: { + type: DataTypes.INTEGER(1), + allowNull: false + }, + is_warrior: { + type: DataTypes.INTEGER(1), + allowNull: false + }, + is_carry: { + type: DataTypes.INTEGER(1), + allowNull: false + }, + is_jungler: { + type: DataTypes.INTEGER(1), + allowNull: false + }, + is_captain: { + type: DataTypes.INTEGER(1), + allowNull: false + }, + heroic_perk: { + type: DataTypes.STRING(191), + allowNull: false + }, + ability_a: { + type: DataTypes.STRING(191), + allowNull: false + }, + ability_b: { + type: DataTypes.STRING(191), + allowNull: false + }, + ability_c: { + type: DataTypes.STRING(191), + allowNull: false + } + }, { + tableName: 'heros' + }); +}; -- cgit v1.3.1