/** * Delete related tranformatioinformationn information * * @param String $db current database * @param String $table current table * @param array $analyzed_sql analyzed sql query * * @return void */ function PMA_deleteTransformationInfo($db, $table, $analyzed_sql) { include_once 'libraries/transformations.lib.php'; if ($analyzed_sql[0]['querytype'] == 'ALTER') { $posDrop = mb_stripos($analyzed_sql[0]['unsorted_query'], 'DROP'); if ($posDrop !== false) { $drop_column = PMA_getColumnNameInColumnDropSql($analyzed_sql[0]['unsorted_query']); if ($drop_column != '') { PMA_clearTransformations($db, $table, $drop_column); } } } else { if ($analyzed_sql[0]['querytype'] == 'DROP' && $table != '') { PMA_clearTransformations($db, $table); } } }
include_once 'libraries/relation_cleanup.lib.php'; PMA_relationsCleanupColumn($db, $table, $dropped_column); // to refresh the list of indexes (Ajax mode) $extra_data['indexes_list'] = PMA_Index::getView($table, $db); } // end if column was dropped } // end else "didn't ask to see php code" // No rows returned -> move back to the calling page if (0 == $num_rows && 0 == $unlim_num_rows || $is_affected) { // Delete related tranformation information if (!empty($analyzed_sql[0]['querytype']) && ($analyzed_sql[0]['querytype'] == 'ALTER' || $analyzed_sql[0]['querytype'] == 'DROP')) { include_once 'libraries/transformations.lib.php'; if ($analyzed_sql[0]['querytype'] == 'ALTER') { if (stripos($analyzed_sql[0]['unsorted_query'], 'DROP') !== false) { $drop_column = PMA_getColumnNameInColumnDropSql($analyzed_sql[0]['unsorted_query']); if ($drop_column != '') { PMA_clearTransformations($db, $table, $drop_column); } } } else { if ($analyzed_sql[0]['querytype'] == 'DROP' && $table != '') { PMA_clearTransformations($db, $table); } } } if ($is_delete) { $message = PMA_Message::getMessageForDeletedRows($num_rows); } elseif ($is_insert) { if ($is_replace) { // For replace we get DELETED + INSERTED row count,