X-Git-Url: https://pd.if.org/git/?a=blobdiff_plain;ds=sidebyside;f=db.sql;h=316f3e47ba42354640d334341d0771bafd12f0aa;hb=5b8d8e172ec79d54a03bf005f6151a583f450917;hp=eb7c461bcc426ec0bee8c4ab96db564cee1c128d;hpb=b3db43c1429f5f07f625f8a59ec51eba5057e0c8;p=zpackage

diff --git a/db.sql b/db.sql
index eb7c461..316f3e4 100644
--- a/db.sql
+++ b/db.sql
@@ -477,7 +477,10 @@ modified as (
 	select distinct
 	SS.path, 
 	SS.username, SS.uid, SS.groupname, SS.gid, SS.mode, SS.filetype,
-	SS.mtime, SS.hash, SS.configuration, SS.target, SS.device,
+	SS.mtime, SS.hash,
+	SS.configuration + case when OS.configuration = 1 then 2 else 0 end
+	as configuration,
+       	SS.target, SS.device,
 	OS.hash as ohash, SS.mds, OS.mds as omds
 	from syncstatus SS
 	join syncstatus OS