From 2f4ec682bfd88c651451d32f292e3f172daa4f11 Mon Sep 17 00:00:00 2001 From: Udo Walter Date: Mon, 17 Sep 2018 18:25:13 +0000 Subject: add ipxe entry and config database migrations and models --- server/models/config.js | 27 +++++++++++++++++++++++++++ server/models/entry.js | 16 ++++++++++++++++ 2 files changed, 43 insertions(+) create mode 100644 server/models/config.js create mode 100644 server/models/entry.js (limited to 'server/models') diff --git a/server/models/config.js b/server/models/config.js new file mode 100644 index 0000000..11661fd --- /dev/null +++ b/server/models/config.js @@ -0,0 +1,27 @@ +'use strict' +module.exports = (sequelize, DataTypes) => { + var config = sequelize.define('config', { + id: { + allowNull: false, + autoIncrement: true, + primaryKey: true, + type: DataTypes.INTEGER + }, + name: DataTypes.STRING, + description: DataTypes.STRING(2048), + defaultEntry: DataTypes.INTEGER, + timeout: DataTypes.INTEGER, + script: DataTypes.STRING(4096) + }, { + timestamps: false + }) + config.associate = function (models) { + var ConfigXEntry = sequelize.define('config_x_entry', { + sortValue: DataTypes.INTEGER, + customName: DataTypes.STRING, + keyBind: DataTypes.STRING + }, { timestamps: false, freezeTableName: true }) + config.belongsToMany(models.entry, { as: 'entries', through: ConfigXEntry, foreignKey: 'configId', otherKey: 'entryId' }) + } + return config +} diff --git a/server/models/entry.js b/server/models/entry.js new file mode 100644 index 0000000..94d6a01 --- /dev/null +++ b/server/models/entry.js @@ -0,0 +1,16 @@ +'use strict' +module.exports = (sequelize, DataTypes) => { + var entry = sequelize.define('entry', { + id: { + allowNull: false, + autoIncrement: true, + primaryKey: true, + type: DataTypes.INTEGER + }, + name: DataTypes.STRING, + script: DataTypes.STRING(4096) + }, { + timestamps: false + }) + return entry +} -- cgit v1.2.3-55-g7522