ALTER TABLE `users` MODIFY COLUMN `role` enum('ADMIN','MANAGER','MAID','GOD') DEFAULT 'MANAGER';--> statement-breakpoint
ALTER TABLE `daily_checkins` MODIFY COLUMN `room_id` varchar(10) NOT NULL;--> statement-breakpoint
ALTER TABLE `daily_checkins` MODIFY COLUMN `date` date NOT NULL;--> statement-breakpoint
ALTER TABLE `linen_dispatch_log` MODIFY COLUMN `dispatch_date` varchar(10) NOT NULL;--> statement-breakpoint
ALTER TABLE `daily_linen_usage` MODIFY COLUMN `date` date NOT NULL;--> statement-breakpoint
ALTER TABLE `paymaster_rows` MODIFY COLUMN `type` varchar(100) NOT NULL;--> statement-breakpoint
ALTER TABLE `tasks` ADD `position` text;--> statement-breakpoint
ALTER TABLE `tasks` ADD `order` int;--> statement-breakpoint
ALTER TABLE `paymaster_rows` ADD `room_number` varchar(100);--> statement-breakpoint
ALTER TABLE `paymaster_rows` ADD `contractor` varchar(255);--> statement-breakpoint
ALTER TABLE `paymaster_rows` ADD `stay_dates` varchar(100);--> statement-breakpoint
ALTER TABLE `paymaster_rows` ADD `operational_day` date NOT NULL;--> statement-breakpoint
ALTER TABLE `daily_checkins` ADD CONSTRAINT `date_room_idx` UNIQUE(`date`,`room_id`);--> statement-breakpoint
ALTER TABLE `tasks` DROP COLUMN `date`;--> statement-breakpoint
ALTER TABLE `tasks` DROP COLUMN `archived_at`;--> statement-breakpoint
ALTER TABLE `daily_checkins` DROP COLUMN `room_number`;--> statement-breakpoint
ALTER TABLE `paymaster_rows` DROP COLUMN `description`;--> statement-breakpoint
ALTER TABLE `paymaster_rows` DROP COLUMN `archived_at`;