Improvement issue 0000319:

Add new item on page administration/maintenance.
This item allow to repair and optimize database

Functionality tested with MySQL 4.1.9.
Please to report problem with previous version of MySql

git-svn-id: http://piwigo.org/svn/trunk@1111 68402e56-0260-453c-a942-63ccdbb3a9ee

4 files changed, 18 insertions, 8 deletions

diff --git a/language/en_UK.iso-8859-1/admin.lang.php b/language/en_UK.iso-8859-1/admin.lang.php
index f4cd1c294..b5ed27c4c 100644
--- a/language/en_UK.iso-8859-1/admin.lang.php
+++ b/language/en_UK.iso-8859-1/admin.lang.php
@@ -293,6 +293,7 @@ $lang['private'] = 'private';
 $lang['public'] = 'public';
 $lang['purge history'] = 'purge history';
 $lang['purge never used notification feeds'] = 'purge never used notification feeds';
+$lang['repair and optimize database'] = 'repair and optimize database';
 $lang['purge sessions'] = 'purge sessions';
 $lang['randomly represented'] = 'randomly represented';
 $lang['registration_date'] = 'registration date';
diff --git a/language/en_UK.iso-8859-1/help/maintenance.html b/language/en_UK.iso-8859-1/help/maintenance.html
index c3ecbea46..1bc3978b3 100644
--- a/language/en_UK.iso-8859-1/help/maintenance.html
+++ b/language/en_UK.iso-8859-1/help/maintenance.html
@@ -11,13 +11,13 @@ information from database make you save disk space.</p>
 
 <ul>
 
-  <li><strong>update categories informations</strong>. For each category,
+  <li><strong>Update categories informations</strong>. For each category,
   informations to update or control are the following : list of parent
   categories, number of pictures, date of the last picture, position among
   brother categories, position among all categories. This action also checks
   the coherence of representative picture.</li>
 
-  <li><strong>update images informations</strong>. For each picture,
+  <li><strong>Update images informations</strong>. For each picture,
   informations to update are : full path to file, average
   rate. <em>Warning</em>: do not get confuse with metadata informations
   which can be synchronized from <span class="pwgScreen">Administration,
@@ -25,14 +25,18 @@ information from database make you save disk space.</p>
   single picture (through <span class="pwgScreen">Picture</span> for
   example).</li>
 
-  <li><strong>purge history</strong>. Delete all lines from
+  <li><strong>Purge history</strong>. Delete all lines from
   <code>history</code> table. Screen <span class="pwgScreen">Administration,
   General, History</span> shows no informations anymore on past
   history. <em>Warning</em>: all data will be lost and there is no way to
   get informations back.</li>
 
-  <li><strong>purge sessions</strong>. Delete expired user sessions.</li>
+  <li><strong>Purge sessions</strong>. Delete expired user sessions.</li>
 
-  <li><strong>purge never used notification feeds</strong></li>
+  <li><strong>Purge never used notification feeds</strong></li>
+
+  <li><strong>Repair and optimize database</strong>
+  For each table, re-odrer, repair and optimize operations are done.
+  </li>
 
 </ul>
diff --git a/language/fr_FR.iso-8859-1/admin.lang.php b/language/fr_FR.iso-8859-1/admin.lang.php
index a8ede8c34..58d85a647 100644
--- a/language/fr_FR.iso-8859-1/admin.lang.php
+++ b/language/fr_FR.iso-8859-1/admin.lang.php
@@ -293,6 +293,7 @@ $lang['private'] = 'privée';
 $lang['public'] = 'publique';
 $lang['purge history'] = 'purger l\'historique';
 $lang['purge never used notification feeds'] = 'purger les flux de notification jamais utilisés';
+$lang['repair and optimize database'] = 'réparer et optimiser la base de données';
 $lang['purge sessions'] = 'purger les sessions';
 $lang['randomly represented'] = 'représentant au hasard';
 $lang['registration_date'] = 'date d\'enregistrement';
diff --git a/language/fr_FR.iso-8859-1/help/maintenance.html b/language/fr_FR.iso-8859-1/help/maintenance.html
index bd7a3aee1..7691e739d 100644
--- a/language/fr_FR.iso-8859-1/help/maintenance.html
+++ b/language/fr_FR.iso-8859-1/help/maintenance.html
@@ -28,15 +28,19 @@ l'écran <span class="pwgScreen">Modifier les informations d'une image</span>
 (accessible depuis la page de visualisation d'une image <span
 class="pwgScreen">picture.php</span>).</li>
 
-  <li><strong>purger l'historique</strong>. Supprime toutes les lignes de
+  <li><strong>Purger l'historique</strong>. Supprime toutes les lignes de
 la table <code>history</code>. L'écran <span
 class="pwgScreen">Administration, Général, Historique</span> ne montre alors
 plus aucune information sur le passé. <em>Attention</em>: toutes les données
 seront perdues et il n'existe aucun moyen de les récupérer.</li>
 
-  <li><strong>purger les sessions</strong>. Supprimer les sessions
+  <li><strong>Purger les sessions</strong>. Supprimer les sessions
 expirées..</li>
 
-  <li><strong>purger les flux de notification jamais utilisés</strong></li>
+  <li><strong>Purger les flux de notification jamais utilisés</strong></li>
+
+  <li><strong>Réparer et optimiser la base de données</strong>
+Pour chaque tables de la base de données PhpWegGallery, les opérations de ré-ordonnancement, de réparation et d'optimisation sont effectuées.
+  </li>
 
 </ul>