• 2023-10-08-0000-mqtt-query.js
  • exports.up = function (knex) {
        // Add new column monitor.mqtt_check_type
        return knex.schema
            .alterTable("monitor", function (table) {
                table.string("mqtt_check_type", 255).notNullable().defaultTo("keyword");
            });
    
    };
    
    exports.down = function (knex) {
        // Drop column monitor.mqtt_check_type
        return knex.schema
            .alterTable("monitor", function (table) {
                table.dropColumn("mqtt_check_type");
            });
    };