[Noalyss-commit] [noalyss] 02/12: SQL : improve vw_fiche_attr with index

[Dany De Bontridder]

sparkyx pushed a commit to branch master
in repository noalyss.

commit df45c20cf88778db1b6bd559160ccd8c7e7788e4
Author: sparkyx <danydb@noalyss.eu>
AuthorDate: Fri Dec 11 15:37:30 2020 +0100

    SQL : improve vw_fiche_attr with index
---
 sql/upgrade.sql | 3 +++
 1 file changed, 3 insertions(+)

diff --git a/sql/upgrade.sql b/sql/upgrade.sql
index e69de29..db56945 100644
--- a/sql/upgrade.sql
+++ b/sql/upgrade.sql
@@ -0,0 +1,3 @@
+-- improve vw_fiche_attr
+drop index if exists fiche_detail_attr_ix;
+create index fiche_detail_attr_ix on fiche_detail (ad_id);