diff --git a/htdocs/sql/tbl_printview.php b/htdocs/sql/tbl_printview.php deleted file mode 100755 --- a/htdocs/sql/tbl_printview.php +++ /dev/null @@ -1,560 +0,0 @@ - 1); - -if ($multi_tables) { - if (empty($GLOBALS['is_header_sent'])) { - require_once './libraries/header.inc.php'; - } - $tbl_list = ''; - foreach ($the_tables as $key => $table) { - $tbl_list .= (empty($tbl_list) ? '' : ', ') - . PMA_backquote(urldecode($table)); - } - echo ''. $strShowTables . ': ' . $tbl_list . '' . "\n"; - echo '
' . "\n"; -} // end if - -$tables_cnt = count($the_tables); -$counter = 0; - -foreach ($the_tables as $key => $table) { - $table = urldecode($table); - if ($counter + 1 >= $tables_cnt) { - $breakstyle = ''; - } else { - $breakstyle = ' style="page-break-after: always;"'; - } - $counter++; - echo '' . "\n"; - echo '

' . $table . '

' . "\n"; - - /** - * Gets table informations - */ - $result = PMA_DBI_query( - 'SHOW TABLE STATUS LIKE \'' . PMA_sqlAddslashes($table, true) . '\';'); - $showtable = PMA_DBI_fetch_assoc($result); - $num_rows = (isset($showtable['Rows']) ? $showtable['Rows'] : 0); - $show_comment = (isset($showtable['Comment']) ? $showtable['Comment'] : ''); - PMA_DBI_free_result($result); - - $tbl_is_view = PMA_Table::isView($db, $table); - - // Gets table keys and store them in arrays - $indexes = array(); - $indexes_info = array(); - $indexes_data = array(); - $ret_keys = PMA_get_indexes($table, $err_url_0); - - PMA_extract_indexes($ret_keys, $indexes, $indexes_info, $indexes_data); - - /** - * Gets fields properties - */ - $result = PMA_DBI_query( - 'SHOW FIELDS FROM ' . PMA_backquote($table) . ';', null, - PMA_DBI_QUERY_STORE); - $fields_cnt = PMA_DBI_num_rows($result); - - -// We need this to correctly learn if a TIMESTAMP is NOT NULL, since -// SHOW FULL FIELDS or INFORMATION_SCHEMA incorrectly says NULL -// and SHOW CREATE TABLE says NOT NULL (tested -// in MySQL 4.0.25 and 5.0.21, http://bugs.mysql.com/20910). - - $show_create_table = PMA_DBI_fetch_value( - 'SHOW CREATE TABLE ' . PMA_backquote($db) . '.' . PMA_backquote($table), - 0, 1); - $analyzed_sql = PMA_SQP_analyze(PMA_SQP_parse($show_create_table)); - - // Check if we can use Relations (Mike Beck) - if (!empty($cfgRelation['relation'])) { - // Find which tables are related with the current one and write it in - // an array - $res_rel = PMA_getForeigners($db, $table); - - if (count($res_rel) > 0) { - $have_rel = true; - } else { - $have_rel = false; - } - } else { - $have_rel = false; - } // end if - - - /** - * Displays the comments of the table if MySQL >= 3.23 - */ - if (!empty($show_comment)) { - echo $strTableComments . ': ' . htmlspecialchars($show_comment) . '

'; - } - - /** - * Displays the table structure - */ - ?> - - - - - - - - - - - - ' . $strLinksTo . '' . "\n"; - } - if ($cfgRelation['commwork'] || PMA_MYSQL_INT_VERSION >= 40100) { - echo ' ' . "\n"; - } - if ($cfgRelation['mimework']) { - echo ' ' . "\n"; - } - ?> - - - - NULL'; - } - } else { - $row['Default'] = htmlspecialchars($row['Default']); - } - $field_name = htmlspecialchars($row['Field']); - - // here, we have a TIMESTAMP that SHOW FULL FIELDS reports as having the - // NULL attribute, but SHOW CREATE TABLE says the contrary. Believe - // the latter. - /** - * @todo merge this logic with the one in tbl_structure.php - * or move it in a function similar to PMA_DBI_get_columns_full() - * but based on SHOW CREATE TABLE because information_schema - * cannot be trusted in this case (MySQL bug) - */ - if (!empty($analyzed_sql[0]['create_table_fields'][$field_name]['type']) && $analyzed_sql[0]['create_table_fields'][$field_name]['type'] == 'TIMESTAMP' && $analyzed_sql[0]['create_table_fields'][$field_name]['timestamp_not_null']) { - $row['Null'] = ''; - } - ?> - - - - - - - - '; - if (isset($res_rel[$field_name])) { - echo htmlspecialchars($res_rel[$field_name]['foreign_table'] . ' -> ' . $res_rel[$field_name]['foreign_field']); - } - echo ' ' . "\n"; - } - if ($cfgRelation['commwork'] || PMA_MYSQL_INT_VERSION >= 40100) { - echo ' ' . "\n"; - } - if ($cfgRelation['mimework']) { - $mime_map = PMA_getMIME($db, $table, true); - - echo ' ' . "\n"; - } - ?> - - - -
' . $strComments . 'MIME
- ' . $field_name . '' . "\n"; - } else { - echo ' ' . $field_name . "\n"; - } - ?> -   '; - $comments = PMA_getComments($db, $table); - if (isset($comments[$field_name])) { - echo htmlspecialchars($comments[$field_name]); - } - echo ' '; - if (isset($mime_map[$field_name])) { - echo htmlspecialchars(str_replace('_', '/', $mime_map[$field_name]['mimetype'])); - } - echo ' 
- - 0) { - echo "\n"; - ?> -

- - - - - - - - - - - -
- 0) { - list($free_size, $free_unit) = PMA_formatByteDown($showtable['Data_free']); - list($effect_size, $effect_unit) = PMA_formatByteDown($showtable['Data_length'] + $showtable['Index_length'] - $showtable['Data_free']); - } else { - unset($free_size); - unset($free_unit); - list($effect_size, $effect_unit) = PMA_formatByteDown($showtable['Data_length'] + $showtable['Index_length']); - } - list($tot_size, $tot_unit) = PMA_formatByteDown($showtable['Data_length'] + $showtable['Index_length']); - if ($num_rows > 0) { - list($avg_size, $avg_unit) = PMA_formatByteDown(($showtable['Data_length'] + $showtable['Index_length']) / $showtable['Rows'], 6, 1); - } - - // Displays them - ?> -

- - - - - - - - - - - - -
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
- 		  - - - - - - - - - - - - - - - - - 0) { - ?> - - - - - 0 && $mergetable == false) { - ?> - - - - - - - - - - - - - - - - - - - - - - - - - - -
- -
- -
 ø - -
 ø - -
 Autoindex - -
- -
- -
- -
-
- - ' . "\n"; - } // end if - echo '' . "\n"; - -} // end while - -/** - * Displays the footer - */ -?> - - - -

-

- -