git.rot13.org Git - virtual-ldap/blob - sql/hreduperson.sql

   1
   2 select
   3         concat('uid=',trim(userid))                     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         borrowernumber                                  as objectGUID,
  16         surname                                         as displayName,
  17         rfid_sid                                        as pager,
  18         email                                           as mail,
  19         categorycode                                    as memberOf,
  20         categorycode                                    as ou,
  21         concat('/home/',borrowernumber)                 as homeDirectory
  22 from borrowers
  23