"; // line 18 echo " "; // line 28 if (($context["show_column_comments"] ?? null)) { // line 29 echo ""; } // line 31 echo " "; // line 33 echo " "; if (( !($context["db_is_system_schema"] ?? null) && !($context["tbl_is_view"] ?? null))) { // line 34 echo " "; } // line 37 echo " "; // line 41 echo " "; $context["rownum"] = 0; // line 42 echo " "; $context['_parent'] = $context; $context['_seq'] = twig_ensure_traversable(($context["fields"] ?? null)); foreach ($context['_seq'] as $context["_key"] => $context["row"]) { // line 43 echo " "; $context["rownum"] = (($context["rownum"] ?? null) + 1); // line 44 echo " "; // line 45 $context["extracted_columnspec"] = (($__internal_f607aeef2c31a95a7bf963452dff024ffaeb6aafbe4603f9ca3bec57be8633f4 = ($context["extracted_columnspecs"] ?? null)) && is_array($__internal_f607aeef2c31a95a7bf963452dff024ffaeb6aafbe4603f9ca3bec57be8633f4) || $__internal_f607aeef2c31a95a7bf963452dff024ffaeb6aafbe4603f9ca3bec57be8633f4 instanceof ArrayAccess ? ($__internal_f607aeef2c31a95a7bf963452dff024ffaeb6aafbe4603f9ca3bec57be8633f4[($context["rownum"] ?? null)] ?? null) : null); // line 46 echo " "; $context["field_name"] = twig_escape_filter($this->env, (($__internal_62824350bc4502ee19dbc2e99fc6bdd3bd90e7d8dd6e72f42c35efd048542144 = $context["row"]) && is_array($__internal_62824350bc4502ee19dbc2e99fc6bdd3bd90e7d8dd6e72f42c35efd048542144) || $__internal_62824350bc4502ee19dbc2e99fc6bdd3bd90e7d8dd6e72f42c35efd048542144 instanceof ArrayAccess ? ($__internal_62824350bc4502ee19dbc2e99fc6bdd3bd90e7d8dd6e72f42c35efd048542144["Field"] ?? null) : null)); // line 47 echo " "; // line 48 echo " "; $context["comments"] = (($__internal_1cfccaec8dd2e8578ccb026fbe7f2e7e29ac2ed5deb976639c5fc99a6ea8583b = ($context["row_comments"] ?? null)) && is_array($__internal_1cfccaec8dd2e8578ccb026fbe7f2e7e29ac2ed5deb976639c5fc99a6ea8583b) || $__internal_1cfccaec8dd2e8578ccb026fbe7f2e7e29ac2ed5deb976639c5fc99a6ea8583b instanceof ArrayAccess ? ($__internal_1cfccaec8dd2e8578ccb026fbe7f2e7e29ac2ed5deb976639c5fc99a6ea8583b[($context["rownum"] ?? null)] ?? null) : null); // line 49 echo " "; // line 50 echo " "; // line 68 echo (($__internal_d527c24a729d38501d770b40a0d25e1ce8a7f0bff897cc4f8f449ba71fcff3d9 = ($context["extracted_columnspec"] ?? null)) && is_array($__internal_d527c24a729d38501d770b40a0d25e1ce8a7f0bff897cc4f8f449ba71fcff3d9) || $__internal_d527c24a729d38501d770b40a0d25e1ce8a7f0bff897cc4f8f449ba71fcff3d9 instanceof ArrayAccess ? ($__internal_d527c24a729d38501d770b40a0d25e1ce8a7f0bff897cc4f8f449ba71fcff3d9["displayed_type"] ?? null) : null); echo " "; // line 69 if ((((($context["relation_commwork"] ?? null) && ($context["relation_mimework"] ?? null)) && ($context["browse_mime"] ?? null)) && twig_get_attribute($this->env, $this->source, twig_get_attribute($this->env, $this->source, // line 70 ($context["mime_map"] ?? null), (($__internal_f6dde3a1020453fdf35e718e94f93ce8eb8803b28cc77a665308e14bbe8572ae = $context["row"]) && is_array($__internal_f6dde3a1020453fdf35e718e94f93ce8eb8803b28cc77a665308e14bbe8572ae) || $__internal_f6dde3a1020453fdf35e718e94f93ce8eb8803b28cc77a665308e14bbe8572ae instanceof ArrayAccess ? ($__internal_f6dde3a1020453fdf35e718e94f93ce8eb8803b28cc77a665308e14bbe8572ae["Field"] ?? null) : null), [], "array", false, true, false, 70), "mimetype", [], "array", true, true, false, 70))) { // line 71 echo "
"; echo _gettext("Media type:"); echo " "; echo twig_escape_filter($this->env, twig_lower_filter($this->env, twig_replace_filter((($__internal_25c0fab8152b8dd6b90603159c0f2e8a936a09ab76edb5e4d7bc95d9a8d2dc8f = (($__internal_f769f712f3484f00110c86425acea59f5af2752239e2e8596bcb6effeb425b40 = ($context["mime_map"] ?? null)) && is_array($__internal_f769f712f3484f00110c86425acea59f5af2752239e2e8596bcb6effeb425b40) || $__internal_f769f712f3484f00110c86425acea59f5af2752239e2e8596bcb6effeb425b40 instanceof ArrayAccess ? ($__internal_f769f712f3484f00110c86425acea59f5af2752239e2e8596bcb6effeb425b40[(($__internal_98e944456c0f58b2585e4aa36e3a7e43f4b7c9038088f0f056004af41f4a007f = $context["row"]) && is_array($__internal_98e944456c0f58b2585e4aa36e3a7e43f4b7c9038088f0f056004af41f4a007f) || $__internal_98e944456c0f58b2585e4aa36e3a7e43f4b7c9038088f0f056004af41f4a007f instanceof ArrayAccess ? ($__internal_98e944456c0f58b2585e4aa36e3a7e43f4b7c9038088f0f056004af41f4a007f["Field"] ?? null) : null)] ?? null) : null)) && is_array($__internal_25c0fab8152b8dd6b90603159c0f2e8a936a09ab76edb5e4d7bc95d9a8d2dc8f) || $__internal_25c0fab8152b8dd6b90603159c0f2e8a936a09ab76edb5e4d7bc95d9a8d2dc8f instanceof ArrayAccess ? ($__internal_25c0fab8152b8dd6b90603159c0f2e8a936a09ab76edb5e4d7bc95d9a8d2dc8f["mimetype"] ?? null) : null), ["_" => "/"])), "html", null, true); echo " "; } // line 73 echo " "; // line 95 if (($context["show_column_comments"] ?? null)) { // line 96 echo " "; } // line 100 echo " "; // line 101 if (( !($context["tbl_is_view"] ?? null) && !($context["db_is_system_schema"] ?? null))) { // line 102 echo " "; } // line 125 echo " "; // line 126 if (( !($context["tbl_is_view"] ?? null) && !($context["db_is_system_schema"] ?? null))) { // line 127 echo " "; $context["type"] = (( !twig_test_empty((($__internal_0a23ad2f11a348e49c87410947e20d5a4e711234ce49927662da5dddac687855 = ($context["extracted_columnspec"] ?? null)) && is_array($__internal_0a23ad2f11a348e49c87410947e20d5a4e711234ce49927662da5dddac687855) || $__internal_0a23ad2f11a348e49c87410947e20d5a4e711234ce49927662da5dddac687855 instanceof ArrayAccess ? ($__internal_0a23ad2f11a348e49c87410947e20d5a4e711234ce49927662da5dddac687855["print_type"] ?? null) : null))) ? ((($__internal_0228c5445a74540c89ea8a758478d405796357800f8af831a7f7e1e2c0159d9b = ($context["extracted_columnspec"] ?? null)) && is_array($__internal_0228c5445a74540c89ea8a758478d405796357800f8af831a7f7e1e2c0159d9b) || $__internal_0228c5445a74540c89ea8a758478d405796357800f8af831a7f7e1e2c0159d9b instanceof ArrayAccess ? ($__internal_0228c5445a74540c89ea8a758478d405796357800f8af831a7f7e1e2c0159d9b["print_type"] ?? null) : null)) : ("")); // line 128 echo " "; } // line 262 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 264 echo "

	#	"; // line 22 echo _gettext("Name"); echo "	"; // line 23 echo _gettext("Type"); echo "	"; // line 24 echo _gettext("Collation"); echo "	"; // line 25 echo _gettext("Attributes"); echo "	"; // line 26 echo _gettext("Null"); echo "	"; // line 27 echo _gettext("Default"); echo "	"; echo _gettext("Comments"); echo "	"; echo _gettext("Extra"); echo "	"; echo _gettext("Action"); echo "
