<?php

/* vim: set expandtab sw=4 ts=4 sts=4: */

/**

* Renders data dictionary

*

* @package PhpMyAdmin

*/

use PhpMyAdmin\Relation;

use PhpMyAdmin\Response;

use PhpMyAdmin\Transformations;

use PhpMyAdmin\Url;

/**

* Gets the variables sent or posted to this script, then displays headers

*/

require_once 'libraries/common.inc.php';

if (! isset($selected_tbl)) {

include 'libraries/db_common.inc.php';

list(

$tables,

$num_tables,

$total_num_tables,

$sub_part,

$is_show_stats,

$db_is_system_schema,

$tooltip_truename,

$tooltip_aliasname,

$pos

) = PhpMyAdmin\Util::getDbInfo($db, isset($sub_part) ? $sub_part : '');

}

$response = Response::getInstance();

$header = $response->getHeader();

$header->enablePrintView();

$relation = new Relation();

$transformations = new Transformations();

/**

* Gets the relations settings

*/

$cfgRelation = $relation->getRelationsParam();

/**

* Check parameters

*/

PhpMyAdmin\Util::checkParameters(array('db'));

/**

* Defines the url to return to in case of error in a sql statement

*/

$err_url = 'db_sql.php' . Url::getCommon(array('db' => $db));

if ($cfgRelation['commwork']) {

$comment = $relation->getDbComment($db);

/**

* Displays DB comment

*/

if ($comment) {

echo '<p>' , __('Database comment')

, '<br /><i>' , htmlspecialchars($comment) , '</i></p>';

} // end if

}

/**

* Selects the database and gets tables names

*/

$GLOBALS['dbi']->selectDb($db);

$tables = $GLOBALS['dbi']->getTables($db);

$count = 0;

foreach ($tables as $table) {

$comments = $relation->getComments($db, $table);

echo '<div>' , "\n";

echo '<h2>' , htmlspecialchars($table) , '</h2>' , "\n";

/**

* Gets table information

*/

$show_comment = $GLOBALS['dbi']->getTable($db, $table)

->getStatusInfo('TABLE_COMMENT');

/**

* Gets table keys and retains them

*/

$GLOBALS['dbi']->selectDb($db);

$indexes = $GLOBALS['dbi']->getTableIndexes($db, $table);

list($primary, $pk_array, $indexes_info, $indexes_data)

= PhpMyAdmin\Util::processIndexData($indexes);

/**

* Gets columns properties

*/

$columns = $GLOBALS['dbi']->getColumns($db, $table);

// Check if we can use Relations

list($res_rel, $have_rel) = $relation->getRelationsAndStatus(

! empty($cfgRelation['relation']), $db, $table

);

/**

* Displays the comments of the table if MySQL >= 3.23

*/

if (!empty($show_comment)) {

echo __('Table comments:') , ' ';

echo htmlspecialchars($show_comment) , '<br /><br />';

}

/**

* Displays the table structure

*/

echo '<table width="100%" class="print">';

echo '<tr><th width="50">' , __('Column') , '</th>';

echo '<th width="80">' , __('Type') , '</th>';

echo '<th width="40">' , __('Null') , '</th>';

echo '<th width="70">' , __('Default') , '</th>';

if ($have_rel) {

echo ' <th>' , __('Links to') , '</th>' , "\n";

}

echo ' <th>' , __('Comments') , '</th>' , "\n";

if ($cfgRelation['mimework']) {

echo ' <th>MIME</th>' , "\n";

}

echo '</tr>';

foreach ($columns as $row) {

if ($row['Null'] == '') {

$row['Null'] = 'NO';

}

$extracted_columnspec

= PhpMyAdmin\Util::extractColumnSpec($row['Type']);

// reformat mysql query output

// set or enum types: slashes single quotes inside options

$type = htmlspecialchars($extracted_columnspec['print_type']);

$attribute = $extracted_columnspec['attribute'];

if (! isset($row['Default'])) {

if ($row['Null'] != 'NO') {

$row['Default'] = '<i>NULL</i>';

}

} else {

$row['Default'] = htmlspecialchars($row['Default']);

}

$column_name = $row['Field'];

echo '<tr>';

echo '<td class="nowrap">';

echo htmlspecialchars($column_name);

if (isset($pk_array[$row['Field']])) {

echo ' <em>(' , __('Primary') , ')</em>';

}

echo '</td>';

echo '<td'

, PhpMyAdmin\Util::getClassForType(

$extracted_columnspec['type']

)

, ' lang="en" dir="ltr">' , $type , '</td>';

echo '<td>';

echo (($row['Null'] == 'NO') ? __('No') : __('Yes'));

echo '</td>';

echo '<td class="nowrap">';

if (isset($row['Default'])) {

echo $row['Default'];

}

echo '</td>';

if ($have_rel) {

echo ' <td>';

if ($foreigner = $relation->searchColumnInForeigners($res_rel, $column_name)) {

echo htmlspecialchars(

$foreigner['foreign_table']

. ' -> '

. $foreigner['foreign_field']

);

}

echo '</td>' , "\n";

}

echo ' <td>';

if (isset($comments[$column_name])) {

echo htmlspecialchars($comments[$column_name]);

}

echo '</td>' , "\n";

if ($cfgRelation['mimework']) {

$mime_map = $transformations->getMime($db, $table, true);

echo ' <td>';

if (isset($mime_map[$column_name])) {

echo htmlspecialchars(

str_replace('_', '/', $mime_map[$column_name]['mimetype'])

);

}

echo '</td>' , "\n";

}

echo '</tr>';

} // end foreach

$count++;

echo '</table>';

// display indexes information

if (count(PhpMyAdmin\Index::getFromTable($table, $db)) > 0) {

echo PhpMyAdmin\Index::getHtmlForIndexes($table, $db, true);

}

echo '</div>';

} //ends main while

/**

* Displays the footer

*/

echo PhpMyAdmin\Util::getButton();