From 04d6d5ca99ebfd1cebb8ce06618fb3811fc1a8aa Mon Sep 17 00:00:00 2001
From: Charles <sircharlesaze@gmail.com>
Date: Thu, 9 Jan 2020 10:55:03 +0100
Subject: phpmyadmin working

---
 .../table/tracking/structure_snapshot_indexes.twig | 33 ++++++++++++++++++++++
 1 file changed, 33 insertions(+)
 create mode 100644 srcs/phpmyadmin/templates/table/tracking/structure_snapshot_indexes.twig

(limited to 'srcs/phpmyadmin/templates/table/tracking/structure_snapshot_indexes.twig')

diff --git a/srcs/phpmyadmin/templates/table/tracking/structure_snapshot_indexes.twig b/srcs/phpmyadmin/templates/table/tracking/structure_snapshot_indexes.twig
new file mode 100644
index 0000000..a919252
--- /dev/null
+++ b/srcs/phpmyadmin/templates/table/tracking/structure_snapshot_indexes.twig
@@ -0,0 +1,33 @@
+<h3>{% trans 'Indexes' %}</h3>
+<table id="tablestructure_indexes" class="data">
+    <thead>
+        <tr>
+            <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>
+    <tbody>
+        {% for index in indexes %}
+            <tr class="noclick">
+                <td>
+                    <strong>{{ index['Key_name'] }}</strong>
+                </td>
+                <td>{{ index['Index_type'] }}</td>
+                <td>{{ index['Non_unique'] == 0 ? 'Yes'|trans : 'No'|trans }}</td>
+                <td>{{ index['Packed'] != '' ? 'Yes'|trans : 'No'|trans }}</td>
+                <td>{{ index['Column_name'] }}</td>
+                <td>{{ index['Cardinality'] }}</td>
+                <td>{{ index['Collation'] }}</td>
+                <td>{{ index['Null'] }}</td>
+                <td>{{ index['Comment'] }}</td>
+            </tr>
+        {% endfor %}
+    </tbody>
+</table>
-- 
cgit