X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;ds=inline;f=bin%2Fcron%2Fclean.php;h=6325f63aff95a32f1575ea92f17d2b035eec1e98;hb=2db80ab6f7d054ec274c66f7ba983f49596b81cf;hp=ce90f01ee6071306ac38e93b4ffaa79603b44443;hpb=8d84c630f353ef0534e02325507ed35cc2f0d28f;p=platal.git diff --git a/bin/cron/clean.php b/bin/cron/clean.php index ce90f01..6325f63 100755 --- a/bin/cron/clean.php +++ b/bin/cron/clean.php @@ -37,10 +37,12 @@ query("DELETE FROM register_pending WHERE TO_DAYS(NOW()) - TO_DAYS(date) >= 365" query("DELETE FROM register_pending WHERE hash = 'INSCRIT'"); // quelques tables sont triées pour que la lecture triée soit plus facile -query("ALTER TABLE applis_def ORDER BY text"); +query("ALTER TABLE profile_education_enum ORDER BY name"); query("ALTER TABLE binets_def ORDER BY text"); query("ALTER TABLE groupesx_def ORDER BY text"); -query("ALTER TABLE secteur ORDER BY text"); +query("ALTER TABLE profile_job_sector_enum ORDER BY name"); +query("ALTER TABLE profile_job_subsector_enum ORDER BY name"); +query("ALTER TABLE profile_job_subsubsector_enum ORDER BY name"); query("ALTER TABLE sections ORDER BY text"); // Prunes older autocomplete queries.