Add date location index

[airbundle] / Resources / config / doctrine / Location.orm.yml

diff --git a/Resources/config/doctrine/Location.orm.yml b/Resources/config/doctrine/Location.orm.yml
index 0cb8dfca3870c3763015fa925a71f9223e4d472c..9d261442e0dd6be5c47913e52bba2399cfd8327c 100644 (file)
--- a/Resources/config/doctrine/Location.orm.yml
+++ b/Resources/config/doctrine/Location.orm.yml
@@ -13,6 +13,9 @@ Rapsys\AirBundle\Entity\Location:
         title:
             type: string
             length: 32
         title:
             type: string
             length: 32

+        description:
+            type: text
+            nullable: true

         address:
             type: string
             length: 32
         address:
             type: string
             length: 32


@@ -30,6 +33,8 @@ Rapsys\AirBundle\Entity\Location:
             type: decimal
             precision: 9
             scale: 6
             type: decimal
             precision: 9
             scale: 6

+        indoor:
+            type: boolean

         hotspot:
             type: boolean
         created:
         hotspot:
             type: boolean
         created:


@@ -51,5 +56,10 @@ Rapsys\AirBundle\Entity\Location:
         #XXX: used in SessionRepository::(findAllPendingDailyWeather|findAllPendingHourlyWeather)
         zipcode:
             columns: [ zipcode ]
         #XXX: used in SessionRepository::(findAllPendingDailyWeather|findAllPendingHourlyWeather)
         zipcode:
             columns: [ zipcode ]

+        city_zipcode3:
+            columns: [ city, zipcode ]
+            #XXX: see https://github.com/doctrine/dbal/pull/2412 and https://stackoverflow.com/questions/32539973/configuring-index-text-length-mysql-in-doctrine
+            options:
+                lengths: [ ~, 3 ]

     lifecycleCallbacks:
         preUpdate: ['preUpdate']
     lifecycleCallbacks:
         preUpdate: ['preUpdate']