From f1d9cc59cfc96d5ee76e48d7a9569bb329cad501 Mon Sep 17 00:00:00 2001
From: =?utf8?q?Rapha=C3=ABl=20Gertz?= <git@rapsys.eu>
Date: Thu, 7 Mar 2024 18:53:30 +0100
Subject: [PATCH] Add date location index

---
 Resources/config/doctrine/Session.orm.yml | 3 +++
 1 file changed, 3 insertions(+)

diff --git a/Resources/config/doctrine/Session.orm.yml b/Resources/config/doctrine/Session.orm.yml
index 9631e93..fb1e962 100644
--- a/Resources/config/doctrine/Session.orm.yml
+++ b/Resources/config/doctrine/Session.orm.yml
@@ -70,6 +70,9 @@ Rapsys\AirBundle\Entity\Session:
         date_location_slot:
             columns: [ date, location_id, slot_id ]
     indexes:
+        #XXX: used in SessionRepository::findAllByPeriodAsCalendarArray
+        date_location:
+            columns: [ date, location_id ]
         #XXX: used in SessionRepository::findAllPendingApplication
         locked_date_begin_created:
             columns: [ locked, date, begin, created ]
-- 
2.41.0