columns_priv
db
event
func
general_log
help_category
help_keyword
help_relation
help_topic
host
ndb_binlog_index
plugin
proc
procs_priv
servers
slow_log
tables_priv
time_zone
time_zone_leap_second
time_zone_name
time_zone_transition
time_zone_transition_type
user

columns_priv

Field	Type	Null	Key	Default	Extra
Host	char(60)	NO	PRI
Db	char(64)	NO	PRI
User	char(16)	NO	PRI
Table_name	char(64)	NO	PRI
Column_name	char(64)	NO	PRI
Timestamp	timestamp	NO		CURRENT_TIMESTAMP	on update CURRENT_TIMESTAMP
Column_priv	set('Select','Insert','Update','References')	NO

db

Field	Type	Null	Key	Default
Host	char(60)	NO	PRI
Db	char(64)	NO	PRI
User	char(16)	NO	PRI
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

event

Field	Type	Null	Key	Default	Extra
db	char(64)	NO	PRI
name	char(64)	NO	PRI
body	longblob	NO		NULL
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	on update 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) unsigned	NO		NULL
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

func

Field	Type	Null	Key	Default
name	char(64)	NO	PRI
ret	tinyint(1)	NO		0
dl	char(128)	NO
type	enum('function','aggregate')	NO		NULL

general_log

Field	Type	Null	Default	Extra
event_time	timestamp	NO	CURRENT_TIMESTAMP	on update CURRENT_TIMESTAMP
user_host	mediumtext	NO	NULL
thread_id	int(11)	NO	NULL
server_id	int(10) unsigned	NO	NULL
command_type	varchar(64)	NO	NULL
argument	mediumtext	NO	NULL

help_category

Field	Type	Null	Key	Default
help_category_id	smallint(5) unsigned	NO	PRI	NULL
name	char(64)	NO	UNI	NULL
parent_category_id	smallint(5) unsigned	YES		NULL
url	char(128)	NO		NULL

help_keyword

Field	Type	Null	Key	Default	Extra
help_keyword_id	int(10) unsigned	NO	PRI	NULL
name	char(64)	NO	UNI	NULL

help_relation

Field	Type	Null	Key	Default	Extra
help_topic_id	int(10) unsigned	NO	PRI	NULL
help_keyword_id	int(10) unsigned	NO	PRI	NULL

help_topic

Field	Type	Null	Key	Default
help_topic_id	int(10) unsigned	NO	PRI	NULL
name	char(64)	NO	UNI	NULL
help_category_id	smallint(5) unsigned	NO		NULL
description	text	NO		NULL
example	text	NO		NULL
url	char(128)	NO		NULL

host

Field	Type	Null	Key	Default
Host	char(60)	NO	PRI
Db	char(64)	NO	PRI
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

ndb_binlog_index

Field	Type	Null	Key	Default
Position	bigint(20) unsigned	NO		NULL
File	varchar(255)	NO		NULL
epoch	bigint(20) unsigned	NO	PRI	NULL
inserts	bigint(20) unsigned	NO		NULL
updates	bigint(20) unsigned	NO		NULL
deletes	bigint(20) unsigned	NO		NULL
schemaops	bigint(20) unsigned	NO		NULL

plugin

Field	Type	Null	Key	Default	Extra
name	char(64)	NO	PRI
dl	char(128)	NO

proc

Field	Type	Null	Key	Default	Extra
db	char(64)	NO	PRI
name	char(64)	NO	PRI
type	enum('FUNCTION','PROCEDURE')	NO	PRI	NULL
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		NULL
returns	longblob	NO		NULL
body	longblob	NO		NULL
definer	char(77)	NO
created	timestamp	NO		CURRENT_TIMESTAMP	on update 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	char(64)	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

procs_priv

Field	Type	Null	Key	Default	Extra
Host	char(60)	NO	PRI
Db	char(64)	NO	PRI
User	char(16)	NO	PRI
Routine_name	char(64)	NO	PRI
Routine_type	enum('FUNCTION','PROCEDURE')	NO	PRI	NULL
Grantor	char(77)	NO	MUL
Proc_priv	set('Execute','Alter Routine','Grant')	NO
Timestamp	timestamp	NO		CURRENT_TIMESTAMP	on update CURRENT_TIMESTAMP

servers

Field	Type	Null	Key	Default
Server_name	char(64)	NO	PRI
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

slow_log

Field	Type	Null	Default	Extra
start_time	timestamp	NO	CURRENT_TIMESTAMP	on update CURRENT_TIMESTAMP
user_host	mediumtext	NO	NULL
query_time	time	NO	NULL
lock_time	time	NO	NULL
rows_sent	int(11)	NO	NULL
rows_examined	int(11)	NO	NULL
db	varchar(512)	NO	NULL
last_insert_id	int(11)	NO	NULL
insert_id	int(11)	NO	NULL
server_id	int(10) unsigned	NO	NULL
sql_text	mediumtext	NO	NULL

tables_priv

Field	Type	Null	Key	Default	Extra
Host	char(60)	NO	PRI
Db	char(64)	NO	PRI
User	char(16)	NO	PRI
Table_name	char(64)	NO	PRI
Grantor	char(77)	NO	MUL
Timestamp	timestamp	NO		CURRENT_TIMESTAMP	on update 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

time_zone

Field	Type	Null	Key	Default	Extra
Time_zone_id	int(10) unsigned	NO	PRI	NULL	auto_increment
Use_leap_seconds	enum('Y','N')	NO		N

time_zone_leap_second

Field	Type	Null	Key	Default	Extra
Transition_time	bigint(20)	NO	PRI	NULL
Correction	int(11)	NO		NULL

time_zone_name

Field	Type	Null	Key	Default	Extra
Name	char(64)	NO	PRI	NULL
Time_zone_id	int(10) unsigned	NO		NULL

time_zone_transition

Field	Type	Null	Key	Default
Time_zone_id	int(10) unsigned	NO	PRI	NULL
Transition_time	bigint(20)	NO	PRI	NULL
Transition_type_id	int(10) unsigned	NO		NULL

time_zone_transition_type

Field	Type	Null	Key	Default
Time_zone_id	int(10) unsigned	NO	PRI	NULL
Transition_type_id	int(10) unsigned	NO	PRI	NULL
Offset	int(11)	NO		0
Is_DST	tinyint(3) unsigned	NO		0
Abbreviation	char(8)	NO

user

Field	Type	Null	Key	Default
Host	char(60)	NO	PRI
User	char(16)	NO	PRI
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
ssl_type	enum('','ANY','X509','SPECIFIED')	NO
ssl_cipher	blob	NO		NULL
x509_issuer	blob	NO		NULL
x509_subject	blob	NO		NULL
max_questions	int(11) unsigned	NO		0
max_updates	int(11) unsigned	NO		0
max_connections	int(11) unsigned	NO		0
max_user_connections	int(11) unsigned	NO		0