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