-/* Validite des flags de transmission */
-check("SELECT u.user_id, nom, prenom, promo,
- emails_alias_pub, profile_freetext_pub, profile_medals_pub
- FROM auth_user_md5 AS u
- INNER JOIN auth_user_quick AS q USING(user_id)
- WHERE (emails_alias_pub != 'private' AND emails_alias_pub != 'public')
- OR (profile_freetext_pub != 'private' AND profile_freetext_pub != 'public')
- OR (profile_medals_pub != 'private' AND profile_medals_pub != 'public')",
- "Utilisateur n'ayant pas de flag de publicite pour leurs donnees de profil");
-check("SELECT pid
- FROM profile_addresses
- WHERE pub != 'private' AND pub !='ax' AND pub != 'public'",
- "Utiliseur n'ayant pas de flag de publicité pour une adresse.");
-check("select uid from profile_phones where pub != 'private' and pub != 'ax' and pub != 'public'", "Utiliseur n'ayant pas de flag de publicite pour un numero de téléphone");
-check("select uid from profile_networking where pub != 'private' and pub != 'public'", "Utiliseur n'ayant pas de flag de publicité pour une adresse de networking");
-
-/* validite des hruid */
-check("SELECT user_id, nom, prenom, promo FROM auth_user_md5 WHERE hruid IS NULL OR hruid = ''",
- "Utilisateur n'ayant pas de hruid.");
-
-/* validite de aliases */
-check("SELECT a.*
- FROM aliases AS 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 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");
-check("select b.* from binets_ins as b left join binets_def as bd on bd.id=b.binet_id where bd.text is null");
-
-/* validite de contacts */
-check("select c.* from contacts as c left join auth_user_md5 as u on u.user_id=c.uid where u.prenom is null");
-check("select c.* from contacts as c left join auth_user_md5 as u on u.user_id=c.contact where u.prenom is null");
+/* Checks rewriting on deleted aliases. */
+check("SELECT a.alias, e.email, e.rewrite AS broken
+ FROM aliases AS a
+ INNER JOIN emails AS e ON (a.uid = e.uid AND rewrite != '')
+ LEFT JOIN aliases AS b ON (b.uid = a.uid AND rewrite LIKE CONCAT(b.alias, '@%') AND b.type != 'homonyme')
+ WHERE a.type = 'a_vie' AND b.type IS NULL",
+ "Personnes qui ont des rewrite sur un alias perdu.");