projects
/
virtual-ldap
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
create organizationlUnit for each categorycode from Koha
[virtual-ldap]
/
sql
/
organizationalunit.sql
diff --git
a/sql/organizationalunit.sql
b/sql/organizationalunit.sql
index
7f010fc
..
21d4912
100644
(file)
--- a/
sql/organizationalunit.sql
+++ b/
sql/organizationalunit.sql
@@
-1,7
+1,8
@@
select
select
-
'ou=groups'
as dn,
+
concat('ou=',c.categorycode,'dc=ffzg,dc=hr')
as dn,
'organizationalunit' as objectClass,
'organizationalunit' as objectClass,
- 'groups' as ou,
- 'Groups from Koha' as description
+ c.categorycode as ou,
+ c.description as description
+from categories c