split out sql queries into own files for easier

[virtual-ldap] / sql / organizationalunit.sql

diff --git a/sql/organizationalunit.sql b/sql/organizationalunit.sql
new file mode 100644 (file)
index 0000000..24dbfc9
--- /dev/null
+++ b/sql/organizationalunit.sql
@@ -0,0 +1,12 @@
+
+select
+       concat('ou=',categorycode)      as dn,
+       'top
+       organizationalUnit'             as objectClass,
+       categorycode                    as ou,
+       description                     as description,
+
+       -- fake objectGUID since we don't have primary key
+       crc32(categorycode)             as objectGUID
+
+from categories