-- CreateIndex
CREATE INDEX "BotSubscription_ownerId_status_expiresAt_idx" ON "BotSubscription"("ownerId", "status", "expiresAt");

-- CreateIndex
CREATE INDEX "Broadcast_status_scheduledAt_idx" ON "Broadcast"("status", "scheduledAt");

-- CreateIndex
CREATE INDEX "Subscription_status_expiresAt_idx" ON "Subscription"("status", "expiresAt");

-- CreateIndex
CREATE INDEX "Subscription_status_reminderSentAt_expiresAt_idx" ON "Subscription"("status", "reminderSentAt", "expiresAt");

-- CreateIndex
CREATE INDEX "Subscription_userId_channelId_status_idx" ON "Subscription"("userId", "channelId", "status");

-- CreateIndex
CREATE INDEX "Transaction_status_paidAt_idx" ON "Transaction"("status", "paidAt");
