replace CR and LF in RFID_SID
[virtual-ldap] / sql / hreduperson.sql
1
2 select
3         concat('uid=',trim(userid),',ou=',categorycode,',dc=ffzg,dc=hr')        as dn,
4         'person
5         organizationalPerson
6         inetOrgPerson
7         hrEduPerson'                                    as objectClass,
8
9         trim(userid)                                    as uid,
10         firstname                                       as givenName,
11         surname                                         as sn,
12         concat(firstname,' ',surname)                   as cn,
13
14         -- SAFEQ specific mappings from UMgr-LDAP.conf
15         b.borrowernumber                                        as objectGUID,
16         surname                                         as displayName,
17         a.attribute                                     as pager,
18         email                                           as mail,
19         categorycode                                    as memberOf,
20         categorycode                                    as ou,
21         categorycode                                    as department,
22         concat('/home/',b.borrowernumber)                       as homeDirectory
23 from borrowers b
24 left join borrower_attributes a on b.borrowernumber = a.borrowernumber and code='RFID_SID'
25
26
27