implement multiple values by keeping dn and repeating rows with changed

[virtual-ldap] / sql / organizationalunit.sql

diff --git a/sql/organizationalunit.sql b/sql/organizationalunit.sql
index 24dbfc9..7f010fc 100644 (file)
--- a/sql/organizationalunit.sql
+++ b/sql/organizationalunit.sql
@@ -1,12 +1,7 @@
 
 select
 
 select

-       concat('ou=',categorycode)      as dn,
-       'top
-       organizationalUnit'             as objectClass,
-       categorycode                    as ou,
-       description                     as description,
+       'ou=groups'                     as dn,
+       'organizationalunit'            as objectClass,
+       'groups'                        as ou,
+       'Groups from Koha'              as description

 
 

-       -- fake objectGUID since we don't have primary key
-       crc32(categorycode)             as objectGUID
-
-from categories