X-Git-Url: https://pd.if.org/git/?p=zpackage;a=blobdiff_plain;f=schema%2Fsyncinfo.sql;h=1a76c263c9716a7cd92cde8c95d7cf5acebce9cd;hp=cbdffce45ba2018b8e06ca70162bb806a5d717d0;hb=ff5642a271350490e758b206b1c57afb42f93d07;hpb=2d4d941e7a05a98755c2ba96426a444e6645432a diff --git a/schema/syncinfo.sql b/schema/syncinfo.sql index cbdffce..1a76c26 100644 --- a/schema/syncinfo.sql +++ b/schema/syncinfo.sql @@ -78,7 +78,14 @@ PC.status not in ('installed','removing','updating') union select case -when PFI.filetype is PFC.filetype +when PFI.filetype is not 'l' + and PFI.filetype is PFC.filetype + and PFI.mode is PFC.mode and PFI.username is PFC.username + and PFI.groupname is PFC.groupname and PFI.hash is PFC.hash + then 'noop' +when PFI.filetype is 'l' + and PFI.target is PFC.target + and PFI.filetype is PFC.filetype and PFI.mode is PFC.mode and PFI.username is PFC.username and PFI.groupname is PFC.groupname and PFI.hash is PFC.hash then 'noop'