-- DropIndex
DROP INDEX "public"."Service_enableCost_idx";

-- DropIndex
DROP INDEX "public"."Service_enabled_idx";

-- DropIndex
DROP INDEX "public"."Service_enabled_lastStatus_idx";

-- DropIndex
DROP INDEX "public"."Service_lastChecked_idx";

-- DropIndex
DROP INDEX "public"."Service_ownerTeam_idx";

-- DropIndex
DROP INDEX "public"."Service_provider_region_idx";

-- DropIndex
DROP INDEX "public"."Service_serviceType_idx";

-- AlterTable
ALTER TABLE "public"."Service" ADD COLUMN     "deleted" BOOLEAN NOT NULL DEFAULT false;

-- CreateIndex
CREATE INDEX "Service_deleted_enabled_lastStatus_idx" ON "public"."Service"("deleted", "enabled", "lastStatus");

-- CreateIndex
CREATE INDEX "Service_deleted_lastChecked_idx" ON "public"."Service"("deleted", "lastChecked");

-- CreateIndex
CREATE INDEX "Service_deleted_enabled_idx" ON "public"."Service"("deleted", "enabled");

-- CreateIndex
CREATE INDEX "Service_deleted_serviceType_idx" ON "public"."Service"("deleted", "serviceType");

-- CreateIndex
CREATE INDEX "Service_deleted_ownerTeam_idx" ON "public"."Service"("deleted", "ownerTeam");

-- CreateIndex
CREATE INDEX "Service_deleted_provider_region_idx" ON "public"."Service"("deleted", "provider", "region");

-- CreateIndex
CREATE INDEX "Service_deleted_enableCost_idx" ON "public"."Service"("deleted", "enableCost");

-- CreateIndex
CREATE INDEX "Service_deleted_idx" ON "public"."Service"("deleted");
