'use strict' module.exports = { up: (queryInterface, Sequelize) => { return queryInterface.createTable('log', { id: { allowNull: false, autoIncrement: true, primaryKey: true, type: Sequelize.INTEGER }, timestamp: { type: Sequelize.BIGINT }, category: { type: Sequelize.STRING }, description: { type: Sequelize.TEXT }, groupId: { type: Sequelize.INTEGER, onDelete: 'SET NULL', references: { model: 'groups', key: 'id' } }, groupSnapshot: { type: Sequelize.TEXT }, clientId: { type: Sequelize.INTEGER, onDelete: 'SET NULL', references: { model: 'clients', key: 'id' } }, clientSnapshot: { type: Sequelize.TEXT }, userId: { type: Sequelize.INTEGER, onDelete: 'SET NULL', references: { model: 'users', key: 'id' } }, userSnapshot: { type: Sequelize.TEXT } }) }, down: (queryInterface, Sequelize) => { return queryInterface.dropTable('log') } }