add syncinfo test for symlinks

[zpackage] / schema / syncinfo.sql

diff --git a/schema/syncinfo.sql b/schema/syncinfo.sql
index cbdffce45ba2018b8e06ca70162bb806a5d717d0..1a76c263c9716a7cd92cde8c95d7cf5acebce9cd 100644 (file)
--- 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'