/[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 47 by dpavlin, Fri Apr 17 21:39:45 2009 UTC revision 60 by dpavlin, Fri Nov 13 12:43:47 2009 UTC
# Line 1  Line 1 
1    
2  select  select
3          concat('uid=',trim(userid))                     as dn,          concat('uid=',trim(userid),',ou=',categorycode,',dc=ffzg,dc=hr')        as dn,
4          'person          'person
5          organizationalPerson          organizationalPerson
6          inetOrgPerson          inetOrgPerson
# 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,
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.47  
changed lines
  Added in v.60
  ViewVC Help
Powered by ViewVC 1.1.26