X-Git-Url: http://git.rot13.org/?p=virtual-ldap;a=blobdiff_plain;f=sql%2Forganizationalunit.sql;h=d87aa38aa2f048cb2970551d5830f0553e08b096;hp=8c07ff90261b7593863bfdb318109a2f9c919f8d;hb=df535c72d73502e74b72f4b4f1bbd6b1b7b629dc;hpb=8166d09ec62b25bdd1f6f046d91b92470740309d;ds=sidebyside

diff --git a/sql/organizationalunit.sql b/sql/organizationalunit.sql
index 8c07ff9..d87aa38 100644
--- a/sql/organizationalunit.sql
+++ b/sql/organizationalunit.sql
@@ -3,6 +3,8 @@ select
 	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