-- AlterTable
ALTER TABLE `workorder` ADD COLUMN `deletedAt` DATETIME(3) NULL,
    ADD COLUMN `deletedById` VARCHAR(30) NULL;

-- CreateIndex
CREATE INDEX `WorkOrder_deletedAt_status_createdAt_idx` ON `WorkOrder`(`deletedAt`, `status`, `createdAt`);

-- AddForeignKey
ALTER TABLE `WorkOrder` ADD CONSTRAINT `WorkOrder_deletedById_fkey` FOREIGN KEY (`deletedById`) REFERENCES `User`(`id`) ON DELETE RESTRICT ON UPDATE CASCADE;