X-Git-Url: http://git.rot13.org/?a=blobdiff_plain;ds=sidebyside;f=sql%2Fbackups_on_dvds.sql;fp=sql%2Fbackups_on_dvds.sql;h=761dfb1fbdb009e6c8b6af2ac447b273e4d52c9b;hb=d9578b0f7c2269b3658cae14b62ae4dd7bb6b7da;hp=acab92baa3b107b00e49dd1384d2e2e78b6609dc;hpb=a9b071009a7b3b922922176709e9153eb9ed52b0;p=BackupPC.git

diff --git a/sql/backups_on_dvds.sql b/sql/backups_on_dvds.sql
index acab92b..761dfb1 100644
--- a/sql/backups_on_dvds.sql
+++ b/sql/backups_on_dvds.sql
@@ -1,5 +1,6 @@
 -- report backups and corresponding dvd
 
+create view backups_on_dvds as
 select
 	backups.id as id,
 	hosts.name || ':' || shares.name as share,