ALTER TABLE `users` MODIFY COLUMN `role` enum('user','admin','technician') NOT NULL DEFAULT 'user';--> statement-breakpoint
ALTER TABLE `inventoryTransactions` ADD `evidenceStorageKey` varchar(512);--> statement-breakpoint
ALTER TABLE `inventoryTransactions` ADD `evidenceUrl` varchar(1024);--> statement-breakpoint
ALTER TABLE `inventoryTransactions` ADD `evidenceFileName` varchar(255);--> statement-breakpoint
ALTER TABLE `inventoryTransactions` ADD `evidenceContentType` varchar(100);--> statement-breakpoint
ALTER TABLE `inventoryTransactions` ADD `evidenceSizeBytes` int;