X-Git-Url: http://git.rot13.org/?a=blobdiff_plain;f=sql%2Forganizationalunit.sql;h=d87aa38aa2f048cb2970551d5830f0553e08b096;hb=9db13acebc545f239943a56a6bd5086b84d95100;hp=21d4912545373bd9342933ced41867262eecdc22;hpb=81326d819a2f6c6fdd076087f54fb82c3a44739e;p=virtual-ldap

diff --git a/sql/organizationalunit.sql b/sql/organizationalunit.sql
index 21d4912..d87aa38 100644
--- a/sql/organizationalunit.sql
+++ b/sql/organizationalunit.sql
@@ -1,8 +1,10 @@
 
 select
-	concat('ou=',c.categorycode,'dc=ffzg,dc=hr')	as dn,
+	concat('ou=',c.categorycode,',dc=ffzg,dc=hr')	as dn,
 	'organizationalunit'		as objectClass,
 	c.categorycode			as ou,
-	c.description			as description
+	c.description			as description,
+	-- fake for SafeQ, we don't have numeric primary key
+	crc32(categorycode) % 1000	as objectGUID
 from categories c