diff options
| author | Charles <sircharlesaze@gmail.com> | 2020-01-09 10:55:03 +0100 |
|---|---|---|
| committer | Charles <sircharlesaze@gmail.com> | 2020-01-09 13:09:38 +0100 |
| commit | 04d6d5ca99ebfd1cebb8ce06618fb3811fc1a8aa (patch) | |
| tree | 5c691241355c943a3c68ddb06b8cf8c60aa11319 /srcs/phpmyadmin/templates/table/tracking/structure_snapshot_columns.twig | |
| parent | 7e0d85db834d6351ed85d01e5126ac31dc510b86 (diff) | |
| download | ft_server-04d6d5ca99ebfd1cebb8ce06618fb3811fc1a8aa.tar.gz ft_server-04d6d5ca99ebfd1cebb8ce06618fb3811fc1a8aa.tar.bz2 ft_server-04d6d5ca99ebfd1cebb8ce06618fb3811fc1a8aa.zip | |
phpmyadmin working
Diffstat (limited to 'srcs/phpmyadmin/templates/table/tracking/structure_snapshot_columns.twig')
| -rw-r--r-- | srcs/phpmyadmin/templates/table/tracking/structure_snapshot_columns.twig | 56 |
1 files changed, 56 insertions, 0 deletions
diff --git a/srcs/phpmyadmin/templates/table/tracking/structure_snapshot_columns.twig b/srcs/phpmyadmin/templates/table/tracking/structure_snapshot_columns.twig new file mode 100644 index 0000000..4ef8c21 --- /dev/null +++ b/srcs/phpmyadmin/templates/table/tracking/structure_snapshot_columns.twig @@ -0,0 +1,56 @@ +<h3>{% trans 'Structure' %}</h3> +<table id="tablestructure" class="data"> + <thead> + <tr> + <th>{% trans %}#{% context %}Number{% endtrans %}</th> + <th>{% trans 'Column' %}</th> + <th>{% trans 'Type' %}</th> + <th>{% trans 'Collation' %}</th> + <th>{% trans 'Null' %}</th> + <th>{% trans 'Default' %}</th> + <th>{% trans 'Extra' %}</th> + <th>{% trans 'Comment' %}</th> + </tr> + </thead> + <tbody> + {% set index = 1 %} + {% for field in columns %} + <tr class="noclick"> + <td>{{ index }}</td> + {% set index = index + 1 %} + <td> + <strong> + {{ field['Field'] }} + {% if field['Key'] == 'PRI' %} + {{ get_image('b_primary', 'Primary'|trans) }} + {% elseif field['Key'] is not empty %} + {{ get_image('bd_primary', 'Index'|trans) }} + {% endif %} + </strong> + </td> + <td>{{ field['Type'] }}</td> + <td>{{ field['Collation'] }}</td> + <td>{{ field['Null'] == 'YES' ? 'Yes'|trans : 'No'|trans }}</td> + <td> + {% if field['Default'] is defined %} + {% set extracted_columnspec = extract_column_spec(field['Type']) %} + {% if extracted_columnspec['type'] == 'bit' %} + {# here, $field['Default'] contains something like b'010' #} + {{ field['Default']|convert_bit_default_value }} + {% else %} + {{ field['Default'] }} + {% endif %} + {% else %} + {% if field['Null'] == 'YES' %} + <em>NULL</em> + {% else %} + <em>{% trans %}None{% context %}None for default{% endtrans %}</em> + {% endif %} + {% endif %} + </td> + <td>{{ field['Extra'] }}</td> + <td>{{ field['Comment'] }}</td> + </tr> + {% endfor %} + </tbody> +</table> |