"; echo twig_escape_filter($this->env, ($context["table"] ?? null), "html", null, true); echo "

"; // line 17 echo " "; // line 27 if (($context["show_column_comments"] ?? null)) { // line 28 echo ""; } // line 30 echo " "; // line 32 echo " "; if (( !($context["db_is_system_schema"] ?? null) && !($context["tbl_is_view"] ?? null))) { // line 33 echo " "; } // line 36 echo " "; // line 40 echo " "; $context["rownum"] = 0; // line 41 echo " "; $context['_parent'] = $context; $context['_seq'] = twig_ensure_traversable(($context["fields"] ?? null)); foreach ($context['_seq'] as $context["_key"] => $context["row"]) { // line 42 echo " "; $context["rownum"] = (($context["rownum"] ?? null) + 1); // line 43 echo " "; // line 44 $context["extracted_columnspec"] = (($__internal_compile_0 = ($context["extracted_columnspecs"] ?? null)) && is_array($__internal_compile_0) || $__internal_compile_0 instanceof ArrayAccess ? ($__internal_compile_0[($context["rownum"] ?? null)] ?? null) : null); // line 45 echo " "; $context["field_name"] = twig_escape_filter($this->env, (($__internal_compile_1 = $context["row"]) && is_array($__internal_compile_1) || $__internal_compile_1 instanceof ArrayAccess ? ($__internal_compile_1["Field"] ?? null) : null)); // line 46 echo " "; // line 47 echo " "; $context["comments"] = (($__internal_compile_2 = ($context["row_comments"] ?? null)) && is_array($__internal_compile_2) || $__internal_compile_2 instanceof ArrayAccess ? ($__internal_compile_2[($context["rownum"] ?? null)] ?? null) : null); // line 48 echo " "; // line 49 echo " "; // line 67 echo (($__internal_compile_10 = ($context["extracted_columnspec"] ?? null)) && is_array($__internal_compile_10) || $__internal_compile_10 instanceof ArrayAccess ? ($__internal_compile_10["displayed_type"] ?? null) : null); echo " "; // line 68 if (((( !(null === twig_get_attribute($this->env, $this->source, ($context["relation_parameters"] ?? null), "columnCommentsFeature", [], "any", false, false, false, 68)) && !(null === twig_get_attribute($this->env, $this->source, ($context["relation_parameters"] ?? null), "browserTransformationFeature", [], "any", false, false, false, 68))) && ($context["browse_mime"] ?? null)) && twig_get_attribute($this->env, $this->source, twig_get_attribute($this->env, $this->source, // line 69 ($context["mime_map"] ?? null), (($__internal_compile_11 = $context["row"]) && is_array($__internal_compile_11) || $__internal_compile_11 instanceof ArrayAccess ? ($__internal_compile_11["Field"] ?? null) : null), [], "array", false, true, false, 69), "mimetype", [], "array", true, true, false, 69))) { // line 70 echo "
"; echo _gettext("Media type:"); echo " "; echo twig_escape_filter($this->env, twig_lower_filter($this->env, twig_replace_filter((($__internal_compile_12 = (($__internal_compile_13 = ($context["mime_map"] ?? null)) && is_array($__internal_compile_13) || $__internal_compile_13 instanceof ArrayAccess ? ($__internal_compile_13[(($__internal_compile_14 = $context["row"]) && is_array($__internal_compile_14) || $__internal_compile_14 instanceof ArrayAccess ? ($__internal_compile_14["Field"] ?? null) : null)] ?? null) : null)) && is_array($__internal_compile_12) || $__internal_compile_12 instanceof ArrayAccess ? ($__internal_compile_12["mimetype"] ?? null) : null), ["_" => "/"])), "html", null, true); echo " "; } // line 72 echo " "; // line 94 if (($context["show_column_comments"] ?? null)) { // line 95 echo " "; } // line 99 echo " "; // line 100 if (( !($context["tbl_is_view"] ?? null) && !($context["db_is_system_schema"] ?? null))) { // line 101 echo " "; } // line 124 echo " "; // line 125 if (( !($context["tbl_is_view"] ?? null) && !($context["db_is_system_schema"] ?? null))) { // line 126 echo " "; $context["type"] = (( !twig_test_empty((($__internal_compile_32 = ($context["extracted_columnspec"] ?? null)) && is_array($__internal_compile_32) || $__internal_compile_32 instanceof ArrayAccess ? ($__internal_compile_32["print_type"] ?? null) : null))) ? ((($__internal_compile_33 = ($context["extracted_columnspec"] ?? null)) && is_array($__internal_compile_33) || $__internal_compile_33 instanceof ArrayAccess ? ($__internal_compile_33["print_type"] ?? null) : null)) : ("")); // line 127 echo " "; } // line 270 echo " "; } $_parent = $context['_parent']; unset($context['_seq'], $context['_iterated'], $context['_key'], $context['row'], $context['_parent'], $context['loop']); $context = array_intersect_key($context, $_parent) + $_parent; // line 272 echo "

	#	"; echo _gettext("Name"); // line 21 echo "	"; echo _gettext("Type"); // line 22 echo "	"; echo _gettext("Collation"); // line 23 echo "	"; echo _gettext("Attributes"); // line 24 echo "	"; echo _gettext("Null"); // line 25 echo "	"; echo _gettext("Default"); // line 26 echo "	"; echo _gettext("Comments"); echo "	"; echo _gettext("Extra"); echo "	"; echo _gettext("Action"); echo "
