X-Git-Url: http://git.rot13.org/?p=virtual-ldap;a=blobdiff_plain;f=sql%2Forganizationalunit.sql;h=d87aa38aa2f048cb2970551d5830f0553e08b096;hp=7f010fc84bbf9c0c249a20ba56511ad5e01c101f;hb=ae9edb3fcef1370d28ed71ed7830d0fa0d2fc657;hpb=73b88761ef8b4801dddb2a8117dcaab4b98a9545

diff --git a/sql/organizationalunit.sql b/sql/organizationalunit.sql
index 7f010fc..d87aa38 100644
--- a/sql/organizationalunit.sql
+++ b/sql/organizationalunit.sql
@@ -1,7 +1,10 @@
 
 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,
+	-- fake for SafeQ, we don't have numeric primary key
+	crc32(categorycode) % 1000	as objectGUID
+from categories c