X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=bin%2Fcron%2Fcheckdb.php;h=66b74aad3a1a476ab00e6ce1544aae08ec96a9f4;hb=043bbacf7d5ceaeba4db582ac0ea7c75d6f13c80;hp=510381780ee56c419e80aa5620eeec0a0090a982;hpb=7f12e3b4113791f3372f11572a205925d7bb6b97;p=platal.git diff --git a/bin/cron/checkdb.php b/bin/cron/checkdb.php index 5103817..66b74aa 100755 --- a/bin/cron/checkdb.php +++ b/bin/cron/checkdb.php @@ -90,9 +90,9 @@ check("SELECT a.* LEFT JOIN auth_user_md5 AS u ON u.user_id=a.id WHERE (a.type='alias' OR a.type='a_vie') AND u.prenom is null"); -/* validite de applis_ins */ -check("select a.* from applis_ins as a left join auth_user_md5 as u on u.user_id=a.uid where u.prenom is null"); -check("select a.* from applis_ins as a left join applis_def as ad on ad.id=a.aid where ad.text is null"); +/* validite de profile_education */ +check("select a.* from profile_education as a left join auth_user_md5 as u on u.user_id=a.uid where u.prenom is null"); +check("select a.* from profile_education as a left join profile_education_enum as ad on ad.id=a.eduid where ad.name is null"); /* validite de binet_users */ check("select b.* from binets_ins as b left join auth_user_md5 as u on u.user_id=b.user_id where u.prenom is null");