env, (($__internal_compile_3 = $context["row"]) && is_array($__internal_compile_3) \|\| $__internal_compile_3 instanceof ArrayAccess ? ($__internal_compile_3["Field"] ?? null) : null), "html", null, true); echo "\" id=\"checkbox_row_"; echo twig_escape_filter($this->env, ($context["rownum"] ?? null), "html", null, true); echo "\">	"; // line 54 echo twig_escape_filter($this->env, ($context["rownum"] ?? null), "html", null, true); echo "	env, ($context["rownum"] ?? null), "html", null, true); echo "\"> "; // line 57 if (twig_get_attribute($this->env, $this->source, twig_get_attribute($this->env, $this->source, ($context["displayed_fields"] ?? null), ($context["rownum"] ?? null), [], "array", false, true, false, 57), "comment", [], "any", true, true, false, 57)) { // line 58 echo " env, twig_get_attribute($this->env, $this->source, (($__internal_compile_4 = ($context["displayed_fields"] ?? null)) && is_array($__internal_compile_4) \|\| $__internal_compile_4 instanceof ArrayAccess ? ($__internal_compile_4[($context["rownum"] ?? null)] ?? null) : null), "comment", [], "any", false, false, false, 58), "html", null, true); echo "\">"; echo twig_escape_filter($this->env, twig_get_attribute($this->env, $this->source, (($__internal_compile_5 = ($context["displayed_fields"] ?? null)) && is_array($__internal_compile_5) \|\| $__internal_compile_5 instanceof ArrayAccess ? ($__internal_compile_5[($context["rownum"] ?? null)] ?? null) : null), "text", [], "any", false, false, false, 58), "html", null, true); echo " "; } else { // line 60 echo " "; echo twig_escape_filter($this->env, twig_get_attribute($this->env, $this->source, (($__internal_compile_6 = ($context["displayed_fields"] ?? null)) && is_array($__internal_compile_6) \|\| $__internal_compile_6 instanceof ArrayAccess ? ($__internal_compile_6[($context["rownum"] ?? null)] ?? null) : null), "text", [], "any", false, false, false, 60), "html", null, true); echo " "; } // line 62 echo " "; echo twig_get_attribute($this->env, $this->source, (($__internal_compile_7 = ($context["displayed_fields"] ?? null)) && is_array($__internal_compile_7) \|\| $__internal_compile_7 instanceof ArrayAccess ? ($__internal_compile_7[($context["rownum"] ?? null)] ?? null) : null), "icon", [], "any", false, false, false, 62); echo "	"; // line 75 if ( !twig_test_empty((($__internal_compile_15 = $context["row"]) && is_array($__internal_compile_15) \|\| $__internal_compile_15 instanceof ArrayAccess ? ($__internal_compile_15["Collation"] ?? null) : null))) { // line 76 echo " env, twig_get_attribute($this->env, $this->source, (($__internal_compile_16 = ($context["collations"] ?? null)) && is_array($__internal_compile_16) \|\| $__internal_compile_16 instanceof ArrayAccess ? ($__internal_compile_16[(($__internal_compile_17 = $context["row"]) && is_array($__internal_compile_17) \|\| $__internal_compile_17 instanceof ArrayAccess ? ($__internal_compile_17["Collation"] ?? null) : null)] ?? null) : null), "description", [], "any", false, false, false, 76), "html", null, true); echo "\">"; echo twig_escape_filter($this->env, twig_get_attribute($this->env, $this->source, (($__internal_compile_18 = ($context["collations"] ?? null)) && is_array($__internal_compile_18) \|\| $__internal_compile_18 instanceof ArrayAccess ? ($__internal_compile_18[(($__internal_compile_19 = $context["row"]) && is_array($__internal_compile_19) \|\| $__internal_compile_19 instanceof ArrayAccess ? ($__internal_compile_19["Collation"] ?? null) : null)] ?? null) : null), "name", [], "any", false, false, false, 76), "html", null, true); echo " "; } // line 78 echo "	"; // line 79 echo twig_escape_filter($this->env, (($__internal_compile_20 = ($context["attributes"] ?? null)) && is_array($__internal_compile_20) \|\| $__internal_compile_20 instanceof ArrayAccess ? ($__internal_compile_20[($context["rownum"] ?? null)] ?? null) : null), "html", null, true); echo "	"; // line 80 echo twig_escape_filter($this->env, ((((($__internal_compile_21 = $context["row"]) && is_array($__internal_compile_21) \|\| $__internal_compile_21 instanceof ArrayAccess ? ($__internal_compile_21["Null"] ?? null) : null) == "YES")) ? (_gettext("Yes")) : (_gettext("No"))), "html", null, true); echo "	"; // line 82 if ( !(null === (($__internal_compile_22 = $context["row"]) && is_array($__internal_compile_22) \|\| $__internal_compile_22 instanceof ArrayAccess ? ($__internal_compile_22["Default"] ?? null) : null))) { // line 83 if (((($__internal_compile_23 = ($context["extracted_columnspec"] ?? null)) && is_array($__internal_compile_23) \|\| $__internal_compile_23 instanceof ArrayAccess ? ($__internal_compile_23["type"] ?? null) : null) == "bit")) { // line 84 echo twig_escape_filter($this->env, PhpMyAdmin\Util::convertBitDefaultValue((($__internal_compile_24 = $context["row"]) && is_array($__internal_compile_24) \|\| $__internal_compile_24 instanceof ArrayAccess ? ($__internal_compile_24["Default"] ?? null) : null)), "html", null, true); } else { // line 86 echo twig_escape_filter($this->env, (($__internal_compile_25 = $context["row"]) && is_array($__internal_compile_25) \|\| $__internal_compile_25 instanceof ArrayAccess ? ($__internal_compile_25["Default"] ?? null) : null), "html", null, true); } } elseif (((($__internal_compile_26 = // line 88 $context["row"]) && is_array($__internal_compile_26) \|\| $__internal_compile_26 instanceof ArrayAccess ? ($__internal_compile_26["Null"] ?? null) : null) == "YES")) { // line 89 echo "NULL"; } else { // line 91 echo ""; echo _pgettext("None for default", "None"); echo ""; } // line 93 echo "	"; // line 96 echo twig_escape_filter($this->env, ($context["comments"] ?? null), "html", null, true); echo "	"; echo twig_escape_filter($this->env, twig_upper_filter($this->env, (($__internal_compile_27 = $context["row"]) && is_array($__internal_compile_27) \|\| $__internal_compile_27 instanceof ArrayAccess ? ($__internal_compile_27["Extra"] ?? null) : null)), "html", null, true); echo "	// line 103 ($context["db"] ?? null), "table" => // line 104 ($context["table"] ?? null), "field" => (($__internal_compile_28 = // line 105 $context["row"]) && is_array($__internal_compile_28) \|\| $__internal_compile_28 instanceof ArrayAccess ? ($__internal_compile_28["Field"] ?? null) : null), "change_column" => 1]); // line 107 echo "\"> "; // line 108 echo PhpMyAdmin\Html\Generator::getIcon("b_edit", _gettext("Change")); echo "	// line 113 ($context["db"] ?? null), "table" => // line 114 ($context["table"] ?? null), "sql_query" => (((("ALTER TABLE " . PhpMyAdmin\Util::backquote( // line 115 ($context["table"] ?? null))) . " DROP ") . PhpMyAdmin\Util::backquote((($__internal_compile_29 = $context["row"]) && is_array($__internal_compile_29) \|\| $__internal_compile_29 instanceof ArrayAccess ? ($__internal_compile_29["Field"] ?? null) : null))) . ";"), "dropped_column" => (($__internal_compile_30 = // line 116 $context["row"]) && is_array($__internal_compile_30) \|\| $__internal_compile_30 instanceof ArrayAccess ? ($__internal_compile_30["Field"] ?? null) : null), "purge" => true, "message_to_show" => twig_sprintf(_gettext("Column %s has been dropped."), twig_escape_filter($this->env, (($__internal_compile_31 = // line 118 $context["row"]) && is_array($__internal_compile_31) \|\| $__internal_compile_31 instanceof ArrayAccess ? ($__internal_compile_31["Field"] ?? null) : null)))], "", false); // line 119 echo "\"> "; // line 120 echo PhpMyAdmin\Html\Generator::getIcon("b_drop", _gettext("Drop")); echo "	"; // line 128 if (($context["hide_structure_actions"] ?? null)) { // line 129 echo " "; } else { // line 133 echo " "; } // line 135 echo " "; // line 136 if (((((($context["type"] ?? null) == "text") \|\| (($context["type"] ?? null) == "blob")) \|\| (($context["tbl_storage_engine"] ?? null) == "ARCHIVE")) \|\| (($context["primary"] ?? null) && twig_get_attribute($this->env, $this->source, ($context["primary"] ?? null), "hasColumn", [0 => ($context["field_name"] ?? null)], "method", false, false, false, 136)))) { // line 137 echo " "; echo PhpMyAdmin\Html\Generator::getIcon("bd_primary", _gettext("Primary")); echo " "; } else { // line 139 echo " // line 140 ($context["db"] ?? null), "table" => // line 141 ($context["table"] ?? null), "sql_query" => ((((("ALTER TABLE " . PhpMyAdmin\Util::backquote( // line 142 ($context["table"] ?? null))) . ((($context["primary"] ?? null)) ? (" DROP PRIMARY KEY,") : (""))) . " ADD PRIMARY KEY(") . PhpMyAdmin\Util::backquote((($__internal_compile_34 = $context["row"]) && is_array($__internal_compile_34) \|\| $__internal_compile_34 instanceof ArrayAccess ? ($__internal_compile_34["Field"] ?? null) : null))) . ");"), "message_to_show" => twig_sprintf(_gettext("A primary key has been added on %s."), twig_escape_filter($this->env, (($__internal_compile_35 = // line 143 $context["row"]) && is_array($__internal_compile_35) \|\| $__internal_compile_35 instanceof ArrayAccess ? ($__internal_compile_35["Field"] ?? null) : null)))], "", false); // line 144 echo "\"> "; // line 145 echo PhpMyAdmin\Html\Generator::getIcon("b_primary", _gettext("Primary")); echo " "; } // line 148 echo " "; // line 151 if (((((($context["type"] ?? null) == "text") \|\| (($context["type"] ?? null) == "blob")) \|\| (($context["tbl_storage_engine"] ?? null) == "ARCHIVE")) \|\| twig_in_filter(($context["field_name"] ?? null), ($context["columns_with_unique_index"] ?? null)))) { // line 152 echo " "; echo PhpMyAdmin\Html\Generator::getIcon("bd_unique", _gettext("Unique")); echo " "; } else { // line 154 echo " // line 155 ($context["db"] ?? null), "table" => // line 156 ($context["table"] ?? null), "sql_query" => (((("ALTER TABLE " . PhpMyAdmin\Util::backquote( // line 157 ($context["table"] ?? null))) . " ADD UNIQUE(") . PhpMyAdmin\Util::backquote((($__internal_compile_36 = $context["row"]) && is_array($__internal_compile_36) \|\| $__internal_compile_36 instanceof ArrayAccess ? ($__internal_compile_36["Field"] ?? null) : null))) . ");"), "message_to_show" => twig_sprintf(_gettext("An index has been added on %s."), twig_escape_filter($this->env, (($__internal_compile_37 = // line 158 $context["row"]) && is_array($__internal_compile_37) \|\| $__internal_compile_37 instanceof ArrayAccess ? ($__internal_compile_37["Field"] ?? null) : null)))], "", false); // line 159 echo "\"> "; // line 160 echo PhpMyAdmin\Html\Generator::getIcon("b_unique", _gettext("Unique")); echo " "; } // line 163 echo " "; // line 166 if ((((($context["type"] ?? null) == "text") \|\| (($context["type"] ?? null) == "blob")) \|\| (($context["tbl_storage_engine"] ?? null) == "ARCHIVE"))) { // line 167 echo " "; echo PhpMyAdmin\Html\Generator::getIcon("bd_index", _gettext("Index")); echo " "; } else { // line 169 echo " // line 170 ($context["db"] ?? null), "table" => // line 171 ($context["table"] ?? null), "sql_query" => (((("ALTER TABLE " . PhpMyAdmin\Util::backquote( // line 172 ($context["table"] ?? null))) . " ADD INDEX(") . PhpMyAdmin\Util::backquote((($__internal_compile_38 = $context["row"]) && is_array($__internal_compile_38) \|\| $__internal_compile_38 instanceof ArrayAccess ? ($__internal_compile_38["Field"] ?? null) : null))) . ");"), "message_to_show" => twig_sprintf(_gettext("An index has been added on %s."), twig_escape_filter($this->env, (($__internal_compile_39 = // line 173 $context["row"]) && is_array($__internal_compile_39) \|\| $__internal_compile_39 instanceof ArrayAccess ? ($__internal_compile_39["Field"] ?? null) : null)))], "", false); // line 174 echo "\"> "; // line 175 echo PhpMyAdmin\Html\Generator::getIcon("b_index", _gettext("Index")); echo " "; } // line 178 echo " "; // line 180 $context["spatial_types"] = [0 => "geometry", 1 => "point", 2 => "linestring", 3 => "polygon", 4 => "multipoint", 5 => "multilinestring", 6 => "multipolygon", 7 => "geomtrycollection"]; // line 190 echo " "; // line 191 if (((((($context["type"] ?? null) == "text") \|\| (($context["type"] ?? null) == "blob")) \|\| (($context["tbl_storage_engine"] ?? null) == "ARCHIVE")) \|\| (!twig_in_filter(($context["type"] ?? null), ($context["spatial_types"] ?? null)) && ((($context["tbl_storage_engine"] ?? null) == "MYISAM") \|\| (($context["mysql_int_version"] ?? null) >= 50705))))) { // line 192 echo " "; echo PhpMyAdmin\Html\Generator::getIcon("bd_spatial", _gettext("Spatial")); echo " "; } else { // line 194 echo " // line 195 ($context["db"] ?? null), "table" => // line 196 ($context["table"] ?? null), "sql_query" => (((("ALTER TABLE " . PhpMyAdmin\Util::backquote( // line 197 ($context["table"] ?? null))) . " ADD SPATIAL(") . PhpMyAdmin\Util::backquote((($__internal_compile_40 = $context["row"]) && is_array($__internal_compile_40) \|\| $__internal_compile_40 instanceof ArrayAccess ? ($__internal_compile_40["Field"] ?? null) : null))) . ");"), "message_to_show" => twig_sprintf(_gettext("An index has been added on %s."), twig_escape_filter($this->env, (($__internal_compile_41 = // line 198 $context["row"]) && is_array($__internal_compile_41) \|\| $__internal_compile_41 instanceof ArrayAccess ? ($__internal_compile_41["Field"] ?? null) : null)))], "", false); // line 199 echo "\"> "; // line 200 echo PhpMyAdmin\Html\Generator::getIcon("b_spatial", _gettext("Spatial")); echo " "; } // line 203 echo " "; // line 206 echo " "; // line 207 if ((( !twig_test_empty(($context["tbl_storage_engine"] ?? null)) && (((( // line 208 ($context["tbl_storage_engine"] ?? null) == "MYISAM") \|\| ( // line 209 ($context["tbl_storage_engine"] ?? null) == "ARIA")) \|\| ( // line 210 ($context["tbl_storage_engine"] ?? null) == "MARIA")) \|\| (( // line 211 ($context["tbl_storage_engine"] ?? null) == "INNODB") && (($context["mysql_int_version"] ?? null) >= 50604)))) && (twig_in_filter("text", // line 212 ($context["type"] ?? null)) \|\| twig_in_filter("char", ($context["type"] ?? null))))) { // line 213 echo " // line 214 ($context["db"] ?? null), "table" => // line 215 ($context["table"] ?? null), "sql_query" => (((("ALTER TABLE " . PhpMyAdmin\Util::backquote( // line 216 ($context["table"] ?? null))) . " ADD FULLTEXT(") . PhpMyAdmin\Util::backquote((($__internal_compile_42 = $context["row"]) && is_array($__internal_compile_42) \|\| $__internal_compile_42 instanceof ArrayAccess ? ($__internal_compile_42["Field"] ?? null) : null))) . ");"), "message_to_show" => twig_sprintf(_gettext("An index has been added on %s."), twig_escape_filter($this->env, (($__internal_compile_43 = // line 217 $context["row"]) && is_array($__internal_compile_43) \|\| $__internal_compile_43 instanceof ArrayAccess ? ($__internal_compile_43["Field"] ?? null) : null)))], "", false); // line 218 echo "\"> "; // line 219 echo PhpMyAdmin\Html\Generator::getIcon("b_ftext", _gettext("Fulltext")); echo " "; } else { // line 222 echo " "; echo PhpMyAdmin\Html\Generator::getIcon("bd_ftext", _gettext("Fulltext")); echo " "; } // line 224 echo " "; // line 227 echo " // line 229 ($context["db"] ?? null), "table" => // line 230 ($context["table"] ?? null), "sql_query" => ((((((((("SELECT COUNT(*) AS " . PhpMyAdmin\Util::backquote(_gettext("Rows"))) . ", ") . PhpMyAdmin\Util::backquote((($__internal_compile_44 = // line 232 $context["row"]) && is_array($__internal_compile_44) \|\| $__internal_compile_44 instanceof ArrayAccess ? ($__internal_compile_44["Field"] ?? null) : null))) . " FROM ") . PhpMyAdmin\Util::backquote( // line 233 ($context["table"] ?? null))) . " GROUP BY ") . PhpMyAdmin\Util::backquote((($__internal_compile_45 = // line 234 $context["row"]) && is_array($__internal_compile_45) \|\| $__internal_compile_45 instanceof ArrayAccess ? ($__internal_compile_45["Field"] ?? null) : null))) . " ORDER BY ") . PhpMyAdmin\Util::backquote((($__internal_compile_46 = // line 235 $context["row"]) && is_array($__internal_compile_46) \|\| $__internal_compile_46 instanceof ArrayAccess ? ($__internal_compile_46["Field"] ?? null) : null))), "is_browse_distinct" => true], "", false); // line 237 echo "\"> "; // line 238 echo PhpMyAdmin\Html\Generator::getIcon("b_browse", _gettext("Distinct values")); echo " "; // line 241 if ( !(null === twig_get_attribute($this->env, $this->source, ($context["relation_parameters"] ?? null), "centralColumnsFeature", [], "any", false, false, false, 241))) { // line 242 echo " "; // line 243 if (twig_in_filter((($__internal_compile_47 = $context["row"]) && is_array($__internal_compile_47) \|\| $__internal_compile_47 instanceof ArrayAccess ? ($__internal_compile_47["Field"] ?? null) : null), ($context["central_list"] ?? null))) { // line 244 echo " // line 245 ($context["db"] ?? null), "table" => // line 246 ($context["table"] ?? null), "selected_fld" => [0 => (($__internal_compile_48 = // line 247 $context["row"]) && is_array($__internal_compile_48) \|\| $__internal_compile_48 instanceof ArrayAccess ? ($__internal_compile_48["Field"] ?? null) : null)]]); // line 248 echo "\"> "; // line 249 echo PhpMyAdmin\Html\Generator::getIcon("centralColumns_delete", _gettext("Remove from central columns")); echo " "; } else { // line 252 echo " // line 253 ($context["db"] ?? null), "table" => // line 254 ($context["table"] ?? null), "selected_fld" => [0 => (($__internal_compile_49 = // line 255 $context["row"]) && is_array($__internal_compile_49) \|\| $__internal_compile_49 instanceof ArrayAccess ? ($__internal_compile_49["Field"] ?? null) : null)]]); // line 256 echo "\"> "; // line 257 echo PhpMyAdmin\Html\Generator::getIcon("centralColumns_add", _gettext("Add to central columns")); echo " "; } // line 260 echo " "; } // line 262 echo " "; if ( !($context["hide_structure_actions"] ?? null)) { // line 263 echo " "; } else { // line 265 echo " "; } // line 268 echo "

