From 461549c117c9760392debae54bb8c7a1ed66b807 Mon Sep 17 00:00:00 2001 From: Udo Walter Date: Sat, 23 Feb 2019 08:35:27 +0000 Subject: [groups] add iprange functionality to groups; add refresh button --- server/migrations/20190223034423-create-iprange.js | 31 ++++++++++++++++++++++ 1 file changed, 31 insertions(+) create mode 100644 server/migrations/20190223034423-create-iprange.js (limited to 'server/migrations') diff --git a/server/migrations/20190223034423-create-iprange.js b/server/migrations/20190223034423-create-iprange.js new file mode 100644 index 0000000..75d6d6f --- /dev/null +++ b/server/migrations/20190223034423-create-iprange.js @@ -0,0 +1,31 @@ +'use strict' +module.exports = { + up: (queryInterface, Sequelize) => { + return queryInterface.createTable('ipranges', { + id: { + allowNull: false, + autoIncrement: true, + primaryKey: true, + type: Sequelize.INTEGER + }, + startIp: { + type: Sequelize.STRING + }, + endIp: { + type: Sequelize.STRING(2048) + }, + groupId: { + allowNull: false, + type: Sequelize.INTEGER, + onDelete: 'cascade', + references: { + model: 'groups', + key: 'id' + } + } + }) + }, + down: (queryInterface, Sequelize) => { + return queryInterface.dropTable('ipranges') + } +} -- cgit v1.2.3-55-g7522