Update zipcode index with two leading characters

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

diff --git a/Resources/config/doctrine/Location.orm.yml b/Resources/config/doctrine/Location.orm.yml
index 0b276fa48130917269aecf75d05f3b32451787d8..109ec98cb8c5d27d1109c4c111d8e39bf9961900 100644 (file)
--- a/Resources/config/doctrine/Location.orm.yml
+++ b/Resources/config/doctrine/Location.orm.yml
@@ -1,6 +1,6 @@
 Rapsys\AirBundle\Entity\Location:
     type: entity
-    #repositoryClass: Rapsys\AirBundle\Repository\LocationRepository
+    repositoryClass: Rapsys\AirBundle\Repository\LocationRepository
     table: locations
     id:
         id:
@@ -13,9 +13,9 @@ Rapsys\AirBundle\Entity\Location:
         title:
             type: string
             length: 32
-        short:
-            type: string
-            length: 16
+        description:
+            type: text
+            nullable: true
         address:
             type: string
             length: 32
@@ -33,6 +33,10 @@ Rapsys\AirBundle\Entity\Location:
             type: decimal
             precision: 9
             scale: 6
+        indoor:
+            type: boolean
+        hotspot:
+            type: boolean
         created:
             type: datetime
         updated:
@@ -41,32 +45,21 @@ Rapsys\AirBundle\Entity\Location:
         sessions:
             targetEntity: Rapsys\AirBundle\Entity\Session
             mappedBy: location
-
-#        manyToOne:
-#                title:
-#                        targetEntity: Rapsys\UserBundle\Entity\Title
-#                        inversedBy: users
-#        manyToMany:
-#                groups:
-#                        targetEntity: Rapsys\UserBundle\Entity\Group
-#                        inversedBy: users
-#                        joinTable:
-#                                name: groups_users
-#
-#        manyToOne:
-#                site:
-#                        targetEntity: Rapsys\BlogBundle\Entity\Site
-#                        inversedBy: articles
-#                author:
-#                        targetEntity: Rapsys\BlogBundle\Entity\Author
-#                        inversedBy: articles
-#        manyToMany:
-#                keywords:
-#                        targetEntity: Rapsys\BlogBundle\Entity\Keyword
-#                        inversedBy: articles
-#                        joinTable:
-#                                name: articles_keywords
-#        oneToMany:
-#                article_translations:
-#                        targetEntity: Rapsys\BlogBundle\Entity\ArticleTranslation
-#                        mappedBy: article
+        snippets:
+            targetEntity: Rapsys\AirBundle\Entity\Snippet
+            mappedBy: location
+    manyToMany:
+        users:
+            targetEntity: Rapsys\AirBundle\Entity\User
+            mappedBy: locations
+    indexes:
+        #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: [ ~, 2 ]
+    lifecycleCallbacks:
+        preUpdate: ['preUpdate']