[Phpmyadmin-git] [SCM] phpMyAdmin branch, master, updated. RELEASE_3_4_3_1-6508-gcfdf3aa

Piotr Przybylski crackpl at users.sourceforge.net
Sun Jul 3 13:21:38 CEST 2011


The branch, master has been updated
       via  cfdf3aa7c346ca90768874bfb7dd5a44920d215f (commit)
      from  5560ad53e07d56e6686964de288d487df02a6153 (commit)


- Log -----------------------------------------------------------------
commit cfdf3aa7c346ca90768874bfb7dd5a44920d215f
Author: Piotr Przybylski <piotrprz at gmail.com>
Date:   Sun Jul 3 13:21:13 2011 +0200

    Whitespace cleanup
    Removed @uses and fixed broken PHPDoc comments

-----------------------------------------------------------------------

Summary of changes:
 libraries/server_synchronize.lib.php |  569 +++++++++++++++++-----------------
 1 files changed, 278 insertions(+), 291 deletions(-)

diff --git a/libraries/server_synchronize.lib.php b/libraries/server_synchronize.lib.php
index a2ea20b..54f15bd 100644
--- a/libraries/server_synchronize.lib.php
+++ b/libraries/server_synchronize.lib.php
@@ -2,26 +2,25 @@
 /* vim: set expandtab sw=4 ts=4 sts=4: */
 
 /**
-* PMA_getMatchingTables places matching tables in source 
+* PMA_getMatchingTables places matching tables in source
 * and target databases in $matching_tables array whereas
 * $uncommon_source_tables array gets the tables present in
 * source database but are absent from target database.
 * Criterion for matching tables is just comparing their names.
-*           
-* @param    $trg_tables   array of target database table names, 
-* @param    $src_tables   array of source database table names, 
-* 
-* @param    &$matching_tables           empty array passed by reference to save names of matching tables, 
-* @param    &$uncommon_source_tables    empty array passed by reference to save names of tables present in 
+*
+* @param    $trg_tables   array of target database table names,
+* @param    $src_tables   array of source database table names,
+*
+* @param    &$matching_tables           empty array passed by reference to save names of matching tables,
+* @param    &$uncommon_source_tables    empty array passed by reference to save names of tables present in
 *                                       source database but absent from target database
 */
