X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=bin%2Fcron%2Fclean.php;h=76af55dd748d601cf7ad33105e1749a3987b5450;hb=3424387cde6c635ff16c3b5459c4caa88bb76e2e;hp=6135696f15d3bbe1f3df48f2a9bd800cb059f86d;hpb=5ecaa68e834e823f3d2ab9ea2c3613c1ebc19bf6;p=platal.git

diff --git a/bin/cron/clean.php b/bin/cron/clean.php
index 6135696..76af55d 100755
--- a/bin/cron/clean.php
+++ b/bin/cron/clean.php
@@ -1,7 +1,7 @@
 #!/usr/bin/php5 -q
 <?php
 /***************************************************************************
- *  Copyright (C) 2003-2010 Polytechnique.org                              *
+ *  Copyright (C) 2003-2014 Polytechnique.org                              *
  *  http://opensource.polytechnique.org/                                   *
  *                                                                         *
  *  This program is free software; you can redistribute it and/or modify   *
@@ -42,19 +42,13 @@ query('ALTER TABLE  profile_corps_enum
 query('ALTER TABLE  profile_corps_rank_enum
           ORDER BY  name');
 query('ALTER TABLE  profile_education_degree_enum
-          ORDER BY  name');
+          ORDER BY  degree');
 query('ALTER TABLE  profile_education_field_enum
           ORDER BY  field');
 query('ALTER TABLE  profile_job_enum
           ORDER BY  name');
-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_langskill_enum
-          ORDER BY  langue_fr');
+          ORDER BY  language');
 query('ALTER TABLE  profile_medal_enum
           ORDER BY  text');
 query('ALTER TABLE  profile_networking_enum
@@ -68,5 +62,9 @@ query('ALTER TABLE  profile_skill_enum
 query('DELETE FROM  search_autocomplete
              WHERE  generated < DATE_SUB(NOW(), INTERVAL 1 DAY)');
 
-// vim:set et sw=4 sts=4 sws=4 foldmethod=marker enc=utf-8:
+// XXX: cleans profile_merge_issues (to be removed once all merge related issues have been fixed)
+query('DELETE FROM  profile_merge_issues
+             WHERE  issues IS NULL OR issues = \'\'');
+
+// vim:set et sw=4 sts=4 sws=4 foldmethod=marker fenc=utf-8:
 ?>