X-Git-Url: http://git.rot13.org/?p=virtual-ldap;a=blobdiff_plain;f=sql%2Forganizationalunit.sql;h=21d4912545373bd9342933ced41867262eecdc22;hp=7f010fc84bbf9c0c249a20ba56511ad5e01c101f;hb=81326d819a2f6c6fdd076087f54fb82c3a44739e;hpb=b3ce3ad0c105c022cc9b048a5f93c7eaaa0f4931;ds=sidebyside

diff --git a/sql/organizationalunit.sql b/sql/organizationalunit.sql
index 7f010fc..21d4912 100644
--- a/sql/organizationalunit.sql
+++ b/sql/organizationalunit.sql
@@ -1,7 +1,8 @@
 
 select
-	'ou=groups'			as dn,
+	concat('ou=',c.categorycode,'dc=ffzg,dc=hr')	as dn,
 	'organizationalunit'		as objectClass,
-	'groups'			as ou,
-	'Groups from Koha'		as description
+	c.categorycode			as ou,
+	c.description			as description
+from categories c