create organizationlUnit for each categorycode from Koha

[virtual-ldap] / sql / organizationalunit.sql

diff --git a/sql/organizationalunit.sql b/sql/organizationalunit.sql
index 7f010fc..21d4912 100644 (file)
--- 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