From d442deb5f5c4f965819cbb0e290d95b702ab1db0 Mon Sep 17 00:00:00 2001
From: =?utf8?q?Rapha=C3=ABl=20Gertz?= <git@rapsys.eu>
Date: Sun, 13 Dec 2020 22:54:38 +0100
Subject: [PATCH 1/1] Add hotspot Cleanup Add zipcode index

---
 Resources/config/doctrine/Location.orm.yml | 35 ++++------------------
 1 file changed, 6 insertions(+), 29 deletions(-)

diff --git a/Resources/config/doctrine/Location.orm.yml b/Resources/config/doctrine/Location.orm.yml
index abed5dd..303a51b 100644
--- a/Resources/config/doctrine/Location.orm.yml
+++ b/Resources/config/doctrine/Location.orm.yml
@@ -33,6 +33,8 @@ Rapsys\AirBundle\Entity\Location:
             type: decimal
             precision: 9
             scale: 6
+        hotspot:
+            type: boolean
         created:
             type: datetime
         updated:
@@ -41,32 +43,7 @@ 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
+    indexes:
+        #XXX: used in SessionRepository::(findAllPendingDailyWeather|findAllPendingHourlyWeather)
+        zipcode:
+            columns: [ zipcode ]
-- 
2.41.1