From 5750aee20b594a3dd7401bca873f2e7b41b9cfa7 Mon Sep 17 00:00:00 2001 From: Nathan Wagner Date: Fri, 28 Sep 2018 22:51:16 +0000 Subject: [PATCH] add metadata string to packagefiles view --- db.sql | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) 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 ; -- 2.40.0