-        
 function PMA_getMatchingTables($trg_tables, $src_tables, &$matching_tables, &$uncommon_source_tables)
 {
-    for($k=0; $k< sizeof($src_tables); $k++) {                  
-        $present_in_target = false;   
-        for($l=0; $l < sizeof($trg_tables); $l++) {   
-            if ($src_tables[$k] === $trg_tables[$l]) {            
+    for($k=0; $k< sizeof($src_tables); $k++) {
+        $present_in_target = false;
+        for($l=0; $l < sizeof($trg_tables); $l++) {
+            if ($src_tables[$k] === $trg_tables[$l]) {
                 $present_in_target = true;
                 $matching_tables[] = $src_tables[$k];
             }
@@ -36,30 +35,29 @@ function PMA_getMatchingTables($trg_tables, $src_tables, &$matching_tables, &$un
 * PMA_getNonMatchingTargetTables() places tables present
 * in target database but are absent from source database
 * 
-* @param    $trg_tables   array of target database table names, 
-*  
-* @param    $matching_tables           $matching tables array containing names of matching tables, 
-* @param    &$uncommon_target_tables    empty array passed by reference to save names of tables presnet in 
+* @param    $trg_tables   array of target database table names,
+*
+* @param    $matching_tables           $matching tables array containing names of matching tables,
+* @param    &$uncommon_target_tables    empty array passed by reference to save names of tables presnet in
 *                                       target database but absent from source database
 */
-
 function PMA_getNonMatchingTargetTables($trg_tables, $matching_tables, &$uncommon_target_tables)
 {
     for($c=0; $c<sizeof($trg_tables) ;$c++) {
-        $match = false;          
+        $match = false;
         for($d=0; $d < sizeof($matching_tables); $d++)
         {
             if ($trg_tables[$c] === $matching_tables[$d]) {
                 $match=true;
-            } 
+            }
         }
         if ($match === false) {
             $uncommon_target_tables[] = $trg_tables[$c];
-        }      
+        }
     }
 }
- 
- /**
+
+/**
  * PMA_dataDiffInTables() finds the difference in source and target matching tables by
  * first comparing source table's primary key entries with target table enteries.
  * It gets the field names for the matching table also for comparisons.
@@ -67,29 +65,27 @@ function PMA_getNonMatchingTargetTables($trg_tables, $matching_tables, &$uncommo
  * field values also, in order to check whether update is required or not.
  * If update is required, it is placed in $update_array
  * Otherwise that entry is placed in the $insert_array.
- * 
- * 
+ *
+ *
  * @param    $src_db    name of source database
  * @param    $trg_db    name of target database
  * @param    $src_link  connection established with source server
  * @param    $trg_link  connection established with target server
- * @param    $index     Index of a table from $matching_table array 
- * 
- * @param    $update_array    A three dimensional array passed by reference to 
+ * @param    $matching_table   array containing matching table names
+ * @param    $matching_tables_fields    A two dimensional array passed by reference to contain names of fields for each matching table
+ * @param    $update_array    A three dimensional array passed by reference to
  *                            contain updates required for each matching table
- * @param    $insert_array    A three dimensional array passed by reference to 
+ * @param    $insert_array    A three dimensional array passed by reference to
  *                            contain inserts required for each matching table
- * @param    $fields_num      A two dimensional array passed by reference to 
+ * @param    $delete_array    Unused
+ * @param    $fields_num      A two dimensional array passed by reference to
  *                            contain number of fields for each matching table
- * @param    $matching_table   array containing matching table names
- * 
- * @param    $matching_tables_fields    A two dimensional array passed by reference to contain names of fields for each matching table
- * 
+ * @param    $matching_table_index    Index of a table from $matching_table array
  * @param    $matching_tables_keys     A two dimensional array passed by reference to contain names of keys for each matching table
- */                                                  
+ */
 function PMA_dataDiffInTables($src_db, $trg_db, $src_link, $trg_link, &$matching_table, &$matching_tables_fields,
     &$update_array, &$insert_array, &$delete_array, &$fields_num, $matching_table_index, &$matching_tables_keys)
-{   
+{
     if (isset($matching_table[$matching_table_index])) {
         $fld = array();
         $fld_results = PMA_DBI_get_columns($src_db, $matching_table[$matching_table_index], true, $src_link);
@@ -101,80 +97,80 @@ function PMA_dataDiffInTables($src_db, $trg_db, $src_link, $trg_link, &$matching
                     $is_key[] = $field_name;
                 }
                 $fld[] = $field_name;
-            }    
+            }
         }
         $matching_tables_fields[$matching_table_index] = $fld; 
         $fields_num[$matching_table_index] = sizeof($fld);
         $matching_tables_keys[$matching_table_index] = $is_key;
-        
-        $source_result_set = PMA_get_column_values($src_db, $matching_table[$matching_table_index], $is_key, $src_link);      
+
+        $source_result_set = PMA_get_column_values($src_db, $matching_table[$matching_table_index], $is_key, $src_link);
         $source_size = sizeof($source_result_set);
-        
+
         $trg_fld_results = PMA_DBI_get_columns($trg_db, $matching_table[$matching_table_index], true, $trg_link);
         $all_keys_match = true;
         $trg_keys = array();
-        
+
         if (isset($trg_fld_results)) {
             foreach ($trg_fld_results as $each_field) {
                 if ($each_field['Key'] == 'PRI') {
-                    $trg_keys[] = $each_field['Field']; 
+                    $trg_keys[] = $each_field['Field'];
                     if (! (in_array($each_field['Field'], $is_key))) {
                         $all_keys_match = false;
-                    }    
-                }   
-            }   
+                    }
+                }
+            }
         }
         $update_row = 0;
         $insert_row = 0;
         $update_field = 0;
         $insert_field = 0;
-        $starting_index = 0; 
-        
-        for ($j = 0; $j < $source_size; $j++) { 
+        $starting_index = 0;
+
+        for ($j = 0; $j < $source_size; $j++) {
             $starting_index = 0;
-			$update_field = 0; 
+			$update_field = 0;
 
 			if (isset($source_result_set[$j]) && ($all_keys_match)) {
 
 				// Query the target server to see which rows already exist
-                $trg_select_query = "SELECT * FROM " . PMA_backquote($trg_db) . "." 
+                $trg_select_query = "SELECT * FROM " . PMA_backquote($trg_db) . "."
         	        . PMA_backquote($matching_table[$matching_table_index]) . " WHERE ";
-  
+
                 if (sizeof($is_key) == 1) {
                     $trg_select_query .= $is_key[0]. "='" . $source_result_set[$j] . "'";
                 } elseif (sizeof($is_key) > 1){
                     for ($k=0; $k < sizeof($is_key); $k++) {
                         $trg_select_query .= $is_key[$k] . "='" . $source_result_set[$j][$is_key[$k]] . "'";
                         if ($k < (sizeof($is_key)-1)){
-                            $trg_select_query .= " AND ";    
+                            $trg_select_query .= " AND ";
                         }
-                    }  
+                    }
                 }
-        
+
                 $target_result_set = PMA_DBI_fetch_result($trg_select_query, null, null, $trg_link);
 				if ($target_result_set) {
 
 					// Fetch the row from the source server to do a comparison
-                    $src_select_query = "SELECT * FROM " . PMA_backquote($src_db) . "." 
+                    $src_select_query = "SELECT * FROM " . PMA_backquote($src_db) . "."
                  	   . PMA_backquote($matching_table[$matching_table_index]) . " WHERE ";
-                    
+
                     if (sizeof($is_key) == 1) {
                         $src_select_query .= $is_key[0] . "='" . $source_result_set[$j] . "'";
                     } else if(sizeof($is_key) > 1){
                         for ($k=0; $k< sizeof($is_key); $k++) {
                             $src_select_query .= $is_key[$k] . "='" . $source_result_set[$j][$is_key[$k]] . "'";
                             if ($k < (sizeof($is_key) - 1)){
-                                $src_select_query .= " AND ";    
+                                $src_select_query .= " AND ";
                             }
                         }
-                    }  
-                    
+                    }
+
                     $src_result_set = PMA_DBI_fetch_result($src_select_query, null, null, $src_link);
-                    
+
                     /**
                     * Comparing each corresponding field of the source and target matching rows.
-                    * Placing the primary key, value of primary key, field to be updated, and the 
-                    * new value of field to be updated in each row of the update array. 
+                    * Placing the primary key, value of primary key, field to be updated, and the
+                    * new value of field to be updated in each row of the update array.
                     */
                     for ($m = 0; ($m < $fields_num[$matching_table_index]) && ($starting_index == 0) ; $m++) {
                         if (isset($src_result_set[0][$fld[$m]])) {
@@ -191,12 +187,12 @@ function PMA_dataDiffInTables($src_db, $trg_db, $src_link, $trg_link, &$matching
                                         }
                                     }
                                 }
-                                        
+
                                 $update_array[$matching_table_index][$update_row][$update_field] = $fld[$m];
-                                
+
                                 $update_field++;
                                 if (isset($src_result_set[0][$fld[$m]])) {
-                                    $update_array[$matching_table_index][$update_row][$update_field] = $src_result_set[0][$fld[$m]]; 
+                                    $update_array[$matching_table_index][$update_row][$update_field] = $src_result_set[0][$fld[$m]];
                                     $update_field++;
                                 }
                                 $starting_index = $m;
@@ -206,7 +202,7 @@ function PMA_dataDiffInTables($src_db, $trg_db, $src_link, $trg_link, &$matching
                                if (sizeof($is_key) == 1) {
                                     if ($source_result_set[$j]) {
                                         $update_array[$matching_table_index][$update_row][$is_key[0]] = $source_result_set[$j];
-                                
+
                                     }
                                 } elseif (sizeof($is_key) > 1) {  
                                     for ($n = 0; $n < sizeof($is_key); $n++) {
@@ -215,12 +211,12 @@ function PMA_dataDiffInTables($src_db, $trg_db, $src_link, $trg_link, &$matching
                                         }
                                     }
                                 }
-                                        
+
                                 $update_array[$matching_table_index][$update_row][$update_field] = $fld[$m];
-                                
+
                                 $update_field++;
                                 if (isset($src_result_set[0][$fld[$m]])) {
-                                    $update_array[$matching_table_index][$update_row][$update_field] = $src_result_set[0][$fld[$m]]; 
+                                    $update_array[$matching_table_index][$update_row][$update_field] = $src_result_set[0][$fld[$m]];
                                     $update_field++;
                                 }
                                 $starting_index = $m;
@@ -229,28 +225,28 @@ function PMA_dataDiffInTables($src_db, $trg_db, $src_link, $trg_link, &$matching
                       }
                     }
                     for ($m = $starting_index + 1; $m < $fields_num[$matching_table_index] ; $m++)
-                    {   
+                    {
                         if (isset($src_result_set[0][$fld[$m]])) {
-                            if (isset($target_result_set[0][$fld[$m]])) { 
+                            if (isset($target_result_set[0][$fld[$m]])) {
                                 if (($src_result_set[0][$fld[$m]] != $target_result_set[0][$fld[$m]]) && (!(in_array($fld[$m], $is_key)))) {
-                                $update_row--; 
+                                $update_row--;
                                 $update_array[$matching_table_index][$update_row][$update_field] = $fld[$m];
                                 $update_field++;
                                 if ($src_result_set[0][$fld[$m]]) {
                                     $update_array[$matching_table_index][$update_row][$update_field] = $src_result_set[0][$fld[$m]];
                                     $update_field++;
                                 }
-                                $update_row++; 
+                                $update_row++;
                             }
                         } else {
-                               $update_row--; 
+                               $update_row--;
                                 $update_array[$matching_table_index][$update_row][$update_field] = $fld[$m];
                                 $update_field++;
                                 if ($src_result_set[0][$fld[$m]]) {
                                     $update_array[$matching_table_index][$update_row][$update_field] = $src_result_set[0][$fld[$m]];
                                     $update_field++;
                                 }
-                                $update_row++; 
+                                $update_row++;
                             }
                         }
                     }
@@ -262,7 +258,7 @@ function PMA_dataDiffInTables($src_db, $trg_db, $src_link, $trg_link, &$matching
                         if (isset($source_result_set[$j])) {
                             $insert_array[$matching_table_index][$insert_row][$is_key[0]] = $source_result_set[$j];
                         }
-                    } elseif (sizeof($is_key) > 1) {  
+                    } elseif (sizeof($is_key) > 1) {
                         for($l = 0; $l < sizeof($is_key); $l++) {
                             if (isset($source_result_set[$j][$matching_tables_fields[$matching_table_index][$l]])) {
                                 $insert_array[$matching_table_index][$insert_row][$is_key[$l]] = $source_result_set[$j][$matching_tables_fields[$matching_table_index][$l]];
@@ -274,13 +270,13 @@ function PMA_dataDiffInTables($src_db, $trg_db, $src_link, $trg_link, &$matching
             } else {
                     /**
                     * Placing the primary key, and the value of primary key of the row that is to be inserted in the target table
-                    * This condition is met when there is an additional column in the source table                                                  
+                    * This condition is met when there is an additional column in the source table
                     */
                     if (sizeof($is_key) == 1) {
                         if (isset($source_result_set[$j])) {
                             $insert_array[$matching_table_index][$insert_row][$is_key[0]] = $source_result_set[$j];
                         }
-                    } elseif (sizeof($is_key) > 1) {  
+                    } elseif (sizeof($is_key) > 1) {
                         for ($l = 0; $l < sizeof($is_key); $l++) {
                             if (isset($source_result_set[$j][$matching_tables_fields[$matching_table_index][$l]])) {
                                 $insert_array[$matching_table_index][$insert_row][$is_key[$l]] = $source_result_set[$j][$matching_tables_fields[$matching_table_index][$l]];
@@ -290,31 +286,31 @@ function PMA_dataDiffInTables($src_db, $trg_db, $src_link, $trg_link, &$matching
                 $insert_row++;
             }
         } // for loop ends
-    }    
-} 
+    }
+}
+
 /**
 * PMA_findDeleteRowsFromTargetTables finds the rows which are to be deleted from target table.
-* 
-* @param  $delete_array          array containing rows that are to be deleted 
+*
+* @param  $delete_array          array containing rows that are to be deleted
 * @param  $matching_table        array containing matching table names
 * @param  $matching_table_index  index of a table from $matching_table array
 * @param  $trg_keys              array of target table keys
 * @param  $src_keys              array of source table keys
 * @param  $trg_db                name of target database
 * @param  $trg_link              connection established with target server
-* @param  $src_db                name of source database 
+* @param  $src_db                name of source database
 * @param  $src_link              connection established with source server
-* 
 */
 function PMA_findDeleteRowsFromTargetTables(&$delete_array, $matching_table, $matching_table_index, $trg_keys, $src_keys, $trg_db, $trg_link,$src_db, $src_link)
 {
     if (isset($trg_keys[$matching_table_index])) {
         $target_key_values = PMA_get_column_values($trg_db, $matching_table[$matching_table_index], $trg_keys[$matching_table_index], $trg_link);      
-        $target_row_size = sizeof($target_key_values);        
+        $target_row_size = sizeof($target_key_values);
     }
     if (isset($src_keys[$matching_table_index])) {
         $source_key_values = PMA_get_column_values($src_db, $matching_table[$matching_table_index], $src_keys[$matching_table_index], $src_link);      
-        $source_size = sizeof($source_key_values);        
+        $source_size = sizeof($source_key_values);
     }
     $all_keys_match = 1;
     for ($a = 0; $a < sizeof($trg_keys[$matching_table_index]); $a++) {
@@ -322,7 +318,7 @@ function PMA_findDeleteRowsFromTargetTables(&$delete_array, $matching_table, $ma
            if (! (in_array($trg_keys[$matching_table_index][$a], $src_keys[$matching_table_index]))) {
                $all_keys_match = 0;
            }
-       }   
+       }
     }
     if (! ($all_keys_match)) {
         if (isset($target_key_values)) {
@@ -331,17 +327,17 @@ function PMA_findDeleteRowsFromTargetTables(&$delete_array, $matching_table, $ma
     }
     if (isset($trg_keys[$matching_table_index])) {
         if ((sizeof($trg_keys[$matching_table_index]) == 1) && $all_keys_match) {
-           $row = 0; 
+           $row = 0;
            if (isset($target_key_values)) {
                for ($i = 0; $i < sizeof($target_key_values); $i++) {
                     if (! (in_array($target_key_values[$i], $source_key_values))) {
                         $delete_array[$matching_table_index][$row] = $target_key_values[$i];
-                        $row++;   
+                        $row++;
                     }
-                }                  
+                }
             }
         } elseif ((sizeof($trg_keys[$matching_table_index]) > 1) && $all_keys_match) {
-            $row = 0;  
+            $row = 0;
             if (isset($target_key_values)) {
                 for ($i = 0; $i < sizeof($target_key_values); $i++) {
                     $is_present = false;
@@ -350,7 +346,7 @@ function PMA_findDeleteRowsFromTargetTables(&$delete_array, $matching_table, $ma
                         for ($k = 0; $k < sizeof($trg_keys[$matching_table_index]); $k++) {
                             if ($target_key_values[$i][$trg_keys[$matching_table_index][$k]] != $source_key_values[$j][$trg_keys[$matching_table_index][$k]]) {
                                 $check = false;
-                            }    
+                            }
                         }
                         if ($check) {
                             $is_present = true;
@@ -362,61 +358,60 @@ function PMA_findDeleteRowsFromTargetTables(&$delete_array, $matching_table, $ma
                         }
                         $row++;
                     }
-                }                    
-            }        
+                }
+            }
         }
-    }    
+    }
 }
 
 /**
 * PMA_dataDiffInUncommonTables() finds the data difference in  $source_tables_uncommon
-* 
+*
 * @param  $source_tables_uncommon  array of table names; containing table names that are in source db and not in target db
 * @param  $src_db                  name of source database
 * @param  $src_link                connection established with source server
 * @param  $index                   index of a table from $matching_table array
 * @param  $row_count               number of rows
 */
-
 function PMA_dataDiffInUncommonTables($source_tables_uncommon, $src_db, $src_link, $index, &$row_count)
 {
-   $query = "SELECT COUNT(*) FROM " . PMA_backquote($src_db) . "." . PMA_backquote($source_tables_uncommon[$index]);  
-   $rows  = PMA_DBI_fetch_result($query, null, null, $src_link); 
-   $row_count[$index] = $rows[0]; 
+   $query = "SELECT COUNT(*) FROM " . PMA_backquote($src_db) . "." . PMA_backquote($source_tables_uncommon[$index]);
+   $rows  = PMA_DBI_fetch_result($query, null, null, $src_link);
+   $row_count[$index] = $rows[0];
 }
 
 /**
 * PMA_updateTargetTables() sets the updated field values to target table rows using $update_array[$matching_table_index]
 *
-*  
-* @param    $table                 Array containing matching tables' names 
+*
+* @param    $table                 Array containing matching tables' names
 * @param    $update_array          A three dimensional array containing field
 *                                  value updates required for each matching table
-* @param    $src_db                Name of source database 
+* @param    $src_db                Name of source database
 * @param    $trg_db                Name of target database
 * @param    $trg_link              Connection established with target server
-* @param    $matching_table_index  index of matching table in matching_table_array    
+* @param    $matching_table_index  index of matching table in matching_table_array
+* @param    $matching_table_keys
 * @param    $display               true/false value
-*/                                                                                                        
-
+*/
 function PMA_updateTargetTables($table, $update_array, $src_db, $trg_db, $trg_link, $matching_table_index, $matching_table_keys, $display)
-{ 
+{
     if (isset($update_array[$matching_table_index])) {
         if (sizeof($update_array[$matching_table_index])) {
-               
+
             for ($update_row = 0; $update_row < sizeof($update_array[$matching_table_index]); $update_row++) {
-                   
-                if (isset($update_array[$matching_table_index][$update_row])) { 
+
+                if (isset($update_array[$matching_table_index][$update_row])) {
                      $update_fields_num = sizeof($update_array[$matching_table_index][$update_row])-sizeof($matching_table_keys[$matching_table_index]);
                      if ($update_fields_num > 0) {
-                        $query = "UPDATE " . PMA_backquote($trg_db) . "." .PMA_backquote($table[$matching_table_index]) . " SET ";   
-                     
+                        $query = "UPDATE " . PMA_backquote($trg_db) . "." .PMA_backquote($table[$matching_table_index]) . " SET ";
+
                      for ($update_field = 0; $update_field < $update_fields_num; $update_field = $update_field+2) {
                          if (isset($update_array[$matching_table_index][$update_row][$update_field]) && isset($update_array[$matching_table_index][$update_row][$update_field+1])) {
                              $query .= $update_array[$matching_table_index][$update_row][$update_field] . "='" . $update_array[$matching_table_index][$update_row][$update_field+1] . "'";
                          }
                          if ($update_field < ($update_fields_num - 2)) {
-                             $query .= ", ";    
+                             $query .= ", ";
                          }
                      }
                      $query .= " WHERE ";
@@ -424,7 +419,6 @@ function PMA_updateTargetTables($table, $update_array, $src_db, $trg_db, $trg_li
                         for ($key = 0; $key < sizeof($matching_table_keys[$matching_table_index]); $key++)
                         {
                             if (isset($matching_table_keys[$matching_table_index][$key])) {
-                            
                                 $query .= $matching_table_keys[$matching_table_index][$key] . "='" . $update_array[$matching_table_index][$update_row][$matching_table_keys[$matching_table_index][$key]] . "'";
                             }
                             if ($key < (sizeof($matching_table_keys[$matching_table_index]) - 1)) {
@@ -434,27 +428,26 @@ function PMA_updateTargetTables($table, $update_array, $src_db, $trg_db, $trg_li
                     }
                     if ($display == true) {
                         echo "<p>" . $query . "</p>";
-                    }                    
+                    }
                     PMA_DBI_try_query($query, $trg_link, 0);
                     }
-                }                    
+                }
             }
         }
     }
 }
+
 /**
 * PMA_insertIntoTargetTable() inserts missing rows in the target table using $array_insert[$matching_table_index]
-*  
-* 
-*                                              
+*
 * @param  $matching_table         array containing matching table names
 * @param  $src_db                 name of source database
 * @param  $trg_db                 name of target database
 * @param  $src_link               connection established with source server
 * @param  $trg_link               connection established with target server
 * @param  $table_fields           array containing field names of a table
-* @param  $array_insert            
-* @param  $matching_table_index   index of matching table in matching_table_array 
+* @param  $array_insert
+* @param  $matching_table_index   index of matching table in matching_table_array
 * @param  $matching_tables_keys   array containing field names that are keys in the matching table
 * @param  $source_columns         array containing source column information
 * @param  $add_column_array       array containing column names that are to be added in target table
@@ -463,30 +456,29 @@ function PMA_updateTargetTables($table, $update_array, $src_db, $trg_db, $trg_li
 * @param  $uncommon_tables        array containing table names that are present in source db but not in targt db
 * @param  $uncommon_tables_fields array containing field names of the uncommon tables
 * @param  $uncommon_cols          column names that are present in target table and not in source table
-* @param  $alter_str_array        array containing column names that are to be altered 
-* @param  $source_indexes         column names on which indexes are made in source table 
-* @param  $target_indexes         column names on which indexes are made in target table 
+* @param  $alter_str_array        array containing column names that are to be altered
+* @param  $source_indexes         column names on which indexes are made in source table
+* @param  $target_indexes         column names on which indexes are made in target table
 * @param  $add_indexes_array      array containing column names on which index is to be added in target table
-* @param  $alter_indexes_array    array containing column names whose indexes are to be altered. Only index name and uniqueness of an index can be changed 
+* @param  $alter_indexes_array    array containing column names whose indexes are to be altered. Only index name and uniqueness of an index can be changed
 * @param  $delete_array           array containing rows that are to be deleted
 * @param  $update_array           array containing rows that are to be updated in target
 * @param  $display                true/false value
-*
 */
 function PMA_insertIntoTargetTable($matching_table, $src_db, $trg_db, $src_link, $trg_link, $table_fields, &$array_insert, $matching_table_index,
- $matching_tables_keys, $source_columns, &$add_column_array, $criteria, $target_tables_keys, $uncommon_tables, &$uncommon_tables_fields,$uncommon_cols, 
+ $matching_tables_keys, $source_columns, &$add_column_array, $criteria, $target_tables_keys, $uncommon_tables, &$uncommon_tables_fields,$uncommon_cols,
  &$alter_str_array,&$source_indexes, &$target_indexes, &$add_indexes_array, &$alter_indexes_array, &$delete_array, &$update_array, $display)
-{   
+{
     if(isset($array_insert[$matching_table_index])) {
         if (sizeof($array_insert[$matching_table_index])) {
             for ($insert_row = 0; $insert_row< sizeof($array_insert[$matching_table_index]); $insert_row++) {
                 if (isset($array_insert[$matching_table_index][$insert_row][$matching_tables_keys[$matching_table_index][0]])) {
-                   
+
                     $select_query = "SELECT * FROM " . PMA_backquote($src_db) . "." . PMA_backquote($matching_table[$matching_table_index]) . " WHERE ";
                     for ($i = 0; $i < sizeof($matching_tables_keys[$matching_table_index]); $i++) {
                         $select_query .= $matching_tables_keys[$matching_table_index][$i] . "='";
                         $select_query .= $array_insert[$matching_table_index][$insert_row][$matching_tables_keys[$matching_table_index][$i]] . "'" ;
-                        
+
                         if ($i < (sizeof($matching_tables_keys[$matching_table_index]) - 1)) {
                             $select_query.= " AND ";    
                         }
@@ -494,38 +486,38 @@ function PMA_insertIntoTargetTable($matching_table, $src_db, $trg_db, $src_link,
                     $select_query .= "; ";
                     $result = PMA_DBI_fetch_result ($select_query, null, null, $src_link);
                     $insert_query = "INSERT INTO " . PMA_backquote($trg_db) . "." . PMA_backquote($matching_table[$matching_table_index]) ." (";
-                    
-                    for ($field_index = 0; $field_index < sizeof($table_fields[$matching_table_index]); $field_index++) 
+
+                    for ($field_index = 0; $field_index < sizeof($table_fields[$matching_table_index]); $field_index++)
                     {
                         $insert_query .=  $table_fields[$matching_table_index][$field_index];
-                        
-                        $is_fk_query = "SELECT * FROM  information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = '" . $trg_db ."' 
+
+                        $is_fk_query = "SELECT * FROM  information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = '" . $trg_db ."'
                                          AND TABLE_NAME = '" . $matching_table[$matching_table_index]. "'AND COLUMN_NAME = '" .
                                          $table_fields[$matching_table_index][$field_index] . "' AND TABLE_NAME <> REFERENCED_TABLE_NAME;" ;
-                    
+
                         $is_fk_result = PMA_DBI_fetch_result($is_fk_query, null, null, $trg_link);
                         if (sizeof($is_fk_result) > 0) {
                             for ($j = 0; $j < sizeof($is_fk_result); $j++)
                             {
                                 $table_index = array_keys($matching_table, $is_fk_result[$j]['REFERENCED_TABLE_NAME']);
-                                 
+
                                 if (isset($alter_str_array[$table_index[0]])) {
                                    PMA_alterTargetTableStructure($trg_db, $trg_link, $matching_tables, $source_columns, $alter_str_array, $matching_tables_fields,
                                     $criteria, $matching_tables_keys, $target_tables_keys, $table_index[0], $display);
-                                    unset($alter_str_array[$table_index[0]]);        
-                                }                                                           
+                                    unset($alter_str_array[$table_index[0]]);
+                                }
                                 if (isset($uncommon_columns[$table_index[0]])) {
                                     PMA_removeColumnsFromTargetTable($trg_db, $trg_link, $matching_tables, $uncommon_columns, $table_index[0], $display);
-                                    unset($uncommon_columns[$table_index[0]]); 
-                                }           
+                                    unset($uncommon_columns[$table_index[0]]);
+                                }
                                 if (isset($add_column_array[$table_index[0]])) {
                                     PMA_findDeleteRowsFromTargetTables($delete_array, $matching_tables, $table_index[0], $target_tables_keys, $matching_tables_keys,
                                     $trg_db, $trg_link, $src_db, $src_link);
-                                     
+
                                     if (isset($delete_array[$table_index[0]])) {
                                        PMA_deleteFromTargetTable($trg_db, $trg_link, $matching_tables, $table_index[0], $target_tables_keys, $delete_array, $display);
-                                       unset($delete_array[$table_index[0]]); 
-                                    }        
+                                       unset($delete_array[$table_index[0]]);
+                                    }
                                     PMA_addColumnsInTargetTable($src_db, $trg_db, $src_link, $trg_link, $matching_tables, $source_columns, $add_column_array, 
                                     $matching_tables_fields, $criteria, $matching_tables_keys, $target_tables_keys, $uncommon_tables,$uncommon_tables_fields,
                                     $table_index[0], $uncommon_cols, $display);
@@ -535,7 +527,7 @@ function PMA_insertIntoTargetTable($matching_table, $src_db, $trg_db, $src_link,
                                     || isset($alter_indexes_array[$table_index[0]])) {
                                     PMA_applyIndexesDiff ($trg_db, $trg_link, $matching_tables, $source_indexes, $target_indexes, $add_indexes_array, $alter_indexes_array, 
                                     $remove_indexes_array, $table_index[0], $display); 
-                                   
+
                                     unset($add_indexes_array[$table_index[0]]);
                                     unset($alter_indexes_array[$table_index[0]]);
                                     unset($remove_indexes_array[$table_index[0]]);
@@ -548,16 +540,16 @@ function PMA_insertIntoTargetTable($matching_table, $src_db, $trg_db, $src_link,
                                 if (isset($array_insert[$table_index[0]])) {
                                      PMA_insertIntoTargetTable($matching_table, $src_db, $trg_db, $src_link, $trg_link, $table_fields, $array_insert,
                                      $table_index[0], $matching_tables_keys, $source_columns, $add_column_array, $criteria, $target_tables_keys, $uncommon_tables,
-                                     $uncommon_tables_fields, $uncommon_cols, $alter_str_array, $source_indexes, $target_indexes, $add_indexes_array, 
-                                     $alter_indexes_array, $delete_array, $update_array, $display); 
+                                     $uncommon_tables_fields, $uncommon_cols, $alter_str_array, $source_indexes, $target_indexes, $add_indexes_array,
+                                     $alter_indexes_array, $delete_array, $update_array, $display);
                                      unset($array_insert[$table_index[0]]);
-                                }      
+                                }
                             }
                         }
                         if ($field_index < sizeof($table_fields[$matching_table_index])-1) {
                             $insert_query .= ", ";
                         }
-                    }             
+                    }
                     $insert_query .= ") VALUES(";
                     if (sizeof($table_fields[$matching_table_index]) == 1) {
                          $insert_query .= "'" . PMA_sqlAddSlashes($result[0]) . "'";
@@ -570,32 +562,32 @@ function PMA_insertIntoTargetTable($matching_table, $src_db, $trg_db, $src_link,
                             }
                             if ($field_index < (sizeof($table_fields[$matching_table_index])) - 1) {
                                     $insert_query .= " ," ;
-                            }      
+                            }
                         }
-                    } 
+                    }
                     $insert_query .= ");";
                     if ($display == true) {
                         PMA_displayQuery($insert_query);
                     }
                     PMA_DBI_try_query($insert_query, $trg_link, 0);
-                }   
+                }
             }
         }
     }
-} 
+}
+
 /**
-* PMA_createTargetTables() Create the missing table $uncommon_table in target database 
-* 
-*                                                                     
-* @param    $src_db                 name of source database 
+* PMA_createTargetTables() Create the missing table $uncommon_table in target database
+*
+* @param    $src_db                 name of source database
 * @param    $trg_db                 name of target database
-* @param    $trg_link               connection established with target server
 * @param    $src_link               connection established with source server
-* @param    $uncommon_table         name of table present in source but not in target
-* @param    $table_index            index of table in matching_table_array 
+* @param    $trg_link               connection established with target server
+* @param    $uncommon_tables        names of tables present in source but not in target
+* @param    $table_index            index of table in $uncommon_tables array
 * @param    $uncommon_tables_fields field names of the uncommon table
-* @param    $display                 true/false value
-*/ 
+* @param    $display                true/false value
+*/
 function PMA_createTargetTables($src_db, $trg_db, $src_link, $trg_link, &$uncommon_tables, $table_index, &$uncommon_tables_fields, $display)
 {
     if (isset($uncommon_tables[$table_index])) {
@@ -605,20 +597,20 @@ function PMA_createTargetTables($src_db, $trg_db, $src_link, $trg_link, &$uncomm
             $field_name = $each_field['Field'];
             $fields[] = $field_name;
         }
-        $uncommon_tables_fields[$table_index] = $fields; 
-       
+        $uncommon_tables_fields[$table_index] = $fields;
+
         $Create_Query = PMA_DBI_fetch_value("SHOW CREATE TABLE " . PMA_backquote($src_db) . '.' . PMA_backquote($uncommon_tables[$table_index]), 0, 1, $src_link);
 
         // Replace the src table name with a `dbname`.`tablename`
-        $Create_Table_Query = preg_replace('/' . preg_quote(PMA_backquote($uncommon_tables[$table_index]), '/') . '/', 
+        $Create_Table_Query = preg_replace('/' . preg_quote(PMA_backquote($uncommon_tables[$table_index]), '/') . '/',
                                             PMA_backquote($trg_db) . '.' .PMA_backquote($uncommon_tables[$table_index]),
                                             $Create_Query,
                                             $limit = 1
         );
 
-        $is_fk_query = "SELECT * FROM  information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = '" . $src_db . "' 
+        $is_fk_query = "SELECT * FROM  information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = '" . $src_db . "'
                         AND TABLE_NAME = '" . $uncommon_tables[$table_index] . "' AND TABLE_NAME <> REFERENCED_TABLE_NAME;" ;
-                    
+
         $is_fk_result = PMA_DBI_fetch_result($is_fk_query, null, null, $src_link);
         if (sizeof($is_fk_result) > 0) {
             for ($j = 0; $j < sizeof($is_fk_result); $j++)
@@ -627,35 +619,35 @@ function PMA_createTargetTables($src_db, $trg_db, $src_link, $trg_link, &$uncomm
                     $table_index = array_keys($uncommon_tables, $is_fk_result[$j]['REFERENCED_TABLE_NAME']);
                     PMA_createTargetTables($src_db, $trg_db, $trg_link, $src_link, $uncommon_tables, $table_index[0], $uncommon_tables_fields, $display);
                     unset($uncommon_tables[$table_index[0]]);
-                }      
+                }
             }
          }
          if ($display == true) {
               echo '<p>' . $Create_Table_Query . '</p>';
          }
          PMA_DBI_try_query($Create_Table_Query, $trg_link, 0);
-    }                                   
+    }
 }
 /**
 * PMA_populateTargetTables() inserts data into uncommon tables after they have been created
-* 
+*
 * @param  $src_db                 name of source database
 * @param  $trg_db                 name of target database
 * @param  $src_link               connection established with source server
 * @param  $trg_link               connection established with target server
-* @param  $uncommon_tables        array containing uncommon table names (table names that are present in source but not in target db) 
-* @param  $table_index            index of table in matching_table_array 
+* @param  $uncommon_tables        array containing uncommon table names (table names that are present in source but not in target db)
+* @param  $table_index            index of table in matching_table_array
 * @param  $uncommon_tables_fields field names of the uncommon table
 * @param  $display                true/false value
 *
 * FIXME: This turns NULL values into '' (empty string)
 */
-function PMA_populateTargetTables($src_db, $trg_db, $src_link, $trg_link, $uncommon_tables, $table_index, $uncommon_tables_fields, $display) 
-{                                                                            
+function PMA_populateTargetTables($src_db, $trg_db, $src_link, $trg_link, $uncommon_tables, $table_index, $uncommon_tables_fields, $display)
+{
     $display = false; // todo: maybe display some of the queries if they are not too numerous
     $unbuffered_result = PMA_DBI_try_query('SELECT * FROM ' . PMA_backquote($src_db) . '.' . PMA_backquote($uncommon_tables[$table_index]), $src_link, PMA_DBI_QUERY_UNBUFFERED);
     if (false !== $unbuffered_result) {
-        $insert_query = 'INSERT INTO ' . PMA_backquote($trg_db) . '.' .PMA_backquote($uncommon_tables[$table_index]) . ' VALUES';         
+        $insert_query = 'INSERT INTO ' . PMA_backquote($trg_db) . '.' .PMA_backquote($uncommon_tables[$table_index]) . ' VALUES';
         while ($one_row = PMA_DBI_fetch_row($unbuffered_result)) {
             $insert_query .= '(';
             $key_of_last_value = count($one_row) - 1;
@@ -675,55 +667,56 @@ function PMA_populateTargetTables($src_db, $trg_db, $src_link, $trg_link, $uncom
         PMA_DBI_try_query($insert_query, $trg_link, 0);
     }
 }
+
 /**
 * PMA_deleteFromTargetTable() delete rows from target table 
-* 
-* 
+*
 * @param  $trg_db                 name of target database
 * @param  $trg_link               connection established with target server
 * @param  $matching_tables        array containing matching table names
 * @param  $table_index            index of table in matching_table_array
-* @param  $target_table_keys      primary key names of the target tables
-* @param  $delete array           array containing the key values of rows that are to be deleted 
+* @param  $target_tables_keys     primary key names of the target tables
+* @param  $delete_array           array containing the key values of rows that are to be deleted
 * @param  $display                true/false value
 */
-function PMA_deleteFromTargetTable($trg_db, $trg_link, $matching_tables, $table_index, $target_tables_keys, $delete_array, $display) 
+function PMA_deleteFromTargetTable($trg_db, $trg_link, $matching_tables, $table_index, $target_tables_keys, $delete_array, $display)
 {
     for($i = 0; $i < sizeof($delete_array[$table_index]); $i++) {
         if (isset($target_tables_keys[$table_index])) {
-            $delete_query = 'DELETE FROM ' . PMA_backquote($trg_db) . '.' .PMA_backquote($matching_tables[$table_index]) . ' WHERE ';         
+            $delete_query = 'DELETE FROM ' . PMA_backquote($trg_db) . '.' .PMA_backquote($matching_tables[$table_index]) . ' WHERE ';
             for($y = 0; $y < sizeof($target_tables_keys[$table_index]); $y++) {
                 $delete_query .= $target_tables_keys[$table_index][$y] . " = '";
-                
+
                 if (sizeof($target_tables_keys[$table_index]) == 1) {
-                    $delete_query .= $delete_array[$table_index][$i] . "'";   
+                    $delete_query .= $delete_array[$table_index][$i] . "'";
                 } elseif (sizeof($target_tables_keys[$table_index]) > 1) {
                     $delete_query .= $delete_array[$table_index][$i][$target_tables_keys[$table_index][$y]] . "'";
                 }
                 if ($y < (sizeof($target_tables_keys[$table_index]) - 1)) {
                     $delete_query .= ' AND ';
                 }
-                $pk_query = "SELECT * FROM information_schema.KEY_COLUMN_USAGE WHERE REFERENCED_TABLE_SCHEMA = '" . $trg_db . "' 
+                $pk_query = "SELECT * FROM information_schema.KEY_COLUMN_USAGE WHERE REFERENCED_TABLE_SCHEMA = '" . $trg_db . "'
                             AND REFERENCED_TABLE_NAME = '" . $matching_tables[$table_index]."' AND REFERENCED_COLUMN_NAME = '"
                            . $target_tables_keys[$table_index][$y] . "' AND TABLE_NAME <> REFERENCED_TABLE_NAME;";
-    
+
                 $pk_query_result = PMA_DBI_fetch_result($pk_query, null, null, $trg_link);
                 $result_size = sizeof($pk_query_result);
-             
+
                 if ($result_size > 0) {
                     for ($b = 0; $b < $result_size; $b++) {
                         $drop_pk_query = "DELETE FROM " . PMA_backquote($pk_query_result[$b]['TABLE_SCHEMA']) . "." . PMA_backquote($pk_query_result[$b]['TABLE_NAME']) . " WHERE " . $pk_query_result[$b]['COLUMN_NAME'] . " = " . $target_tables_keys[$table_index][$y] . ";";
                         PMA_DBI_try_query($drop_pk_query, $trg_link, 0);
-                    }              
-                }       
-            }               
+                    }
+                }
+            }
         }
         if ($display == true) {
-            echo '<p>' . $delete_query . '</p>';    
+            echo '<p>' . $delete_query . '</p>';
         }
         PMA_DBI_try_query($delete_query, $trg_link, 0);
     }
 }
+
 /**
 * PMA_structureDiffInTables() Gets all the column information for source and target table.
 * Compare columns on their names.
@@ -732,10 +725,9 @@ function PMA_deleteFromTargetTable($trg_db, $trg_link, $matching_tables, $table_
 * If column exists in target table but criteria is different then it is palced in $alter_str_array.
 * If column does not exist in source table but is present in target table then it is placed in  $uncommon_columns.
 * Keys for all the source tables that have a corresponding target table are placed  in $matching_tables_keys.
-* Keys for all the target tables that have a corresponding source table are placed  in $target_tables_keys. 
-* 
-*                                                                     
-* @param    $src_db                name of source database 
+* Keys for all the target tables that have a corresponding source table are placed  in $target_tables_keys.
+*
+* @param    $src_db                name of source database
 * @param    $trg_db                name of target database
 * @param    $src_link              connection established with source server
 * @param    $trg_link              connection established with target server
@@ -749,26 +741,25 @@ function PMA_deleteFromTargetTable($trg_db, $trg_link, $matching_tables, $table_
 * @param    $uncommon_columns      array containing the columns that are present in the target table but not in the source table
 * @param    $criteria              array containing the criterias which are to be checked for field that is present in source table and target table
 * @param    $target_tables_keys    array containing the field names which is key in the target table
-* @param    $matching_table_index  integer number of the matching table 
-*                              
+* @param    $matching_table_index  integer number of the matching table
 */
 function PMA_structureDiffInTables($src_db, $trg_db, $src_link, $trg_link, $matching_tables, &$source_columns, &$target_columns, &$alter_str_array,
- &$add_column_array, &$uncommon_columns, $criteria, &$target_tables_keys, $matching_table_index) 
+ &$add_column_array, &$uncommon_columns, $criteria, &$target_tables_keys, $matching_table_index)
 {
     //Gets column information for source and target table
     $source_columns[$matching_table_index] = PMA_DBI_get_columns_full($src_db, $matching_tables[$matching_table_index], null, $src_link);
     $target_columns[$matching_table_index] = PMA_DBI_get_columns_full($trg_db, $matching_tables[$matching_table_index], null, $trg_link);
     foreach ($source_columns[$matching_table_index] as $column_name => $each_column) {
         if (isset($target_columns[$matching_table_index][$column_name]['Field'])) {
-            //If column exists in target table then matches criterias like type, null, collation, key, default, comment of the column 
+            //If column exists in target table then matches criterias like type, null, collation, key, default, comment of the column
             for ($i = 0; $i < sizeof($criteria); $i++) {
                 if ($source_columns[$matching_table_index][$column_name][$criteria[$i]] != $target_columns[$matching_table_index][$column_name][$criteria[$i]]) {
                     if (($criteria[$i] == 'Default') && ($source_columns[$matching_table_index][$column_name][$criteria[$i]] == '' )) {
-                        $alter_str_array[$matching_table_index][$column_name][$criteria[$i]] = 'None'; 
+                        $alter_str_array[$matching_table_index][$column_name][$criteria[$i]] = 'None';
                     } else {
                         if (! (($criteria[$i] == 'Key') && (($source_columns[$matching_table_index][$column_name][$criteria[$i]] == 'MUL')
-                            || ($target_columns[$matching_table_index][$column_name][$criteria[$i]] == 'MUL') 
-                            || ($source_columns[$matching_table_index][$column_name][$criteria[$i]] == 'UNI') 
+                            || ($target_columns[$matching_table_index][$column_name][$criteria[$i]] == 'MUL')
+                            || ($source_columns[$matching_table_index][$column_name][$criteria[$i]] == 'UNI')
                             || ($target_columns[$matching_table_index][$column_name][$criteria[$i]] == 'UNI')))) {
                             $alter_str_array[$matching_table_index][$column_name][$criteria[$i]] = $source_columns[$matching_table_index][$column_name][$criteria[$i]];
                         }
@@ -782,23 +773,23 @@ function PMA_structureDiffInTables($src_db, $trg_db, $src_link, $trg_link, $matc
     //Finds column names that are present in target table but not in source table
     foreach ($target_columns[$matching_table_index] as $fld_name => $each_column) {
         if (! (isset($source_columns[$matching_table_index][$fld_name]['Field']))) {
-            $fields_uncommon[] = $fld_name; 
+            $fields_uncommon[] = $fld_name;
         }
         if ($target_columns[$matching_table_index][$fld_name]['Key'] == 'PRI') {
             $keys[] = $fld_name;
         }
     }
     if (isset($fields_uncommon)) {
-        $uncommon_columns[$matching_table_index] = $fields_uncommon;   
+        $uncommon_columns[$matching_table_index] = $fields_uncommon;
     }
     if (isset($keys)) {
-        $target_tables_keys[$matching_table_index] = $keys; 
+        $target_tables_keys[$matching_table_index] = $keys;
     }
 }
 /**
 * PMA_addColumnsInTargetTable() adds column that are present in source table but not in target table
 * 
-* @param   $src_db                 name of source database 
+* @param   $src_db                 name of source database
 * @param   $trg_db                 name of target database
 * @param   $src_link               connection established with source server
 * @param   $trg_link               connection established with target server
@@ -806,7 +797,7 @@ function PMA_structureDiffInTables($src_db, $trg_db, $src_link, $trg_link, $matc
 * @param   $source_columns         array containing columns information of the source tables
 * @param   $add_column_array       array containing the names of the column(field) that are to be added in the target
 * @param   $matching_tables_fields
-* @param   $criteria               array containing the criterias 
+* @param   $criteria               array containing the criterias
 * @param   $matching_tables_keys   array containing the field names which is key in the source table
 * @param   $target_tables_keys     array containing the field names which is key in the target table
 * @param   $uncommon_tables        array containing the table names that are present in source db and not in target db
@@ -826,7 +817,7 @@ function PMA_addColumnsInTargetTable($src_db, $trg_db, $src_link, $trg_link, $ma
             if($source_columns[$table_counter][$matching_tables_fields[$table_counter][$i]]['Null'] == 'NO') {
                 $query .= ' Not Null ';
             } elseif ($source_columns[$table_counter][$matching_tables_fields[$table_counter][$i]]['Null'] == 'YES') {
-                $query .= ' Null '; 
+                $query .= ' Null ';
             }
             if ($source_columns[$table_counter][$matching_tables_fields[$table_counter][$i]]['Collation'] != '') {
                 $query .= ' COLLATE ' . $source_columns[$table_counter][$matching_tables_fields[$table_counter][$i]]['Collation'];
@@ -835,21 +826,21 @@ function PMA_addColumnsInTargetTable($src_db, $trg_db, $src_link, $trg_link, $ma
                 $query .= " DEFAULT " . $source_columns[$table_counter][$matching_tables_fields[$table_counter][$i]]['Default'];
             }
             if ($source_columns[$table_counter][$matching_tables_fields[$table_counter][$i]]['Comment'] != '') {
-                $query .= " COMMENT " . $source_columns[$table_counter][$matching_tables_fields[$table_counter][$i]]['Comment']; 
-            }                                                   
-            if ($source_columns[$table_counter][$matching_tables_fields[$table_counter][$i]]['Key'] == 'PRI' ) {  
+                $query .= " COMMENT " . $source_columns[$table_counter][$matching_tables_fields[$table_counter][$i]]['Comment'];
+            }
+            if ($source_columns[$table_counter][$matching_tables_fields[$table_counter][$i]]['Key'] == 'PRI' ) {
                 $trg_key_size = sizeof($target_tables_keys[$table_counter]);
                 if ($trg_key_size) {
                     $check = true;
-                    for ($a = 0; ($a < $trg_key_size) && ($check); $a++) {    
+                    for ($a = 0; ($a < $trg_key_size) && ($check); $a++) {
                         if (! (in_array($target_tables_keys[$table_counter], $uncommon_cols))) {
                              $check = false;
-                         }    
+                         }
                     }
                     if (! $check) {
-                        $query .= " ,DROP PRIMARY KEY " ;      
+                        $query .= " ,DROP PRIMARY KEY " ;
                     }
-                } 
+                }
                 $query .= " , ADD PRIMARY KEY (";
                 for ($t = 0; $t < sizeof($matching_tables_keys[$table_counter]); $t++) {
                     $query .= $matching_tables_keys[$table_counter][$t];
@@ -859,20 +850,20 @@ function PMA_addColumnsInTargetTable($src_db, $trg_db, $src_link, $trg_link, $ma
                 }
                 $query .= ")";
             }
-            
+
             $query .= ";";
             if ($display == true) {
                 echo '<p>' . $query . '</p>';
             }
             PMA_DBI_try_query($query, $trg_link, 0);
-          
+
             //Checks if column to be added is a foreign key or not
             $is_fk_query = "SELECT * FROM  information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = '" . $trg_db . "' AND TABLE_NAME = '"
             . $matching_tables[$table_counter] . "' AND COLUMN_NAME ='" . $add_column_array[$table_counter][$matching_tables_fields[$table_counter][$i]] .
             "' AND TABLE_NAME <> REFERENCED_TABLE_NAME;";
-            
+
             $is_fk_result = PMA_DBI_fetch_result($is_fk_query, null, null, $src_link);
-            
+
             //If column is a foreign key then it is checked that referenced table exist in target db. If referenced table does not exist in target db then 
             //it is created first.
             if (isset($is_fk_result)) {
@@ -886,8 +877,8 @@ function PMA_addColumnsInTargetTable($src_db, $trg_db, $src_link, $trg_link, $ma
                             "ADD CONSTRAINT FOREIGN KEY " . $add_column_array[$table_counter][$matching_tables_fields[$table_counter][$i]] . " 
                             (" . $add_column_array[$table_counter][$matching_tables_fields[$table_counter][$i]] . ") REFERENCES " . PMA_backquote($trg_db) .
                              '.' . PMA_backquote($is_fk_result[0]['REFERENCED_TABLE_NAME']) . " (" . $is_fk_result[0]['REFERENCED_COLUMN_NAME'] . ");";
-             
-                PMA_DBI_try_query($fk_query, $trg_link, null);    
+
+                PMA_DBI_try_query($fk_query, $trg_link, null);
             }
         }
     }
@@ -895,44 +886,43 @@ function PMA_addColumnsInTargetTable($src_db, $trg_db, $src_link, $trg_link, $ma
 /**
 * PMA_checkForeignKeys() checks if the referenced table have foreign keys.
 * uses    PMA_createTargetTables()
-* 
+*
 * @param  $src_db                 name of source database
 * @param  $src_link               connection established with source server
 * @param  $trg_db                 name of target database
 * @param  $trg_link               connection established with target server
 * @param  $referenced_table       table whose column is a foreign key in another table
-* @param  $uncommon_tables        array containing names that are uncommon 
+* @param  $uncommon_tables        array containing names that are uncommon
 * @param  $uncommon_tables_fields field names of the uncommon table
 * @param  $display                true/false value
 */
 function PMA_checkForeignKeys($src_db, $src_link, $trg_db, $trg_link ,$referenced_table, &$uncommon_tables, &$uncommon_tables_fields, $display)
 {
-    $is_fk_query = "SELECT * FROM  information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = '" . $src_db . "' 
+    $is_fk_query = "SELECT * FROM  information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = '" . $src_db . "'
                     AND TABLE_NAME = '" . $referenced_table . "' AND TABLE_NAME <> REFERENCED_TABLE_NAME;";
-    
+
     $is_fk_result = PMA_DBI_fetch_result($is_fk_query, null, null, $src_link);
     if (sizeof($is_fk_result) > 0) {
         for ($j = 0; $j < sizeof($is_fk_result); $j++) {
             if (in_array($is_fk_result[$j]['REFERENCED_TABLE_NAME'], $uncommon_tables)) {
                 $table_index = array_keys($uncommon_tables, $is_fk_result[$j]['REFERENCED_TABLE_NAME']);
-                PMA_checkForeignKeys($src_db, $src_link, $trg_db, $trg_link, $is_fk_result[$j]['REFERENCED_TABLE_NAME'], $uncommon_tables, 
-                $uncommon_tables_fields, $display); 
+                PMA_checkForeignKeys($src_db, $src_link, $trg_db, $trg_link, $is_fk_result[$j]['REFERENCED_TABLE_NAME'], $uncommon_tables,
+                $uncommon_tables_fields, $display);
                 PMA_createTargetTables($src_db, $trg_db, $trg_link, $src_link, $uncommon_tables, $table_index[0], $uncommon_tables_fields, $display);
                 unset($uncommon_tables[$table_index[0]]);
-            }      
+            }
         }
     }
 }
 /**
 * PMA_alterTargetTableStructure() alters structure of the target table using $alter_str_array
-* 
-* 
+*
 * @param   $trg_db                 name of target database
 * @param   $trg_link               connection established with target server
 * @param   $matching_tables        array containing names of matching tables
 * @param   $source_columns         array containing columns information of the source table
 * @param   $alter_str_array        array containing the column name and criteria which is to be altered for the targert table
-* @param   $matching_tables_fields array containing the name of the fields for the matching table 
+* @param   $matching_tables_fields array containing the name of the fields for the matching table
 * @param   $criteria               array containing the criterias
 * @param   $matching_tables_keys   array containing the field names which is key in the source table
 * @param   $target_tables_keys     array containing the field names which is key in the target table
@@ -940,7 +930,7 @@ function PMA_checkForeignKeys($src_db, $src_link, $trg_db, $trg_link ,$reference
 * @param   $display                true/false value
 */
 function PMA_alterTargetTableStructure($trg_db, $trg_link, $matching_tables, &$source_columns, &$alter_str_array, $matching_tables_fields, $criteria,
- &$matching_tables_keys, &$target_tables_keys, $matching_table_index, $display) 
+ &$matching_tables_keys, &$target_tables_keys, $matching_table_index, $display)
 {
     $check = true;
     $sql_query = '';
@@ -969,22 +959,22 @@ function PMA_alterTargetTableStructure($trg_db, $trg_link, $matching_tables, &$s
         }
         $pri_query .= ");";
     }
-    
+
     if (isset($pri_query)) {
         if ($display == true) {
             echo '<p>' . $pri_query . '</p>';
         }
-        PMA_DBI_try_query($pri_query, $trg_link, 0);    
+        PMA_DBI_try_query($pri_query, $trg_link, 0);
     }
     for ($t = 0; $t < sizeof($matching_tables_fields[$matching_table_index]); $t++) {
         if ((isset($alter_str_array[$matching_table_index][$matching_tables_fields[$matching_table_index][$t]])) && (sizeof($alter_str_array[$matching_table_index][$matching_tables_fields[$matching_table_index][$t]]) > 0)) {
-            $sql_query = 'ALTER TABLE ' . PMA_backquote($trg_db) . '.' . PMA_backquote($matching_tables[$matching_table_index]) . ' MODIFY ' . 
-            $matching_tables_fields[$matching_table_index][$t] . ' ' . $source_columns[$matching_table_index][$matching_tables_fields[$matching_table_index][$t]]['Type']; 
+            $sql_query = 'ALTER TABLE ' . PMA_backquote($trg_db) . '.' . PMA_backquote($matching_tables[$matching_table_index]) . ' MODIFY ' .
+            $matching_tables_fields[$matching_table_index][$t] . ' ' . $source_columns[$matching_table_index][$matching_tables_fields[$matching_table_index][$t]]['Type'];
             $found = false;
             for ($i = 0; $i < sizeof($criteria); $i++)
             {
                 if (isset($alter_str_array[$matching_table_index][$matching_tables_fields[$matching_table_index][$t]][$criteria[$i]]) && $criteria[$i] != 'Key') {
-                    $found = true; 
+                    $found = true;
                     if (($criteria[$i] == 'Type') && (! isset($alter_str_array[$matching_table_index][$matching_tables_fields[$matching_table_index][$t]][$criteria[$i+1]]))) {
                         if ($source_columns[$matching_table_index][$matching_tables_fields[$matching_table_index][$t]][$criteria[$i + 1]] == 'NO') {
                             $sql_query .= " Not Null" ;
@@ -1015,7 +1005,7 @@ function PMA_alterTargetTableStructure($trg_db, $trg_link, $matching_tables, &$s
                             if ($source_columns[$matching_table_index][$matching_tables_fields[$matching_table_index][$t]]['Type'] != 'timestamp') {
                                 $sql_query .=  " DEFAULT '" . $alter_str_array[$matching_table_index][$matching_tables_fields[$matching_table_index][$t]][$criteria[$i]] . "'";
                             } elseif($source_columns[$matching_table_index][$matching_tables_fields[$matching_table_index][$t]]['Type'] == 'timestamp') {
-                                $sql_query .=  " DEFAULT " . $alter_str_array[$matching_table_index][$matching_tables_fields[$matching_table_index][$t]][$criteria[$i]]; 
+                                $sql_query .=  " DEFAULT " . $alter_str_array[$matching_table_index][$matching_tables_fields[$matching_table_index][$t]][$criteria[$i]];
                             }
                         } elseif (is_numeric($alter_str_array[$matching_table_index][$matching_tables_fields[$matching_table_index][$t]][$criteria[$i]])) {
                             $sql_query .=  " DEFAULT " . $alter_str_array[$matching_table_index][$matching_tables_fields[$matching_table_index][$t]][$criteria[$i]];
@@ -1053,19 +1043,19 @@ function PMA_alterTargetTableStructure($trg_db, $trg_link, $matching_tables, &$s
     if ($check) {
         if ($display == true) {
             echo '<p>' . $query . '</p>';
-        }                
+        }
         PMA_DBI_try_query($query, $trg_link, 0);
     }
 }
 
 /**
 * PMA_removeColumnsFromTargetTable() removes the columns which are present in target table but not in source table.
-* 
+*
 * @param  $trg_db            name of target database
 * @param  $trg_link          connection established with target server
 * @param  $matching_tables   array containing names of matching tables
 * @param  $uncommon_columns  array containing the names of the column which are to be dropped from the target table
-* @param  $table_counter     index of the matching table as in $matchiing_tables array 
+* @param  $table_counter     index of the matching table as in $matchiing_tables array
 * @param  $display           true/false value
 */
 function PMA_removeColumnsFromTargetTable($trg_db, $trg_link, $matching_tables, $uncommon_columns, $table_counter, $display)
@@ -1074,21 +1064,21 @@ function PMA_removeColumnsFromTargetTable($trg_db, $trg_link, $matching_tables,
         $drop_query = "ALTER TABLE " . PMA_backquote($trg_db) . "." . PMA_backquote($matching_tables[$table_counter]);
         for ($a = 0; $a < sizeof($uncommon_columns[$table_counter]); $a++) {
             //Checks if column to be removed is a foreign key in any table
-            $pk_query = "SELECT * FROM information_schema.KEY_COLUMN_USAGE WHERE REFERENCED_TABLE_SCHEMA = '" . $trg_db . "' 
+            $pk_query = "SELECT * FROM information_schema.KEY_COLUMN_USAGE WHERE REFERENCED_TABLE_SCHEMA = '" . $trg_db . "'
                          AND REFERENCED_TABLE_NAME = '" . $matching_tables[$table_counter]."' AND REFERENCED_COLUMN_NAME = '"
                          . $uncommon_columns[$table_counter][$a] . "' AND TABLE_NAME <> REFERENCED_TABLE_NAME;";
-    
+
             $pk_query_result = PMA_DBI_fetch_result($pk_query, null, null, $trg_link);
             $result_size = sizeof($pk_query_result);
-             
+
             if ($result_size > 0) {
                 for ($b = 0; $b < $result_size; $b++) {
                     $drop_pk_query = "ALTER TABLE " . PMA_backquote($pk_query_result[$b]['TABLE_SCHEMA']) . "." . PMA_backquote($pk_query_result[$b]['TABLE_NAME']) . "
                                       DROP FOREIGN KEY " . $pk_query_result[$b]['CONSTRAINT_NAME'] . ", DROP COLUMN " . $pk_query_result[$b]['COLUMN_NAME'] . ";";
-                    PMA_DBI_try_query($drop_pk_query, $trg_link, 0);                   
-                }              
-            }       
-            $query = "SELECT * FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = '" . $trg_db . "' AND TABLE_NAME = '" 
+                    PMA_DBI_try_query($drop_pk_query, $trg_link, 0);
+                }
+            }
+            $query = "SELECT * FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = '" . $trg_db . "' AND TABLE_NAME = '"
                      . $matching_tables[$table_counter]. "' AND COLUMN_NAME = '" . $uncommon_columns[$table_counter][$a] . "'
                       AND TABLE_NAME <> REFERENCED_TABLE_NAME;";
 
@@ -1100,41 +1090,40 @@ function PMA_removeColumnsFromTargetTable($trg_db, $trg_link, $matching_tables,
             $drop_query .=  " DROP COLUMN " . $uncommon_columns[$table_counter][$a];
             if ($a < (sizeof($uncommon_columns[$table_counter]) - 1)) {
                 $drop_query .= " , " ;
-            } 
+            }
         }
         $drop_query .= ";" ;
-        
+
         if ($display == true) {
             echo '<p>' . $drop_query . '</p>';
         }
-        PMA_DBI_try_query($drop_query, $trg_link, 0); 
-    } 
-} 
+        PMA_DBI_try_query($drop_query, $trg_link, 0);
+    }
+}
+
 /**
-*  PMA_indexesDiffInTables() compares the source table indexes with target table indexes and keep the indexes to be added in target table in $add_indexes_array
-*  indexes to be altered in $alter_indexes_array and indexes to be removed from target table in $remove_indexes_array.
-*  Only keyname and uniqueness characteristic of the indexes are altered.
-*  @uses  sizeof()
-*  @uses  PMA_get_table_indexes()
-* 
-* @param   $src_db                 name of source database 
+* PMA_indexesDiffInTables() compares the source table indexes with target table indexes and keep the indexes to be added in target table in $add_indexes_array
+* indexes to be altered in $alter_indexes_array and indexes to be removed from target table in $remove_indexes_array.
+* Only keyname and uniqueness characteristic of the indexes are altered.
+*
+* @param   $src_db                 name of source database
 * @param   $trg_db                 name of target database
 * @param   $src_link               connection established with source server
 * @param   $trg_link               connection established with target server
 * @param  $matching_tables         array containing the matching tables name
-* @param  $source_indexes          array containing the indexes of the source table 
+* @param  $source_indexes          array containing the indexes of the source table
 * @param  $target_indexes          array containing the indexes of the target table
 * @param  $add_indexes_array       array containing the name of the column on which the index is to be added in the target table
 * @param  $alter_indexes_array     array containing the key name which needs to be altered
 * @param  $remove_indexes_array    array containing the key name of the index which is to be removed from the target table
-* @param  $table_counter           number of the matching table 
+* @param  $table_counter           number of the matching table
 */
 function PMA_indexesDiffInTables($src_db, $trg_db, $src_link, $trg_link, $matching_tables, &$source_indexes, &$target_indexes, &$add_indexes_array,
  &$alter_indexes_array, &$remove_indexes_array, $table_counter)
 {
     //Gets indexes information for source and target table
     $source_indexes[$table_counter] = PMA_get_table_indexes($src_db, $matching_tables[$table_counter],$src_link);
-    $target_indexes[$table_counter] = PMA_get_table_indexes($trg_db, $matching_tables[$table_counter],$trg_link); 
+    $target_indexes[$table_counter] = PMA_get_table_indexes($trg_db, $matching_tables[$table_counter],$trg_link);
     for ($a = 0; $a < sizeof($source_indexes[$table_counter]); $a++) {
         $found = false;
         $z = 0;
@@ -1152,15 +1141,15 @@ function PMA_indexesDiffInTables($src_db, $trg_db, $src_link, $trg_link, $matchi
                     }
                 }
             }
-            $z++; 
+            $z++;
         }
         if ($found === false) {
             if(! ($source_indexes[$table_counter][$a]['Key_name'] == 'PRIMARY')) {
-                $add_indexes_array [$table_counter][] = $source_indexes[$table_counter][$a]['Column_name']; 
+                $add_indexes_array [$table_counter][] = $source_indexes[$table_counter][$a]['Column_name'];
             }
         }
     }
-    
+
     //Finds indexes that exist on target table but not on source table
     for ($b = 0; $b < sizeof($target_indexes[$table_counter]); $b++) {
         $found = false;
@@ -1170,29 +1159,29 @@ function PMA_indexesDiffInTables($src_db, $trg_db, $src_link, $trg_link, $matchi
             if ($target_indexes[$table_counter][$b]['Column_name'] == $source_indexes[$table_counter][$c]['Column_name']) {
                 $found = true;
             }
-            $c++; 
+            $c++;
         }
         if ($found === false) {
-            $remove_indexes_array[$table_counter][] = $target_indexes[$table_counter][$b]['Key_name']; 
+            $remove_indexes_array[$table_counter][] = $target_indexes[$table_counter][$b]['Key_name'];
         }
     }
 }
 
 /**
-* PMA_applyIndexesDiff() create indexes, alters indexes and remove indexes.  
-* 
+* PMA_applyIndexesDiff() create indexes, alters indexes and remove indexes.
+*
 * @param   $trg_db                 name of target database
 * @param   $trg_link               connection established with target server
 * @param  $matching_tables         array containing the matching tables name
-* @param  $source_indexes          array containing the indexes of the source table 
+* @param  $source_indexes          array containing the indexes of the source table
 * @param  $target_indexes          array containing the indexes of the target table
 * @param  $add_indexes_array       array containing the column names on which indexes are to be created in target table
 * @param  $alter_indexes_array     array containing the column names for which indexes are to be altered
 * @param  $remove_indexes_array    array containing the key name of the indexes which are to be removed from the target table
-* @param  $table_counter           number of the matching table 
+* @param  $table_counter           number of the matching table
 * @param  $display                 true/false value
 */
-function PMA_applyIndexesDiff ($trg_db, $trg_link, $matching_tables, $source_indexes, $target_indexes, $add_indexes_array, $alter_indexes_array, 
+function PMA_applyIndexesDiff ($trg_db, $trg_link, $matching_tables, $source_indexes, $target_indexes, $add_indexes_array, $alter_indexes_array,
           $remove_indexes_array, $table_counter, $display)
 {
     //Adds indexes on target table
@@ -1200,7 +1189,7 @@ function PMA_applyIndexesDiff ($trg_db, $trg_link, $matching_tables, $source_ind
         $sql = "ALTER TABLE " . PMA_backquote($trg_db) . "." . PMA_backquote($matching_tables[$table_counter]) . " ADD" ;
         for ($a = 0; $a < sizeof($source_indexes[$table_counter]); $a++) {
             if (isset($add_indexes_array[$table_counter][$a])) {
-                for ($b = 0; $b < sizeof($source_indexes[$table_counter]); $b++) {                                                              
+                for ($b = 0; $b < sizeof($source_indexes[$table_counter]); $b++) {
                     if ($source_indexes[$table_counter][$b]['Column_name'] == $add_indexes_array[$table_counter][$a]) {
                         if ($source_indexes[$table_counter][$b]['Non_unique'] == '0') {
                             $sql .= " UNIQUE ";
@@ -1221,9 +1210,9 @@ function PMA_applyIndexesDiff ($trg_db, $trg_link, $matching_tables, $source_ind
         $query = "ALTER TABLE " . PMA_backquote($trg_db) . "." . PMA_backquote($matching_tables[$table_counter]);
         for ($a = 0; $a < sizeof($alter_indexes_array[$table_counter]); $a++) {
             if (isset($alter_indexes_array[$table_counter][$a])) {
-                $query .= ' DROP INDEX ' . PMA_backquote($alter_indexes_array[$table_counter][$a]) . " , ADD ";       
+                $query .= ' DROP INDEX ' . PMA_backquote($alter_indexes_array[$table_counter][$a]) . " , ADD ";
                 $got_first_index_column = false;
-                for ($z = 0; $z < sizeof($source_indexes[$table_counter]); $z++) {                                                               
+                for ($z = 0; $z < sizeof($source_indexes[$table_counter]); $z++) {
                     if ($source_indexes[$table_counter][$z]['Key_name'] == $alter_indexes_array[$table_counter][$a]) {
                         if (! $got_first_index_column) {
                             if ($source_indexes[$table_counter][$z]['Non_unique'] == '0') {
@@ -1250,25 +1239,25 @@ function PMA_applyIndexesDiff ($trg_db, $trg_link, $matching_tables, $source_ind
         $drop_index_query = "ALTER TABLE " . PMA_backquote($trg_db) . "." . PMA_backquote($matching_tables[$table_counter]);
         for ($a = 0; $a < sizeof($target_indexes[$table_counter]); $a++) {
             if (isset($remove_indexes_array[$table_counter][$a])) {
-                $drop_index_query .= " DROP INDEX " . $remove_indexes_array[$table_counter][$a];  
+                $drop_index_query .= " DROP INDEX " . $remove_indexes_array[$table_counter][$a];
             }
             if ($a < (sizeof($remove_indexes_array[$table_counter]) - 1)) {
                 $drop_index_query .= " , " ;
             }
         }
-        $drop_index_query .= " ; " ; 
+        $drop_index_query .= " ; " ;
         if ($display == true) {
             echo '<p>' . $drop_index_query . '</p>';
         }
-        PMA_DBI_try_query($drop_index_query, $trg_link, 0); 
+        PMA_DBI_try_query($drop_index_query, $trg_link, 0);
     }
 }
 
 /**
  * PMA_displayQuery() displays a query, taking the maximum display size
- * into account 
- * 
- * @param   $query                 the query to display 
+ * into account
+ *
+ * @param   $query                 the query to display
 */
 function PMA_displayQuery($query) {
     if (strlen($query) > $GLOBALS['cfg']['MaxCharactersInDisplayedSQL']) {
@@ -1278,12 +1267,12 @@ function PMA_displayQuery($query) {
 }
 
 /**
- * PMA_syncDisplayHeaderSource() shows the header for source database 
+ * PMA_syncDisplayHeaderSource() shows the header for source database
  *
- * @param  string $src_db          source db name 
+ * @param  string $src_db          source db name
 */
 function PMA_syncDisplayHeaderSource($src_db) {
-    echo '<div id="serverstatus" style = "overflow: auto; width: 1020px; height: 220px; border-left: 1px gray solid; border-bottom: 1px gray solid; padding:0px; margin-bottom: 1em "> ';
+    echo '<div id="serverstatus" style = "overflow: auto; width: 1020px; height: 220px; border-left: 1px gray solid; border-bottom: 1px gray solid; padding:0; margin-bottom: 1em "> ';
 
     echo '<table id="serverstatusconnections" class="data" width="55%">';
     echo '<tr>';
@@ -1300,10 +1289,10 @@ function PMA_syncDisplayHeaderSource($src_db) {
 
 /**
  * PMA_syncDisplayHeaderTargetAndMatchingTables() shows the header for target database and the matching tables
- * 
- * @param   string  $trg_db          target db name 
+ *
+ * @param   string  $trg_db          target db name
  * @param   array   $matching_tables
- * @return  boolean $odd_row         current value of this toggle 
+ * @return  boolean $odd_row         current value of this toggle
 */
 function PMA_syncDisplayHeaderTargetAndMatchingTables($trg_db, $matching_tables) {
     echo '<table id="serverstatusconnections" class="data" width="43%">';
@@ -1326,10 +1315,10 @@ function PMA_syncDisplayHeaderTargetAndMatchingTables($trg_db, $matching_tables)
 }
 
 /**
- * PMA_syncDisplayBeginTableRow() displays the TR tag for alternating colors 
- * 
- * @param   boolean $odd_row        current status of the toggle 
- * @return  boolean $odd_row        final status of the toggle 
+ * PMA_syncDisplayBeginTableRow() displays the TR tag for alternating colors
+ *
+ * @param   boolean $odd_row        current status of the toggle
+ * @return  boolean $odd_row        final status of the toggle
 */
 function PMA_syncDisplayBeginTableRow($odd_row) {
     $odd_row = ! $odd_row;
@@ -1348,7 +1337,6 @@ function PMA_syncDisplayBeginTableRow($odd_row) {
  * @param   mixed   $link       mysql link resource
  * @return  array   $field_values
  */
-
 function PMA_get_column_values($database, $table, $column, $link = null)
 {
     $query = 'SELECT ';
@@ -1377,7 +1365,6 @@ function PMA_get_column_values($database, $table, $column, $link = null)
 * @param    mixed   $link       mysql link resource
 * @return   array   $indexes
 */
-
 function PMA_get_table_indexes($database, $table, $link = null)
 {
 


hooks/post-receive
-- 
phpMyAdmin




More information about the Git mailing list