X-Git-Url: https://git.rapsys.eu/airbundle/blobdiff_plain/be821fb6ac6f0ddb4f6a31c257314d6b81557c2e..5ec45cd7fa8b353f4f211c0abfcc0c875a938c7e:/Resources/config/doctrine/Session.orm.yml?ds=sidebyside

diff --git a/Resources/config/doctrine/Session.orm.yml b/Resources/config/doctrine/Session.orm.yml
index 810c4a0..fb1e962 100644
--- a/Resources/config/doctrine/Session.orm.yml
+++ b/Resources/config/doctrine/Session.orm.yml
@@ -20,6 +20,7 @@ Rapsys\AirBundle\Entity\Session:
             nullable: true
         premium:
             type: boolean
+            nullable: true
         rainfall:
             type: float
             nullable: true
@@ -44,6 +45,9 @@ Rapsys\AirBundle\Entity\Session:
         temperaturemax:
             type: float
             nullable: true
+        locked:
+            type: datetime
+            nullable: true
         created:
             type: datetime
         updated:
@@ -66,5 +70,26 @@ Rapsys\AirBundle\Entity\Session:
         date_location_slot:
             columns: [ date, location_id, slot_id ]
     indexes:
-        application_date_begin_slot_created:
-            columns: [ application_id, date, begin, slot_id, created ]
+        #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::findBestApplicationById(s3)
+        application_locked_date_begin_slot_created:
+            columns: [ application_id, locked, date, begin, slot_id, created ]
+        #XXX: candidated in findAllPendingDailyWeather and findAllPendingHourlyWeather
+        location_date_begin_length_slot:
+            columns: [ location_id, date, begin, length, slot_id ]
+#        #XXX: tried for SessionRepository::findBestApplicationById(s2)
+#        location_slot_application_locked_date_begin:
+#            columns: [ location_id, slot_id, application_id, locked, date ]
+#        #XXX: tried for SessionRepository::findBestApplicationById(s3)
+#        application_locked_date:
+#            columns: [ application_id, locked, date ]
+#        #XXX: tried for SessionRepository::findBestApplicationById(s4)
+#        location_application_locked_date:
+#            columns: [ location_id, application_id, locked, date ]
+    lifecycleCallbacks:
+        preUpdate: ['preUpdate']