From 6a951df4a98d808f970ecd290630a15456a66e16 Mon Sep 17 00:00:00 2001 From: schneefux Date: Mon, 10 Apr 2017 20:03:57 +0200 Subject: add builds table --- models/skill_tier.js | 29 +++++++++++++++++++++++++++++ 1 file changed, 29 insertions(+) create mode 100644 models/skill_tier.js (limited to 'models/skill_tier.js') diff --git a/models/skill_tier.js b/models/skill_tier.js new file mode 100644 index 0000000..f0af0be --- /dev/null +++ b/models/skill_tier.js @@ -0,0 +1,29 @@ +/* jshint indent: 2 */ + +module.exports = function(sequelize, DataTypes) { + return sequelize.define('skill_tier', { + id: { + type: DataTypes.INTEGER(10).UNSIGNED, + allowNull: false, + primaryKey: true, + autoIncrement: true + }, + name: { + type: DataTypes.STRING(191), + allowNull: false + }, + start: { + type: DataTypes.INTEGER(6), + allowNull: false + }, + end: { + type: DataTypes.INTEGER(6), + allowNull: false + } + }, { + tableName: 'skill_tier', + timestamps: false, + underscored: true, + freezeTableName: true + }); +}; -- cgit v1.3.1