0
0
mirror of https://github.com/louislam/uptime-kuma.git synced 2024-11-24 19:56:56 +01:00
uptime-kuma/db/knex_migrations/2023-10-16-0000-create-remote-browsers.js

22 lines
788 B
JavaScript
Raw Permalink Normal View History

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