From 1ee0e6c1d7484930387438b7ebb15340595b5383 Mon Sep 17 00:00:00 2001 From: Christian Hofmaier Date: Sun, 24 Mar 2019 16:02:18 +0000 Subject: [eventmanager] Add module and functionality - list to show all events, buttons to create/delete events - can add groups/clients to event - can add blacklist to event --- server/migrations/20190226151600-create-event.js | 31 ++++++++++++++++++++++++ 1 file changed, 31 insertions(+) create mode 100644 server/migrations/20190226151600-create-event.js (limited to 'server/migrations/20190226151600-create-event.js') diff --git a/server/migrations/20190226151600-create-event.js b/server/migrations/20190226151600-create-event.js new file mode 100644 index 0000000..59cab86 --- /dev/null +++ b/server/migrations/20190226151600-create-event.js @@ -0,0 +1,31 @@ +'use strict' +module.exports = { + up: (queryInterface, Sequelize) => { + return queryInterface.createTable('events', { + id: { + allowNull: false, + autoIncrement: true, + primaryKey: true, + type: Sequelize.INTEGER + }, + name: { + type: Sequelize.STRING + }, + description: { + type: Sequelize.STRING(2048) + }, + config: { + type: Sequelize.INTEGER + }, + times: { + type: Sequelize.STRING(4096) + }, + important: { + type: Sequelize.BOOLEAN + } + }) + }, + down: (queryInterface, Sequelize) => { + return queryInterface.dropTable('permissions') + } +} -- cgit v1.2.3-55-g7522