env, (($__internal_68aa442c1d43d3410ea8f958ba9090f3eaa9a76f8de8fc9be4d6c7389ba28002 = $context["row"]) && is_array($__internal_68aa442c1d43d3410ea8f958ba9090f3eaa9a76f8de8fc9be4d6c7389ba28002) \|\| $__internal_68aa442c1d43d3410ea8f958ba9090f3eaa9a76f8de8fc9be4d6c7389ba28002 instanceof ArrayAccess ? ($__internal_68aa442c1d43d3410ea8f958ba9090f3eaa9a76f8de8fc9be4d6c7389ba28002["Field"] ?? null) : null), "html", null, true); echo "\" id=\"checkbox_row_"; echo twig_escape_filter($this->env, ($context["rownum"] ?? null), "html", null, true); echo "\">	"; // line 55 echo twig_escape_filter($this->env, ($context["rownum"] ?? null), "html", null, true); echo "	env, ($context["rownum"] ?? null), "html", null, true); echo "\"> "; // line 58 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, 58), "comment", [], "any", true, true, false, 58)) { // line 59 echo " env, twig_get_attribute($this->env, $this->source, (($__internal_d7fc55f1a54b629533d60b43063289db62e68921ee7a5f8de562bd9d4a2b7ad4 = ($context["displayed_fields"] ?? null)) && is_array($__internal_d7fc55f1a54b629533d60b43063289db62e68921ee7a5f8de562bd9d4a2b7ad4) \|\| $__internal_d7fc55f1a54b629533d60b43063289db62e68921ee7a5f8de562bd9d4a2b7ad4 instanceof ArrayAccess ? ($__internal_d7fc55f1a54b629533d60b43063289db62e68921ee7a5f8de562bd9d4a2b7ad4[($context["rownum"] ?? null)] ?? null) : null), "comment", [], "any", false, false, false, 59), "html", null, true); echo "\">"; echo twig_escape_filter($this->env, twig_get_attribute($this->env, $this->source, (($__internal_01476f8db28655ee4ee02ea2d17dd5a92599be76304f08cd8bc0e05aced30666 = ($context["displayed_fields"] ?? null)) && is_array($__internal_01476f8db28655ee4ee02ea2d17dd5a92599be76304f08cd8bc0e05aced30666) \|\| $__internal_01476f8db28655ee4ee02ea2d17dd5a92599be76304f08cd8bc0e05aced30666 instanceof ArrayAccess ? ($__internal_01476f8db28655ee4ee02ea2d17dd5a92599be76304f08cd8bc0e05aced30666[($context["rownum"] ?? null)] ?? null) : null), "text", [], "any", false, false, false, 59), "html", null, true); echo " "; } else { // line 61 echo " "; echo twig_escape_filter($this->env, twig_get_attribute($this->env, $this->source, (($__internal_01c35b74bd85735098add188b3f8372ba465b232ab8298cb582c60f493d3c22e = ($context["displayed_fields"] ?? null)) && is_array($__internal_01c35b74bd85735098add188b3f8372ba465b232ab8298cb582c60f493d3c22e) \|\| $__internal_01c35b74bd85735098add188b3f8372ba465b232ab8298cb582c60f493d3c22e instanceof ArrayAccess ? ($__internal_01c35b74bd85735098add188b3f8372ba465b232ab8298cb582c60f493d3c22e[($context["rownum"] ?? null)] ?? null) : null), "text", [], "any", false, false, false, 61), "html", null, true); echo " "; } // line 63 echo " "; echo twig_get_attribute($this->env, $this->source, (($__internal_63ad1f9a2bf4db4af64b010785e9665558fdcac0e8db8b5b413ed986c62dbb52 = ($context["displayed_fields"] ?? null)) && is_array($__internal_63ad1f9a2bf4db4af64b010785e9665558fdcac0e8db8b5b413ed986c62dbb52) \|\| $__internal_63ad1f9a2bf4db4af64b010785e9665558fdcac0e8db8b5b413ed986c62dbb52 instanceof ArrayAccess ? ($__internal_63ad1f9a2bf4db4af64b010785e9665558fdcac0e8db8b5b413ed986c62dbb52[($context["rownum"] ?? null)] ?? null) : null), "icon", [], "any", false, false, false, 63); echo "	"; // line 76 if ( !twig_test_empty((($__internal_a06a70691a7ca361709a372174fa669f5ee1c1e4ed302b3a5b61c10c80c02760 = $context["row"]) && is_array($__internal_a06a70691a7ca361709a372174fa669f5ee1c1e4ed302b3a5b61c10c80c02760) \|\| $__internal_a06a70691a7ca361709a372174fa669f5ee1c1e4ed302b3a5b61c10c80c02760 instanceof ArrayAccess ? ($__internal_a06a70691a7ca361709a372174fa669f5ee1c1e4ed302b3a5b61c10c80c02760["Collation"] ?? null) : null))) { // line 77 echo " env, twig_get_attribute($this->env, $this->source, (($__internal_653499042eb14fd8415489ba6fa87c1e85cff03392e9f57b26d0da09b9be82ce = ($context["collations"] ?? null)) && is_array($__internal_653499042eb14fd8415489ba6fa87c1e85cff03392e9f57b26d0da09b9be82ce) \|\| $__internal_653499042eb14fd8415489ba6fa87c1e85cff03392e9f57b26d0da09b9be82ce instanceof ArrayAccess ? ($__internal_653499042eb14fd8415489ba6fa87c1e85cff03392e9f57b26d0da09b9be82ce[(($__internal_ba9f0a3bb95c082f61c9fbf892a05514d732703d52edc77b51f2e6284135900b = $context["row"]) && is_array($__internal_ba9f0a3bb95c082f61c9fbf892a05514d732703d52edc77b51f2e6284135900b) \|\| $__internal_ba9f0a3bb95c082f61c9fbf892a05514d732703d52edc77b51f2e6284135900b instanceof ArrayAccess ? ($__internal_ba9f0a3bb95c082f61c9fbf892a05514d732703d52edc77b51f2e6284135900b["Collation"] ?? null) : null)] ?? null) : null), "description", [], "any", false, false, false, 77), "html", null, true); echo "\">"; echo twig_escape_filter($this->env, twig_get_attribute($this->env, $this->source, (($__internal_73db8eef4d2582468dab79a6b09c77ce3b48675a610afd65a1f325b68804a60c = ($context["collations"] ?? null)) && is_array($__internal_73db8eef4d2582468dab79a6b09c77ce3b48675a610afd65a1f325b68804a60c) \|\| $__internal_73db8eef4d2582468dab79a6b09c77ce3b48675a610afd65a1f325b68804a60c instanceof ArrayAccess ? ($__internal_73db8eef4d2582468dab79a6b09c77ce3b48675a610afd65a1f325b68804a60c[(($__internal_d8ad5934f1874c52fa2ac9a4dfae52038b39b8b03cfc82eeb53de6151d883972 = $context["row"]) && is_array($__internal_d8ad5934f1874c52fa2ac9a4dfae52038b39b8b03cfc82eeb53de6151d883972) \|\| $__internal_d8ad5934f1874c52fa2ac9a4dfae52038b39b8b03cfc82eeb53de6151d883972 instanceof ArrayAccess ? ($__internal_d8ad5934f1874c52fa2ac9a4dfae52038b39b8b03cfc82eeb53de6151d883972["Collation"] ?? null) : null)] ?? null) : null), "name", [], "any", false, false, false, 77), "html", null, true); echo " "; } // line 79 echo "	"; // line 80 echo twig_escape_filter($this->env, (($__internal_df39c71428eaf37baa1ea2198679e0077f3699bdd31bb5ba10d084710b9da216 = ($context["attributes"] ?? null)) && is_array($__internal_df39c71428eaf37baa1ea2198679e0077f3699bdd31bb5ba10d084710b9da216) \|\| $__internal_df39c71428eaf37baa1ea2198679e0077f3699bdd31bb5ba10d084710b9da216 instanceof ArrayAccess ? ($__internal_df39c71428eaf37baa1ea2198679e0077f3699bdd31bb5ba10d084710b9da216[($context["rownum"] ?? null)] ?? null) : null), "html", null, true); echo "	"; // line 81 echo twig_escape_filter($this->env, ((((($__internal_bf0e189d688dc2ad611b50a437a32d3692fb6b8be90d2228617cfa6db44e75c0 = $context["row"]) && is_array($__internal_bf0e189d688dc2ad611b50a437a32d3692fb6b8be90d2228617cfa6db44e75c0) \|\| $__internal_bf0e189d688dc2ad611b50a437a32d3692fb6b8be90d2228617cfa6db44e75c0 instanceof ArrayAccess ? ($__internal_bf0e189d688dc2ad611b50a437a32d3692fb6b8be90d2228617cfa6db44e75c0["Null"] ?? null) : null) == "YES")) ? (_gettext("Yes")) : (_gettext("No"))), "html", null, true); echo "	"; // line 83 if ( !(null === (($__internal_674c0abf302105af78b0a38907d86c5dd0028bdc3ee5f24bf52771a16487760c = $context["row"]) && is_array($__internal_674c0abf302105af78b0a38907d86c5dd0028bdc3ee5f24bf52771a16487760c) \|\| $__internal_674c0abf302105af78b0a38907d86c5dd0028bdc3ee5f24bf52771a16487760c instanceof ArrayAccess ? ($__internal_674c0abf302105af78b0a38907d86c5dd0028bdc3ee5f24bf52771a16487760c["Default"] ?? null) : null))) { // line 84 echo " "; if (((($__internal_dd839fbfcab68823c49af471c7df7659a500fe72e71b58d6b80d896bdb55e75f = ($context["extracted_columnspec"] ?? null)) && is_array($__internal_dd839fbfcab68823c49af471c7df7659a500fe72e71b58d6b80d896bdb55e75f) \|\| $__internal_dd839fbfcab68823c49af471c7df7659a500fe72e71b58d6b80d896bdb55e75f instanceof ArrayAccess ? ($__internal_dd839fbfcab68823c49af471c7df7659a500fe72e71b58d6b80d896bdb55e75f["type"] ?? null) : null) == "bit")) { // line 85 echo " "; echo twig_escape_filter($this->env, PhpMyAdmin\Util::convertBitDefaultValue((($__internal_a7ed47878554bdc32b70e1ba5ccc67d2302196876fbf62b4c853b20cb9e029fc = $context["row"]) && is_array($__internal_a7ed47878554bdc32b70e1ba5ccc67d2302196876fbf62b4c853b20cb9e029fc) \|\| $__internal_a7ed47878554bdc32b70e1ba5ccc67d2302196876fbf62b4c853b20cb9e029fc instanceof ArrayAccess ? ($__internal_a7ed47878554bdc32b70e1ba5ccc67d2302196876fbf62b4c853b20cb9e029fc["Default"] ?? null) : null)), "html", null, true); echo " "; } else { // line 87 echo " "; echo twig_escape_filter($this->env, (($__internal_e5d7b41e16b744b68da1e9bb49047b8028ced86c782900009b4b4029b83d4b55 = $context["row"]) && is_array($__internal_e5d7b41e16b744b68da1e9bb49047b8028ced86c782900009b4b4029b83d4b55) \|\| $__internal_e5d7b41e16b744b68da1e9bb49047b8028ced86c782900009b4b4029b83d4b55 instanceof ArrayAccess ? ($__internal_e5d7b41e16b744b68da1e9bb49047b8028ced86c782900009b4b4029b83d4b55["Default"] ?? null) : null), "html", null, true); echo " "; } // line 89 echo " "; } elseif (((($__internal_9e93f398968fa0576dce82fd00f280e95c734ad3f84e7816ff09158ae224f5ba = $context["row"]) && is_array($__internal_9e93f398968fa0576dce82fd00f280e95c734ad3f84e7816ff09158ae224f5ba) \|\| $__internal_9e93f398968fa0576dce82fd00f280e95c734ad3f84e7816ff09158ae224f5ba instanceof ArrayAccess ? ($__internal_9e93f398968fa0576dce82fd00f280e95c734ad3f84e7816ff09158ae224f5ba["Null"] ?? null) : null) == "YES")) { // line 90 echo " NULL "; } else { // line 92 echo " "; echo _pgettext( "None for default", "None"); echo " "; } // line 94 echo "	"; // line 97 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_0795e3de58b6454b051261c0c2b5be48852e17f25b59d4aeef29fb07c614bd78 = $context["row"]) && is_array($__internal_0795e3de58b6454b051261c0c2b5be48852e17f25b59d4aeef29fb07c614bd78) \|\| $__internal_0795e3de58b6454b051261c0c2b5be48852e17f25b59d4aeef29fb07c614bd78 instanceof ArrayAccess ? ($__internal_0795e3de58b6454b051261c0c2b5be48852e17f25b59d4aeef29fb07c614bd78["Extra"] ?? null) : null)), "html", null, true); echo "	// line 104 ($context["db"] ?? null), "table" => // line 105 ($context["table"] ?? null), "field" => (($__internal_fecb0565c93d0b979a95c352ff76e401e0ae0c73bb8d3b443c8c6133e1c190de = // line 106 $context["row"]) && is_array($__internal_fecb0565c93d0b979a95c352ff76e401e0ae0c73bb8d3b443c8c6133e1c190de) \|\| $__internal_fecb0565c93d0b979a95c352ff76e401e0ae0c73bb8d3b443c8c6133e1c190de instanceof ArrayAccess ? ($__internal_fecb0565c93d0b979a95c352ff76e401e0ae0c73bb8d3b443c8c6133e1c190de["Field"] ?? null) : null), "change_column" => 1]); // line 108 echo "\"> "; // line 109 echo \PhpMyAdmin\Html\Generator::getIcon("b_edit", _gettext("Change")); echo "	// line 114 ($context["db"] ?? null), "table" => // line 115 ($context["table"] ?? null), "sql_query" => (((("ALTER TABLE " . PhpMyAdmin\Util::backquote( // line 116 ($context["table"] ?? null))) . " DROP ") . PhpMyAdmin\Util::backquote((($__internal_87570a635eac7f6e150744bd218085d17aff15d92d9c80a66d3b911e3355b828 = $context["row"]) && is_array($__internal_87570a635eac7f6e150744bd218085d17aff15d92d9c80a66d3b911e3355b828) \|\| $__internal_87570a635eac7f6e150744bd218085d17aff15d92d9c80a66d3b911e3355b828 instanceof ArrayAccess ? ($__internal_87570a635eac7f6e150744bd218085d17aff15d92d9c80a66d3b911e3355b828["Field"] ?? null) : null))) . ";"), "dropped_column" => (($__internal_17b5b5f9aaeec4b528bfeed02b71f624021d6a52d927f441de2f2204d0e527cd = // line 117 $context["row"]) && is_array($__internal_17b5b5f9aaeec4b528bfeed02b71f624021d6a52d927f441de2f2204d0e527cd) \|\| $__internal_17b5b5f9aaeec4b528bfeed02b71f624021d6a52d927f441de2f2204d0e527cd instanceof ArrayAccess ? ($__internal_17b5b5f9aaeec4b528bfeed02b71f624021d6a52d927f441de2f2204d0e527cd["Field"] ?? null) : null), "purge" => true, "message_to_show" => sprintf(_gettext("Column %s has been dropped."), twig_escape_filter($this->env, (($__internal_0db9a23306660395861a0528381e0668025e56a8a99f399e9ec23a4b392422d6 = // line 119 $context["row"]) && is_array($__internal_0db9a23306660395861a0528381e0668025e56a8a99f399e9ec23a4b392422d6) \|\| $__internal_0db9a23306660395861a0528381e0668025e56a8a99f399e9ec23a4b392422d6 instanceof ArrayAccess ? ($__internal_0db9a23306660395861a0528381e0668025e56a8a99f399e9ec23a4b392422d6["Field"] ?? null) : null)))]); // line 120 echo "\"> "; // line 121 echo \PhpMyAdmin\Html\Generator::getIcon("b_drop", _gettext("Drop")); echo "	"; // line 130 if (($context["hide_structure_actions"] ?? null)) { // line 131 echo " "; // line 132 echo \PhpMyAdmin\Html\Generator::getIcon("b_more", _gettext("More")); echo " "; } // line 135 echo " "; // line 137 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, 137)))) { // line 138 echo " "; echo \PhpMyAdmin\Html\Generator::getIcon("bd_primary", _gettext("Primary")); echo " "; } else { // line 140 echo " // line 141 ($context["db"] ?? null), "table" => // line 142 ($context["table"] ?? null), "sql_query" => ((((("ALTER TABLE " . PhpMyAdmin\Util::backquote( // line 143 ($context["table"] ?? null))) . ((($context["primary"] ?? null)) ? (" DROP PRIMARY KEY,") : (""))) . " ADD PRIMARY KEY(") . PhpMyAdmin\Util::backquote((($__internal_6fb04c4457ec9ffa7dd6fd2300542be8b961b6e5f7858a80a282f47b43ddae5f = $context["row"]) && is_array($__internal_6fb04c4457ec9ffa7dd6fd2300542be8b961b6e5f7858a80a282f47b43ddae5f) \|\| $__internal_6fb04c4457ec9ffa7dd6fd2300542be8b961b6e5f7858a80a282f47b43ddae5f instanceof ArrayAccess ? ($__internal_6fb04c4457ec9ffa7dd6fd2300542be8b961b6e5f7858a80a282f47b43ddae5f["Field"] ?? null) : null))) . ");"), "message_to_show" => sprintf(_gettext("A primary key has been added on %s."), twig_escape_filter($this->env, (($__internal_417a1a95b289c75779f33186a6dc0b71d01f257b68beae7dcb9d2d769acca0e0 = // line 144 $context["row"]) && is_array($__internal_417a1a95b289c75779f33186a6dc0b71d01f257b68beae7dcb9d2d769acca0e0) \|\| $__internal_417a1a95b289c75779f33186a6dc0b71d01f257b68beae7dcb9d2d769acca0e0 instanceof ArrayAccess ? ($__internal_417a1a95b289c75779f33186a6dc0b71d01f257b68beae7dcb9d2d769acca0e0["Field"] ?? null) : null)))]); // line 145 echo "\"> "; // line 146 echo \PhpMyAdmin\Html\Generator::getIcon("b_primary", _gettext("Primary")); echo " "; } // line 149 echo " "; // line 152 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 153 echo " "; echo \PhpMyAdmin\Html\Generator::getIcon("bd_unique", _gettext("Unique")); echo " "; } else { // line 155 echo " // line 156 ($context["db"] ?? null), "table" => // line 157 ($context["table"] ?? null), "sql_query" => (((("ALTER TABLE " . PhpMyAdmin\Util::backquote( // line 158 ($context["table"] ?? null))) . " ADD UNIQUE(") . PhpMyAdmin\Util::backquote((($__internal_af3439635eb343262861f05093b3dcce5d4dae1e20a47bc25a2eef28135b0d55 = $context["row"]) && is_array($__internal_af3439635eb343262861f05093b3dcce5d4dae1e20a47bc25a2eef28135b0d55) \|\| $__internal_af3439635eb343262861f05093b3dcce5d4dae1e20a47bc25a2eef28135b0d55 instanceof ArrayAccess ? ($__internal_af3439635eb343262861f05093b3dcce5d4dae1e20a47bc25a2eef28135b0d55["Field"] ?? null) : null))) . ");"), "message_to_show" => sprintf(_gettext("An index has been added on %s."), twig_escape_filter($this->env, (($__internal_b16f7904bcaaa7a87404cbf85addc7a8645dff94eef4e8ae7182b86e3638e76a = // line 159 $context["row"]) && is_array($__internal_b16f7904bcaaa7a87404cbf85addc7a8645dff94eef4e8ae7182b86e3638e76a) \|\| $__internal_b16f7904bcaaa7a87404cbf85addc7a8645dff94eef4e8ae7182b86e3638e76a instanceof ArrayAccess ? ($__internal_b16f7904bcaaa7a87404cbf85addc7a8645dff94eef4e8ae7182b86e3638e76a["Field"] ?? null) : null)))]); // line 160 echo "\"> "; // line 161 echo \PhpMyAdmin\Html\Generator::getIcon("b_unique", _gettext("Unique")); echo " "; } // line 164 echo " "; // line 167 if ((((($context["type"] ?? null) == "text") \|\| (($context["type"] ?? null) == "blob")) \|\| (($context["tbl_storage_engine"] ?? null) == "ARCHIVE"))) { // line 168 echo " "; echo \PhpMyAdmin\Html\Generator::getIcon("bd_index", _gettext("Index")); echo " "; } else { // line 170 echo " // line 171 ($context["db"] ?? null), "table" => // line 172 ($context["table"] ?? null), "sql_query" => (((("ALTER TABLE " . PhpMyAdmin\Util::backquote( // line 173 ($context["table"] ?? null))) . " ADD INDEX(") . PhpMyAdmin\Util::backquote((($__internal_462377748602ccf3a44a10ced4240983cec8df1ad86ab53e582fcddddb98fc88 = $context["row"]) && is_array($__internal_462377748602ccf3a44a10ced4240983cec8df1ad86ab53e582fcddddb98fc88) \|\| $__internal_462377748602ccf3a44a10ced4240983cec8df1ad86ab53e582fcddddb98fc88 instanceof ArrayAccess ? ($__internal_462377748602ccf3a44a10ced4240983cec8df1ad86ab53e582fcddddb98fc88["Field"] ?? null) : null))) . ");"), "message_to_show" => sprintf(_gettext("An index has been added on %s."), twig_escape_filter($this->env, (($__internal_be1db6a1ea9fa5c04c40f99df0ec5af053ca391863fc6256c5c4ee249724f758 = // line 174 $context["row"]) && is_array($__internal_be1db6a1ea9fa5c04c40f99df0ec5af053ca391863fc6256c5c4ee249724f758) \|\| $__internal_be1db6a1ea9fa5c04c40f99df0ec5af053ca391863fc6256c5c4ee249724f758 instanceof ArrayAccess ? ($__internal_be1db6a1ea9fa5c04c40f99df0ec5af053ca391863fc6256c5c4ee249724f758["Field"] ?? null) : null)))]); // line 175 echo "\"> "; // line 176 echo \PhpMyAdmin\Html\Generator::getIcon("b_index", _gettext("Index")); echo " "; } // line 179 echo " "; // line 181 $context["spatial_types"] = [0 => "geometry", 1 => "point", 2 => "linestring", 3 => "polygon", 4 => "multipoint", 5 => "multilinestring", 6 => "multipolygon", 7 => "geomtrycollection"]; // line 191 echo " "; // line 192 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 193 echo " "; echo \PhpMyAdmin\Html\Generator::getIcon("bd_spatial", _gettext("Spatial")); echo " "; } else { // line 195 echo " // line 196 ($context["db"] ?? null), "table" => // line 197 ($context["table"] ?? null), "sql_query" => (((("ALTER TABLE " . PhpMyAdmin\Util::backquote( // line 198 ($context["table"] ?? null))) . " ADD SPATIAL(") . PhpMyAdmin\Util::backquote((($__internal_6e6eda1691934a8f5855a3221f5a9f036391304a5cda73a3a2009f2961a84c35 = $context["row"]) && is_array($__internal_6e6eda1691934a8f5855a3221f5a9f036391304a5cda73a3a2009f2961a84c35) \|\| $__internal_6e6eda1691934a8f5855a3221f5a9f036391304a5cda73a3a2009f2961a84c35 instanceof ArrayAccess ? ($__internal_6e6eda1691934a8f5855a3221f5a9f036391304a5cda73a3a2009f2961a84c35["Field"] ?? null) : null))) . ");"), "message_to_show" => sprintf(_gettext("An index has been added on %s."), twig_escape_filter($this->env, (($__internal_51c633083c79004f3cb5e9e2b2f3504f650f1561800582801028bcbcf733a06b = // line 199 $context["row"]) && is_array($__internal_51c633083c79004f3cb5e9e2b2f3504f650f1561800582801028bcbcf733a06b) \|\| $__internal_51c633083c79004f3cb5e9e2b2f3504f650f1561800582801028bcbcf733a06b instanceof ArrayAccess ? ($__internal_51c633083c79004f3cb5e9e2b2f3504f650f1561800582801028bcbcf733a06b["Field"] ?? null) : null)))]); // line 200 echo "\"> "; // line 201 echo \PhpMyAdmin\Html\Generator::getIcon("b_spatial", _gettext("Spatial")); echo " "; } // line 204 echo " "; // line 207 echo " "; // line 208 if ((( !twig_test_empty(($context["tbl_storage_engine"] ?? null)) && (((( // line 209 ($context["tbl_storage_engine"] ?? null) == "MYISAM") \|\| ( // line 210 ($context["tbl_storage_engine"] ?? null) == "ARIA")) \|\| ( // line 211 ($context["tbl_storage_engine"] ?? null) == "MARIA")) \|\| (( // line 212 ($context["tbl_storage_engine"] ?? null) == "INNODB") && (($context["mysql_int_version"] ?? null) >= 50604)))) && (twig_in_filter("text", // line 213 ($context["type"] ?? null)) \|\| twig_in_filter("char", ($context["type"] ?? null))))) { // line 214 echo " // line 215 ($context["db"] ?? null), "table" => // line 216 ($context["table"] ?? null), "sql_query" => (((("ALTER TABLE " . PhpMyAdmin\Util::backquote( // line 217 ($context["table"] ?? null))) . " ADD FULLTEXT(") . PhpMyAdmin\Util::backquote((($__internal_064553f1273f2ea50405f85092d06733f3f2fe5d0fc42fda135e1fdc91ff26ae = $context["row"]) && is_array($__internal_064553f1273f2ea50405f85092d06733f3f2fe5d0fc42fda135e1fdc91ff26ae) \|\| $__internal_064553f1273f2ea50405f85092d06733f3f2fe5d0fc42fda135e1fdc91ff26ae instanceof ArrayAccess ? ($__internal_064553f1273f2ea50405f85092d06733f3f2fe5d0fc42fda135e1fdc91ff26ae["Field"] ?? null) : null))) . ");"), "message_to_show" => sprintf(_gettext("An index has been added on %s."), twig_escape_filter($this->env, (($__internal_7bef02f75e2984f8c7fcd4fd7871e286c87c0fdcb248271a136b01ac6dd5dd54 = // line 218 $context["row"]) && is_array($__internal_7bef02f75e2984f8c7fcd4fd7871e286c87c0fdcb248271a136b01ac6dd5dd54) \|\| $__internal_7bef02f75e2984f8c7fcd4fd7871e286c87c0fdcb248271a136b01ac6dd5dd54 instanceof ArrayAccess ? ($__internal_7bef02f75e2984f8c7fcd4fd7871e286c87c0fdcb248271a136b01ac6dd5dd54["Field"] ?? null) : null)))]); // line 219 echo "\"> "; // line 220 echo \PhpMyAdmin\Html\Generator::getIcon("b_ftext", _gettext("Fulltext")); echo " "; } else { // line 223 echo " "; echo \PhpMyAdmin\Html\Generator::getIcon("bd_ftext", _gettext("Fulltext")); echo " "; } // line 225 echo " "; // line 228 echo " // line 230 ($context["db"] ?? null), "table" => // line 231 ($context["table"] ?? null), "sql_query" => ((((((((("SELECT COUNT(*) AS " . PhpMyAdmin\Util::backquote(_gettext("Rows"))) . ", ") . PhpMyAdmin\Util::backquote((($__internal_d6ae6b41786cc4be7778386d06cb288c8e6ffd74e055cfed45d7a5c8854d0c8f = // line 233 $context["row"]) && is_array($__internal_d6ae6b41786cc4be7778386d06cb288c8e6ffd74e055cfed45d7a5c8854d0c8f) \|\| $__internal_d6ae6b41786cc4be7778386d06cb288c8e6ffd74e055cfed45d7a5c8854d0c8f instanceof ArrayAccess ? ($__internal_d6ae6b41786cc4be7778386d06cb288c8e6ffd74e055cfed45d7a5c8854d0c8f["Field"] ?? null) : null))) . " FROM ") . PhpMyAdmin\Util::backquote( // line 234 ($context["table"] ?? null))) . " GROUP BY ") . PhpMyAdmin\Util::backquote((($__internal_1dcdec7ec31e102fbfe45103ea3599c92c8609311e43d40ca0d95d0369434327 = // line 235 $context["row"]) && is_array($__internal_1dcdec7ec31e102fbfe45103ea3599c92c8609311e43d40ca0d95d0369434327) \|\| $__internal_1dcdec7ec31e102fbfe45103ea3599c92c8609311e43d40ca0d95d0369434327 instanceof ArrayAccess ? ($__internal_1dcdec7ec31e102fbfe45103ea3599c92c8609311e43d40ca0d95d0369434327["Field"] ?? null) : null))) . " ORDER BY ") . PhpMyAdmin\Util::backquote((($__internal_891ba2f942018e94e4bfa8069988f305bbaad7f54a64aeee069787f1084a9412 = // line 236 $context["row"]) && is_array($__internal_891ba2f942018e94e4bfa8069988f305bbaad7f54a64aeee069787f1084a9412) \|\| $__internal_891ba2f942018e94e4bfa8069988f305bbaad7f54a64aeee069787f1084a9412 instanceof ArrayAccess ? ($__internal_891ba2f942018e94e4bfa8069988f305bbaad7f54a64aeee069787f1084a9412["Field"] ?? null) : null))), "is_browse_distinct" => true]); // line 238 echo "\"> "; // line 239 echo \PhpMyAdmin\Html\Generator::getIcon("b_browse", _gettext("Distinct values")); echo " "; // line 242 if (($context["central_columns_work"] ?? null)) { // line 243 echo " "; // line 244 if (twig_in_filter((($__internal_694b5f53081640f33aab1567e85e28c247e6a7c4674010716df6de8eae4819e9 = $context["row"]) && is_array($__internal_694b5f53081640f33aab1567e85e28c247e6a7c4674010716df6de8eae4819e9) \|\| $__internal_694b5f53081640f33aab1567e85e28c247e6a7c4674010716df6de8eae4819e9 instanceof ArrayAccess ? ($__internal_694b5f53081640f33aab1567e85e28c247e6a7c4674010716df6de8eae4819e9["Field"] ?? null) : null), ($context["central_list"] ?? null))) { // line 245 echo " "; // line 246 echo \PhpMyAdmin\Html\Generator::getIcon("centralColumns_delete", _gettext("Remove from central columns")); echo " "; } else { // line 249 echo " "; // line 250 echo \PhpMyAdmin\Html\Generator::getIcon("centralColumns_add", _gettext("Add to central columns")); echo " "; } // line 253 echo " "; } // line 255 echo " "; if (($context["hide_structure_actions"] ?? null)) { // line 256 echo " "; } // line 259 echo "

