virtual-ldap/sql/hreduperson.sql


select
        concat('uid=',trim(userid),',ou=',categorycode,',dc=ffzg,dc=hr')        as dn,
        'person
        organizationalPerson
        inetOrgPerson
        hrEduPerson'                                    as objectClass,

        trim(userid)                                    as uid,
        firstname                                       as givenName,
        surname                                         as sn,
        concat(firstname,' ',surname)                   as cn,

        -- SAFEQ specific mappings from UMgr-LDAP.conf
        borrowernumber                                  as objectGUID,
        surname                                         as displayName,
        rfid_sid                                        as pager,
        email                                           as mail,
        categorycode                                    as memberOf,
        categorycode                                    as ou,
        categorycode                                    as department,
        concat('/home/',borrowernumber)                 as homeDirectory
from borrowers

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	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	categorycode as department,
22	concat('/home/',borrowernumber) as homeDirectory
23	from borrowers
24