CREATE TABLE `recycleBinSummaryDeliveries` (
	`summaryDate` varchar(10) NOT NULL,
	`alertCount` int NOT NULL DEFAULT 0,
	`status` varchar(16) NOT NULL DEFAULT 'pending',
	`errorMessage` text,
	`deliveredAt` timestamp,
	`createdAt` timestamp NOT NULL DEFAULT (now()),
	`updatedAt` timestamp NOT NULL DEFAULT (now()) ON UPDATE CURRENT_TIMESTAMP,
	CONSTRAINT `recycleBinSummaryDeliveries_summaryDate` PRIMARY KEY(`summaryDate`)
);
--> statement-breakpoint
ALTER TABLE `recycleBinRetentionSettings` ADD `internalSummaryEnabled` boolean DEFAULT true NOT NULL;