Update zipcode index with two leading characters

diff --git a/Resources/config/doctrine/Location.orm.yml b/Resources/config/doctrine/Location.orm.yml
index 9d261442e0dd6be5c47913e52bba2399cfd8327c..109ec98cb8c5d27d1109c4c111d8e39bf9961900 100644 (file)
--- 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']