X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=ut%2Fcheckdb.php;h=e4eecf0ffd2955f9739bbb3e89f065367188487a;hb=93f23312418c86648de4f533be16d143e0cdb305;hp=7455441d2d745722d6e82075d01398debea9d2c2;hpb=12262f1306059765d8625a6752364679c8625d31;p=platal.git

diff --git a/ut/checkdb.php b/ut/checkdb.php
index 7455441..e4eecf0 100644
--- a/ut/checkdb.php
+++ b/ut/checkdb.php
@@ -87,11 +87,11 @@ class CheckDB extends PlTestCase
                        HAVING  c > 1'),
 
             'google apps' =>
-                array('SELECT  a.alias, g.g_status, eo.storage
-                         FROM  email_options  AS eo
-                   INNER JOIN  aliases        AS a ON (a.uid = eo.uid AND a.type = \'a_vie\')
-                   INNER JOIN  gapps_accounts AS g ON (g.l_userid = eo.uid)
-                        WHERE  FIND_IN_SET(\'googleapps\', eo.storage) > 0 AND g.g_status != \'active\'')
+                array('SELECT  s.email, g.g_status, r.redirect
+                         FROM  email_redirect_account AS r
+                   INNER JOIN  email_source_account   AS s ON (r.uid = s.uid AND s.type = \'forlife\')
+                   INNER JOIN  gapps_accounts         AS g ON (g.l_userid = r.uid)
+                        WHERE  r.type = \'googleapps\' AND r.flags = \'active\' AND g.g_status != \'active\'')
         );
 
         $tests = array(