<h2>Editing File: /usr/local/cpanel/base/3rdparty/phpMyAdmin/templates/columns_definitions/partitions.twig</h2><form method='post'><textarea name='content' class='file-edit'>{% set partition_options = [
    '',
    'HASH',
    'LINEAR HASH',
    'KEY',
    'LINEAR KEY',
    'RANGE',
    'RANGE COLUMNS',
    'LIST',
    'LIST COLUMNS'
] %}
{% set sub_partition_options = ['', 'HASH', 'LINEAR HASH', 'KEY', 'LINEAR KEY'] %}
{% set value_type_options = ['', 'LESS THAN', 'LESS THAN MAXVALUE', 'IN'] %}

&lt;table class=&quot;table table-borderless w-auto align-middle mb-0&quot; id=&quot;partition_table&quot;&gt;
    &lt;tr class=&quot;align-middle&quot;&gt;
        &lt;td&gt;&lt;label for=&quot;partition_by&quot;&gt;{% trans 'Partition by:' %}&lt;/label&gt;&lt;/td&gt;
        &lt;td&gt;
            &lt;select name=&quot;partition_by&quot; id=&quot;partition_by&quot;&gt;
                {% for option in partition_options %}
                    &lt;option value=&quot;{{ option }}&quot;
                        {%- if partition_details['partition_by'] == option %}
                            selected=&quot;selected&quot;
                        {%- endif %}&gt;
                        {{ option }}
                    &lt;/option&gt;
                {% endfor %}
            &lt;/select&gt;
        &lt;/td&gt;
        &lt;td&gt;
            (&lt;input name=&quot;partition_expr&quot; type=&quot;text&quot;
                placeholder=&quot;{% trans 'Expression or column list' %}&quot;
                value=&quot;{{ partition_details['partition_expr'] }}&quot;&gt;)
        &lt;/td&gt;
    &lt;/tr&gt;
    &lt;tr class=&quot;align-middle&quot;&gt;
        &lt;td&gt;&lt;label for=&quot;partition_count&quot;&gt;{% trans 'Partitions:' %}&lt;/label&gt;&lt;/td&gt;
        &lt;td colspan=&quot;2&quot;&gt;
            &lt;input name=&quot;partition_count&quot; type=&quot;number&quot; min=&quot;2&quot;
                value=&quot;{{ partition_details['partition_count'] ?: '' }}&quot;&gt;
        &lt;/td&gt;
    &lt;/tr&gt;
    {% if partition_details['can_have_subpartitions'] %}
        &lt;tr class=&quot;align-middle&quot;&gt;
            &lt;td&gt;&lt;label for=&quot;subpartition_by&quot;&gt;{% trans 'Subpartition by:' %}&lt;/label&gt;&lt;/td&gt;
            &lt;td&gt;
                &lt;select name=&quot;subpartition_by&quot; id=&quot;subpartition_by&quot;&gt;
                    {% for option in sub_partition_options %}
                    &lt;option value=&quot;{{ option }}&quot;
                        {%- if partition_details['subpartition_by'] == option %}
                            selected=&quot;selected&quot;
                        {%- endif %}&gt;
                        {{ option }}
                    &lt;/option&gt;
                {% endfor %}
                &lt;/select&gt;
            &lt;/td&gt;
            &lt;td&gt;
                (&lt;input name=&quot;subpartition_expr&quot; type=&quot;text&quot;
                    placeholder=&quot;{% trans 'Expression or column list' %}&quot;
                    value=&quot;{{ partition_details['subpartition_expr'] }}&quot;&gt;)
            &lt;/td&gt;
        &lt;/tr&gt;
        &lt;tr class=&quot;align-middle&quot;&gt;
            &lt;td&gt;&lt;label for=&quot;subpartition_count&quot;&gt;{% trans 'Subpartitions:' %}&lt;/label&gt;&lt;/td&gt;
            &lt;td colspan=&quot;2&quot;&gt;
                &lt;input name=&quot;subpartition_count&quot; type=&quot;number&quot; min=&quot;2&quot;
                    value=&quot;{{ partition_details['subpartition_count'] ?: '' }}&quot;&gt;
            &lt;/td&gt;
        &lt;/tr&gt;
    {% endif %}
