From 9309eaba0d6e5efa85d33be95f0a23f2df2e4228 Mon Sep 17 00:00:00 2001
From: =?utf8?q?Rapha=C3=ABl=20Gertz?= <git@rapsys.eu>
Date: Fri, 8 Mar 2024 01:40:10 +0100
Subject: [PATCH 1/1] Update zipcode index with two leading characters

---
 Resources/config/doctrine/Location.orm.yml | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

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']
-- 
2.41.1