X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=bin%2Fcron%2Fclean.php;h=6a1fef85ddcda20f755638b4a376eb565d6debf9;hb=61a7d2794e5e36491f49ab46d52f8c7eaf2f7a27;hp=195cd4c2e00e2455d989db5fe2b06d70adbf4403;hpb=9e1816c7666767755abbc24f6a0df290efff81b6;p=platal.git diff --git a/bin/cron/clean.php b/bin/cron/clean.php index 195cd4c..6a1fef8 100755 --- a/bin/cron/clean.php +++ b/bin/cron/clean.php @@ -37,11 +37,13 @@ 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 binets_def ORDER BY text"); +query("ALTER TABLE profile_education_enum ORDER BY name"); +query("ALTER TABLE profile_binet_enum ORDER BY text"); query("ALTER TABLE groupesx_def ORDER BY text"); -query("ALTER TABLE secteur ORDER BY text"); -query("ALTER TABLE sections 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 profile_section_enum ORDER BY text"); // Prunes older autocomplete queries. query("DELETE FROM search_autocomplete WHERE generated < DATE_SUB(NOW(), INTERVAL 1 DAY)");