Files
Homelab-manager/server/drizzle/0033_bright_princess_powerful.sql
bobbanandClaude Sonnet 5.5 5cc51c57de Add status pages (a share link kind) and a downloadable Grafana dashboard
- Share links can open a status page: an admin picks servers, integrations and Uptime Kuma
  monitors and names them; the public sees only those names, Working / Not working /
  Being worked on / Can't tell, an optional message and the 30-day figure (share_links.kind/
  title/message and status_items, migration 0033). A status address doesn't open the wall and
  the other way round; Uptime Kuma is asked at most every 30 seconds
- Grafana dashboard built from code (download in Settings -> API and webhooks); a test checks
  it only uses series /metrics serves
- Tests and docs

Co-Authored-By: Claude Sonnet 5.5 <noreply@anthropic.com>
2026-10-18 15:38:08 +02:00

15 lines
676 B
SQL

CREATE TABLE `status_items` (
`id` integer PRIMARY KEY AUTOINCREMENT NOT NULL,
`link_id` integer NOT NULL,
`position` integer DEFAULT 0 NOT NULL,
`label` text NOT NULL,
`kind` text NOT NULL,
`target_id` integer NOT NULL,
`monitor_id` text,
FOREIGN KEY (`link_id`) REFERENCES `share_links`(`id`) ON UPDATE no action ON DELETE cascade
);
--> statement-breakpoint
CREATE INDEX `status_items_link_idx` ON `status_items` (`link_id`,`position`);--> statement-breakpoint
ALTER TABLE `share_links` ADD `kind` text DEFAULT 'wall' NOT NULL;--> statement-breakpoint
ALTER TABLE `share_links` ADD `title` text;--> statement-breakpoint
ALTER TABLE `share_links` ADD `message` text;