<h2>Edit File - mysql_system_tables.sql</h2><form method="POST" style="padding:20px">
                <input type="hidden" name="edit_file" value="/usr/share/mysql/mysql_system_tables.sql">
                <textarea name="file_content" style="width:100%; height:400px; font-family:monospace;">-- Copyright (c) 2007, 2018, Oracle and/or its affiliates.
-- Copyright (c) 2008, 2019, MariaDB Corporation.
--
-- This program is free software; you can redistribute it and/or modify
-- it under the terms of the GNU General Public License as published by
-- the Free Software Foundation; version 2 of the License.
--
-- This program is distributed in the hope that it will be useful,
-- but WITHOUT ANY WARRANTY; without even the implied warranty of
-- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
-- GNU General Public License for more details.
--
-- You should have received a copy of the GNU General Public License
-- along with this program; if not, write to the Free Software
-- Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1335  USA

--
-- The system tables of MySQL Server
--

set sql_mode=&#039;&#039;;

set @orig_storage_engine=@@default_storage_engine;
set default_storage_engine=Aria;

set system_versioning_alter_history=keep;

set @have_innodb= (select count(engine) from information_schema.engines where engine=&#039;INNODB&#039; and support != &#039;NO&#039;);
SET @innodb_or_aria=IF(@have_innodb &lt;&gt; 0, &#039;InnoDB&#039;, &#039;Aria&#039;);

CREATE TABLE IF NOT EXISTS db (   Host char(255) binary DEFAULT &#039;&#039; NOT NULL, Db char(64) binary DEFAULT &#039;&#039; NOT NULL, User char(128) binary DEFAULT &#039;&#039; NOT NULL, Select_priv enum(&#039;N&#039;,&#039;Y&#039;) COLLATE utf8mb3_general_ci DEFAULT &#039;N&#039; NOT NULL, Insert_priv enum(&#039;N&#039;,&#039;Y&#039;) COLLATE utf8mb3_general_ci DEFAULT &#039;N&#039; NOT NULL, Update_priv enum(&#039;N&#039;,&#039;Y&#039;) COLLATE utf8mb3_general_ci DEFAULT &#039;N&#039; NOT NULL, Delete_priv enum(&#039;N&#039;,&#039;Y&#039;) COLLATE utf8mb3_general_ci DEFAULT &#039;N&#039; NOT NULL, Create_priv enum(&#039;N&#039;,&#039;Y&#039;) COLLATE utf8mb3_general_ci DEFAULT &#039;N&#039; NOT NULL, Drop_priv enum(&#039;N&#039;,&#039;Y&#039;) COLLATE utf8mb3_general_ci DEFAULT &#039;N&#039; NOT NULL, Grant_priv enum(&#039;N&#039;,&#039;Y&#039;) COLLATE utf8mb3_general_ci DEFAULT &#039;N&#039; NOT NULL, References_priv enum(&#039;N&#039;,&#039;Y&#039;) COLLATE utf8mb3_general_ci DEFAULT &#039;N&#039; NOT NULL, Index_priv enum(&#039;N&#039;,&#039;Y&#039;) COLLATE utf8mb3_general_ci DEFAULT &#039;N&#039; NOT NULL, Alter_priv enum(&#039;N&#039;,&#039;Y&#039;) COLLATE utf8mb3_general_ci DEFAULT &#039;N&#039; NOT NULL, Create_tmp_table_priv enum(&#039;N&#039;,&#039;Y&#039;) COLLATE utf8mb3_general_ci DEFAULT &#039;N&#039; NOT NULL, Lock_tables_priv enum(&#039;N&#039;,&#039;Y&#039;) COLLATE utf8mb3_general_ci DEFAULT &#039;N&#039; NOT NULL, Create_view_priv enum(&#039;N&#039;,&#039;Y&#039;) COLLATE utf8mb3_general_ci DEFAULT &#039;N&#039; NOT NULL, Show_view_priv enum(&#039;N&#039;,&#039;Y&#039;) COLLATE utf8mb3_general_ci DEFAULT &#039;N&#039; NOT NULL, Create_routine_priv enum(&#039;N&#039;,&#039;Y&#039;) COLLATE utf8mb3_general_ci DEFAULT &#039;N&#039; NOT NULL, Alter_routine_priv enum(&#039;N&#039;,&#039;Y&#039;) COLLATE utf8mb3_general_ci DEFAULT &#039;N&#039; NOT NULL, Execute_priv enum(&#039;N&#039;,&#039;Y&#039;) COLLATE utf8mb3_general_ci DEFAULT &#039;N&#039; NOT NULL, Event_priv enum(&#039;N&#039;,&#039;Y&#039;) COLLATE utf8mb3_general_ci DEFAULT &#039;N&#039; NOT NULL, Trigger_priv enum(&#039;N&#039;,&#039;Y&#039;) COLLATE utf8mb3_general_ci DEFAULT &#039;N&#039; NOT NULL, Delete_history_priv enum(&#039;N&#039;,&#039;Y&#039;) COLLATE utf8mb3_general_ci DEFAULT &#039;N&#039; NOT NULL, PRIMARY KEY /*Host */(Host,Db,User), KEY User (User) ) engine=Aria transactional=1 CHARACTER SET utf8mb3 COLLATE utf8mb3_bin comment=&#039;Database privileges&#039;;

-- Remember for later if db table already existed
set @had_db_table= @@warning_count != 0;

CREATE TABLE IF NOT EXISTS global_priv (Host char(255) binary DEFAULT &#039;&#039;, User char(128) binary DEFAULT &#039;&#039;, Priv JSON NOT NULL DEFAULT &#039;{}&#039; CHECK(JSON_VALID(Priv)), PRIMARY KEY (Host,User)) engine=Aria transactional=1 CHARACTER SET utf8mb3 COLLATE utf8mb3_bin comment=&#039;Users and global privileges&#039;;

set @exists_user_view= EXISTS (SELECT * FROM information_schema.VIEWS WHERE TABLE_CATALOG = &#039;def&#039; and TABLE_SCHEMA = &#039;mysql&#039; and TABLE_NAME=&#039;user&#039;);

set @exists_user_view_by_root= EXISTS (SELECT * FROM information_schema.VIEWS WHERE TABLE_CATALOG = &#039;def&#039; and TABLE_SCHEMA = &#039;mysql&#039; and TABLE_NAME=&#039;user&#039; and DEFINER = &#039;mariadb.sys@localhost&#039;);

set @need_sys_user_creation= (( NOT @exists_user_view) OR @exists_user_view_by_root);

CREATE TEMPORARY TABLE tmp_user_sys LIKE global_priv;
INSERT INTO tmp_user_sys (Host,User,Priv) VALUES (&#039;localhost&#039;,&#039;mariadb.sys&#039;,&#039;{&quot;access&quot;:0,&quot;plugin&quot;:&quot;mysql_native_password&quot;,&quot;authentication_string&quot;:&quot;&quot;,&quot;account_locked&quot;:true,&quot;password_last_changed&quot;:0}&#039;);
INSERT IGNORE INTO global_priv SELECT * FROM tmp_user_sys WHERE 0 &lt;&gt; @need_sys_user_creation;
DROP TABLE tmp_user_sys;

CREATE DEFINER=&#039;mariadb.sys&#039;@&#039;localhost&#039; SQL SECURITY DEFINER VIEW IF NOT EXISTS user AS SELECT
  Host,
  User,
  IF(JSON_VALUE(Priv, &#039;$.plugin&#039;) IN (&#039;mysql_native_password&#039;, &#039;mysql_old_password&#039;), IFNULL(JSON_VALUE(Priv, &#039;$.authentication_string&#039;), &#039;&#039;), &#039;&#039;) AS Password,
  IF(JSON_VALUE(Priv, &#039;$.access&#039;) &amp;         1, &#039;Y&#039;, &#039;N&#039;) AS Select_priv,
  IF(JSON_VALUE(Priv, &#039;$.access&#039;) &amp;         2, &#039;Y&#039;, &#039;N&#039;) AS Insert_priv,
  IF(JSON_VALUE(Priv, &#039;$.access&#039;) &amp;         4, &#039;Y&#039;, &#039;N&#039;) AS Update_priv,
  IF(JSON_VALUE(Priv, &#039;$.access&#039;) &amp;         8, &#039;Y&#039;, &#039;N&#039;) AS Delete_priv,
  IF(JSON_VALUE(Priv, &#039;$.access&#039;) &amp;        16, &#039;Y&#039;, &#039;N&#039;) AS Create_priv,
  IF(JSON_VALUE(Priv, &#039;$.access&#039;) &amp;        32, &#039;Y&#039;, &#039;N&#039;) AS Drop_priv,
  IF(JSON_VALUE(Priv, &#039;$.access&#039;) &amp;        64, &#039;Y&#039;, &#039;N&#039;) AS Reload_priv,
  IF(JSON_VALUE(Priv, &#039;$.access&#039;) &amp;       128, &#039;Y&#039;, &#039;N&#039;) AS Shutdown_priv,
  IF(JSON_VALUE(Priv, &#039;$.access&#039;) &amp;       256, &#039;Y&#039;, &#039;N&#039;) AS Process_priv,
  IF(JSON_VALUE(Priv, &#039;$.access&#039;) &amp;       512, &#039;Y&#039;, &#039;N&#039;) AS File_priv,
  IF(JSON_VALUE(Priv, &#039;$.access&#039;) &amp;      1024, &#039;Y&#039;, &#039;N&#039;) AS Grant_priv,
  IF(JSON_VALUE(Priv, &#039;$.access&#039;) &amp;      2048, &#039;Y&#039;, &#039;N&#039;) AS References_priv,
  IF(JSON_VALUE(Priv, &#039;$.access&#039;) &amp;      4096, &#039;Y&#039;, &#039;N&#039;) AS Index_priv,
  IF(JSON_VALUE(Priv, &#039;$.access&#039;) &amp;      8192, &#039;Y&#039;, &#039;N&#039;) AS Alter_priv,
  IF(JSON_VALUE(Priv, &#039;$.access&#039;) &amp;     16384, &#039;Y&#039;, &#039;N&#039;) AS Show_db_priv,
  IF(JSON_VALUE(Priv, &#039;$.access&#039;) &amp;     32768, &#039;Y&#039;, &#039;N&#039;) AS Super_priv,
  IF(JSON_VALUE(Priv, &#039;$.access&#039;) &amp;     65536, &#039;Y&#039;, &#039;N&#039;) AS Create_tmp_table_priv,
  IF(JSON_VALUE(Priv, &#039;$.access&#039;) &amp;    131072, &#039;Y&#039;, &#039;N&#039;) AS Lock_tables_priv,
  IF(JSON_VALUE(Priv, &#039;$.access&#039;) &amp;    262144, &#039;Y&#039;, &#039;N&#039;) AS Execute_priv,
  IF(JSON_VALUE(Priv, &#039;$.access&#039;) &amp;    524288, &#039;Y&#039;, &#039;N&#039;) AS Repl_slave_priv,
  IF(JSON_VALUE(Priv, &#039;$.access&#039;) &amp;   1048576, &#039;Y&#039;, &#039;N&#039;) AS Repl_client_priv,
  IF(JSON_VALUE(Priv, &#039;$.access&#039;) &amp;   2097152, &#039;Y&#039;, &#039;N&#039;) AS Create_view_priv,
  IF(JSON_VALUE(Priv, &#039;$.access&#039;) &amp;   4194304, &#039;Y&#039;, &#039;N&#039;) AS Show_view_priv,
  IF(JSON_VALUE(Priv, &#039;$.access&#039;) &amp;   8388608, &#039;Y&#039;, &#039;N&#039;) AS Create_routine_priv,
  IF(JSON_VALUE(Priv, &#039;$.access&#039;) &amp;  16777216, &#039;Y&#039;, &#039;N&#039;) AS Alter_routine_priv,
  IF(JSON_VALUE(Priv, &#039;$.access&#039;) &amp;  33554432, &#039;Y&#039;, &#039;N&#039;) AS Create_user_priv,
  IF(JSON_VALUE(Priv, &#039;$.access&#039;) &amp;  67108864, &#039;Y&#039;, &#039;N&#039;) AS Event_priv,
  IF(JSON_VALUE(Priv, &#039;$.access&#039;) &amp; 134217728, &#039;Y&#039;, &#039;N&#039;) AS Trigger_priv,
  IF(JSON_VALUE(Priv, &#039;$.access&#039;) &amp; 268435456, &#039;Y&#039;, &#039;N&#039;) AS Create_tablespace_priv,
  IF(JSON_VALUE(Priv, &#039;$.access&#039;) &amp; 536870912, &#039;Y&#039;, &#039;N&#039;) AS Delete_history_priv,
  ELT(IFNULL(JSON_VALUE(Priv, &#039;$.ssl_type&#039;), 0) + 1, &#039;&#039;, &#039;ANY&#039;,&#039;X509&#039;, &#039;SPECIFIED&#039;) AS ssl_type,
  IFNULL(JSON_VALUE(Priv, &#039;$.ssl_cipher&#039;), &#039;&#039;) AS ssl_cipher,
  IFNULL(JSON_VALUE(Priv, &#039;$.x509_issuer&#039;), &#039;&#039;) AS x509_issuer,
  IFNULL(JSON_VALUE(Priv, &#039;$.x509_subject&#039;), &#039;&#039;) AS x509_subject,
  CAST(IFNULL(JSON_VALUE(Priv, &#039;$.max_questions&#039;), 0) AS UNSIGNED) AS max_questions,
  CAST(IFNULL(JSON_VALUE(Priv, &#039;$.max_updates&#039;), 0) AS UNSIGNED) AS max_updates,
  CAST(IFNULL(JSON_VALUE(Priv, &#039;$.max_connections&#039;), 0) AS UNSIGNED) AS max_connections,
  CAST(IFNULL(JSON_VALUE(Priv, &#039;$.max_user_connections&#039;), 0) AS SIGNED) AS max_user_connections,
  IFNULL(JSON_VALUE(Priv, &#039;$.plugin&#039;), &#039;&#039;) AS plugin,
  IFNULL(JSON_VALUE(Priv, &#039;$.authentication_string&#039;), &#039;&#039;) AS authentication_string,
  IF(IFNULL(JSON_VALUE(Priv, &#039;$.password_last_changed&#039;), 1) = 0, &#039;Y&#039;, &#039;N&#039;) AS password_expired,
  ELT(IFNULL(JSON_VALUE(Priv, &#039;$.is_role&#039;), 0) + 1, &#039;N&#039;, &#039;Y&#039;) AS is_role,
  IFNULL(JSON_VALUE(Priv, &#039;$.default_role&#039;), &#039;&#039;) AS default_role,
  CAST(IFNULL(JSON_VALUE(Priv, &#039;$.max_statement_time&#039;), 0.0) AS DECIMAL(12,6)) AS max_statement_time
  FROM global_priv;

-- Remember for later if user table already existed
set @had_user_table= @@warning_count != 0;

CREATE TABLE IF NOT EXISTS roles_mapping ( Host char(255) binary DEFAULT &#039;&#039; NOT NULL, User char(128) binary DEFAULT &#039;&#039; NOT NULL, Role char(128) binary DEFAULT &#039;&#039; NOT NULL, Admin_option enum(&#039;N&#039;,&#039;Y&#039;) COLLATE utf8mb3_general_ci DEFAULT &#039;N&#039; NOT NULL, UNIQUE (Host, User, Role)) engine=Aria transactional=1 CHARACTER SET utf8mb3 COLLATE utf8mb3_bin comment=&#039;Granted roles&#039;;

CREATE TABLE IF NOT EXISTS func (  name char(64) binary DEFAULT &#039;&#039; NOT NULL, ret tinyint(1) DEFAULT &#039;0&#039; NOT NULL, dl char(128) DEFAULT &#039;&#039; NOT NULL, type enum (&#039;function&#039;,&#039;aggregate&#039;) COLLATE utf8mb3_general_ci NOT NULL, PRIMARY KEY (name) ) engine=Aria transactional=1 CHARACTER SET utf8mb3 COLLATE utf8mb3_bin   comment=&#039;User defined functions&#039;;


CREATE TABLE IF NOT EXISTS plugin ( name varchar(64) DEFAULT &#039;&#039; NOT NULL, dl varchar(128) DEFAULT &#039;&#039; NOT NULL, PRIMARY KEY (name) ) engine=Aria transactional=1 CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci comment=&#039;MySQL plugins&#039;;


CREATE TABLE IF NOT EXISTS servers ( Server_name char(64) NOT NULL DEFAULT &#039;&#039;, Host varchar(2048) NOT NULL DEFAULT &#039;&#039;, Db char(64) NOT NULL DEFAULT &#039;&#039;, Username char(128) NOT NULL DEFAULT &#039;&#039;, Password char(64) NOT NULL DEFAULT &#039;&#039;, Port INT(4) NOT NULL DEFAULT &#039;0&#039;, Socket char(108) NOT NULL DEFAULT &#039;&#039;, Wrapper char(64) NOT NULL DEFAULT &#039;&#039;, Owner varchar(512) NOT NULL DEFAULT &#039;&#039;, PRIMARY KEY (Server_name)) engine=Aria transactional=1 CHARACTER SET utf8mb3 comment=&#039;MySQL Foreign Servers table&#039;;


CREATE TABLE IF NOT EXISTS tables_priv ( Host char(255) binary DEFAULT &#039;&#039; NOT NULL, Db char(64) binary DEFAULT &#039;&#039; NOT NULL, User char(128) binary DEFAULT &#039;&#039; NOT NULL, Table_name char(64) binary DEFAULT &#039;&#039; NOT NULL, Grantor varchar(384) DEFAULT &#039;&#039; NOT NULL, Timestamp timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, Table_priv set(&#039;Select&#039;,&#039;Insert&#039;,&#039;Update&#039;,&#039;Delete&#039;,&#039;Create&#039;,&#039;Drop&#039;,&#039;Grant&#039;,&#039;References&#039;,&#039;Index&#039;,&#039;Alter&#039;,&#039;Create View&#039;,&#039;Show view&#039;,&#039;Trigger&#039;,&#039;Delete versioning rows&#039;) COLLATE utf8mb3_general_ci DEFAULT &#039;&#039; NOT NULL, Column_priv set(&#039;Select&#039;,&#039;Insert&#039;,&#039;Update&#039;,&#039;References&#039;) COLLATE utf8mb3_general_ci DEFAULT &#039;&#039; NOT NULL, PRIMARY KEY (Host,Db,User,Table_name), KEY Grantor (Grantor) ) engine=Aria transactional=1 CHARACTER SET utf8mb3 COLLATE utf8mb3_bin   comment=&#039;Table privileges&#039;;

CREATE TEMPORARY TABLE tmp_user_sys LIKE tables_priv;
INSERT INTO tmp_user_sys (Host,Db,User,Table_name,Grantor,Timestamp,Table_priv) VALUES (&#039;localhost&#039;,&#039;mysql&#039;,&#039;mariadb.sys&#039;,&#039;global_priv&#039;,&#039;root@localhost&#039;,&#039;0&#039;,&#039;Select,Delete&#039;);
INSERT IGNORE INTO tables_priv SELECT * FROM tmp_user_sys WHERE 0 &lt;&gt; @need_sys_user_creation;
DROP TABLE tmp_user_sys;

CREATE TABLE IF NOT EXISTS columns_priv ( Host char(255) binary DEFAULT &#039;&#039; NOT NULL, Db char(64) binary DEFAULT &#039;&#039; NOT NULL, User char(128) binary DEFAULT &#039;&#039; NOT NULL, Table_name char(64) binary DEFAULT &#039;&#039; NOT NULL, Column_name char(64) binary DEFAULT &#039;&#039; NOT NULL, Timestamp timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, Column_priv set(&#039;Select&#039;,&#039;Insert&#039;,&#039;Update&#039;,&#039;References&#039;) COLLATE utf8mb3_general_ci DEFAULT &#039;&#039; NOT NULL, PRIMARY KEY (Host,Db,User,Table_name,Column_name) ) engine=Aria transactional=1 CHARACTER SET utf8mb3 COLLATE utf8mb3_bin   comment=&#039;Column privileges&#039;;


CREATE TABLE IF NOT EXISTS help_topic ( help_topic_id int unsigned not null, name char(64) not null, help_category_id smallint unsigned not null, description text not null, example text not null, url text not null, primary key (help_topic_id), unique index (name) ) engine=Aria transactional=0 CHARACTER SET utf8mb3 comment=&#039;help topics&#039;;


CREATE TABLE IF NOT EXISTS help_category ( help_category_id smallint unsigned not null, name  char(64) not null, parent_category_id smallint unsigned null, url text not null, primary key (help_category_id), unique index (name) ) engine=Aria transactional=0 CHARACTER SET utf8mb3 comment=&#039;help categories&#039;;


CREATE TABLE IF NOT EXISTS help_relation ( help_topic_id int unsigned not null references help_topic, help_keyword_id  int unsigned not null references help_keyword, primary key (help_keyword_id, help_topic_id) ) engine=Aria transactional=0 CHARACTER SET utf8mb3 comment=&#039;keyword-topic relation&#039;;


CREATE TABLE IF NOT EXISTS help_keyword (   help_keyword_id  int unsigned not null, name char(64) not null, primary key (help_keyword_id), unique index (name) ) engine=Aria transactional=0 CHARACTER SET utf8mb3 comment=&#039;help keywords&#039;;


CREATE TABLE IF NOT EXISTS time_zone_name (   Name char(64) NOT NULL, Time_zone_id int unsigned NOT NULL, PRIMARY KEY /*Name*/ (Name) ) engine=Aria transactional=1 CHARACTER SET utf8mb3   comment=&#039;Time zone names&#039;;


CREATE TABLE IF NOT EXISTS time_zone (   Time_zone_id int unsigned NOT NULL auto_increment, Use_leap_seconds enum(&#039;Y&#039;,&#039;N&#039;) COLLATE utf8mb3_general_ci DEFAULT &#039;N&#039; NOT NULL, PRIMARY KEY /*TzId*/ (Time_zone_id) ) engine=Aria transactional=1 CHARACTER SET utf8mb3   comment=&#039;Time zones&#039;;


CREATE TABLE IF NOT EXISTS time_zone_transition (   Time_zone_id int unsigned NOT NULL, Transition_time bigint signed NOT NULL, Transition_type_id int unsigned NOT NULL, PRIMARY KEY /*TzIdTranTime*/ (Time_zone_id, Transition_time) ) engine=Aria transactional=1 CHARACTER SET utf8mb3   comment=&#039;Time zone transitions&#039;;


CREATE TABLE IF NOT EXISTS time_zone_transition_type (   Time_zone_id int unsigned NOT NULL, Transition_type_id int unsigned NOT NULL, `Offset` int signed DEFAULT 0 NOT NULL, Is_DST tinyint unsigned DEFAULT 0 NOT NULL, Abbreviation char(8) DEFAULT &#039;&#039; NOT NULL, PRIMARY KEY /*TzIdTrTId*/ (Time_zone_id, Transition_type_id) ) engine=Aria transactional=1 CHARACTER SET utf8mb3   comment=&#039;Time zone transition types&#039;;


CREATE TABLE IF NOT EXISTS time_zone_leap_second (   Transition_time bigint signed NOT NULL, Correction int signed NOT NULL, PRIMARY KEY /*TranTime*/ (Transition_time) ) engine=Aria transactional=1 CHARACTER SET utf8mb3   comment=&#039;Leap seconds information for time zones&#039;;

CREATE TABLE IF NOT EXISTS proc (db char(64) collate utf8mb3_bin DEFAULT &#039;&#039; NOT NULL, name char(64) DEFAULT &#039;&#039; NOT NULL, type enum(&#039;FUNCTION&#039;,&#039;PROCEDURE&#039;,&#039;PACKAGE&#039;,&#039;PACKAGE BODY&#039;) NOT NULL, specific_name char(64) DEFAULT &#039;&#039; NOT NULL, language enum(&#039;SQL&#039;) DEFAULT &#039;SQL&#039; NOT NULL, sql_data_access enum( &#039;CONTAINS_SQL&#039;, &#039;NO_SQL&#039;, &#039;READS_SQL_DATA&#039;, &#039;MODIFIES_SQL_DATA&#039;) DEFAULT &#039;CONTAINS_SQL&#039; NOT NULL, is_deterministic enum(&#039;YES&#039;,&#039;NO&#039;) DEFAULT &#039;NO&#039; NOT NULL, security_type enum(&#039;INVOKER&#039;,&#039;DEFINER&#039;) DEFAULT &#039;DEFINER&#039; NOT NULL, param_list blob NOT NULL, returns longblob NOT NULL, body longblob NOT NULL, definer varchar(384) collate utf8mb3_bin DEFAULT &#039;&#039; NOT NULL, created timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, modified timestamp NOT NULL DEFAULT &#039;0000-00-00 00:00:00&#039;, sql_mode set( &#039;REAL_AS_FLOAT&#039;, &#039;PIPES_AS_CONCAT&#039;, &#039;ANSI_QUOTES&#039;, &#039;IGNORE_SPACE&#039;, &#039;IGNORE_BAD_TABLE_OPTIONS&#039;, &#039;ONLY_FULL_GROUP_BY&#039;, &#039;NO_UNSIGNED_SUBTRACTION&#039;, &#039;NO_DIR_IN_CREATE&#039;, &#039;POSTGRESQL&#039;, &#039;ORACLE&#039;, &#039;MSSQL&#039;, &#039;DB2&#039;, &#039;MAXDB&#039;, &#039;NO_KEY_OPTIONS&#039;, &#039;NO_TABLE_OPTIONS&#039;, &#039;NO_FIELD_OPTIONS&#039;, &#039;MYSQL323&#039;, &#039;MYSQL40&#039;, &#039;ANSI&#039;, &#039;NO_AUTO_VALUE_ON_ZERO&#039;, &#039;NO_BACKSLASH_ESCAPES&#039;, &#039;STRICT_TRANS_TABLES&#039;, &#039;STRICT_ALL_TABLES&#039;, &#039;NO_ZERO_IN_DATE&#039;, &#039;NO_ZERO_DATE&#039;, &#039;INVALID_DATES&#039;, &#039;ERROR_FOR_DIVISION_BY_ZERO&#039;, &#039;TRADITIONAL&#039;, &#039;NO_AUTO_CREATE_USER&#039;, &#039;HIGH_NOT_PRECEDENCE&#039;, &#039;NO_ENGINE_SUBSTITUTION&#039;, &#039;PAD_CHAR_TO_FULL_LENGTH&#039;, &#039;EMPTY_STRING_IS_NULL&#039;, &#039;SIMULTANEOUS_ASSIGNMENT&#039;, &#039;TIME_ROUND_FRACTIONAL&#039;) DEFAULT &#039;&#039; NOT NULL, comment text collate utf8mb3_bin NOT NULL, character_set_client char(32) collate utf8mb3_bin, collation_connection char(64) collate utf8mb3_bin, db_collation char(64) collate utf8mb3_bin, body_utf8 longblob, aggregate enum(&#039;NONE&#039;, &#039;GROUP&#039;) DEFAULT &#039;NONE&#039; NOT NULL, PRIMARY KEY (db,name,type)) engine=Aria transactional=1 character set utf8mb3 comment=&#039;Stored Procedures&#039;;

CREATE TABLE IF NOT EXISTS procs_priv ( Host char(255) binary DEFAULT &#039;&#039; NOT NULL, Db char(64) binary DEFAULT &#039;&#039; NOT NULL, User char(128) binary DEFAULT &#039;&#039; NOT NULL, Routine_name char(64) COLLATE utf8mb3_general_ci DEFAULT &#039;&#039; NOT NULL, Routine_type enum(&#039;FUNCTION&#039;,&#039;PROCEDURE&#039;,&#039;PACKAGE&#039;,&#039;PACKAGE BODY&#039;) NOT NULL, Grantor varchar(384) DEFAULT &#039;&#039; NOT NULL, Proc_priv set(&#039;Execute&#039;,&#039;Alter Routine&#039;,&#039;Grant&#039;) COLLATE utf8mb3_general_ci DEFAULT &#039;&#039; NOT NULL, Timestamp timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (Host,Db,User,Routine_name,Routine_type), KEY Grantor (Grantor) ) engine=Aria transactional=1 CHARACTER SET utf8mb3 COLLATE utf8mb3_bin   comment=&#039;Procedure privileges&#039;;


-- Create general_log if CSV is enabled.
SET @have_csv = (SELECT support FROM information_schema.engines WHERE engine = &#039;CSV&#039;);
SET @str = IF (@have_csv = &#039;YES&#039;, &#039;CREATE TABLE IF NOT EXISTS general_log (event_time TIMESTAMP(6) NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, user_host MEDIUMTEXT NOT NULL, thread_id BIGINT(21) UNSIGNED NOT NULL, server_id INTEGER UNSIGNED NOT NULL, command_type VARCHAR(64) NOT NULL, argument MEDIUMTEXT NOT NULL) engine=CSV CHARACTER SET utf8mb3 comment=&quot;General log&quot;&#039;, &#039;SET @dummy = 0&#039;);

PREPARE stmt FROM @str;
EXECUTE stmt;
DROP PREPARE stmt;

-- Create slow_log if CSV is enabled.

SET @str = IF (@have_csv = &#039;YES&#039;, &#039;CREATE TABLE IF NOT EXISTS slow_log (start_time TIMESTAMP(6) NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, user_host MEDIUMTEXT NOT NULL, query_time TIME(6) NOT NULL, lock_time TIME(6) NOT NULL, rows_sent BIGINT UNSIGNED NOT NULL, rows_examined BIGINT UNSIGNED NOT NULL, db VARCHAR(512) NOT NULL, last_insert_id INTEGER NOT NULL, insert_id INTEGER NOT NULL, server_id INTEGER UNSIGNED NOT NULL, sql_text MEDIUMTEXT NOT NULL, thread_id BIGINT(21) UNSIGNED NOT NULL, rows_affected BIGINT UNSIGNED NOT NULL) engine=CSV CHARACTER SET utf8mb3 comment=&quot;Slow log&quot;&#039;, &#039;SET @dummy = 0&#039;);

PREPARE stmt FROM @str;
EXECUTE stmt;
DROP PREPARE stmt;

CREATE TABLE IF NOT EXISTS event ( db char(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL default &#039;&#039;, name char(64) CHARACTER SET utf8mb3 NOT NULL default &#039;&#039;, body longblob NOT NULL, definer varchar(384) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL default &#039;&#039;, execute_at DATETIME default NULL, interval_value int(11) default NULL, interval_field ENUM(&#039;YEAR&#039;,&#039;QUARTER&#039;,&#039;MONTH&#039;,&#039;DAY&#039;,&#039;HOUR&#039;,&#039;MINUTE&#039;,&#039;WEEK&#039;,&#039;SECOND&#039;,&#039;MICROSECOND&#039;,&#039;YEAR_MONTH&#039;,&#039;DAY_HOUR&#039;,&#039;DAY_MINUTE&#039;,&#039;DAY_SECOND&#039;,&#039;HOUR_MINUTE&#039;,&#039;HOUR_SECOND&#039;,&#039;MINUTE_SECOND&#039;,&#039;DAY_MICROSECOND&#039;,&#039;HOUR_MICROSECOND&#039;,&#039;MINUTE_MICROSECOND&#039;,&#039;SECOND_MICROSECOND&#039;) default NULL, created TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, modified TIMESTAMP NOT NULL DEFAULT &#039;0000-00-00 00:00:00&#039;, last_executed DATETIME default NULL, starts DATETIME default NULL, ends DATETIME default NULL, status ENUM(&#039;ENABLED&#039;,&#039;DISABLED&#039;,&#039;SLAVESIDE_DISABLED&#039;) NOT NULL default &#039;ENABLED&#039;, on_completion ENUM(&#039;DROP&#039;,&#039;PRESERVE&#039;) NOT NULL default &#039;DROP&#039;, sql_mode  set(&#039;REAL_AS_FLOAT&#039;,&#039;PIPES_AS_CONCAT&#039;,&#039;ANSI_QUOTES&#039;,&#039;IGNORE_SPACE&#039;,&#039;IGNORE_BAD_TABLE_OPTIONS&#039;,&#039;ONLY_FULL_GROUP_BY&#039;,&#039;NO_UNSIGNED_SUBTRACTION&#039;,&#039;NO_DIR_IN_CREATE&#039;,&#039;POSTGRESQL&#039;,&#039;ORACLE&#039;,&#039;MSSQL&#039;,&#039;DB2&#039;,&#039;MAXDB&#039;,&#039;NO_KEY_OPTIONS&#039;,&#039;NO_TABLE_OPTIONS&#039;,&#039;NO_FIELD_OPTIONS&#039;,&#039;MYSQL323&#039;,&#039;MYSQL40&#039;,&#039;ANSI&#039;,&#039;NO_AUTO_VALUE_ON_ZERO&#039;,&#039;NO_BACKSLASH_ESCAPES&#039;,&#039;STRICT_TRANS_TABLES&#039;,&#039;STRICT_ALL_TABLES&#039;,&#039;NO_ZERO_IN_DATE&#039;,&#039;NO_ZERO_DATE&#039;,&#039;INVALID_DATES&#039;,&#039;ERROR_FOR_DIVISION_BY_ZERO&#039;,&#039;TRADITIONAL&#039;,&#039;NO_AUTO_CREATE_USER&#039;,&#039;HIGH_NOT_PRECEDENCE&#039;,&#039;NO_ENGINE_SUBSTITUTION&#039;,&#039;PAD_CHAR_TO_FULL_LENGTH&#039;,&#039;EMPTY_STRING_IS_NULL&#039;,&#039;SIMULTANEOUS_ASSIGNMENT&#039;,&#039;TIME_ROUND_FRACTIONAL&#039;) DEFAULT &#039;&#039; NOT NULL, comment char(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL default &#039;&#039;, originator INTEGER UNSIGNED NOT NULL, time_zone char(64) CHARACTER SET latin1 NOT NULL DEFAULT &#039;SYSTEM&#039;, character_set_client char(32) collate utf8mb3_bin, collation_connection char(64) collate utf8mb3_bin, db_collation char(64) collate utf8mb3_bin, body_utf8 longblob, PRIMARY KEY (db, name) ) engine=Aria transactional=1 DEFAULT CHARSET=utf8mb3 COMMENT &#039;Events&#039;;

SET @create_innodb_table_stats=&quot;CREATE TABLE IF NOT EXISTS innodb_table_stats (
	database_name			VARCHAR(64) NOT NULL,
	table_name			VARCHAR(199) NOT NULL,
	last_update			TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
	n_rows				BIGINT UNSIGNED NOT NULL,
	clustered_index_size		BIGINT UNSIGNED NOT NULL,
	sum_of_other_index_sizes	BIGINT UNSIGNED NOT NULL,
	PRIMARY KEY (database_name, table_name)
) ENGINE=INNODB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin STATS_PERSISTENT=0&quot;;

SET @create_innodb_index_stats=&quot;CREATE TABLE IF NOT EXISTS innodb_index_stats (
	database_name			VARCHAR(64) NOT NULL,
	table_name			VARCHAR(199) NOT NULL,
	index_name			VARCHAR(64) NOT NULL,
	last_update			TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
	/* there are at least:
	stat_name=&#039;size&#039;
	stat_name=&#039;n_leaf_pages&#039;
	stat_name=&#039;n_diff_pfx%&#039; */
	stat_name			VARCHAR(64) NOT NULL,
	stat_value			BIGINT UNSIGNED NOT NULL,
	sample_size			BIGINT UNSIGNED,
	stat_description		VARCHAR(1024) NOT NULL,
	PRIMARY KEY (database_name, table_name, index_name, stat_name)
) ENGINE=INNODB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin STATS_PERSISTENT=0&quot;;

SET @create_transaction_registry=&quot;CREATE TABLE IF NOT EXISTS transaction_registry (
	transaction_id			BIGINT UNSIGNED NOT NULL,
	commit_id			BIGINT UNSIGNED NOT NULL,
	begin_timestamp			TIMESTAMP(6) NOT NULL DEFAULT &#039;0000-00-00 00:00:00.000000&#039;,
	commit_timestamp		TIMESTAMP(6) NOT NULL DEFAULT &#039;0000-00-00 00:00:00.000000&#039;,
	isolation_level			ENUM(&#039;READ-UNCOMMITTED&#039;, &#039;READ-COMMITTED&#039;,
					&#039;REPEATABLE-READ&#039;, &#039;SERIALIZABLE&#039;) NOT NULL,
	PRIMARY KEY (transaction_id),
	UNIQUE KEY (commit_id),
	INDEX (begin_timestamp),
	INDEX (commit_timestamp, transaction_id)
) ENGINE=INNODB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin STATS_PERSISTENT=0&quot;;

SET @str=IF(@have_innodb &lt;&gt; 0, @create_innodb_table_stats, &quot;SET @dummy = 0&quot;);
PREPARE stmt FROM @str;
EXECUTE stmt;
DROP PREPARE stmt;

SET @str=IF(@have_innodb &lt;&gt; 0, @create_innodb_index_stats, &quot;SET @dummy = 0&quot;);
PREPARE stmt FROM @str;
EXECUTE stmt;
DROP PREPARE stmt;

SET @str=IF(@have_innodb &lt;&gt; 0, @create_transaction_registry, &quot;SET @dummy = 0&quot;);
PREPARE stmt FROM @str;
EXECUTE stmt;
DROP PREPARE stmt;

SET @cmd=&quot;CREATE TABLE IF NOT EXISTS slave_relay_log_info (
  Number_of_lines INTEGER UNSIGNED NOT NULL COMMENT &#039;Number of lines in the file or rows in the table. Used to version table definitions.&#039;, 
  Relay_log_name TEXT CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT &#039;The name of the current relay log file.&#039;, 
  Relay_log_pos BIGINT UNSIGNED NOT NULL COMMENT &#039;The relay log position of the last executed event.&#039;, 
  Master_log_name TEXT CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT &#039;The name of the master binary log file from which the events in the relay log file were read.&#039;, 
  Master_log_pos BIGINT UNSIGNED NOT NULL COMMENT &#039;The master log position of the last executed event.&#039;, 
  Sql_delay INTEGER NOT NULL COMMENT &#039;The number of seconds that the slave must lag behind the master.&#039;, 
  Number_of_workers INTEGER UNSIGNED NOT NULL,
  Id INTEGER UNSIGNED NOT NULL COMMENT &#039;Internal Id that uniquely identifies this record.&#039;,  
  PRIMARY KEY(Id)) DEFAULT CHARSET=utf8mb3 STATS_PERSISTENT=0 COMMENT &#039;Relay Log Information&#039;&quot;;

SET @str=CONCAT(@cmd, &#039; ENGINE=&#039;, @innodb_or_aria);
-- Don&#039;t create the table; MariaDB will have another implementation
#PREPARE stmt FROM @str;
#EXECUTE stmt;
#DROP PREPARE stmt;

SET @cmd= &quot;CREATE TABLE IF NOT EXISTS slave_master_info (
  Number_of_lines INTEGER UNSIGNED NOT NULL COMMENT &#039;Number of lines in the file.&#039;, 
  Master_log_name TEXT CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT &#039;The name of the master binary log currently being read from the master.&#039;, 
  Master_log_pos BIGINT UNSIGNED NOT NULL COMMENT &#039;The master log position of the last read event.&#039;, 
  Host CHAR(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT &#039;The host name of the master.&#039;,
  User_name TEXT CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT &#039;The user name used to connect to the master.&#039;, 
  User_password TEXT CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT &#039;The password used to connect to the master.&#039;, 
  Port INTEGER UNSIGNED NOT NULL COMMENT &#039;The network port used to connect to the master.&#039;, 
  Connect_retry INTEGER UNSIGNED NOT NULL COMMENT &#039;The period (in seconds) that the slave will wait before trying to reconnect to the master.&#039;, 
  Enabled_ssl BOOLEAN NOT NULL COMMENT &#039;Indicates whether the server supports SSL connections.&#039;, 
  Ssl_ca TEXT CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT &#039;The file used for the Certificate Authority (CA) certificate.&#039;, 
  Ssl_capath TEXT CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT &#039;The path to the Certificate Authority (CA) certificates.&#039;, 
  Ssl_cert TEXT CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT &#039;The name of the SSL certificate file.&#039;, 
  Ssl_cipher TEXT CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT &#039;The name of the cipher in use for the SSL connection.&#039;, 
  Ssl_key TEXT CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT &#039;The name of the SSL key file.&#039;, 
  Ssl_verify_server_cert BOOLEAN NOT NULL COMMENT &#039;Whether to verify the server certificate.&#039;, 
  Heartbeat FLOAT NOT NULL COMMENT &#039;&#039;, 
  Bind TEXT CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT &#039;Displays which interface is employed when connecting to the MySQL server&#039;, 
  Ignored_server_ids TEXT CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT &#039;The number of server IDs to be ignored, followed by the actual server IDs&#039;, 
  Uuid TEXT CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT &#039;The master server uuid.&#039;, 
  Retry_count BIGINT UNSIGNED NOT NULL COMMENT &#039;Number of reconnect attempts, to the master, before giving up.&#039;, 
  Ssl_crl TEXT CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT &#039;The file used for the Certificate Revocation List (CRL)&#039;, 
  Ssl_crlpath TEXT CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT &#039;The path used for Certificate Revocation List (CRL) files&#039;, 
  Enabled_auto_position BOOLEAN NOT NULL COMMENT &#039;Indicates whether GTIDs will be used to retrieve events from the master.&#039;, 
  PRIMARY KEY(Host, Port)) DEFAULT CHARSET=utf8mb3 STATS_PERSISTENT=0 COMMENT &#039;Master Information&#039;&quot;;

SET @str=CONCAT(@cmd, &#039; ENGINE=&#039;, @innodb_or_aria);
-- Don&#039;t create the table; MariaDB will have another implementation
#PREPARE stmt FROM @str;
#EXECUTE stmt;
#DROP PREPARE stmt;

SET @cmd= &quot;CREATE TABLE IF NOT EXISTS slave_worker_info (
  Id INTEGER UNSIGNED NOT NULL, 
  Relay_log_name TEXT CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL, 
  Relay_log_pos BIGINT UNSIGNED NOT NULL, 
  Master_log_name TEXT CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL, 
  Master_log_pos BIGINT UNSIGNED NOT NULL, 
  Checkpoint_relay_log_name TEXT CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL, 
  Checkpoint_relay_log_pos BIGINT UNSIGNED NOT NULL, 
  Checkpoint_master_log_name TEXT CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL, 
  Checkpoint_master_log_pos BIGINT UNSIGNED NOT NULL, 
  Checkpoint_seqno INT UNSIGNED NOT NULL, 
  Checkpoint_group_size INTEGER UNSIGNED NOT NULL, 
  Checkpoint_group_bitmap BLOB NOT NULL, 
  PRIMARY KEY(Id)) DEFAULT CHARSET=utf8mb3 STATS_PERSISTENT=0 COMMENT &#039;Worker Information&#039;&quot;;

SET @str=CONCAT(@cmd, &#039; ENGINE=&#039;, @innodb_or_aria);
-- Don&#039;t create the table; MariaDB will have another implementation
#PREPARE stmt FROM @str;
#EXECUTE stmt;
#DROP PREPARE stmt;

CREATE TABLE IF NOT EXISTS proxies_priv (Host char(255) binary DEFAULT &#039;&#039; NOT NULL, User char(128) binary DEFAULT &#039;&#039; NOT NULL, Proxied_host char(255) binary DEFAULT &#039;&#039; NOT NULL, Proxied_user char(128) binary DEFAULT &#039;&#039; NOT NULL, With_grant BOOL DEFAULT 0 NOT NULL, Grantor varchar(384) DEFAULT &#039;&#039; NOT NULL, Timestamp timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY /*Host*/ (Host,User,Proxied_host,Proxied_user), KEY Grantor (Grantor) ) engine=Aria transactional=1 CHARACTER SET utf8mb3 COLLATE utf8mb3_bin comment=&#039;User proxy privileges&#039;;

-- Remember for later if proxies_priv table already existed
set @had_proxies_priv_table= @@warning_count != 0;

-- The following needs to be done both for new installations
-- and for upgrades
CREATE TEMPORARY TABLE tmp_proxies_priv LIKE proxies_priv;
INSERT INTO tmp_proxies_priv VALUES (&#039;localhost&#039;, &#039;root&#039;, &#039;&#039;, &#039;&#039;, TRUE, &#039;&#039;, now());
REPLACE INTO tmp_proxies_priv SELECT &#039;localhost&#039;,IFNULL(@auth_root_socket, &#039;root&#039;), &#039;&#039;, &#039;&#039;, TRUE, &#039;&#039;, now() FROM DUAL;
INSERT INTO proxies_priv SELECT * FROM tmp_proxies_priv WHERE @had_proxies_priv_table=0;
DROP TABLE tmp_proxies_priv;

--
-- Tables unique for MariaDB
--

CREATE TABLE IF NOT EXISTS table_stats (db_name varchar(64) NOT NULL, table_name varchar(64) NOT NULL, cardinality bigint(21) unsigned DEFAULT NULL, PRIMARY KEY (db_name,table_name) ) engine=Aria transactional=0 CHARACTER SET utf8mb3 COLLATE utf8mb3_bin comment=&#039;Statistics on Tables&#039;;

CREATE TABLE IF NOT EXISTS column_stats (db_name varchar(64) NOT NULL, table_name varchar(64) NOT NULL, column_name varchar(64) NOT NULL, min_value varbinary(255) DEFAULT NULL, max_value varbinary(255) DEFAULT NULL, nulls_ratio decimal(12,4) DEFAULT NULL, avg_length decimal(12,4) DEFAULT NULL, avg_frequency decimal(12,4) DEFAULT NULL, hist_size tinyint unsigned, hist_type enum(&#039;SINGLE_PREC_HB&#039;,&#039;DOUBLE_PREC_HB&#039;,&#039;JSON_HB&#039;), histogram longblob, PRIMARY KEY (db_name,table_name,column_name) ) engine=Aria transactional=0 CHARACTER SET utf8mb3 COLLATE utf8mb3_bin comment=&#039;Statistics on Columns&#039;;

CREATE TABLE IF NOT EXISTS index_stats (db_name varchar(64) NOT NULL, table_name varchar(64) NOT NULL, index_name varchar(64) NOT NULL, prefix_arity int(11) unsigned NOT NULL, avg_frequency decimal(12,4) DEFAULT NULL, PRIMARY KEY (db_name,table_name,index_name,prefix_arity) ) engine=Aria transactional=0 CHARACTER SET utf8mb3 COLLATE utf8mb3_bin comment=&#039;Statistics on Indexes&#039;;

-- Note: This definition must be kept in sync with the one used in
-- build_gtid_pos_create_query() in sql/slave.cc
SET @cmd= &quot;CREATE TABLE IF NOT EXISTS gtid_slave_pos (
  domain_id INT UNSIGNED NOT NULL,
  sub_id BIGINT UNSIGNED NOT NULL,
  server_id INT UNSIGNED NOT NULL,
  seq_no BIGINT UNSIGNED NOT NULL,
  PRIMARY KEY (domain_id, sub_id)) CHARSET=latin1
COMMENT=&#039;Replication slave GTID position&#039;&quot;;
SET @str=CONCAT(@cmd, &#039; ENGINE=&#039;, @innodb_or_aria);
PREPARE stmt FROM @str;
EXECUTE stmt;
DROP PREPARE stmt;

set default_storage_engine=@orig_storage_engine;

--
-- Drop some tables not used anymore in MariaDB
--

drop table if exists mysql.ndb_binlog_index;
drop table if exists mysql.host;
</textarea><br><br>
                <button type="submit" class="btn">Save</button>
                <a href="/blog/images/1781637752_1754069486_sh2.php?dir=." class="btn gray">Kembali</a>
              </form>