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	dpavlin	47
2			select
3	dpavlin	55	concat('uid=',trim(userid),',ou=',categorycode,',dc=ffzg,dc=hr') as dn,
4	dpavlin	47	'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	dpavlin	54	categorycode as memberOf,
20			categorycode as ou,
21	dpavlin	56	categorycode as department,
22	dpavlin	47	concat('/home/',borrowernumber) as homeDirectory
23			from borrowers
24