columns_priv

Table comments: Column privileges

Column Type Null Default Comments
Host char(60) No
Db char(64) No
User char(16) No
Table_name char(64) No
Column_name char(64) No
Timestamp timestamp No CURRENT_TIMESTAMP
Column_priv set('Select', 'Insert', 'Update', 'References') No

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoHostANo
DbANo
UserANo
Table_nameANo
Column_name29ANo

db

Table comments: Database privileges

Column Type Null Default Comments
Host char(60) No
Db char(64) No
User char(16) 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

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoHostANo
DbANo
User3ANo
UserBTREENoNoUserANo

event

Table comments: Events

Column Type Null Default Comments
db char(64) No
name char(64) No
body longblob No
definer char(77) No
execute_at datetime Yes NULL
interval_value int(11) Yes NULL
interval_field enum('YEAR', 'QUARTER', 'MONTH', 'DAY', 'HOUR', 'MINUTE', 'WEEK', 'SECOND', 'MICROSECOND', 'YEAR_MONTH', 'DAY_HOUR', 'DAY_MINUTE', 'DAY_SECOND', 'HOUR_MINUTE', 'HOUR_SECOND', 'MINUTE_SECOND', 'DAY_MICROSECOND', 'HOUR_MICROSECOND', 'MINUTE_MICROSECOND', 'SECOND_MICROSECOND') Yes NULL
created timestamp No CURRENT_TIMESTAMP
modified timestamp No 0000-00-00 00:00:00
last_executed datetime Yes NULL
starts datetime Yes NULL
ends datetime Yes NULL
status enum('ENABLED', 'DISABLED', 'SLAVESIDE_DISABLED') No ENABLED
on_completion enum('DROP', 'PRESERVE') No DROP
sql_mode set('REAL_AS_FLOAT', 'PIPES_AS_CONCAT', 'ANSI_QUOTES', 'IGNORE_SPACE', 'NOT_USED', 'ONLY_FULL_GROUP_BY', 'NO_UNSIGNED_SUBTRACTION', 'NO_DIR_IN_CREATE', 'POSTGRESQL', 'ORACLE', 'MSSQL', 'DB2', 'MAXDB', 'NO_KEY_OPTIONS', 'NO_TABLE_OPTIONS', 'NO_FIELD_OPTIONS', 'MYSQL323', 'MYSQL40', 'ANSI', 'NO_AUTO_VALUE_ON_ZERO', 'NO_BACKSLASH_ESCAPES', 'STRICT_TRANS_TABLES', 'STRICT_ALL_TABLES', 'NO_ZERO_IN_DATE', 'NO_ZERO_DATE', 'INVALID_DATES', 'ERROR_FOR_DIVISION_BY_ZERO', 'TRADITIONAL', 'NO_AUTO_CREATE_USER', 'HIGH_NOT_PRECEDENCE', 'NO_ENGINE_SUBSTITUTION', 'PAD_CHAR_TO_FULL_LENGTH') No
comment char(64) No
originator int(10) No
time_zone char(64) No SYSTEM
character_set_client char(32) Yes NULL
collation_connection char(32) Yes NULL
db_collation char(32) Yes NULL
body_utf8 longblob Yes NULL

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNodbANo
name0ANo

func

Table comments: User defined functions

Column Type Null Default Comments
name binary(64) No
ret tinyint(1) No 0
dl char(128) No
type enum('function', 'aggregate') No

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoname0ANo

general_log

Table comments: General log

Column Type Null Default Comments
event_time timestamp No CURRENT_TIMESTAMP
user_host mediumtext No
thread_id int(11) No
server_id int(10) No
command_type varchar(64) No
argument mediumtext No

help_category

Table comments: help categories

Column Type Null Default Comments
help_category_id smallint(5) No 0
name varchar(64) No
parent_category_id smallint(5) Yes NULL
url varchar(128) No

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNohelp_category_id0ANo
nameBTREEYesNoname0ANo

help_keyword

Table comments: help keywords

Column Type Null Default Comments
help_keyword_id int(10) No 0
name varchar(64) No

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNohelp_keyword_id0ANo
nameBTREEYesNoname0ANo

help_relation

Table comments: keyword-topic relation

Column Type Null Default Comments
help_topic_id int(10) No 0
help_keyword_id int(10) No 0

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNohelp_keyword_idANo
help_topic_id0ANo

help_topic

Table comments: help topics

Column Type Null Default Comments
help_topic_id int(10) No 0
name varchar(64) No
help_category_id smallint(5) No 0
description text No
example text No
url varchar(128) No

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNohelp_topic_id0ANo
nameBTREEYesNoname0ANo

host

Table comments: Host privileges; Merged with database privileges

Column Type Null Default Comments
Host char(60) No
Db char(64) 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
Trigger_priv enum('N', 'Y') No N

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoHostANo
Db0ANo

ndb_binlog_index

Column Type Null Default Comments
Position bigint(20) No
File varchar(255) No
epoch bigint(20) No
inserts bigint(20) No
updates bigint(20) No
deletes bigint(20) No
schemaops bigint(20) No

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoepoch0ANo

plugin

Table comments: MySQL plugins

