added while loop since we are starting from rc.local

[virtual-ldap] / sql / organizationalunit.sql

select
        concat('ou=',c.categorycode,',dc=ffzg,dc=hr')   as dn,
        'organizationalunit'            as objectClass,
        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