Files
Homelab-manager/server/drizzle/0083_lovely_midnight.sql
bobbanandClaude Sonnet 5.5 7618bf0f0a Add qBittorrent and SABnzbd: a Download clients page with stuck, disconnected, paused and full-disk alerts
Each client is read every five minutes (read-only; qBittorrent's sign-in is the only POST): speed, queue and item states, network connection or paused queue, free space, SABnzbd's failures and warnings. Shared adapter, sync service, download_state table, /api/downloads, metrics and docs.

Co-Authored-By: Claude Sonnet 5.5 <noreply@anthropic.com>
2026-11-04 23:13:03 +01:00

18 lines
522 B
SQL

CREATE TABLE `download_state` (
`integration_id` integer PRIMARY KEY NOT NULL,
`version` text,
`speed_down` integer,
`speed_up` integer,
`paused` integer DEFAULT false NOT NULL,
`connection` text,
`counts` text NOT NULL,
`total` integer DEFAULT 0 NOT NULL,
`items` text DEFAULT '[]' NOT NULL,
`failed` text,
`disks` text,
`warnings` text,
`since` text DEFAULT '{}' NOT NULL,
`updated_at` text NOT NULL,
FOREIGN KEY (`integration_id`) REFERENCES `integrations`(`id`) ON UPDATE no action ON DELETE cascade
);