ALTER TABLE `daily_checkins` RENAME COLUMN `guest_count` TO `guests_count`;--> statement-breakpoint
ALTER TABLE `daily_checkins` MODIFY COLUMN `date` date NOT NULL;--> statement-breakpoint
ALTER TABLE `daily_checkins` MODIFY COLUMN `guests_count` int NOT NULL DEFAULT 0;--> statement-breakpoint
ALTER TABLE `linen_dispatch_log` MODIFY COLUMN `total_weight` float NOT NULL;--> statement-breakpoint
ALTER TABLE `users` ADD `full_name` varchar(255);--> statement-breakpoint
ALTER TABLE `users` ADD `position` varchar(100);--> statement-breakpoint
ALTER TABLE `users` ADD `birth_date` date;--> statement-breakpoint
ALTER TABLE `users` ADD `address` text;--> statement-breakpoint
ALTER TABLE `users` ADD `phone` varchar(20);--> statement-breakpoint
ALTER TABLE `users` ADD `notes` text;--> statement-breakpoint
ALTER TABLE `users` ADD `is_fired` boolean DEFAULT false;--> statement-breakpoint
ALTER TABLE `users` ADD `fired_reason` text;--> statement-breakpoint
ALTER TABLE `users` ADD `user_id` varchar(36);--> statement-breakpoint
ALTER TABLE `daily_checkins` ADD `room_id` varchar(36) NOT NULL;--> statement-breakpoint
ALTER TABLE `daily_checkins` ADD `is_cleaned` boolean DEFAULT false NOT NULL;--> statement-breakpoint
ALTER TABLE `daily_checkins` ADD `cleaner_name` varchar(255);--> statement-breakpoint
ALTER TABLE `daily_checkins` ADD `is_dispatched` boolean DEFAULT false NOT NULL;--> statement-breakpoint
ALTER TABLE `linen_dispatch_log` ADD `dispatch_date` date NOT NULL;--> statement-breakpoint
ALTER TABLE `linen_dispatch_log` ADD `details` json NOT NULL;--> statement-breakpoint
ALTER TABLE `linen_dispatch_log` ADD `dispatched_at` timestamp NOT NULL;--> statement-breakpoint
ALTER TABLE `users` DROP COLUMN `is_active`;--> statement-breakpoint
ALTER TABLE `daily_checkins` DROP COLUMN `room_number`;--> statement-breakpoint
ALTER TABLE `daily_checkins` DROP COLUMN `guest_name`;--> statement-breakpoint
ALTER TABLE `daily_checkins` DROP COLUMN `check_in_time`;--> statement-breakpoint
ALTER TABLE `daily_checkins` DROP COLUMN `check_out_time`;--> statement-breakpoint
ALTER TABLE `daily_checkins` DROP COLUMN `check_out_info`;--> statement-breakpoint
ALTER TABLE `daily_checkins` DROP COLUMN `cleaning_status`;--> statement-breakpoint
ALTER TABLE `daily_checkins` DROP COLUMN `linen_dispatched`;--> statement-breakpoint
ALTER TABLE `linen_dispatch_log` DROP COLUMN `date`;--> statement-breakpoint
ALTER TABLE `linen_dispatch_log` DROP COLUMN `items`;--> statement-breakpoint
ALTER TABLE `linen_dispatch_log` DROP COLUMN `dispatched_by`;