git.rot13.org Git - virtual-ldap/blob - 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