CREATE TABLE `nodeMetrics` (
	`id` int AUTO_INCREMENT NOT NULL,
	`containerId` varchar(64) NOT NULL,
	`containerName` varchar(255) NOT NULL,
	`cpuPercent` decimal(6,2) NOT NULL DEFAULT '0.00',
	`memUsedMb` decimal(10,2) NOT NULL DEFAULT '0.00',
	`memLimitMb` decimal(10,2) NOT NULL DEFAULT '0.00',
	`status` varchar(32) NOT NULL DEFAULT 'running',
	`recordedAt` timestamp NOT NULL DEFAULT (now()),
	CONSTRAINT `nodeMetrics_id` PRIMARY KEY(`id`)
);
--> statement-breakpoint
CREATE INDEX `nodeMetrics_containerId_idx` ON `nodeMetrics` (`containerId`);--> statement-breakpoint
CREATE INDEX `nodeMetrics_recordedAt_idx` ON `nodeMetrics` (`recordedAt`);