Rev Author Line No. Line
250 kaklik 1 <?php
2 /* $Id: db_details_structure.php,v 2.73.2.6 2006/02/17 13:57:36 lem9 Exp $ */
3 // vim: expandtab sw=4 ts=4 sts=4:
4  
5 require_once './libraries/common.lib.php';
6  
7 /**
8 * Prepares the tables list if the user where not redirected to this script
9 * because there is no table in the database ($is_info is true)
10 */
11 if (empty($is_info)) {
12 // Drops/deletes/etc. multiple tables if required
13 if ((!empty($submit_mult) && isset($selected_tbl))
14 || isset($mult_btn)) {
15 $action = 'db_details_structure.php';
16 $err_url = 'db_details_structure.php?'. PMA_generate_common_url($db);
17 require './libraries/mult_submits.inc.php';
18 $message = $strSuccess;
19 }
20 require './libraries/db_details_common.inc.php';
21 $url_query .= '&amp;goto=db_details_structure.php';
22  
23 // Gets the database structure
24 $sub_part = '_structure';
25 require './libraries/db_details_db_info.inc.php';
26 }
27  
28 // 1. No tables
29 if ($num_tables == 0) {
30 echo '<p>' . $strNoTablesFound . '</p>' . "\n";
31  
32 if (empty($db_is_information_schema)) {
33 require './libraries/display_create_table.lib.php';
34 } // end if (Create Table dialog)
35  
36 /**
37 * Displays the footer
38 */
39 require_once './libraries/footer.inc.php';
40 exit;
41 }
42  
43 // else
44 // 2. Shows table informations - staybyte - 11 June 2001
45  
46 require_once './libraries/bookmark.lib.php';
47  
48 if (PMA_MYSQL_INT_VERSION >= 40101) {
49 require_once './libraries/mysql_charsets.lib.php';
50 $db_collation = PMA_getDbCollation($db);
51 }
52  
53 // Display function
54 /**
55 * void PMA_TableHeader([bool $db_is_information_schema = false])
56 * display table header (<table><thead>...</thead><tbody>)
57 *
58 * @uses PMA_showHint()
59 * @uses PMA_MYSQL_INT_VERSION
60 * @uses $GLOBALS['cfg']['PropertiesNumColumns']
61 * @uses $GLOBALS['cfg']['ShowStats']
62 * @uses $GLOBALS['strTable']
63 * @uses $GLOBALS['strAction']
64 * @uses $GLOBALS['strRecords']
65 * @uses $GLOBALS['strApproximateCount']
66 * @uses $GLOBALS['strType']
67 * @uses $GLOBALS['strCollation']
68 * @uses $GLOBALS['strSize']
69 * @uses $GLOBALS['strOverhead']
70 * @uses $GLOBALS['structure_tbl_col_cnt']
71 * @param boolean $db_is_information_schema
72 */
73 function PMA_TableHeader($db_is_information_schema = false)
74 {
75 $cnt = 0; // Let's count the columns...
76  
77 if ($db_is_information_schema) {
78 $action_colspan = 3;
79 } else {
80 $action_colspan = 6;
81 }
82  
83 echo '<table class="data" style="float: left;">' . "\n"
84 .'<thead>' . "\n"
85 .'<tr><td></td>' . "\n"
86 .' <th>' . $GLOBALS['strTable'] . '</th>' . "\n"
87 .' <th colspan="' . $action_colspan . '">' . "\n"
88 .' ' . $GLOBALS['strAction'] . "\n"
89 .' </th>'
90 .' <th>' . $GLOBALS['strRecords']
91 .PMA_showHint($GLOBALS['strApproximateCount']) . "\n"
92 .' </th>' . "\n";
93 if (!($GLOBALS['cfg']['PropertiesNumColumns'] > 1)) {
94 echo ' <th>' . $GLOBALS['strType'] . '</th>' . "\n";
95 $cnt++;
96 if (PMA_MYSQL_INT_VERSION >= 40100) {
97 echo ' <th>' . $GLOBALS['strCollation'] . '</th>' . "\n";
98 $cnt++;
99 }
100 }
101 if ($GLOBALS['cfg']['ShowStats']) {
102 echo ' <th>' . $GLOBALS['strSize'] . '</th>' . "\n"
103 . ' <th>' . $GLOBALS['strOverhead'] . '</th>' . "\n";
104 $cnt += 2;
105 }
106 echo '</tr>' . "\n";
107 echo '</thead>' . "\n";
108 echo '<tbody>' . "\n";
109 $GLOBALS['structure_tbl_col_cnt'] = $cnt + $action_colspan + 3;
110 }
111  
112 $titles = array();
113 if (true == $cfg['PropertiesIconic']) {
114 $titles['Browse'] = '<img class="icon" width="16" height="16" src="' .$pmaThemeImage . 'b_browse.png" alt="' . $strBrowse . '" title="' . $strBrowse . '" />';
115 $titles['NoBrowse'] = '<img class="icon" width="16" height="16" src="' .$pmaThemeImage . 'bd_browse.png" alt="' . $strBrowse . '" title="' . $strBrowse . '" />';
116 $titles['Search'] = '<img class="icon" width="16" height="16" src="' .$pmaThemeImage . 'b_select.png" alt="' . $strSearch . '" title="' . $strSearch . '" />';
117 $titles['NoSearch'] = '<img class="icon" width="16" height="16" src="' .$pmaThemeImage . 'bd_select.png" alt="' . $strSearch . '" title="' . $strSearch . '" />';
118 $titles['Insert'] = '<img class="icon" width="16" height="16" src="' .$pmaThemeImage . 'b_insrow.png" alt="' . $strInsert . '" title="' . $strInsert . '" />';
119 $titles['NoInsert'] = '<img class="icon" width="16" height="16" src="' .$pmaThemeImage . 'bd_insrow.png" alt="' . $strInsert . '" title="' . $strInsert . '" />';
120 $titles['Structure'] = '<img class="icon" width="16" height="16" src="' .$pmaThemeImage . 'b_props.png" alt="' . $strStructure . '" title="' . $strStructure . '" />';
121 $titles['Drop'] = '<img class="icon" width="16" height="16" src="' .$pmaThemeImage . 'b_drop.png" alt="' . $strDrop . '" title="' . $strDrop . '" />';
122 $titles['NoDrop'] = '<img class="icon" width="16" height="16" src="' .$pmaThemeImage . 'bd_drop.png" alt="' . $strDrop . '" title="' . $strDrop . '" />';
123 $titles['Empty'] = '<img class="icon" width="16" height="16" src="' .$pmaThemeImage . 'b_empty.png" alt="' . $strEmpty . '" title="' . $strEmpty . '" />';
124 $titles['NoEmpty'] = '<img class="icon" width="16" height="16" src="' .$pmaThemeImage . 'bd_empty.png" alt="' . $strEmpty . '" title="' . $strEmpty . '" />';
125  
126 if ('both' === $cfg['PropertiesIconic']) {
127 $titles['Browse'] .= $strBrowse;
128 $titles['Search'] .= $strSearch;
129 $titles['NoBrowse'] .= $strBrowse;
130 $titles['NoSearch'] .= $strSearch;
131 $titles['Insert'] .= $strInsert;
132 $titles['NoInsert'] .= $strInsert;
133 $titles['Structure'] .= $strStructure;
134 $titles['Drop'] .= $strDrop;
135 $titles['NoDrop'] .= $strDrop;
136 $titles['Empty'] .= $strEmpty;
137 $titles['NoEmpty'] .= $strEmpty;
138 }
139 } else {
140 $titles['Browse'] = $strBrowse;
141 $titles['Search'] = $strSearch;
142 $titles['NoBrowse'] = $strBrowse;
143 $titles['NoSearch'] = $strSearch;
144 $titles['Insert'] = $strInsert;
145 $titles['NoInsert'] = $strInsert;
146 $titles['Structure'] = $strStructure;
147 $titles['Drop'] = $strDrop;
148 $titles['NoDrop'] = $strDrop;
149 $titles['Empty'] = $strEmpty;
150 $titles['NoEmpty'] = $strEmpty;
151 }
152  
153 /**
154 * Displays the tables list
155 */
156 ?>
157 <form method="post" action="db_details_structure.php" name="tablesForm" id="tablesForm">
158 <?php
159 echo PMA_generate_common_hidden_inputs($db);
160  
161 PMA_TableHeader($db_is_information_schema);
162  
163 $i = $sum_entries = 0;
164 $sum_size = (double) 0;
165 $overhead_size = (double) 0;
166 $overhead_check = '';
167 $checked = !empty($checkall) ? ' checked="checked"' : '';
168 $num_columns = $cfg['PropertiesNumColumns'] > 1 ? ceil($num_tables / $cfg['PropertiesNumColumns']) + 1 : 0;
169 $row_count = 0;
170  
171  
172 $hidden_fields = array();
173 $odd_row = true;
174 $at_least_one_view_exceeds_max_count = false;
175  
176 foreach ($tables as $keyname => $each_table) {
177 if ($each_table['TABLE_ROWS'] === null || $each_table['TABLE_ROWS'] < $GLOBALS['cfg']['MaxExactCount']) {
178 $each_table['TABLE_ROWS'] = PMA_countRecords($db,
179 $each_table['TABLE_NAME'], $return = true, $force_exact = true);
180 }
181  
182 $table_encoded = urlencode($each_table['TABLE_NAME']);
183 // MySQL < 5.0.13 returns "view", >= 5.0.13 returns "VIEW"
184 $table_is_view = ($each_table['TABLE_TYPE'] === 'VIEW'
185 || $each_table['TABLE_TYPE'] === 'SYSTEM VIEW');
186  
187 $alias = (!empty($tooltip_aliasname) && isset($tooltip_aliasname[$each_table['TABLE_NAME']]))
188 ? htmlspecialchars($tooltip_aliasname[$each_table['TABLE_NAME']])
189 : htmlspecialchars($each_table['TABLE_NAME']);
190 $truename = (!empty($tooltip_truename) && isset($tooltip_truename[$each_table['TABLE_NAME']]))
191 ? htmlspecialchars($tooltip_truename[$each_table['TABLE_NAME']])
192 : htmlspecialchars($each_table['TABLE_NAME']);
193  
194 // Sets parameters for links
195 $tbl_url_query = $url_query . '&amp;table=' . $table_encoded;
196 $i++;
197  
198 $row_count++;
199 if ($table_is_view) {
200 $hidden_fields[] = '<input type="hidden" name="views[]" value="' . $table_encoded . '" />';
201 }
202  
203 if ($each_table['TABLE_ROWS'] > 0) {
204 $browse_table = '<a href="sql.php?' . $tbl_url_query . '&amp;pos=0">' . $titles['Browse'] . '</a>';
205 $search_table = '<a href="tbl_select.php?' . $tbl_url_query . '">' . $titles['Search'] . '</a>';
206 } else {
207 $browse_table = $titles['NoBrowse'];
208 $search_table = $titles['NoSearch'];
209 }
210  
211 if (! $db_is_information_schema) {
212 if (! empty($each_table['TABLE_ROWS'])) {
213 $empty_table = '<a href="sql.php?' . $tbl_url_query
214 . '&amp;sql_query=';
215 if (PMA_MYSQL_INT_VERSION >= 40000) {
216 $empty_table .= urlencode('TRUNCATE ' . PMA_backquote($each_table['TABLE_NAME']))
217 . '&amp;zero_rows='
218 . urlencode(sprintf($strTableHasBeenEmptied, htmlspecialchars($each_table['TABLE_NAME'])))
219 . '" onclick="return confirmLink(this, \'TRUNCATE ';
220 } else {
221 $empty_table .= urlencode('DELETE FROM ' . PMA_backquote($each_table['TABLE_NAME']))
222 . '&amp;zero_rows='
223 . urlencode(sprintf($strTableHasBeenEmptied, htmlspecialchars($each_table['TABLE_NAME'])))
224 . '" onclick="return confirmLink(this, \'DELETE FROM ';
225 }
226 $empty_table .= PMA_jsFormat($each_table['TABLE_NAME']) . '\')">' . $titles['Empty'] . '</a>';
227 } else {
228 $empty_table = $titles['NoEmpty'];
229 }
230 $drop_query = 'DROP '
231 . ($table_is_view ? 'VIEW' : 'TABLE')
232 . ' ' . PMA_backquote($each_table['TABLE_NAME']);
233 $drop_message = sprintf(
234 $table_is_view ? $strViewHasBeenDropped : $strTableHasBeenDropped,
235 htmlspecialchars($each_table['TABLE_NAME']));
236 }
237  
238 // loic1: Patch from Joshua Nye <josh at boxcarmedia.com> to get valid
239 // statistics whatever is the table type
240  
241 if (isset($each_table['TABLE_ROWS'])) {
242 // MyISAM, ISAM or Heap table: Row count, data size and index size
243 // is accurate.
244 if (preg_match('@^(MyISAM|ISAM|HEAP|MEMORY)$@', $each_table['ENGINE'])) {
245 if ($cfg['ShowStats']) {
246 $tblsize = doubleval($each_table['Data_length']) + doubleval($each_table['Index_length']);
247 $sum_size += $tblsize;
248 list($formated_size, $unit) = PMA_formatByteDown($tblsize, 3, ($tblsize > 0) ? 1 : 0);
249 if (isset($each_table['Data_free']) && $each_table['Data_free'] > 0) {
250 list($formated_overhead, $overhead_unit) = PMA_formatByteDown($each_table['Data_free']);
251 $overhead_size += $each_table['Data_free'];
252 }
253 }
254 $sum_entries += $each_table['TABLE_ROWS'];
255 } elseif ($each_table['ENGINE'] == 'InnoDB') {
256 // InnoDB table: Row count is not accurate but data and index
257 // sizes are.
258 if ($cfg['ShowStats']) {
259 $tblsize = $each_table['Data_length'] + $each_table['Index_length'];
260 $sum_size += $tblsize;
261 list($formated_size, $unit) = PMA_formatByteDown($tblsize, 3, ($tblsize > 0) ? 1 : 0);
262 }
263 //$display_rows = ' - ';
264 $sum_entries += $each_table['TABLE_ROWS'];
265 } elseif (preg_match('@^(MRG_MyISAM|BerkeleyDB)$@', $each_table['ENGINE'])) {
266 // Merge or BerkleyDB table: Only row count is accurate.
267 if ($cfg['ShowStats']) {
268 $formated_size = ' - ';
269 $unit = '';
270 }
271 $sum_entries += $each_table['TABLE_ROWS'];
272 } else {
273 // Unknown table type.
274 if ($cfg['ShowStats']) {
275 $formated_size = 'unknown';
276 $unit = '';
277 }
278 }
279  
280 if (PMA_MYSQL_INT_VERSION >= 40100) {
281 if (isset($each_table['Collation'])) {
282 $collation = '<dfn title="'
283 . PMA_getCollationDescr($each_table['Collation']) . '">'
284 . $each_table['Collation'] . '</dfn>';
285 } else {
286 $collation = '---';
287 }
288 }
289  
290 if ($cfg['ShowStats']) {
291 if (isset($formated_overhead)) {
292 $overhead = '<a href="tbl_properties_structure.php?'
293 . $tbl_url_query . '#showusage">' . $formated_overhead
294 . ' ' . $overhead_unit . '</a>' . "\n";
295 unset($formated_overhead);
296 $overhead_check .=
297 "document.getElementById('checkbox_tbl_$i').checked = true;";
298 } else {
299 $overhead = '-';
300 }
301 } // end if
302 } // end if (isset($each_table['TABLE_ROWS'])
303  
304 if ($num_columns > 0 && $num_tables > $num_columns
305 && (($row_count % $num_columns) == 0)) {
306 $row_count = 1;
307 $odd_row = true;
308 ?>
309 </tr>
310 </tbody>
311 </table>
312 <?php
313 PMA_TableHeader();
314 }
315 ?>
316 <tr class="<?php echo $odd_row ? 'odd' : 'even'; $odd_row = ! $odd_row; ?>">
317 <td align="center">
318 <input type="checkbox" name="selected_tbl[]"
319 value="<?php echo $table_encoded; ?>"
320 id="checkbox_tbl_<?php echo $i; ?>"<?php echo $checked; ?> /></td>
321 <th><label for="checkbox_tbl_<?php echo $i; ?>"
322 title="<?php echo $alias; ?>"><?php echo $truename; ?></label>
323 </th>
324 <td align="center"><?php echo $browse_table; ?></td>
325 <td align="center">
326 <a href="tbl_properties_structure.php?<?php echo $tbl_url_query; ?>">
327 <?php echo $titles['Structure']; ?></a></td>
328 <td align="center"><?php echo $search_table; ?></td>
329 <?php if (! $db_is_information_schema) { ?>
330 <td align="center">
331 <a href="tbl_change.php?<?php echo $tbl_url_query; ?>">
332 <?php echo $titles['Insert']; ?></a></td>
333 <td align="center"><?php echo $empty_table; ?></td>
334 <td align="center">
335 <a href="sql.php?<?php echo $tbl_url_query;
336 ?>&amp;reload=1&amp;purge=1&amp;sql_query=<?php
337 echo urlencode($drop_query); ?>&amp;zero_rows=<?php
338 echo urlencode($drop_message); ?>"
339 onclick="return confirmLink(this, '<?php echo PMA_jsFormat($drop_query, false); ?>')">
340 <?php echo $titles['Drop']; ?></a></td>
341 <?php } // end if (! $db_is_information_schema)
342  
343 // there is a null value in the ENGINE
344 // - when the table needs to be repaired, or
345 // - when it's a view
346 // so ensure that we'll display "in use" below for a table
347 // that needs to be repaired
348  
349 if (isset($each_table['TABLE_ROWS']) && ($each_table['ENGINE'] != null || $table_is_view)) {
350 if ($table_is_view && $each_table['TABLE_ROWS'] >= $cfg['MaxExactCount']) {
351 $at_least_one_view_exceeds_max_count = true;
352 $show_superscript = '<sup>1</sup>';
353 } else {
354 $show_superscript = '';
355 }
356 ?>
357 <td class="value"><?php echo PMA_formatNumber($each_table['TABLE_ROWS'], 0) . $show_superscript; ?></td>
358 <?php if (!($cfg['PropertiesNumColumns'] > 1)) { ?>
359 <td nowrap="nowrap"><?php echo ($table_is_view ? $strView : $each_table['ENGINE']); ?></td>
360 <?php if (isset($collation)) { ?>
361 <td nowrap="nowrap"><?php echo $collation ?></td>
362 <?php } ?>
363 <?php } ?>
364  
365 <?php if ($cfg['ShowStats']) { ?>
366 <td class="value"><a
367 href="tbl_properties_structure.php?<?php echo $tbl_url_query; ?>#showusage"
368 ><?php echo $formated_size . ' ' . $unit; ?></a></td>
369 <td class="value"><?php echo $overhead; ?></td>
370 <?php } // end if ?>
371 <?php } elseif ($table_is_view) { ?>
372 <td class="value">-</td>
373 <td><?php echo $strView; ?></td>
374 <td>---</td>
375 <?php if ($cfg['ShowStats']) { ?>
376 <td class="value">-</td>
377 <td class="value">-</td>
378 <?php } ?>
379 <?php } else { ?>
380 <td colspan="<?php echo ($structure_tbl_col_cnt - ($db_is_information_schema ? 5 : 8)) ?>"
381 align="center">
382 <?php echo $strInUse; ?></td>
383 <?php } // end if (isset($each_table['TABLE_ROWS'])) else ?>
384 </tr>
385 <?php
386 } // end foreach
387  
388 // Show Summary
389 if ($cfg['ShowStats']) {
390 list($sum_formated, $unit) = PMA_formatByteDown($sum_size, 3, 1);
391 list($overhead_formated, $overhead_unit) =
392 PMA_formatByteDown($overhead_size, 3, 1);
393 }
394 ?>
395 </tbody>
396 <tbody>
397 <tr><td></td>
398 <th align="center" nowrap="nowrap">
399 <?php echo sprintf($strTables, PMA_formatNumber($num_tables, 0)); ?>
400 </th>
401 <th colspan="<?php echo ($db_is_information_schema ? 3 : 6) ?>" align="center">
402 <?php echo $strSum; ?></th>
403 <th class="value"><?php echo PMA_formatNumber($sum_entries, 0); ?></th>
404 <?php
405 if (!($cfg['PropertiesNumColumns'] > 1)) {
406 echo ' <th align="center">'
407 .PMA_DBI_get_default_engine() . '</th>' . "\n";
408 if (! empty($db_collation)) {
409 echo ' <th align="center">' . "\n"
410 . ' <dfn title="'
411 . PMA_getCollationDescr($db_collation) . '">' . $db_collation
412 . '</dfn></th>';
413 }
414 }
415  
416 if ($cfg['ShowStats']) {
417 ?>
418 <th class="value"><?php echo $sum_formated . ' ' . $unit; ?></th>
419 <th class="value"><?php echo $overhead_formated . ' ' . $overhead_unit; ?></th>
420 <?php
421 }
422 ?>
423 </tr>
424 </tbody>
425 </table>
426  
427 <div class="clearfloat">
428 <?php
429 // Check all tables url
430 $checkall_url = 'db_details_structure.php?' . PMA_generate_common_url($db);
431 ?>
432 <img class="selectallarrow" src="<?php echo $pmaThemeImage .'arrow_'.$text_dir.'.png'; ?>"
433 width="38" height="22" alt="<?php echo $strWithChecked; ?>" />
434 <a href="<?php echo $checkall_url; ?>&amp;checkall=1"
435 onclick="if (markAllRows('tablesForm')) return false;">
436 <?php echo $strCheckAll; ?></a>
437 /
438 <a href="<?php echo $checkall_url; ?>"
439 onclick="if (unMarkAllRows('tablesForm')) return false;">
440 <?php echo $strUncheckAll; ?></a>
441 <?php if ($overhead_check != '') { ?>
442 /
443 <a href="#" onclick="unMarkAllRows('tablesForm');
444 <?php echo $overhead_check; ?> return false;">
445 <?php echo $strCheckOverhead; ?></a>
446 <?php } ?>
447  
448 <select name="submit_mult" onchange="this.form.submit();" style="margin: 0 3em 0 3em;">
449 <?php
450 echo ' <option value="' . $strWithChecked . '" selected="selected">'
451 . $strWithChecked . '</option>' . "\n";
452 echo ' <option value="' . $strEmpty . '" >'
453 . $strEmpty . '</option>' . "\n";
454 echo ' <option value="' . $strDrop . '" >'
455 . $strDrop . '</option>' . "\n";
456 echo ' <option value="' . $strPrintView . '" >'
457 . $strPrintView . '</option>' . "\n";
458 echo ' <option value="' . $strCheckTable . '" >'
459 . $strCheckTable . '</option>' . "\n";
460 echo ' <option value="' . $strOptimizeTable . '" >'
461 . $strOptimizeTable . '</option>' . "\n";
462 echo ' <option value="' . $strRepairTable . '" >'
463 . $strRepairTable . '</option>' . "\n";
464 echo ' <option value="' . $strAnalyzeTable . '" >'
465 . $strAnalyzeTable . '</option>' . "\n";
466 ?>
467 </select>
468 <script type="text/javascript" language="javascript">
469 <!--
470 // Fake js to allow the use of the <noscript> tag
471 //-->
472 </script>
473 <noscript>
474 <input type="submit" value="<?php echo $strGo; ?>" />
475 </noscript>
476 <?php echo implode("\n", $hidden_fields) . "\n"; ?>
477 </div>
478 </form>
479 <?php
480 // Notice about row count for views
481  
482 if ($at_least_one_view_exceeds_max_count && !$db_is_information_schema) {
483 echo '<div class="notice">' . "\n";
484 echo '<sup>1</sup>' . PMA_sanitize(sprintf($strViewMaxExactCount, PMA_formatNumber($cfg['MaxExactCount'], 0), '[a@./Documentation.html#cfg_MaxExactCount@_blank]', '[/a]')) . "\n";
485 echo '</div>' . "\n";
486 }
487 ?>
488 <hr />
489  
490 <?php
491 /**
492 * Work on the database
493 * redesigned 2004-05-08 by mkkeck
494 */
495 /* DATABASE WORK */
496 /* Printable view of a table */
497 echo '<p>';
498 echo '<a href="db_printview.php?' . $url_query . '">';
499 if ($cfg['PropertiesIconic']) {
500 echo '<img class="icon" src="' . $pmaThemeImage
501 .'b_print.png" width="16" height="16" alt="" />';
502 }
503 echo $strPrintView . '</a> ';
504  
505 echo '<a href="./db_datadict.php?' . $url_query . '">';
506 if ($cfg['PropertiesIconic']) {
507 echo '<img class="icon" src="' . $pmaThemeImage
508 .'b_tblanalyse.png" width="16" height="16" alt="" />';
509 }
510 echo $strDataDict . '</a>';
511 echo '</p>';
512  
513 if (empty($db_is_information_schema)) {
514 require './libraries/display_create_table.lib.php';
515 } // end if (Create Table dialog)
516  
517 /**
518 * Displays the footer
519 */
520 require_once './libraries/footer.inc.php';
521 ?>