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	dpavlin	47
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