ALTER TABLE `employees` DROP INDEX `employees_email_unique`;--> statement-breakpoint
ALTER TABLE `users` MODIFY COLUMN `email` varchar(100);--> statement-breakpoint
ALTER TABLE `users` MODIFY COLUMN `role` enum('ADMIN','MANAGER','MAID') NOT NULL DEFAULT 'MANAGER';--> statement-breakpoint
ALTER TABLE `employees` MODIFY COLUMN `id` varchar(36) NOT NULL;--> statement-breakpoint
ALTER TABLE `employees` MODIFY COLUMN `email` varchar(100);--> statement-breakpoint
ALTER TABLE `shifts` MODIFY COLUMN `date` timestamp NOT NULL;--> statement-breakpoint
ALTER TABLE `shifts` MODIFY COLUMN `role_at_shift` enum('Manager','Maid') NOT NULL;--> statement-breakpoint
ALTER TABLE `shifts` MODIFY COLUMN `status` enum('Blank','Work','Holiday','Unavailable') NOT NULL DEFAULT 'Blank';--> statement-breakpoint
ALTER TABLE `users` ADD `employee_id` varchar(36);--> statement-breakpoint
ALTER TABLE `employees` ADD `is_maid_also` boolean DEFAULT false;