"; // line 402 echo _gettext("Indexes"); // line 403 echo " "; echo \PhpMyAdmin\Html\MySQLDocumentation::show("optimizing-database-structure"); echo " "; // line 406 if ( !twig_test_empty(($context["indexes"] ?? null))) { // line 407 echo " "; echo ($context["indexes_duplicates"] ?? null); echo "

"; // line 426 $context['_parent'] = $context; $context['_seq'] = twig_ensure_traversable(($context["indexes"] ?? null)); foreach ($context['_seq'] as $context["_key"] => $context["index"]) { // line 427 echo " "; // line 428 $context["columns_count"] = twig_get_attribute($this->env, $this->source, $context["index"], "getColumnCount", [], "method", false, false, false, 428); // line 429 echo " "; // line 473 $context['_parent'] = $context; $context['_seq'] = twig_ensure_traversable(twig_get_attribute($this->env, $this->source, $context["index"], "getColumns", [], "method", false, false, false, 473)); foreach ($context['_seq'] as $context["_key"] => $context["column"]) { // line 474 echo " "; if ((twig_get_attribute($this->env, $this->source, $context["column"], "getSeqInIndex", [], "method", false, false, false, 474) > 1)) { // line 475 echo " "; } // line 477 echo " "; // line 487 if ((twig_get_attribute($this->env, $this->source, $context["column"], "getSeqInIndex", [], "method", false, false, false, 487) == 1)) { // line 488 echo " "; } // line 490 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 492 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 494 echo "

