From 1b74aba3b3208deed91863e634ca74827dddfdc2 Mon Sep 17 00:00:00 2001
From: =?utf8?q?Rapha=C3=ABl=20Gertz?= <git@rapsys.eu>
Date: Tue, 8 Dec 2020 01:23:34 +0100
Subject: [PATCH] Add premium, rainfall, rainrisk, realfeel, realfeelmin,
 realfeelmax, temperature, temperaturemin, temperaturemax fields Add
 application_date_begin_slot_created index

---
 Resources/config/doctrine/Session.orm.yml | 33 ++++++++++++++++++++---
 1 file changed, 29 insertions(+), 4 deletions(-)

diff --git a/Resources/config/doctrine/Session.orm.yml b/Resources/config/doctrine/Session.orm.yml
index 68c6116..810c4a0 100644
--- a/Resources/config/doctrine/Session.orm.yml
+++ b/Resources/config/doctrine/Session.orm.yml
@@ -18,10 +18,32 @@ Rapsys\AirBundle\Entity\Session:
         length:
             type: time
             nullable: true
-#The day score, 1 for sun-thu, 2 for fri-sat, +1 for high temperature, *-1 for bad weather
-#        score:
-#            type: smallint
-#            nullable: true
+        premium:
+            type: boolean
+        rainfall:
+            type: float
+            nullable: true
+        rainrisk:
+            type: float
+            nullable: true
+        realfeel:
+            type: float
+            nullable: true
+        realfeelmin:
+            type: float
+            nullable: true
+        realfeelmax:
+            type: float
+            nullable: true
+        temperature:
+            type: float
+            nullable: true
+        temperaturemin:
+            type: float
+            nullable: true
+        temperaturemax:
+            type: float
+            nullable: true
         created:
             type: datetime
         updated:
@@ -43,3 +65,6 @@ Rapsys\AirBundle\Entity\Session:
     uniqueConstraints:
         date_location_slot:
             columns: [ date, location_id, slot_id ]
+    indexes:
+        application_date_begin_slot_created:
+            columns: [ application_id, date, begin, slot_id, created ]
-- 
2.41.0