projects
/
platal.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
Displays and compares our country and language lists with iso lists.
[platal.git]
/
bin
/
cron
/
clean.php
diff --git
a/bin/cron/clean.php
b/bin/cron/clean.php
index
2663bb2
..
add5458
100755
(executable)
--- a/
bin/cron/clean.php
+++ b/
bin/cron/clean.php
@@
-1,7
+1,7
@@
#!/usr/bin/php5 -q
<?php
/***************************************************************************
#!/usr/bin/php5 -q
<?php
/***************************************************************************
- * Copyright (C) 2003-201
0
Polytechnique.org *
+ * Copyright (C) 2003-201
1
Polytechnique.org *
* http://opensource.polytechnique.org/ *
* *
* This program is free software; you can redistribute it and/or modify *
* http://opensource.polytechnique.org/ *
* *
* This program is free software; you can redistribute it and/or modify *
@@
-47,12
+47,6
@@
query('ALTER TABLE profile_education_field_enum
ORDER BY field');
query('ALTER TABLE profile_job_enum
ORDER BY name');
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');
query('ALTER TABLE profile_medal_enum
query('ALTER TABLE profile_langskill_enum
ORDER BY langue_fr');
query('ALTER TABLE profile_medal_enum
@@
-68,5
+62,9
@@
query('ALTER TABLE profile_skill_enum
query('DELETE FROM search_autocomplete
WHERE generated < DATE_SUB(NOW(), INTERVAL 1 DAY)');
query('DELETE FROM search_autocomplete
WHERE generated < DATE_SUB(NOW(), INTERVAL 1 DAY)');
+// 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 enc=utf-8:
?>
// vim:set et sw=4 sts=4 sws=4 foldmethod=marker enc=utf-8:
?>