create view backups_on_dvds

[BackupPC.git] / sql / backups_on_dvds.sql

diff --git a/sql/backups_on_dvds.sql b/sql/backups_on_dvds.sql
index acab92b..761dfb1 100644 (file)
--- 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,