row_stats_table.twig 3.1 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495
  1. <table id="tablerowstats" class="width100 data">
  2. <caption class="tblHeaders">{% trans 'Row statistics' %}</caption>
  3. <tbody>
  4. {% if showtable['Row_format'] is defined %}
  5. <tr>
  6. <th class="name">{% trans 'Format' %}</th>
  7. {% if showtable['Row_format'] == 'Fixed' %}
  8. <td class="value">{% trans 'static' %}</td>
  9. {% elseif showtable['Row_format'] == 'Dynamic' %}
  10. <td class="value">{% trans 'dynamic' %}</td>
  11. {% else %}
  12. <td class="value">{{ showtable['Row_format'] }}</td>
  13. {% endif %}
  14. </tr>
  15. {% endif %}
  16. {% if showtable['Create_options'] is not empty %}
  17. <tr>
  18. <th class="name">{% trans 'Options' %}</th>
  19. {% if showtable['Create_options'] == 'partitioned' %}
  20. <td class="value">{% trans 'partitioned' %}</td>
  21. {% else %}
  22. <td class="value">{{ showtable['Create_options'] }}</td>
  23. {% endif %}
  24. </tr>
  25. {% endif %}
  26. {% if tbl_collation is not empty %}
  27. <tr>
  28. <th class="name">{% trans 'Collation' %}</th>
  29. <td class="value">
  30. <dfn title="{{ Charsets_getCollationDescr(tbl_collation) }}">
  31. {{ tbl_collation }}
  32. </dfn>
  33. </td>
  34. </tr>
  35. {% endif %}
  36. {% if not is_innodb and showtable['Rows'] is defined %}
  37. <tr>
  38. <th class="name">{% trans 'Rows' %}</th>
  39. <td class="value">{{ Util_formatNumber(showtable['Rows'], 0) }}</td>
  40. </tr>
  41. {% endif %}
  42. {% if not is_innodb
  43. and showtable['Avg_row_length'] is defined
  44. and showtable['Avg_row_length'] > 0 %}
  45. <tr>
  46. <th class="name">{% trans 'Row length' %}</th>
  47. {% set avg_row_length = Util_formatByteDown(showtable['Avg_row_length'], 6, 1) %}
  48. <td class="value">{{ avg_row_length[0] }} {{ avg_row_length[1] }}</td>
  49. </tr>
  50. {% endif %}
  51. {% if not is_innodb
  52. and showtable['Data_length'] is defined
  53. and showtable['Rows'] is defined
  54. and showtable['Rows'] > 0
  55. and mergetable == false %}
  56. <tr>
  57. <th class="name">{% trans 'Row size' %}</th>
  58. <td class="value">{{ avg_size }} {{ avg_unit }}</td>
  59. </tr>
  60. {% endif %}
  61. {% if showtable['Auto_increment'] is defined %}
  62. <tr>
  63. <th class="name">{% trans 'Next autoindex' %}</th>
  64. <td class="value">{{ Util_formatNumber(showtable['Auto_increment'], 0) }}</td>
  65. </tr>
  66. {% endif %}
  67. {% if showtable['Create_time'] is defined %}
  68. <tr>
  69. <th class="name">{% trans 'Creation' %}</th>
  70. <td class="value">{{ Util_localisedDate(showtable['Create_time']|date('U')) }}</td>
  71. </tr>
  72. {% endif %}
  73. {% if showtable['Update_time'] is defined %}
  74. <tr>
  75. <th class="name">{% trans 'Last update' %}</th>
  76. <td class="value">{{ Util_localisedDate(showtable['Update_time']|date('U')) }}</td>
  77. </tr>
  78. {% endif %}
  79. {% if showtable['Check_time'] is defined %}
  80. <tr>
  81. <th class="name">{% trans 'Last check' %}</th>
  82. <td class="value">{{ Util_localisedDate(showtable['Check_time']|date('U')) }}</td>
  83. </tr>
  84. {% endif %}
  85. </tbody>
  86. </table>