X-Git-Url: http://git.rot13.org/?p=virtual-ldap;a=blobdiff_plain;f=sql%2Fhreduperson.sql;h=568e5f53dbd8b1d469f4b27db03382416013f6d3;hp=d0eb0580c769bf8c47932e2cc4acd743d0933b5b;hb=8166d09ec62b25bdd1f6f046d91b92470740309d;hpb=33aa21f83590dc7189bbc67ecf660f9566facd11

diff --git a/sql/hreduperson.sql b/sql/hreduperson.sql
index d0eb058..568e5f5 100644
--- 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