Parent Directory | Revision Log
implement multiple values by keeping dn and repeating rows with changed attributes, implement organizationalunit and group with same attributes as Active Directory
1 | dpavlin | 48 | select |
2 | concat('cn=',c.categorycode,',ou=groups') as dn, | ||
3 | 'group' as objectClass, | ||
4 | 'groups' as ou, | ||
5 | c.categorycode as cn, | ||
6 | description as description, | ||
7 | |||
8 | concat('uid=',replace(userid,'@ffzg.hr',''),',ou=',c.categorycode,',dc=ffzg,dc=hr') as members | ||
9 | from categories c | ||
10 | join borrowers b on b.categorycode = c.categorycode | ||
11 | where length(userid) > 0 |
ViewVC Help | |
Powered by ViewVC 1.1.26 |