Rajout de l'export CSV

[zf2.biz/galerie.git] / data / scripts / schema.sql

diff --git a/data/scripts/schema.sql b/data/scripts/schema.sql
index 14a9f1f..ebf8a4b 100644 (file)
--- a/data/scripts/schema.sql
+++ b/data/scripts/schema.sql
@@ -215,3 +215,10 @@ BEGIN
     END;
 END;
 
+CREATE VIEW gallery_info AS
+    SELECT gallery.id, gallery.name, gallery.description, user.firstname || ' ' || user.lastname AS username, count(photo.id) as nb
+    INNER JOIN user ON gallery.id_user = user.id
+    LEFT JOIN photo ON gallery.id = photo.id_gallery
+    GROUP BY user.lastname, user.firstname, gallery.name
+    ORDER BY user.lastname, user.firstname, gallery.name
+;