2
/* $Id: db_datadict.php 9602 2006-10-25 12:25:01Z nijel $ */
6
* Gets the variables sent or posted to this script, then displays headers
8
require_once('./libraries/common.lib.php');
10
if (!isset($selected_tbl)) {
11
require_once('./libraries/header.inc.php');
16
* Gets the relations settings
18
require_once('./libraries/relation.lib.php');
19
require_once('./libraries/transformations.lib.php');
21
$cfgRelation = PMA_getRelationsParam();
26
PMA_checkParameters(array('db'));
29
* Defines the url to return to in case of error in a sql statement
32
$err_url = 'tbl_sql.php?' . PMA_generate_common_url($db, $table);
34
$err_url = 'db_sql.php?' . PMA_generate_common_url($db);
37
if ($cfgRelation['commwork']) {
38
$comment = PMA_getComments($db);
43
if (is_array($comment)) {
45
<p> <?php echo $strDBComment; ?>
46
<i><?php echo htmlspecialchars( implode( ' ', $comment ) ); ?></i></p>
52
* Selects the database and gets tables names
54
PMA_DBI_select_db($db);
55
$rowset = PMA_DBI_query('SHOW TABLES FROM ' . PMA_backquote($db) . ';', null, PMA_DBI_QUERY_STORE);
58
while ($row = PMA_DBI_fetch_assoc($rowset)) {
59
$myfieldname = 'Tables_in_' . htmlspecialchars($db);
60
$table = $row[$myfieldname];
61
if ($cfgRelation['commwork'] || PMA_MYSQL_INT_VERSION >= 40100) {
62
$comments = PMA_getComments($db, $table);
66
echo '<div style="page-break-before: always;">' . "\n";
71
echo '<h2>' . $table . '</h2>' . "\n";
74
* Gets table informations
76
// The 'show table' statement works correct since 3.23.03
77
$showtable = PMA_DBI_get_tables_full( $db, $table );
78
$num_rows = (isset($showtable[$table]['TABLE_ROWS']) ? $showtable[$table]['TABLE_ROWS'] : 0);
79
$show_comment = (isset($showtable[$table]['TABLE_COMMENT']) ? $showtable[$table]['TABLE_COMMENT'] : '');
84
* Gets table keys and retains them
87
PMA_DBI_select_db($db);
88
$result = PMA_DBI_query('SHOW KEYS FROM ' . PMA_backquote($table) . ';');
92
$indexes_info = array();
93
$indexes_data = array();
94
$pk_array = array(); // will be use to emphasis prim. keys in the table
96
while ($row = PMA_DBI_fetch_assoc($result)) {
97
// Backups the list of primary keys
98
if ($row['Key_name'] == 'PRIMARY') {
99
$primary .= $row['Column_name'] . ', ';
100
$pk_array[$row['Column_name']] = 1;
102
// Retains keys informations
103
if ($row['Key_name'] != $lastIndex ){
104
$indexes[] = $row['Key_name'];
105
$lastIndex = $row['Key_name'];
107
$indexes_info[$row['Key_name']]['Sequences'][] = $row['Seq_in_index'];
108
$indexes_info[$row['Key_name']]['Non_unique'] = $row['Non_unique'];
109
if (isset($row['Cardinality'])) {
110
$indexes_info[$row['Key_name']]['Cardinality'] = $row['Cardinality'];
112
// I don't know what does following column mean....
113
// $indexes_info[$row['Key_name']]['Packed'] = $row['Packed'];
115
$indexes_info[$row['Key_name']]['Comment'] = $row['Comment'];
117
$indexes_data[$row['Key_name']][$row['Seq_in_index']]['Column_name'] = $row['Column_name'];
118
if (isset($row['Sub_part'])) {
119
$indexes_data[$row['Key_name']][$row['Seq_in_index']]['Sub_part'] = $row['Sub_part'];
124
PMA_DBI_free_result($result);
129
* Gets fields properties
131
$result = PMA_DBI_query('SHOW FIELDS FROM ' . PMA_backquote($table) . ';', null, PMA_DBI_QUERY_STORE);
132
$fields_cnt = PMA_DBI_num_rows($result);
135
// We need this to correctly learn if a TIMESTAMP is NOT NULL, since
136
// SHOW FULL FIELDS or INFORMATION_SCHEMA incorrectly says NULL
137
// and SHOW CREATE TABLE says NOT NULL (tested
138
// in MySQL 4.0.25 and 5.0.21, http://bugs.mysql.com/20910).
140
$show_create_table = PMA_DBI_fetch_value(
141
'SHOW CREATE TABLE ' . PMA_backquote($db) . '.' . PMA_backquote($table),
143
$analyzed_sql = PMA_SQP_analyze(PMA_SQP_parse($show_create_table));
145
// Check if we can use Relations (Mike Beck)
146
if (!empty($cfgRelation['relation'])) {
147
// Find which tables are related with the current one and write it in
149
$res_rel = PMA_getForeigners($db, $table);
151
if (count($res_rel) > 0) {
162
* Displays the comments of the table if MySQL >= 3.23
164
if (!empty($show_comment)) {
165
echo $strTableComments . ': ' . $show_comment . '<br /><br />';
169
* Displays the table structure
173
<table width="100%" class="print">
174
<tr><th width="50"><?php echo $strField; ?></th>
175
<th width="80"><?php echo $strType; ?></th>
176
<?php /* <th width="50"><?php echo $strAttr; ?></th>*/ ?>
177
<th width="40"><?php echo $strNull; ?></th>
178
<th width="70"><?php echo $strDefault; ?></th>
179
<?php /* <th width="50"><?php echo $strExtra; ?></th>*/ ?>
182
echo ' <th>' . $strLinksTo . '</th>' . "\n";
184
if ($cfgRelation['commwork'] || PMA_MYSQL_INT_VERSION >= 40100) {
185
echo ' <th>' . $strComments . '</th>' . "\n";
187
if ($cfgRelation['mimework']) {
188
echo ' <th>MIME</th>' . "\n";
194
while ($row = PMA_DBI_fetch_assoc($result)) {
196
$type = $row['Type'];
197
// reformat mysql query output - staybyte - 9. June 2001
198
// loic1: set or enum types: slashes single quotes inside options
199
if (preg_match('@^(set|enum)\((.+)\)$@i', $type, $tmp)) {
200
$tmp[2] = substr(preg_replace('@([^,])\'\'@', '\\1\\\'', ',' . $tmp[2]), 1);
201
$type = $tmp[1] . '(' . str_replace(',', ', ', $tmp[2]) . ')';
208
$binary = stristr($row['Type'], 'binary');
209
$unsigned = stristr($row['Type'], 'unsigned');
210
$zerofill = stristr($row['Type'], 'zerofill');
211
$type_nowrap = ' nowrap="nowrap"';
212
$type = preg_replace('@BINARY@i', '', $type);
213
$type = preg_replace('@ZEROFILL@i', '', $type);
214
$type = preg_replace('@UNSIGNED@i', '', $type);
221
$strAttribute = 'BINARY';
224
$strAttribute = 'UNSIGNED';
227
$strAttribute = 'UNSIGNED ZEROFILL';
229
if (!isset($row['Default'])) {
230
if ($row['Null'] != '' && $row['Null'] != 'NO') {
231
$row['Default'] = '<i>NULL</i>';
234
$row['Default'] = htmlspecialchars($row['Default']);
236
$field_name = htmlspecialchars($row['Field']);
238
// here, we have a TIMESTAMP that SHOW FULL FIELDS reports as having the
239
// NULL attribute, but SHOW CREATE TABLE says the contrary. Believe
242
* @todo merge this logic with the one in tbl_structure.php
243
* or move it in a function similar to PMA_DBI_get_columns_full()
244
* but based on SHOW CREATE TABLE because information_schema
245
* cannot be trusted in this case (MySQL bug)
247
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']) {
251
<tr class="<?php echo $odd_row ? 'odd' : 'even'; $odd_row = ! $odd_row; ?>">
254
if (isset($pk_array[$row['Field']])) {
255
echo '<u>' . $field_name . '</u>';
261
<td<?php echo $type_nowrap; ?> xml:lang="en" dir="ltr"><?php echo $type; ?></td>
262
<?php /* <td<?php echo $type_nowrap; ?>><?php echo $strAttribute; ?></td>*/ ?>
263
<td><?php echo (($row['Null'] == '' || $row['Null'] == 'NO') ? $strNo : $strYes); ?></td>
264
<td nowrap="nowrap"><?php if (isset($row['Default'])) { echo $row['Default']; } ?></td>
265
<?php /* <td<?php echo $type_nowrap; ?>><?php echo $row['Extra']; ?></td>*/ ?>
269
if (isset($res_rel[$field_name])) {
270
echo htmlspecialchars($res_rel[$field_name]['foreign_table'] . ' -> ' . $res_rel[$field_name]['foreign_field']);
274
if ($cfgRelation['commwork'] || PMA_MYSQL_INT_VERSION >= 40100) {
276
if (isset($comments[$field_name])) {
277
echo htmlspecialchars($comments[$field_name]);
281
if ($cfgRelation['mimework']) {
282
$mime_map = PMA_getMIME($db, $table, true);
285
if (isset($mime_map[$field_name])) {
286
echo htmlspecialchars(str_replace('_', '/', $mime_map[$field_name]['mimetype']));
294
PMA_DBI_free_result( $result );
303
* Displays the footer
306
<script type="text/javascript" language="javascript">
310
document.getElementById('print').style.visibility = 'hidden';
312
if (typeof(window.print) != 'undefined') {
315
document.getElementById('print').style.visibility = '';
320
echo '<br /><br /><input type="button" id="print" value="' . $strPrint . '" onclick="printPage()" />';
322
require_once('./libraries/footer.inc.php');