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

1	dpavlin	47
2			select
3	dpavlin	55	concat('ou=',c.categorycode,',dc=ffzg,dc=hr') as dn,
4	dpavlin	48	'organizationalunit' as objectClass,
5	dpavlin	54	c.categorycode as ou,
6	dpavlin	57	c.description as description,
7			-- fake for SafeQ, we don't have numeric primary key
8			crc32(categorycode) % 1000 as objectGUID
9	dpavlin	54	from categories c
10	dpavlin	47