<h2>Editing File: /usr/local/cpanel/base/3rdparty/phpMyAdmin/templates/columns_definitions/column_attributes.twig</h2><form method='post'><textarea name='content' class='file-edit'>{# Cell index: If certain fields get left out, the counter shouldn't change. #}
{% set ci = 0 %}

{# Every time a cell shall be left out the STRG-jumping feature, $ci_offset has
   to be incremented ($ci_offset++) #}
{% set ci_offset = -1 %}

&lt;td class=&quot;text-center&quot;&gt;
    {# column name #}
    {% include 'columns_definitions/column_name.twig' with {
        'column_number': column_number,
        'ci': ci,
        'ci_offset': ci_offset,
        'column_meta': column_meta,
        'has_central_columns_feature': relation_parameters.centralColumnsFeature is not null,
        'max_rows': max_rows
    } only %}
    {% set ci = ci + 1 %}
&lt;/td&gt;
&lt;td class=&quot;text-center&quot;&gt;
  &lt;select class=&quot;column_type&quot; name=&quot;field_type[{{ column_number }}]&quot; id=&quot;field_{{ column_number }}_{{ ci - ci_offset }}&quot;
    {{- column_meta['column_status'] is defined and not column_meta['column_status']['isEditable'] ? ' disabled' }}&gt;
    {{ get_supported_datatypes(true, type_upper) }}
  &lt;/select&gt;
  {% set ci = ci + 1 %}
&lt;/td&gt;
&lt;td class=&quot;text-center&quot;&gt;
  &lt;input id=&quot;field_{{ column_number }}_{{ ci - ci_offset }}&quot; type=&quot;text&quot; name=&quot;field_length[{{ column_number }}]&quot; size=&quot;
    {{- length_values_input_size }}&quot; value=&quot;{{ length }}&quot; class=&quot;textfield&quot;&gt;
  &lt;p class=&quot;enum_notice&quot; id=&quot;enum_notice_{{ column_number }}_{{ ci - ci_offset }}&quot;&gt;
    &lt;a href=&quot;#&quot; class=&quot;open_enum_editor&quot;&gt;{% trans 'Edit ENUM/SET values' %}&lt;/a&gt;
  &lt;/p&gt;
  {% set ci = ci + 1 %}
&lt;/td&gt;
&lt;td class=&quot;text-center&quot;&gt;
  &lt;select name=&quot;field_default_type[{{ column_number }}]&quot; id=&quot;field_{{ column_number }}_{{ ci - ci_offset }}&quot; class=&quot;default_type&quot;&gt;
    &lt;option value=&quot;NONE&quot;{{ column_meta['DefaultType'] is defined and column_meta['DefaultType'] == 'NONE' ? ' selected' }}&gt;
      {% trans %}None{% context %}for default{% endtrans %}
    &lt;/option&gt;
    &lt;option value=&quot;USER_DEFINED&quot;{{ column_meta['DefaultType'] is defined and column_meta['DefaultType'] == 'USER_DEFINED' ? ' selected' }}&gt;
      {% trans 'As defined:' %}
    &lt;/option&gt;
    &lt;option value=&quot;NULL&quot;{{ column_meta['DefaultType'] is defined and column_meta['DefaultType'] == 'NULL' ? ' selected' }}&gt;
      NULL
    &lt;/option&gt;
    &lt;option value=&quot;CURRENT_TIMESTAMP&quot;{{ column_meta['DefaultType'] is defined and column_meta['DefaultType'] == 'CURRENT_TIMESTAMP' ? ' selected' }}&gt;
      CURRENT_TIMESTAMP
    &lt;/option&gt;
    {% if is_uuid_supported() %}
    &lt;option value=&quot;UUID&quot;{{ column_meta['DefaultType'] is defined and column_meta['DefaultType'] == 'UUID' ? ' selected' }}&gt;
      UUID
    &lt;/option&gt;
    {% endif %}
  &lt;/select&gt;
  {% if char_editing == 'textarea' %}
    &lt;textarea name=&quot;field_default_value[{{ column_number }}]&quot; cols=&quot;15&quot; class=&quot;textfield default_value&quot;&gt;{{ default_value }}&lt;/textarea&gt;
  {% else %}
    &lt;input type=&quot;text&quot; name=&quot;field_default_value[{{ column_number }}]&quot; size=&quot;12&quot; value=&quot;{{ default_value }}&quot; class=&quot;textfield default_value&quot;&gt;
  {% endif %}
  {% set ci = ci + 1 %}
&lt;/td&gt;
&lt;td class=&quot;text-center&quot;&gt;
  {# column collation #}
  &lt;select lang=&quot;en&quot; dir=&quot;ltr&quot; name=&quot;field_collation[{{ column_number }}]&quot; id=&quot;field_{{ column_number }}_{{ ci - ci_offset }}&quot;&gt;
    &lt;option value=&quot;&quot;&gt;&lt;/option&gt;
    {% for charset in charsets %}
      &lt;optgroup label=&quot;{{ charset.name }}&quot; title=&quot;{{ charset.description }}&quot;&gt;
        {% for collation in charset.collations %}
          &lt;option value=&quot;{{ collation.name }}&quot; title=&quot;{{ collation.description }}&quot;
            {{- collation.name == column_meta['Collation'] ? ' selected' }}&gt;
            {{- collation.name -}}
          &lt;/option&gt;
        {% endfor %}
      &lt;/optgroup&gt;
    {% endfor %}
  &lt;/select&gt;
  {% set ci = ci + 1 %}
&lt;/td&gt;
&lt;td class=&quot;text-center&quot;&gt;
    {# column attribute #}
    {% include 'columns_definitions/column_attribute.twig' with {
        'column_number': column_number,
        'ci': ci,
        'ci_offset': ci_offset,
        'column_meta': column_meta,
        'extracted_columnspec': extracted_columnspec,
        'submit_attribute': submit_attribute,
        'attribute_types': attribute_types
    } only %}
    {% set ci = ci + 1 %}
&lt;/td&gt;
&lt;td class=&quot;text-center&quot;&gt;
    &lt;input name=&quot;field_null[{{ column_number }}]&quot; id=&quot;field_{{ column_number }}_{{ ci - ci_offset }}&quot; type=&quot;checkbox&quot; value=&quot;YES&quot; class=&quot;allow_null&quot;
      {{- column_meta['Null'] is not empty and column_meta['Null'] != 'NO' and column_meta['Null'] != 'NOT NULL' ? ' checked' }}&gt;
    {% set ci = ci + 1 %}
&lt;/td&gt;
{% if change_column is defined and change_column is not empty %}
    {# column Adjust privileges, Only for 'Edit' Column(s) #}
    &lt;td class=&quot;text-center&quot;&gt;
      &lt;input name=&quot;field_adjust_privileges[{{ column_number }}]&quot; id=&quot;field_{{ column_number }}_{{ ci - ci_offset }}&quot; type=&quot;checkbox&quot; value=&quot;NULL&quot; class=&quot;allow_null&quot;
        {%- if privs_available %} checked&gt;
        {%- else %} title=&quot;{% trans &quot;You don't have sufficient privileges to perform this operation; Please refer to the documentation for more details&quot; %}&quot; disabled&gt;
        {%- endif %}
      {% set ci = ci + 1 %}
    &lt;/td&gt;
{% endif %}
{% if not is_backup %}
    {# column indexes, See my other comment about  this 'if'. #}
    &lt;td class=&quot;text-center&quot;&gt;
      &lt;select name=&quot;field_key[{{ column_number }}]&quot; id=&quot;field_{{ column_number }}_{{ ci - ci_offset }}&quot; data-index=&quot;&quot;&gt;
        &lt;option value=&quot;none_{{ column_number }}&quot;&gt;---&lt;/option&gt;
        &lt;option value=&quot;primary_{{ column_number }}&quot; title=&quot;{% trans &quot;Primary&quot; %}&quot;
          {{- column_meta['Key'] is defined and column_meta['Key'] == 'PRI' ? ' selected' }}&gt;
          PRIMARY
        &lt;/option&gt;
        &lt;option value=&quot;unique_{{ column_number }}&quot; title=&quot;{% trans &quot;Unique&quot; %}&quot;
          {{- column_meta['Key'] is defined and column_meta['Key'] == 'UNI' ? ' selected' }}&gt;
          UNIQUE
        &lt;/option&gt;
        &lt;option value=&quot;index_{{ column_number }}&quot; title=&quot;{% trans &quot;Index&quot; %}&quot;
          {{- column_meta['Key'] is defined and column_meta['Key'] == 'MUL' ? ' selected' }}&gt;
          INDEX
        &lt;/option&gt;
        &lt;option value=&quot;fulltext_{{ column_number }}&quot; title=&quot;{% trans &quot;Fulltext&quot; %}&quot;
          {{- column_meta['Key'] is defined and column_meta['Key'] == 'FULLTEXT' ? ' selected' }}&gt;
          FULLTEXT
        &lt;/option&gt;
        &lt;option value=&quot;spatial_{{ column_number }}&quot; title=&quot;{% trans &quot;Spatial&quot; %}&quot;
          {{- column_meta['Key'] is defined and column_meta['Key'] == 'SPATIAL' ? ' selected' }}&gt;
          SPATIAL
        &lt;/option&gt;
      &lt;/select&gt;
      {% set ci = ci + 1 %}
    &lt;/td&gt;
{% endif %}
&lt;td class=&quot;text-center&quot;&gt;
  &lt;input name=&quot;field_extra[{{ column_number }}]&quot; id=&quot;field_{{ column_number }}_{{ ci - ci_offset }}&quot; type=&quot;checkbox&quot; value=&quot;AUTO_INCREMENT&quot;
    {{- column_meta['Extra'] is defined and column_meta['Extra']|lower == 'auto_increment' ? ' checked' }}&gt;
  {% set ci = ci + 1 %}
&lt;/td&gt;
&lt;td class=&quot;text-center&quot;&gt;
  &lt;textarea id=&quot;field_{{ column_number }}_{{ ci - ci_offset }}&quot; rows=&quot;1&quot; name=&quot;field_comments[{{ column_number }}]&quot; maxlength=&quot;{{ max_length }}&quot;&gt;
    {{- column_meta['Field'] is defined and comments_map is iterable and comments_map[column_meta['Field']] is defined ? comments_map[column_meta['Field']] -}}
  &lt;/textarea&gt;
  {% set ci = ci + 1 %}
&lt;/td&gt;
 {# column virtuality #}
{% if is_virtual_columns_supported %}
    &lt;td class=&quot;text-center&quot;&gt;
      &lt;select name=&quot;field_virtuality[{{ column_number }}]&quot; id=&quot;field_{{ column_number }}_{{ ci - ci_offset }}&quot; class=&quot;virtuality&quot;&gt;
        {% for key, value in options %}
          {% set virtuality = column_meta['Extra'] is defined ? column_meta['Extra'] : null %}
          {# Creating a new row on create table sends a Virtuality field #}
          {% set virtuality = column_meta['Virtuality'] is defined ? column_meta['Virtuality'] : virtuality %}

          &lt;option value=&quot;{{ key }}&quot;{{ virtuality is not null and key != '' and virtuality|slice(0, key|length) is same as (key) ? ' selected' }}&gt;
            {{ value }}
          &lt;/option&gt;
        {% endfor %}
      &lt;/select&gt;

      {% if char_editing == 'textarea' %}
        &lt;textarea name=&quot;field_expression[{{ column_number }}]&quot; cols=&quot;15&quot; class=&quot;textfield expression&quot;&gt;{{ column_meta['Expression'] is defined ? column_meta['Expression'] }}&lt;/textarea&gt;
      {% else %}
        &lt;input type=&quot;text&quot; name=&quot;field_expression[{{ column_number }}]&quot; size=&quot;12&quot; value=&quot;{{ column_meta['Expression'] is defined ? column_meta['Expression'] }}&quot; placeholder=&quot;{% trans 'Expression' %}&quot; class=&quot;textfield expression&quot;&gt;
      {% endif %}
      {% set ci = ci + 1 %}
    &lt;/td&gt;
{% endif %}
{# move column #}
{% if fields_meta is defined %}
    {% set current_index = 0 %}
    {% set cols = move_columns|length - 1 %}
    {% set break = false %}
    {% for mi in 0..cols %}
      {% if move_columns[mi].name == column_meta['Field'] and not break %}
        {% set current_index = mi %}
        {% set break = true %}
      {% endif %}
    {% endfor %}

    &lt;td class=&quot;text-center&quot;&gt;
      &lt;select id=&quot;field_{{ column_number }}_{{ ci - ci_offset }}&quot; name=&quot;field_move_to[{{ column_number }}]&quot; size=&quot;1&quot; width=&quot;5em&quot;&gt;
        &lt;option value=&quot;&quot; selected=&quot;selected&quot;&gt;&amp;nbsp;&lt;/option&gt;
        &lt;option value=&quot;-first&quot;{{ current_index == 0 ? ' disabled=&quot;disabled&quot;' }}&gt;
          {% trans 'first' %}
        &lt;/option&gt;
        {% for mi in 0..move_columns|length - 1 %}
          &lt;option value=&quot;{{ move_columns[mi].name }}&quot;
            {{- current_index == mi or current_index == mi + 1 ? ' disabled' }}&gt;
            {{ 'after %s'|trans|format(backquote(move_columns[mi].name|e)) }}
          &lt;/option&gt;
        {% endfor %}
      &lt;/select&gt;
      {% set ci = ci + 1 %}
    &lt;/td&gt;
{% endif %}

{% if relation_parameters.browserTransformationFeature is not null and relation_parameters.columnCommentsFeature is not null and browse_mime %}
    &lt;td class=&quot;text-center&quot;&gt;
      &lt;select id=&quot;field_{{ column_number }}_{{ ci - ci_offset }}&quot; size=&quot;1&quot; name=&quot;field_mimetype[{{ column_number }}]&quot;&gt;
        &lt;option value=&quot;&quot;&gt;&amp;nbsp;&lt;/option&gt;
        {% if available_mime['mimetype'] is defined and available_mime['mimetype'] is iterable %}
          {% for media_type in available_mime['mimetype'] %}
            &lt;option value=&quot;{{ media_type|replace({'/': '_'}) }}&quot;
              {{- column_meta['Field'] is defined and mime_map[column_meta['Field']]['mimetype'] is defined
                and mime_map[column_meta['Field']]['mimetype'] == media_type|replace({'/': '_'}) ? ' selected' }}&gt;
              {{ media_type|lower }}
            &lt;/option&gt;
          {% endfor %}
        {% endif %}
      &lt;/select&gt;
      {% set ci = ci + 1 %}
    &lt;/td&gt;
    &lt;td class=&quot;text-center&quot;&gt;
      &lt;select id=&quot;field_{{ column_number }}_{{ ci - ci_offset }}&quot; size=&quot;1&quot; name=&quot;field_transformation[{{ column_number }}]&quot;&gt;
        &lt;option value=&quot;&quot; title=&quot;{% trans 'None' %}&quot;&gt;&lt;/option&gt;
        {% if available_mime['transformation'] is defined and available_mime['transformation'] is iterable %}
          {% for mimekey, transform in available_mime['transformation'] %}
            {% set parts = transform|split(':') %}
            &lt;option value=&quot;{{ available_mime['transformation_file'][mimekey] }}&quot; title=&quot;{{ get_description(available_mime['transformation_file'][mimekey]) }}&quot;
              {{- column_meta['Field'] is defined
                and mime_map[column_meta['Field']]['transformation'] is defined
                and mime_map[column_meta['Field']]['transformation'] is not null
                and mime_map[column_meta['Field']]['transformation'] matches '@' ~ available_mime['transformation_file_quoted'][mimekey] ~ '3?@i' ? ' selected'}}&gt;
              {{ get_name(available_mime['transformation_file'][mimekey]) ~ ' (' ~ parts[0]|lower ~ ':' ~ parts[1] ~ ')' }}
            &lt;/option&gt;
          {% endfor %}
        {% endif %}
      &lt;/select&gt;
      {% set ci = ci + 1 %}
    &lt;/td&gt;
    &lt;td class=&quot;text-center&quot;&gt;
      &lt;input id=&quot;field_{{ column_number }}_{{ ci - ci_offset }}&quot; type=&quot;text&quot; name=&quot;field_transformation_options[{{ column_number }}]&quot; size=&quot;16&quot; class=&quot;textfield&quot; value=&quot;
        {{- column_meta['Field'] is defined and mime_map[column_meta['Field']]['transformation_options'] is defined ? mime_map[column_meta['Field']]['transformation_options'] }}&quot;&gt;
      {% set ci = ci + 1 %}
    &lt;/td&gt;
    &lt;td class=&quot;text-center&quot;&gt;
      &lt;select id=&quot;field_{{ column_number }}_{{ ci - ci_offset }}&quot; size=&quot;1&quot; name=&quot;field_input_transformation[{{ column_number }}]&quot;&gt;
        &lt;option value=&quot;&quot; title=&quot;{% trans 'None' %}&quot;&gt;&lt;/option&gt;
        {% if available_mime['input_transformation'] is defined and available_mime['input_transformation'] is iterable %}
          {% for mimekey, transform in available_mime['input_transformation'] %}
            {% set parts = transform|split(':') %}
            &lt;option value=&quot;{{ available_mime['input_transformation_file'][mimekey] }}&quot; title=&quot;{{ get_description(available_mime['input_transformation_file'][mimekey]) }}&quot;
              {{- column_meta['Field'] is defined and mime_map[column_meta['Field']]['input_transformation'] is defined
                and mime_map[column_meta['Field']]['input_transformation'] matches '@' ~ available_mime['input_transformation_file_quoted'][mimekey] ~ '3?@i' ? ' selected' }}&gt;
              {{ get_name(available_mime['input_transformation_file'][mimekey]) ~ ' (' ~ parts[0]|lower ~ ':' ~ parts[1] ~ ')' }}
            &lt;/option&gt;
          {% endfor %}
        {% endif %}
      &lt;/select&gt;
      {% set ci = ci + 1 %}
    &lt;/td&gt;
    &lt;td class=&quot;text-center&quot;&gt;
      &lt;input id=&quot;field_{{ column_number }}_{{ ci - ci_offset }}&quot; type=&quot;text&quot; name=&quot;field_input_transformation_options[{{ column_number }}]&quot; size=&quot;16&quot; class=&quot;textfield&quot; value=&quot;
        {{- column_meta['Field'] is defined and mime_map[column_meta['Field']]['input_transformation_options'] is defined ? mime_map[column_meta['Field']]['input_transformation_options'] }}&quot;&gt;
      {% set ci = ci + 1 %}
    &lt;/td&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>