create view backups_on_dvds

git-svn-id: svn+ssh://llin/home/dpavlin/private/svn/BackupPC/trunk@365 8392b6e1-25fa-0310-8288-cc32f8e212ea

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,