text: 'use strict';
  module.exports = {
    up: (queryInterface, Sequelize) => {
      return queryInterface.createTable('Reports', {
        reportId: {
          type: Sequelize.UUID,
          allowNull: false,
          defaultValue: Sequelize.UUIDV4,
          primaryKey: true,
        },
        offenderId: {
          type: Sequelize.UUID,
          allowNull: false,
          onDelete: 'CASCADE',
        },
        reporterId: {
          type: Sequelize.UUID,
          allowNull: false,
          onDelete: 'CASCADE',
        },
        offence: {
          type: Sequelize.TEXT,
          allowNull: false,
        },
        details: {
          type: Sequelize.TEXT,
          allowNull: false,
        },
        createdAt: {
          allowNull: false,
          type: Sequelize.DATE,
          defaultValue: new Date()
        },
        updatedAt: {
          allowNull: false,
          type: Sequelize.DATE,
          defaultValue: new Date()
        },
        deletedAt: {
          type: Sequelize.DATE,
          defaultValue: null
        }
      });
    },
    down: (queryInterface, Sequelize) => {
      return queryInterface.dropTable('Reports');
    }
  };
  