"; echo _gettext("Indexes"); // line 463 echo " "; echo PhpMyAdmin\Html\MySQLDocumentation::show("optimizing-database-structure"); echo " "; // line 466 if ( !twig_test_empty(($context["indexes"] ?? null))) { // line 467 echo " "; echo ($context["indexes_duplicates"] ?? null); echo " "; // line 469 echo twig_include($this->env, $context, "modals/preview_sql_confirmation.twig"); echo "

"; // line 488 $context['_parent'] = $context; $context['_seq'] = twig_ensure_traversable(($context["indexes"] ?? null)); foreach ($context['_seq'] as $context["_key"] => $context["index"]) { // line 489 echo " "; $context["columns_count"] = twig_get_attribute($this->env, $this->source, $context["index"], "getColumnCount", [], "method", false, false, false, 489); // line 490 echo " "; // line 535 $context['_parent'] = $context; $context['_seq'] = twig_ensure_traversable(twig_get_attribute($this->env, $this->source, $context["index"], "getColumns", [], "method", false, false, false, 535)); foreach ($context['_seq'] as $context["_key"] => $context["column"]) { // line 536 echo " "; if ((twig_get_attribute($this->env, $this->source, $context["column"], "getSeqInIndex", [], "method", false, false, false, 536) > 1)) { // line 537 echo " "; } // line 539 echo " "; // line 549 if ((twig_get_attribute($this->env, $this->source, $context["column"], "getSeqInIndex", [], "method", false, false, false, 549) == 1)) { // line 550 echo " "; } // line 552 echo " "; } $_parent = $context['_parent']; unset($context['_seq'], $context['_iterated'], $context['_key'], $context['column'], $context['_parent'], $context['loop']); $context = array_intersect_key($context, $_parent) + $_parent; // line 554 echo " "; } $_parent = $context['_parent']; unset($context['_seq'], $context['_iterated'], $context['_key'], $context['index'], $context['_parent'], $context['loop']); $context = array_intersect_key($context, $_parent) + $_parent; // line 555 echo "

