ALTER TABLE `maintenance_orders` ADD `deadline` text;
--> statement-breakpoint
ALTER TABLE `maintenance_orders` ADD `progress` integer NOT NULL DEFAULT 0;
--> statement-breakpoint
ALTER TABLE `maintenance_orders` ADD `closed_at` text;
--> statement-breakpoint
ALTER TABLE `maintenance_orders` ADD `closure_note` text;
--> statement-breakpoint
UPDATE `maintenance_orders` SET `deadline` = `due` WHERE `deadline` IS NULL;
--> statement-breakpoint
CREATE INDEX IF NOT EXISTS `idx_maintenance_orders_deadline_status` ON `maintenance_orders` (`deadline`,`status`);
--> statement-breakpoint
PRAGMA optimize;