34 lines
1.4 KiB
PHP
34 lines
1.4 KiB
PHP
<?php
|
|
|
|
/** Expanded table structure output
|
|
* @link https://www.adminer.org/plugins/#use
|
|
* @author Matthew Gamble, https://www.matthewgamble.net/
|
|
* @license https://www.apache.org/licenses/LICENSE-2.0 Apache License, Version 2.0
|
|
* @license https://www.gnu.org/licenses/gpl-2.0.html GNU General Public License, version 2 (one or other)
|
|
*/
|
|
class AdminerTableStructure {
|
|
|
|
/** Print table structure in tabular format
|
|
* @param array data about individual fields
|
|
* @return bool
|
|
*/
|
|
function tableStructurePrint($fields) {
|
|
echo "<div class='scrollable'>\n";
|
|
echo "<table cellspacing='0' class='nowrap'>\n";
|
|
echo "<thead><tr><th>" . lang('Column') . "<th>" . lang('Type') . "<th>" . lang('Nullable') . "<th>" . lang('Default') . (support("comment") ? "<th>" . lang('Comment') : "") . "</thead>\n";
|
|
foreach ($fields as $field) {
|
|
echo "<tr" . odd() . "><th>" . h($field["field"]) . ($field["primary"] ? " (PRIMARY)" : "");
|
|
echo "<td><span>" . h($field["full_type"]) . "</span>";
|
|
echo ($field["auto_increment"] ? " <i>" . lang('Auto Increment') . "</i>" : "");
|
|
echo ($field["collation"] ? " <i>" . h($field["collation"]) . "</i>" : "");
|
|
echo "<td>" . ($field["null"] ? lang('Yes') : lang('No'));
|
|
echo "<td>" . h($field["default"]);
|
|
echo (support("comment") ? "<td>" . h($field["comment"]) : "");
|
|
echo "\n";
|
|
}
|
|
echo "</table>\n";
|
|
echo "</div>\n";
|
|
return true;
|
|
}
|
|
}
|