X-Git-Url: https://git.rapsys.eu/airbundle/blobdiff_plain/d442deb5f5c4f965819cbb0e290d95b702ab1db0..98d9c3dc2b46ac796418794aae53b20925d45a8b:/Resources/config/doctrine/Location.orm.yml?ds=sidebyside

diff --git a/Resources/config/doctrine/Location.orm.yml b/Resources/config/doctrine/Location.orm.yml
index 303a51b..9d26144 100644
--- a/Resources/config/doctrine/Location.orm.yml
+++ b/Resources/config/doctrine/Location.orm.yml
@@ -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,8 @@ Rapsys\AirBundle\Entity\Location:
             type: decimal
             precision: 9
             scale: 6
+        indoor:
+            type: boolean
         hotspot:
             type: boolean
         created:
@@ -43,7 +45,21 @@ Rapsys\AirBundle\Entity\Location:
         sessions:
             targetEntity: Rapsys\AirBundle\Entity\Session
             mappedBy: location
+        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: [ ~, 3 ]
+    lifecycleCallbacks:
+        preUpdate: ['preUpdate']