put categorycode also in department attribute

[virtual-ldap] / sql / hreduperson.sql

diff --git a/sql/hreduperson.sql b/sql/hreduperson.sql
index d0eb058..568e5f5 100644 (file)
--- a/sql/hreduperson.sql
+++ b/sql/hreduperson.sql
@@ -1,6 +1,6 @@
 
 select
-       concat('uid=',trim(userid))                     as dn,
+       concat('uid=',trim(userid),',ou=',categorycode,',dc=ffzg,dc=hr')        as dn,
        'person
        organizationalPerson
        inetOrgPerson
@@ -16,7 +16,8 @@ select
        surname                                         as displayName,
        rfid_sid                                        as pager,
        email                                           as mail,
---     categorycode                                    as memberOf,
+       categorycode                                    as memberOf,
+       categorycode                                    as ou,
        categorycode                                    as department,
        concat('/home/',borrowernumber)                 as homeDirectory
 from borrowers