MaaBackend/migrations/20200701035753-add_geo_data_to_sites_table.js

"use strict";

const { query } = require("express");

module.exports = {
  up: async (queryInterface, Sequelize) => {
    await queryInterface.addColumn("sites", "latitude", {
      type: Sequelize.DECIMAL(8, 5),
      allowNull: false,
    });

    return await queryInterface.addColumn("sites", "longitude", {
      type: Sequelize.DECIMAL(8, 5),
      allowNull: false,
    });
  },

  down: async (queryInterface, Sequelize) => {
    await queryInterface.removeColumn("sites", "latitude");
    return await queryInterface.removeColumn("sites", "longitude");
  },
};