Files
bobbanandClaude Sonnet 5.5 a2b43bcd5d Add a power history to each game server
Each change a read of a Fragnet account sees, and each power signal sent from
here with who sent it, is written down (180 days). A server's details show the
share of the last 30 days it was on, starts and stops, a seven-day bar and the
latest changes, with who asked for them.

Co-Authored-By: Claude Sonnet 5.5 <noreply@anthropic.com>
2026-11-10 19:30:27 +01:00

13 lines
477 B
SQL

CREATE TABLE `fragnet_power_log` (
`id` integer PRIMARY KEY AUTOINCREMENT NOT NULL,
`integration_id` integer NOT NULL,
`server_id` text NOT NULL,
`server_name` text NOT NULL,
`at` text NOT NULL,
`kind` text NOT NULL,
`detail` text,
`by` text,
FOREIGN KEY (`integration_id`) REFERENCES `integrations`(`id`) ON UPDATE no action ON DELETE cascade
);
--> statement-breakpoint
CREATE INDEX `fragnet_power_log_idx` ON `fragnet_power_log` (`integration_id`,`server_id`,`at`);