Files
Homelab-manager/server/drizzle/0069_overconfident_cloak.sql
bobbanandClaude Sonnet 5.5 f86661f6c9 Speedtest Tracker, Costs, "Having trouble" on status pages, grouped Integrations and Dashboard
- Speedtest Tracker integration: charts, alerts for a slow line (median of the
  last three tests under a share of what is paid for) and for failing tests.
- Costs page (Records): things paid for by hand plus Hetzner's estimate, totals
  per currency, bills rolled forward into Coming up as Renewals.
- Status pages: a "Having trouble" state for things that answer but have an open
  alert; Speedtest reads as the internet.
- Integrations page and kind picker grouped like the sidebar (one shared types
  file); Notifications "What to send" shown one group at a time; Dashboard
  integration sections follow the menu groups, with tiles for integrations that
  have no widget.
- Docs, tests, and ROLES.md menu table brought up to date.

Co-Authored-By: Claude Sonnet 5.5 <noreply@anthropic.com>
2026-10-26 23:23:46 +01:00

14 lines
489 B
SQL

CREATE TABLE `speedtest_results` (
`integration_id` integer NOT NULL,
`result_id` integer NOT NULL,
`at` text NOT NULL,
`status` text NOT NULL,
`download_bps` real,
`upload_bps` real,
`ping_ms` real,
`healthy` integer,
PRIMARY KEY(`integration_id`, `result_id`),
FOREIGN KEY (`integration_id`) REFERENCES `integrations`(`id`) ON UPDATE no action ON DELETE cascade
);
--> statement-breakpoint
CREATE INDEX `speedtest_results_at_idx` ON `speedtest_results` (`integration_id`,`at`);