columns_priv
Comentarios de la tabla: Column privileges
| Columna |
Tipo |
Nulo |
Predeterminado |
Comentarios |
|
Host
(Primaria)
|
char(255)
|
No |
|
|
|
Db
(Primaria)
|
char(64)
|
No |
|
|
|
User
(Primaria)
|
char(32)
|
No |
|
|
|
Table_name
(Primaria)
|
char(64)
|
No |
|
|
|
Column_name
(Primaria)
|
char(64)
|
No |
|
|
|
Timestamp
|
timestamp
|
No |
CURRENT_TIMESTAMP
|
|
|
Column_priv
|
set('Select', 'Insert', 'Update', 'References')
|
No |
|
|
Índices
| Nombre de la clave |
Tipo |
Único |
Empaquetado |
Columna |
Cardinalidad |
Cotejamiento |
Nulo |
Comentario |
| PRIMARY |
BTREE |
Sí |
No |
Host
|
0 |
A |
No |
|
|
Db
|
0 |
A |
No |
|
User
|
0 |
A |
No |
|
Table_name
|
0 |
A |
No |
|
Column_name
|
0 |
A |
No |
component
Comentarios de la tabla: Components
| Columna |
Tipo |
Nulo |
Predeterminado |
Comentarios |
|
component_id
(Primaria)
|
int(10)
|
No |
|
|
|
component_group_id
|
int(10)
|
No |
|
|
|
component_urn
|
text
|
No |
|
|
Índices
| Nombre de la clave |
Tipo |
Único |
Empaquetado |
Columna |
Cardinalidad |
Cotejamiento |
Nulo |
Comentario |
| PRIMARY |
BTREE |
Sí |
No |
component_id
|
0 |
A |
No |
|
db
Comentarios de la tabla: Database privileges
| Columna |
Tipo |
Nulo |
Predeterminado |
Comentarios |
|
Host
(Primaria)
|
char(255)
|
No |
|
|
|
Db
(Primaria)
|
char(64)
|
No |
|
|
|
User
(Primaria)
|
char(32)
|
No |
|
|
|
Select_priv
|
enum('N', 'Y')
|
No |
N
|
|
|
Insert_priv
|
enum('N', 'Y')
|
No |
N
|
|
|
Update_priv
|
enum('N', 'Y')
|
No |
N
|
|
|
Delete_priv
|
enum('N', 'Y')
|
No |
N
|
|
|
Create_priv
|
enum('N', 'Y')
|
No |
N
|
|
|
Drop_priv
|
enum('N', 'Y')
|
No |
N
|
|
|
Grant_priv
|
enum('N', 'Y')
|
No |
N
|
|
|
References_priv
|
enum('N', 'Y')
|
No |
N
|
|
|
Index_priv
|
enum('N', 'Y')
|
No |
N
|
|
|
Alter_priv
|
enum('N', 'Y')
|
No |
N
|
|
|
Create_tmp_table_priv
|
enum('N', 'Y')
|
No |
N
|
|
|
Lock_tables_priv
|
enum('N', 'Y')
|
No |
N
|
|
|
Create_view_priv
|
enum('N', 'Y')
|
No |
N
|
|
|
Show_view_priv
|
enum('N', 'Y')
|
No |
N
|
|
|
Create_routine_priv
|
enum('N', 'Y')
|
No |
N
|
|
|
Alter_routine_priv
|
enum('N', 'Y')
|
No |
N
|
|
|
Execute_priv
|
enum('N', 'Y')
|
No |
N
|
|
|
Event_priv
|
enum('N', 'Y')
|
No |
N
|
|
|
Trigger_priv
|
enum('N', 'Y')
|
No |
N
|
|
Índices
| Nombre de la clave |
Tipo |
Único |
Empaquetado |
Columna |
Cardinalidad |
Cotejamiento |
Nulo |
Comentario |
| PRIMARY |
BTREE |
Sí |
No |
Host
|
2 |
A |
No |
|
|
Db
|
5 |
A |
No |
|
User
|
5 |
A |
No |
| User |
BTREE |
No |
No |
User
|
5 |
A |
No |
|
default_roles
Comentarios de la tabla: Default roles
| Columna |
Tipo |
Nulo |
Predeterminado |
Comentarios |
|
HOST
(Primaria)
|
char(255)
|
No |
|
|
|
USER
(Primaria)
|
char(32)
|
No |
|
|
|
DEFAULT_ROLE_HOST
(Primaria)
|
char(255)
|
No |
%
|
|
|
DEFAULT_ROLE_USER
(Primaria)
|
char(32)
|
No |
|
|
Índices
| Nombre de la clave |
Tipo |
Único |
Empaquetado |
Columna |
Cardinalidad |
Cotejamiento |
Nulo |
Comentario |
| PRIMARY |
BTREE |
Sí |
No |
HOST
|
0 |
A |
No |
|
|
USER
|
0 |
A |
No |
|
DEFAULT_ROLE_HOST
|
0 |
A |
No |
|
DEFAULT_ROLE_USER
|
0 |
A |
No |
engine_cost
| Columna |
Tipo |
Nulo |
Predeterminado |
Comentarios |
|
engine_name
(Primaria)
|
varchar(64)
|
No |
|
|
|
device_type
(Primaria)
|
int(11)
|
No |
|
|
|
cost_name
(Primaria)
|
varchar(64)
|
No |
|
|
|
cost_value
|
float
|
Sí |
NULL
|
|
|
last_update
|
timestamp
|
No |
CURRENT_TIMESTAMP
|
|
|
comment
|
varchar(1024)
|
Sí |
NULL
|
|
|
default_value
|
float
|
Sí |
NULL
|
|
Índices
| Nombre de la clave |
Tipo |
Único |
Empaquetado |
Columna |
Cardinalidad |
Cotejamiento |
Nulo |
Comentario |
| PRIMARY |
BTREE |
Sí |
No |
cost_name
|
2 |
A |
No |
|
|
engine_name
|
2 |
A |
No |
|
device_type
|
2 |
A |
No |
func
Comentarios de la tabla: User defined functions
| Columna |
Tipo |
Nulo |
Predeterminado |
Comentarios |
|
name
(Primaria)
|
char(64)
|
No |
|
|
|
ret
|
tinyint(1)
|
No |
0
|
|
|
dl
|
char(128)
|
No |
|
|
|
type
|
enum('function', 'aggregate')
|
No |
|
|
Índices
| Nombre de la clave |
Tipo |
Único |
Empaquetado |
Columna |
Cardinalidad |
Cotejamiento |
Nulo |
Comentario |
| PRIMARY |
BTREE |
Sí |
No |
name
|
0 |
A |
No |
|
general_log
Comentarios de la tabla: General log
| Columna |
Tipo |
Nulo |
Predeterminado |
Comentarios |
|
event_time
|
timestamp(6)
|
No |
CURRENT_TIMESTAMP(6)
|
|
|
user_host
|
mediumtext
|
No |
|
|
|
thread_id
|
bigint(21)
|
No |
|
|
|
server_id
|
int(10)
|
No |
|
|
|
command_type
|
varchar(64)
|
No |
|
|
|
argument
|
mediumblob
|
No |
|
|
¡No se ha definido ningún índice!
global_grants
Comentarios de la tabla: Extended global grants
| Columna |
Tipo |
Nulo |
Predeterminado |
Comentarios |
|
USER
(Primaria)
|
char(32)
|
No |
|
|
|
HOST
(Primaria)
|
char(255)
|
No |
|
|
|
PRIV
(Primaria)
|
char(32)
|
No |
|
|
|
WITH_GRANT_OPTION
|
enum('N', 'Y')
|
No |
N
|
|
Índices
| Nombre de la clave |
Tipo |
Único |
Empaquetado |
Columna |
Cardinalidad |
Cotejamiento |
Nulo |
Comentario |
| PRIMARY |
BTREE |
Sí |
No |
USER
|
3 |
A |
No |
|
|
HOST
|
4 |
A |
No |
|
PRIV
|
76 |
A |
No |
gtid_executed
| Columna |
Tipo |
Nulo |
Predeterminado |
Comentarios |
|
source_uuid
(Primaria)
|
char(36)
|
No |
|
uuid of the source where the transaction was originally executed. |
|
interval_start
(Primaria)
|
bigint(20)
|
No |
|
First number of interval. |
|
interval_end
|
bigint(20)
|
No |
|
Last number of interval. |
Índices
| Nombre de la clave |
Tipo |
Único |
Empaquetado |
Columna |
Cardinalidad |
Cotejamiento |
Nulo |
Comentario |
| PRIMARY |
BTREE |
Sí |
No |
source_uuid
|
0 |
A |
No |
|
|
interval_start
|
0 |
A |
No |
help_category
Comentarios de la tabla: help categories
| Columna |
Tipo |
Nulo |
Predeterminado |
Comentarios |
|
help_category_id
(Primaria)
|
smallint(5)
|
No |
|
|
|
name
|
char(64)
|
No |
|
|
|
parent_category_id
|
smallint(5)
|
Sí |
NULL
|
|
|
url
|
text
|
No |
|
|
Índices
| Nombre de la clave |
Tipo |
Único |
Empaquetado |
Columna |
Cardinalidad |
Cotejamiento |
Nulo |
Comentario |
| PRIMARY |
BTREE |
Sí |
No |
help_category_id
|
44 |
A |
No |
|
| name |
BTREE |
Sí |
No |
name
|
44 |
A |
No |
|
help_keyword
Comentarios de la tabla: help keywords
| Columna |
Tipo |
Nulo |
Predeterminado |
Comentarios |
|
help_keyword_id
(Primaria)
|
int(10)
|
No |
|
|
|
name
|
char(64)
|
No |
|
|
Índices
| Nombre de la clave |
Tipo |
Único |
Empaquetado |
Columna |
Cardinalidad |
Cotejamiento |
Nulo |
Comentario |
| PRIMARY |
BTREE |
Sí |
No |
help_keyword_id
|
671 |
A |
No |
|
| name |
BTREE |
Sí |
No |
name
|
671 |
A |
No |
|
help_relation
Comentarios de la tabla: keyword-topic relation
| Columna |
Tipo |
Nulo |
Predeterminado |
Comentarios |
|
help_topic_id
(Primaria)
|
int(10)
|
No |
|
|
|
help_keyword_id
(Primaria)
|
int(10)
|
No |
|
|
Índices
| Nombre de la clave |
Tipo |
Único |
Empaquetado |
Columna |
Cardinalidad |
Cotejamiento |
Nulo |
Comentario |
| PRIMARY |
BTREE |
Sí |
No |
help_keyword_id
|
607 |
A |
No |
|
|
help_topic_id
|
1608 |
A |
No |
help_topic
Comentarios de la tabla: help topics
| Columna |
Tipo |
Nulo |
Predeterminado |
Comentarios |
|
help_topic_id
(Primaria)
|
int(10)
|
No |
|
|
|
name
|
char(64)
|
No |
|
|
|
help_category_id
|
smallint(5)
|
No |
|
|
|
description
|
text
|
No |
|
|
|
example
|
text
|
No |
|
|
|
url
|
text
|
No |
|
|
Índices
| Nombre de la clave |
Tipo |
Único |
Empaquetado |
Columna |
Cardinalidad |
Cotejamiento |
Nulo |
Comentario |
| PRIMARY |
BTREE |
Sí |
No |
help_topic_id
|
681 |
A |
No |
|
| name |
BTREE |
Sí |
No |
name
|
570 |
A |
No |
|
innodb_index_stats
| Columna |
Tipo |
Nulo |
Predeterminado |
Comentarios |
|
database_name
(Primaria)
|
varchar(64)
|
No |
|
|
|
table_name
(Primaria)
|
varchar(199)
|
No |
|
|
|
index_name
(Primaria)
|
varchar(64)
|
No |
|
|
|
last_update
|
timestamp
|
No |
CURRENT_TIMESTAMP
|
|
|
stat_name
(Primaria)
|
varchar(64)
|
No |
|
|
|
stat_value
|
bigint(20)
|
No |
|
|
|
sample_size
|
bigint(20)
|
Sí |
NULL
|
|
|
stat_description
|
varchar(1024)
|
No |
|
|
Índices
| Nombre de la clave |
Tipo |
Único |
Empaquetado |
Columna |
Cardinalidad |
Cotejamiento |
Nulo |
Comentario |
| PRIMARY |
BTREE |
Sí |
No |
database_name
|
23 |
A |
No |
|
|
table_name
|
64 |
A |
No |
|
index_name
|
99 |
A |
No |
|
stat_name
|
353 |
A |
No |
innodb_table_stats
| Columna |
Tipo |
Nulo |
Predeterminado |
Comentarios |
|
database_name
(Primaria)
|
varchar(64)
|
No |
|
|
|
table_name
(Primaria)
|
varchar(199)
|
No |
|
|
|
last_update
|
timestamp
|
No |
CURRENT_TIMESTAMP
|
|
|
n_rows
|
bigint(20)
|
No |
|
|
|
clustered_index_size
|
bigint(20)
|
No |
|
|
|
sum_of_other_index_sizes
|
bigint(20)
|
No |
|
|
Índices
| Nombre de la clave |
Tipo |
Único |
Empaquetado |
Columna |
Cardinalidad |
Cotejamiento |
Nulo |
Comentario |
| PRIMARY |
BTREE |
Sí |
No |
database_name
|
20 |
A |
No |
|
|
table_name
|
60 |
A |
No |
password_history
Comentarios de la tabla: Password history for user accounts
| Columna |
Tipo |
Nulo |
Predeterminado |
Comentarios |
|
Host
(Primaria)
|
char(255)
|
No |
|
|
|
User
(Primaria)
|
char(32)
|
No |
|
|
|
Password_timestamp
(Primaria)
|
timestamp(6)
|
No |
CURRENT_TIMESTAMP(6)
|
|
|
Password
|
text
|
Sí |
NULL
|
|
Índices
| Nombre de la clave |
Tipo |
Único |
Empaquetado |
Columna |
Cardinalidad |
Cotejamiento |
Nulo |
Comentario |
| PRIMARY |
BTREE |
Sí |
No |
Host
|
0 |
A |
No |
|
|
User
|
0 |
A |
No |
|
Password_timestamp
|
0 |
D |
No |
plugin
Comentarios de la tabla: MySQL plugins
| Columna |
Tipo |
Nulo |
Predeterminado |
Comentarios |
|
name
(Primaria)
|
varchar(64)
|
No |
|
|
|
dl
|
varchar(128)
|
No |
|
|
Índices
| Nombre de la clave |
Tipo |
Único |
Empaquetado |
Columna |
Cardinalidad |
Cotejamiento |
Nulo |
Comentario |
| PRIMARY |
BTREE |
Sí |
No |
name
|
1 |
A |
No |
|
procs_priv
Comentarios de la tabla: Procedure privileges
| Columna |
Tipo |
Nulo |
Predeterminado |
Comentarios |
|
Host
(Primaria)
|
char(255)
|
No |
|
|
|
Db
(Primaria)
|
char(64)
|
No |
|
|
|
User
(Primaria)
|
char(32)
|
No |
|
|
|
Routine_name
(Primaria)
|
char(64)
|
No |
|
|
|
Routine_type
(Primaria)
|
enum('FUNCTION', 'PROCEDURE')
|
No |
|
|
|
Grantor
|
varchar(288)
|
No |
|
|
|
Proc_priv
|
set('Execute', 'Alter Routine', 'Grant')
|
No |
|
|
|
Timestamp
|
timestamp
|
No |
CURRENT_TIMESTAMP
|
|
Índices
| Nombre de la clave |
Tipo |
Único |
Empaquetado |
Columna |
Cardinalidad |
Cotejamiento |
Nulo |
Comentario |
| PRIMARY |
BTREE |
Sí |
No |
Host
|
0 |
A |
No |
|
|
Db
|
0 |
A |
No |
|
User
|
0 |
A |
No |
|
Routine_name
|
0 |
A |
No |
|
Routine_type
|
0 |
A |
No |
| Grantor |
BTREE |
No |
No |
Grantor
|
0 |
A |
No |
|
proxies_priv
Comentarios de la tabla: User proxy privileges
| Columna |
Tipo |
Nulo |
Predeterminado |
Comentarios |
|
Host
(Primaria)
|
char(255)
|
No |
|
|
|
User
(Primaria)
|
char(32)
|
No |
|
|
|
Proxied_host
(Primaria)
|
char(255)
|
No |
|
|
|
Proxied_user
(Primaria)
|
char(32)
|
No |
|
|
|
With_grant
|
tinyint(1)
|
No |
0
|
|
|
Grantor
|
varchar(288)
|
No |
|
|
|
Timestamp
|
timestamp
|
No |
CURRENT_TIMESTAMP
|
|
Índices
| Nombre de la clave |
Tipo |
Único |
Empaquetado |
Columna |
Cardinalidad |
Cotejamiento |
Nulo |
Comentario |
| PRIMARY |
BTREE |
Sí |
No |
Host
|
1 |
A |
No |
|
|
User
|
1 |
A |
No |
|
Proxied_host
|
1 |
A |
No |
|
Proxied_user
|
1 |
A |
No |
| Grantor |
BTREE |
No |
No |
Grantor
|
1 |
A |
No |
|
role_edges
Comentarios de la tabla: Role hierarchy and role grants
| Columna |
Tipo |
Nulo |
Predeterminado |
Comentarios |
|
FROM_HOST
(Primaria)
|
char(255)
|
No |
|
|
|
FROM_USER
(Primaria)
|
char(32)
|
No |
|
|
|
TO_HOST
(Primaria)
|
char(255)
|
No |
|
|
|
TO_USER
(Primaria)
|
char(32)
|
No |
|
|
|
WITH_ADMIN_OPTION
|
enum('N', 'Y')
|
No |
N
|
|
Índices
| Nombre de la clave |
Tipo |
Único |
Empaquetado |
Columna |
Cardinalidad |
Cotejamiento |
Nulo |
Comentario |
| PRIMARY |
BTREE |
Sí |
No |
FROM_HOST
|
0 |
A |
No |
|
|
FROM_USER
|
0 |
A |
No |
|
TO_HOST
|
0 |
A |
No |
|
TO_USER
|
0 |
A |
No |
servers
Comentarios de la tabla: MySQL Foreign Servers table
| Columna |
Tipo |
Nulo |
Predeterminado |
Comentarios |
|
Server_name
(Primaria)
|
char(64)
|
No |
|
|
|
Host
|
char(255)
|
No |
|
|
|
Db
|
char(64)
|
No |
|
|
|
Username
|
char(64)
|
No |
|
|
|
Password
|
char(64)
|
No |
|
|
|
Port
|
int(4)
|
No |
0
|
|
|
Socket
|
char(64)
|
No |
|
|
|
Wrapper
|
char(64)
|
No |
|
|
|
Owner
|
char(64)
|
No |
|
|
Índices
| Nombre de la clave |
Tipo |
Único |
Empaquetado |
Columna |
Cardinalidad |
Cotejamiento |
Nulo |
Comentario |
| PRIMARY |
BTREE |
Sí |
No |
Server_name
|
0 |
A |
No |
|
server_cost
| Columna |
Tipo |
Nulo |
Predeterminado |
Comentarios |
|
cost_name
(Primaria)
|
varchar(64)
|
No |
|
|
|
cost_value
|
float
|
Sí |
NULL
|
|
|
last_update
|
timestamp
|
No |
CURRENT_TIMESTAMP
|
|
|
comment
|
varchar(1024)
|
Sí |
NULL
|
|
|
default_value
|
float
|
Sí |
NULL
|
|
Índices
| Nombre de la clave |
Tipo |
Único |
Empaquetado |
Columna |
Cardinalidad |
Cotejamiento |
Nulo |
Comentario |
| PRIMARY |
BTREE |
Sí |
No |
cost_name
|
6 |
A |
No |
|
slave_master_info
Comentarios de la tabla: Master Information
| Columna |
Tipo |
Nulo |
Predeterminado |
Comentarios |
|
Number_of_lines
|
int(10)
|
No |
|
Number of lines in the file. |
|
Master_log_name
|
text
|
No |
|
The name of the master binary log currently being read from the master. |
|
Master_log_pos
|
bigint(20)
|
No |
|
The master log position of the last read event. |
|
Host
|
char(255)
|
Sí |
NULL
|
The host name of the master. |
|
User_name
|
text
|
Sí |
NULL
|
The user name used to connect to the master. |
|
User_password
|
text
|
Sí |
NULL
|
The password used to connect to the master. |
|
Port
|
int(10)
|
No |
|
The network port used to connect to the master. |
|
Connect_retry
|
int(10)
|
No |
|
The period (in seconds) that the slave will wait before trying to reconnect to the master. |
|
Enabled_ssl
|
tinyint(1)
|
No |
|
Indicates whether the server supports SSL connections. |
|
Ssl_ca
|
text
|
Sí |
NULL
|
The file used for the Certificate Authority (CA) certificate. |
|
Ssl_capath
|
text
|
Sí |
NULL
|
The path to the Certificate Authority (CA) certificates. |
|
Ssl_cert
|
text
|
Sí |
NULL
|
The name of the SSL certificate file. |
|
Ssl_cipher
|
text
|
Sí |
NULL
|
The name of the cipher in use for the SSL connection. |
|
Ssl_key
|
text
|
Sí |
NULL
|
The name of the SSL key file. |
|
Ssl_verify_server_cert
|
tinyint(1)
|
No |
|
Whether to verify the server certificate. |
|
Heartbeat
|
float
|
No |
|
|
|
Bind
|
text
|
Sí |
NULL
|
Displays which interface is employed when connecting to the MySQL server |
|
Ignored_server_ids
|
text
|
Sí |
NULL
|
The number of server IDs to be ignored, followed by the actual server IDs |
|
Uuid
|
text
|
Sí |
NULL
|
The master server uuid. |
|
Retry_count
|
bigint(20)
|
No |
|
Number of reconnect attempts, to the master, before giving up. |
|
Ssl_crl
|
text
|
Sí |
NULL
|
The file used for the Certificate Revocation List (CRL) |
|
Ssl_crlpath
|
text
|
Sí |
NULL
|
The path used for Certificate Revocation List (CRL) files |
|
Enabled_auto_position
|
tinyint(1)
|
No |
|
Indicates whether GTIDs will be used to retrieve events from the master. |
|
Channel_name
(Primaria)
|
char(64)
|
No |
|
The channel on which the slave is connected to a source. Used in Multisource Replication |
|
Tls_version
|
text
|
Sí |
NULL
|
Tls version |
|
Public_key_path
|
text
|
Sí |
NULL
|
The file containing public key of master server. |
|
Get_public_key
|
tinyint(1)
|
No |
|
Preference to get public key from master. |
|
Network_namespace
|
text
|
Sí |
NULL
|
Network namespace used for communication with the master server. |
|
Master_compression_algorithm
|
char(64)
|
No |
|
Compression algorithm supported for data transfer between master and slave. |
|
Master_zstd_compression_level
|
int(10)
|
No |
|
Compression level associated with zstd compression algorithm. |
Índices
| Nombre de la clave |
Tipo |
Único |
Empaquetado |
Columna |
Cardinalidad |
Cotejamiento |
Nulo |
Comentario |
| PRIMARY |
BTREE |
Sí |
No |
Channel_name
|
0 |
A |
No |
|
slave_relay_log_info
Comentarios de la tabla: Relay Log Information
| Columna |
Tipo |
Nulo |
Predeterminado |
Comentarios |
|
Number_of_lines
|
int(10)
|
No |
|
Number of lines in the file or rows in the table. Used to version table definitions. |
|
Relay_log_name
|
text
|
No |
|
The name of the current relay log file. |
|
Relay_log_pos
|
bigint(20)
|
No |
|
The relay log position of the last executed event. |
|
Master_log_name
|
text
|
No |
|
The name of the master binary log file from which the events in the relay log file were read. |
|
Master_log_pos
|
bigint(20)
|
No |
|
The master log position of the last executed event. |
|
Sql_delay
|
int(11)
|
No |
|
The number of seconds that the slave must lag behind the master. |
|
Number_of_workers
|
int(10)
|
No |
|
|
|
Id
|
int(10)
|
No |
|
Internal Id that uniquely identifies this record. |
|
Channel_name
(Primaria)
|
char(64)
|
No |
|
The channel on which the slave is connected to a source. Used in Multisource Replication |
|
Privilege_checks_username
|
char(32)
|
Sí |
NULL
|
Username part of PRIVILEGE_CHECKS_USER. |
|
Privilege_checks_hostname
|
char(255)
|
Sí |
NULL
|
Hostname part of PRIVILEGE_CHECKS_USER. |
Índices
| Nombre de la clave |
Tipo |
Único |
Empaquetado |
Columna |
Cardinalidad |
Cotejamiento |
Nulo |
Comentario |
| PRIMARY |
BTREE |
Sí |
No |
Channel_name
|
0 |
A |
No |
|
slave_worker_info
Comentarios de la tabla: Worker Information
| Columna |
Tipo |
Nulo |
Predeterminado |
Comentarios |
|
Id
(Primaria)
|
int(10)
|
No |
|
|
|
Relay_log_name
|
text
|
No |
|
|
|
Relay_log_pos
|
bigint(20)
|
No |
|
|
|
Master_log_name
|
text
|
No |
|
|
|
Master_log_pos
|
bigint(20)
|
No |
|
|
|
Checkpoint_relay_log_name
|
text
|
No |
|
|
|
Checkpoint_relay_log_pos
|
bigint(20)
|
No |
|
|
|
Checkpoint_master_log_name
|
text
|
No |
|
|
|
Checkpoint_master_log_pos
|
bigint(20)
|
No |
|
|
|
Checkpoint_seqno
|
int(10)
|
No |
|
|
|
Checkpoint_group_size
|
int(10)
|
No |
|
|
|
Checkpoint_group_bitmap
|
blob
|
No |
|
|
|
Channel_name
(Primaria)
|
char(64)
|
No |
|
The channel on which the slave is connected to a source. Used in Multisource Replication |
Índices
| Nombre de la clave |
Tipo |
Único |
Empaquetado |
Columna |
Cardinalidad |
Cotejamiento |
Nulo |
Comentario |
| PRIMARY |
BTREE |
Sí |
No |
Channel_name
|
0 |
A |
No |
|
|
Id
|
0 |
A |
No |
slow_log
Comentarios de la tabla: Slow log
| Columna |
Tipo |
Nulo |
Predeterminado |
Comentarios |
|
start_time
|
timestamp(6)
|
No |
CURRENT_TIMESTAMP(6)
|
|
|
user_host
|
mediumtext
|
No |
|
|
|
query_time
|
time(6)
|
No |
|
|
|
lock_time
|
time(6)
|
No |
|
|
|
rows_sent
|
int(11)
|
No |
|
|
|
rows_examined
|
int(11)
|
No |
|
|
|
db
|
varchar(512)
|
No |
|
|
|
last_insert_id
|
int(11)
|
No |
|
|
|
insert_id
|
int(11)
|
No |
|
|
|
server_id
|
int(10)
|
No |
|
|
|
sql_text
|
mediumblob
|
No |
|
|
|
thread_id
|
bigint(21)
|
No |
|
|
¡No se ha definido ningún índice!
tables_priv
Comentarios de la tabla: Table privileges
| Columna |
Tipo |
Nulo |
Predeterminado |
Comentarios |
|
Host
(Primaria)
|
char(255)
|
No |
|
|
|
Db
(Primaria)
|
char(64)
|
No |
|
|
|
User
(Primaria)
|
char(32)
|
No |
|
|
|
Table_name
(Primaria)
|
char(64)
|
No |
|
|
|
Grantor
|
varchar(288)
|
No |
|
|
|
Timestamp
|
timestamp
|
No |
CURRENT_TIMESTAMP
|
|
|
Table_priv
|
set('Select', 'Insert', 'Update', 'Delete', 'Create', 'Drop', 'Grant', 'References', 'Index', 'Alter', 'Create View', 'Show view', 'Trigger')
|
No |
|
|
|
Column_priv
|
set('Select', 'Insert', 'Update', 'References')
|
No |
|
|
Índices
| Nombre de la clave |
Tipo |
Único |
Empaquetado |
Columna |
Cardinalidad |
Cotejamiento |
Nulo |
Comentario |
| PRIMARY |
BTREE |
Sí |
No |
Host
|
1 |
A |
No |
|
|
Db
|
2 |
A |
No |
|
User
|
2 |
A |
No |
|
Table_name
|
2 |
A |
No |
| Grantor |
BTREE |
No |
No |
Grantor
|
2 |
A |
No |
|
time_zone
Comentarios de la tabla: Time zones
| Columna |
Tipo |
Nulo |
Predeterminado |
Comentarios |
|
Time_zone_id
(Primaria)
|
int(10)
|
No |
|
|
|
Use_leap_seconds
|
enum('Y', 'N')
|
No |
N
|
|
Índices
| Nombre de la clave |
Tipo |
Único |
Empaquetado |
Columna |
Cardinalidad |
Cotejamiento |
Nulo |
Comentario |
| PRIMARY |
BTREE |
Sí |
No |
Time_zone_id
|
0 |
A |
No |
|
time_zone_leap_second
Comentarios de la tabla: Leap seconds information for time zones
| Columna |
Tipo |
Nulo |
Predeterminado |
Comentarios |
|
Transition_time
(Primaria)
|
bigint(20)
|
No |
|
|
|
Correction
|
int(11)
|
No |
|
|
Índices
| Nombre de la clave |
Tipo |
Único |
Empaquetado |
Columna |
Cardinalidad |
Cotejamiento |
Nulo |
Comentario |
| PRIMARY |
BTREE |
Sí |
No |
Transition_time
|
0 |
A |
No |
|
time_zone_name
Comentarios de la tabla: Time zone names
| Columna |
Tipo |
Nulo |
Predeterminado |
Comentarios |
|
Name
(Primaria)
|
char(64)
|
No |
|
|
|
Time_zone_id
|
int(10)
|
No |
|
|
Índices
| Nombre de la clave |
Tipo |
Único |
Empaquetado |
Columna |
Cardinalidad |
Cotejamiento |
Nulo |
Comentario |
| PRIMARY |
BTREE |
Sí |
No |
Name
|
0 |
A |
No |
|
time_zone_transition
Comentarios de la tabla: Time zone transitions
| Columna |
Tipo |
Nulo |
Predeterminado |
Comentarios |
|
Time_zone_id
(Primaria)
|
int(10)
|
No |
|
|
|
Transition_time
(Primaria)
|
bigint(20)
|
No |
|
|
|
Transition_type_id
|
int(10)
|
No |
|
|
Índices
| Nombre de la clave |
Tipo |
Único |
Empaquetado |
Columna |
Cardinalidad |
Cotejamiento |
Nulo |
Comentario |
| PRIMARY |
BTREE |
Sí |
No |
Time_zone_id
|
0 |
A |
No |
|
|
Transition_time
|
0 |
A |
No |
time_zone_transition_type
Comentarios de la tabla: Time zone transition types
| Columna |
Tipo |
Nulo |
Predeterminado |
Comentarios |
|
Time_zone_id
(Primaria)
|
int(10)
|
No |
|
|
|
Transition_type_id
(Primaria)
|
int(10)
|
No |
|
|
|
Offset
|
int(11)
|
No |
0
|
|
|
Is_DST
|
tinyint(3)
|
No |
0
|
|
|
Abbreviation
|
char(8)
|
No |
|
|
Índices
| Nombre de la clave |
Tipo |
Único |
Empaquetado |
Columna |
Cardinalidad |
Cotejamiento |
Nulo |
Comentario |
| PRIMARY |
BTREE |
Sí |
No |
Time_zone_id
|
0 |
A |
No |
|
|
Transition_type_id
|
0 |
A |
No |
user
Comentarios de la tabla: Users and global privileges
| Columna |
Tipo |
Nulo |
Predeterminado |
Comentarios |
|
Host
(Primaria)
|
char(255)
|
No |
|
|
|
User
(Primaria)
|
char(32)
|
No |
|
|
|
Select_priv
|
enum('N', 'Y')
|
No |
N
|
|
|
Insert_priv
|
enum('N', 'Y')
|
No |
N
|
|
|
Update_priv
|
enum('N', 'Y')
|
No |
N
|
|
|
Delete_priv
|
enum('N', 'Y')
|
No |
N
|
|
|
Create_priv
|
enum('N', 'Y')
|
No |
N
|
|
|
Drop_priv
|
enum('N', 'Y')
|
No |
N
|
|
|
Reload_priv
|
enum('N', 'Y')
|
No |
N
|
|
|
Shutdown_priv
|
enum('N', 'Y')
|
No |
N
|
|
|
Process_priv
|
enum('N', 'Y')
|
No |
N
|
|
|
File_priv
|
enum('N', 'Y')
|
No |
N
|
|
|
Grant_priv
|
enum('N', 'Y')
|
No |
N
|
|
|
References_priv
|
enum('N', 'Y')
|
No |
N
|
|
|
Index_priv
|
enum('N', 'Y')
|
No |
N
|
|
|
Alter_priv
|
enum('N', 'Y')
|
No |
N
|
|
|
Show_db_priv
|
enum('N', 'Y')
|
No |
N
|
|
|
Super_priv
|
enum('N', 'Y')
|
No |
N
|
|
|
Create_tmp_table_priv
|
enum('N', 'Y')
|
No |
N
|
|
|
Lock_tables_priv
|
enum('N', 'Y')
|
No |
N
|
|
|
Execute_priv
|
enum('N', 'Y')
|
No |
N
|
|
|
Repl_slave_priv
|
enum('N', 'Y')
|
No |
N
|
|
|
Repl_client_priv
|
enum('N', 'Y')
|
No |
N
|
|
|
Create_view_priv
|
enum('N', 'Y')
|
No |
N
|
|
|
Show_view_priv
|
enum('N', 'Y')
|
No |
N
|
|
|
Create_routine_priv
|
enum('N', 'Y')
|
No |
N
|
|
|
Alter_routine_priv
|
enum('N', 'Y')
|
No |
N
|
|
|
Create_user_priv
|
enum('N', 'Y')
|
No |
N
|
|
|
Event_priv
|
enum('N', 'Y')
|
No |
N
|
|
|
Trigger_priv
|
enum('N', 'Y')
|
No |
N
|
|
|
Create_tablespace_priv
|
enum('N', 'Y')
|
No |
N
|
|
|
ssl_type
|
enum('', 'ANY', 'X509', 'SPECIFIED')
|
No |
|
|
|
ssl_cipher
|
blob
|
No |
|
|
|
x509_issuer
|
blob
|
No |
|
|
|
x509_subject
|
blob
|
No |
|
|
|
max_questions
|
int(11)
|
No |
0
|
|
|
max_updates
|
int(11)
|
No |
0
|
|
|
max_connections
|
int(11)
|
No |
0
|
|
|
max_user_connections
|
int(11)
|
No |
0
|
|
|
plugin
|
char(64)
|
No |
caching_sha2_password
|
|
|
authentication_string
|
text
|
Sí |
NULL
|
|
|
password_expired
|
enum('N', 'Y')
|
No |
N
|
|
|
password_last_changed
|
timestamp
|
Sí |
NULL
|
|
|
password_lifetime
|
smallint(5)
|
Sí |
NULL
|
|
|
account_locked
|
enum('N', 'Y')
|
No |
N
|
|
|
Create_role_priv
|
enum('N', 'Y')
|
No |
N
|
|
|
Drop_role_priv
|
enum('N', 'Y')
|
No |
N
|
|
|
Password_reuse_history
|
smallint(5)
|
Sí |
NULL
|
|
|
Password_reuse_time
|
smallint(5)
|
Sí |
NULL
|
|
|
Password_require_current
|
enum('N', 'Y')
|
Sí |
NULL
|
|
|
User_attributes
|
json
|
Sí |
NULL
|
|
Índices
| Nombre de la clave |
Tipo |
Único |
Empaquetado |
Columna |
Cardinalidad |
Cotejamiento |
Nulo |
Comentario |
| PRIMARY |
BTREE |
Sí |
No |
Host
|
2 |
A |
No |
|
|
User
|
9 |
A |
No |
