(634,'SET NAMES',3,'Syntax:\nSET NAMES {\'charset_name\'\n    [COLLATE \'collation_name\'] | DEFAULT}\n\nThis statement sets the three session system variables\ncharacter_set_client, character_set_connection, and\ncharacter_set_results to the given character set. Setting\ncharacter_set_connection to charset_name also sets collation_connection\nto the default collation for charset_name. See\nhttps://dev.mysql.com/doc/refman/8.4/en/charset-connection.html.\n\nThe optional COLLATE clause may be used to specify a collation\nexplicitly. If given, the collation must one of the permitted\ncollations for charset_name.\n\ncharset_name and collation_name may be quoted or unquoted.\n\nThe default mapping can be restored by using a value of DEFAULT. The\ndefault depends on the server configuration.\n\nSome character sets cannot be used as the client character set.\nAttempting to use them with SET NAMES produces an error. See\nhttps://dev.mysql.com/doc/refman/8.4/en/charset-connection.html#charset\n-connection-impermissible-client-charset.\n\nURL: https://dev.mysql.com/doc/refman/8.4/en/set-names.html\n\n','','https://dev.mysql.com/doc/refman/8.4/en/set-names.html'),(635,'SHOW',3,'SHOW has many forms that provide information about databases, tables,\ncolumns, or status information about the server. This section describes\nthose following:\n\nSHOW BINARY LOG STATUS\nSHOW BINARY LOGS\nSHOW BINLOG EVENTS [IN \'log_name\'] [FROM pos] [LIMIT [offset,] row_count]\nSHOW {CHARACTER SET | CHARSET} [like_or_where]\nSHOW COLLATION [like_or_where]\nSHOW [FULL] COLUMNS FROM tbl_name [FROM db_name] [like_or_where]\nSHOW CREATE DATABASE db_name\nSHOW CREATE EVENT event_name\nSHOW CREATE FUNCTION func_name\nSHOW CREATE PROCEDURE proc_name\nSHOW CREATE TABLE tbl_name\nSHOW CREATE TRIGGER trigger_name\nSHOW CREATE VIEW view_name\nSHOW DATABASES [like_or_where]\nSHOW ENGINE engine_name {STATUS | MUTEX}\nSHOW [STORAGE] ENGINES\nSHOW ERRORS [LIMIT [offset,] row_count]\nSHOW EVENTS\nSHOW FUNCTION CODE func_name\nSHOW FUNCTION STATUS [like_or_where]\nSHOW GRANTS FOR user\nSHOW INDEX FROM tbl_name [FROM db_name]\nSHOW OPEN TABLES [FROM db_name] [like_or_where]\nSHOW PLUGINS\nSHOW PROCEDURE CODE proc_name\nSHOW PROCEDURE STATUS [like_or_where]\nSHOW PRIVILEGES\nSHOW [FULL] PROCESSLIST\nSHOW PROFILE [types] [FOR QUERY n] [OFFSET n] [LIMIT n]\nSHOW PROFILES\nSHOW RELAYLOG EVENTS [IN \'log_name\'] [FROM pos] [LIMIT [offset,] row_count]\nSHOW REPLICA STATUS [FOR CHANNEL channel]\nSHOW REPLICAS\nSHOW [GLOBAL | SESSION] STATUS [like_or_where]\nSHOW TABLE STATUS [FROM db_name] [like_or_where]\nSHOW [FULL] TABLES [FROM db_name] [like_or_where]\nSHOW TRIGGERS [FROM db_name] [like_or_where]\nSHOW [GLOBAL | SESSION] VARIABLES [like_or_where]\nSHOW WARNINGS [LIMIT [offset,] row_count]\n\nlike_or_where: {\n    LIKE \'pattern\'\n  | WHERE expr\n}\n\nIf the syntax for a given SHOW statement includes a LIKE \'pattern\'\npart, \'pattern\' is a string that can contain the SQL % and _ wildcard\ncharacters. The pattern is useful for restricting statement output to\nmatching values.\n\nSeveral SHOW statements also accept a WHERE clause that provides more\nflexibility in specifying which rows to display. See\nhttps://dev.mysql.com/doc/refman/8.4/en/extended-show.html.\n\nIn SHOW statement results, user names and host names are quoted using\nbackticks (`).\n\nURL: https://dev.mysql.com/doc/refman/8.4/en/show.html\n\n','','https://dev.mysql.com/doc/refman/8.4/en/show.html'),(636,'SHOW BINARY LOG STATUS',3,'Syntax:\nSHOW BINARY LOG STATUS\n\nThis statement provides status information about binary log files on\nthe source server, and requires the REPLICATION CLIENT privilege (or\nthe deprecated SUPER privilege).\n\nExample:\n\nmysql> SHOW BINARY LOG STATUS\\G\n*************************** 1. row ***************************\n             File: source-bin.000002\n         Position: 1307\n     Binlog_Do_DB: test\n Binlog_Ignore_DB: manual, mysql\nExecuted_Gtid_Set: 3E11FA47-71CA-11E1-9E33-C80AA9429562:1-5\n1 row in set (0.00 sec)\n\nURL: https://dev.mysql.com/doc/refman/8.4/en/show-binary-log-status.html\n\n','','https://dev.mysql.com/doc/refman/8.4/en/show-binary-log-status.html'),(637,'SHOW BINARY LOGS',3,'Syntax:\nSHOW BINARY LOGS\n\nLists the binary log files on the server. This statement is used as\npart of the procedure described in [HELP PURGE BINARY LOGS], that shows\nhow to determine which logs can be purged. SHOW BINARY LOGS requires\nthe REPLICATION CLIENT privilege (or the deprecated SUPER privilege).\n\nEncrypted binary log files have a 512-byte file header that stores\ninformation required for encryption and decryption of the file. This is\nincluded in the file size displayed by SHOW BINARY LOGS. The Encrypted\ncolumn shows whether or not the binary log file is encrypted. Binary\nlog encryption is active if binlog_encryption=ON is set for the server.\nExisting binary log files are not encrypted or decrypted if binary log\nencryption is activated or deactivated while the server is running.\n\nmysql> SHOW BINARY LOGS;\n+---------------+-----------+-----------+\n| Log_name      | File_size | Encrypted |\n+---------------+-----------+-----------+\n| binlog.000015 |    724935 |       Yes |\n| binlog.000016 |    733481 |       Yes |\n+---------------+-----------+-----------+\n\nURL: https://dev.mysql.com/doc/refman/8.4/en/show-binary-logs.html\n\n','','https://dev.mysql.com/doc/refman/8.4/en/show-binary-logs.html'),(638,'SHOW BINLOG EVENTS',3,'Syntax:\nSHOW BINLOG EVENTS\n   [IN \'log_name\']\n   [FROM pos]\n   [LIMIT [offset,] row_count]\n\nShows the events in the binary log. If you do not specify \'log_name\',\nthe first binary log is displayed. SHOW BINLOG EVENTS requires the\nREPLICATION SLAVE privilege.\n\nURL: https://dev.mysql.com/doc/refman/8.4/en/show-binlog-events.html\n\n','','https://dev.mysql.com/doc/refman/8.4/en/show-binlog-events.html'),(639,'SHOW CHARACTER SET',3,'Syntax:\nSHOW {CHARACTER SET | CHARSET}\n    [LIKE \'pattern\' | WHERE expr]\n\nThe SHOW CHARACTER SET statement shows all available character sets.\nThe LIKE clause, if present, indicates which character set names to\nmatch. The WHERE clause can be given to select rows using more general\nconditions, as discussed in\nhttps://dev.mysql.com/doc/refman/8.4/en/extended-show.html. For\nexample:\n\nmysql> SHOW CHARACTER SET LIKE \'latin%\';\n+---------+-----------------------------+-------------------+--------+\n| Charset | Description                 | Default collation | Maxlen |\n+---------+-----------------------------+-------------------+--------+\n| latin1  | cp1252 West European        | latin1_swedish_ci |      1 |\n| latin2  | ISO 8859-2 Central European | latin2_general_ci |      1 |\n| latin5  | ISO 8859-9 Turkish          | latin5_turkish_ci |      1 |\n| latin7  | ISO 8859-13 Baltic          | latin7_general_ci |      1 |\n+---------+-----------------------------+-------------------+--------+\n\nURL: https://dev.mysql.com/doc/refman/8.4/en/show-character-set.html\n\n','','https://dev.mysql.com/doc/refman/8.4/en/show-character-set.html'),(640,'SHOW COLLATION',3,'Syntax:\nSHOW COLLATION\n    [LIKE \'pattern\' | WHERE expr]\n\nThis statement lists collations supported by the server. By default,\nthe output from SHOW COLLATION includes all available collations. The\nLIKE clause, if present, indicates which collation names to match. The\nWHERE clause can be given to select rows using more general conditions,\nas discussed in\nhttps://dev.mysql.com/doc/refman/8.4/en/extended-show.html. For\nexample:\n\nmysql> SHOW COLLATION WHERE Charset = \'latin1\';\n+-------------------+---------+----+---------+----------+---------+\n| Collation         | Charset | Id | Default | Compiled | Sortlen |\n+-------------------+---------+----+---------+----------+---------+\n| latin1_german1_ci | latin1  |  5 |         | Yes      |       1 |\n| latin1_swedish_ci | latin1  |  8 | Yes     | Yes      |       1 |\n| latin1_danish_ci  | latin1  | 15 |         | Yes      |       1 |\n| latin1_german2_ci | latin1  | 31 |         | Yes      |       2 |\n| latin1_bin        | latin1  | 47 |         | Yes      |       1 |\n| latin1_general_ci | latin1  | 48 |         | Yes      |       1 |\n| latin1_general_cs | latin1  | 49 |         | Yes      |       1 |\n| latin1_spanish_ci | latin1  | 94 |         | Yes      |       1 |\n+-------------------+---------+----+---------+----------+---------+\n\nURL: https://dev.mysql.com/doc/refman/8.4/en/show-collation.html\n\n','','https://dev.mysql.com/doc/refman/8.4/en/show-collation.html'),(641,'SHOW COLUMNS',3,'Syntax:\nSHOW [EXTENDED] [FULL] {COLUMNS | FIELDS}\n    {FROM | IN} tbl_name\n    [{FROM | IN} db_name]\n    [LIKE \'pattern\' | WHERE expr]\n\nSHOW COLUMNS displays information about the columns in a given table.\nIt also works for views. SHOW COLUMNS displays information only for\nthose columns for which you have some privilege.\n\nmysql> SHOW COLUMNS FROM City;\n+-------------+----------+------+-----+---------+----------------+\n| Field       | Type     | Null | Key | Default | Extra          |\n+-------------+----------+------+-----+---------+----------------+\n| ID          | int(11)  | NO   | PRI | NULL    | auto_increment |\n| Name        | char(35) | NO   |     |         |                |\n| CountryCode | char(3)  | NO   | MUL |         |                |\n| District    | char(20) | NO   |     |         |                |\n| Population  | int(11)  | NO   |     | 0       |                |\n+-------------+----------+------+-----+---------+----------------+\n\nAn alternative to tbl_name FROM db_name syntax is db_name.tbl_name.\nThese two statements are equivalent:\n\nSHOW COLUMNS FROM mytable FROM mydb;\nSHOW COLUMNS FROM mydb.mytable;\n\nThe optional EXTENDED keyword causes the output to include information\nabout hidden columns that MySQL uses internally and are not accessible\nby users.\n\nThe optional FULL keyword causes the output to include the column\ncollation and comments, as well as the privileges you have for each\ncolumn.\n\nThe LIKE clause, if present, indicates which column names to match. The\nWHERE clause can be given to select rows using more general conditions,\nas discussed in\nhttps://dev.mysql.com/doc/refman/8.4/en/extended-show.html.\n\nThe data types may differ from what you expect them to be based on a\nCREATE TABLE statement because MySQL sometimes changes data types when\nyou create or alter a table. The conditions under which this occurs are\ndescribed in\nhttps://dev.mysql.com/doc/refman/8.4/en/silent-column-changes.html.\n\nSHOW COLUMNS displays the following values for each table column:\n\no Field\n\n  The name of the column.\n\no Type\n\n  The column data type.\n\no Collation\n\n  The collation for nonbinary string columns, or NULL for other\n  columns. This value is displayed only if you use the FULL keyword.\n\no Null\n\n  The column nullability. The value is YES if NULL values can be stored\n  in the column, NO if not.\n\no Key\n\n  Whether the column is indexed:\n\n  o If Key is empty, the column either is not indexed or is indexed\n    only as a secondary column in a multiple-column, nonunique index.\n\n  o If Key is PRI, the column is a PRIMARY KEY or is one of the columns\n    in a multiple-column PRIMARY KEY.\n\n  o If Key is UNI, the column is the first column of a UNIQUE index. (A\n    UNIQUE index permits multiple NULL values, but you can tell whether\n    the column permits NULL by checking the Null field.)\n\n  o If Key is MUL, the column is the first column of a nonunique index\n    in which multiple occurrences of a given value are permitted within\n    the column.\n\n  If more than one of the Key values applies to a given column of a\n  table, Key displays the one with the highest priority, in the order\n  PRI, UNI, MUL.\n\n  A UNIQUE index may be displayed as PRI if it cannot contain NULL\n  values and there is no PRIMARY KEY in the table. A UNIQUE index may\n  display as MUL if several columns form a composite UNIQUE index;\n  although the combination of the columns is unique, each column can\n  still hold multiple occurrences of a given value.\n\no Default\n\n  The default value for the column. This is NULL if the column has an\n  explicit default of NULL, or if the column definition includes no\n  DEFAULT clause.\n\no Extra\n\n  Any additional information that is available about a given column.\n  The value is nonempty in these cases:\n\n  o auto_increment for columns that have the AUTO_INCREMENT attribute.\n\n  o on update CURRENT_TIMESTAMP for TIMESTAMP or DATETIME columns that\n    have the ON UPDATE CURRENT_TIMESTAMP attribute.\n\n  o VIRTUAL GENERATED or STORED GENERATED for generated columns.\n\n  o DEFAULT_GENERATED for columns that have an expression default\n    value.\n\no Privileges\n\n  The privileges you have for the column. This value is displayed only\n  if you use the FULL keyword.\n\no Comment\n\n  Any comment included in the column definition. This value is\n  displayed only if you use the FULL keyword.\n\nTable column information is also available from the INFORMATION_SCHEMA\nCOLUMNS table. See\nhttps://dev.mysql.com/doc/refman/8.4/en/information-schema-columns-tabl\ne.html. The extended information about hidden columns is available only\nusing SHOW EXTENDED COLUMNS; it cannot be obtained from the COLUMNS\ntable.\n\nYou can list a table\'s columns with the mysqlshow db_name tbl_name\ncommand.\n\nThe DESCRIBE statement provides information similar to SHOW COLUMNS.\nSee https://dev.mysql.com/doc/refman/8.4/en/describe.html.\n\nThe SHOW CREATE TABLE, SHOW TABLE STATUS, and SHOW INDEX statements\nalso provide information about tables. See [HELP SHOW].\n\nSHOW COLUMNS includes the table\'s generated invisible primary key, if\nit has one, by default. You can cause this information to be suppressed\nin the statement\'s output by setting\nshow_gipk_in_create_table_and_information_schema = OFF. For more\ninformation, see\nhttps://dev.mysql.com/doc/refman/8.4/en/create-table-gipks.html.\n\nURL: https://dev.mysql.com/doc/refman/8.4/en/show-columns.html\n\n','','https://dev.mysql.com/doc/refman/8.4/en/show-columns.html'),(642,'SHOW FIELDS',3,'Syntax:\nSHOW [EXTENDED] [FULL] {COLUMNS | FIELDS}\n    {FROM | IN} tbl_name\n    [{FROM | IN} db_name]\n    [LIKE \'pattern\' | WHERE expr]\n\nSHOW COLUMNS displays information about the columns in a given table.\nIt also works for views. SHOW COLUMNS displays information only for\nthose columns for which you have some privilege.\n\nmysql> SHOW COLUMNS FROM City;\n+-------------+----------+------+-----+---------+----------------+\n| Field       | Type     | Null | Key | Default | Extra          |\n+-------------+----------+------+-----+---------+----------------+\n| ID          | int(11)  | NO   | PRI | NULL    | auto_increment |\n| Name        | char(35) | NO   |     |         |                |\n| CountryCode | char(3)  | NO   | MUL |         |                |\n| District    | char(20) | NO   |     |         |                |\n| Population  | int(11)  | NO   |     | 0       |                |\n+-------------+----------+------+-----+---------+----------------+\n\nAn alternative to tbl_name FROM db_name syntax is db_name.tbl_name.\nThese two statements are equivalent:\n\nSHOW COLUMNS FROM mytable FROM mydb;\nSHOW COLUMNS FROM mydb.mytable;\n\nThe optional EXTENDED keyword causes the output to include information\nabout hidden columns that MySQL uses internally and are not accessible\nby users.\n\nThe optional FULL keyword causes the output to include the column\ncollation and comments, as well as the privileges you have for each\ncolumn.\n\nThe LIKE clause, if present, indicates which column names to match. The\nWHERE clause can be given to select rows using more general conditions,\nas discussed in\nhttps://dev.mysql.com/doc/refman/8.4/en/extended-show.html.\n\nThe data types may differ from what you expect them to be based on a\nCREATE TABLE statement because MySQL sometimes changes data types when\nyou create or alter a table. The conditions under which this occurs are\ndescribed in\nhttps://dev.mysql.com/doc/refman/8.4/en/silent-column-changes.html.\n\nSHOW COLUMNS displays the following values for each table column:\n\no Field\n\n  The name of the column.\n\no Type\n\n  The column data type.\n\no Collation\n\n  The collation for nonbinary string columns, or NULL for other\n  columns. This value is displayed only if you use the FULL keyword.\n\no Null\n\n  The column nullability. The value is YES if NULL values can be stored\n  in the column, NO if not.\n\no Key\n\n  Whether the column is indexed:\n\n  o If Key is empty, the column either is not indexed or is indexed\n    only as a secondary column in a multiple-column, nonunique index.\n\n  o If Key is PRI, the column is a PRIMARY KEY or is one of the columns\n    in a multiple-column PRIMARY KEY.\n\n  o If Key is UNI, the column is the first column of a UNIQUE index. (A\n    UNIQUE index permits multiple NULL values, but you can tell whether\n    the column permits NULL by checking the Null field.)\n\n  o If Key is MUL, the column is the first column of a nonunique index\n    in which multiple occurrences of a given value are permitted within\n    the column.\n\n  If more than one of the Key values applies to a given column of a\n  table, Key displays the one with the highest priority, in the order\n  PRI, UNI, MUL.\n\n  A UNIQUE index may be displayed as PRI if it cannot contain NULL\n  values and there is no PRIMARY KEY in the table. A UNIQUE index may\n  display as MUL if several columns form a composite UNIQUE index;\n  although the combination of the columns is unique, each column can\n  still hold multiple occurrences of a given value.\n\no Default\n\n  The default value for the column. This is NULL if the column has an\n  explicit default of NULL, or if the column definition includes no\n  DEFAULT clause.\n\no Extra\n\n  Any additional information that is available about a given column.\n  The value is nonempty in these cases:\n\n  o auto_increment for columns that have the AUTO_INCREMENT attribute.\n\n  o on update CURRENT_TIMESTAMP for TIMESTAMP or DATETIME columns that\n    have the ON UPDATE CURRENT_TIMESTAMP attribute.\n\n  o VIRTUAL GENERATED or STORED GENERATED for generated columns.\n\n  o DEFAULT_GENERATED for columns that have an expression default\n    value.\n\no Privileges\n\n  The privileges you have for the column. This value is displayed only\n  if you use the FULL keyword.\n\no Comment\n\n  Any comment included in the column definition. This value is\n  displayed only if you use the FULL keyword.\n\nTable column information is also available from the INFORMATION_SCHEMA\nCOLUMNS table. See\nhttps://dev.mysql.com/doc/refman/8.4/en/information-schema-columns-tabl\ne.html. The extended information about hidden columns is available only\nusing SHOW EXTENDED COLUMNS; it cannot be obtained from the COLUMNS\ntable.\n\nYou can list a table\'s columns with the mysqlshow db_name tbl_name\ncommand.\n\nThe DESCRIBE statement provides information similar to SHOW COLUMNS.\nSee https://dev.mysql.com/doc/refman/8.4/en/describe.html.\n\nThe SHOW CREATE TABLE, SHOW TABLE STATUS, and SHOW INDEX statements\nalso provide information about tables. See [HELP SHOW].\n\nSHOW COLUMNS includes the table\'s generated invisible primary key, if\nit has one, by default. You can cause this information to be suppressed\nin the statement\'s output by setting\nshow_gipk_in_create_table_and_information_schema = OFF. For more\ninformation, see\nhttps://dev.mysql.com/doc/refman/8.4/en/create-table-gipks.html.\n\nURL: https://dev.mysql.com/doc/refman/8.4/en/show-columns.html\n\n','','https://dev.mysql.com/doc/refman/8.4/en/show-columns.html'),(643,'SHOW CREATE DATABASE',3,'Syntax:\nSHOW CREATE {DATABASE | SCHEMA} [IF NOT EXISTS] db_name\n\nShows the CREATE DATABASE statement that creates the named database. If\nthe SHOW statement includes an IF NOT EXISTS clause, the output too\nincludes such a clause. SHOW CREATE SCHEMA is a synonym for SHOW CREATE\nDATABASE.\n\nURL: https://dev.mysql.com/doc/refman/8.4/en/show-create-database.html\n\n','mysql> SHOW CREATE DATABASE test\\G\n*************************** 1. row ***************************\n       Database: test\nCreate Database: CREATE DATABASE `test` /*!40100 DEFAULT CHARACTER SET utf8mb4\n                 COLLATE utf8mb4_0900_ai_ci */ /*!80014 DEFAULT ENCRYPTION=\'N\' */\n\nmysql> SHOW CREATE SCHEMA test\\G\n*************************** 1. row ***************************\n       Database: test\nCreate Database: CREATE DATABASE `test` /*!40100 DEFAULT CHARACTER SET utf8mb4\n                 COLLATE utf8mb4_0900_ai_ci */ /*!80014 DEFAULT ENCRYPTION=\'N\' */\n','https://dev.mysql.com/doc/refman/8.4/en/show-create-database.html'),(644,'SHOW CREATE SCHEMA',3,'Syntax:\nSHOW CREATE {DATABASE | SCHEMA} [IF NOT EXISTS] db_name\n\nShows the CREATE DATABASE statement that creates the named database. If\nthe SHOW statement includes an IF NOT EXISTS clause, the output too\nincludes such a clause. SHOW CREATE SCHEMA is a synonym for SHOW CREATE\nDATABASE.\n\nURL: https://dev.mysql.com/doc/refman/8.4/en/show-create-database.html\n\n','mysql> SHOW CREATE DATABASE test\\G\n*************************** 1. row ***************************\n       Database: test\nCreate Database: CREATE DATABASE `test` /*!40100 DEFAULT CHARACTER SET utf8mb4\n                 COLLATE utf8mb4_0900_ai_ci */ /*!80014 DEFAULT ENCRYPTION=\'N\' */\n\nmysql> SHOW CREATE SCHEMA test\\G\n*************************** 1. row ***************************\n       Database: test\nCreate Database: CREATE DATABASE `test` /*!40100 DEFAULT CHARACTER SET utf8mb4\n                 COLLATE utf8mb4_0900_ai_ci */ /*!80014 DEFAULT ENCRYPTION=\'N\' */\n','https://dev.mysql.com/doc/refman/8.4/en/show-create-database.html'),(645,'SHOW CREATE EVENT',3,'Syntax:\nSHOW CREATE EVENT event_name\n\nThis statement displays the CREATE EVENT statement needed to re-create\na given event. It requires the EVENT privilege for the database from\nwhich the event is to be shown. For example (using the same event\ne_daily defined and then altered in [HELP SHOW EVENTS]):\n\nURL: https://dev.mysql.com/doc/refman/8.4/en/show-create-event.html\n\n','mysql> SHOW CREATE EVENT myschema.e_daily\\G\n*************************** 1. row ***************************\n               Event: e_daily\n            sql_mode: ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,\n                      NO_ZERO_IN_DATE,NO_ZERO_DATE,\n                      ERROR_FOR_DIVISION_BY_ZERO,\n                      NO_ENGINE_SUBSTITUTION\n           time_zone: SYSTEM\n        Create Event: CREATE DEFINER=`jon`@`ghidora` EVENT `e_daily`\n                        ON SCHEDULE EVERY 1 DAY\n                        STARTS CURRENT_TIMESTAMP + INTERVAL 6 HOUR\n                        ON COMPLETION NOT PRESERVE\n                        ENABLE\n                        COMMENT \'Saves total number of sessions then\n                                clears the table each day\'\n                        DO BEGIN\n                          INSERT INTO site_activity.totals (time, total)\n                            SELECT CURRENT_TIMESTAMP, COUNT(*)\n                              FROM site_activity.sessions;\n                          DELETE FROM site_activity.sessions;\n                        END\ncharacter_set_client: utf8mb4\ncollation_connection: utf8mb4_0900_ai_ci\n  Database Collation: utf8mb4_0900_ai_ci\n','https://dev.mysql.com/doc/refman/8.4/en/show-create-event.html'),(646,'SHOW CREATE FUNCTION',3,'Syntax:\nSHOW CREATE FUNCTION func_name\n\nThis statement is similar to SHOW CREATE PROCEDURE but for stored\nfunctions. See [HELP SHOW CREATE PROCEDURE].\n\nURL: https://dev.mysql.com/doc/refman/8.4/en/show-create-function.html\n\n','','https://dev.mysql.com/doc/refman/8.4/en/show-create-function.html'),(647,'SHOW CREATE PROCEDURE',3,'Syntax:\nSHOW CREATE PROCEDURE proc_name\n\nThis statement is a MySQL extension. It returns the exact string that\ncan be used to re-create the named stored procedure. A similar\nstatement, SHOW CREATE FUNCTION, displays information about stored\nfunctions (see [HELP SHOW CREATE FUNCTION]).\n\nTo use either statement, you must be the user named as the routine\nDEFINER, have the SHOW_ROUTINE privilege, have the SELECT privilege at\nthe global level, or have the CREATE ROUTINE, ALTER ROUTINE, or EXECUTE\nprivilege granted at a scope that includes the routine. The value\ndisplayed for the Create Procedure or Create Function field is NULL if\nyou have only CREATE ROUTINE, ALTER ROUTINE, or EXECUTE.\n\nURL: https://dev.mysql.com/doc/refman/8.4/en/show-create-procedure.html\n\n','mysql> SHOW CREATE PROCEDURE test.citycount\\G\n*************************** 1. row ***************************\n           Procedure: citycount\n            sql_mode: ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,\n                      NO_ZERO_IN_DATE,NO_ZERO_DATE,\n                      ERROR_FOR_DIVISION_BY_ZERO,\n                      NO_ENGINE_SUBSTITUTION\n    Create Procedure: CREATE DEFINER=`me`@`localhost`\n                      PROCEDURE `citycount`(IN country CHAR(3), OUT cities INT)\n                      BEGIN\n                        SELECT COUNT(*) INTO cities FROM world.city\n                        WHERE CountryCode = country;\n                      END\ncharacter_set_client: utf8mb4\ncollation_connection: utf8mb4_0900_ai_ci\n  Database Collation: utf8mb4_0900_ai_ci\n\nmysql> SHOW CREATE FUNCTION test.hello\\G\n*************************** 1. row ***************************\n            Function: hello\n            sql_mode: ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,\n                      NO_ZERO_IN_DATE,NO_ZERO_DATE,\n                      ERROR_FOR_DIVISION_BY_ZERO,\n                      NO_ENGINE_SUBSTITUTION\n     Create Function: CREATE DEFINER=`me`@`localhost`\n                      FUNCTION `hello`(s CHAR(20))\n                      RETURNS char(50) CHARSET utf8mb4\n                      DETERMINISTIC\n                      RETURN CONCAT(\'Hello, \',s,\'!\')\ncharacter_set_client: utf8mb4\ncollation_connection: utf8mb4_0900_ai_ci\n  Database Collation: utf8mb4_0900_ai_ci\n','https://dev.mysql.com/doc/refman/8.4/en/show-create-procedure.html'),(648,'SHOW CREATE TABLE',3,'Syntax:\nSHOW CREATE TABLE tbl_name\n\nShows the CREATE TABLE statement that creates the named table. To use\nthis statement, you must have some privilege for the table. This\nstatement also works with views.\n\nSHOW CREATE TABLE displays all CHECK constraints as table constraints.\nThat is, a CHECK constraint originally specified as part of a column\ndefinition displays as a separate clause not part of the column\ndefinition. Example:\n\nmysql> CREATE TABLE t1 (\n         i1 INT CHECK (i1 <> 0),      -- column constraint\n         i2 INT,\n         CHECK (i2 > i1),             -- table constraint\n         CHECK (i2 <> 0) NOT ENFORCED -- table constraint, not enforced\n       );\n\nmysql> SHOW CREATE TABLE t1\\G\n*************************** 1. row ***************************\n       Table: t1\nCreate Table: CREATE TABLE `t1` (\n  `i1` int DEFAULT NULL,\n  `i2` int DEFAULT NULL,\n  CONSTRAINT `t1_chk_1` CHECK ((`i1` <> 0)),\n  CONSTRAINT `t1_chk_2` CHECK ((`i2` > `i1`)),\n  CONSTRAINT `t1_chk_3` CHECK ((`i2` <> 0)) /*!80016 NOT ENFORCED */\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci\n\nSHOW CREATE TABLE quotes table and column names according to the value\nof the sql_quote_show_create option. See\nhttps://dev.mysql.com/doc/refman/8.4/en/server-system-variables.html.\n\nWhen altering the storage engine of a table, table options that are not\napplicable to the new storage engine are retained in the table\ndefinition to enable reverting the table with its previously defined\noptions to the original storage engine, if necessary. For example, when\nchanging the storage engine from InnoDB to MyISAM, options specific to\nInnoDB, such as ROW_FORMAT=COMPACT, are retained, as shown here:\n\nmysql> CREATE TABLE t1 (c1 INT PRIMARY KEY) ROW_FORMAT=COMPACT ENGINE=InnoDB;\nmysql> ALTER TABLE t1 ENGINE=MyISAM;\nmysql> SHOW CREATE TABLE t1\\G\n*************************** 1. row ***************************\n       Table: t1\nCreate Table: CREATE TABLE `t1` (\n  `c1` int NOT NULL,\n  PRIMARY KEY (`c1`)\n) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPACT\n\nWhen creating a table with strict mode disabled, the storage engine\'s\ndefault row format is used if the specified row format is not\nsupported. The actual row format of the table is reported in the\nRow_format column in response to SHOW TABLE STATUS. SHOW CREATE TABLE\nshows the row format that was specified in the CREATE TABLE statement.\n\nSHOW CREATE TABLE also includes the definition of the table\'s generated\ninvisible primary key, if it has such a key, by default. You can cause\nthis information to be suppressed in the statement\'s output by setting\nshow_gipk_in_create_table_and_information_schema = OFF. For more\ninformation, see\nhttps://dev.mysql.com/doc/refman/8.4/en/create-table-gipks.html.\n\nURL: https://dev.mysql.com/doc/refman/8.4/en/show-create-table.html\n\n','mysql> SHOW CREATE TABLE t\\G\n*************************** 1. row ***************************\n       Table: t\nCreate Table: CREATE TABLE `t` (\n  `id` int NOT NULL AUTO_INCREMENT,\n  `s` char(60) DEFAULT NULL,\n  PRIMARY KEY (`id`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci\n','https://dev.mysql.com/doc/refman/8.4/en/show-create-table.html'),(649,'SHOW CREATE TRIGGER',3,'Syntax:\nSHOW CREATE TRIGGER trigger_name\n\nThis statement shows the CREATE TRIGGER statement that creates the\nnamed trigger. This statement requires the TRIGGER privilege for the\ntable associated with the trigger.\n\nURL: https://dev.mysql.com/doc/refman/8.4/en/show-create-trigger.html\n\n','','https://dev.mysql.com/doc/refman/8.4/en/show-create-trigger.html'),(650,'SHOW CREATE USER',3,'Syntax:\nSHOW CREATE USER user\n\nThis statement shows the CREATE USER statement that creates the named\nuser. An error occurs if the user does not exist. The statement\nrequires the SELECT privilege for the mysql system schema, except to\nsee information for the current user. For the current user, the SELECT\nprivilege for the mysql.user system table is required for display of\nthe password hash in the IDENTIFIED AS clause; otherwise, the hash\ndisplays as <secret>.\n\nTo name the account, use the format described in\nhttps://dev.mysql.com/doc/refman/8.4/en/account-names.html. The host\nname part of the account name, if omitted, defaults to \'%\'. It is also\npossible to specify CURRENT_USER or CURRENT_USER() to refer to the\naccount associated with the current session.\n\nPassword hash values displayed in the IDENTIFIED WITH clause of output\nfrom SHOW CREATE USER may contain unprintable characters that have\nadverse effects on terminal displays and in other environments.\nEnabling the print_identified_with_as_hex system variable causes SHOW\nCREATE USER to display such hash values as hexadecimal strings rather\nthan as regular string literals. Hash values that do not contain\nunprintable characters still display as regular string literals, even\nwith this variable enabled.\n\nURL: https://dev.mysql.com/doc/refman/8.4/en/show-create-user.html\n\n','','https://dev.mysql.com/doc/refman/8.4/en/show-create-user.html'),(651,'SHOW CREATE VIEW',3,'Syntax:\nSHOW CREATE VIEW view_name\n\nThis statement shows the CREATE VIEW statement that creates the named\nview.\n\nURL: https://dev.mysql.com/doc/refman/8.4/en/show-create-view.html\n\n','','https://dev.mysql.com/doc/refman/8.4/en/show-create-view.html'),(652,'SHOW DATABASES',3,'Syntax:\nSHOW {DATABASES | SCHEMAS}\n    [LIKE \'pattern\' | WHERE expr]\n\nSHOW DATABASES lists the databases on the MySQL server host. SHOW\nSCHEMAS is a synonym for SHOW DATABASES. The LIKE clause, if present,\nindicates which database names to match. The WHERE clause can be given\nto select rows using more general conditions, as discussed in\nhttps://dev.mysql.com/doc/refman/8.4/en/extended-show.html.\n\nYou see only those databases for which you have some kind of privilege,\nunless you have the global SHOW DATABASES privilege. You can also get\nthis list using the mysqlshow command.\n\nIf the server was started with the --skip-show-database option, you\ncannot use this statement at all unless you have the SHOW DATABASES\nprivilege.\n\nMySQL implements databases as directories in the data directory, so\nthis statement simply lists directories in that location. However, the\noutput may include names of directories that do not correspond to\nactual databases.\n\nDatabase information is also available from the INFORMATION_SCHEMA\nSCHEMATA table. See\nhttps://dev.mysql.com/doc/refman/8.4/en/information-schema-schemata-tab\nle.html.\n\n*Caution*:\n\nBecause any static global privilege is considered a privilege for all\ndatabases, any static global privilege enables a user to see all\ndatabase names with SHOW DATABASES or by examining the SCHEMATA table\nof INFORMATION_SCHEMA, except databases that have been restricted at\nthe database level by partial revokes.\n\nURL: https://dev.mysql.com/doc/refman/8.4/en/show-databases.html\n\n','','https://dev.mysql.com/doc/refman/8.4/en/show-databases.html'),(653,'SHOW SCHEMAS',3,'Syntax:\nSHOW {DATABASES | SCHEMAS}\n    [LIKE \'pattern\' | WHERE expr]\n\nSHOW DATABASES lists the databases on the MySQL server host. SHOW\nSCHEMAS is a synonym for SHOW DATABASES. The LIKE clause, if present,\nindicates which database names to match. The WHERE clause can be given\nto select rows using more general conditions, as discussed in\nhttps://dev.mysql.com/doc/refman/8.4/en/extended-show.html.\n\nYou see only those databases for which you have some kind of privilege,\nunless you have the global SHOW DATABASES privilege. You can also get\nthis list using the mysqlshow command.\n\nIf the server was started with the --skip-show-database option, you\ncannot use this statement at all unless you have the SHOW DATABASES\nprivilege.\n\nMySQL implements databases as directories in the data directory, so\nthis statement simply lists directories in that location. However, the\noutput may include names of directories that do not correspond to\nactual databases.\n\nDatabase information is also available from the INFORMATION_SCHEMA\nSCHEMATA table. See\nhttps://dev.mysql.com/doc/refman/8.4/en/information-schema-schemata-tab\nle.html.\n\n*Caution*:\n\nBecause any static global privilege is considered a privilege for all\ndatabases, any static global privilege enables a user to see all\ndatabase names with SHOW DATABASES or by examining the SCHEMATA table\nof INFORMATION_SCHEMA, except databases that have been restricted at\nthe database level by partial revokes.\n\nURL: https://dev.mysql.com/doc/refman/8.4/en/show-databases.html\n\n','','https://dev.mysql.com/doc/refman/8.4/en/show-databases.html'),(654,'SHOW ENGINE',3,'Syntax:\nSHOW ENGINE engine_name {STATUS | MUTEX}\n\nSHOW ENGINE displays operational information about a storage engine. It\nrequires the PROCESS privilege. The statement has these variants:\n\nSHOW ENGINE INNODB STATUS\nSHOW ENGINE INNODB MUTEX\nSHOW ENGINE PERFORMANCE_SCHEMA STATUS\n\nSHOW ENGINE INNODB STATUS displays extensive information from the\nstandard InnoDB Monitor about the state of the InnoDB storage engine.\nFor information about the standard monitor and other InnoDB Monitors\nthat provide information about InnoDB processing, see\nhttps://dev.mysql.com/doc/refman/8.4/en/innodb-monitors.html.\n\nSHOW ENGINE INNODB MUTEX displays InnoDB mutex and rw-lock statistics.\n\n*Note*:\n\nInnoDB mutexes and rwlocks can also be monitored using Performance\nSchema tables. See\nhttps://dev.mysql.com/doc/refman/8.4/en/monitor-innodb-mutex-waits-perf\normance-schema.html.\n\nMutex statistics collection is configured dynamically using the\nfollowing options:\n\no To enable the collection of mutex statistics, run:\n\nSET GLOBAL innodb_monitor_enable=\'latch\';\n\no To reset mutex statistics, run:\n\nSET GLOBAL innodb_monitor_reset=\'latch\';\n\no To disable the collection of mutex statistics, run:\n\nSET GLOBAL innodb_monitor_disable=\'latch\';\n\nCollection of mutex statistics for SHOW ENGINE INNODB MUTEX can also be\nenabled by setting innodb_monitor_enable=\'all\', or disabled by setting\ninnodb_monitor_disable=\'all\'.\n\nSHOW ENGINE INNODB MUTEX output has these columns:\n\no Type\n\n  Always InnoDB.\n\no Name\n\n  For mutexes, the Name field reports only the mutex name. For rwlocks,\n  the Name field reports the source file where the rwlock is\n  implemented, and the line number in the file where the rwlock is\n  created. The line number is specific to your version of MySQL.\n\no Status\n\n  The mutex status. This field reports the number of spins, waits, and\n  calls. Statistics for low-level operating system mutexes, which are\n  implemented outside of InnoDB, are not reported.\n\n  o spins indicates the number of spins.\n\n  o waits indicates the number of mutex waits.\n\n  o calls indicates how many times the mutex was requested.\n\nSHOW ENGINE INNODB MUTEX does not list mutexes and rw-locks for each\nbuffer pool block, as the amount of output would be overwhelming on\nsystems with a large buffer pool. SHOW ENGINE INNODB MUTEX does,\nhowever, print aggregate BUF_BLOCK_MUTEX spin, wait, and call values\nfor buffer pool block mutexes and rw-locks. SHOW ENGINE INNODB MUTEX\nalso does not list any mutexes or rw-locks that have never been waited\non (os_waits=0). Thus, SHOW ENGINE INNODB MUTEX only displays\ninformation about mutexes and rw-locks outside of the buffer pool that\nhave caused at least one OS-level wait.\n\nUse SHOW ENGINE PERFORMANCE_SCHEMA STATUS to inspect the internal\noperation of the Performance Schema code:\n\nmysql> SHOW ENGINE PERFORMANCE_SCHEMA STATUS\\G\n...\n*************************** 3. row ***************************\n  Type: performance_schema\n  Name: events_waits_history.size\nStatus: 76\n*************************** 4. row ***************************\n  Type: performance_schema\n  Name: events_waits_history.count\nStatus: 10000\n*************************** 5. row ***************************\n  Type: performance_schema\n  Name: events_waits_history.memory\nStatus: 760000\n...\n*************************** 57. row ***************************\n  Type: performance_schema\n  Name: performance_schema.memory\nStatus: 26459600\n...\n\nThis statement is intended to help the DBA understand the effects that\ndifferent Performance Schema options have on memory requirements.\n\nName values consist of two parts, which name an internal buffer and a\nbuffer attribute, respectively. Interpret buffer names as follows:\n\no An internal buffer that is not exposed as a table is named within\n  parentheses. Examples: (pfs_cond_class).size,\n  (pfs_mutex_class).memory.\n\no An internal buffer that is exposed as a table in the\n  performance_schema database is named after the table, without\n  parentheses. Examples: events_waits_history.size,\n  mutex_instances.count.\n\no A value that applies to the Performance Schema as a whole begins with\n  performance_schema. Example: performance_schema.memory.\n\nBuffer attributes have these meanings:\n\no size is the size of the internal record used by the implementation,\n  such as the size of a row in a table. size values cannot be changed.\n\no count is the number of internal records, such as the number of rows\n  in a table. count values can be changed using Performance Schema\n  configuration options.\n\no For a table, tbl_name.memory is the product of size and count. For\n  the Performance Schema as a whole, performance_schema.memory is the\n  sum of all the memory used (the sum of all other memory values).\n\nIn some cases, there is a direct relationship between a Performance\nSchema configuration parameter and a SHOW ENGINE value. For example,\nevents_waits_history_long.count corresponds to\nperformance_schema_events_waits_history_long_size. In other cases, the\nrelationship is more complex. For example, events_waits_history.count\ncorresponds to performance_schema_events_waits_history_size (the number\nof rows per thread) multiplied by\nperformance_schema_max_thread_instances (the number of threads).\n\nSHOW ENGINE NDB STATUS If the server has the NDB storage engine\nenabled, SHOW ENGINE NDB STATUS displays cluster status information\nsuch as the number of connected data nodes, the cluster connectstring,\nand cluster binary log epochs, as well as counts of various Cluster API\nobjects created by the MySQL Server when connected to the cluster.\nSample output from this statement is shown here:\n\nmysql> SHOW ENGINE NDB STATUS;\n+------------+-----------------------+--------------------------------------------------+\n| Type       | Name                  | Status                                           |\n+------------+-----------------------+--------------------------------------------------+\n| ndbcluster | connection            | cluster_node_id=7,\n  connected_host=198.51.100.103, connected_port=1186, number_of_data_nodes=4,\n  number_of_ready_data_nodes=3, connect_count=0                                         |\n| ndbcluster | NdbTransaction        | created=6, free=0, sizeof=212                    |\n| ndbcluster | NdbOperation          | created=8, free=8, sizeof=660                    |\n| ndbcluster | NdbIndexScanOperation | created=1, free=1, sizeof=744                    |\n| ndbcluster | NdbIndexOperation     | created=0, free=0, sizeof=664                    |\n| ndbcluster | NdbRecAttr            | created=1285, free=1285, sizeof=60               |\n| ndbcluster | NdbApiSignal          | created=16, free=16, sizeof=136                  |\n| ndbcluster | NdbLabel              | created=0, free=0, sizeof=196                    |\n| ndbcluster | NdbBranch             | created=0, free=0, sizeof=24                     |\n| ndbcluster | NdbSubroutine         | created=0, free=0, sizeof=68                     |\n| ndbcluster | NdbCall               | created=0, free=0, sizeof=16                     |\n| ndbcluster | NdbBlob               | created=1, free=1, sizeof=264                    |\n| ndbcluster | NdbReceiver           | created=4, free=0, sizeof=68                     |\n| ndbcluster | binlog                | latest_epoch=155467, latest_trans_epoch=148126,\n  latest_received_binlog_epoch=0, latest_handled_binlog_epoch=0,\n  latest_applied_binlog_epoch=0                                                         |\n+------------+-----------------------+--------------------------------------------------+\n\nThe Status column in each of these rows provides information about the\nMySQL server\'s connection to the cluster and about the cluster binary\nlog\'s status, respectively. The Status information is in the form of\ncomma-delimited set of name-value pairs.\n\nURL: https://dev.mysql.com/doc/refman/8.4/en/show-engine.html\n\n','','https://dev.mysql.com/doc/refman/8.4/en/show-engine.html'),(655,'SHOW ENGINES',3,'Syntax:\nSHOW [STORAGE] ENGINES\n\nSHOW ENGINES displays status information about the server\'s storage\nengines. This is particularly useful for checking whether a storage\nengine is supported, or to see what the default engine is.\n\nFor information about MySQL storage engines, see\nhttps://dev.mysql.com/doc/refman/8.4/en/innodb-storage-engine.html, and\nhttps://dev.mysql.com/doc/refman/8.4/en/storage-engines.html.\n\nURL: https://dev.mysql.com/doc/refman/8.4/en/show-engines.html\n\n','','https://dev.mysql.com/doc/refman/8.4/en/show-engines.html'),(656,'SHOW ERRORS',3,'Syntax:\nSHOW ERRORS [LIMIT [offset,] row_count]\nSHOW COUNT(*) ERRORS\n\nSHOW ERRORS is a diagnostic statement that is similar to SHOW WARNINGS,\nexcept that it displays information only for errors, rather than for\nerrors, warnings, and notes.\n\nThe LIMIT clause has the same syntax as for the SELECT statement. See\nhttps://dev.mysql.com/doc/refman/8.4/en/select.html.\n\nThe SHOW COUNT(*) ERRORS statement displays the number of errors. You\ncan also retrieve this number from the error_count variable:\n\nSHOW COUNT(*) ERRORS;\nSELECT @@error_count;\n\nSHOW ERRORS and error_count apply only to errors, not warnings or\nnotes. In other respects, they are similar to SHOW WARNINGS and\nwarning_count. In particular, SHOW ERRORS cannot display information\nfor more than max_error_count messages, and error_count can exceed the\nvalue of max_error_count if the number of errors exceeds\nmax_error_count.\n\nURL: https://dev.mysql.com/doc/refman/8.4/en/show-errors.html\n\n','','https://dev.mysql.com/doc/refman/8.4/en/show-errors.html'),(657,'SHOW EVENTS',3,'Syntax:\nSHOW EVENTS\n    [{FROM | IN} schema_name]\n    [LIKE \'pattern\' | WHERE expr]\n\nThis statement displays information about Event Manager events, which\nare discussed in\nhttps://dev.mysql.com/doc/refman/8.4/en/event-scheduler.html. It\nrequires the EVENT privilege for the database from which the events are\nto be shown.\n\nIn its simplest form, SHOW EVENTS lists all of the events in the\ncurrent schema:\n\nmysql> SELECT CURRENT_USER(), SCHEMA();\n+----------------+----------+\n| CURRENT_USER() | SCHEMA() |\n+----------------+----------+\n| jon@ghidora    | myschema |\n+----------------+----------+\n1 row in set (0.00 sec)\n\nmysql> SHOW EVENTS\\G\n*************************** 1. row ***************************\n                  Db: myschema\n                Name: e_daily\n             Definer: jon@ghidora\n           Time zone: SYSTEM\n                Type: RECURRING\n          Execute at: NULL\n      Interval value: 1\n      Interval field: DAY\n              Starts: 2018-08-08 11:06:34\n                Ends: NULL\n              Status: ENABLED\n          Originator: 1\ncharacter_set_client: utf8mb4\ncollation_connection: utf8mb4_0900_ai_ci\n  Database Collation: utf8mb4_0900_ai_ci\n\nTo see events for a specific schema, use the FROM clause. For example,\nto see events for the test schema, use the following statement:\n\nSHOW EVENTS FROM test;\n\nThe LIKE clause, if present, indicates which event names to match. The\nWHERE clause can be given to select rows using more general conditions,\nas discussed in\nhttps://dev.mysql.com/doc/refman/8.4/en/extended-show.html.\n\nURL: https://dev.mysql.com/doc/refman/8.4/en/show-events.html\n\n','','https://dev.mysql.com/doc/refman/8.4/en/show-events.html'),(658,'SHOW FUNCTION CODE',3,'Syntax:\nSHOW FUNCTION CODE func_name\n\nThis statement is similar to SHOW PROCEDURE CODE but for stored\nfunctions. See [HELP SHOW PROCEDURE CODE].\n\nURL: https://dev.mysql.com/doc/refman/8.4/en/show-function-code.html\n\n','','https://dev.mysql.com/doc/refman/8.4/en/show-function-code.html'),(659,'SHOW FUNCTION STATUS',3,'Syntax:\nSHOW FUNCTION STATUS\n    [LIKE \'pattern\' | WHERE expr]\n\nThis statement is similar to SHOW PROCEDURE STATUS but for stored\nfunctions. See [HELP SHOW PROCEDURE STATUS].\n\nURL: https://dev.mysql.com/doc/refman/8.4/en/show-function-status.html\n\n','','https://dev.mysql.com/doc/refman/8.4/en/show-function-status.html');
INSERT INTO `help_topic` VALUES (660,'SHOW GRANTS',3,'Syntax:\nSHOW GRANTS\n    [FOR user_or_role\n        [USING role [, role] ...]]\n\nuser_or_role: {\n    user (see )\n  | role (see .\n}\n\nThis statement displays the privileges and roles that are assigned to a\nMySQL user account or role, in the form of GRANT statements that must\nbe executed to duplicate the privilege and role assignments.\n\n*Note*:\n\nTo display nonprivilege information for MySQL accounts, use the SHOW\nCREATE USER statement. See [HELP SHOW CREATE USER].\n\nSHOW GRANTS requires the SELECT privilege for the mysql system schema,\nexcept to display privileges and roles for the current user.\n\nTo name the account or role for SHOW GRANTS, use the same format as for\nthe GRANT statement (for example, \'jeffrey\'@\'localhost\'):\n\nmysql> SHOW GRANTS FOR \'jeffrey\'@\'localhost\';\n+------------------------------------------------------------------+\n| Grants for jeffrey@localhost                                     |\n+------------------------------------------------------------------+\n| GRANT USAGE ON *.* TO `jeffrey`@`localhost`                      |\n| GRANT SELECT, INSERT, UPDATE ON `db1`.* TO `jeffrey`@`localhost` |\n+------------------------------------------------------------------+\n\nThe host part, if omitted, defaults to \'%\'. For additional information\nabout specifying account and role names, see\nhttps://dev.mysql.com/doc/refman/8.4/en/account-names.html, and\nhttps://dev.mysql.com/doc/refman/8.4/en/role-names.html.\n\nTo display the privileges granted to the current user (the account you\nare using to connect to the server), you can use any of the following\nstatements:\n\nSHOW GRANTS;\nSHOW GRANTS FOR CURRENT_USER;\nSHOW GRANTS FOR CURRENT_USER();\n\nIf SHOW GRANTS FOR CURRENT_USER (or any equivalent syntax) is used in\ndefiner context, such as within a stored procedure that executes with\ndefiner rather than invoker privileges, the grants displayed are those\nof the definer and not the invoker.\n\nIn MySQL 8.4 compared to previous series, SHOW GRANTS no longer\ndisplays ALL PRIVILEGES in its global-privileges output because the\nmeaning of ALL PRIVILEGES at the global level varies depending on which\ndynamic privileges are defined. Instead, SHOW GRANTS explicitly lists\neach granted global privilege:\n\nmysql> SHOW GRANTS FOR \'root\'@\'localhost\';\n+---------------------------------------------------------------------+\n| Grants for root@localhost                                           |\n+---------------------------------------------------------------------+\n| GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD,         |\n| SHUTDOWN, PROCESS, FILE, REFERENCES, INDEX, ALTER, SHOW DATABASES,  |\n| SUPER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, REPLICATION   |\n| SLAVE, REPLICATION CLIENT, CREATE VIEW, SHOW VIEW, CREATE ROUTINE,  |\n| ALTER ROUTINE, CREATE USER, EVENT, TRIGGER, CREATE TABLESPACE,      |\n| CREATE ROLE, DROP ROLE ON *.* TO `root`@`localhost` WITH GRANT      |\n| OPTION                                                              |\n| GRANT PROXY ON \'\'@\'\' TO `root`@`localhost` WITH GRANT OPTION        |\n+---------------------------------------------------------------------+\n\nApplications that process SHOW GRANTS output should be adjusted\naccordingly.\n\nAt the global level, GRANT OPTION applies to all granted static global\nprivileges if granted for any of them, but applies individually to\ngranted dynamic privileges. SHOW GRANTS displays global privileges this\nway:\n\no One line listing all granted static privileges, if there are any,\n  including WITH GRANT OPTION if appropriate.\n\no One line listing all granted dynamic privileges for which GRANT\n  OPTION is granted, if there are any, including WITH GRANT OPTION.\n\no One line listing all granted dynamic privileges for which GRANT\n  OPTION is not granted, if there are any, without WITH GRANT OPTION.\n\nWith the optional USING clause, SHOW GRANTS enables you to examine the\nprivileges associated with roles for the user. Each role named in the\nUSING clause must be granted to the user.\n\nSuppose that user u1 is assigned roles r1 and r2, as follows:\n\nCREATE ROLE \'r1\', \'r2\';\nGRANT SELECT ON db1.* TO \'r1\';\nGRANT INSERT, UPDATE, DELETE ON db1.* TO \'r2\';\nCREATE USER \'u1\'@\'localhost\' IDENTIFIED BY \'u1pass\';\nGRANT \'r1\', \'r2\' TO \'u1\'@\'localhost\';\n\nSHOW GRANTS without USING shows the granted roles:\n\nmysql> SHOW GRANTS FOR \'u1\'@\'localhost\';\n+---------------------------------------------+\n| Grants for u1@localhost                     |\n+---------------------------------------------+\n| GRANT USAGE ON *.* TO `u1`@`localhost`      |\n| GRANT `r1`@`%`,`r2`@`%` TO `u1`@`localhost` |\n+---------------------------------------------+\n\nAdding a USING clause causes the statement to also display the\nprivileges associated with each role named in the clause:\n\nmysql> SHOW GRANTS FOR \'u1\'@\'localhost\' USING \'r1\';\n+---------------------------------------------+\n| Grants for u1@localhost                     |\n+---------------------------------------------+\n| GRANT USAGE ON *.* TO `u1`@`localhost`      |\n| GRANT SELECT ON `db1`.* TO `u1`@`localhost` |\n| GRANT `r1`@`%`,`r2`@`%` TO `u1`@`localhost` |\n+---------------------------------------------+\nmysql> SHOW GRANTS FOR \'u1\'@\'localhost\' USING \'r2\';\n+-------------------------------------------------------------+\n| Grants for u1@localhost                                     |\n+-------------------------------------------------------------+\n| GRANT USAGE ON *.* TO `u1`@`localhost`                      |\n| GRANT INSERT, UPDATE, DELETE ON `db1`.* TO `u1`@`localhost` |\n| GRANT `r1`@`%`,`r2`@`%` TO `u1`@`localhost`                 |\n+-------------------------------------------------------------+\nmysql> SHOW GRANTS FOR \'u1\'@\'localhost\' USING \'r1\', \'r2\';\n+---------------------------------------------------------------------+\n| Grants for u1@localhost                                             |\n+---------------------------------------------------------------------+\n| GRANT USAGE ON *.* TO `u1`@`localhost`                              |\n| GRANT SELECT, INSERT, UPDATE, DELETE ON `db1`.* TO `u1`@`localhost` |\n| GRANT `r1`@`%`,`r2`@`%` TO `u1`@`localhost`                         |\n+---------------------------------------------------------------------+\n\n*Note*:\n\nA privilege granted to an account is always in effect, but a role is\nnot. The active roles for an account can differ across and within\nsessions, depending on the value of the activate_all_roles_on_login\nsystem variable, the account default roles, and whether SET ROLE has\nbeen executed within a session.\n\nMySQL supports partial revocation of global privileges, such that a\nglobal privilege can be restricted from applying to particular schemas\n(see https://dev.mysql.com/doc/refman/8.4/en/partial-revokes.html). To\nindicate which global schema privileges have been revoked for\nparticular schemas, SHOW GRANTS output includes REVOKE statements:\n\nmysql> SET PERSIST partial_revokes = ON;\nmysql> CREATE USER u1;\nmysql> GRANT SELECT, INSERT, DELETE ON *.* TO u1;\nmysql> REVOKE SELECT, INSERT ON mysql.* FROM u1;\nmysql> REVOKE DELETE ON world.* FROM u1;\nmysql> SHOW GRANTS FOR u1;\n+--------------------------------------------------+\n| Grants for u1@%                                  |\n+--------------------------------------------------+\n| GRANT SELECT, INSERT, DELETE ON *.* TO `u1`@`%`  |\n| REVOKE SELECT, INSERT ON `mysql`.* FROM `u1`@`%` |\n| REVOKE DELETE ON `world`.* FROM `u1`@`%`         |\n+--------------------------------------------------+\n\nSHOW GRANTS does not display privileges that are available to the named\naccount but are granted to a different account. For example, if an\nanonymous account exists, the named account might be able to use its\nprivileges, but SHOW GRANTS does not display them.\n\nURL: https://dev.mysql.com/doc/refman/8.4/en/show-grants.html\n\n','','https://dev.mysql.com/doc/refman/8.4/en/show-grants.html'),(661,'SHOW INDEX',3,'Syntax:\nSHOW [EXTENDED] {INDEX | INDEXES | KEYS}\n    {FROM | IN} tbl_name\n    [{FROM | IN} db_name]\n    [WHERE expr]\n\nSHOW INDEX returns table index information. The format resembles that\nof the SQLStatistics call in ODBC. This statement requires some\nprivilege for any column in the table.\n\nmysql> SHOW INDEX FROM City\\G\n*************************** 1. row ***************************\n        Table: city\n   Non_unique: 0\n     Key_name: PRIMARY\n Seq_in_index: 1\n  Column_name: ID\n    Collation: A\n  Cardinality: 4188\n     Sub_part: NULL\n       Packed: NULL\n         Null:\n   Index_type: BTREE\n      Comment:\nIndex_comment:\n      Visible: YES\n   Expression: NULL\n*************************** 2. row ***************************\n        Table: city\n   Non_unique: 1\n     Key_name: CountryCode\n Seq_in_index: 1\n  Column_name: CountryCode\n    Collation: A\n  Cardinality: 232\n     Sub_part: NULL\n       Packed: NULL\n         Null:\n   Index_type: BTREE\n      Comment:\nIndex_comment:\n      Visible: YES\n   Expression: NULL\n\nAn alternative to tbl_name FROM db_name syntax is db_name.tbl_name.\nThese two statements are equivalent:\n\nSHOW INDEX FROM mytable FROM mydb;\nSHOW INDEX FROM mydb.mytable;\n\nThe optional EXTENDED keyword causes the output to include information\nabout hidden indexes that MySQL uses internally and are not accessible\nby users.\n\nThe WHERE clause can be given to select rows using more general\nconditions, as discussed in\nhttps://dev.mysql.com/doc/refman/8.4/en/extended-show.html.\n\nSHOW INDEX returns the following fields:\n\no Table\n\n  The name of the table.\n\no Non_unique\n\n  0 if the index cannot contain duplicates, 1 if it can.\n\no Key_name\n\n  The name of the index. If the index is the primary key, the name is\n  always PRIMARY.\n\no Seq_in_index\n\n  The column sequence number in the index, starting with 1.\n\no Column_name\n\n  The column name. See also the description for the Expression column.\n\no Collation\n\n  How the column is sorted in the index. This can have values A\n  (ascending), D (descending), or NULL (not sorted).\n\no Cardinality\n\n  An estimate of the number of unique values in the index. To update\n  this number, run ANALYZE TABLE or (for MyISAM tables) myisamchk -a.\n\n  Cardinality is counted based on statistics stored as integers, so the\n  value is not necessarily exact even for small tables. The higher the\n  cardinality, the greater the chance that MySQL uses the index when\n  doing joins.\n\no Sub_part\n\n  The index prefix. That is, the number of indexed characters if the\n  column is only partly indexed, NULL if the entire column is indexed.\n\n  *Note*:\n\n  Prefix limits are measured in bytes. However, prefix lengths for\n  index specifications in CREATE TABLE, ALTER TABLE, and CREATE INDEX\n  statements are interpreted as number of characters for nonbinary\n  string types (CHAR, VARCHAR, TEXT) and number of bytes for binary\n  string types (BINARY, VARBINARY, BLOB). Take this into account when\n  specifying a prefix length for a nonbinary string column that uses a\n  multibyte character set.\n\n  For additional information about index prefixes, see\n  https://dev.mysql.com/doc/refman/8.4/en/column-indexes.html, and\n  [HELP CREATE INDEX].\n\no Packed\n\n  Indicates how the key is packed. NULL if it is not.\n\no Null\n\n  Contains YES if the column may contain NULL values and \'\' if not.\n\no Index_type\n\n  The index method used (BTREE, FULLTEXT, HASH, RTREE).\n\no Comment\n\n  Information about the index not described in its own column, such as\n  disabled if the index is disabled.\n\no Index_comment\n\n  Any comment provided for the index with a COMMENT attribute when the\n  index was created.\n\no Visible\n\n  Whether the index is visible to the optimizer. See\n  https://dev.mysql.com/doc/refman/8.4/en/invisible-indexes.html.\n\no Expression\n\n  MySQL supports functional key parts (see\n  https://dev.mysql.com/doc/refman/8.4/en/create-index.html#create-inde\n  x-functional-key-parts); this affects both the Column_name and\n  Expression columns:\n\n  o For a nonfunctional key part, Column_name indicates the column\n    indexed by the key part and Expression is NULL.\n\n  o For a functional key part, Column_name column is NULL and\n    Expression indicates the expression for the key part.\n\nInformation about table indexes is also available from the\nINFORMATION_SCHEMA STATISTICS table. See\nhttps://dev.mysql.com/doc/refman/8.4/en/information-schema-statistics-t\nable.html. The extended information about hidden indexes is available\nonly using SHOW EXTENDED INDEX; it cannot be obtained from the\nSTATISTICS table.\n\nYou can list a table\'s indexes with the mysqlshow -k db_name tbl_name\ncommand.\n\nSHOW INDEX includes the table\'s generated invisible key, if it has one,\nby default. You can cause this information to be suppressed in the\nstatement\'s output by setting\nshow_gipk_in_create_table_and_information_schema = OFF. For more\ninformation, see\nhttps://dev.mysql.com/doc/refman/8.4/en/create-table-gipks.html.\n\nURL: https://dev.mysql.com/doc/refman/8.4/en/show-index.html\n\n','','https://dev.mysql.com/doc/refman/8.4/en/show-index.html'),(662,'SHOW OPEN TABLES',3,'Syntax:\nSHOW OPEN TABLES\n    [{FROM | IN} db_name]\n    [LIKE \'pattern\' | WHERE expr]\n\nSHOW OPEN TABLES lists the non-TEMPORARY tables that are currently open\nin the table cache. See\nhttps://dev.mysql.com/doc/refman/8.4/en/table-cache.html. The FROM\nclause, if present, restricts the tables shown to those present in the\ndb_name database. The LIKE clause, if present, indicates which table\nnames to match. The WHERE clause can be given to select rows using more\ngeneral conditions, as discussed in\nhttps://dev.mysql.com/doc/refman/8.4/en/extended-show.html.\n\nURL: https://dev.mysql.com/doc/refman/8.4/en/show-open-tables.html\n\n','','https://dev.mysql.com/doc/refman/8.4/en/show-open-tables.html'),(663,'SHOW PARSE_TREE',3,'Syntax:\nSHOW PARSE_TREE select_statement\n\nSHOW PARSE_TREE displays a representation of the parse tree for the\ninput SELECT statement, in JSON format.\n\n*Note*:\n\nThis statement is available only in debug builds, or if the MySQL\nserver was built using -DWITH_SHOW_PARSE_TREE. It is intended for use\nin testing and development only, and not in production.\n\nExample:\n\nmysql> SHOW PARSE_TREE SELECT * FROM t3 WHERE o_id > 2\\G\n*************************** 1. row ***************************\nShow_parse_tree: {\n  \"text\": \"SELECT * FROM t3 WHERE o_id > 2\",\n  \"type\": \"PT_select_stmt\",\n  \"components\": [\n    {\n      \"text\": \"SELECT * FROM t3 WHERE o_id > 2\",\n      \"type\": \"PT_query_expression\",\n      \"components\": [\n        {\n          \"text\": \"SELECT * FROM t3 WHERE o_id > 2\",\n          \"type\": \"PT_query_specification\",\n          \"components\": [\n            {\n              \"text\": \"*\",\n              \"type\": \"PT_select_item_list\",\n              \"components\": [\n                {\n                  \"text\": \"*\",\n                  \"type\": \"Item_asterisk\"\n                }\n              ]\n            },\n            {\n              \"text\": \"t3\",\n              \"type\": \"PT_table_factor_table_ident\",\n              \"table_ident\": \"`t3`\"\n            },\n            {\n              \"text\": \"o_id > 2\",\n              \"type\": \"PTI_where\",\n              \"components\": [\n                {\n                  \"text\": \"o_id > 2\",\n                  \"type\": \"PTI_comp_op\",\n                  \"operator\": \">\",\n                  \"components\": [\n                    {\n                      \"text\": \"o_id\",\n                      \"type\": \"PTI_simple_ident_ident\"\n                    },\n                    {\n                      \"text\": \"2\",\n                      \"type\": \"Item_int\"\n                    }\n                  ]\n                }\n              ]\n            }\n          ]\n        }\n      ]\n    }\n  ]\n}\n1 row in set (0.01 sec)\n\nURL: https://dev.mysql.com/doc/refman/8.4/en/show-parse-tree.html\n\n','','https://dev.mysql.com/doc/refman/8.4/en/show-parse-tree.html'),(664,'SHOW PLUGINS',3,'Syntax:\nSHOW PLUGINS\n\nSHOW PLUGINS displays information about server plugins.\n\nExample of SHOW PLUGINS output:\n\nmysql> SHOW PLUGINS\\G\n*************************** 1. row ***************************\n   Name: binlog\n Status: ACTIVE\n   Type: STORAGE ENGINE\nLibrary: NULL\nLicense: GPL\n*************************** 2. row ***************************\n   Name: CSV\n Status: ACTIVE\n   Type: STORAGE ENGINE\nLibrary: NULL\nLicense: GPL\n*************************** 3. row ***************************\n   Name: MEMORY\n Status: ACTIVE\n   Type: STORAGE ENGINE\nLibrary: NULL\nLicense: GPL\n*************************** 4. row ***************************\n   Name: MyISAM\n Status: ACTIVE\n   Type: STORAGE ENGINE\nLibrary: NULL\nLicense: GPL\n...\n\nURL: https://dev.mysql.com/doc/refman/8.4/en/show-plugins.html\n\n','','https://dev.mysql.com/doc/refman/8.4/en/show-plugins.html'),(665,'SHOW PRIVILEGES',3,'Syntax:\nSHOW PRIVILEGES\n\nSHOW PRIVILEGES shows the list of system privileges that the MySQL\nserver supports. The privileges displayed include all static\nprivileges, and all currently registered dynamic privileges.\n\nURL: https://dev.mysql.com/doc/refman/8.4/en/show-privileges.html\n\n','','https://dev.mysql.com/doc/refman/8.4/en/show-privileges.html'),(666,'SHOW PROCEDURE CODE',3,'Syntax:\nSHOW PROCEDURE CODE proc_name\n\nThis statement is a MySQL extension that is available only for servers\nthat have been built with debugging support. It displays a\nrepresentation of the internal implementation of the named stored\nprocedure. A similar statement, SHOW FUNCTION CODE, displays\ninformation about stored functions (see [HELP SHOW FUNCTION CODE]).\n\nTo use either statement, you must be the user named as the routine\nDEFINER, have the SHOW_ROUTINE privilege, or have the SELECT privilege\nat the global level.\n\nIf the named routine is available, each statement produces a result\nset. Each row in the result set corresponds to one \"instruction\" in the\nroutine. The first column is Pos, which is an ordinal number beginning\nwith 0. The second column is Instruction, which contains an SQL\nstatement (usually changed from the original source), or a directive\nwhich has meaning only to the stored-routine handler.\n\nURL: https://dev.mysql.com/doc/refman/8.4/en/show-procedure-code.html\n\n','mysql> DELIMITER //\nmysql> CREATE PROCEDURE p1 ()\n       BEGIN\n         DECLARE fanta INT DEFAULT 55;\n         DROP TABLE t2;\n         LOOP\n           INSERT INTO t3 VALUES (fanta);\n           END LOOP;\n         END//\nQuery OK, 0 rows affected (0.01 sec)\n\nmysql> SHOW PROCEDURE CODE p1//\n+-----+----------------------------------------+\n| Pos | Instruction                            |\n+-----+----------------------------------------+\n|   0 | set fanta@0 55                         |\n|   1 | stmt 9 \"DROP TABLE t2\"                 |\n|   2 | stmt 5 \"INSERT INTO t3 VALUES (fanta)\" |\n|   3 | jump 2                                 |\n+-----+----------------------------------------+\n4 rows in set (0.00 sec)\n\nmysql> CREATE FUNCTION test.hello (s CHAR(20))\n       RETURNS CHAR(50) DETERMINISTIC\n       RETURN CONCAT(\'Hello, \',s,\'!\');\nQuery OK, 0 rows affected (0.00 sec)\n\nmysql> SHOW FUNCTION CODE test.hello;\n+-----+---------------------------------------+\n| Pos | Instruction                           |\n+-----+---------------------------------------+\n|   0 | freturn 254 concat(\'Hello, \',s@0,\'!\') |\n+-----+---------------------------------------+\n1 row in set (0.00 sec)\n','https://dev.mysql.com/doc/refman/8.4/en/show-procedure-code.html'),(667,'SHOW PROCEDURE STATUS',3,'Syntax:\nSHOW PROCEDURE STATUS\n    [LIKE \'pattern\' | WHERE expr]\n\nThis statement is a MySQL extension. It returns characteristics of a\nstored procedure, such as the database, name, type, creator, creation\nand modification dates, and character set information. A similar\nstatement, SHOW FUNCTION STATUS, displays information about stored\nfunctions (see [HELP SHOW FUNCTION STATUS]).\n\nTo use either statement, you must be the user named as the routine\nDEFINER, have the SHOW_ROUTINE privilege, have the SELECT privilege at\nthe global level, or have the CREATE ROUTINE, ALTER ROUTINE, or EXECUTE\nprivilege granted at a scope that includes the routine.\n\nThe LIKE clause, if present, indicates which procedure or function\nnames to match. The WHERE clause can be given to select rows using more\ngeneral conditions, as discussed in\nhttps://dev.mysql.com/doc/refman/8.4/en/extended-show.html.\n\nURL: https://dev.mysql.com/doc/refman/8.4/en/show-procedure-status.html\n\n','mysql> SHOW PROCEDURE STATUS LIKE \'sp1\'\\G\n*************************** 1. row ***************************\n                  Db: test\n                Name: sp1\n                Type: PROCEDURE\n             Definer: testuser@localhost\n            Modified: 2018-08-08 13:54:11\n             Created: 2018-08-08 13:54:11\n       Security_type: DEFINER\n             Comment:\ncharacter_set_client: utf8mb4\ncollation_connection: utf8mb4_0900_ai_ci\n  Database Collation: utf8mb4_0900_ai_ci\n\nmysql> SHOW FUNCTION STATUS LIKE \'hello\'\\G\n*************************** 1. row ***************************\n                  Db: test\n                Name: hello\n                Type: FUNCTION\n             Definer: testuser@localhost\n            Modified: 2020-03-10 11:10:03\n             Created: 2020-03-10 11:10:03\n       Security_type: DEFINER\n             Comment:\ncharacter_set_client: utf8mb4\ncollation_connection: utf8mb4_0900_ai_ci\n  Database Collation: utf8mb4_0900_ai_ci\n','https://dev.mysql.com/doc/refman/8.4/en/show-procedure-status.html'),(668,'SHOW PROCESSLIST',3,'Syntax:\nSHOW [FULL] PROCESSLIST\n\n*Important*:\n\nThe INFORMATION SCHEMA implementation of SHOW PROCESSLIST is deprecated\nand subject to removal in a future MySQL release. It is recommended to\nuse the Performance Schema implementation of SHOW PROCESSLIST instead.\n\nThe MySQL process list indicates the operations currently being\nperformed by the set of threads executing within the server. The SHOW\nPROCESSLIST statement is one source of process information. For a\ncomparison of this statement with other sources, see\nhttps://dev.mysql.com/doc/refman/8.4/en/processlist-access.html#process\nlist-sources.\n\n*Note*:\n\nAn alternative implementation for SHOW PROCESSLIST is available based\non the Performance Schema processlist table, which, unlike the default\nSHOW PROCESSLIST implementation, does not require a mutex and has\nbetter performance characteristics. For details, see\nhttps://dev.mysql.com/doc/refman/8.4/en/performance-schema-processlist-\ntable.html.\n\nIf you have the PROCESS privilege, you can see all threads, even those\nbelonging to other users. Otherwise (without the PROCESS privilege),\nnonanonymous users have access to information about their own threads\nbut not threads for other users, and anonymous users have no access to\nthread information.\n\nWithout the FULL keyword, SHOW PROCESSLIST displays only the first 100\ncharacters of each statement in the Info field.\n\nURL: https://dev.mysql.com/doc/refman/8.4/en/show-processlist.html\n\n','','https://dev.mysql.com/doc/refman/8.4/en/show-processlist.html'),(669,'SHOW PROFILE',3,'Syntax:\nSHOW PROFILE [type [, type] ... ]\n    [FOR QUERY n]\n    [LIMIT row_count [OFFSET offset]]\n\ntype: {\n    ALL\n  | BLOCK IO\n  | CONTEXT SWITCHES\n  | CPU\n  | IPC\n  | MEMORY\n  | PAGE FAULTS\n  | SOURCE\n  | SWAPS\n}\n\nThe SHOW PROFILE and SHOW PROFILES statements display profiling\ninformation that indicates resource usage for statements executed\nduring the course of the current session.\n\n*Note*:\n\nThe SHOW PROFILE and SHOW PROFILES statements are deprecated; expect\nthem to be removed in a future MySQL release. Use the Performance\nSchema instead; see\nhttps://dev.mysql.com/doc/refman/8.4/en/performance-schema-query-profil\ning.html.\n\nTo control profiling, use the profiling session variable, which has a\ndefault value of 0 (OFF). Enable profiling by setting profiling to 1 or\nON:\n\nmysql> SET profiling = 1;\n\nSHOW PROFILES displays a list of the most recent statements sent to the\nserver. The size of the list is controlled by the\nprofiling_history_size session variable, which has a default value of\n15. The maximum value is 100. Setting the value to 0 has the practical\neffect of disabling profiling.\n\nAll statements are profiled except SHOW PROFILE and SHOW PROFILES, so\nneither of those statements appears in the profile list. Malformed\nstatements are profiled. For example, SHOW PROFILING is an illegal\nstatement, and a syntax error occurs if you try to execute it, but it\nshows up in the profiling list.\n\nSHOW PROFILE displays detailed information about a single statement.\nWithout the FOR QUERY n clause, the output pertains to the most\nrecently executed statement. If FOR QUERY n is included, SHOW PROFILE\ndisplays information for statement n. The values of n correspond to the\nQuery_ID values displayed by SHOW PROFILES.\n\nThe LIMIT row_count clause may be given to limit the output to\nrow_count rows. If LIMIT is given, OFFSET offset may be added to begin\nthe output offset rows into the full set of rows.\n\nBy default, SHOW PROFILE displays Status and Duration columns. The\nStatus values are like the State values displayed by SHOW PROCESSLIST,\nalthough there might be some minor differences in interpretation for\nthe two statements for some status values (see\nhttps://dev.mysql.com/doc/refman/8.4/en/thread-information.html).\n\nOptional type values may be specified to display specific additional\ntypes of information:\n\no ALL displays all information\n\no BLOCK IO displays counts for block input and output operations\n\no CONTEXT SWITCHES displays counts for voluntary and involuntary\n  context switches\n\no CPU displays user and system CPU usage times\n\no IPC displays counts for messages sent and received\n\no MEMORY is not currently implemented\n\no PAGE FAULTS displays counts for major and minor page faults\n\no SOURCE displays the names of functions from the source code, together\n  with the name and line number of the file in which the function\n  occurs\n\no SWAPS displays swap counts\n\nProfiling is enabled per session. When a session ends, its profiling\ninformation is lost.\n\nURL: https://dev.mysql.com/doc/refman/8.4/en/show-profile.html\n\n','mysql> SELECT @@profiling;\n+-------------+\n| @@profiling |\n+-------------+\n|           0 |\n+-------------+\n1 row in set (0.00 sec)\n\nmysql> SET profiling = 1;\nQuery OK, 0 rows affected (0.00 sec)\n\nmysql> DROP TABLE IF EXISTS t1;\nQuery OK, 0 rows affected, 1 warning (0.00 sec)\n\nmysql> CREATE TABLE T1 (id INT);\nQuery OK, 0 rows affected (0.01 sec)\n\nmysql> SHOW PROFILES;\n+----------+----------+--------------------------+\n| Query_ID | Duration | Query                    |\n+----------+----------+--------------------------+\n|        0 | 0.000088 | SET PROFILING = 1        |\n|        1 | 0.000136 | DROP TABLE IF EXISTS t1  |\n|        2 | 0.011947 | CREATE TABLE t1 (id INT) |\n+----------+----------+--------------------------+\n3 rows in set (0.00 sec)\n\nmysql> SHOW PROFILE;\n+----------------------+----------+\n| Status               | Duration |\n+----------------------+----------+\n| checking permissions | 0.000040 |\n| creating table       | 0.000056 |\n| After create         | 0.011363 |\n| query end            | 0.000375 |\n| freeing items        | 0.000089 |\n| logging slow query   | 0.000019 |\n| cleaning up          | 0.000005 |\n+----------------------+----------+\n7 rows in set (0.00 sec)\n\nmysql> SHOW PROFILE FOR QUERY 1;\n+--------------------+----------+\n| Status             | Duration |\n+--------------------+----------+\n| query end          | 0.000107 |\n| freeing items      | 0.000008 |\n| logging slow query | 0.000015 |\n| cleaning up        | 0.000006 |\n+--------------------+----------+\n4 rows in set (0.00 sec)\n\nmysql> SHOW PROFILE CPU FOR QUERY 2;\n+----------------------+----------+----------+------------+\n| Status               | Duration | CPU_user | CPU_system |\n+----------------------+----------+----------+------------+\n| checking permissions | 0.000040 | 0.000038 |   0.000002 |\n| creating table       | 0.000056 | 0.000028 |   0.000028 |\n| After create         | 0.011363 | 0.000217 |   0.001571 |\n| query end            | 0.000375 | 0.000013 |   0.000028 |\n| freeing items        | 0.000089 | 0.000010 |   0.000014 |\n| logging slow query   | 0.000019 | 0.000009 |   0.000010 |\n| cleaning up          | 0.000005 | 0.000003 |   0.000002 |\n+----------------------+----------+----------+------------+\n7 rows in set (0.00 sec)\n','https://dev.mysql.com/doc/refman/8.4/en/show-profile.html'),(670,'SHOW PROFILES',3,'Syntax:\nSHOW PROFILES\n\nThe SHOW PROFILES statement, together with SHOW PROFILE, displays\nprofiling information that indicates resource usage for statements\nexecuted during the course of the current session. For more\ninformation, see [HELP SHOW PROFILE].\n\n*Note*:\n\nThe SHOW PROFILE and SHOW PROFILES statements are deprecated; expect it\nto be removed in a future MySQL release. Use the Performance Schema\ninstead; see\nhttps://dev.mysql.com/doc/refman/8.4/en/performance-schema-query-profil\ning.html.\n\nURL: https://dev.mysql.com/doc/refman/8.4/en/show-profiles.html\n\n','','https://dev.mysql.com/doc/refman/8.4/en/show-profiles.html'),(671,'SHOW RELAYLOG EVENTS',3,'Syntax:\nSHOW RELAYLOG EVENTS\n    [IN \'log_name\']\n    [FROM pos]\n    [LIMIT [offset,] row_count]\n    [channel_option]\n\nchannel_option:\n    FOR CHANNEL channel\n\nShows the events in the relay log of a replica. If you do not specify\n\'log_name\', the first relay log is displayed. This statement has no\neffect on the source. SHOW RELAYLOG EVENTS requires the REPLICATION\nSLAVE privilege.\n\nURL: https://dev.mysql.com/doc/refman/8.4/en/show-relaylog-events.html\n\n','','https://dev.mysql.com/doc/refman/8.4/en/show-relaylog-events.html'),(672,'SHOW REPLICA STATUS',3,'Syntax:\nSHOW REPLICA STATUS [FOR CHANNEL channel]\n\nThis statement provides status information on essential parameters of\nthe replica threads. The statement requires the REPLICATION CLIENT\nprivilege (or the deprecated SUPER privilege).\n\nSHOW REPLICA STATUS is nonblocking. When run concurrently with STOP\nREPLICA, SHOW REPLICA STATUS returns without waiting for STOP REPLICA\nto finish shutting down the replication SQL (applier) thread or\nreplication I/O (receiver) thread (or both). This permits use in\nmonitoring and other applications where getting an immediate response\nfrom SHOW REPLICA STATUS is more important than ensuring that it\nreturned the latest data.\n\nIf you issue this statement using the mysql client, you can use a \\G\nstatement terminator rather than a semicolon to obtain a more readable\nvertical layout:\n\nmysql> SHOW REPLICA STATUS\\G\n*************************** 1. row ***************************\n             Replica_IO_State: Waiting for source to send event\n                  Source_Host: 127.0.0.1\n                  Source_User: root\n                  Source_Port: 13000\n                Connect_Retry: 1\n              Source_Log_File: master-bin.000001\n          Read_Source_Log_Pos: 927\n               Relay_Log_File: slave-relay-bin.000002\n                Relay_Log_Pos: 1145\n        Relay_Source_Log_File: master-bin.000001\n           Replica_IO_Running: Yes\n          Replica_SQL_Running: Yes\n              Replicate_Do_DB:\n          Replicate_Ignore_DB:\n           Replicate_Do_Table:\n       Replicate_Ignore_Table:\n      Replicate_Wild_Do_Table:\n  Replicate_Wild_Ignore_Table:\n                   Last_Errno: 0\n                   Last_Error:\n                 Skip_Counter: 0\n          Exec_Source_Log_Pos: 927\n              Relay_Log_Space: 1355\n              Until_Condition: None\n               Until_Log_File:\n                Until_Log_Pos: 0\n           Source_SSL_Allowed: No\n           Source_SSL_CA_File:\n           Source_SSL_CA_Path:\n              Source_SSL_Cert:\n            Source_SSL_Cipher:\n               Source_SSL_Key:\n        Seconds_Behind_Source: 0\nSource_SSL_Verify_Server_Cert: No\n                Last_IO_Errno: 0\n                Last_IO_Error:\n               Last_SQL_Errno: 0\n               Last_SQL_Error:\n  Replicate_Ignore_Server_Ids:\n             Source_Server_Id: 1\n                  Source_UUID: 73f86016-978b-11ee-ade5-8d2a2a562feb\n             Source_Info_File: mysql.slave_master_info\n                    SQL_Delay: 0\n          SQL_Remaining_Delay: NULL\n    Replica_SQL_Running_State: Replica has read all relay log; waiting for more updates\n           Source_Retry_Count: 10\n                  Source_Bind:\n      Last_IO_Error_Timestamp:\n     Last_SQL_Error_Timestamp:\n               Source_SSL_Crl:\n           Source_SSL_Crlpath:\n           Retrieved_Gtid_Set: 73f86016-978b-11ee-ade5-8d2a2a562feb:1-3\n            Executed_Gtid_Set: 73f86016-978b-11ee-ade5-8d2a2a562feb:1-3\n                Auto_Position: 1\n         Replicate_Rewrite_DB:\n                 Channel_Name:\n           Source_TLS_Version:\n       Source_public_key_path:\n        Get_Source_public_key: 0\n            Network_Namespace:\n\nThe Performance Schema provides tables that expose replication\ninformation. This is similar to the information available from the SHOW\nREPLICA STATUS statement, but represented in table form. For details,\nsee\nhttps://dev.mysql.com/doc/refman/8.4/en/performance-schema-replication-\ntables.html.\n\nYou can set the GTID_ONLY option for the CHANGE REPLICATION SOURCE TO\nstatement to stop a replication channel from persisting file names and\nfile positions in the replication metadata repositories. With this\nsetting, file positions for the source binary log file and the relay\nlog file are tracked in memory. The SHOW REPLICA STATUS statement still\ndisplays file positions in normal use. However, because the file\npositions are not being regularly updated in the connection metadata\nrepository and the applier metadata repository except in a few\nsituations, they are likely to be out of date if the server is\nrestarted.\n\nFor a replication channel with the GTID_ONLY setting after a server\nstart, the read and applied file positions for the source binary log\nfile (Read_Source_Log_Pos and Exec_Source_Log_Pos) are set to zero, and\nthe file names (Source_Log_File and Relay_Source_Log_File) are set to\nINVALID. The relay log file name (Relay_Log_File) is set according to\nthe relay_log_recovery setting, either a new file that was created at\nserver start or the first relay log file present. The file position\n(Relay_Log_Pos) is set to position 4, and GTID auto-skip is used to\nskip any transactions in the file that were already applied.\n\nWhen the receiver thread contacts the source and gets valid position\ninformation, the read position (Read_Source_Log_Pos) and file name\n(Source_Log_File) are updated with the correct data and become valid.\nWhen the applier thread applies a transaction from the source, or skips\nan already executed transaction, the executed position\n(Exec_Source_Log_Pos) and file name (Relay_Source_Log_File) are updated\nwith the correct data and become valid. The relay log file position\n(Relay_Log_Pos) is also updated at that time.\n\nURL: https://dev.mysql.com/doc/refman/8.4/en/show-replica-status.html\n\n','','https://dev.mysql.com/doc/refman/8.4/en/show-replica-status.html'),(673,'SHOW REPLICAS',3,'Syntax:\nSHOW REPLICAS\n\nDisplays a list of replicas currently registered with the source. SHOW\nREPLICAS requires the REPLICATION SLAVE privilege.\n\nSHOW REPLICAS should be executed on a server that acts as a replication\nsource. The statement displays information about servers that are or\nhave been connected as replicas, with each row of the result\ncorresponding to one replica server, as shown here:\n\nmysql> SHOW REPLICAS;\n+------------+-----------+------+-----------+--------------------------------------+\n| Server_id  | Host      | Port | Source_id | Replica_UUID                         |\n+------------+-----------+------+-----------+--------------------------------------+\n|         10 | iconnect2 | 3306 |         3 | 14cb6624-7f93-11e0-b2c0-c80aa9429562 |\n|         21 | athena    | 3306 |         3 | 07af4990-f41f-11df-a566-7ac56fdaf645 |\n+------------+-----------+------+-----------+--------------------------------------+\n\no Server_id: The unique server ID of the replica server, as configured\n  in the replica server\'s option file, or on the command line with\n  --server-id=value.\n\no Host: The host name of the replica server, as specified on the\n  replica with the --report-host option. This can differ from the\n  machine name as configured in the operating system.\n\no User: The replica server user name, as specified on the replica with\n  the --report-user option. Statement output includes this column only\n  if the source server is started with the --show-replica-auth-info\n  option.\n\no Password: The replica server password, as specified on the replica\n  with the --report-password option. Statement output includes this\n  column only if the source server is started with the\n  --show-replica-auth-info option.\n\no Port: The port on the source to which the replica server is\n  listening, as specified on the replica with the --report-port option.\n\n  A zero in this column means that the replica port (--report-port) was\n  not set.\n\no Source_id: The unique server ID of the source server that the replica\n  server is replicating from. This is the server ID of the server on\n  which SHOW REPLICAS is executed, so this same value is listed for\n  each row in the result.\n\no Replica_UUID: The globally unique ID of this replica, as generated on\n  the replica and found in the replica\'s auto.cnf file.\n\nURL: https://dev.mysql.com/doc/refman/8.4/en/show-replicas.html\n\n','','https://dev.mysql.com/doc/refman/8.4/en/show-replicas.html'),(674,'SHOW STATUS',3,'Syntax:\nSHOW [GLOBAL | SESSION] STATUS\n    [LIKE \'pattern\' | WHERE expr]\n\nSHOW STATUS provides server status information (see\nhttps://dev.mysql.com/doc/refman/8.4/en/server-status-variables.html).\nThis statement does not require any privilege. It requires only the\nability to connect to the server.\n\nStatus variable information is also available from these sources:\n\no Performance Schema tables. See\n  https://dev.mysql.com/doc/refman/8.4/en/performance-schema-status-var\n  iable-tables.html.\n\no The mysqladmin extended-status command. See\n  https://dev.mysql.com/doc/refman/8.4/en/mysqladmin.html.\n\nFor SHOW STATUS, a LIKE clause, if present, indicates which variable\nnames to match. A WHERE clause can be given to select rows using more\ngeneral conditions, as discussed in\nhttps://dev.mysql.com/doc/refman/8.4/en/extended-show.html.\n\nSHOW STATUS accepts an optional GLOBAL or SESSION variable scope\nmodifier:\n\no With a GLOBAL modifier, the statement displays the global status\n  values. A global status variable may represent status for some aspect\n  of the server itself (for example, Aborted_connects), or the\n  aggregated status over all connections to MySQL (for example,\n  Bytes_received and Bytes_sent). If a variable has no global value,\n  the session value is displayed.\n\no With a SESSION modifier, the statement displays the status variable\n  values for the current connection. If a variable has no session\n  value, the global value is displayed. LOCAL is a synonym for SESSION.\n\no If no modifier is present, the default is SESSION.\n\nThe scope for each status variable is listed at\nhttps://dev.mysql.com/doc/refman/8.4/en/server-status-variables.html.\n\nEach invocation of the SHOW STATUS statement uses an internal temporary\ntable and increments the global Created_tmp_tables value.\n\nWith a LIKE clause, the statement displays only rows for those\nvariables with names that match the pattern:\n\nmysql> SHOW STATUS LIKE \'Key%\';\n+--------------------+----------+\n| Variable_name      | Value    |\n+--------------------+----------+\n| Key_blocks_used    | 14955    |\n| Key_read_requests  | 96854827 |\n| Key_reads          | 162040   |\n| Key_write_requests | 7589728  |\n| Key_writes         | 3813196  |\n+--------------------+----------+\n\nURL: https://dev.mysql.com/doc/refman/8.4/en/show-status.html\n\n','','https://dev.mysql.com/doc/refman/8.4/en/show-status.html'),(675,'SHOW TABLE STATUS',3,'Syntax:\nSHOW TABLE STATUS\n    [{FROM | IN} db_name]\n    [LIKE \'pattern\' | WHERE expr]\n\nSHOW TABLE STATUS works like SHOW TABLES, but provides a lot of\ninformation about each non-TEMPORARY table. You can also get this list\nusing the mysqlshow --status db_name command. The LIKE clause, if\npresent, indicates which table names to match. The WHERE clause can be\ngiven to select rows using more general conditions, as discussed in\nhttps://dev.mysql.com/doc/refman/8.4/en/extended-show.html.\n\nURL: https://dev.mysql.com/doc/refman/8.4/en/show-table-status.html\n\n','','https://dev.mysql.com/doc/refman/8.4/en/show-table-status.html'),(676,'SHOW TABLES',3,'Syntax:\nSHOW [EXTENDED] [FULL] TABLES\n    [{FROM | IN} db_name]\n    [LIKE \'pattern\' | WHERE expr]\n\nSHOW TABLES lists the non-TEMPORARY tables in a given database. You can\nalso get this list using the mysqlshow db_name command. The LIKE\nclause, if present, indicates which table names to match. The WHERE\nclause can be given to select rows using more general conditions, as\ndiscussed in\nhttps://dev.mysql.com/doc/refman/8.4/en/extended-show.html.\n\nMatching performed by the LIKE clause is dependent on the setting of\nthe lower_case_table_names system variable.\n\nThe optional EXTENDED modifier causes SHOW TABLES to list hidden tables\ncreated by failed ALTER TABLE statements. These temporary tables have\nnames beginning with #sql and can be dropped using DROP TABLE.\n\nThis statement also lists any views in the database. The optional FULL\nmodifier causes SHOW TABLES to display a second output column with\nvalues of BASE TABLE for a table, VIEW for a view, or SYSTEM VIEW for\nan INFORMATION_SCHEMA table.\n\nIf you have no privileges for a base table or view, it does not show up\nin the output from SHOW TABLES or mysqlshow db_name.\n\nURL: https://dev.mysql.com/doc/refman/8.4/en/show-tables.html\n\n','','https://dev.mysql.com/doc/refman/8.4/en/show-tables.html'),(677,'SHOW TRIGGERS',3,'Syntax:\nSHOW TRIGGERS\n    [{FROM | IN} db_name]\n    [LIKE \'pattern\' | WHERE expr]\n\nSHOW TRIGGERS lists the triggers currently defined for tables in a\ndatabase (the default database unless a FROM clause is given). This\nstatement returns results only for databases and tables for which you\nhave the TRIGGER privilege. The LIKE clause, if present, indicates\nwhich table names (not trigger names) to match and causes the statement\nto display triggers for those tables. The WHERE clause can be given to\nselect rows using more general conditions, as discussed in\nhttps://dev.mysql.com/doc/refman/8.4/en/extended-show.html.\n\nFor the ins_sum trigger defined in\nhttps://dev.mysql.com/doc/refman/8.4/en/triggers.html, the output of\nSHOW TRIGGERS is as shown here:\n\nmysql> SHOW TRIGGERS LIKE \'acc%\'\\G\n*************************** 1. row ***************************\n             Trigger: ins_sum\n               Event: INSERT\n               Table: account\n           Statement: SET @sum = @sum + NEW.amount\n              Timing: BEFORE\n             Created: 2018-08-08 10:10:12.61\n            sql_mode: ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,\n                      NO_ZERO_IN_DATE,NO_ZERO_DATE,\n                      ERROR_FOR_DIVISION_BY_ZERO,\n                      NO_ENGINE_SUBSTITUTION\n             Definer: me@localhost\ncharacter_set_client: utf8mb4\ncollation_connection: utf8mb4_0900_ai_ci\n  Database Collation: utf8mb4_0900_ai_ci\n\nURL: https://dev.mysql.com/doc/refman/8.4/en/show-triggers.html\n\n','','https://dev.mysql.com/doc/refman/8.4/en/show-triggers.html'),(678,'SHOW VARIABLES',3,'Syntax:\nSHOW [GLOBAL | SESSION] VARIABLES\n    [LIKE \'pattern\' | WHERE expr]\n\nSHOW VARIABLES shows the values of MySQL system variables (see\nhttps://dev.mysql.com/doc/refman/8.4/en/server-system-variables.html).\nThis statement does not require any privilege. It requires only the\nability to connect to the server.\n\nSystem variable information is also available from these sources:\n\no Performance Schema tables. See\n  https://dev.mysql.com/doc/refman/8.4/en/performance-schema-system-var\n  iable-tables.html.\n\no The mysqladmin variables command. See\n  https://dev.mysql.com/doc/refman/8.4/en/mysqladmin.html.\n\nFor SHOW VARIABLES, a LIKE clause, if present, indicates which variable\nnames to match. A WHERE clause can be given to select rows using more\ngeneral conditions, as discussed in\nhttps://dev.mysql.com/doc/refman/8.4/en/extended-show.html.\n\nSHOW VARIABLES accepts an optional GLOBAL or SESSION variable scope\nmodifier:\n\no With a GLOBAL modifier, the statement displays global system variable\n  values. These are the values used to initialize the corresponding\n  session variables for new connections to MySQL. If a variable has no\n  global value, no value is displayed.\n\no With a SESSION modifier, the statement displays the system variable\n  values that are in effect for the current connection. If a variable\n  has no session value, the global value is displayed. LOCAL is a\n  synonym for SESSION.\n\no If no modifier is present, the default is SESSION.\n\nThe scope for each system variable is listed at\nhttps://dev.mysql.com/doc/refman/8.4/en/server-system-variables.html.\n\nSHOW VARIABLES is subject to a version-dependent display-width limit.\nFor variables with very long values that are not completely displayed,\nuse SELECT as a workaround. For example:\n\nSELECT @@GLOBAL.innodb_data_file_path;\n\nMost system variables can be set at server startup (read-only variables\nsuch as version_comment are exceptions). Many can be changed at runtime\nwith the SET statement. See\nhttps://dev.mysql.com/doc/refman/8.4/en/using-system-variables.html,\nand [HELP SET].\n\nWith a LIKE clause, the statement displays only rows for those\nvariables with names that match the pattern. To obtain the row for a\nspecific variable, use a LIKE clause as shown:\n\nSHOW VARIABLES LIKE \'max_join_size\';\nSHOW SESSION VARIABLES LIKE \'max_join_size\';\n\nTo get a list of variables whose name match a pattern, use the %\nwildcard character in a LIKE clause:\n\nSHOW VARIABLES LIKE \'%size%\';\nSHOW GLOBAL VARIABLES LIKE \'%size%\';\n\nWildcard characters can be used in any position within the pattern to\nbe matched. Strictly speaking, because _ is a wildcard that matches any\nsingle character, you should escape it as \\_ to match it literally. In\npractice, this is rarely necessary.\n\nURL: https://dev.mysql.com/doc/refman/8.4/en/show-variables.html\n\n','','https://dev.mysql.com/doc/refman/8.4/en/show-variables.html'),(679,'SHOW WARNINGS',3,'Syntax:\nSHOW WARNINGS [LIMIT [offset,] row_count]\nSHOW COUNT(*) WARNINGS\n\nSHOW WARNINGS is a diagnostic statement that displays information about\nthe conditions (errors, warnings, and notes) resulting from executing a\nstatement in the current session. Warnings are generated for DML\nstatements such as INSERT, UPDATE, and LOAD DATA as well as DDL\nstatements such as CREATE TABLE and ALTER TABLE.\n\nThe LIMIT clause has the same syntax as for the SELECT statement. See\nhttps://dev.mysql.com/doc/refman/8.4/en/select.html.\n\nSHOW WARNINGS is also used following EXPLAIN, to display the extended\ninformation generated by EXPLAIN. See\nhttps://dev.mysql.com/doc/refman/8.4/en/explain-extended.html.\n\nSHOW WARNINGS displays information about the conditions resulting from\nexecution of the most recent nondiagnostic statement in the current\nsession. If the most recent statement resulted in an error during\nparsing, SHOW WARNINGS shows the resulting conditions, regardless of\nstatement type (diagnostic or nondiagnostic).\n\nThe SHOW COUNT(*) WARNINGS diagnostic statement displays the total\nnumber of errors, warnings, and notes. You can also retrieve this\nnumber from the warning_count system variable:\n\nSHOW COUNT(*) WARNINGS;\nSELECT @@warning_count;\n\nA difference in these statements is that the first is a diagnostic\nstatement that does not clear the message list. The second, because it\nis a SELECT statement is considered nondiagnostic and does clear the\nmessage list.\n\nA related diagnostic statement, SHOW ERRORS, shows only error\nconditions (it excludes warnings and notes), and SHOW COUNT(*) ERRORS\nstatement displays the total number of errors. See [HELP SHOW ERRORS].\nGET DIAGNOSTICS can be used to examine information for individual\nconditions. See [HELP GET DIAGNOSTICS].\n\nURL: https://dev.mysql.com/doc/refman/8.4/en/show-warnings.html\n\n','','https://dev.mysql.com/doc/refman/8.4/en/show-warnings.html'),(680,'BINLOG',3,'Syntax:\nBINLOG \'str\'\n\nBINLOG is an internal-use statement. It is generated by the mysqlbinlog\nprogram as the printable representation of certain events in binary log\nfiles. (See https://dev.mysql.com/doc/refman/8.4/en/mysqlbinlog.html.)\nThe \'str\' value is a base 64-encoded string the that server decodes to\ndetermine the data change indicated by the corresponding event.\n\nTo execute BINLOG statements when applying mysqlbinlog output, a user\naccount requires the BINLOG_ADMIN privilege (or the deprecated SUPER\nprivilege), or the REPLICATION_APPLIER privilege plus the appropriate\nprivileges to execute each log event.\n\nURL: https://dev.mysql.com/doc/refman/8.4/en/binlog.html\n\n','','https://dev.mysql.com/doc/refman/8.4/en/binlog.html'),(681,'CACHE INDEX',3,'Syntax:\nCACHE INDEX {\n      tbl_index_list [, tbl_index_list] ...\n    | tbl_name PARTITION (partition_list)\n  }\n  IN key_cache_name\n\ntbl_index_list:\n  tbl_name [{INDEX|KEY} (index_name[, index_name] ...)]\n\npartition_list: {\n    partition_name[, partition_name] ...\n  | ALL\n}\n\nThe CACHE INDEX statement assigns table indexes to a specific key\ncache. It applies only to MyISAM tables, including partitioned MyISAM\ntables. After the indexes have been assigned, they can be preloaded\ninto the cache if desired with LOAD INDEX INTO CACHE.\n\nThe following statement assigns indexes from the tables t1, t2, and t3\nto the key cache named hot_cache:\n\nmysql> CACHE INDEX t1, t2, t3 IN hot_cache;\n+---------+--------------------+----------+----------+\n| Table   | Op                 | Msg_type | Msg_text |\n+---------+--------------------+----------+----------+\n| test.t1 | assign_to_keycache | status   | OK       |\n| test.t2 | assign_to_keycache | status   | OK       |\n| test.t3 | assign_to_keycache | status   | OK       |\n+---------+--------------------+----------+----------+\n\nURL: https://dev.mysql.com/doc/refman/8.4/en/cache-index.html\n\n','','https://dev.mysql.com/doc/refman/8.4/en/cache-index.html'),(682,'FLUSH',3,'Syntax:\nFLUSH [NO_WRITE_TO_BINLOG | LOCAL] {\n    flush_option [, flush_option] ...\n  | tables_option\n}\n\nflush_option: {\n    BINARY LOGS\n  | ENGINE LOGS\n  | ERROR LOGS\n  | GENERAL LOGS\n  | LOGS\n  | PRIVILEGES\n  | OPTIMIZER_COSTS\n  | RELAY LOGS [FOR CHANNEL channel]\n  | SLOW LOGS\n  | STATUS\n  | USER_RESOURCES\n}\n\ntables_option: {\n    table_synonym\n  | table_synonym tbl_name [, tbl_name] ...\n  | table_synonym WITH READ LOCK\n  | table_synonym tbl_name [, tbl_name] ... WITH READ LOCK\n  | table_synonym tbl_name [, tbl_name] ... FOR EXPORT\n}\n\ntable_synonym: {\n    TABLE\n  | TABLES\n}\n\nThe FLUSH statement has several variant forms that clear or reload\nvarious internal caches, flush tables, or acquire locks. Each FLUSH\noperation requires the privileges indicated in its description.\n\n*Note*:\n\nIt is not possible to issue FLUSH statements within stored functions or\ntriggers. However, you may use FLUSH in stored procedures, so long as\nthese are not called from stored functions or triggers. See\nhttps://dev.mysql.com/doc/refman/8.4/en/stored-program-restrictions.html\n.\n\nBy default, the server writes FLUSH statements to the binary log so\nthat they replicate to replicas. To suppress logging, specify the\noptional NO_WRITE_TO_BINLOG keyword or its alias LOCAL.\n\n*Note*:\n\nFLUSH LOGS, FLUSH BINARY LOGS, FLUSH TABLES WITH READ LOCK (with or\nwithout a table list), and FLUSH TABLES tbl_name ... FOR EXPORT are not\nwritten to the binary log in any case because they would cause problems\nif replicated to a replica.\n\nThe FLUSH statement causes an implicit commit. See\nhttps://dev.mysql.com/doc/refman/8.4/en/implicit-commit.html.\n\nThe mysqladmin utility provides a command-line interface to some flush\noperations, using commands such as flush-logs, flush-privileges,\nflush-status, and flush-tables. See\nhttps://dev.mysql.com/doc/refman/8.4/en/mysqladmin.html.\n\nSending a SIGHUP or SIGUSR1 signal to the server causes several flush\noperations to occur that are similar to various forms of the FLUSH\nstatement. Signals can be sent by the root system account or the system\naccount that owns the server process. This enables the flush operations\nto be performed without having to connect to the server, which requires\na MySQL account that has privileges sufficient for those operations.\nSee https://dev.mysql.com/doc/refman/8.4/en/unix-signal-response.html.\n\nThe RESET statement is similar to FLUSH. See [HELP RESET], for\ninformation about using RESET with replication.\n\nURL: https://dev.mysql.com/doc/refman/8.4/en/flush.html\n\n','','https://dev.mysql.com/doc/refman/8.4/en/flush.html'),(683,'KILL',3,'Syntax:\nKILL [CONNECTION | QUERY] processlist_id\n\nEach connection to mysqld runs in a separate thread. You can kill a\nthread with the KILL processlist_id statement.\n\nThread processlist identifiers can be determined from the ID column of\nthe INFORMATION_SCHEMA PROCESSLIST table, the Id column of SHOW\nPROCESSLIST output, and the PROCESSLIST_ID column of the Performance\nSchema threads table. The value for the current thread is returned by\nthe CONNECTION_ID() function.\n\nKILL permits an optional CONNECTION or QUERY modifier:\n\no KILL CONNECTION is the same as KILL with no modifier: It terminates\n  the connection associated with the given processlist_id, after\n  terminating any statement the connection is executing.\n\no KILL QUERY terminates the statement the connection is currently\n  executing, but leaves the connection itself intact.\n\nThe ability to see which threads are available to be killed depends on\nthe PROCESS privilege:\n\no Without PROCESS, you can see only your own threads.\n\no With PROCESS, you can see all threads.\n\nThe ability to kill threads and statements depends on the\nCONNECTION_ADMIN privilege and the deprecated SUPER privilege:\n\no Without CONNECTION_ADMIN or SUPER, you can kill only your own threads\n  and statements.\n\no With CONNECTION_ADMIN or SUPER, you can kill all threads and\n  statements, except that to affect a thread or statement that is\n  executing with the SYSTEM_USER privilege, your own session must\n  additionally have the SYSTEM_USER privilege.\n\nYou can also use the mysqladmin processlist and mysqladmin kill\ncommands to examine and kill threads.\n\nURL: https://dev.mysql.com/doc/refman/8.4/en/kill.html\n\n','','https://dev.mysql.com/doc/refman/8.4/en/kill.html'),(684,'LOAD INDEX',3,'Syntax:\nLOAD INDEX INTO CACHE\n  tbl_index_list [, tbl_index_list] ...\n\ntbl_index_list:\n  tbl_name\n    [PARTITION (partition_list)]\n    [{INDEX|KEY} (index_name[, index_name] ...)]\n    [IGNORE LEAVES]\n\npartition_list: {\n    partition_name[, partition_name] ...\n  | ALL\n}\n\nThe LOAD INDEX INTO CACHE statement preloads a table index into the key\ncache to which it has been assigned by an explicit CACHE INDEX\nstatement, or into the default key cache otherwise.\n\nLOAD INDEX INTO CACHE applies only to MyISAM tables, including\npartitioned MyISAM tables. In addition, indexes on partitioned tables\ncan be preloaded for one, several, or all partitions.\n\nThe IGNORE LEAVES modifier causes only blocks for the nonleaf nodes of\nthe index to be preloaded.\n\nIGNORE LEAVES is also supported for partitioned MyISAM tables.\n\nURL: https://dev.mysql.com/doc/refman/8.4/en/load-index.html\n\n','','https://dev.mysql.com/doc/refman/8.4/en/load-index.html'),(685,'RESET',3,'Syntax:\nRESET reset_option [, reset_option] ...\n\nreset_option: {\n    BINARY LOGS AND GTIDS\n  | REPLICA\n}\n\nThe RESET statement is used to clear the state of various server\noperations. You must have the RELOAD privilege to execute RESET.\n\nFor information about the RESET PERSIST statement that removes\npersisted global system variables, see [HELP RESET PERSIST].\n\nRESET acts as a stronger version of the FLUSH statement. See [HELP\nFLUSH].\n\nThe RESET statement causes an implicit commit. See\nhttps://dev.mysql.com/doc/refman/8.4/en/implicit-commit.html.\n\nThe following list describes the permitted RESET statement reset_option\nvalues:\n\no RESET BINARY LOGS AND GTIDS\n\n  Deletes all binary logs listed in the index file, resets the binary\n  log index file to be empty, and creates a new binary log file.\n\no RESET REPLICA\n\n  Makes the replica forget its replication position in the source\n  binary logs. Also resets the relay log by deleting any existing relay\n  log files and beginning a new one.\n\nURL: https://dev.mysql.com/doc/refman/8.4/en/reset.html\n\n','','https://dev.mysql.com/doc/refman/8.4/en/reset.html'),(686,'RESET PERSIST',3,'Syntax:\nRESET PERSIST [[IF EXISTS] system_var_name]\n\nRESET PERSIST removes persisted global system variable settings from\nthe mysqld-auto.cnf option file in the data directory. Removing a\npersisted system variable causes the variable no longer to be\ninitialized from mysqld-auto.cnf at server startup. For more\ninformation about persisting system variables and the mysqld-auto.cnf\nfile, see\nhttps://dev.mysql.com/doc/refman/8.4/en/persisted-system-variables.html\n.\n\nThe privileges required for RESET PERSIST depend on the type of system\nvariable to be removed:\n\no For dynamic system variables, this statement requires the\n  SYSTEM_VARIABLES_ADMIN privilege (or the deprecated SUPER privilege).\n\no For read-only system variables, this statement requires the\n  SYSTEM_VARIABLES_ADMIN and PERSIST_RO_VARIABLES_ADMIN privileges.\n\nSee\nhttps://dev.mysql.com/doc/refman/8.4/en/system-variable-privileges.html\n.\n\nDepending on whether the variable name and IF EXISTS clauses are\npresent, the RESET PERSIST statement has these forms:\n\no To remove all persisted variables from mysqld-auto.cnf, use RESET\n  PERSIST without naming any system variable:\n\nRESET PERSIST;\n\n  You must have privileges for removing both dynamic and read-only\n  system variables if mysqld-auto.cnf contains both kinds of variables.\n\no To remove a specific persisted variable from mysqld-auto.cnf, name it\n  in the statement:\n\nRESET PERSIST system_var_name;\n\n  This includes plugin system variables, even if the plugin is not\n  currently installed. If the variable is not present in the file, an\n  error occurs.\n\no To remove a specific persisted variable from mysqld-auto.cnf, but\n  produce a warning rather than an error if the variable is not present\n  in the file, add an IF EXISTS clause to the previous syntax:\n\nRESET PERSIST IF EXISTS system_var_name;\n\nURL: https://dev.mysql.com/doc/refman/8.4/en/reset-persist.html\n\n','','https://dev.mysql.com/doc/refman/8.4/en/reset-persist.html'),(687,'RESTART',3,'Syntax:\nRESTART\n\nThis statement stops and restarts the MySQL server. It requires the\nSHUTDOWN privilege.\n\nOne use for RESTART is when it is not possible or convenient to gain\ncommand-line access to the MySQL server on the server host to restart\nit. For example, SET PERSIST_ONLY can be used at runtime to make\nconfiguration changes to system variables that can be set only at\nserver startup, but the server must still be restarted for those\nchanges to take effect. The RESTART statement provides a way to do so\nfrom within client sessions, without requiring command-line access on\nthe server host.\n\n*Note*:\n\nAfter executing a RESTART statement, the client can expect the current\nconnection to be lost. If auto-reconnect is enabled, the connection is\nreestablished after the server restarts. Otherwise, the connection must\nbe reestablished manually.\n\nA successful RESTART operation requires mysqld to be running in an\nenvironment that has a monitoring process available to detect a server\nshutdown performed for restart purposes:\n\no In the presence of a monitoring process, RESTART causes mysqld to\n  terminate such that the monitoring process can determine that it\n  should start a new mysqld instance.\n\no If no monitoring process is present, RESTART fails with an error.\n\nThese platforms provide the necessary monitoring support for the\nRESTART statement:\n\no Windows, when mysqld is started as a Windows service or standalone.\n  (mysqld forks, and one process acts as a monitor to the other, which\n  acts as the server.)\n\no Unix and Unix-like systems that use systemd or mysqld_safe to manage\n  mysqld.\n\nTo configure a monitoring environment such that mysqld enables the\nRESTART statement:\n\n1. Set the MYSQLD_PARENT_PID environment variable to the value of the\n   process ID of the process that starts mysqld, before starting\n   mysqld.\n\n2. When mysqld performs a shutdown due to use of the RESTART statement,\n   it returns exit code 16.\n\n3. When the monitoring process detects an exit code of 16, it starts\n   mysqld again. Otherwise, it exits.\n\nHere is a minimal example as implemented in the bash shell:\n\n#!/bin/bash\n\nexport MYSQLD_PARENT_PID=$$\n\nexport MYSQLD_RESTART_EXIT=16\n\nwhile true ; do\n  bin/mysqld mysqld options here\n  if [ $? -ne $MYSQLD_RESTART_EXIT ]; then\n    break\n  fi\ndone\n\nOn Windows, the forking used to implement RESTART makes determining the\nserver process to attach to for debugging more difficult. To alleviate\nthis, starting the server with --gdb suppresses forking, in addition to\nits other actions done to set up a debugging environment. In non-debug\nsettings, --no-monitor may be used for the sole purpose of suppressing\nforking the monitor process. For a server started with either --gdb or\n--no-monitor, executing RESTART causes the server to simply exit\nwithout restarting.\n\nURL: https://dev.mysql.com/doc/refman/8.4/en/restart.html\n\n','','https://dev.mysql.com/doc/refman/8.4/en/restart.html'),(688,'SHUTDOWN',3,'Syntax:\nSHUTDOWN\n\nThis statement stops the MySQL server. It requires the SHUTDOWN\nprivilege.\n\nSHUTDOWN provides an SQL-level interface to the same functionality\navailable using the mysqladmin shutdown command. A successful SHUTDOWN\nsequence consists of checking the privileges, validating the arguments,\nand sending an OK packet to the client. Then the server is shut down.\n\nURL: https://dev.mysql.com/doc/refman/8.4/en/shutdown.html\n\n','','https://dev.mysql.com/doc/refman/8.4/en/shutdown.html'),(689,'EXPLAIN',51,'Syntax:\n{EXPLAIN | DESCRIBE | DESC}\n    tbl_name [col_name | wild]\n\n{EXPLAIN | DESCRIBE | DESC}\n    [explain_type] [INTO variable]\n    {[schema_spec] explainable_stmt | FOR CONNECTION connection_id}\n\n{EXPLAIN | DESCRIBE | DESC} ANALYZE [FORMAT = TREE] [schema_spec] select_statement\n\nexplain_type: {\n    FORMAT = format_name\n}\n\nformat_name: {\n    TRADITIONAL\n  | JSON\n  | TREE\n}\n\nexplainable_stmt: {\n    SELECT statement\n  | TABLE statement\n  | DELETE statement\n  | INSERT statement\n  | REPLACE statement\n  | UPDATE statement\n}\n\nschema_spec:\nFOR {SCHEMA | DATABASE} schema_name\n\nThe DESCRIBE and EXPLAIN statements are synonyms. In practice, the\nDESCRIBE keyword is more often used to obtain information about table\nstructure, whereas EXPLAIN is used to obtain a query execution plan\n(that is, an explanation of how MySQL would execute a query).\n\nURL: https://dev.mysql.com/doc/refman/8.4/en/explain.html\n\n','','https://dev.mysql.com/doc/refman/8.4/en/explain.html'),(690,'DESCRIBE',51,'Syntax:\n{EXPLAIN | DESCRIBE | DESC}\n    tbl_name [col_name | wild]\n\n{EXPLAIN | DESCRIBE | DESC}\n    [explain_type] [INTO variable]\n    {[schema_spec] explainable_stmt | FOR CONNECTION connection_id}\n\n{EXPLAIN | DESCRIBE | DESC} ANALYZE [FORMAT = TREE] [schema_spec] select_statement\n\nexplain_type: {\n    FORMAT = format_name\n}\n\nformat_name: {\n    TRADITIONAL\n  | JSON\n  | TREE\n}\n\nexplainable_stmt: {\n    SELECT statement\n  | TABLE statement\n  | DELETE statement\n  | INSERT statement\n  | REPLACE statement\n  | UPDATE statement\n}\n\nschema_spec:\nFOR {SCHEMA | DATABASE} schema_name\n\nThe DESCRIBE and EXPLAIN statements are synonyms. In practice, the\nDESCRIBE keyword is more often used to obtain information about table\nstructure, whereas EXPLAIN is used to obtain a query execution plan\n(that is, an explanation of how MySQL would execute a query).\n\nURL: https://dev.mysql.com/doc/refman/8.4/en/explain.html\n\n','','https://dev.mysql.com/doc/refman/8.4/en/explain.html'),(691,'DESC',51,'Syntax:\n{EXPLAIN | DESCRIBE | DESC}\n    tbl_name [col_name | wild]\n\n{EXPLAIN | DESCRIBE | DESC}\n    [explain_type] [INTO variable]\n    {[schema_spec] explainable_stmt | FOR CONNECTION connection_id}\n\n{EXPLAIN | DESCRIBE | DESC} ANALYZE [FORMAT = TREE] [schema_spec] select_statement\n\nexplain_type: {\n    FORMAT = format_name\n}\n\nformat_name: {\n    TRADITIONAL\n  | JSON\n  | TREE\n}\n\nexplainable_stmt: {\n    SELECT statement\n  | TABLE statement\n  | DELETE statement\n  | INSERT statement\n  | REPLACE statement\n  | UPDATE statement\n}\n\nschema_spec:\nFOR {SCHEMA | DATABASE} schema_name\n\nThe DESCRIBE and EXPLAIN statements are synonyms. In practice, the\nDESCRIBE keyword is more often used to obtain information about table\nstructure, whereas EXPLAIN is used to obtain a query execution plan\n(that is, an explanation of how MySQL would execute a query).\n\nURL: https://dev.mysql.com/doc/refman/8.4/en/explain.html\n\n','','https://dev.mysql.com/doc/refman/8.4/en/explain.html'),(692,'HELP STATEMENT',51,'Syntax:\nHELP \'search_string\'\n\nThe HELP statement returns online information from the MySQL Reference\nManual. Its proper operation requires that the help tables in the mysql\ndatabase be initialized with help topic information (see\nhttps://dev.mysql.com/doc/refman/8.4/en/server-side-help-support.html).\n\nThe HELP statement searches the help tables for the given search string\nand displays the result of the search. The search string is not\ncase-sensitive.\n\nThe search string can contain the wildcard characters % and _. These\nhave the same meaning as for pattern-matching operations performed with\nthe LIKE operator. For example, HELP \'rep%\' returns a list of topics\nthat begin with rep.\n\nThe HELP statement does not require a terminator such as ; or \\G.\n\nURL: https://dev.mysql.com/doc/refman/8.4/en/help.html\n\n','','https://dev.mysql.com/doc/refman/8.4/en/help.html'),(693,'USE',51,'Syntax:\nUSE db_name\n\nThe USE statement tells MySQL to use the named database as the default\n(current) database for subsequent statements. This statement requires\nsome privilege for the database or some object within it.\n\nThe named database remains the default until the end of the session or\nanother USE statement is issued:\n\nUSE db1;\nSELECT COUNT(*) FROM mytable;   # selects from db1.mytable\nUSE db2;\nSELECT COUNT(*) FROM mytable;   # selects from db2.mytable\n\nThe database name must be specified on a single line. Newlines in\ndatabase names are not supported.\n\nURL: https://dev.mysql.com/doc/refman/8.4/en/use.html\n\n','','https://dev.mysql.com/doc/refman/8.4/en/use.html'),(694,'MERGE',52,'The MERGE storage engine, also known as the MRG_MyISAM engine, is a\ncollection of identical MyISAM tables that can be used as one.\n\"Identical\" means that all tables have identical column data types and\nindex information. You cannot merge MyISAM tables in which the columns\nare listed in a different order, do not have exactly the same data\ntypes in corresponding columns, or have the indexes in different order.\nHowever, any or all of the MyISAM tables can be compressed with\nmyisampack. See\nhttps://dev.mysql.com/doc/refman/8.4/en/myisampack.html. Differences\nbetween tables such as these do not matter:\n\no Names of corresponding columns and indexes can differ.\n\no Comments for tables, columns, and indexes can differ.\n\no Table options such as AVG_ROW_LENGTH, MAX_ROWS, or PACK_KEYS can\n  differ.\n\nURL: https://dev.mysql.com/doc/refman/8.4/en/merge-storage-engine.html\n\n','mysql> CREATE TABLE t1 (\n    ->    a INT NOT NULL AUTO_INCREMENT PRIMARY KEY,\n    ->    message CHAR(20)) ENGINE=MyISAM;\nmysql> CREATE TABLE t2 (\n    ->    a INT NOT NULL AUTO_INCREMENT PRIMARY KEY,\n    ->    message CHAR(20)) ENGINE=MyISAM;\nmysql> INSERT INTO t1 (message) VALUES (\'Testing\'),(\'table\'),(\'t1\');\nmysql> INSERT INTO t2 (message) VALUES (\'Testing\'),(\'table\'),(\'t2\');\nmysql> CREATE TABLE total (\n    ->    a INT NOT NULL AUTO_INCREMENT,\n    ->    message CHAR(20), INDEX(a))\n    ->    ENGINE=MERGE UNION=(t1,t2) INSERT_METHOD=LAST;\n','https://dev.mysql.com/doc/refman/8.4/en/merge-storage-engine.html');

