X-Git-Url: http://git.rot13.org/?p=virtual-ldap;a=blobdiff_plain;f=sql%2Forganizationalunit.sql;h=d87aa38aa2f048cb2970551d5830f0553e08b096;hp=24dbfc9f8be029cc72fcb20114c6f28100df3114;hb=df535c72d73502e74b72f4b4f1bbd6b1b7b629dc;hpb=33aa21f83590dc7189bbc67ecf660f9566facd11

diff --git a/sql/organizationalunit.sql b/sql/organizationalunit.sql
index 24dbfc9..d87aa38 100644
--- a/sql/organizationalunit.sql
+++ b/sql/organizationalunit.sql
@@ -1,12 +1,10 @@
 
 select
-	concat('ou=',categorycode)	as dn,
-	'top
-	organizationalUnit'		as objectClass,
-	categorycode			as ou,
-	description			as description,
+	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
 
-	-- fake objectGUID since we don't have primary key
-	crc32(categorycode)		as objectGUID
-
-from categories