skip expired users

[virtual-ldap] / sql / organizationalunit.sql

diff --git a/sql/organizationalunit.sql b/sql/organizationalunit.sql
index 21d4912..d87aa38 100644 (file)
--- a/sql/organizationalunit.sql
+++ b/sql/organizationalunit.sql
@@ -1,8 +1,10 @@
 
 select
-       concat('ou=',c.categorycode,'dc=ffzg,dc=hr')    as dn,
+       concat('ou=',c.categorycode,',dc=ffzg,dc=hr')   as dn,
        'organizationalunit'            as objectClass,
        c.categorycode                  as ou,
-       c.description                   as description
+       c.description                   as description,
+       -- fake for SafeQ, we don't have numeric primary key
+       crc32(categorycode) % 1000      as objectGUID
 from categories c