From: Raphaël Gertz <git@rapsys.eu>
Date: Mon, 24 Oct 2022 08:06:17 +0000 (+0200)
Subject: Add city_zipcode3 index
X-Git-Tag: 0.3.0~151
X-Git-Url: https://git.rapsys.eu/.gitweb.cgi/airbundle/commitdiff_plain/a6a7f8d7586fe24b0af6df0bfec34c86036dbef7?ds=inline;hp=47ac0123a276b130162a20175bb540830860e25c

Add city_zipcode3 index
---

diff --git a/Resources/config/doctrine/Location.orm.yml b/Resources/config/doctrine/Location.orm.yml
index ba031a0..9d26144 100644
--- a/Resources/config/doctrine/Location.orm.yml
+++ b/Resources/config/doctrine/Location.orm.yml
@@ -56,5 +56,10 @@ Rapsys\AirBundle\Entity\Location:
         #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']