From: Raphaël Gertz <git@rapsys.eu>
Date: Fri, 8 Mar 2024 00:40:10 +0000 (+0100)
Subject: Update zipcode index with two leading characters
X-Git-Tag: 0.4.0~14
X-Git-Url: https://git.rapsys.eu/airbundle/commitdiff_plain/9309eaba0d6e5efa85d33be95f0a23f2df2e4228?ds=inline;hp=28ffa9276b13abd463ef5bf926d8af2f5169d4fb

Update zipcode index with two leading characters
---

diff --git a/Resources/config/doctrine/Location.orm.yml b/Resources/config/doctrine/Location.orm.yml
index 9d26144..109ec98 100644
--- a/Resources/config/doctrine/Location.orm.yml
+++ b/Resources/config/doctrine/Location.orm.yml
@@ -60,6 +60,6 @@ Rapsys\AirBundle\Entity\Location:
             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 ]
+                lengths: [ ~, 2 ]
     lifecycleCallbacks:
         preUpdate: ['preUpdate']