/[virtual-ldap]/sql/hreduperson.sql
This is repository of my old source code which isn't updated any more. Go to git.rot13.org for current projects!
ViewVC logotype

Diff of /sql/hreduperson.sql

Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

revision 59 by dpavlin, Tue May 5 16:06:45 2009 UTC revision 60 by dpavlin, Fri Nov 13 12:43:47 2009 UTC
# Line 12  select Line 12  select
12          concat(firstname,' ',surname)                   as cn,          concat(firstname,' ',surname)                   as cn,
13    
14          -- SAFEQ specific mappings from UMgr-LDAP.conf          -- SAFEQ specific mappings from UMgr-LDAP.conf
15          borrowernumber                                  as objectGUID,          b.borrowernumber                                        as objectGUID,
16          surname                                         as displayName,          surname                                         as displayName,
17          rfid_sid                                        as pager,          a.attribute                                     as pager,
18          email                                           as mail,          email                                           as mail,
19          categorycode                                    as memberOf,          categorycode                                    as memberOf,
20          categorycode                                    as ou,          categorycode                                    as ou,
21          categorycode                                    as department,          categorycode                                    as department,
22          concat('/home/',borrowernumber)                 as homeDirectory          concat('/home/',b.borrowernumber)                       as homeDirectory
23  from borrowers  from borrowers b
24    left join borrower_attributes a on b.borrowernumber = a.borrowernumber and code='RFID_SID'
25    
26    
27    
Legend:
Removed from v.59  
changed lines
  Added in v.60
  ViewVC Help
Powered by ViewVC 1.1.26