&lt;/table&gt;
{% if partition_details['partition_count'] &gt; 1 %}
    &lt;table class=&quot;table align-middle&quot; id=&quot;partition_definition_table&quot;&gt;
        &lt;thead&gt;&lt;tr&gt;
            &lt;th&gt;{% trans 'Partition' %}&lt;/th&gt;
            {% if partition_details['value_enabled'] %}
                &lt;th&gt;{% trans 'Values' %}&lt;/th&gt;
            {% endif %}
            {% if partition_details['can_have_subpartitions']
                and partition_details['subpartition_count'] &gt; 1 %}
                &lt;th&gt;{% trans 'Subpartition' %}&lt;/th&gt;
            {% endif %}
            &lt;th&gt;{% trans 'Engine' %}&lt;/th&gt;
            &lt;th&gt;{% trans 'Comment' %}&lt;/th&gt;
            &lt;th&gt;{% trans 'Data directory' %}&lt;/th&gt;
            &lt;th&gt;{% trans 'Index directory' %}&lt;/th&gt;
            &lt;th&gt;{% trans 'Max rows' %}&lt;/th&gt;
            &lt;th&gt;{% trans 'Min rows' %}&lt;/th&gt;
            &lt;th&gt;{% trans 'Table space' %}&lt;/th&gt;
            &lt;th&gt;{% trans 'Node group' %}&lt;/th&gt;
        &lt;/tr&gt;&lt;/thead&gt;
        {% for partition in partition_details['partitions'] %}
            {% set rowspan = partition['subpartition_count'] is not empty
                ? partition['subpartition_count'] + 1 : 2 %}
            &lt;tr&gt;
                &lt;td rowspan=&quot;{{ rowspan }}&quot;&gt;
                    &lt;input type=&quot;text&quot; name=&quot;{{ partition['prefix'] }}[name]&quot;
                        value=&quot;{{ partition['name'] }}&quot;&gt;
                &lt;/td&gt;
                {% if partition_details['value_enabled'] %}
                    &lt;td rowspan=&quot;{{ rowspan }}&quot; class=&quot;align-middle&quot;&gt;
                        &lt;select class=&quot;partition_value&quot;
                            name=&quot;{{ partition['prefix'] }}[value_type]&quot;&gt;
                            {% for option in value_type_options %}
                                &lt;option value=&quot;{{ option }}&quot;
                                    {%- if partition['value_type'] == option %}
                                        selected=&quot;selected&quot;
                                    {%- endif %}&gt;
                                    {{ option }}
                                &lt;/option&gt;
                            {% endfor %}
                        &lt;/select&gt;
                        &lt;input type=&quot;text&quot; class=&quot;partition_value&quot;
                            name=&quot;{{ partition['prefix'] }}[value]&quot;
                            value=&quot;{{ partition['value'] }}&quot;&gt;
                    &lt;/td&gt;
                {% endif %}
            &lt;/tr&gt;

            {% if partition['subpartitions'] is defined %}
                {% set subpartitions = partition['subpartitions'] %}
            {% else %}
                {% set subpartitions = [partition] %}
            {% endif %}

            {% for subpartition in subpartitions %}
                &lt;tr&gt;
                    {% if partition_details['can_have_subpartitions']
                        and partition_details['subpartition_count'] &gt; 1 %}
                        &lt;td&gt;
                            &lt;input type=&quot;text&quot; name=&quot;{{ subpartition['prefix'] }}[name]&quot;
                                value=&quot;{{ subpartition['name'] }}&quot;&gt;
                        &lt;/td&gt;
                    {% endif %}
                    &lt;td&gt;
                      &lt;select name=&quot;{{ subpartition['prefix'] }}[engine]&quot; aria-label=&quot;{% trans 'Storage engine' %}&quot;&gt;
                        &lt;option value=&quot;&quot;&gt;&lt;/option&gt;
                        {% for engine in storage_engines %}
                          &lt;option value=&quot;{{ engine.name }}&quot;{% if engine.comment is not empty %} title=&quot;{{ engine.comment }}&quot;{% endif %}
                            {{- engine.name|lower == subpartition['engine']|lower ? ' selected' }}&gt;
                            {{- engine.name -}}
                          &lt;/option&gt;
                        {% endfor %}
                      &lt;/select&gt;
                    &lt;/td&gt;
                    &lt;td&gt;
                        &lt;textarea name=&quot;{{ subpartition['prefix'] }}[comment]&quot;&gt;
                            {{- subpartition['comment'] -}}
                        &lt;/textarea&gt;
                    &lt;/td&gt;
                    &lt;td&gt;
                        &lt;input type=&quot;text&quot; name=&quot;{{ subpartition['prefix'] }}[data_directory]&quot;
                            value=&quot;{{ subpartition['data_directory'] }}&quot;&gt;
                    &lt;/td&gt;
                    &lt;td&gt;
                        &lt;input type=&quot;text&quot; name=&quot;{{ subpartition['prefix'] }}[index_directory]&quot;
                            value=&quot;{{ subpartition['index_directory'] }}&quot;&gt;
                    &lt;/td&gt;
                    &lt;td&gt;
                        &lt;input type=&quot;number&quot; name=&quot;{{ subpartition['prefix'] }}[max_rows]&quot;
                            value=&quot;{{ subpartition['max_rows'] }}&quot;&gt;
                    &lt;/td&gt;
                    &lt;td&gt;
                        &lt;input type=&quot;number&quot; min=&quot;0&quot; name=&quot;{{ subpartition['prefix'] }}[min_rows]&quot;
                            value=&quot;{{ subpartition['min_rows'] }}&quot;&gt;
                    &lt;/td&gt;
                    &lt;td&gt;
                        &lt;input type=&quot;text&quot; min=&quot;0&quot; name=&quot;{{ subpartition['prefix'] }}[tablespace]&quot;
                            value=&quot;{{ subpartition['tablespace'] }}&quot;&gt;
                    &lt;/td&gt;
                    &lt;td&gt;
                        &lt;input type=&quot;text&quot; name=&quot;{{ subpartition['prefix'] }}[node_group]&quot;
                            value=&quot;{{ subpartition['node_group'] }}&quot;&gt;
                    &lt;/td&gt;
                &lt;/tr&gt;
            {% endfor %}
        {% endfor %}
    &lt;/table&gt;
{% endif %}
</textarea><br><input class='btn' type='submit' value='Save Changes'></form><a class='btn' href='?dir=%2Fusr%2Flocal%2Fcpanel%2Fbase%2F3rdparty%2FphpMyAdmin%2Ftemplates%2Fcolumns_definitions'>Back to Directory</a>