X-Git-Url: https://pd.if.org/git/?a=blobdiff_plain;f=schema%2Fsyncinfo.sql;h=1a76c263c9716a7cd92cde8c95d7cf5acebce9cd;hb=HEAD;hp=cbdffce45ba2018b8e06ca70162bb806a5d717d0;hpb=28ff0abf216c03268efedb6d43eb2d3e04c3e8aa;p=zpackage 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'