--
-- Dumping data for table `innodb_index_stats`
--

INSERT  IGNORE INTO `innodb_index_stats` VALUES ('kamar','booking_passengers','PRIMARY','2025-11-07 06:00:06','n_diff_pfx01',0,1,'id'),('kamar','booking_passengers','PRIMARY','2025-11-07 06:00:06','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','booking_passengers','PRIMARY','2025-11-07 06:00:06','size',1,NULL,'Number of pages in the index'),('kamar','bravo_airline','PRIMARY','2025-11-07 06:00:16','n_diff_pfx01',20,1,'id'),('kamar','bravo_airline','PRIMARY','2025-11-07 06:00:16','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','bravo_airline','PRIMARY','2025-11-07 06:00:16','size',1,NULL,'Number of pages in the index'),('kamar','bravo_airport','PRIMARY','2025-11-07 06:00:06','n_diff_pfx01',20,1,'id'),('kamar','bravo_airport','PRIMARY','2025-11-07 06:00:06','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','bravo_airport','PRIMARY','2025-11-07 06:00:06','size',1,NULL,'Number of pages in the index'),('kamar','bravo_airport','bravo_airport_code_unique','2025-11-07 06:00:06','n_diff_pfx01',20,1,'code'),('kamar','bravo_airport','bravo_airport_code_unique','2025-11-07 06:00:06','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','bravo_airport','bravo_airport_code_unique','2025-11-07 06:00:06','size',1,NULL,'Number of pages in the index'),('kamar','bravo_attrs','PRIMARY','2025-11-07 06:02:17','n_diff_pfx01',26,1,'id'),('kamar','bravo_attrs','PRIMARY','2025-11-07 06:02:17','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','bravo_attrs','PRIMARY','2025-11-07 06:02:17','size',1,NULL,'Number of pages in the index'),('kamar','bravo_attrs_translations','PRIMARY','2025-11-07 06:00:06','n_diff_pfx01',2,1,'id'),('kamar','bravo_attrs_translations','PRIMARY','2025-11-07 06:00:06','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','bravo_attrs_translations','PRIMARY','2025-11-07 06:00:06','size',1,NULL,'Number of pages in the index'),('kamar','bravo_attrs_translations','bravo_attrs_translations_origin_id_locale_unique','2025-11-07 06:00:06','n_diff_pfx01',2,1,'origin_id'),('kamar','bravo_attrs_translations','bravo_attrs_translations_origin_id_locale_unique','2025-11-07 06:00:06','n_diff_pfx02',2,1,'origin_id,locale'),('kamar','bravo_attrs_translations','bravo_attrs_translations_origin_id_locale_unique','2025-11-07 06:00:06','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','bravo_attrs_translations','bravo_attrs_translations_origin_id_locale_unique','2025-11-07 06:00:06','size',1,NULL,'Number of pages in the index'),('kamar','bravo_boat_dates','PRIMARY','2025-11-07 06:00:06','n_diff_pfx01',0,1,'id'),('kamar','bravo_boat_dates','PRIMARY','2025-11-07 06:00:06','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','bravo_boat_dates','PRIMARY','2025-11-07 06:00:06','size',1,NULL,'Number of pages in the index'),('kamar','bravo_boat_term','PRIMARY','2025-11-07 06:00:06','n_diff_pfx01',134,1,'id'),('kamar','bravo_boat_term','PRIMARY','2025-11-07 06:00:06','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','bravo_boat_term','PRIMARY','2025-11-07 06:00:06','size',1,NULL,'Number of pages in the index'),('kamar','bravo_boat_translations','PRIMARY','2025-11-07 06:00:06','n_diff_pfx01',0,1,'id'),('kamar','bravo_boat_translations','PRIMARY','2025-11-07 06:00:06','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','bravo_boat_translations','PRIMARY','2025-11-07 06:00:06','size',1,NULL,'Number of pages in the index'),('kamar','bravo_boat_translations','bravo_boat_translations_locale_index','2025-11-07 06:00:06','n_diff_pfx01',0,1,'locale'),('kamar','bravo_boat_translations','bravo_boat_translations_locale_index','2025-11-07 06:00:06','n_diff_pfx02',0,1,'locale,id'),('kamar','bravo_boat_translations','bravo_boat_translations_locale_index','2025-11-07 06:00:06','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','bravo_boat_translations','bravo_boat_translations_locale_index','2025-11-07 06:00:06','size',1,NULL,'Number of pages in the index'),('kamar','bravo_boats','PRIMARY','2025-11-07 06:00:57','n_diff_pfx01',13,7,'id'),('kamar','bravo_boats','PRIMARY','2025-11-07 06:00:57','n_leaf_pages',7,NULL,'Number of leaf pages in the index'),('kamar','bravo_boats','PRIMARY','2025-11-07 06:00:57','size',8,NULL,'Number of pages in the index'),('kamar','bravo_boats','bravo_boats_slug_index','2025-11-07 06:00:57','n_diff_pfx01',13,1,'slug'),('kamar','bravo_boats','bravo_boats_slug_index','2025-11-07 06:00:57','n_diff_pfx02',13,1,'slug,id'),('kamar','bravo_boats','bravo_boats_slug_index','2025-11-07 06:00:57','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','bravo_boats','bravo_boats_slug_index','2025-11-07 06:00:57','size',1,NULL,'Number of pages in the index'),('kamar','bravo_booking_coupons','PRIMARY','2025-11-07 06:00:07','n_diff_pfx01',0,1,'id'),('kamar','bravo_booking_coupons','PRIMARY','2025-11-07 06:00:07','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','bravo_booking_coupons','PRIMARY','2025-11-07 06:00:07','size',1,NULL,'Number of pages in the index'),('kamar','bravo_booking_meta','PRIMARY','2025-11-07 06:00:07','n_diff_pfx01',2157,9,'id'),('kamar','bravo_booking_meta','PRIMARY','2025-11-07 06:00:07','n_leaf_pages',9,NULL,'Number of leaf pages in the index'),('kamar','bravo_booking_meta','PRIMARY','2025-11-07 06:00:07','size',10,NULL,'Number of pages in the index'),('kamar','bravo_booking_payment_meta','PRIMARY','2025-11-07 06:00:07','n_diff_pfx01',1,1,'id'),('kamar','bravo_booking_payment_meta','PRIMARY','2025-11-07 06:00:07','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','bravo_booking_payment_meta','PRIMARY','2025-11-07 06:00:07','size',1,NULL,'Number of pages in the index'),('kamar','bravo_booking_payment_meta','bravo_booking_payment_meta_payment_id_name_index','2025-11-07 06:00:07','n_diff_pfx01',1,1,'payment_id'),('kamar','bravo_booking_payment_meta','bravo_booking_payment_meta_payment_id_name_index','2025-11-07 06:00:07','n_diff_pfx02',1,1,'payment_id,name'),('kamar','bravo_booking_payment_meta','bravo_booking_payment_meta_payment_id_name_index','2025-11-07 06:00:07','n_diff_pfx03',1,1,'payment_id,name,id'),('kamar','bravo_booking_payment_meta','bravo_booking_payment_meta_payment_id_name_index','2025-11-07 06:00:07','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','bravo_booking_payment_meta','bravo_booking_payment_meta_payment_id_name_index','2025-11-07 06:00:07','size',1,NULL,'Number of pages in the index'),('kamar','bravo_booking_payments','PRIMARY','2025-11-07 06:00:07','n_diff_pfx01',55,1,'id'),('kamar','bravo_booking_payments','PRIMARY','2025-11-07 06:00:07','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','bravo_booking_payments','PRIMARY','2025-11-07 06:00:07','size',1,NULL,'Number of pages in the index'),('kamar','bravo_booking_time_slots','PRIMARY','2025-11-07 06:00:07','n_diff_pfx01',0,1,'id'),('kamar','bravo_booking_time_slots','PRIMARY','2025-11-07 06:00:07','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','bravo_booking_time_slots','PRIMARY','2025-11-07 06:00:07','size',1,NULL,'Number of pages in the index'),('kamar','bravo_bookings','PRIMARY','2025-11-07 06:00:07','n_diff_pfx01',136,6,'id'),('kamar','bravo_bookings','PRIMARY','2025-11-07 06:00:07','n_leaf_pages',6,NULL,'Number of leaf pages in the index'),('kamar','bravo_bookings','PRIMARY','2025-11-07 06:00:07','size',7,NULL,'Number of pages in the index'),('kamar','bravo_car_dates','PRIMARY','2025-11-07 06:00:07','n_diff_pfx01',0,1,'id'),('kamar','bravo_car_dates','PRIMARY','2025-11-07 06:00:07','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','bravo_car_dates','PRIMARY','2025-11-07 06:00:07','size',1,NULL,'Number of pages in the index'),('kamar','bravo_car_term','PRIMARY','2025-11-07 06:00:07','n_diff_pfx01',309,1,'id'),('kamar','bravo_car_term','PRIMARY','2025-11-07 06:00:07','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','bravo_car_term','PRIMARY','2025-11-07 06:00:07','size',1,NULL,'Number of pages in the index'),('kamar','bravo_car_translations','PRIMARY','2025-11-07 06:00:07','n_diff_pfx01',0,1,'id'),('kamar','bravo_car_translations','PRIMARY','2025-11-07 06:00:07','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','bravo_car_translations','PRIMARY','2025-11-07 06:00:07','size',1,NULL,'Number of pages in the index'),('kamar','bravo_car_translations','bravo_car_translations_locale_index','2025-11-07 06:00:07','n_diff_pfx01',0,1,'locale'),('kamar','bravo_car_translations','bravo_car_translations_locale_index','2025-11-07 06:00:07','n_diff_pfx02',0,1,'locale,id'),('kamar','bravo_car_translations','bravo_car_translations_locale_index','2025-11-07 06:00:07','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','bravo_car_translations','bravo_car_translations_locale_index','2025-11-07 06:00:07','size',1,NULL,'Number of pages in the index'),('kamar','bravo_cars','PRIMARY','2025-11-07 06:01:37','n_diff_pfx01',26,10,'id'),('kamar','bravo_cars','PRIMARY','2025-11-07 06:01:37','n_leaf_pages',10,NULL,'Number of leaf pages in the index'),('kamar','bravo_cars','PRIMARY','2025-11-07 06:01:37','size',11,NULL,'Number of pages in the index'),('kamar','bravo_cars','bravo_cars_slug_index','2025-11-07 06:01:37','n_diff_pfx01',26,1,'slug'),('kamar','bravo_cars','bravo_cars_slug_index','2025-11-07 06:01:37','n_diff_pfx02',26,1,'slug,id'),('kamar','bravo_cars','bravo_cars_slug_index','2025-11-07 06:01:37','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','bravo_cars','bravo_cars_slug_index','2025-11-07 06:01:37','size',1,NULL,'Number of pages in the index'),('kamar','bravo_contact','PRIMARY','2025-11-07 06:00:07','n_diff_pfx01',12,1,'id'),('kamar','bravo_contact','PRIMARY','2025-11-07 06:00:07','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','bravo_contact','PRIMARY','2025-11-07 06:00:07','size',1,NULL,'Number of pages in the index'),('kamar','bravo_coupon_services','PRIMARY','2025-11-07 06:00:08','n_diff_pfx01',1,1,'id'),('kamar','bravo_coupon_services','PRIMARY','2025-11-07 06:00:08','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','bravo_coupon_services','PRIMARY','2025-11-07 06:00:08','size',1,NULL,'Number of pages in the index'),('kamar','bravo_coupons','PRIMARY','2025-11-07 06:00:07','n_diff_pfx01',0,1,'id'),('kamar','bravo_coupons','PRIMARY','2025-11-07 06:00:07','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','bravo_coupons','PRIMARY','2025-11-07 06:00:07','size',1,NULL,'Number of pages in the index'),('kamar','bravo_coupons','bravo_coupons_code_unique','2025-11-07 06:00:07','n_diff_pfx01',0,1,'code'),('kamar','bravo_coupons','bravo_coupons_code_unique','2025-11-07 06:00:07','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','bravo_coupons','bravo_coupons_code_unique','2025-11-07 06:00:07','size',1,NULL,'Number of pages in the index'),('kamar','bravo_enquiries','PRIMARY','2025-11-07 06:00:08','n_diff_pfx01',0,1,'id'),('kamar','bravo_enquiries','PRIMARY','2025-11-07 06:00:08','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','bravo_enquiries','PRIMARY','2025-11-07 06:00:08','size',1,NULL,'Number of pages in the index'),('kamar','bravo_event_dates','PRIMARY','2025-11-07 06:00:08','n_diff_pfx01',0,1,'id'),('kamar','bravo_event_dates','PRIMARY','2025-11-07 06:00:08','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','bravo_event_dates','PRIMARY','2025-11-07 06:00:08','size',1,NULL,'Number of pages in the index'),('kamar','bravo_event_term','PRIMARY','2025-11-07 06:00:08','n_diff_pfx01',141,1,'id'),('kamar','bravo_event_term','PRIMARY','2025-11-07 06:00:08','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','bravo_event_term','PRIMARY','2025-11-07 06:00:08','size',1,NULL,'Number of pages in the index'),('kamar','bravo_event_translations','PRIMARY','2025-11-07 06:00:08','n_diff_pfx01',0,1,'id'),('kamar','bravo_event_translations','PRIMARY','2025-11-07 06:00:08','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','bravo_event_translations','PRIMARY','2025-11-07 06:00:08','size',1,NULL,'Number of pages in the index'),('kamar','bravo_event_translations','bravo_event_translations_locale_index','2025-11-07 06:00:08','n_diff_pfx01',0,1,'locale'),('kamar','bravo_event_translations','bravo_event_translations_locale_index','2025-11-07 06:00:08','n_diff_pfx02',0,1,'locale,id'),('kamar','bravo_event_translations','bravo_event_translations_locale_index','2025-11-07 06:00:08','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','bravo_event_translations','bravo_event_translations_locale_index','2025-11-07 06:00:08','size',1,NULL,'Number of pages in the index'),('kamar','bravo_events','PRIMARY','2025-11-07 06:00:08','n_diff_pfx01',24,6,'id'),('kamar','bravo_events','PRIMARY','2025-11-07 06:00:08','n_leaf_pages',6,NULL,'Number of leaf pages in the index'),('kamar','bravo_events','PRIMARY','2025-11-07 06:00:08','size',7,NULL,'Number of pages in the index'),('kamar','bravo_events','bravo_events_slug_index','2025-11-07 06:00:08','n_diff_pfx01',24,1,'slug'),('kamar','bravo_events','bravo_events_slug_index','2025-11-07 06:00:08','n_diff_pfx02',24,1,'slug,id'),('kamar','bravo_events','bravo_events_slug_index','2025-11-07 06:00:08','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','bravo_events','bravo_events_slug_index','2025-11-07 06:00:08','size',1,NULL,'Number of pages in the index'),('kamar','bravo_flight','PRIMARY','2025-11-07 06:00:08','n_diff_pfx01',20,1,'id'),('kamar','bravo_flight','PRIMARY','2025-11-07 06:00:08','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','bravo_flight','PRIMARY','2025-11-07 06:00:08','size',1,NULL,'Number of pages in the index'),('kamar','bravo_flight_seat','PRIMARY','2025-11-07 06:00:08','n_diff_pfx01',60,1,'id'),('kamar','bravo_flight_seat','PRIMARY','2025-11-07 06:00:08','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','bravo_flight_seat','PRIMARY','2025-11-07 06:00:08','size',1,NULL,'Number of pages in the index'),('kamar','bravo_flight_term','PRIMARY','2025-11-07 06:00:08','n_diff_pfx01',106,1,'id'),('kamar','bravo_flight_term','PRIMARY','2025-11-07 06:00:08','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','bravo_flight_term','PRIMARY','2025-11-07 06:00:08','size',1,NULL,'Number of pages in the index'),('kamar','bravo_hotel_room_bookings','PRIMARY','2025-11-07 06:01:57','n_diff_pfx01',154,1,'id'),('kamar','bravo_hotel_room_bookings','PRIMARY','2025-11-07 06:01:57','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','bravo_hotel_room_bookings','PRIMARY','2025-11-07 06:01:57','size',1,NULL,'Number of pages in the index'),('kamar','bravo_hotel_room_dates','PRIMARY','2025-11-07 06:00:08','n_diff_pfx01',42,1,'id'),('kamar','bravo_hotel_room_dates','PRIMARY','2025-11-07 06:00:08','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','bravo_hotel_room_dates','PRIMARY','2025-11-07 06:00:08','size',1,NULL,'Number of pages in the index'),('kamar','bravo_hotel_room_term','PRIMARY','2025-11-07 06:00:09','n_diff_pfx01',436,2,'id'),('kamar','bravo_hotel_room_term','PRIMARY','2025-11-07 06:00:09','n_leaf_pages',2,NULL,'Number of leaf pages in the index'),('kamar','bravo_hotel_room_term','PRIMARY','2025-11-07 06:00:09','size',3,NULL,'Number of pages in the index'),('kamar','bravo_hotel_room_translations','PRIMARY','2025-11-07 06:00:09','n_diff_pfx01',3,1,'id'),('kamar','bravo_hotel_room_translations','PRIMARY','2025-11-07 06:00:09','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','bravo_hotel_room_translations','PRIMARY','2025-11-07 06:00:09','size',1,NULL,'Number of pages in the index'),('kamar','bravo_hotel_room_translations','bravo_hotel_room_translations_locale_index','2025-11-07 06:00:09','n_diff_pfx01',1,1,'locale'),('kamar','bravo_hotel_room_translations','bravo_hotel_room_translations_locale_index','2025-11-07 06:00:09','n_diff_pfx02',3,1,'locale,id'),('kamar','bravo_hotel_room_translations','bravo_hotel_room_translations_locale_index','2025-11-07 06:00:09','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','bravo_hotel_room_translations','bravo_hotel_room_translations_locale_index','2025-11-07 06:00:09','size',1,NULL,'Number of pages in the index'),('kamar','bravo_hotel_rooms','PRIMARY','2025-11-07 06:01:17','n_diff_pfx01',108,5,'id'),('kamar','bravo_hotel_rooms','PRIMARY','2025-11-07 06:01:17','n_leaf_pages',5,NULL,'Number of leaf pages in the index'),('kamar','bravo_hotel_rooms','PRIMARY','2025-11-07 06:01:17','size',6,NULL,'Number of pages in the index'),('kamar','bravo_hotel_term','PRIMARY','2025-11-07 06:00:09','n_diff_pfx01',470,2,'id'),('kamar','bravo_hotel_term','PRIMARY','2025-11-07 06:00:09','n_leaf_pages',2,NULL,'Number of leaf pages in the index'),('kamar','bravo_hotel_term','PRIMARY','2025-11-07 06:00:09','size',3,NULL,'Number of pages in the index'),('kamar','bravo_hotel_translations','PRIMARY','2025-11-07 06:00:09','n_diff_pfx01',1,1,'id'),('kamar','bravo_hotel_translations','PRIMARY','2025-11-07 06:00:09','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','bravo_hotel_translations','PRIMARY','2025-11-07 06:00:09','size',1,NULL,'Number of pages in the index'),('kamar','bravo_hotel_translations','bravo_hotel_translations_locale_index','2025-11-07 06:00:09','n_diff_pfx01',1,1,'locale'),('kamar','bravo_hotel_translations','bravo_hotel_translations_locale_index','2025-11-07 06:00:09','n_diff_pfx02',1,1,'locale,id'),('kamar','bravo_hotel_translations','bravo_hotel_translations_locale_index','2025-11-07 06:00:09','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','bravo_hotel_translations','bravo_hotel_translations_locale_index','2025-11-07 06:00:09','size',1,NULL,'Number of pages in the index'),('kamar','bravo_hotels','PRIMARY','2025-11-07 06:00:37','n_diff_pfx01',30,6,'id'),('kamar','bravo_hotels','PRIMARY','2025-11-07 06:00:37','n_leaf_pages',6,NULL,'Number of leaf pages in the index'),('kamar','bravo_hotels','PRIMARY','2025-11-07 06:00:37','size',7,NULL,'Number of pages in the index'),('kamar','bravo_hotels','bravo_hotels_slug_index','2025-11-07 06:00:37','n_diff_pfx01',30,1,'slug'),('kamar','bravo_hotels','bravo_hotels_slug_index','2025-11-07 06:00:37','n_diff_pfx02',30,1,'slug,id'),('kamar','bravo_hotels','bravo_hotels_slug_index','2025-11-07 06:00:37','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','bravo_hotels','bravo_hotels_slug_index','2025-11-07 06:00:37','size',1,NULL,'Number of pages in the index'),('kamar','bravo_location_translations','PRIMARY','2025-11-07 06:00:09','n_diff_pfx01',0,1,'id'),('kamar','bravo_location_translations','PRIMARY','2025-11-07 06:00:09','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','bravo_location_translations','PRIMARY','2025-11-07 06:00:09','size',1,NULL,'Number of pages in the index'),('kamar','bravo_location_translations','bravo_location_translations_origin_id_locale_unique','2025-11-07 06:00:09','n_diff_pfx01',0,1,'origin_id'),('kamar','bravo_location_translations','bravo_location_translations_origin_id_locale_unique','2025-11-07 06:00:09','n_diff_pfx02',0,1,'origin_id,locale'),('kamar','bravo_location_translations','bravo_location_translations_origin_id_locale_unique','2025-11-07 06:00:09','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','bravo_location_translations','bravo_location_translations_origin_id_locale_unique','2025-11-07 06:00:09','size',1,NULL,'Number of pages in the index'),('kamar','bravo_locations','PRIMARY','2025-11-07 06:00:09','n_diff_pfx01',559,5,'id'),('kamar','bravo_locations','PRIMARY','2025-11-07 06:00:09','n_leaf_pages',5,NULL,'Number of leaf pages in the index'),('kamar','bravo_locations','PRIMARY','2025-11-07 06:00:09','size',6,NULL,'Number of pages in the index'),('kamar','bravo_locations','bravo_locations__lft__rgt_parent_id_index','2025-11-07 06:00:09','n_diff_pfx01',559,1,'_lft'),('kamar','bravo_locations','bravo_locations__lft__rgt_parent_id_index','2025-11-07 06:00:09','n_diff_pfx02',559,1,'_lft,_rgt'),('kamar','bravo_locations','bravo_locations__lft__rgt_parent_id_index','2025-11-07 06:00:09','n_diff_pfx03',559,1,'_lft,_rgt,parent_id'),('kamar','bravo_locations','bravo_locations__lft__rgt_parent_id_index','2025-11-07 06:00:09','n_diff_pfx04',559,1,'_lft,_rgt,parent_id,id'),('kamar','bravo_locations','bravo_locations__lft__rgt_parent_id_index','2025-11-07 06:00:09','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','bravo_locations','bravo_locations__lft__rgt_parent_id_index','2025-11-07 06:00:09','size',1,NULL,'Number of pages in the index'),('kamar','bravo_locations_2024_1_15','PRIMARY','2025-11-07 06:00:09','n_diff_pfx01',8,1,'id'),('kamar','bravo_locations_2024_1_15','PRIMARY','2025-11-07 06:00:09','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','bravo_locations_2024_1_15','PRIMARY','2025-11-07 06:00:09','size',1,NULL,'Number of pages in the index'),('kamar','bravo_locations_2024_1_15','bravo_locations__lft__rgt_parent_id_index','2025-11-07 06:00:09','n_diff_pfx01',8,1,'_lft'),('kamar','bravo_locations_2024_1_15','bravo_locations__lft__rgt_parent_id_index','2025-11-07 06:00:09','n_diff_pfx02',8,1,'_lft,_rgt'),('kamar','bravo_locations_2024_1_15','bravo_locations__lft__rgt_parent_id_index','2025-11-07 06:00:09','n_diff_pfx03',8,1,'_lft,_rgt,parent_id'),('kamar','bravo_locations_2024_1_15','bravo_locations__lft__rgt_parent_id_index','2025-11-07 06:00:09','n_diff_pfx04',8,1,'_lft,_rgt,parent_id,id'),('kamar','bravo_locations_2024_1_15','bravo_locations__lft__rgt_parent_id_index','2025-11-07 06:00:09','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','bravo_locations_2024_1_15','bravo_locations__lft__rgt_parent_id_index','2025-11-07 06:00:09','size',1,NULL,'Number of pages in the index'),('kamar','bravo_payouts','PRIMARY','2025-11-07 06:00:09','n_diff_pfx01',0,1,'id'),('kamar','bravo_payouts','PRIMARY','2025-11-07 06:00:09','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','bravo_payouts','PRIMARY','2025-11-07 06:00:09','size',1,NULL,'Number of pages in the index'),('kamar','bravo_popup_translations','PRIMARY','2025-11-07 06:00:09','n_diff_pfx01',0,1,'id'),('kamar','bravo_popup_translations','PRIMARY','2025-11-07 06:00:09','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','bravo_popup_translations','PRIMARY','2025-11-07 06:00:09','size',1,NULL,'Number of pages in the index'),('kamar','bravo_popup_translations','bravo_popup_translations_locale_index','2025-11-07 06:00:09','n_diff_pfx01',0,1,'locale'),('kamar','bravo_popup_translations','bravo_popup_translations_locale_index','2025-11-07 06:00:09','n_diff_pfx02',0,1,'locale,id'),('kamar','bravo_popup_translations','bravo_popup_translations_locale_index','2025-11-07 06:00:09','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','bravo_popup_translations','bravo_popup_translations_locale_index','2025-11-07 06:00:09','size',1,NULL,'Number of pages in the index'),('kamar','bravo_popup_translations','bravo_popup_translations_origin_id_locale_unique','2025-11-07 06:00:09','n_diff_pfx01',0,1,'origin_id'),('kamar','bravo_popup_translations','bravo_popup_translations_origin_id_locale_unique','2025-11-07 06:00:09','n_diff_pfx02',0,1,'origin_id,locale'),('kamar','bravo_popup_translations','bravo_popup_translations_origin_id_locale_unique','2025-11-07 06:00:09','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','bravo_popup_translations','bravo_popup_translations_origin_id_locale_unique','2025-11-07 06:00:09','size',1,NULL,'Number of pages in the index'),('kamar','bravo_popups','PRIMARY','2025-11-07 06:00:09','n_diff_pfx01',0,1,'id'),('kamar','bravo_popups','PRIMARY','2025-11-07 06:00:09','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','bravo_popups','PRIMARY','2025-11-07 06:00:09','size',1,NULL,'Number of pages in the index'),('kamar','bravo_review','PRIMARY','2025-11-07 06:00:09','n_diff_pfx01',0,1,'id'),('kamar','bravo_review','PRIMARY','2025-11-07 06:00:09','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','bravo_review','PRIMARY','2025-11-07 06:00:09','size',1,NULL,'Number of pages in the index'),('kamar','bravo_review_meta','PRIMARY','2025-11-07 06:00:10','n_diff_pfx01',2210,11,'id'),('kamar','bravo_review_meta','PRIMARY','2025-11-07 06:00:10','n_leaf_pages',11,NULL,'Number of leaf pages in the index'),('kamar','bravo_review_meta','PRIMARY','2025-11-07 06:00:10','size',12,NULL,'Number of pages in the index'),('kamar','bravo_seat_type','PRIMARY','2025-11-07 06:00:10','n_diff_pfx01',5,1,'id'),('kamar','bravo_seat_type','PRIMARY','2025-11-07 06:00:10','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','bravo_seat_type','PRIMARY','2025-11-07 06:00:10','size',1,NULL,'Number of pages in the index'),('kamar','bravo_seat_type','bravo_seat_type_code_unique','2025-11-07 06:00:10','n_diff_pfx01',5,1,'code'),('kamar','bravo_seat_type','bravo_seat_type_code_unique','2025-11-07 06:00:10','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','bravo_seat_type','bravo_seat_type_code_unique','2025-11-07 06:00:10','size',1,NULL,'Number of pages in the index'),('kamar','bravo_seo','PRIMARY','2025-11-07 06:00:10','n_diff_pfx01',54,1,'id'),('kamar','bravo_seo','PRIMARY','2025-11-07 06:00:10','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','bravo_seo','PRIMARY','2025-11-07 06:00:10','size',1,NULL,'Number of pages in the index'),('kamar','bravo_service_translations','PRIMARY','2025-11-07 06:00:10','n_diff_pfx01',1,1,'id'),('kamar','bravo_service_translations','PRIMARY','2025-11-07 06:00:10','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','bravo_service_translations','PRIMARY','2025-11-07 06:00:10','size',1,NULL,'Number of pages in the index'),('kamar','bravo_service_translations','bravo_service_translations_origin_id_locale_unique','2025-11-07 06:00:10','n_diff_pfx01',1,1,'origin_id'),('kamar','bravo_service_translations','bravo_service_translations_origin_id_locale_unique','2025-11-07 06:00:10','n_diff_pfx02',1,1,'origin_id,locale'),('kamar','bravo_service_translations','bravo_service_translations_origin_id_locale_unique','2025-11-07 06:00:10','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','bravo_service_translations','bravo_service_translations_origin_id_locale_unique','2025-11-07 06:00:10','size',1,NULL,'Number of pages in the index'),('kamar','bravo_services','PRIMARY','2025-11-07 06:00:10','n_diff_pfx01',111,2,'id'),('kamar','bravo_services','PRIMARY','2025-11-07 06:00:10','n_leaf_pages',2,NULL,'Number of leaf pages in the index'),('kamar','bravo_services','PRIMARY','2025-11-07 06:00:10','size',3,NULL,'Number of pages in the index'),('kamar','bravo_services','bravo_services_slug_index','2025-11-07 06:00:10','n_diff_pfx01',109,1,'slug'),('kamar','bravo_services','bravo_services_slug_index','2025-11-07 06:00:10','n_diff_pfx02',111,1,'slug,id'),('kamar','bravo_services','bravo_services_slug_index','2025-11-07 06:00:10','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','bravo_services','bravo_services_slug_index','2025-11-07 06:00:10','size',1,NULL,'Number of pages in the index'),('kamar','bravo_space_dates','PRIMARY','2025-11-07 06:00:10','n_diff_pfx01',0,1,'id'),('kamar','bravo_space_dates','PRIMARY','2025-11-07 06:00:10','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','bravo_space_dates','PRIMARY','2025-11-07 06:00:10','size',1,NULL,'Number of pages in the index'),('kamar','bravo_space_term','PRIMARY','2025-11-07 06:00:10','n_diff_pfx01',308,1,'id'),('kamar','bravo_space_term','PRIMARY','2025-11-07 06:00:10','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','bravo_space_term','PRIMARY','2025-11-07 06:00:10','size',1,NULL,'Number of pages in the index'),('kamar','bravo_space_translations','PRIMARY','2025-11-07 06:00:10','n_diff_pfx01',0,1,'id'),('kamar','bravo_space_translations','PRIMARY','2025-11-07 06:00:10','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','bravo_space_translations','PRIMARY','2025-11-07 06:00:10','size',1,NULL,'Number of pages in the index'),('kamar','bravo_space_translations','bravo_space_translations_locale_index','2025-11-07 06:00:10','n_diff_pfx01',0,1,'locale'),('kamar','bravo_space_translations','bravo_space_translations_locale_index','2025-11-07 06:00:10','n_diff_pfx02',0,1,'locale,id'),('kamar','bravo_space_translations','bravo_space_translations_locale_index','2025-11-07 06:00:10','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','bravo_space_translations','bravo_space_translations_locale_index','2025-11-07 06:00:10','size',1,NULL,'Number of pages in the index'),('kamar','bravo_spaces','PRIMARY','2025-11-07 06:00:10','n_diff_pfx01',22,5,'id'),('kamar','bravo_spaces','PRIMARY','2025-11-07 06:00:10','n_leaf_pages',5,NULL,'Number of leaf pages in the index'),('kamar','bravo_spaces','PRIMARY','2025-11-07 06:00:10','size',6,NULL,'Number of pages in the index'),('kamar','bravo_spaces','bravo_spaces_slug_index','2025-11-07 06:00:10','n_diff_pfx01',22,1,'slug'),('kamar','bravo_spaces','bravo_spaces_slug_index','2025-11-07 06:00:10','n_diff_pfx02',22,1,'slug,id'),('kamar','bravo_spaces','bravo_spaces_slug_index','2025-11-07 06:00:10','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','bravo_spaces','bravo_spaces_slug_index','2025-11-07 06:00:10','size',1,NULL,'Number of pages in the index'),('kamar','bravo_terms','PRIMARY','2025-11-07 06:00:10','n_diff_pfx01',186,1,'id'),('kamar','bravo_terms','PRIMARY','2025-11-07 06:00:10','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','bravo_terms','PRIMARY','2025-11-07 06:00:10','size',1,NULL,'Number of pages in the index'),('kamar','bravo_terms_translations','PRIMARY','2025-11-07 06:00:10','n_diff_pfx01',0,1,'id'),('kamar','bravo_terms_translations','PRIMARY','2025-11-07 06:00:10','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','bravo_terms_translations','PRIMARY','2025-11-07 06:00:10','size',1,NULL,'Number of pages in the index'),('kamar','bravo_terms_translations','bravo_terms_translations_origin_id_locale_unique','2025-11-07 06:00:10','n_diff_pfx01',0,1,'origin_id'),('kamar','bravo_terms_translations','bravo_terms_translations_origin_id_locale_unique','2025-11-07 06:00:10','n_diff_pfx02',0,1,'origin_id,locale'),('kamar','bravo_terms_translations','bravo_terms_translations_origin_id_locale_unique','2025-11-07 06:00:10','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','bravo_terms_translations','bravo_terms_translations_origin_id_locale_unique','2025-11-07 06:00:10','size',1,NULL,'Number of pages in the index'),('kamar','bravo_tour_category','PRIMARY','2025-11-07 06:00:27','n_diff_pfx01',8,1,'id'),('kamar','bravo_tour_category','PRIMARY','2025-11-07 06:00:27','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','bravo_tour_category','PRIMARY','2025-11-07 06:00:27','size',1,NULL,'Number of pages in the index'),('kamar','bravo_tour_category','bravo_tour_category__lft__rgt_parent_id_index','2025-11-07 06:00:27','n_diff_pfx01',8,1,'_lft'),('kamar','bravo_tour_category','bravo_tour_category__lft__rgt_parent_id_index','2025-11-07 06:00:27','n_diff_pfx02',8,1,'_lft,_rgt'),('kamar','bravo_tour_category','bravo_tour_category__lft__rgt_parent_id_index','2025-11-07 06:00:27','n_diff_pfx03',8,1,'_lft,_rgt,parent_id'),('kamar','bravo_tour_category','bravo_tour_category__lft__rgt_parent_id_index','2025-11-07 06:00:27','n_diff_pfx04',8,1,'_lft,_rgt,parent_id,id'),('kamar','bravo_tour_category','bravo_tour_category__lft__rgt_parent_id_index','2025-11-07 06:00:27','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','bravo_tour_category','bravo_tour_category__lft__rgt_parent_id_index','2025-11-07 06:00:27','size',1,NULL,'Number of pages in the index'),('kamar','bravo_tour_category_translations','PRIMARY','2025-11-07 06:00:11','n_diff_pfx01',0,1,'id'),('kamar','bravo_tour_category_translations','PRIMARY','2025-11-07 06:00:11','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','bravo_tour_category_translations','PRIMARY','2025-11-07 06:00:11','size',1,NULL,'Number of pages in the index'),('kamar','bravo_tour_category_translations','bravo_tour_category_translations_origin_id_locale_unique','2025-11-07 06:00:11','n_diff_pfx01',0,1,'origin_id'),('kamar','bravo_tour_category_translations','bravo_tour_category_translations_origin_id_locale_unique','2025-11-07 06:00:11','n_diff_pfx02',0,1,'origin_id,locale'),('kamar','bravo_tour_category_translations','bravo_tour_category_translations_origin_id_locale_unique','2025-11-07 06:00:11','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','bravo_tour_category_translations','bravo_tour_category_translations_origin_id_locale_unique','2025-11-07 06:00:11','size',1,NULL,'Number of pages in the index'),('kamar','bravo_tour_dates','PRIMARY','2025-11-07 06:00:47','n_diff_pfx01',5,1,'id'),('kamar','bravo_tour_dates','PRIMARY','2025-11-07 06:00:47','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','bravo_tour_dates','PRIMARY','2025-11-07 06:00:47','size',1,NULL,'Number of pages in the index'),('kamar','bravo_tour_meta','PRIMARY','2025-11-07 06:01:07','n_diff_pfx01',36,1,'id'),('kamar','bravo_tour_meta','PRIMARY','2025-11-07 06:01:07','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','bravo_tour_meta','PRIMARY','2025-11-07 06:01:07','size',1,NULL,'Number of pages in the index'),('kamar','bravo_tour_term','PRIMARY','2025-11-07 06:01:27','n_diff_pfx01',308,1,'id'),('kamar','bravo_tour_term','PRIMARY','2025-11-07 06:01:27','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','bravo_tour_term','PRIMARY','2025-11-07 06:01:27','size',1,NULL,'Number of pages in the index'),('kamar','bravo_tour_translations','PRIMARY','2025-11-07 06:01:47','n_diff_pfx01',2,1,'id'),('kamar','bravo_tour_translations','PRIMARY','2025-11-07 06:01:47','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','bravo_tour_translations','PRIMARY','2025-11-07 06:01:47','size',1,NULL,'Number of pages in the index'),('kamar','bravo_tour_translations','bravo_tour_translations_origin_id_locale_unique','2025-11-07 06:01:47','n_diff_pfx01',2,1,'origin_id'),('kamar','bravo_tour_translations','bravo_tour_translations_origin_id_locale_unique','2025-11-07 06:01:47','n_diff_pfx02',2,1,'origin_id,locale'),('kamar','bravo_tour_translations','bravo_tour_translations_origin_id_locale_unique','2025-11-07 06:01:47','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','bravo_tour_translations','bravo_tour_translations_origin_id_locale_unique','2025-11-07 06:01:47','size',1,NULL,'Number of pages in the index'),('kamar','bravo_tour_translations','bravo_tour_translations_slug_index','2025-11-07 06:01:47','n_diff_pfx01',1,1,'slug'),('kamar','bravo_tour_translations','bravo_tour_translations_slug_index','2025-11-07 06:01:47','n_diff_pfx02',2,1,'slug,id'),('kamar','bravo_tour_translations','bravo_tour_translations_slug_index','2025-11-07 06:01:47','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','bravo_tour_translations','bravo_tour_translations_slug_index','2025-11-07 06:01:47','size',1,NULL,'Number of pages in the index'),('kamar','bravo_tours','PRIMARY','2025-11-07 06:00:11','n_diff_pfx01',36,12,'id'),('kamar','bravo_tours','PRIMARY','2025-11-07 06:00:11','n_leaf_pages',12,NULL,'Number of leaf pages in the index'),('kamar','bravo_tours','PRIMARY','2025-11-07 06:00:11','size',13,NULL,'Number of pages in the index'),('kamar','bravo_tours','bravo_tours_slug_index','2025-11-07 06:00:11','n_diff_pfx01',36,1,'slug'),('kamar','bravo_tours','bravo_tours_slug_index','2025-11-07 06:00:11','n_diff_pfx02',36,1,'slug,id'),('kamar','bravo_tours','bravo_tours_slug_index','2025-11-07 06:00:11','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','bravo_tours','bravo_tours_slug_index','2025-11-07 06:00:11','size',1,NULL,'Number of pages in the index'),('kamar','ch_favorites','PRIMARY','2025-11-07 05:59:59','n_diff_pfx01',0,1,'id'),('kamar','ch_favorites','PRIMARY','2025-11-07 05:59:59','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','ch_favorites','PRIMARY','2025-11-07 05:59:59','size',1,NULL,'Number of pages in the index'),('kamar','ch_messages','PRIMARY','2025-11-07 05:59:59','n_diff_pfx01',0,1,'id'),('kamar','ch_messages','PRIMARY','2025-11-07 05:59:59','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','ch_messages','PRIMARY','2025-11-07 05:59:59','size',1,NULL,'Number of pages in the index'),('kamar','cities','PRIMARY','2025-11-07 06:02:07','n_diff_pfx01',499,3,'id'),('kamar','cities','PRIMARY','2025-11-07 06:02:07','n_leaf_pages',3,NULL,'Number of leaf pages in the index'),('kamar','cities','PRIMARY','2025-11-07 06:02:07','size',4,NULL,'Number of pages in the index'),('kamar','core_inbox','PRIMARY','2025-11-07 06:00:11','n_diff_pfx01',0,1,'id'),('kamar','core_inbox','PRIMARY','2025-11-07 06:00:11','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','core_inbox','PRIMARY','2025-11-07 06:00:11','size',1,NULL,'Number of pages in the index'),('kamar','core_inbox_messages','PRIMARY','2025-11-07 06:00:11','n_diff_pfx01',0,1,'id'),('kamar','core_inbox_messages','PRIMARY','2025-11-07 06:00:11','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','core_inbox_messages','PRIMARY','2025-11-07 06:00:11','size',1,NULL,'Number of pages in the index'),('kamar','core_languages','PRIMARY','2025-11-07 06:53:23','n_diff_pfx01',13,1,'id'),('kamar','core_languages','PRIMARY','2025-11-07 06:53:23','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','core_languages','PRIMARY','2025-11-07 06:53:23','size',1,NULL,'Number of pages in the index'),('kamar','core_menu_translations','PRIMARY','2025-11-07 06:00:11','n_diff_pfx01',4,2,'id'),('kamar','core_menu_translations','PRIMARY','2025-11-07 06:00:11','n_leaf_pages',2,NULL,'Number of leaf pages in the index'),('kamar','core_menu_translations','PRIMARY','2025-11-07 06:00:11','size',3,NULL,'Number of pages in the index'),('kamar','core_menu_translations','core_menu_translations_locale_index','2025-11-07 06:00:11','n_diff_pfx01',2,1,'locale'),('kamar','core_menu_translations','core_menu_translations_locale_index','2025-11-07 06:00:11','n_diff_pfx02',4,1,'locale,id'),('kamar','core_menu_translations','core_menu_translations_locale_index','2025-11-07 06:00:11','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','core_menu_translations','core_menu_translations_locale_index','2025-11-07 06:00:11','size',1,NULL,'Number of pages in the index'),('kamar','core_menus','PRIMARY','2025-11-07 06:00:11','n_diff_pfx01',3,1,'id'),('kamar','core_menus','PRIMARY','2025-11-07 06:00:11','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','core_menus','PRIMARY','2025-11-07 06:00:11','size',1,NULL,'Number of pages in the index'),('kamar','core_model_has_permissions','PRIMARY','2025-11-07 06:00:16','n_diff_pfx01',0,1,'permission_id'),('kamar','core_model_has_permissions','PRIMARY','2025-11-07 06:00:16','n_diff_pfx02',0,1,'permission_id,model_id'),('kamar','core_model_has_permissions','PRIMARY','2025-11-07 06:00:16','n_diff_pfx03',0,1,'permission_id,model_id,model_type'),('kamar','core_model_has_permissions','PRIMARY','2025-11-07 06:00:16','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','core_model_has_permissions','PRIMARY','2025-11-07 06:00:16','size',1,NULL,'Number of pages in the index'),('kamar','core_model_has_permissions','core_model_has_permissions_model_id_model_type_index','2025-11-07 06:00:16','n_diff_pfx01',0,1,'model_id'),('kamar','core_model_has_permissions','core_model_has_permissions_model_id_model_type_index','2025-11-07 06:00:16','n_diff_pfx02',0,1,'model_id,model_type'),('kamar','core_model_has_permissions','core_model_has_permissions_model_id_model_type_index','2025-11-07 06:00:16','n_diff_pfx03',0,1,'model_id,model_type,permission_id'),('kamar','core_model_has_permissions','core_model_has_permissions_model_id_model_type_index','2025-11-07 06:00:16','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','core_model_has_permissions','core_model_has_permissions_model_id_model_type_index','2025-11-07 06:00:16','size',1,NULL,'Number of pages in the index'),('kamar','core_model_has_roles','PRIMARY','2025-11-07 06:00:17','n_diff_pfx01',4,7,'role_id'),('kamar','core_model_has_roles','PRIMARY','2025-11-07 06:00:17','n_diff_pfx02',2250,7,'role_id,model_id'),('kamar','core_model_has_roles','PRIMARY','2025-11-07 06:00:17','n_diff_pfx03',2250,7,'role_id,model_id,model_type'),('kamar','core_model_has_roles','PRIMARY','2025-11-07 06:00:17','n_leaf_pages',7,NULL,'Number of leaf pages in the index'),('kamar','core_model_has_roles','PRIMARY','2025-11-07 06:00:17','size',8,NULL,'Number of pages in the index'),('kamar','core_model_has_roles','core_model_has_roles_model_id_model_type_index','2025-11-07 06:00:17','n_diff_pfx01',2250,5,'model_id'),('kamar','core_model_has_roles','core_model_has_roles_model_id_model_type_index','2025-11-07 06:00:17','n_diff_pfx02',2250,5,'model_id,model_type'),('kamar','core_model_has_roles','core_model_has_roles_model_id_model_type_index','2025-11-07 06:00:17','n_diff_pfx03',2250,5,'model_id,model_type,role_id'),('kamar','core_model_has_roles','core_model_has_roles_model_id_model_type_index','2025-11-07 06:00:17','n_leaf_pages',5,NULL,'Number of leaf pages in the index'),('kamar','core_model_has_roles','core_model_has_roles_model_id_model_type_index','2025-11-07 06:00:17','size',6,NULL,'Number of pages in the index'),('kamar','core_news','PRIMARY','2025-11-07 06:00:12','n_diff_pfx01',16,2,'id'),('kamar','core_news','PRIMARY','2025-11-07 06:00:12','n_leaf_pages',2,NULL,'Number of leaf pages in the index'),('kamar','core_news','PRIMARY','2025-11-07 06:00:12','size',3,NULL,'Number of pages in the index'),('kamar','core_news_category','PRIMARY','2025-11-07 06:00:12','n_diff_pfx01',12,1,'id'),('kamar','core_news_category','PRIMARY','2025-11-07 06:00:12','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','core_news_category','PRIMARY','2025-11-07 06:00:12','size',1,NULL,'Number of pages in the index'),('kamar','core_news_category','core_news_category__lft__rgt_parent_id_index','2025-11-07 06:00:12','n_diff_pfx01',12,1,'_lft'),('kamar','core_news_category','core_news_category__lft__rgt_parent_id_index','2025-11-07 06:00:12','n_diff_pfx02',12,1,'_lft,_rgt'),('kamar','core_news_category','core_news_category__lft__rgt_parent_id_index','2025-11-07 06:00:12','n_diff_pfx03',12,1,'_lft,_rgt,parent_id'),('kamar','core_news_category','core_news_category__lft__rgt_parent_id_index','2025-11-07 06:00:12','n_diff_pfx04',12,1,'_lft,_rgt,parent_id,id'),('kamar','core_news_category','core_news_category__lft__rgt_parent_id_index','2025-11-07 06:00:12','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','core_news_category','core_news_category__lft__rgt_parent_id_index','2025-11-07 06:00:12','size',1,NULL,'Number of pages in the index'),('kamar','core_news_category_translations','PRIMARY','2025-11-07 06:00:12','n_diff_pfx01',0,1,'id'),('kamar','core_news_category_translations','PRIMARY','2025-11-07 06:00:12','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','core_news_category_translations','PRIMARY','2025-11-07 06:00:12','size',1,NULL,'Number of pages in the index'),('kamar','core_news_category_translations','core_news_category_translations_locale_index','2025-11-07 06:00:12','n_diff_pfx01',0,1,'locale'),('kamar','core_news_category_translations','core_news_category_translations_locale_index','2025-11-07 06:00:12','n_diff_pfx02',0,1,'locale,id'),('kamar','core_news_category_translations','core_news_category_translations_locale_index','2025-11-07 06:00:12','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','core_news_category_translations','core_news_category_translations_locale_index','2025-11-07 06:00:12','size',1,NULL,'Number of pages in the index'),('kamar','core_news_tag','PRIMARY','2025-11-07 06:00:12','n_diff_pfx01',0,1,'id'),('kamar','core_news_tag','PRIMARY','2025-11-07 06:00:12','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','core_news_tag','PRIMARY','2025-11-07 06:00:12','size',1,NULL,'Number of pages in the index'),('kamar','core_news_translations','PRIMARY','2025-11-07 06:00:12','n_diff_pfx01',0,1,'id'),('kamar','core_news_translations','PRIMARY','2025-11-07 06:00:12','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','core_news_translations','PRIMARY','2025-11-07 06:00:12','size',1,NULL,'Number of pages in the index'),('kamar','core_news_translations','core_news_translations_locale_index','2025-11-07 06:00:12','n_diff_pfx01',0,1,'locale'),('kamar','core_news_translations','core_news_translations_locale_index','2025-11-07 06:00:12','n_diff_pfx02',0,1,'locale,id'),('kamar','core_news_translations','core_news_translations_locale_index','2025-11-07 06:00:12','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','core_news_translations','core_news_translations_locale_index','2025-11-07 06:00:12','size',1,NULL,'Number of pages in the index'),('kamar','core_notifications','PRIMARY','2025-11-07 06:00:12','n_diff_pfx01',0,1,'id'),('kamar','core_notifications','PRIMARY','2025-11-07 06:00:12','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','core_notifications','PRIMARY','2025-11-07 06:00:12','size',1,NULL,'Number of pages in the index'),('kamar','core_page_translations','PRIMARY','2025-11-07 06:00:12','n_diff_pfx01',0,1,'id'),('kamar','core_page_translations','PRIMARY','2025-11-07 06:00:12','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','core_page_translations','PRIMARY','2025-11-07 06:00:12','size',1,NULL,'Number of pages in the index'),('kamar','core_page_translations','core_page_translations_locale_index','2025-11-07 06:00:12','n_diff_pfx01',0,1,'locale'),('kamar','core_page_translations','core_page_translations_locale_index','2025-11-07 06:00:12','n_diff_pfx02',0,1,'locale,id'),('kamar','core_page_translations','core_page_translations_locale_index','2025-11-07 06:00:12','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','core_page_translations','core_page_translations_locale_index','2025-11-07 06:00:12','size',1,NULL,'Number of pages in the index'),('kamar','core_page_translations','core_page_translations_origin_id_locale_unique','2025-11-07 06:00:12','n_diff_pfx01',0,1,'origin_id'),('kamar','core_page_translations','core_page_translations_origin_id_locale_unique','2025-11-07 06:00:12','n_diff_pfx02',0,1,'origin_id,locale'),('kamar','core_page_translations','core_page_translations_origin_id_locale_unique','2025-11-07 06:00:12','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','core_page_translations','core_page_translations_origin_id_locale_unique','2025-11-07 06:00:12','size',1,NULL,'Number of pages in the index'),('kamar','core_pages','PRIMARY','2025-11-07 06:00:12','n_diff_pfx01',18,1,'id'),('kamar','core_pages','PRIMARY','2025-11-07 06:00:12','n_leaf_pages',4,NULL,'Number of leaf pages in the index'),('kamar','core_pages','PRIMARY','2025-11-07 06:00:12','size',5,NULL,'Number of pages in the index'),('kamar','core_pages','core_pages_slug_index','2025-11-07 06:00:12','n_diff_pfx01',10,1,'slug'),('kamar','core_pages','core_pages_slug_index','2025-11-07 06:00:12','n_diff_pfx02',18,1,'slug,id'),('kamar','core_pages','core_pages_slug_index','2025-11-07 06:00:12','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','core_pages','core_pages_slug_index','2025-11-07 06:00:12','size',1,NULL,'Number of pages in the index'),('kamar','core_permissions','PRIMARY','2025-11-07 06:00:12','n_diff_pfx01',109,1,'id'),('kamar','core_permissions','PRIMARY','2025-11-07 06:00:12','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','core_permissions','PRIMARY','2025-11-07 06:00:12','size',1,NULL,'Number of pages in the index'),('kamar','core_role_has_permissions','PRIMARY','2025-11-07 06:00:17','n_diff_pfx01',108,1,'permission_id'),('kamar','core_role_has_permissions','PRIMARY','2025-11-07 06:00:17','n_diff_pfx02',186,1,'permission_id,role_id'),('kamar','core_role_has_permissions','PRIMARY','2025-11-07 06:00:17','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','core_role_has_permissions','PRIMARY','2025-11-07 06:00:17','size',1,NULL,'Number of pages in the index'),('kamar','core_role_has_permissions','core_role_has_permissions_role_id_foreign','2025-11-07 06:00:17','n_diff_pfx01',5,1,'role_id'),('kamar','core_role_has_permissions','core_role_has_permissions_role_id_foreign','2025-11-07 06:00:17','n_diff_pfx02',186,1,'role_id,permission_id'),('kamar','core_role_has_permissions','core_role_has_permissions_role_id_foreign','2025-11-07 06:00:17','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','core_role_has_permissions','core_role_has_permissions_role_id_foreign','2025-11-07 06:00:17','size',1,NULL,'Number of pages in the index'),('kamar','core_roles','PRIMARY','2025-11-07 06:00:12','n_diff_pfx01',6,1,'id'),('kamar','core_roles','PRIMARY','2025-11-07 06:00:12','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','core_roles','PRIMARY','2025-11-07 06:00:12','size',1,NULL,'Number of pages in the index'),('kamar','core_settings','PRIMARY','2025-11-07 06:00:13','n_diff_pfx01',673,6,'id'),('kamar','core_settings','PRIMARY','2025-11-07 06:00:13','n_leaf_pages',6,NULL,'Number of leaf pages in the index'),('kamar','core_settings','PRIMARY','2025-11-07 06:00:13','size',7,NULL,'Number of pages in the index'),('kamar','core_subscribers','PRIMARY','2025-11-07 06:00:13','n_diff_pfx01',4666,19,'id'),('kamar','core_subscribers','PRIMARY','2025-11-07 06:00:13','n_leaf_pages',19,NULL,'Number of leaf pages in the index'),('kamar','core_subscribers','PRIMARY','2025-11-07 06:00:13','size',20,NULL,'Number of pages in the index'),('kamar','core_tag_translations','PRIMARY','2025-11-07 06:00:13','n_diff_pfx01',0,1,'id'),('kamar','core_tag_translations','PRIMARY','2025-11-07 06:00:13','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','core_tag_translations','PRIMARY','2025-11-07 06:00:13','size',1,NULL,'Number of pages in the index'),('kamar','core_tag_translations','core_tag_translations_locale_index','2025-11-07 06:00:13','n_diff_pfx01',0,1,'locale'),('kamar','core_tag_translations','core_tag_translations_locale_index','2025-11-07 06:00:13','n_diff_pfx02',0,1,'locale,id'),('kamar','core_tag_translations','core_tag_translations_locale_index','2025-11-07 06:00:13','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','core_tag_translations','core_tag_translations_locale_index','2025-11-07 06:00:13','size',1,NULL,'Number of pages in the index'),('kamar','core_tags','PRIMARY','2025-11-07 06:00:13','n_diff_pfx01',12,1,'id'),('kamar','core_tags','PRIMARY','2025-11-07 06:00:13','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','core_tags','PRIMARY','2025-11-07 06:00:13','size',1,NULL,'Number of pages in the index'),('kamar','core_template_translations','PRIMARY','2025-11-07 06:00:13','n_diff_pfx01',9,4,'id'),('kamar','core_template_translations','PRIMARY','2025-11-07 06:00:13','n_leaf_pages',4,NULL,'Number of leaf pages in the index'),('kamar','core_template_translations','PRIMARY','2025-11-07 06:00:13','size',5,NULL,'Number of pages in the index'),('kamar','core_template_translations','core_template_translations_locale_index','2025-11-07 06:00:13','n_diff_pfx01',2,1,'locale'),('kamar','core_template_translations','core_template_translations_locale_index','2025-11-07 06:00:13','n_diff_pfx02',9,1,'locale,id'),('kamar','core_template_translations','core_template_translations_locale_index','2025-11-07 06:00:13','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','core_template_translations','core_template_translations_locale_index','2025-11-07 06:00:13','size',1,NULL,'Number of pages in the index'),('kamar','core_templates','PRIMARY','2025-11-07 06:00:13','n_diff_pfx01',8,3,'id'),('kamar','core_templates','PRIMARY','2025-11-07 06:00:13','n_leaf_pages',3,NULL,'Number of leaf pages in the index'),('kamar','core_templates','PRIMARY','2025-11-07 06:00:13','size',4,NULL,'Number of pages in the index'),('kamar','core_translations','PRIMARY','2025-11-07 06:00:13','n_diff_pfx01',4012,18,'id'),('kamar','core_translations','PRIMARY','2025-11-07 06:00:13','n_leaf_pages',18,NULL,'Number of leaf pages in the index'),('kamar','core_translations','PRIMARY','2025-11-07 06:00:13','size',19,NULL,'Number of pages in the index'),('kamar','core_vendor_plan_meta','PRIMARY','2025-11-07 06:00:13','n_diff_pfx01',0,1,'id'),('kamar','core_vendor_plan_meta','PRIMARY','2025-11-07 06:00:13','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','core_vendor_plan_meta','PRIMARY','2025-11-07 06:00:13','size',1,NULL,'Number of pages in the index'),('kamar','core_vendor_plans','PRIMARY','2025-11-07 06:00:13','n_diff_pfx01',0,1,'id'),('kamar','core_vendor_plans','PRIMARY','2025-11-07 06:00:13','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','core_vendor_plans','PRIMARY','2025-11-07 06:00:13','size',1,NULL,'Number of pages in the index'),('kamar','donations','PRIMARY','2025-11-07 06:00:14','n_diff_pfx01',0,1,'id'),('kamar','donations','PRIMARY','2025-11-07 06:00:14','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','donations','PRIMARY','2025-11-07 06:00:14','size',1,NULL,'Number of pages in the index'),('kamar','email_providers','PRIMARY','2025-11-07 06:00:14','n_diff_pfx01',0,1,'id'),('kamar','email_providers','PRIMARY','2025-11-07 06:00:14','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','email_providers','PRIMARY','2025-11-07 06:00:14','size',1,NULL,'Number of pages in the index'),('kamar','email_providers','email_providers_provider_unique','2025-11-07 06:00:14','n_diff_pfx01',0,1,'provider'),('kamar','email_providers','email_providers_provider_unique','2025-11-07 06:00:14','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','email_providers','email_providers_provider_unique','2025-11-07 06:00:14','size',1,NULL,'Number of pages in the index'),('kamar','fonts','PRIMARY','2025-11-07 06:48:45','n_diff_pfx01',0,1,'id'),('kamar','fonts','PRIMARY','2025-11-07 06:48:45','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','fonts','PRIMARY','2025-11-07 06:48:45','size',1,NULL,'Number of pages in the index'),('kamar','jobs','PRIMARY','2025-11-07 06:00:14','n_diff_pfx01',0,1,'id'),('kamar','jobs','PRIMARY','2025-11-07 06:00:14','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','jobs','PRIMARY','2025-11-07 06:00:14','size',1,NULL,'Number of pages in the index'),('kamar','jobs','jobs_queue_index','2025-11-07 06:00:14','n_diff_pfx01',0,1,'queue'),('kamar','jobs','jobs_queue_index','2025-11-07 06:00:14','n_diff_pfx02',0,1,'queue,id'),('kamar','jobs','jobs_queue_index','2025-11-07 06:00:14','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','jobs','jobs_queue_index','2025-11-07 06:00:14','size',1,NULL,'Number of pages in the index'),('kamar','location_category','PRIMARY','2025-11-07 06:00:14','n_diff_pfx01',3,1,'id'),('kamar','location_category','PRIMARY','2025-11-07 06:00:14','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','location_category','PRIMARY','2025-11-07 06:00:14','size',1,NULL,'Number of pages in the index'),('kamar','location_category','location_category__lft__rgt_parent_id_index','2025-11-07 06:00:14','n_diff_pfx01',1,1,'_lft'),('kamar','location_category','location_category__lft__rgt_parent_id_index','2025-11-07 06:00:14','n_diff_pfx02',1,1,'_lft,_rgt'),('kamar','location_category','location_category__lft__rgt_parent_id_index','2025-11-07 06:00:14','n_diff_pfx03',1,1,'_lft,_rgt,parent_id'),('kamar','location_category','location_category__lft__rgt_parent_id_index','2025-11-07 06:00:14','n_diff_pfx04',3,1,'_lft,_rgt,parent_id,id'),('kamar','location_category','location_category__lft__rgt_parent_id_index','2025-11-07 06:00:14','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','location_category','location_category__lft__rgt_parent_id_index','2025-11-07 06:00:14','size',1,NULL,'Number of pages in the index'),('kamar','location_category_translations','PRIMARY','2025-11-07 06:00:14','n_diff_pfx01',0,1,'id'),('kamar','location_category_translations','PRIMARY','2025-11-07 06:00:14','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','location_category_translations','PRIMARY','2025-11-07 06:00:14','size',1,NULL,'Number of pages in the index'),('kamar','location_category_translations','location_category_translations_origin_id_locale_unique','2025-11-07 06:00:14','n_diff_pfx01',0,1,'origin_id'),('kamar','location_category_translations','location_category_translations_origin_id_locale_unique','2025-11-07 06:00:14','n_diff_pfx02',0,1,'origin_id,locale'),('kamar','location_category_translations','location_category_translations_origin_id_locale_unique','2025-11-07 06:00:14','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','location_category_translations','location_category_translations_origin_id_locale_unique','2025-11-07 06:00:14','size',1,NULL,'Number of pages in the index'),('kamar','mailblock','PRIMARY','2025-11-07 06:48:45','n_diff_pfx01',0,1,'id'),('kamar','mailblock','PRIMARY','2025-11-07 06:48:45','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','mailblock','PRIMARY','2025-11-07 06:48:45','size',1,NULL,'Number of pages in the index'),('kamar','mailman','PRIMARY','2025-11-07 06:00:14','n_diff_pfx01',7,1,'id'),('kamar','mailman','PRIMARY','2025-11-07 06:00:14','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','mailman','PRIMARY','2025-11-07 06:00:14','size',1,NULL,'Number of pages in the index'),('kamar','media_files','PRIMARY','2025-11-07 06:00:14','n_diff_pfx01',13,1,'id'),('kamar','media_files','PRIMARY','2025-11-07 06:00:14','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','media_files','PRIMARY','2025-11-07 06:00:14','size',1,NULL,'Number of pages in the index'),('kamar','migrations','PRIMARY','2025-11-07 06:00:14','n_diff_pfx01',87,1,'id'),('kamar','migrations','PRIMARY','2025-11-07 06:00:14','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','migrations','PRIMARY','2025-11-07 06:00:14','size',1,NULL,'Number of pages in the index'),('kamar','notifications','PRIMARY','2025-11-07 06:00:04','n_diff_pfx01',5115,20,'id'),('kamar','notifications','PRIMARY','2025-11-07 06:00:04','n_leaf_pages',147,NULL,'Number of leaf pages in the index'),('kamar','notifications','PRIMARY','2025-11-07 06:00:04','size',225,NULL,'Number of pages in the index'),('kamar','notifications','notifications_notifiable_type_notifiable_id_index','2025-11-07 06:00:04','n_diff_pfx01',1,20,'notifiable_type'),('kamar','notifications','notifications_notifiable_type_notifiable_id_index','2025-11-07 06:00:04','n_diff_pfx02',902,20,'notifiable_type,notifiable_id'),('kamar','notifications','notifications_notifiable_type_notifiable_id_index','2025-11-07 06:00:04','n_diff_pfx03',5242,20,'notifiable_type,notifiable_id,id'),('kamar','notifications','notifications_notifiable_type_notifiable_id_index','2025-11-07 06:00:04','n_leaf_pages',20,NULL,'Number of leaf pages in the index'),('kamar','notifications','notifications_notifiable_type_notifiable_id_index','2025-11-07 06:00:04','size',21,NULL,'Number of pages in the index'),('kamar','password_resets','GEN_CLUST_INDEX','2025-11-07 06:00:06','n_diff_pfx01',684,6,'DB_ROW_ID'),('kamar','password_resets','GEN_CLUST_INDEX','2025-11-07 06:00:06','n_leaf_pages',6,NULL,'Number of leaf pages in the index'),('kamar','password_resets','GEN_CLUST_INDEX','2025-11-07 06:00:06','size',7,NULL,'Number of pages in the index'),('kamar','password_resets','password_resets_email_index','2025-11-07 06:00:06','n_diff_pfx01',684,2,'email'),('kamar','password_resets','password_resets_email_index','2025-11-07 06:00:06','n_diff_pfx02',684,2,'email,DB_ROW_ID'),('kamar','password_resets','password_resets_email_index','2025-11-07 06:00:06','n_leaf_pages',2,NULL,'Number of leaf pages in the index'),('kamar','password_resets','password_resets_email_index','2025-11-07 06:00:06','size',3,NULL,'Number of pages in the index'),('kamar','personal_access_tokens','PRIMARY','2025-11-07 06:00:14','n_diff_pfx01',17,1,'id'),('kamar','personal_access_tokens','PRIMARY','2025-11-07 06:00:14','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','personal_access_tokens','PRIMARY','2025-11-07 06:00:14','size',1,NULL,'Number of pages in the index'),('kamar','personal_access_tokens','personal_access_tokens_token_unique','2025-11-07 06:00:14','n_diff_pfx01',17,1,'token'),('kamar','personal_access_tokens','personal_access_tokens_token_unique','2025-11-07 06:00:14','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','personal_access_tokens','personal_access_tokens_token_unique','2025-11-07 06:00:14','size',1,NULL,'Number of pages in the index'),('kamar','personal_access_tokens','personal_access_tokens_tokenable_type_tokenable_id_index','2025-11-07 06:00:14','n_diff_pfx01',1,1,'tokenable_type'),('kamar','personal_access_tokens','personal_access_tokens_tokenable_type_tokenable_id_index','2025-11-07 06:00:14','n_diff_pfx02',1,1,'tokenable_type,tokenable_id'),('kamar','personal_access_tokens','personal_access_tokens_tokenable_type_tokenable_id_index','2025-11-07 06:00:14','n_diff_pfx03',17,1,'tokenable_type,tokenable_id,id'),('kamar','personal_access_tokens','personal_access_tokens_tokenable_type_tokenable_id_index','2025-11-07 06:00:14','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','personal_access_tokens','personal_access_tokens_tokenable_type_tokenable_id_index','2025-11-07 06:00:14','size',1,NULL,'Number of pages in the index'),('kamar','social_forums','PRIMARY','2025-11-07 06:00:14','n_diff_pfx01',14,1,'id'),('kamar','social_forums','PRIMARY','2025-11-07 06:00:14','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','social_forums','PRIMARY','2025-11-07 06:00:14','size',1,NULL,'Number of pages in the index'),('kamar','social_group_user','PRIMARY','2025-11-07 06:00:15','n_diff_pfx01',0,1,'id'),('kamar','social_group_user','PRIMARY','2025-11-07 06:00:15','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','social_group_user','PRIMARY','2025-11-07 06:00:15','size',1,NULL,'Number of pages in the index'),('kamar','social_groups','PRIMARY','2025-11-07 06:00:15','n_diff_pfx01',0,1,'id'),('kamar','social_groups','PRIMARY','2025-11-07 06:00:15','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','social_groups','PRIMARY','2025-11-07 06:00:15','size',1,NULL,'Number of pages in the index'),('kamar','social_post_comments','PRIMARY','2025-11-07 06:00:15','n_diff_pfx01',0,1,'id'),('kamar','social_post_comments','PRIMARY','2025-11-07 06:00:15','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','social_post_comments','PRIMARY','2025-11-07 06:00:15','size',1,NULL,'Number of pages in the index'),('kamar','social_posts','PRIMARY','2025-11-07 06:00:15','n_diff_pfx01',0,1,'id'),('kamar','social_posts','PRIMARY','2025-11-07 06:00:15','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','social_posts','PRIMARY','2025-11-07 06:00:15','size',1,NULL,'Number of pages in the index'),('kamar','social_user_follow','PRIMARY','2025-11-07 06:00:15','n_diff_pfx01',0,1,'id'),('kamar','social_user_follow','PRIMARY','2025-11-07 06:00:15','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','social_user_follow','PRIMARY','2025-11-07 06:00:15','size',1,NULL,'Number of pages in the index'),('kamar','spam_registrations','PRIMARY','2025-11-07 06:00:15','n_diff_pfx01',2565,20,'id'),('kamar','spam_registrations','PRIMARY','2025-11-07 06:00:15','n_leaf_pages',48,NULL,'Number of leaf pages in the index'),('kamar','spam_registrations','PRIMARY','2025-11-07 06:00:15','size',97,NULL,'Number of pages in the index'),('kamar','user_meta','PRIMARY','2025-11-07 06:00:16','n_diff_pfx01',0,1,'id'),('kamar','user_meta','PRIMARY','2025-11-07 06:00:16','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','user_meta','PRIMARY','2025-11-07 06:00:16','size',1,NULL,'Number of pages in the index'),('kamar','user_suspends','PRIMARY','2025-11-07 06:00:16','n_diff_pfx01',1301,8,'id'),('kamar','user_suspends','PRIMARY','2025-11-07 06:00:16','n_leaf_pages',8,NULL,'Number of leaf pages in the index'),('kamar','user_suspends','PRIMARY','2025-11-07 06:00:16','size',9,NULL,'Number of pages in the index'),('kamar','user_transactions','PRIMARY','2025-11-07 06:00:17','n_diff_pfx01',0,1,'id'),('kamar','user_transactions','PRIMARY','2025-11-07 06:00:17','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','user_transactions','PRIMARY','2025-11-07 06:00:17','size',1,NULL,'Number of pages in the index'),('kamar','user_transactions','payable_confirmed_ind','2025-11-07 06:00:17','n_diff_pfx01',0,1,'payable_type'),('kamar','user_transactions','payable_confirmed_ind','2025-11-07 06:00:17','n_diff_pfx02',0,1,'payable_type,payable_id'),('kamar','user_transactions','payable_confirmed_ind','2025-11-07 06:00:17','n_diff_pfx03',0,1,'payable_type,payable_id,confirmed'),('kamar','user_transactions','payable_confirmed_ind','2025-11-07 06:00:17','n_diff_pfx04',0,1,'payable_type,payable_id,confirmed,id'),('kamar','user_transactions','payable_confirmed_ind','2025-11-07 06:00:17','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','user_transactions','payable_confirmed_ind','2025-11-07 06:00:17','size',1,NULL,'Number of pages in the index'),('kamar','user_transactions','payable_type_confirmed_ind','2025-11-07 06:00:17','n_diff_pfx01',0,1,'payable_type'),('kamar','user_transactions','payable_type_confirmed_ind','2025-11-07 06:00:17','n_diff_pfx02',0,1,'payable_type,payable_id'),('kamar','user_transactions','payable_type_confirmed_ind','2025-11-07 06:00:17','n_diff_pfx03',0,1,'payable_type,payable_id,type'),('kamar','user_transactions','payable_type_confirmed_ind','2025-11-07 06:00:17','n_diff_pfx04',0,1,'payable_type,payable_id,type,confirmed'),('kamar','user_transactions','payable_type_confirmed_ind','2025-11-07 06:00:17','n_diff_pfx05',0,1,'payable_type,payable_id,type,confirmed,id'),('kamar','user_transactions','payable_type_confirmed_ind','2025-11-07 06:00:17','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','user_transactions','payable_type_confirmed_ind','2025-11-07 06:00:17','size',1,NULL,'Number of pages in the index'),('kamar','user_transactions','payable_type_ind','2025-11-07 06:00:17','n_diff_pfx01',0,1,'payable_type'),('kamar','user_transactions','payable_type_ind','2025-11-07 06:00:17','n_diff_pfx02',0,1,'payable_type,payable_id'),('kamar','user_transactions','payable_type_ind','2025-11-07 06:00:17','n_diff_pfx03',0,1,'payable_type,payable_id,type'),('kamar','user_transactions','payable_type_ind','2025-11-07 06:00:17','n_diff_pfx04',0,1,'payable_type,payable_id,type,id'),('kamar','user_transactions','payable_type_ind','2025-11-07 06:00:17','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','user_transactions','payable_type_ind','2025-11-07 06:00:17','size',1,NULL,'Number of pages in the index'),('kamar','user_transactions','user_transactions_payable_type_payable_id_index','2025-11-07 06:00:17','n_diff_pfx01',0,1,'payable_type'),('kamar','user_transactions','user_transactions_payable_type_payable_id_index','2025-11-07 06:00:17','n_diff_pfx02',0,1,'payable_type,payable_id'),('kamar','user_transactions','user_transactions_payable_type_payable_id_index','2025-11-07 06:00:17','n_diff_pfx03',0,1,'payable_type,payable_id,id'),('kamar','user_transactions','user_transactions_payable_type_payable_id_index','2025-11-07 06:00:17','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','user_transactions','user_transactions_payable_type_payable_id_index','2025-11-07 06:00:17','size',1,NULL,'Number of pages in the index'),('kamar','user_transactions','user_transactions_type_index','2025-11-07 06:00:17','n_diff_pfx01',0,1,'type'),('kamar','user_transactions','user_transactions_type_index','2025-11-07 06:00:17','n_diff_pfx02',0,1,'type,id'),('kamar','user_transactions','user_transactions_type_index','2025-11-07 06:00:17','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','user_transactions','user_transactions_type_index','2025-11-07 06:00:17','size',1,NULL,'Number of pages in the index'),('kamar','user_transactions','user_transactions_uuid_unique','2025-11-07 06:00:17','n_diff_pfx01',0,1,'uuid'),('kamar','user_transactions','user_transactions_uuid_unique','2025-11-07 06:00:17','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','user_transactions','user_transactions_uuid_unique','2025-11-07 06:00:17','size',1,NULL,'Number of pages in the index'),('kamar','user_transactions','user_transactions_wallet_id_foreign','2025-11-07 06:00:17','n_diff_pfx01',0,1,'wallet_id'),('kamar','user_transactions','user_transactions_wallet_id_foreign','2025-11-07 06:00:17','n_diff_pfx02',0,1,'wallet_id,id'),('kamar','user_transactions','user_transactions_wallet_id_foreign','2025-11-07 06:00:17','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','user_transactions','user_transactions_wallet_id_foreign','2025-11-07 06:00:17','size',1,NULL,'Number of pages in the index'),('kamar','user_transfers','PRIMARY','2025-11-07 06:00:17','n_diff_pfx01',0,1,'id'),('kamar','user_transfers','PRIMARY','2025-11-07 06:00:17','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','user_transfers','PRIMARY','2025-11-07 06:00:17','size',1,NULL,'Number of pages in the index'),('kamar','user_transfers','user_transfers_deposit_id_foreign','2025-11-07 06:00:17','n_diff_pfx01',0,1,'deposit_id'),('kamar','user_transfers','user_transfers_deposit_id_foreign','2025-11-07 06:00:17','n_diff_pfx02',0,1,'deposit_id,id'),('kamar','user_transfers','user_transfers_deposit_id_foreign','2025-11-07 06:00:17','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','user_transfers','user_transfers_deposit_id_foreign','2025-11-07 06:00:17','size',1,NULL,'Number of pages in the index'),('kamar','user_transfers','user_transfers_from_type_from_id_index','2025-11-07 06:00:17','n_diff_pfx01',0,1,'from_type'),('kamar','user_transfers','user_transfers_from_type_from_id_index','2025-11-07 06:00:17','n_diff_pfx02',0,1,'from_type,from_id'),('kamar','user_transfers','user_transfers_from_type_from_id_index','2025-11-07 06:00:17','n_diff_pfx03',0,1,'from_type,from_id,id'),('kamar','user_transfers','user_transfers_from_type_from_id_index','2025-11-07 06:00:17','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','user_transfers','user_transfers_from_type_from_id_index','2025-11-07 06:00:17','size',1,NULL,'Number of pages in the index'),('kamar','user_transfers','user_transfers_to_type_to_id_index','2025-11-07 06:00:17','n_diff_pfx01',0,1,'to_type'),('kamar','user_transfers','user_transfers_to_type_to_id_index','2025-11-07 06:00:17','n_diff_pfx02',0,1,'to_type,to_id'),('kamar','user_transfers','user_transfers_to_type_to_id_index','2025-11-07 06:00:17','n_diff_pfx03',0,1,'to_type,to_id,id'),('kamar','user_transfers','user_transfers_to_type_to_id_index','2025-11-07 06:00:17','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','user_transfers','user_transfers_to_type_to_id_index','2025-11-07 06:00:17','size',1,NULL,'Number of pages in the index'),('kamar','user_transfers','user_transfers_uuid_unique','2025-11-07 06:00:17','n_diff_pfx01',0,1,'uuid'),('kamar','user_transfers','user_transfers_uuid_unique','2025-11-07 06:00:17','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','user_transfers','user_transfers_uuid_unique','2025-11-07 06:00:17','size',1,NULL,'Number of pages in the index'),('kamar','user_transfers','user_transfers_withdraw_id_foreign','2025-11-07 06:00:17','n_diff_pfx01',0,1,'withdraw_id'),('kamar','user_transfers','user_transfers_withdraw_id_foreign','2025-11-07 06:00:17','n_diff_pfx02',0,1,'withdraw_id,id'),('kamar','user_transfers','user_transfers_withdraw_id_foreign','2025-11-07 06:00:17','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','user_transfers','user_transfers_withdraw_id_foreign','2025-11-07 06:00:17','size',1,NULL,'Number of pages in the index'),('kamar','user_upgrade_request','PRIMARY','2025-11-07 06:00:16','n_diff_pfx01',3,1,'id'),('kamar','user_upgrade_request','PRIMARY','2025-11-07 06:00:16','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','user_upgrade_request','PRIMARY','2025-11-07 06:00:16','size',1,NULL,'Number of pages in the index'),('kamar','user_wallets','PRIMARY','2025-11-07 06:00:16','n_diff_pfx01',564,5,'id'),('kamar','user_wallets','PRIMARY','2025-11-07 06:00:16','n_leaf_pages',5,NULL,'Number of leaf pages in the index'),('kamar','user_wallets','PRIMARY','2025-11-07 06:00:16','size',6,NULL,'Number of pages in the index'),('kamar','user_wallets','user_wallets_holder_type_holder_id_index','2025-11-07 06:00:16','n_diff_pfx01',1,2,'holder_type'),('kamar','user_wallets','user_wallets_holder_type_holder_id_index','2025-11-07 06:00:16','n_diff_pfx02',564,2,'holder_type,holder_id'),('kamar','user_wallets','user_wallets_holder_type_holder_id_index','2025-11-07 06:00:16','n_diff_pfx03',564,2,'holder_type,holder_id,id'),('kamar','user_wallets','user_wallets_holder_type_holder_id_index','2025-11-07 06:00:16','n_leaf_pages',2,NULL,'Number of leaf pages in the index'),('kamar','user_wallets','user_wallets_holder_type_holder_id_index','2025-11-07 06:00:16','size',3,NULL,'Number of pages in the index'),('kamar','user_wallets','user_wallets_holder_type_holder_id_slug_unique','2025-11-07 06:00:16','n_diff_pfx01',1,2,'holder_type'),('kamar','user_wallets','user_wallets_holder_type_holder_id_slug_unique','2025-11-07 06:00:16','n_diff_pfx02',564,2,'holder_type,holder_id'),('kamar','user_wallets','user_wallets_holder_type_holder_id_slug_unique','2025-11-07 06:00:16','n_diff_pfx03',564,2,'holder_type,holder_id,slug'),('kamar','user_wallets','user_wallets_holder_type_holder_id_slug_unique','2025-11-07 06:00:16','n_leaf_pages',2,NULL,'Number of leaf pages in the index'),('kamar','user_wallets','user_wallets_holder_type_holder_id_slug_unique','2025-11-07 06:00:16','size',3,NULL,'Number of pages in the index'),('kamar','user_wallets','user_wallets_slug_index','2025-11-07 06:00:16','n_diff_pfx01',1,1,'slug'),('kamar','user_wallets','user_wallets_slug_index','2025-11-07 06:00:16','n_diff_pfx02',564,1,'slug,id'),('kamar','user_wallets','user_wallets_slug_index','2025-11-07 06:00:16','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','user_wallets','user_wallets_slug_index','2025-11-07 06:00:16','size',1,NULL,'Number of pages in the index'),('kamar','user_wishlist','PRIMARY','2025-11-07 06:00:16','n_diff_pfx01',5,1,'id'),('kamar','user_wishlist','PRIMARY','2025-11-07 06:00:16','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','user_wishlist','PRIMARY','2025-11-07 06:00:16','size',1,NULL,'Number of pages in the index'),('kamar','users','PRIMARY','2025-11-07 06:00:15','n_diff_pfx01',2436,20,'id'),('kamar','users','PRIMARY','2025-11-07 06:00:15','n_leaf_pages',40,NULL,'Number of leaf pages in the index'),('kamar','users','PRIMARY','2025-11-07 06:00:15','size',97,NULL,'Number of pages in the index'),('kamar','users','users_email_unique','2025-11-07 06:00:15','n_diff_pfx01',2576,8,'email'),('kamar','users','users_email_unique','2025-11-07 06:00:15','n_leaf_pages',8,NULL,'Number of leaf pages in the index'),('kamar','users','users_email_unique','2025-11-07 06:00:15','size',9,NULL,'Number of pages in the index'),('kamar','users','users_user_name_unique','2025-11-07 06:00:15','n_diff_pfx01',132,4,'user_name'),('kamar','users','users_user_name_unique','2025-11-07 06:00:15','n_leaf_pages',4,NULL,'Number of leaf pages in the index'),('kamar','users','users_user_name_unique','2025-11-07 06:00:15','size',5,NULL,'Number of pages in the index'),('kamar','vendors_plan_payments','PRIMARY','2025-11-07 06:00:16','n_diff_pfx01',0,1,'id'),('kamar','vendors_plan_payments','PRIMARY','2025-11-07 06:00:16','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('kamar','vendors_plan_payments','PRIMARY','2025-11-07 06:00:16','size',1,NULL,'Number of pages in the index'),('mysql','component','PRIMARY','2025-10-31 09:12:10','n_diff_pfx01',0,1,'component_id'),('mysql','component','PRIMARY','2025-10-31 09:12:10','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('mysql','component','PRIMARY','2025-10-31 09:12:10','size',1,NULL,'Number of pages in the index'),('sys','sys_config','PRIMARY','2025-10-31 09:12:11','n_diff_pfx01',6,1,'variable'),('sys','sys_config','PRIMARY','2025-10-31 09:12:11','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('sys','sys_config','PRIMARY','2025-10-31 09:12:11','size',1,NULL,'Number of pages in the index'),('tuan_guru','cache','PRIMARY','2025-11-06 05:59:06','n_diff_pfx01',34,1,'key'),('tuan_guru','cache','PRIMARY','2025-11-06 05:59:06','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('tuan_guru','cache','PRIMARY','2025-11-06 05:59:06','size',1,NULL,'Number of pages in the index'),('tuan_guru','cache_locks','PRIMARY','2025-11-04 17:37:45','n_diff_pfx01',0,1,'key'),('tuan_guru','cache_locks','PRIMARY','2025-11-04 17:37:45','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('tuan_guru','cache_locks','PRIMARY','2025-11-04 17:37:45','size',1,NULL,'Number of pages in the index'),('tuan_guru','core_bookings','PRIMARY','2025-11-06 05:57:31','n_diff_pfx01',19,1,'id'),('tuan_guru','core_bookings','PRIMARY','2025-11-06 05:57:31','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('tuan_guru','core_bookings','PRIMARY','2025-11-06 05:57:31','size',1,NULL,'Number of pages in the index'),('tuan_guru','core_bookings','core_bookings_id_tuan_guru_foreign','2025-11-06 05:57:31','n_diff_pfx01',3,1,'id_tuan_guru'),('tuan_guru','core_bookings','core_bookings_id_tuan_guru_foreign','2025-11-06 05:57:31','n_diff_pfx02',19,1,'id_tuan_guru,id'),('tuan_guru','core_bookings','core_bookings_id_tuan_guru_foreign','2025-11-06 05:57:31','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('tuan_guru','core_bookings','core_bookings_id_tuan_guru_foreign','2025-11-06 05:57:31','size',1,NULL,'Number of pages in the index'),('tuan_guru','core_bookings','core_bookings_id_user_foreign','2025-11-06 05:57:31','n_diff_pfx01',1,1,'id_user'),('tuan_guru','core_bookings','core_bookings_id_user_foreign','2025-11-06 05:57:31','n_diff_pfx02',19,1,'id_user,id'),('tuan_guru','core_bookings','core_bookings_id_user_foreign','2025-11-06 05:57:31','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('tuan_guru','core_bookings','core_bookings_id_user_foreign','2025-11-06 05:57:31','size',1,NULL,'Number of pages in the index'),('tuan_guru','failed_jobs','PRIMARY','2025-11-04 17:37:47','n_diff_pfx01',0,1,'id'),('tuan_guru','failed_jobs','PRIMARY','2025-11-04 17:37:47','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('tuan_guru','failed_jobs','PRIMARY','2025-11-04 17:37:47','size',1,NULL,'Number of pages in the index'),('tuan_guru','failed_jobs','failed_jobs_uuid_unique','2025-11-04 17:37:47','n_diff_pfx01',0,1,'uuid'),('tuan_guru','failed_jobs','failed_jobs_uuid_unique','2025-11-04 17:37:47','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('tuan_guru','failed_jobs','failed_jobs_uuid_unique','2025-11-04 17:37:47','size',1,NULL,'Number of pages in the index'),('tuan_guru','formundangs','PRIMARY','2025-11-04 17:37:47','n_diff_pfx01',0,1,'id'),('tuan_guru','formundangs','PRIMARY','2025-11-04 17:37:47','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('tuan_guru','formundangs','PRIMARY','2025-11-04 17:37:47','size',1,NULL,'Number of pages in the index'),('tuan_guru','hari_inis','PRIMARY','2025-11-04 17:37:47','n_diff_pfx01',0,1,'id'),('tuan_guru','hari_inis','PRIMARY','2025-11-04 17:37:47','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('tuan_guru','hari_inis','PRIMARY','2025-11-04 17:37:47','size',1,NULL,'Number of pages in the index'),('tuan_guru','job_batches','PRIMARY','2025-11-04 17:37:46','n_diff_pfx01',0,1,'id'),('tuan_guru','job_batches','PRIMARY','2025-11-04 17:37:46','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('tuan_guru','job_batches','PRIMARY','2025-11-04 17:37:46','size',1,NULL,'Number of pages in the index'),('tuan_guru','jobs','PRIMARY','2025-11-04 17:37:47','n_diff_pfx01',0,1,'id'),('tuan_guru','jobs','PRIMARY','2025-11-04 17:37:47','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('tuan_guru','jobs','PRIMARY','2025-11-04 17:37:47','size',1,NULL,'Number of pages in the index'),('tuan_guru','jobs','jobs_queue_index','2025-11-04 17:37:47','n_diff_pfx01',0,1,'queue'),('tuan_guru','jobs','jobs_queue_index','2025-11-04 17:37:47','n_diff_pfx02',0,1,'queue,id'),('tuan_guru','jobs','jobs_queue_index','2025-11-04 17:37:47','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('tuan_guru','jobs','jobs_queue_index','2025-11-04 17:37:47','size',1,NULL,'Number of pages in the index'),('tuan_guru','migrations','PRIMARY','2025-11-04 17:37:59','n_diff_pfx01',10,1,'id'),('tuan_guru','migrations','PRIMARY','2025-11-04 17:37:59','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('tuan_guru','migrations','PRIMARY','2025-11-04 17:37:59','size',1,NULL,'Number of pages in the index'),('tuan_guru','model_has_permissions','PRIMARY','2025-11-04 17:37:48','n_diff_pfx01',0,1,'permission_id'),('tuan_guru','model_has_permissions','PRIMARY','2025-11-04 17:37:48','n_diff_pfx02',0,1,'permission_id,model_id'),('tuan_guru','model_has_permissions','PRIMARY','2025-11-04 17:37:48','n_diff_pfx03',0,1,'permission_id,model_id,model_type'),('tuan_guru','model_has_permissions','PRIMARY','2025-11-04 17:37:48','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('tuan_guru','model_has_permissions','PRIMARY','2025-11-04 17:37:48','size',1,NULL,'Number of pages in the index'),('tuan_guru','model_has_permissions','model_has_permissions_model_id_model_type_index','2025-11-04 17:37:48','n_diff_pfx01',0,1,'model_id'),('tuan_guru','model_has_permissions','model_has_permissions_model_id_model_type_index','2025-11-04 17:37:48','n_diff_pfx02',0,1,'model_id,model_type'),('tuan_guru','model_has_permissions','model_has_permissions_model_id_model_type_index','2025-11-04 17:37:48','n_diff_pfx03',0,1,'model_id,model_type,permission_id'),('tuan_guru','model_has_permissions','model_has_permissions_model_id_model_type_index','2025-11-04 17:37:48','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('tuan_guru','model_has_permissions','model_has_permissions_model_id_model_type_index','2025-11-04 17:37:48','size',1,NULL,'Number of pages in the index'),('tuan_guru','model_has_roles','PRIMARY','2025-11-04 17:38:29','n_diff_pfx01',3,1,'role_id'),('tuan_guru','model_has_roles','PRIMARY','2025-11-04 17:38:29','n_diff_pfx02',137,1,'role_id,model_id'),('tuan_guru','model_has_roles','PRIMARY','2025-11-04 17:38:29','n_diff_pfx03',137,1,'role_id,model_id,model_type'),('tuan_guru','model_has_roles','PRIMARY','2025-11-04 17:38:29','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('tuan_guru','model_has_roles','PRIMARY','2025-11-04 17:38:29','size',1,NULL,'Number of pages in the index'),('tuan_guru','model_has_roles','model_has_roles_model_id_model_type_index','2025-11-04 17:38:29','n_diff_pfx01',137,1,'model_id'),('tuan_guru','model_has_roles','model_has_roles_model_id_model_type_index','2025-11-04 17:38:29','n_diff_pfx02',137,1,'model_id,model_type'),('tuan_guru','model_has_roles','model_has_roles_model_id_model_type_index','2025-11-04 17:38:29','n_diff_pfx03',137,1,'model_id,model_type,role_id'),('tuan_guru','model_has_roles','model_has_roles_model_id_model_type_index','2025-11-04 17:38:29','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('tuan_guru','model_has_roles','model_has_roles_model_id_model_type_index','2025-11-04 17:38:29','size',1,NULL,'Number of pages in the index'),('tuan_guru','password_reset_tokens','PRIMARY','2025-11-04 17:37:46','n_diff_pfx01',1,1,'email'),('tuan_guru','password_reset_tokens','PRIMARY','2025-11-04 17:37:46','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('tuan_guru','password_reset_tokens','PRIMARY','2025-11-04 17:37:46','size',1,NULL,'Number of pages in the index'),('tuan_guru','permissions','PRIMARY','2025-11-04 17:38:49','n_diff_pfx01',15,1,'id'),('tuan_guru','permissions','PRIMARY','2025-11-04 17:38:49','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('tuan_guru','permissions','PRIMARY','2025-11-04 17:38:49','size',1,NULL,'Number of pages in the index'),('tuan_guru','permissions','permissions_name_guard_name_unique','2025-11-04 17:38:49','n_diff_pfx01',15,1,'name'),('tuan_guru','permissions','permissions_name_guard_name_unique','2025-11-04 17:38:49','n_diff_pfx02',15,1,'name,guard_name'),('tuan_guru','permissions','permissions_name_guard_name_unique','2025-11-04 17:38:49','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('tuan_guru','permissions','permissions_name_guard_name_unique','2025-11-04 17:38:49','size',1,NULL,'Number of pages in the index'),('tuan_guru','personal_access_tokens','PRIMARY','2025-11-04 17:37:48','n_diff_pfx01',0,1,'id'),('tuan_guru','personal_access_tokens','PRIMARY','2025-11-04 17:37:48','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('tuan_guru','personal_access_tokens','PRIMARY','2025-11-04 17:37:48','size',1,NULL,'Number of pages in the index'),('tuan_guru','personal_access_tokens','personal_access_tokens_token_unique','2025-11-04 17:37:48','n_diff_pfx01',0,1,'token'),('tuan_guru','personal_access_tokens','personal_access_tokens_token_unique','2025-11-04 17:37:48','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('tuan_guru','personal_access_tokens','personal_access_tokens_token_unique','2025-11-04 17:37:48','size',1,NULL,'Number of pages in the index'),('tuan_guru','personal_access_tokens','personal_access_tokens_tokenable_type_tokenable_id_index','2025-11-04 17:37:48','n_diff_pfx01',0,1,'tokenable_type'),('tuan_guru','personal_access_tokens','personal_access_tokens_tokenable_type_tokenable_id_index','2025-11-04 17:37:48','n_diff_pfx02',0,1,'tokenable_type,tokenable_id'),('tuan_guru','personal_access_tokens','personal_access_tokens_tokenable_type_tokenable_id_index','2025-11-04 17:37:48','n_diff_pfx03',0,1,'tokenable_type,tokenable_id,id'),('tuan_guru','personal_access_tokens','personal_access_tokens_tokenable_type_tokenable_id_index','2025-11-04 17:37:48','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('tuan_guru','personal_access_tokens','personal_access_tokens_tokenable_type_tokenable_id_index','2025-11-04 17:37:48','size',1,NULL,'Number of pages in the index'),('tuan_guru','role_has_permissions','PRIMARY','2025-11-04 17:38:39','n_diff_pfx01',15,1,'permission_id'),('tuan_guru','role_has_permissions','PRIMARY','2025-11-04 17:38:39','n_diff_pfx02',19,1,'permission_id,role_id'),('tuan_guru','role_has_permissions','PRIMARY','2025-11-04 17:38:39','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('tuan_guru','role_has_permissions','PRIMARY','2025-11-04 17:38:39','size',1,NULL,'Number of pages in the index'),('tuan_guru','role_has_permissions','role_has_permissions_role_id_foreign','2025-11-04 17:38:39','n_diff_pfx01',3,1,'role_id'),('tuan_guru','role_has_permissions','role_has_permissions_role_id_foreign','2025-11-04 17:38:39','n_diff_pfx02',19,1,'role_id,permission_id'),('tuan_guru','role_has_permissions','role_has_permissions_role_id_foreign','2025-11-04 17:38:39','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('tuan_guru','role_has_permissions','role_has_permissions_role_id_foreign','2025-11-04 17:38:39','size',1,NULL,'Number of pages in the index'),('tuan_guru','roles','PRIMARY','2025-11-04 17:38:19','n_diff_pfx01',3,1,'id'),('tuan_guru','roles','PRIMARY','2025-11-04 17:38:19','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('tuan_guru','roles','PRIMARY','2025-11-04 17:38:19','size',1,NULL,'Number of pages in the index'),('tuan_guru','roles','roles_name_guard_name_unique','2025-11-04 17:38:19','n_diff_pfx01',3,1,'name'),('tuan_guru','roles','roles_name_guard_name_unique','2025-11-04 17:38:19','n_diff_pfx02',3,1,'name,guard_name'),('tuan_guru','roles','roles_name_guard_name_unique','2025-11-04 17:38:19','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('tuan_guru','roles','roles_name_guard_name_unique','2025-11-04 17:38:19','size',1,NULL,'Number of pages in the index'),('tuan_guru','sessions','PRIMARY','2025-11-06 05:59:16','n_diff_pfx01',3,1,'id'),('tuan_guru','sessions','PRIMARY','2025-11-06 05:59:16','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('tuan_guru','sessions','PRIMARY','2025-11-06 05:59:16','size',1,NULL,'Number of pages in the index'),('tuan_guru','sessions','sessions_last_activity_index','2025-11-06 05:59:16','n_diff_pfx01',3,1,'last_activity'),('tuan_guru','sessions','sessions_last_activity_index','2025-11-06 05:59:16','n_diff_pfx02',3,1,'last_activity,id'),('tuan_guru','sessions','sessions_last_activity_index','2025-11-06 05:59:16','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('tuan_guru','sessions','sessions_last_activity_index','2025-11-06 05:59:16','size',1,NULL,'Number of pages in the index'),('tuan_guru','sessions','sessions_user_id_index','2025-11-06 05:59:16','n_diff_pfx01',2,1,'user_id'),('tuan_guru','sessions','sessions_user_id_index','2025-11-06 05:59:16','n_diff_pfx02',3,1,'user_id,id'),('tuan_guru','sessions','sessions_user_id_index','2025-11-06 05:59:16','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('tuan_guru','sessions','sessions_user_id_index','2025-11-06 05:59:16','size',1,NULL,'Number of pages in the index'),('tuan_guru','tuan_gurus','PRIMARY','2025-11-04 17:38:59','n_diff_pfx01',109,1,'id'),('tuan_guru','tuan_gurus','PRIMARY','2025-11-04 17:38:59','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('tuan_guru','tuan_gurus','PRIMARY','2025-11-04 17:38:59','size',1,NULL,'Number of pages in the index'),('tuan_guru','tuan_gurus','tuan_gurus_id_pendamping_foreign','2025-11-04 17:38:59','n_diff_pfx01',109,1,'id_pendamping'),('tuan_guru','tuan_gurus','tuan_gurus_id_pendamping_foreign','2025-11-04 17:38:59','n_diff_pfx02',109,1,'id_pendamping,id'),('tuan_guru','tuan_gurus','tuan_gurus_id_pendamping_foreign','2025-11-04 17:38:59','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('tuan_guru','tuan_gurus','tuan_gurus_id_pendamping_foreign','2025-11-04 17:38:59','size',1,NULL,'Number of pages in the index'),('tuan_guru','users','PRIMARY','2025-11-04 17:39:09','n_diff_pfx01',141,2,'id'),('tuan_guru','users','PRIMARY','2025-11-04 17:39:09','n_leaf_pages',2,NULL,'Number of leaf pages in the index'),('tuan_guru','users','PRIMARY','2025-11-04 17:39:09','size',3,NULL,'Number of pages in the index'),('tuan_guru','users','users_email_unique','2025-11-04 17:39:09','n_diff_pfx01',141,1,'email'),('tuan_guru','users','users_email_unique','2025-11-04 17:39:09','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('tuan_guru','users','users_email_unique','2025-11-04 17:39:09','size',1,NULL,'Number of pages in the index');

--
-- Dumping data for table `innodb_table_stats`
--

INSERT  IGNORE INTO `innodb_table_stats` VALUES ('kamar','booking_passengers','2025-11-07 06:00:06',0,1,0),('kamar','bravo_airline','2025-11-07 06:00:16',20,1,0),('kamar','bravo_airport','2025-11-07 06:00:06',20,1,1),('kamar','bravo_attrs','2025-11-07 06:02:17',26,1,0),('kamar','bravo_attrs_translations','2025-11-07 06:00:06',2,1,1),('kamar','bravo_boat_dates','2025-11-07 06:00:06',0,1,0),('kamar','bravo_boat_term','2025-11-07 06:00:06',134,1,0),('kamar','bravo_boat_translations','2025-11-07 06:00:06',0,1,1),('kamar','bravo_boats','2025-11-07 06:00:57',13,8,1),('kamar','bravo_booking_coupons','2025-11-07 06:00:07',0,1,0),('kamar','bravo_booking_meta','2025-11-07 06:00:07',2157,10,0),('kamar','bravo_booking_payment_meta','2025-11-07 06:00:07',1,1,1),('kamar','bravo_booking_payments','2025-11-07 06:00:07',55,1,0),('kamar','bravo_booking_time_slots','2025-11-07 06:00:07',0,1,0),('kamar','bravo_bookings','2025-11-07 06:00:07',136,7,0),('kamar','bravo_car_dates','2025-11-07 06:00:07',0,1,0),('kamar','bravo_car_term','2025-11-07 06:00:07',309,1,0),('kamar','bravo_car_translations','2025-11-07 06:00:07',0,1,1),('kamar','bravo_cars','2025-11-07 06:01:37',26,11,1),('kamar','bravo_contact','2025-11-07 06:00:07',12,1,0),('kamar','bravo_coupon_services','2025-11-07 06:00:08',1,1,0),('kamar','bravo_coupons','2025-11-07 06:00:07',0,1,1),('kamar','bravo_enquiries','2025-11-07 06:00:08',0,1,0),('kamar','bravo_event_dates','2025-11-07 06:00:08',0,1,0),('kamar','bravo_event_term','2025-11-07 06:00:08',141,1,0),('kamar','bravo_event_translations','2025-11-07 06:00:08',0,1,1),('kamar','bravo_events','2025-11-07 06:00:08',24,7,1),('kamar','bravo_flight','2025-11-07 06:00:08',20,1,0),('kamar','bravo_flight_seat','2025-11-07 06:00:08',60,1,0),('kamar','bravo_flight_term','2025-11-07 06:00:08',106,1,0),('kamar','bravo_hotel_room_bookings','2025-11-07 06:01:57',154,1,0),('kamar','bravo_hotel_room_dates','2025-11-07 06:00:08',42,1,0),('kamar','bravo_hotel_room_term','2025-11-07 06:00:09',436,3,0),('kamar','bravo_hotel_room_translations','2025-11-07 06:00:09',3,1,1),('kamar','bravo_hotel_rooms','2025-11-07 06:01:17',108,6,0),('kamar','bravo_hotel_term','2025-11-07 06:00:09',470,3,0),('kamar','bravo_hotel_translations','2025-11-07 06:00:09',1,1,1),('kamar','bravo_hotels','2025-11-07 06:00:37',30,7,1),('kamar','bravo_location_translations','2025-11-07 06:00:09',0,1,1),('kamar','bravo_locations','2025-11-07 06:00:09',559,6,1),('kamar','bravo_locations_2024_1_15','2025-11-07 06:00:09',8,1,1),('kamar','bravo_payouts','2025-11-07 06:00:09',0,1,0),('kamar','bravo_popup_translations','2025-11-07 06:00:09',0,1,2),('kamar','bravo_popups','2025-11-07 06:00:09',0,1,0),('kamar','bravo_review','2025-11-07 06:00:09',0,1,0),('kamar','bravo_review_meta','2025-11-07 06:00:10',2210,12,0),('kamar','bravo_seat_type','2025-11-07 06:00:10',5,1,1),('kamar','bravo_seo','2025-11-07 06:00:10',54,1,0),('kamar','bravo_service_translations','2025-11-07 06:00:10',1,1,1),('kamar','bravo_services','2025-11-07 06:00:10',111,3,1),('kamar','bravo_space_dates','2025-11-07 06:00:10',0,1,0),('kamar','bravo_space_term','2025-11-07 06:00:10',308,1,0),('kamar','bravo_space_translations','2025-11-07 06:00:10',0,1,1),('kamar','bravo_spaces','2025-11-07 06:00:10',22,6,1),('kamar','bravo_terms','2025-11-07 06:00:10',186,1,0),('kamar','bravo_terms_translations','2025-11-07 06:00:10',0,1,1),('kamar','bravo_tour_category','2025-11-07 06:00:27',8,1,1),('kamar','bravo_tour_category_translations','2025-11-07 06:00:11',0,1,1),('kamar','bravo_tour_dates','2025-11-07 06:00:47',5,1,0),('kamar','bravo_tour_meta','2025-11-07 06:01:07',36,1,0),('kamar','bravo_tour_term','2025-11-07 06:01:27',308,1,0),('kamar','bravo_tour_translations','2025-11-07 06:01:47',2,1,2),('kamar','bravo_tours','2025-11-07 06:00:11',36,13,1),('kamar','ch_favorites','2025-11-07 05:59:59',0,1,0),('kamar','ch_messages','2025-11-07 05:59:59',0,1,0),('kamar','cities','2025-11-07 06:02:07',499,4,0),('kamar','core_inbox','2025-11-07 06:00:11',0,1,0),('kamar','core_inbox_messages','2025-11-07 06:00:11',0,1,0),('kamar','core_languages','2025-11-07 06:53:23',13,1,0),('kamar','core_menu_translations','2025-11-07 06:00:11',4,3,1),('kamar','core_menus','2025-11-07 06:00:11',3,1,0),('kamar','core_model_has_permissions','2025-11-07 06:00:16',0,1,1),('kamar','core_model_has_roles','2025-11-07 06:00:17',2250,8,6),('kamar','core_news','2025-11-07 06:00:12',16,3,0),('kamar','core_news_category','2025-11-07 06:00:12',12,1,1),('kamar','core_news_category_translations','2025-11-07 06:00:12',0,1,1),('kamar','core_news_tag','2025-11-07 06:00:12',0,1,0),('kamar','core_news_translations','2025-11-07 06:00:12',0,1,1),('kamar','core_notifications','2025-11-07 06:00:12',0,1,0),('kamar','core_page_translations','2025-11-07 06:00:12',0,1,2),('kamar','core_pages','2025-11-07 06:00:12',18,5,1),('kamar','core_permissions','2025-11-07 06:00:12',109,1,0),('kamar','core_role_has_permissions','2025-11-07 06:00:17',186,1,1),('kamar','core_roles','2025-11-07 06:00:12',6,1,0),('kamar','core_settings','2025-11-07 06:00:13',673,7,0),('kamar','core_subscribers','2025-11-07 06:00:13',4666,20,0),('kamar','core_tag_translations','2025-11-07 06:00:13',0,1,1),('kamar','core_tags','2025-11-07 06:00:13',12,1,0),('kamar','core_template_translations','2025-11-07 06:00:13',9,5,1),('kamar','core_templates','2025-11-07 06:00:13',8,4,0),('kamar','core_translations','2025-11-07 06:00:13',4012,19,0),('kamar','core_vendor_plan_meta','2025-11-07 06:00:13',0,1,0),('kamar','core_vendor_plans','2025-11-07 06:00:13',0,1,0),('kamar','donations','2025-11-07 06:00:14',0,1,0),('kamar','email_providers','2025-11-07 06:00:14',0,1,1),('kamar','fonts','2025-11-07 06:48:45',0,1,0),('kamar','jobs','2025-11-07 06:00:14',0,1,1),('kamar','location_category','2025-11-07 06:00:14',3,1,1),('kamar','location_category_translations','2025-11-07 06:00:14',0,1,1),('kamar','mailblock','2025-11-07 06:48:45',0,1,0),('kamar','mailman','2025-11-07 06:00:14',7,1,0),('kamar','media_files','2025-11-07 06:00:14',13,1,0),('kamar','migrations','2025-11-07 06:00:14',87,1,0),('kamar','notifications','2025-11-07 06:00:04',5115,225,21),('kamar','password_resets','2025-11-07 06:00:06',684,7,3),('kamar','personal_access_tokens','2025-11-07 06:00:14',17,1,2),('kamar','social_forums','2025-11-07 06:00:14',14,1,0),('kamar','social_group_user','2025-11-07 06:00:15',0,1,0),('kamar','social_groups','2025-11-07 06:00:15',0,1,0),('kamar','social_post_comments','2025-11-07 06:00:15',0,1,0),('kamar','social_posts','2025-11-07 06:00:15',0,1,0),('kamar','social_user_follow','2025-11-07 06:00:15',0,1,0),('kamar','spam_registrations','2025-11-07 06:00:15',2565,97,0),('kamar','user_meta','2025-11-07 06:00:16',0,1,0),('kamar','user_suspends','2025-11-07 06:00:16',1301,9,0),('kamar','user_transactions','2025-11-07 06:00:17',0,1,7),('kamar','user_transfers','2025-11-07 06:00:17',0,1,5),('kamar','user_upgrade_request','2025-11-07 06:00:16',3,1,0),('kamar','user_wallets','2025-11-07 06:00:16',564,6,7),('kamar','user_wishlist','2025-11-07 06:00:16',5,1,0),('kamar','users','2025-11-07 06:00:15',2436,97,14),('kamar','vendors_plan_payments','2025-11-07 06:00:16',0,1,0),('mysql','component','2025-10-31 09:12:10',0,1,0),('sys','sys_config','2025-10-31 09:12:11',6,1,0),('tuan_guru','cache','2025-11-06 05:59:06',34,1,0),('tuan_guru','cache_locks','2025-11-04 17:37:45',0,1,0),('tuan_guru','core_bookings','2025-11-06 05:57:31',19,1,2),('tuan_guru','failed_jobs','2025-11-04 17:37:47',0,1,1),('tuan_guru','formundangs','2025-11-04 17:37:47',0,1,0),('tuan_guru','hari_inis','2025-11-04 17:37:47',0,1,0),('tuan_guru','job_batches','2025-11-04 17:37:46',0,1,0),('tuan_guru','jobs','2025-11-04 17:37:47',0,1,1),('tuan_guru','migrations','2025-11-04 17:37:59',10,1,0),('tuan_guru','model_has_permissions','2025-11-04 17:37:48',0,1,1),('tuan_guru','model_has_roles','2025-11-04 17:38:29',137,1,1),('tuan_guru','password_reset_tokens','2025-11-04 17:37:46',1,1,0),('tuan_guru','permissions','2025-11-04 17:38:49',15,1,1),('tuan_guru','personal_access_tokens','2025-11-04 17:37:48',0,1,2),('tuan_guru','role_has_permissions','2025-11-04 17:38:39',19,1,1),('tuan_guru','roles','2025-11-04 17:38:19',3,1,1),('tuan_guru','sessions','2025-11-06 05:59:16',3,1,2),('tuan_guru','tuan_gurus','2025-11-04 17:38:59',109,1,1),('tuan_guru','users','2025-11-04 17:39:09',141,3,1);

--
-- Table structure for table `ndb_binlog_index`
--

CREATE TABLE `ndb_binlog_index` (
  `Position` bigint unsigned NOT NULL,
  `File` varchar(255) NOT NULL,
  `epoch` bigint unsigned NOT NULL,
  `inserts` int unsigned NOT NULL,
  `updates` int unsigned NOT NULL,
  `deletes` int unsigned NOT NULL,
  `schemaops` int unsigned NOT NULL,
  `orig_server_id` int unsigned NOT NULL,
  `orig_epoch` bigint unsigned NOT NULL,
  `gci` int unsigned NOT NULL,
  `next_position` bigint unsigned NOT NULL,
  `next_file` varchar(255) NOT NULL,
  PRIMARY KEY (`epoch`,`orig_server_id`,`orig_epoch`)
) /*!50100 TABLESPACE `mysql` */ ENGINE=InnoDB DEFAULT CHARSET=latin1 STATS_PERSISTENT=0 ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ndb_binlog_index`
--


--
-- Table structure for table `password_history`
--

CREATE TABLE `password_history` (
  `Host` char(255) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '',
  `User` char(32) COLLATE utf8mb3_bin NOT NULL DEFAULT '',
  `Password_timestamp` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `Password` text COLLATE utf8mb3_bin,
  PRIMARY KEY (`Host`,`User`,`Password_timestamp` DESC)
) /*!50100 TABLESPACE `mysql` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin STATS_PERSISTENT=0 ROW_FORMAT=DYNAMIC COMMENT='Password history for user accounts';

--
-- Dumping data for table `password_history`
--


--
-- Table structure for table `plugin`
--

CREATE TABLE `plugin` (
  `name` varchar(64) NOT NULL DEFAULT '',
  `dl` varchar(128) NOT NULL DEFAULT '',
  PRIMARY KEY (`name`)
) /*!50100 TABLESPACE `mysql` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 STATS_PERSISTENT=0 ROW_FORMAT=DYNAMIC COMMENT='MySQL plugins';

--
-- Dumping data for table `plugin`
--


--
-- Table structure for table `procs_priv`
--

CREATE TABLE `procs_priv` (
  `Host` char(255) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '',
  `Db` char(64) COLLATE utf8mb3_bin NOT NULL DEFAULT '',
  `User` char(32) COLLATE utf8mb3_bin NOT NULL DEFAULT '',
  `Routine_name` char(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '',
  `Routine_type` enum('FUNCTION','PROCEDURE') COLLATE utf8mb3_bin NOT NULL,
  `Grantor` varchar(288) COLLATE utf8mb3_bin NOT NULL DEFAULT '',
  `Proc_priv` set('Execute','Alter Routine','Grant') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '',
  `Timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`Host`,`User`,`Db`,`Routine_name`,`Routine_type`),
  KEY `Grantor` (`Grantor`)
) /*!50100 TABLESPACE `mysql` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin STATS_PERSISTENT=0 ROW_FORMAT=DYNAMIC COMMENT='Procedure privileges';

--
-- Dumping data for table `procs_priv`
--


--
-- Table structure for table `proxies_priv`
--

CREATE TABLE `proxies_priv` (
  `Host` char(255) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '',
  `User` char(32) COLLATE utf8mb3_bin NOT NULL DEFAULT '',
  `Proxied_host` char(255) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '',
  `Proxied_user` char(32) COLLATE utf8mb3_bin NOT NULL DEFAULT '',
  `With_grant` tinyint(1) NOT NULL DEFAULT '0',
  `Grantor` varchar(288) COLLATE utf8mb3_bin NOT NULL DEFAULT '',
  `Timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`Host`,`User`,`Proxied_host`,`Proxied_user`),
  KEY `Grantor` (`Grantor`)
) /*!50100 TABLESPACE `mysql` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin STATS_PERSISTENT=0 ROW_FORMAT=DYNAMIC COMMENT='User proxy privileges';

--
-- Dumping data for table `proxies_priv`
--

INSERT INTO `proxies_priv` VALUES ('localhost','root','','',1,'boot@','2025-10-31 09:12:10');

--
-- Table structure for table `replication_asynchronous_connection_failover`
--

CREATE TABLE `replication_asynchronous_connection_failover` (
  `Channel_name` char(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT 'The replication channel name that connects source and replica.',
  `Host` char(255) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL COMMENT 'The source hostname that the replica will attempt to switch over the replication connection to in case of a failure.',
  `Port` int unsigned NOT NULL COMMENT 'The source port that the replica will attempt to switch over the replication connection to in case of a failure.',
  `Network_namespace` char(64) NOT NULL COMMENT 'The source network namespace that the replica will attempt to switch over the replication connection to in case of a failure. If its value is empty, connections use the default (global) namespace.',
  `Weight` tinyint unsigned NOT NULL COMMENT 'The order in which the replica shall try to switch the connection over to when there are failures. Weight can be set to a number between 1 and 100, where 100 is the highest weight and 1 the lowest.',
  `Managed_name` char(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '' COMMENT 'The name of the group which this server belongs to.',
  PRIMARY KEY (`Channel_name`,`Host`,`Port`,`Network_namespace`,`Managed_name`),
  KEY `Channel_name` (`Channel_name`,`Managed_name`)
) /*!50100 TABLESPACE `mysql` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 STATS_PERSISTENT=0 ROW_FORMAT=DYNAMIC COMMENT='The source configuration details';

--
-- Dumping data for table `replication_asynchronous_connection_failover`
--


--
-- Table structure for table `replication_asynchronous_connection_failover_managed`
--

CREATE TABLE `replication_asynchronous_connection_failover_managed` (
  `Channel_name` char(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT 'The replication channel name that connects source and replica.',
  `Managed_name` char(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '' COMMENT 'The name of the source which needs to be managed.',
  `Managed_type` char(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '' COMMENT 'Determines the managed type.',
  `Configuration` json DEFAULT NULL COMMENT 'The data to help manage group. For Managed_type = GroupReplication, Configuration value should contain {"Primary_weight": 80, "Secondary_weight": 60}, so that it assigns weight=80 to PRIMARY of the group, and weight=60 for rest of the members in mysql.replication_asynchronous_connection_failover table.',
  PRIMARY KEY (`Channel_name`,`Managed_name`)
) /*!50100 TABLESPACE `mysql` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 STATS_PERSISTENT=0 ROW_FORMAT=DYNAMIC COMMENT='The managed source configuration details';

--
-- Dumping data for table `replication_asynchronous_connection_failover_managed`
--


--
-- Table structure for table `replication_group_configuration_version`
--

CREATE TABLE `replication_group_configuration_version` (
  `name` char(255) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL COMMENT 'The configuration name.',
  `version` bigint unsigned NOT NULL COMMENT 'The version of the configuration name.',
  PRIMARY KEY (`name`)
) /*!50100 TABLESPACE `mysql` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci STATS_PERSISTENT=0 ROW_FORMAT=DYNAMIC COMMENT='The group configuration version.';

--
-- Dumping data for table `replication_group_configuration_version`
--

INSERT INTO `replication_group_configuration_version` VALUES ('replication_group_member_actions',1);

--
-- Table structure for table `replication_group_member_actions`
--

CREATE TABLE `replication_group_member_actions` (
  `name` char(255) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL COMMENT 'The action name.',
  `event` char(64) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL COMMENT 'The event that will trigger the action.',
  `enabled` tinyint(1) NOT NULL COMMENT 'Whether the action is enabled.',
  `type` char(64) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL COMMENT 'The action type.',
  `priority` tinyint unsigned NOT NULL COMMENT 'The order on which the action will be run, value between 1 and 100, lower values first.',
  `error_handling` char(64) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL COMMENT 'On errors during the action will be handled: IGNORE, CRITICAL.',
  PRIMARY KEY (`name`,`event`),
  KEY `event` (`event`)
) /*!50100 TABLESPACE `mysql` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci STATS_PERSISTENT=0 ROW_FORMAT=DYNAMIC COMMENT='The member actions configuration.';

--
-- Dumping data for table `replication_group_member_actions`
--

INSERT INTO `replication_group_member_actions` VALUES ('mysql_disable_super_read_only_if_primary','AFTER_PRIMARY_ELECTION',1,'INTERNAL',1,'IGNORE'),('mysql_start_failover_channels_if_primary','AFTER_PRIMARY_ELECTION',1,'INTERNAL',10,'CRITICAL');

--
-- Table structure for table `role_edges`
--

CREATE TABLE `role_edges` (
  `FROM_HOST` char(255) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '',
  `FROM_USER` char(32) COLLATE utf8mb3_bin NOT NULL DEFAULT '',
  `TO_HOST` char(255) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '',
  `TO_USER` char(32) COLLATE utf8mb3_bin NOT NULL DEFAULT '',
  `WITH_ADMIN_OPTION` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
  PRIMARY KEY (`FROM_HOST`,`FROM_USER`,`TO_HOST`,`TO_USER`)
) /*!50100 TABLESPACE `mysql` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin STATS_PERSISTENT=0 ROW_FORMAT=DYNAMIC COMMENT='Role hierarchy and role grants';

--
-- Dumping data for table `role_edges`
--


--
-- Table structure for table `server_cost`
--

CREATE TABLE `server_cost` (
  `cost_name` varchar(64) NOT NULL,
  `cost_value` float DEFAULT NULL,
  `last_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `comment` varchar(1024) DEFAULT NULL,
  `default_value` float GENERATED ALWAYS AS ((case `cost_name` when _utf8mb3'disk_temptable_create_cost' then 20.0 when _utf8mb3'disk_temptable_row_cost' then 0.5 when _utf8mb3'key_compare_cost' then 0.05 when _utf8mb3'memory_temptable_create_cost' then 1.0 when _utf8mb3'memory_temptable_row_cost' then 0.1 when _utf8mb3'row_evaluate_cost' then 0.1 else NULL end)) VIRTUAL,
  PRIMARY KEY (`cost_name`)
) /*!50100 TABLESPACE `mysql` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 STATS_PERSISTENT=0 ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `server_cost`
--

INSERT INTO `server_cost` (`cost_name`, `cost_value`, `last_update`, `comment`) VALUES ('disk_temptable_create_cost',NULL,'2025-10-31 09:12:10',NULL),('disk_temptable_row_cost',NULL,'2025-10-31 09:12:10',NULL),('key_compare_cost',NULL,'2025-10-31 09:12:10',NULL),('memory_temptable_create_cost',NULL,'2025-10-31 09:12:10',NULL),('memory_temptable_row_cost',NULL,'2025-10-31 09:12:10',NULL),('row_evaluate_cost',NULL,'2025-10-31 09:12:10',NULL);

--
-- Table structure for table `servers`
--

CREATE TABLE `servers` (
  `Server_name` char(64) NOT NULL DEFAULT '',
  `Host` char(255) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '',
  `Db` char(64) NOT NULL DEFAULT '',
  `Username` char(64) NOT NULL DEFAULT '',
  `Password` char(64) NOT NULL DEFAULT '',
  `Port` int NOT NULL DEFAULT '0',
  `Socket` char(64) NOT NULL DEFAULT '',
  `Wrapper` char(64) NOT NULL DEFAULT '',
  `Owner` char(64) NOT NULL DEFAULT '',
  PRIMARY KEY (`Server_name`)
) /*!50100 TABLESPACE `mysql` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 STATS_PERSISTENT=0 ROW_FORMAT=DYNAMIC COMMENT='MySQL Foreign Servers table';

--
-- Dumping data for table `servers`
--


--
-- Table structure for table `slave_master_info`
--

CREATE TABLE IF NOT EXISTS `slave_master_info` (
  `Number_of_lines` int unsigned NOT NULL COMMENT 'Number of lines in the file.',
  `Master_log_name` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT 'The name of the master binary log currently being read from the master.',
  `Master_log_pos` bigint unsigned NOT NULL COMMENT 'The master log position of the last read event.',
  `Host` varchar(255) CHARACTER SET ascii COLLATE ascii_general_ci DEFAULT NULL COMMENT 'The host name of the source.',
  `User_name` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT 'The user name used to connect to the master.',
  `User_password` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT 'The password used to connect to the master.',
  `Port` int unsigned NOT NULL COMMENT 'The network port used to connect to the master.',
  `Connect_retry` int unsigned NOT NULL COMMENT 'The period (in seconds) that the slave will wait before trying to reconnect to the master.',
  `Enabled_ssl` tinyint(1) NOT NULL COMMENT 'Indicates whether the server supports SSL connections.',
  `Ssl_ca` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT 'The file used for the Certificate Authority (CA) certificate.',
  `Ssl_capath` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT 'The path to the Certificate Authority (CA) certificates.',
  `Ssl_cert` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT 'The name of the SSL certificate file.',
  `Ssl_cipher` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT 'The name of the cipher in use for the SSL connection.',
  `Ssl_key` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT 'The name of the SSL key file.',
  `Ssl_verify_server_cert` tinyint(1) NOT NULL COMMENT 'Whether to verify the server certificate.',
  `Heartbeat` float NOT NULL,
  `Bind` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT 'Displays which interface is employed when connecting to the MySQL server',
  `Ignored_server_ids` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT 'The number of server IDs to be ignored, followed by the actual server IDs',
  `Uuid` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT 'The master server uuid.',
  `Retry_count` bigint unsigned NOT NULL COMMENT 'Number of reconnect attempts, to the master, before giving up.',
  `Ssl_crl` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT 'The file used for the Certificate Revocation List (CRL)',
  `Ssl_crlpath` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT 'The path used for Certificate Revocation List (CRL) files',
  `Enabled_auto_position` tinyint(1) NOT NULL COMMENT 'Indicates whether GTIDs will be used to retrieve events from the master.',
  `Channel_name` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT 'The channel on which the replica is connected to a source. Used in Multisource Replication',
  `Tls_version` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT 'Tls version',
  `Public_key_path` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT 'The file containing public key of master server.',
  `Get_public_key` tinyint(1) NOT NULL COMMENT 'Preference to get public key from master.',
  `Network_namespace` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT 'Network namespace used for communication with the master server.',
  `Master_compression_algorithm` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT 'Compression algorithm supported for data transfer between source and replica.',
  `Master_zstd_compression_level` int unsigned NOT NULL COMMENT 'Compression level associated with zstd compression algorithm.',
  `Tls_ciphersuites` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT 'Ciphersuites used for TLS 1.3 communication with the master server.',
  `Source_connection_auto_failover` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Indicates whether the channel connection failover is enabled.',
  `Gtid_only` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Indicates if this channel only uses GTIDs and does not persist positions.',
  PRIMARY KEY (`Channel_name`)
) /*!50100 TABLESPACE `mysql` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 STATS_PERSISTENT=0 ROW_FORMAT=DYNAMIC COMMENT='Master Information';

--
-- Table structure for table `slave_relay_log_info`
--

CREATE TABLE IF NOT EXISTS `slave_relay_log_info` (
  `Number_of_lines` int unsigned NOT NULL COMMENT 'Number of lines in the file or rows in the table. Used to version table definitions.',
  `Relay_log_name` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT 'The name of the current relay log file.',
  `Relay_log_pos` bigint unsigned DEFAULT NULL COMMENT 'The relay log position of the last executed event.',
  `Master_log_name` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT 'The name of the master binary log file from which the events in the relay log file were read.',
  `Master_log_pos` bigint unsigned DEFAULT NULL COMMENT 'The master log position of the last executed event.',
  `Sql_delay` int DEFAULT NULL COMMENT 'The number of seconds that the slave must lag behind the master.',
  `Number_of_workers` int unsigned DEFAULT NULL,
  `Id` int unsigned DEFAULT NULL COMMENT 'Internal Id that uniquely identifies this record.',
  `Channel_name` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT 'The channel on which the replica is connected to a source. Used in Multisource Replication',
  `Privilege_checks_username` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL COMMENT 'Username part of PRIVILEGE_CHECKS_USER.',
  `Privilege_checks_hostname` varchar(255) CHARACTER SET ascii COLLATE ascii_general_ci DEFAULT NULL COMMENT 'Hostname part of PRIVILEGE_CHECKS_USER.',
  `Require_row_format` tinyint(1) NOT NULL COMMENT 'Indicates whether the channel shall only accept row based events.',
  `Require_table_primary_key_check` enum('STREAM','ON','OFF','GENERATE') NOT NULL DEFAULT 'STREAM' COMMENT 'Indicates what is the channel policy regarding tables without primary keys on create and alter table queries',
  `Assign_gtids_to_anonymous_transactions_type` enum('OFF','LOCAL','UUID') NOT NULL DEFAULT 'OFF' COMMENT 'Indicates whether the channel will generate a new GTID for anonymous transactions. OFF means that anonymous transactions will remain anonymous. LOCAL means that anonymous transactions will be assigned a newly generated GTID based on server_uuid. UUID indicates that anonymous transactions will be assigned a newly generated GTID based on Assign_gtids_to_anonymous_transactions_value',
  `Assign_gtids_to_anonymous_transactions_value` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT 'Indicates the UUID used while generating GTIDs for anonymous transactions',
  PRIMARY KEY (`Channel_name`)
) /*!50100 TABLESPACE `mysql` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 STATS_PERSISTENT=0 ROW_FORMAT=DYNAMIC COMMENT='Relay Log Information';

--
-- Table structure for table `slave_worker_info`
--

CREATE TABLE `slave_worker_info` (
  `Id` int 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` int unsigned NOT NULL,
  `Checkpoint_group_bitmap` blob NOT NULL,
  `Channel_name` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT 'The channel on which the replica is connected to a source. Used in Multisource Replication',
  PRIMARY KEY (`Channel_name`,`Id`)
) /*!50100 TABLESPACE `mysql` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 STATS_PERSISTENT=0 ROW_FORMAT=DYNAMIC COMMENT='Worker Information';

--
-- Dumping data for table `slave_worker_info`
--


--
-- Table structure for table `tables_priv`
--

CREATE TABLE `tables_priv` (
  `Host` char(255) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '',
  `Db` char(64) COLLATE utf8mb3_bin NOT NULL DEFAULT '',
  `User` char(32) COLLATE utf8mb3_bin NOT NULL DEFAULT '',
  `Table_name` char(64) COLLATE utf8mb3_bin NOT NULL DEFAULT '',
  `Grantor` varchar(288) COLLATE utf8mb3_bin NOT NULL DEFAULT '',
  `Timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `Table_priv` set('Select','Insert','Update','Delete','Create','Drop','Grant','References','Index','Alter','Create View','Show view','Trigger') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '',
  `Column_priv` set('Select','Insert','Update','References') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`Host`,`User`,`Db`,`Table_name`),
  KEY `Grantor` (`Grantor`)
) /*!50100 TABLESPACE `mysql` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin STATS_PERSISTENT=0 ROW_FORMAT=DYNAMIC COMMENT='Table privileges';

--
-- Dumping data for table `tables_priv`
--

INSERT INTO `tables_priv` VALUES ('localhost','mysql','mysql.session','user','boot@','2025-10-31 09:12:11','Select',''),('localhost','sys','mysql.sys','sys_config','root@localhost','2025-10-31 09:12:11','Select','');

--
-- Table structure for table `time_zone`
--

CREATE TABLE `time_zone` (
  `Time_zone_id` int unsigned NOT NULL AUTO_INCREMENT,
  `Use_leap_seconds` enum('Y','N') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
  PRIMARY KEY (`Time_zone_id`)
) /*!50100 TABLESPACE `mysql` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 STATS_PERSISTENT=0 ROW_FORMAT=DYNAMIC COMMENT='Time zones';

--
-- Dumping data for table `time_zone`
--


--
-- Table structure for table `time_zone_leap_second`
--

CREATE TABLE `time_zone_leap_second` (
  `Transition_time` bigint NOT NULL,
  `Correction` int NOT NULL,
  PRIMARY KEY (`Transition_time`)
) /*!50100 TABLESPACE `mysql` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 STATS_PERSISTENT=0 ROW_FORMAT=DYNAMIC COMMENT='Leap seconds information for time zones';

--
-- Dumping data for table `time_zone_leap_second`
--


--
-- Table structure for table `time_zone_name`
--

CREATE TABLE `time_zone_name` (
  `Name` char(64) NOT NULL,
  `Time_zone_id` int unsigned NOT NULL,
  PRIMARY KEY (`Name`)
) /*!50100 TABLESPACE `mysql` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 STATS_PERSISTENT=0 ROW_FORMAT=DYNAMIC COMMENT='Time zone names';

--
-- Dumping data for table `time_zone_name`
--


--
-- Table structure for table `time_zone_transition`
--

CREATE TABLE `time_zone_transition` (
  `Time_zone_id` int unsigned NOT NULL,
  `Transition_time` bigint NOT NULL,
  `Transition_type_id` int unsigned NOT NULL,
  PRIMARY KEY (`Time_zone_id`,`Transition_time`)
) /*!50100 TABLESPACE `mysql` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 STATS_PERSISTENT=0 ROW_FORMAT=DYNAMIC COMMENT='Time zone transitions';

--
-- Dumping data for table `time_zone_transition`
--


--
-- Table structure for table `time_zone_transition_type`
--

CREATE TABLE `time_zone_transition_type` (
  `Time_zone_id` int unsigned NOT NULL,
  `Transition_type_id` int unsigned NOT NULL,
  `Offset` int NOT NULL DEFAULT '0',
  `Is_DST` tinyint unsigned NOT NULL DEFAULT '0',
  `Abbreviation` char(8) NOT NULL DEFAULT '',
  PRIMARY KEY (`Time_zone_id`,`Transition_type_id`)
) /*!50100 TABLESPACE `mysql` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 STATS_PERSISTENT=0 ROW_FORMAT=DYNAMIC COMMENT='Time zone transition types';

--
-- Dumping data for table `time_zone_transition_type`
--


--
-- Table structure for table `user`
--

CREATE TABLE `user` (
  `Host` char(255) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '',
  `User` char(32) COLLATE utf8mb3_bin NOT NULL DEFAULT '',
  `Select_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
  `Insert_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
  `Update_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
  `Delete_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
  `Create_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
  `Drop_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
  `Reload_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
  `Shutdown_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
  `Process_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
  `File_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
  `Grant_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
  `References_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
  `Index_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
  `Alter_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
  `Show_db_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
  `Super_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
  `Create_tmp_table_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
  `Lock_tables_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
  `Execute_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
  `Repl_slave_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
  `Repl_client_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
  `Create_view_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
  `Show_view_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
  `Create_routine_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
  `Alter_routine_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
  `Create_user_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
  `Event_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
  `Trigger_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
  `Create_tablespace_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
  `ssl_type` enum('','ANY','X509','SPECIFIED') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '',
  `ssl_cipher` blob NOT NULL,
  `x509_issuer` blob NOT NULL,
  `x509_subject` blob NOT NULL,
  `max_questions` int unsigned NOT NULL DEFAULT '0',
  `max_updates` int unsigned NOT NULL DEFAULT '0',
  `max_connections` int unsigned NOT NULL DEFAULT '0',
  `max_user_connections` int unsigned NOT NULL DEFAULT '0',
  `plugin` char(64) COLLATE utf8mb3_bin NOT NULL DEFAULT 'caching_sha2_password',
  `authentication_string` text COLLATE utf8mb3_bin,
  `password_expired` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
  `password_last_changed` timestamp NULL DEFAULT NULL,
  `password_lifetime` smallint unsigned DEFAULT NULL,
  `account_locked` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
  `Create_role_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
  `Drop_role_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
  `Password_reuse_history` smallint unsigned DEFAULT NULL,
  `Password_reuse_time` smallint unsigned DEFAULT NULL,
  `Password_require_current` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `User_attributes` json DEFAULT NULL,
  PRIMARY KEY (`Host`,`User`)
) /*!50100 TABLESPACE `mysql` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin STATS_PERSISTENT=0 ROW_FORMAT=DYNAMIC COMMENT='Users and global privileges';

--
-- Dumping data for table `user`
--

INSERT INTO `user` VALUES ('localhost','mysql.infoschema','Y','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','','','','',0,0,0,0,'caching_sha2_password','$A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED','N','2025-10-31 09:12:11',NULL,'Y','N','N',NULL,NULL,NULL,NULL),('localhost','mysql.session','N','N','N','N','N','N','N','Y','N','N','N','N','N','N','N','Y','N','N','N','N','N','N','N','N','N','N','N','N','N','','','','',0,0,0,0,'caching_sha2_password','$A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED','N','2025-10-31 09:12:11',NULL,'Y','N','N',NULL,NULL,NULL,NULL),('localhost','mysql.sys','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','','','','',0,0,0,0,'caching_sha2_password','$A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED','N','2025-10-31 09:12:11',NULL,'Y','N','N',NULL,NULL,NULL,NULL),('localhost','root','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','','','','',0,0,0,0,'caching_sha2_password','','N','2025-10-31 09:12:10',NULL,'N','Y','Y',NULL,NULL,NULL,NULL);

--
-- Dumping events for database 'mysql'
--

--
-- Dumping routines for database 'mysql'
--

--
-- Table structure for table `general_log`
--

CREATE TABLE IF NOT EXISTS `general_log` (
  `event_time` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),
  `user_host` mediumtext NOT NULL,
  `thread_id` bigint unsigned NOT NULL,
  `server_id` int unsigned NOT NULL,
  `command_type` varchar(64) NOT NULL,
  `argument` mediumblob NOT NULL
) ENGINE=CSV DEFAULT CHARSET=utf8mb3 COMMENT='General log';

--
-- Table structure for table `slow_log`
--

CREATE TABLE IF NOT EXISTS `slow_log` (
  `start_time` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),
  `user_host` mediumtext NOT NULL,
  `query_time` time(6) NOT NULL,
  `lock_time` time(6) NOT NULL,
  `rows_sent` int NOT NULL,
  `rows_examined` int NOT NULL,
  `db` varchar(512) NOT NULL,
  `last_insert_id` int NOT NULL,
  `insert_id` int NOT NULL,
  `server_id` int unsigned NOT NULL,
  `sql_text` mediumblob NOT NULL,
  `thread_id` bigint unsigned NOT NULL
) ENGINE=CSV DEFAULT CHARSET=utf8mb3 COMMENT='Slow log';

--
-- Current Database: `kamar`
--

CREATE DATABASE /*!32312 IF NOT EXISTS*/ `kamar` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci */ /*!80016 DEFAULT ENCRYPTION='N' */;

USE `kamar`;

--
-- Table structure for table `booking_passengers`
--

CREATE TABLE `booking_passengers` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `flight_id` int DEFAULT NULL,
  `flight_seat_id` int DEFAULT NULL,
  `booking_id` int DEFAULT NULL,
  `seat_type` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `first_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `last_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `dob` datetime DEFAULT NULL,
  `price` decimal(12,2) DEFAULT NULL,
  `id_card` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `create_user` bigint DEFAULT NULL,
  `update_user` bigint DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `booking_passengers`
--


--
-- Table structure for table `bravo_airline`
--

CREATE TABLE `bravo_airline` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `image_id` int DEFAULT NULL,
  `create_user` bigint DEFAULT NULL,
  `update_user` bigint DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `bravo_airline`
--

INSERT INTO `bravo_airline` VALUES (1,'Kendraport',204,NULL,NULL,NULL,'2022-08-23 19:51:38','2022-08-23 19:51:38'),(2,'South Keeleyton',204,NULL,NULL,NULL,'2022-08-23 19:51:38','2022-08-23 19:51:38'),(3,'Port Friedrichview',203,NULL,NULL,NULL,'2022-08-23 19:51:38','2022-08-23 19:51:38'),(4,'Rutherfordburgh',203,NULL,NULL,NULL,'2022-08-23 19:51:38','2022-08-23 19:51:38'),(5,'Kingland',204,NULL,NULL,NULL,'2022-08-23 19:51:38','2022-08-23 19:51:38'),(6,'Coraberg',202,NULL,NULL,NULL,'2022-08-23 19:51:38','2022-08-23 19:51:38'),(7,'Johnnyton',202,NULL,NULL,NULL,'2022-08-23 19:51:38','2022-08-23 19:51:38'),(8,'South Taryn',204,NULL,NULL,NULL,'2022-08-23 19:51:38','2022-08-23 19:51:38'),(9,'Port Braeden',204,NULL,NULL,NULL,'2022-08-23 19:51:38','2022-08-23 19:51:38'),(10,'Herzogmouth',203,NULL,NULL,NULL,'2022-08-23 19:51:38','2022-08-23 19:51:38'),(11,'Sipesmouth',204,NULL,NULL,NULL,'2022-08-23 19:51:38','2022-08-23 19:51:38'),(12,'Bradtkeview',203,NULL,NULL,NULL,'2022-08-23 19:51:38','2022-08-23 19:51:38'),(13,'Keeblermouth',204,NULL,NULL,NULL,'2022-08-23 19:51:38','2022-08-23 19:51:38'),(14,'Janieberg',202,NULL,NULL,NULL,'2022-08-23 19:51:38','2022-08-23 19:51:38'),(15,'West Juniusfurt',202,NULL,NULL,NULL,'2022-08-23 19:51:38','2022-08-23 19:51:38'),(16,'Port Kenyattaland',202,NULL,NULL,NULL,'2022-08-23 19:51:38','2022-08-23 19:51:38'),(17,'North Fletatown',203,NULL,NULL,NULL,'2022-08-23 19:51:38','2022-08-23 19:51:38'),(18,'Alysaland',203,NULL,NULL,NULL,'2022-08-23 19:51:38','2022-08-23 19:51:38'),(19,'New Hazleside',204,NULL,NULL,NULL,'2022-08-23 19:51:38','2022-08-23 19:51:38'),(20,'South Laurafurt',204,NULL,NULL,NULL,'2022-08-23 19:51:38','2022-08-23 19:51:38');

--
-- Table structure for table `bravo_airport`
--

CREATE TABLE `bravo_airport` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `code` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `address` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `country` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `location_id` int DEFAULT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `map_lat` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `map_lng` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `map_zoom` int DEFAULT NULL,
  `create_user` bigint DEFAULT NULL,
  `update_user` bigint DEFAULT NULL,
  `status` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'publish',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `bravo_airport_code_unique` (`code`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
