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')
  }
}