X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=bin%2Fcron%2Fcheckdb.php;h=b891fec40ffe2ac27d794521f8b7972c6ff1f80a;hb=12a587df92f7bc9efeb91c1a2d27f763070b8609;hp=e86f9845b1f47b2e6cdcbea912a67b49f86fc39d;hpb=2af95f6f349a10ea8814b5d4a95bb571d649357a;p=platal.git diff --git a/bin/cron/checkdb.php b/bin/cron/checkdb.php index e86f984..b891fec 100755 --- a/bin/cron/checkdb.php +++ b/bin/cron/checkdb.php @@ -85,13 +85,6 @@ check("SELECT u.user_id, nom, prenom, promo, check("select uid from adresses where pub != 'private' and pub !='ax' and pub != 'public'", "Utiliseur n'ayant pas de flag de publicite pour une adresse"); check("select uid from tels where tel_pub != 'private' and tel_pub !='ax' and tel_pub != 'public'", "Utiliseur n'ayant pas de flag de publicite pour un numero de telephone"); -/* validite de adresses */ -check("select uid, count(adrid) from adresses group by uid having count(adrid) > 7", "Utilisateurs ayant trop d'adresses"); - -/* Validite des tables de langues, competences, mentoring*/ -check("select uid, count(lid) from langues_ins group by uid having count(lid) > 10","Utilisateurs ayant trop de langues"); -check("select uid, count(cid) from competences_ins group by uid having count(cid) > 20","Utilisateurs ayant trop de competences"); - /* validite de aliases */ check("SELECT a.* FROM aliases AS a