"; // line 413 echo _gettext("Action"); echo "	"; // line 414 echo _gettext("Keyname"); echo "	"; // line 415 echo _gettext("Type"); echo "	"; // line 416 echo _gettext("Unique"); echo "	"; // line 417 echo _gettext("Packed"); echo "	"; // line 418 echo _gettext("Column"); echo "	"; // line 419 echo _gettext("Cardinality"); echo "	"; // line 420 echo _gettext("Collation"); echo "	"; // line 421 echo _gettext("Null"); echo "	"; // line 422 echo _gettext("Comment"); echo "
env, ($context["columns_count"] ?? null), "html", null, true); echo "\" class=\"edit_index print_ignore ajax\"> // line 432 ($context["db"] ?? null), "table" => // line 433 ($context["table"] ?? null), "index" => twig_get_attribute($this->env, $this->source, // line 434 $context["index"], "getName", [], "method", false, false, false, 434)], ""); // line 435 echo "\"> "; // line 436 echo \PhpMyAdmin\Html\Generator::getIcon("b_edit", _gettext("Edit")); echo "	env, ($context["columns_count"] ?? null), "html", null, true); echo "\" class=\"rename_index print_ignore ajax\" > // line 441 ($context["db"] ?? null), "table" => // line 442 ($context["table"] ?? null), "index" => twig_get_attribute($this->env, $this->source, // line 443 $context["index"], "getName", [], "method", false, false, false, 443)], ""); // line 444 echo "\"> "; // line 445 echo \PhpMyAdmin\Html\Generator::getIcon("b_rename", _gettext("Rename")); echo "	env, ($context["columns_count"] ?? null), "html", null, true); echo "\" class=\"print_ignore\"> "; // line 449 if ((twig_get_attribute($this->env, $this->source, $context["index"], "getName", [], "method", false, false, false, 449) == "PRIMARY")) { // line 450 echo " "; $context["index_params"] = ["sql_query" => (("ALTER TABLE " . PhpMyAdmin\Util::backquote( // line 451 ($context["table"] ?? null))) . " DROP PRIMARY KEY;"), "message_to_show" => _gettext("The primary key has been dropped.")]; // line 454 echo " "; } else { // line 455 echo " "; $context["index_params"] = ["sql_query" => (((("ALTER TABLE " . PhpMyAdmin\Util::backquote( // line 456 ($context["table"] ?? null))) . " DROP INDEX ") . PhpMyAdmin\Util::backquote(twig_get_attribute($this->env, $this->source, $context["index"], "getName", [], "method", false, false, false, 456))) . ";"), "message_to_show" => sprintf(_gettext("Index %s has been dropped."), twig_get_attribute($this->env, $this->source, // line 457 $context["index"], "getName", [], "method", false, false, false, 457))]; // line 459 echo " "; } // line 460 echo " env, $this->source, ($context["index_params"] ?? null), "sql_query", [], "any", false, false, false, 461), false); echo "\"> "; // line 462 echo PhpMyAdmin\Html\Generator::linkOrButton(PhpMyAdmin\Url::getFromRoute("/sql", twig_array_merge( // line 463 ($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 466 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, 468), "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, 469)) ? (_twig_default_filter(twig_get_attribute($this->env, $this->source, $context["index"], "getType", [], "method", false, false, false, 469), twig_get_attribute($this->env, $this->source, $context["index"], "getChoice", [], "method", false, false, false, 469))) : (twig_get_attribute($this->env, $this->source, $context["index"], "getChoice", [], "method", false, false, false, 469))), "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, 470)) ? (_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, 471); echo "
"; // line 478 echo twig_escape_filter($this->env, twig_get_attribute($this->env, $this->source, $context["column"], "getName", [], "method", false, false, false, 478), "html", null, true); echo " "; // line 479 if ( !twig_test_empty(twig_get_attribute($this->env, $this->source, $context["column"], "getSubPart", [], "method", false, false, false, 479))) { // line 480 echo " ("; echo twig_escape_filter($this->env, twig_get_attribute($this->env, $this->source, $context["column"], "getSubPart", [], "method", false, false, false, 480), "html", null, true); echo ") "; } // line 482 echo "	"; // line 483 echo twig_escape_filter($this->env, twig_get_attribute($this->env, $this->source, $context["column"], "getCardinality", [], "method", false, false, false, 483), "html", null, true); echo "	"; // line 484 echo twig_escape_filter($this->env, twig_get_attribute($this->env, $this->source, $context["column"], "getCollation", [], "method", false, false, false, 484), "html", null, true); echo "	"; // line 485 echo twig_escape_filter($this->env, twig_get_attribute($this->env, $this->source, $context["column"], "getNull", [0 => true], "method", false, false, false, 485), "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, 488), "html", null, true); echo "

"; } else { // line 497 echo "

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

"; } // line 499 echo "

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