-- CreateIndex
CREATE INDEX "booking_status_date_idx" ON "booking"("status", "date");

-- CreateIndex
CREATE INDEX "booking_userId_status_idx" ON "booking"("userId", "status");

-- CreateIndex
CREATE INDEX "tour_published_archived_avgRating_idx" ON "tour"("published", "archived", "avgRating");

-- CreateIndex
CREATE INDEX "tour_createdById_published_idx" ON "tour"("createdById", "published");

-- CreateIndex
CREATE INDEX "tour_city_published_archived_idx" ON "tour"("city", "published", "archived");