X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=bin%2Fcron%2Fclean.php;h=6325f63aff95a32f1575ea92f17d2b035eec1e98;hb=ee71865181e96e7b0754ef9e7da4b3cb26f4c1d7;hp=ce90f01ee6071306ac38e93b4ffaa79603b44443;hpb=8230e9f8eff954fb1103c8bdcf0d22557d419ae7;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.