db/knex_migrations/2023-10-08-0000-mqtt-query.js


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16

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");
        });
};