"; echo _gettext("Action"); // line 474 echo "	"; echo _gettext("Keyname"); // line 475 echo "	"; echo _gettext("Type"); // line 476 echo "	"; echo _gettext("Unique"); // line 477 echo "	"; echo _gettext("Packed"); // line 478 echo "	"; echo _gettext("Column"); // line 479 echo "	"; echo _gettext("Cardinality"); // line 480 echo "	"; echo _gettext("Collation"); // line 481 echo "	"; echo _gettext("Null"); // line 482 echo "	"; echo _gettext("Comment"); // line 483 echo "
env, ($context["columns_count"] ?? null), "html", null, true); echo "\" class=\"edit_index d-print-none ajax\"> // line 493 ($context["db"] ?? null), "table" => // line 494 ($context["table"] ?? null), "index" => twig_get_attribute($this->env, $this->source, // line 495 $context["index"], "getName", [], "method", false, false, false, 495)], "", false); // line 496 echo "\"> "; // line 497 echo PhpMyAdmin\Html\Generator::getIcon("b_edit", _gettext("Edit")); echo "	env, ($context["columns_count"] ?? null), "html", null, true); echo "\" class=\"rename_index d-print-none ajax\" > // line 502 ($context["db"] ?? null), "table" => // line 503 ($context["table"] ?? null), "index" => twig_get_attribute($this->env, $this->source, // line 504 $context["index"], "getName", [], "method", false, false, false, 504)], "", false); // line 505 echo "\"> "; // line 506 echo PhpMyAdmin\Html\Generator::getIcon("b_rename", _gettext("Rename")); echo "	env, ($context["columns_count"] ?? null), "html", null, true); echo "\" class=\"d-print-none\"> "; // line 510 if ((twig_get_attribute($this->env, $this->source, $context["index"], "getName", [], "method", false, false, false, 510) == "PRIMARY")) { // line 511 echo " "; $context["index_params"] = ["sql_query" => (("ALTER TABLE " . PhpMyAdmin\Util::backquote( // line 512 ($context["table"] ?? null))) . " DROP PRIMARY KEY;"), "message_to_show" => _gettext("The primary key has been dropped.")]; // line 515 echo " "; } else { // line 516 echo " "; $context["index_params"] = ["sql_query" => (((("ALTER TABLE " . PhpMyAdmin\Util::backquote( // line 517 ($context["table"] ?? null))) . " DROP INDEX ") . PhpMyAdmin\Util::backquote(twig_get_attribute($this->env, $this->source, $context["index"], "getName", [], "method", false, false, false, 517))) . ";"), "message_to_show" => twig_sprintf(_gettext("Index %s has been dropped."), twig_get_attribute($this->env, $this->source, // line 518 $context["index"], "getName", [], "method", false, false, false, 518))]; // line 520 echo " "; } // line 521 echo " env, twig_get_attribute($this->env, $this->source, ($context["index_params"] ?? null), "sql_query", [], "any", false, false, false, 522), "html", null, true); echo "\"> "; // line 523 echo PhpMyAdmin\Html\Generator::linkOrButton(PhpMyAdmin\Url::getFromRoute("/sql"), twig_array_merge( // line 525 ($context["index_params"] ?? null), ["db" => ($context["db"] ?? null), "table" => ($context["table"] ?? null)]), PhpMyAdmin\Html\Generator::getIcon("b_drop", _gettext("Drop")), ["class" => "drop_primary_key_index_anchor ajax"]); // line 528 echo "	env, ($context["columns_count"] ?? null), "html", null, true); echo "\">"; echo twig_escape_filter($this->env, twig_get_attribute($this->env, $this->source, $context["index"], "getName", [], "method", false, false, false, 530), "html", null, true); echo "	env, ($context["columns_count"] ?? null), "html", null, true); echo "\">"; echo twig_escape_filter($this->env, ((twig_get_attribute($this->env, $this->source, $context["index"], "getType", [], "method", true, true, false, 531)) ? (_twig_default_filter(twig_get_attribute($this->env, $this->source, $context["index"], "getType", [], "method", false, false, false, 531), twig_get_attribute($this->env, $this->source, $context["index"], "getChoice", [], "method", false, false, false, 531))) : (twig_get_attribute($this->env, $this->source, $context["index"], "getChoice", [], "method", false, false, false, 531))), "html", null, true); echo "	env, ($context["columns_count"] ?? null), "html", null, true); echo "\">"; echo twig_escape_filter($this->env, ((twig_get_attribute($this->env, $this->source, $context["index"], "isUnique", [], "method", false, false, false, 532)) ? (_gettext("Yes")) : (_gettext("No"))), "html", null, true); echo "	env, ($context["columns_count"] ?? null), "html", null, true); echo "\">"; echo twig_get_attribute($this->env, $this->source, $context["index"], "isPacked", [], "method", false, false, false, 533); echo "
"; // line 540 if (twig_get_attribute($this->env, $this->source, $context["column"], "hasExpression", [], "method", false, false, false, 540)) { echo twig_escape_filter($this->env, twig_get_attribute($this->env, $this->source, $context["column"], "getExpression", [], "method", false, false, false, 540), "html", null, true); } else { echo twig_escape_filter($this->env, twig_get_attribute($this->env, $this->source, $context["column"], "getName", [], "method", false, false, false, 540), "html", null, true); } // line 541 echo " "; if ( !twig_test_empty(twig_get_attribute($this->env, $this->source, $context["column"], "getSubPart", [], "method", false, false, false, 541))) { // line 542 echo " ("; echo twig_escape_filter($this->env, twig_get_attribute($this->env, $this->source, $context["column"], "getSubPart", [], "method", false, false, false, 542), "html", null, true); echo ") "; } // line 544 echo "	"; // line 545 echo twig_escape_filter($this->env, twig_get_attribute($this->env, $this->source, $context["column"], "getCardinality", [], "method", false, false, false, 545), "html", null, true); echo "	"; // line 546 echo twig_escape_filter($this->env, twig_get_attribute($this->env, $this->source, $context["column"], "getCollation", [], "method", false, false, false, 546), "html", null, true); echo "	"; // line 547 echo twig_escape_filter($this->env, twig_get_attribute($this->env, $this->source, $context["column"], "getNull", [0 => true], "method", false, false, false, 547), "html", null, true); echo "	env, ($context["columns_count"] ?? null), "html", null, true); echo "\">"; echo twig_escape_filter($this->env, twig_get_attribute($this->env, $this->source, $context["index"], "getComments", [], "method", false, false, false, 550), "html", null, true); echo "

