summaryrefslogtreecommitdiffstats
path: root/db/knex_migrations/2023-12-22-0000-hourly-uptime.js
diff options
context:
space:
mode:
Diffstat (limited to 'db/knex_migrations/2023-12-22-0000-hourly-uptime.js')
-rw-r--r--db/knex_migrations/2023-12-22-0000-hourly-uptime.js26
1 files changed, 26 insertions, 0 deletions
diff --git a/db/knex_migrations/2023-12-22-0000-hourly-uptime.js b/db/knex_migrations/2023-12-22-0000-hourly-uptime.js
new file mode 100644
index 0000000..4305900
--- /dev/null
+++ b/db/knex_migrations/2023-12-22-0000-hourly-uptime.js
@@ -0,0 +1,26 @@
+exports.up = function (knex) {
+ return knex.schema
+ .createTable("stat_hourly", function (table) {
+ table.increments("id");
+ table.comment("This table contains the hourly aggregate statistics for each monitor");
+ table.integer("monitor_id").unsigned().notNullable()
+ .references("id").inTable("monitor")
+ .onDelete("CASCADE")
+ .onUpdate("CASCADE");
+ table.integer("timestamp")
+ .notNullable()
+ .comment("Unix timestamp rounded down to the nearest hour");
+ table.float("ping").notNullable().comment("Average ping in milliseconds");
+ table.float("ping_min").notNullable().defaultTo(0).comment("Minimum ping during this period in milliseconds");
+ table.float("ping_max").notNullable().defaultTo(0).comment("Maximum ping during this period in milliseconds");
+ table.smallint("up").notNullable();
+ table.smallint("down").notNullable();
+
+ table.unique([ "monitor_id", "timestamp" ]);
+ });
+};
+
+exports.down = function (knex) {
+ return knex.schema
+ .dropTable("stat_hourly");
+};