libraries/display_structure.inc.php

   1 <?php
   2 /* vim: set expandtab sw=4 ts=4 sts=4: */
   3 /**
   4  * Displays the table structure ('show table' works correct since 3.23.03)
   5  *
   6  * @package PhpMyAdmin
   7  */
   8
   9 require_once 'libraries/common.inc.php';
  10 require_once 'libraries/mysql_charsets.inc.php';
  11 require_once 'libraries/structure.lib.php';
  12 require_once 'libraries/index.lib.php';
  13 require_once 'libraries/tbl_info.inc.php';
  14
  15 if (! defined('PHPMYADMIN')) {
  16     exit;
  17 }
  18
  19 /* TABLE INFORMATION */
  20 // table header
  21
  22
  23 $HideStructureActions = '';
  24 if ($GLOBALS['cfg']['HideStructureActions'] === true) {
  25     $HideStructureActions .= ' HideStructureActions';
  26 }
  27
  28 $html_form = '<form method="post" action="tbl_structure.php" name="fieldsForm" '
  29 . 'id="fieldsForm" class="ajax' . $HideStructureActions . '">';
  30
  31 $response->addHTML($html_form);
  32 $response->addHTML(PMA_URL_getHiddenInputs($db, $table));
  33
  34 $tabletype = '<input type="hidden" name="table_type" value=';
  35 if ($db_is_system_schema) {
  36     $tabletype .= '"information_schema" />';
  37 } else if ($tbl_is_view) {
  38     $tabletype .= '"view" />';
  39 } else {
  40     $tabletype .= '"table" />';
  41 }
  42 $response->addHTML($tabletype);
  43
  44 $tablestructure = '<table id="tablestructure" class="data topmargin">';
  45 $response->addHTML($tablestructure);
  46
  47
  48 $response->addHTML(
  49     PMA_getHtmlForTableStructureHeader(
  50         $db_is_system_schema,
  51         $tbl_is_view
  52     )
  53 );
  54
  55 $response->addHTML('<tbody>');
  56
  57 // table body
  58
  59 // prepare comments
  60 $comments_map = array();
  61 $mime_map = array();
  62
  63 if ($GLOBALS['cfg']['ShowPropertyComments']) {
  64     include_once 'libraries/transformations.lib.php';
  65     $comments_map = PMA_getComments($db, $table);
  66     if ($cfgRelation['mimework'] && $cfg['BrowseMIME']) {
  67         $mime_map = PMA_getMIME($db, $table, true);
  68     }
  69 }
  70 require_once 'libraries/central_columns.lib.php';
  71 $central_list = PMA_getCentralColumnsFromTable($db, $table);
  72 $rownum    = 0;
  73 $columns_list = array();
  74 $save_row  = array();
  75 $odd_row   = true;
  76 foreach ($fields as $row) {
  77     $save_row[] = $row;
  78     $rownum++;
  79     $columns_list[]   = $row['Field'];
  80
  81     $type             = $row['Type'];
  82     $extracted_columnspec = PMA_Util::extractColumnSpec($row['Type']);
  83
  84     if ('set' == $extracted_columnspec['type']
  85         || 'enum' == $extracted_columnspec['type']
  86     ) {
  87         $type_nowrap  = '';
  88     } else {
  89         $type_nowrap  = ' class="nowrap"';
  90     }
  91     $type         = $extracted_columnspec['print_type'];
  92     if (empty($type)) {
  93         $type     = ' ';
  94     }
  95
  96     $field_charset = '';
  97     if ($extracted_columnspec['can_contain_collation']
  98         && ! empty($row['Collation'])
  99     ) {
 100         $field_charset = $row['Collation'];
 101     }
 102
 103     // Display basic mimetype [MIME]
 104     if ($cfgRelation['commwork']
 105         && $cfgRelation['mimework']
 106         && $cfg['BrowseMIME']
 107         && isset($mime_map[$row['Field']]['mimetype'])
 108     ) {
 109         $type_mime = '<br />MIME: '
 110         . str_replace('_', '/', $mime_map[$row['Field']]['mimetype']);
 111     } else {
 112         $type_mime = '';
 113     }
 114
 115     $attribute = $extracted_columnspec['attribute'];
 116
 117     // prepare a common variable to reuse below; however,
 118     // in case of a VIEW, $analyzed_sql[0]['create_table_fields'] is empty
 119     if (isset($analyzed_sql[0]['create_table_fields'][$row['Field']])) {
 120         $tempField = $analyzed_sql[0]['create_table_fields'][$row['Field']];
 121     } else {
 122         $tempField = array();
 123     }
 124
 125     // MySQL 4.1.2+ TIMESTAMP options
 126     // (if on_update_current_timestamp is set, then it's TRUE)
 127     if (isset($tempField['on_update_current_timestamp'])) {
 128         $attribute = 'on update CURRENT_TIMESTAMP';
 129     }
 130
 131     // here, we have a TIMESTAMP that SHOW FULL COLUMNS reports as having the
 132     // NULL attribute, but SHOW CREATE TABLE says the contrary. Believe
 133     // the latter.
 134     if (! empty($tempField['type'])
 135         && $tempField['type'] == 'TIMESTAMP'
 136         && $tempField['timestamp_not_null']
 137     ) {
 138         $row['Null'] = '';
 139     }
 140
 141
 142     if (! isset($row['Default'])) {
 143         if ($row['Null'] == 'YES') {
 144             $row['Default'] = '<i>NULL</i>';
 145         }
 146     } else {
 147         $row['Default'] = htmlspecialchars($row['Default']);
 148     }
 149
 150     $field_encoded = urlencode($row['Field']);
 151     $field_name    = htmlspecialchars($row['Field']);
 152     $displayed_field_name = $field_name;
 153
 154     // underline commented fields and display a hover-title (CSS only)
 155
 156     if (isset($comments_map[$row['Field']])) {
 157         $displayed_field_name = '<span class="commented_column" title="'
 158         . htmlspecialchars($comments_map[$row['Field']]) . '">'
 159         . $field_name . '</span>';
 160     }
 161
 162     if ($primary && $primary->hasColumn($field_name)) {
 163         $displayed_field_name .= PMA_Util::getImage(
 164             'b_primary.png', __('Primary')
 165         );
 166     }
 167     $response->addHTML(
 168         '<tr class="' . ($odd_row ? 'odd': 'even') . '">'
 169     );
 170     $odd_row = !$odd_row;
 171     $isInCentralColumns = in_array($row['Field'], $central_list)?true:false;
 172     $response->addHTML(
 173         PMA_getHtmlTableStructureRow(
 174             $row, $rownum, $displayed_field_name,
 175             $type_nowrap, $extracted_columnspec, $type_mime,
 176             $field_charset, $attribute, $tbl_is_view,
 177             $db_is_system_schema, $url_query, $field_encoded, $titles, $table
 178         )
 179     );
 180
 181     if (! $tbl_is_view && ! $db_is_system_schema) {
 182         $response->addHTML(
 183             PMA_getHtmlForActionsInTableStructure(
 184                 $type, $tbl_storage_engine, $primary,
 185                 $field_name, $url_query, $titles, $row, $rownum,
 186                 $columns_with_unique_index,
 187                 $isInCentralColumns
 188             )
 189         );
 190     } // end if (! $tbl_is_view && ! $db_is_system_schema)
 191
 192     $response->addHTML('</tr>');
 193
 194     unset($field_charset);
 195 } // end foreach
 196
 197 $response->addHTML('</tbody></table>');
 198
 199 $response->addHTML(
 200     PMA_getHtmlForCheckAllTableColumn(
 201         $pmaThemeImage, $text_dir, $tbl_is_view,
 202         $db_is_system_schema, $tbl_storage_engine
 203     )
 204 );
 205
 206 $response->addHTML(
 207     '</form><hr />'
 208 );
 209 $response->addHTML(
 210     PMA_getHtmlDivForMoveColumnsDialog()
 211 );
 212
 213 /**
 214  * Work on the table
 215  */
 216
 217 $response->addHTML('<div id="structure-action-links">');
 218
 219 if ($tbl_is_view) {
 220     $response->addHTML(PMA_getHtmlForEditView($url_params));
 221 }
 222 $response->addHTML(
 223     PMA_getHtmlForOptionalActionLinks(
 224         $url_query, $tbl_is_view, $db_is_system_schema
 225     )
 226 );
 227
 228 $response->addHTML('</div>');
 229
 230 if (! $tbl_is_view && ! $db_is_system_schema) {
 231     $response->addHTML('<br />');
 232     $response->addHTML(PMA_getHtmlForAddColumn($columns_list));
 233 }
 234
 235 /**
 236  * Displays indexes
 237  */
 238
 239 if (! $tbl_is_view
 240     && ! $db_is_system_schema
 241     && 'ARCHIVE' !=  $tbl_storage_engine
 242 ) {
 243     //return the list of index
 244     $response->addJSON(
 245         'indexes_list',
 246         PMA_Index::getView($GLOBALS['table'], $GLOBALS['db'])
 247     );
 248     $response->addHTML(PMA_getHtmlForDisplayIndexes());
 249 }
 250
 251 /**
 252  * Displays Space usage and row statistics
 253  */
 254 // BEGIN - Calc Table Space
 255 // Get valid statistics whatever is the table type
 256 if ($cfg['ShowStats']) {
 257     //get table stats in HTML format
 258     $tablestats = PMA_getHtmlForDisplayTableStats(
 259         $showtable, $table_info_num_rows, $tbl_is_view,
 260         $db_is_system_schema, $tbl_storage_engine,
 261         $url_query, $tbl_collation
 262     );
 263     //returning the response in JSON format to be used by Ajax
 264     $response->addJSON('tableStat', $tablestats);
 265     $response->addHTML($tablestats);
 266 }
 267 // END - Calc Table Space
 268
 269 $response->addHTML(
 270     '<div class="clearfloat"></div>'
 271 );
 272 ?>