<?php
$cnt = 0; // Let's count the columns...

if ($db_is_system_schema) {
    $action_colspan = 3;
} else {
    $action_colspan = 6;
}
if ($GLOBALS['cfg']['NumFavoriteTables'] > 0) {
    $action_colspan++;
}
?>
<form method="post" action="db_structure.php" name="tablesForm" id="tablesForm">
<?= PMA\libraries\URL::getHiddenInputs($db); ?>
<table id="structureTable" class="data">
    <thead>
        <tr>
            <th class="print_ignore"></th>
            <th><?= PMA\libraries\Template::get('database/structure/sortable_header')->render(
                   array(
                       'title' => __('Table'),
                       'sort' => 'table',
                       'initial_sort_order' => 'ASC'
                   )
                ); ?></th>
            <?php if ($replication): ?>
                <th><?= __('Replication'); ?></th>
            <?php endif; ?>
            <th colspan="<?= $action_colspan; ?>" class="print_ignore">
                <?= __('Action'); ?>
            </th>
            <!-- larger values are more interesting so default sort order is DESC-->
            <th>
                <?= PMA\libraries\Template::get('database/structure/sortable_header')->render(
                    array(
                        'title' => __('Rows'),
                        'sort' => 'records',
                        'initial_sort_order' => 'DESC'
                    )
                ); ?>
                <?= PMA\libraries\Util::showHint(PMA\libraries\Sanitize::sanitize(
                    __('May be approximate. Click on the number to get the exact'
                        . ' count. See [doc@faq3-11]FAQ 3.11[/doc].'))); ?>
            </th>
            <?php if (!($GLOBALS['cfg']['PropertiesNumColumns'] > 1)): ?>
                <th><?= PMA\libraries\Template::get('database/structure/sortable_header')->render(
                        array(
                            'title' => __('Type'),
                            'sort' => 'type',
                            'initial_sort_order' => 'ASC'
                        )
                    ); $cnt++; ?></th>
                <th><?= PMA\libraries\Template::get('database/structure/sortable_header')->render(
                        array(
                            'title' => __('Collation'),
                            'sort' => 'collation',
                            'initial_sort_order' => 'ASC'
                        )
                    ); $cnt++; ?></th>
            <?php endif; ?>

            <?php if ($GLOBALS['is_show_stats']): ?>
                <!-- larger values are more interesting so default sort order is DESC -->
                <th><?= PMA\libraries\Template::get('database/structure/sortable_header')->render(
                        array(
                            'title' => __('Size'),
                            'sort' => 'size',
                            'initial_sort_order' => 'DESC'
                        )
                    ); $cnt++; ?></th>
                <!-- larger values are more interesting so default sort order is DESC -->
                <th><?= PMA\libraries\Template::get('database/structure/sortable_header')->render(
                        array(
                            'title' => __('Overhead'),
                            'sort' => 'overhead',
                            'initial_sort_order' => 'DESC'
                        )
                    ); $cnt++; ?></th>
            <?php endif; ?>

            <?php if ($GLOBALS['cfg']['ShowDbStructureCharset']): ?>
                <th><?= PMA\libraries\Template::get('database/structure/sortable_header')->render(
                        array(
                            'title' => __('Charset'),
                            'sort' => 'charset',
                            'initial_sort_order' => 'ASC'
                        )
                    ); $cnt++; ?></th>
            <?php endif; ?>

            <?php if ($GLOBALS['cfg']['ShowDbStructureComment']): ?>
                <th><?= PMA\libraries\Template::get('database/structure/sortable_header')->render(
                        array(
                            'title' => __('Comment'),
                            'sort' => 'comment',
                            'initial_sort_order' => 'ASC'
                        )
                    ); $cnt++; ?></th>
            <?php endif; ?>

            <?php if ($GLOBALS['cfg']['ShowDbStructureCreation']): ?>
                <!-- newer values are more interesting so default sort order is DESC -->
                <th><?= PMA\libraries\Template::get('database/structure/sortable_header')->render(
                        array(
                            'title' => __('Creation'),
                            'sort' => 'creation',
                            'initial_sort_order' => 'DESC'
                        )
                    ); $cnt++; ?></th>
            <?php endif; ?>

            <?php if ($GLOBALS['cfg']['ShowDbStructureLastUpdate']): ?>
                <!-- newer values are more interesting so default sort order is DESC -->
                <th><?= PMA\libraries\Template::get('database/structure/sortable_header')->render(
                        array(
                            'title' => __('Last update'),
                            'sort' => 'last_update',
                            'initial_sort_order' => 'DESC'
                        )
                    ); $cnt++; ?></th>
            <?php endif; ?>

            <?php if ($GLOBALS['cfg']['ShowDbStructureLastCheck']): ?>
                <!-- newer values are more interesting so default sort order is DESC -->
                <th><?= PMA\libraries\Template::get('database/structure/sortable_header')->render(
                        array(
                            'title' => __('Last check'),
                            'sort' => 'last_check',
                            'initial_sort_order' => 'DESC'
                        )
                    ); $cnt++; ?></th>
            <?php endif; ?>
        </tr>
    </thead>
    <tbody>
        <?php $GLOBALS['colspan_for_structure'] = $cnt + $action_colspan + 3; ?>
