From: Raphaël Gertz <git@rapsys.eu>
Date: Thu, 7 Mar 2024 17:53:30 +0000 (+0100)
Subject: Add date location index
X-Git-Tag: 0.4.0~60
X-Git-Url: https://git.rapsys.eu/airbundle/commitdiff_plain/f1d9cc59cfc96d5ee76e48d7a9569bb329cad501?hp=aa750ca8852817fd46b2b3963a77e4586637b65f

Add date location index
---

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 ]