"; } else { // line 559 echo "

"; echo $this->env->getFilter('notice')->getCallable()(_gettext("No index defined!")); echo "

"; } // line 561 echo "

"; } // line 602 echo " "; // line 603 $this->loadTemplate("table/structure/display_partitions.twig", "table/structure/display_structure.twig", 603)->display(twig_to_array(["db" => // line 604 ($context["db"] ?? null), "table" => // line 605 ($context["table"] ?? null), "partitions" => // line 606 ($context["partitions"] ?? null), "partition_method" => twig_get_attribute($this->env, $this->source, // line 607 ($context["first_partition"] ?? null), "getMethod", [], "method", false, false, false, 607), "partition_expression" => twig_get_attribute($this->env, $this->source, // line 608 ($context["first_partition"] ?? null), "getExpression", [], "method", false, false, false, 608), "has_description" => !twig_test_empty(twig_get_attribute($this->env, $this->source, // line 609 ($context["first_partition"] ?? null), "getDescription", [], "method", false, false, false, 609)), "has_sub_partitions" => // line 610 ($context["has_sub_partitions"] ?? null), "sub_partition_method" => (( // line 611 ($context["has_sub_partitions"] ?? null)) ? (twig_get_attribute($this->env, $this->source, ($context["first_sub_partition"] ?? null), "getMethod", [], "method", false, false, false, 611)) : ("")), "sub_partition_expression" => (( // line 612 ($context["has_sub_partitions"] ?? null)) ? (twig_get_attribute($this->env, $this->source, ($context["first_sub_partition"] ?? null), "getExpression", [], "method", false, false, false, 612)) : ("")), "range_or_list" => // line 613 ($context["range_or_list"] ?? null)])); // line 615 echo " "; } else { // line 616 echo " "; $this->loadTemplate("table/structure/display_partitions.twig", "table/structure/display_structure.twig", 616)->display(twig_to_array(["db" => // line 617 ($context["db"] ?? null), "table" => // line 618 ($context["table"] ?? null)])); // line 620 echo " "; } // line 621 echo " "; if ((($context["default_sliders_state"] ?? null) != "disabled")) { // line 622 echo "

"; echo twig_escape_filter($this->env, ($context["table"] ?? null), "html", null, true); echo "

"; echo _gettext("Move columns"); // line 328 echo "

"; echo _gettext("Preview SQL"); // line 354 echo "

"; echo _gettext("Error"); // line 372 echo "