X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=bin%2Fcron%2Fclean.php;h=6a1fef85ddcda20f755638b4a376eb565d6debf9;hb=61a7d2794e5e36491f49ab46d52f8c7eaf2f7a27;hp=ce90f01ee6071306ac38e93b4ffaa79603b44443;hpb=ecf2b474289f94932ff60ab18674610979d0e0db;p=platal.git diff --git a/bin/cron/clean.php b/bin/cron/clean.php index ce90f01..6a1fef8 100755 --- a/bin/cron/clean.php +++ b/bin/cron/clean.php @@ -1,7 +1,7 @@ #!/usr/bin/php5 -q = 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)");