virtual-ldap/sql/organizationalunit.sql


select
        concat('ou=',categorycode)      as dn,
        'top
        organizationalUnit'             as objectClass,
        categorycode                    as ou,
        description                     as description,

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

from categories
1
2	select
3	concat('ou=',categorycode) as dn,
4	'top
5	organizationalUnit' as objectClass,
6	categorycode as ou,
7	description as description,
8
9	-- fake objectGUID since we don't have primary key
10	crc32(categorycode) as objectGUID
11
12	from categories