X-Git-Url: https://pd.if.org/git/?a=blobdiff_plain;f=db.sql;h=2e34ad38b6f0fbfc67ba5fc82ba510fe242f3f27;hb=8d39ba5617367d688e653ab40192a9c7f9a5c187;hp=94ffce308a19b726172ff4e9e987d9ef24053750;hpb=51a6d79f8a532376a9f27dbb5133bf13a5474703;p=zpackage

diff --git a/db.sql b/db.sql
index 94ffce3..2e34ad3 100644
--- 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
 ;