add metadata string to packagefiles view

[zpackage] / db.sql

diff --git a/db.sql b/db.sql
index 94ffce308a19b726172ff4e9e987d9ef24053750..2e34ad38b6f0fbfc67ba5fc82ba510fe242f3f27 100644 (file)
--- a/db.sql
+++ b/db.sql
@@ -145,7 +145,8 @@ without rowid
 ;
 
 create view packagefiles_pkgid as
-select printf('%s-%s-%s', package, version, release) as pkgid, *
+select printf('%s-%s-%s', package, version, release) as pkgid, *,
+printf('%s:%o:%s:%s', filetype, mode, username, groupname) as mds
 from packagefiles
 ;