MaaBackend/migrations/20191124064121-create_equipment_data_table.js

"use strict";
module.exports = {
  up: (queryInterface, Sequelize) => {
    return queryInterface.createTable("equipment_data", {
      id: {
        primaryKey: true,
        autoIncrement: true,
        type: Sequelize.BIGINT.UNSIGNED,
      },
      ap_id: Sequelize.STRING,
      aid_id: Sequelize.STRING,
      beacon_id: Sequelize.STRING,
      status: Sequelize.STRING,
      battery: Sequelize.INTEGER,
      alarm: Sequelize.STRING,
      latitude: Sequelize.DECIMAL(8, 5),
      longitude: Sequelize.DECIMAL(8, 5),
      created_at: Sequelize.DATE,
    });
  },

  down: (queryInterface, Sequelize) => {
    return queryInterface.dropTable("equipment_data");
  },
};