CREATE TABLE `manualBillingReminderLogs` (
	`id` int AUTO_INCREMENT NOT NULL,
	`invoiceId` int NOT NULL,
	`userId` int NOT NULL,
	`channel` enum('whatsapp_link','email_link') NOT NULL,
	`destination` varchar(320) NOT NULL,
	`message` text NOT NULL,
	`createdBy` int NOT NULL,
	`createdAt` timestamp NOT NULL DEFAULT (now()),
	CONSTRAINT `manualBillingReminderLogs_id` PRIMARY KEY(`id`)
);
--> statement-breakpoint
ALTER TABLE `inventoryTransactions` ADD `evidenceAlbum` enum('umum','instalasi','maintenance','gudang','serah_terima','lainnya') DEFAULT 'umum' NOT NULL;