COmanage Developers List

Author: benno
Date: 2012-08-04 10:46:15 -0400 (Sat, 04 Aug 2012)
New Revision: 331

Modified:
   demo/trunk/demo.sql
Log:
Update demo.sql to match revisions to cm_identifiers

Modified: demo/trunk/demo.sql
===================================================================
--- demo/trunk/demo.sql 2012-07-30 06:01:52 UTC (rev 330)
+++ demo/trunk/demo.sql 2012-08-04 14:46:15 UTC (rev 331)
@@ -59,9 +59,9 @@
 LEFT JOIN   cm_identifiers AS i
 ON          coil.org_identity_id=i.org_identity_id
 WHERE       i.login=1
-AND         i.type='EP'
-AND         cop.status='A'
-AND         copr.status='A'
+AND         i.type='eppn'
+AND         cop.status IN ('A', 'Y')
+AND         copr.status IN ('A', 'Y')
 AND         (copr.valid_from <= now() || copr.valid_from IS NULL)
 AND         (copr.valid_through >= now() || copr.valid_through IS NULL);