Files
Homelab-manager/server/drizzle/0052_brainy_steve_rogers.sql
bobbanandClaude Sonnet 5.5 e114567d64 How big the app's data is, and a webhook delivery log with Send again
Settings -> Data -> Storage measures the database, backups and sessions and every
table (size, rows, growth, how long it is kept, how far back it reaches), and flags
histories that are not being trimmed or have no limit.

Event webhooks now keep a delivery log (last 100 per webhook, 14 days): what was
sent, how it went, the message itself, and Send again, which resends it exactly as it
was (same id and signature). Resends are audited and in the Change log.

Co-Authored-By: Claude Sonnet 5.5 <noreply@anthropic.com>
2026-10-21 20:58:57 +02:00

15 lines
560 B
SQL

CREATE TABLE `webhook_deliveries` (
`id` integer PRIMARY KEY AUTOINCREMENT NOT NULL,
`webhook_id` integer NOT NULL,
`event` text NOT NULL,
`delivery_id` text NOT NULL,
`attempts` integer DEFAULT 1 NOT NULL,
`ok` integer NOT NULL,
`result` text NOT NULL,
`body` text NOT NULL,
`retry_of` integer,
`created_at` text NOT NULL,
FOREIGN KEY (`webhook_id`) REFERENCES `event_webhooks`(`id`) ON UPDATE no action ON DELETE cascade
);
--> statement-breakpoint
CREATE INDEX `webhook_deliveries_webhook_idx` ON `webhook_deliveries` (`webhook_id`,`created_at`);