COmanage Developers List

Author: benno
Date: 2012-04-18 23:01:28 -0400 (Wed, 18 Apr 2012)
New Revision: 286

Modified:
   demo/trunk/demo.sql
Log:
Fix demo LDAP SQL

Modified: demo/trunk/demo.sql
===================================================================
--- demo/trunk/demo.sql 2012-04-16 23:40:21 UTC (rev 285)
+++ demo/trunk/demo.sql 2012-04-19 03:01:28 UTC (rev 286)
@@ -90,7 +90,7 @@
 --LEFT JOIN   cm_email_addresses AS e
 --ON          cops.co_person_role_id=e.co_person_role_id
 --LEFT JOIN   cm_telephone_numbers AS t
---ON          cops.co_person_role_id=t.co_person_role_id
+--ON          cops.co_q_role_id=t.co_person_role_id
 --LEFT JOIN   cm_identifiers as i
 --ON          cops.org_identity_id=i.org_identity_id
 --WHERE       i.login=1
@@ -294,3 +294,6 @@
        entry_id integer not null references ldap_entries(id),
        oc_name varchar(64)
  );
+
+-- This enables search filtering by objectclass
+insert into ldap_entry_objclasses (entry_id, oc_name) values (1,'person');