Column Type Null Default Comments
name varchar(64) No
dl varchar(128) No

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoname0ANo

proc

Table comments: Stored Procedures

Column Type Null Default Comments
db char(64) No
name char(64) No
type enum('FUNCTION', 'PROCEDURE') No
specific_name char(64) No
language enum('SQL') No SQL
sql_data_access enum('CONTAINS_SQL', 'NO_SQL', 'READS_SQL_DATA', 'MODIFIES_SQL_DATA') No CONTAINS_SQL
is_deterministic enum('YES', 'NO') No NO
security_type enum('INVOKER', 'DEFINER') No DEFINER
param_list blob No
returns longblob No
body longblob No
definer char(77) No
created timestamp No CURRENT_TIMESTAMP
modified timestamp No 0000-00-00 00:00:00
sql_mode set('REAL_AS_FLOAT', 'PIPES_AS_CONCAT', 'ANSI_QUOTES', 'IGNORE_SPACE', 'NOT_USED', 'ONLY_FULL_GROUP_BY', 'NO_UNSIGNED_SUBTRACTION', 'NO_DIR_IN_CREATE', 'POSTGRESQL', 'ORACLE', 'MSSQL', 'DB2', 'MAXDB', 'NO_KEY_OPTIONS', 'NO_TABLE_OPTIONS', 'NO_FIELD_OPTIONS', 'MYSQL323', 'MYSQL40', 'ANSI', 'NO_AUTO_VALUE_ON_ZERO', 'NO_BACKSLASH_ESCAPES', 'STRICT_TRANS_TABLES', 'STRICT_ALL_TABLES', 'NO_ZERO_IN_DATE', 'NO_ZERO_DATE', 'INVALID_DATES', 'ERROR_FOR_DIVISION_BY_ZERO', 'TRADITIONAL', 'NO_AUTO_CREATE_USER', 'HIGH_NOT_PRECEDENCE', 'NO_ENGINE_SUBSTITUTION', 'PAD_CHAR_TO_FULL_LENGTH') No
comment text No
character_set_client char(32) Yes NULL
collation_connection char(32) Yes NULL
db_collation char(32) Yes NULL
body_utf8 longblob Yes NULL

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNodbANo
nameANo
type1ANo

procs_priv

Table comments: Procedure privileges

Column Type Null Default Comments
Host char(60) No
Db char(64) No
User char(16) No
Routine_name char(64) No
Routine_type enum('FUNCTION', 'PROCEDURE') No
Grantor char(77) No
Proc_priv set('Execute', 'Alter Routine', 'Grant') No
Timestamp timestamp No CURRENT_TIMESTAMP

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoHostANo
DbANo
UserANo
Routine_nameANo
Routine_type0ANo
GrantorBTREENoNoGrantorANo

proxies_priv

Table comments: User proxy privileges

Column Type Null Default Comments
Host char(60) No
User char(16) No
Proxied_host char(60) No
Proxied_user char(16) No
With_grant tinyint(1) No 0
Grantor char(77) No
Timestamp timestamp No CURRENT_TIMESTAMP

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoHostANo
UserANo
Proxied_hostANo
Proxied_user1ANo
GrantorBTREENoNoGrantor1ANo

servers

Table comments: MySQL Foreign Servers table

Column Type Null Default Comments
Server_name char(64) No
Host char(64) 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

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoServer_name0ANo

slow_log

Table comments: Slow log

Column Type Null Default Comments
start_time timestamp No CURRENT_TIMESTAMP
user_host mediumtext No
query_time time No
lock_time time 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 mediumtext No

tables_priv

Table comments: Table privileges

Column Type Null Default Comments
Host char(60) No
Db char(64) No
User char(16) No
Table_name char(64) No
Grantor char(77) 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

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoHostANo
DbANo
UserANo
Table_name4ANo
GrantorBTREENoNoGrantorANo

time_zone

Table comments: Time zones

Column Type Null Default Comments
Time_zone_id int(10) No
Use_leap_seconds enum('Y', 'N') No N

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoTime_zone_id1685ANo

time_zone_leap_second

Table comments: Leap seconds information for time zones

Column Type Null Default Comments
Transition_time bigint(20) No 0
Correction int(11) No 0

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoTransition_time0ANo

time_zone_name

Table comments: Time zone names

Column Type Null Default Comments
Name char(64) No
Time_zone_id int(10) No 0

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoName1685ANo

time_zone_transition

Table comments: Time zone transitions

Column Type Null Default Comments
Time_zone_id int(10) No 0
Transition_time bigint(20) No 0
Transition_type_id int(10) No 0

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoTime_zone_idANo
Transition_time117210ANo

time_zone_transition_type

Table comments: Time zone transition types

Column Type Null Default Comments
Time_zone_id int(10) No 0
Transition_type_id int(10) No 0
Offset int(11) No 0
Is_DST tinyint(3) No 0
Abbreviation char(8) No

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoTime_zone_idANo
Transition_type_id7716ANo

user

Table comments: Users and global privileges

Column Type Null Default Comments
Host char(60) No
User char(16) No
Password char(41) 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(60) No
authentication_string text No

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoHostANo
User5ANo