]> Raphaël G. Git Repositories - airbundle/commitdiff
Add date location index
authorRaphaël Gertz <git@rapsys.eu>
Thu, 7 Mar 2024 17:53:30 +0000 (18:53 +0100)
committerRaphaël Gertz <git@rapsys.eu>
Thu, 7 Mar 2024 17:53:30 +0000 (18:53 +0100)
Resources/config/doctrine/Session.orm.yml

index 9631e932bcdb2d7dcb858d0d4b5b1814d87f589c..fb1e962ba00f7f5fd5eb52451995ea9c131db256 100644 (file)
@@ -70,6 +70,9 @@ Rapsys\AirBundle\Entity\Session:
         date_location_slot:
             columns: [ date, location_id, slot_id ]
     indexes:
         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 ]
         #XXX: used in SessionRepository::findAllPendingApplication
         locked_date_begin_created:
             columns: [ locked, date, begin, created ]