db/knex_migrations/2023-10-16-0000-create-remote-browsers.js


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21

exports.up = function (knex) {
    return knex.schema
        .createTable("remote_browser", function (table) {
            table.increments("id");
            table.string("name", 255).notNullable();
            table.string("url", 255).notNullable();
            table.integer("user_id").unsigned();
        }).alterTable("monitor", function (table) {
            // Add new column monitor.remote_browser
            table.integer("remote_browser").nullable().defaultTo(null).unsigned()
                .index()
                .references("id")
                .inTable("remote_browser");
        });
};

exports.down = function (knex) {
    return knex.schema.dropTable("remote_browser").alterTable("monitor", function (table) {
        table.dropColumn("remote_browser");
    });
};