X-Git-Url: http://git.inspyration.org/?p=zf2.biz%2Fgalerie.git;a=blobdiff_plain;f=data%2Fscripts%2Fschema.sql;h=ebf8a4b2a499182c7f044ff14481bb96d99ad316;hp=14a9f1f1bd666f9f927ae1bb3ad5700fc626a5ca;hb=12557cded4e09175aab9f520c3a27f4a194fa6b8;hpb=f455f9a21cfb9cf3bbd48022a757573af7e7c21e

diff --git a/data/scripts/schema.sql b/data/scripts/schema.sql
index 14a9f1f..ebf8a4b 100644
--- 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
+;