db/knex_migrations/2024-04-26-0000-snmp-monitor.js


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

exports.up = function (knex) {
    return knex.schema
        .alterTable("monitor", function (table) {
            table.string("snmp_oid").defaultTo(null);
            table.enum("snmp_version", [ "1", "2c", "3" ]).defaultTo("2c");
            table.string("json_path_operator").defaultTo(null);
        });
};

exports.down = function (knex) {
    return knex.schema.alterTable("monitor", function (table) {
        table.dropColumn("snmp_oid");
        table.dropColumn("snmp_version");
        table.dropColumn("json_path_operator");
    });
};